After running RU6 to AX 2009, the FBI process stops working

Symptoms

After running RU6 to AX 2009, the FBI process stops working and in the event viewer the following error message appears:

Description:

Object Server 01: The database reported (session 47 (Admin)): [Microsoft][SQL Native Client][SQL Server]Cannot insert explicit value for identity column in table
'TBGL_IMPORT_AGENDAMENTO' when IDENTITY_INSERT is set to OFF.. The SQL statement was: "
    INSERT INTO [TBGL_IMPORT_AGENDAMENTO]
           ([COD_AGENDAMENTO]
           ,[DES_AGENDAMENTO]
           ,[COD_PERIODICIDADE]
           ,[DAT_INICIAL_VIGENCIA]
           ,[DAT_FINAL_VIGENCIA]
           ,[HOR_INICIAL_VIGENCIA]
           ,[COD_STATUS])
     VALUES
           (137                                  -- COD_AGENDAMENTO
           ,'FBI_nf_SAIDA'                                -- DES_AGENDAMENTO
           ,0                                   -- COD_PERIODICIDADE
           ,'2010-11-23T00:00:00'                                -- DAT_INICIAL_VIGENCIA
           ,'2010-11-23T23:59:59'                                -- DAT_FINAL_VIGENCIA
           ,convert(char(8), getdate(), 108)    -- HOR_INICIAL_VIGENCIA
           ,'1'                                 -- COD_STATUS -> Importação ativa
            ) "

↑ Back to the top

Cause

When the FBI environment is already in version 3.2, the update process related to RU6 understands that the FBI environment is already updated and doesn't run the necessary updates in the intermediary database "AX_SOFTTEAM".

↑ Back to the top

Resolution

Create a job with the code below and run it. After this, the problem is solved.

-------------------------------------------------------------------------------------------------
static void recreateFBIScripts(Args _args)
{
    FBISchemaCreator_BR fbiSchemaCreator;
    ;

    fbiSchemaCreator = FBISchemaCreator_BR::constructForExecutor(
        new FBISqlExecutor_BR(
            // this call gets all connection info for the current company
            FBIDatabaseConnectionFactory_BR::returnFBIDatabaseConnection())
        );

    fbiSchemaCreator.createSchema();

info('Database Atualizada');

    pause;
}
-------------------------------------------------------------------------------------------------

↑ Back to the top

Keywords: kbmbspartner, kbmbsmigrate, kbsurveynew, kb

↑ Back to the top

Article Info

Article ID	:	2474911
Revision	:	1
Created on	:	1/7/2017
Published on	:	8/5/2011
Exists online	:	False
Views	:	103

Microsoft KB Archive Search

After running RU6 to AX 2009, the FBI process stops working

Symptoms

Cause

Resolution