Whenever running classes->SysDatabaseTransDelete Class in Ax2012 R2 with kernal and application version's-'6.2.1000.156'

Finance and Operations/AX Developer Forum
1

Hi All,

Could any one explain about the below error:

Cannot execute a data definition language command on ().The SQL database has issued an error.

SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]The operation failed because an index or statistics with name ‘i100656_60001_601570D5FEEA47979EB223DA84410601’ already exists on table ‘tempdb.DBO.t100656_601570D5FEEA47979EB223DA84410601’.

SQL statement: CREATE INDEX i100656_60001_601570D5FEEA47979EB223DA84410601 ON tempdb.“DBO”.t100656_601570D5FEEA47979EB223DA84410601 (DATAAREAID,PARTITION,INSTANCERELATIONTYPE) WHERE INSTANCERELATIONTYPE IN ( 100654 )

Event Viewer Id - 117.

Thanks…!

2

it is synchronization problem , first you u need to logoff all the client connected to your AOS , SO need to restart the aos and start the operation .

even though you are facing the error , synchronize the data dictionary and run the class again.