Post reply

Could not find database ID 8. Database may not be activated yet or may be in transition. [SQLSTATE 42000] (Error 913).The step failed.

  • July 9, 2008 at 7:08 am

    #75256

    9:00 AM

    I have two SQL 2000 boxes.

    SQL job runs on the Box 1 (SP3)

    and uses a linked server to Box 2 (SP4).

    Yesterday the databases on Box 2 referenced in that job

    were backed up and restored.

    The job ran OK before yesterday Restore.

    This morning it failed with the error:

    Could not find database ID 8. Database may not be activated yet or may be in transition. [SQLSTATE 42000] (Error 913). The step failed.

    I read http://support.microsoft.com/kb/316541

    and it looks like a bug that can be fixed by SP4.

    Is this true?

    10:12 AM

    The interesting thing is the problem seems to be

    just with one "Import_Log" table.

    SELECT/DELETE work.

    Only INSERT

    insert [LinkedServ].vsImport.dbo.Import_log(message)

    values('Msg 913')

    fails. With the same error

    Could not find database ID 8...

    Locally on Box 2 INSERT works.

    It only fails from Box 1 using linked server 4 part query.

    I checked sysdatabases table in master

    and there is no dbid 8.

    vsImport is under dbid 5.

  • July 9, 2008 at 8:55 am

    #840220

    The issue is fixed.

    I changed Default database

    for "niadetl" SQL Server Login on Box 2 which is used to register Linked Server on Box 1.

    Now it's "master".

  • July 9, 2008 at 9:06 am

    #840244

    Thanks for the update.

  • July 9, 2008 at 11:49 am

    #840423

    Actually the story continues.

    Now one of next steps of that SQL Job (SSIS package) fails

    with the same error

    [Execute SQL Task] Error: Executing the query "insert vsImport.dbo.Import_log(message,[Table],[time]) values('Niad.dtsx started','Dundee-Custom-Entry',getdate())" failed with the following error: "Could not find database ID 8. Database may not be activated yet or may be in transition."

    Again Import_Log table!

    I ran this INSERT statement on Box 2 locally. Works.

    From Box 1, using linked server. Works.

    It only fails in SSIS. SSIS is using ConnectionManager with the same "niadetl" Login

    and "Test Connection" is successful from SSIS.

    Something inside SSIS was not refreshed after I changed "niadetl" Login?

    Should I delete Connection and create it again?

  • January 7, 2016 at 3:42 pm

    #1850372

    Did you ever a resolution?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply