web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Re-Index Problems on V...
Microsoft Dynamics AX (Archived)

Re-Index Problems on Views and Temp Tables

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I am running Ax2012 RTM and having below re-index error when running Re-index action for All tables from Ax SQL Administration option. We notice that most of the error is due to system try to create index on View or Temp tables. There is no problem on permission from Ax to SQL. Is there any one encountered the similar problem before and have a solution on it? Your advises is highly appreciated. Thank you.

Message (03:23:12 pm)
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]Cannot find the object "DBO.TMPLEDGERCONSTRANS" because it does not exist or you do not have permissions.
SQL statement: CREATE UNIQUE INDEX I_466ACCOUNTDATEIDX ON "DBO".TMPLEDGERCONSTRANS (MAINACCOUNTID,DIMENSIONHIERARCHY,TRANSDATE,PERIODCODE,CURRENCYCODE,CREDITING,OPERATIONSTAX,HASH,TMPDATAAREAID,ACKNOWLEDGEMENTDATE)
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]Cannot drop index 'I_505RECID' because it enforces the full-text key for table or indexed view 'VENDTABLE'.
SQL statement: DROP INDEX VENDTABLE.I_505RECID
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 'I_505YOURACCOUNTNUMIDX' already exists on table 'DBO.VENDTABLE'.
SQL statement: CREATE INDEX I_505YOURACCOUNTNUMIDX ON "DBO".VENDTABLE (DATAAREAID,YOURACCOUNTNUM)
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]Cannot find the object "DBO.TMPINVENTAGE" because it does not exist or you do not have permissions.
SQL statement: CREATE CLUSTERED INDEX I_880ITEMGROUPIDX ON "DBO".TMPINVENTAGE (DATAAREAID,ITEMGROUPID,ITEMID)
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]Cannot find the object "DBO.INVENTRELEASEORDERPICKINGTMP" because it does not exist or you do not have permissions.
SQL statement: CREATE CLUSTERED INDEX I_1102ORDERIDX ON "DBO".INVENTRELEASEORDERPICKINGTMP (DATAAREAID,ORDERID,TRANSRECID)
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]Cannot find the object "DBO.TMPLEDGERCONSQUERY" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".TMPLEDGERCONSQUERY ADD CONSTRAINT I_1691ACCOUNTNUMIDX PRIMARY KEY CLUSTERED (DATAAREAID,MAINACCOUNTID)
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]Cannot find the object "DBO.PRICEDISCTMPPRINTOUT" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".PRICEDISCTMPPRINTOUT ADD CONSTRAINT I_2020RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot drop index 'I_2303RECID' because it enforces the full-text key for table or indexed view 'DIRPARTYTABLE'.
SQL statement: ALTER TABLE DIRPARTYTABLE DROP CONSTRAINT I_2303RECID
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]Table 'DIRPARTYTABLE' already has a primary key defined on it.
SQL statement: ALTER TABLE "DBO".DIRPARTYTABLE ADD CONSTRAINT I_2303RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.CUSTSTATEMENTDIRTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".CUSTSTATEMENTDIRTMP ADD CONSTRAINT I_2369PARTYIDIDX PRIMARY KEY CLUSTERED (TIMESTAMP,PARTY)
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]Cannot drop index 'I_2588RECID' because it enforces the full-text key for table or indexed view 'CATEXTERNALCATALOG'.
SQL statement: ALTER TABLE CATEXTERNALCATALOG DROP CONSTRAINT I_2588RECID
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]Table 'CATEXTERNALCATALOG' already has a primary key defined on it.
SQL statement: ALTER TABLE "DBO".CATEXTERNALCATALOG ADD CONSTRAINT I_2588RECID PRIMARY KEY NONCLUSTERED (RECID)
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]Cannot drop index 'I_2606RECID' because it enforces the full-text key for table or indexed view 'CATEXTERNALCATALOGCATEGORIES'.
SQL statement: ALTER TABLE CATEXTERNALCATALOGCATEGORIES DROP CONSTRAINT I_2606RECID
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]Table 'CATEXTERNALCATALOGCATEGORIES' already has a primary key defined on it.
SQL statement: ALTER TABLE "DBO".CATEXTERNALCATALOGCATEGORIES ADD CONSTRAINT I_2606RECID PRIMARY KEY NONCLUSTERED (RECID)
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]Cannot drop index 'I_2830RECID' because it enforces the full-text key for table or indexed view 'CATDISPLAYCATEGORYTABLE'.
SQL statement: ALTER TABLE CATDISPLAYCATEGORYTABLE DROP CONSTRAINT I_2830RECID
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]Table 'CATDISPLAYCATEGORYTABLE' already has a primary key defined on it.
SQL statement: ALTER TABLE "DBO".CATDISPLAYCATEGORYTABLE ADD CONSTRAINT I_2830RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot drop index 'I_4350RECID' because it enforces the full-text key for table or indexed view 'ECORESTEXTVALUE'.
SQL statement: ALTER TABLE ECORESTEXTVALUE DROP CONSTRAINT I_4350RECID
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]Table 'ECORESTEXTVALUE' already has a primary key defined on it.
SQL statement: ALTER TABLE "DBO".ECORESTEXTVALUE ADD CONSTRAINT I_4350RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot drop index 'I_4351RECID' because it enforces the full-text key for table or indexed view 'ECORESTEXTVALUETRANSLATION'.
SQL statement: ALTER TABLE ECORESTEXTVALUETRANSLATION DROP CONSTRAINT I_4351RECID
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]Table 'ECORESTEXTVALUETRANSLATION' already has a primary key defined on it.
SQL statement: ALTER TABLE "DBO".ECORESTEXTVALUETRANSLATION ADD CONSTRAINT I_4351RECID PRIMARY KEY NONCLUSTERED (RECID)
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]Cannot drop index 'I_4593RECID' because it enforces the full-text key for table or indexed view 'ECORESCATEGORYTRANSLATION'.
SQL statement: ALTER TABLE ECORESCATEGORYTRANSLATION DROP CONSTRAINT I_4593RECID
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]Table 'ECORESCATEGORYTRANSLATION' already has a primary key defined on it.
SQL statement: ALTER TABLE "DBO".ECORESCATEGORYTRANSLATION ADD CONSTRAINT I_4593RECID PRIMARY KEY NONCLUSTERED (RECID)
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]Cannot find the object "DBO.INVENTAGEGROUPDIMTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".INVENTAGEGROUPDIMTMP ADD CONSTRAINT I_5817RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.LEDGERPOSTINGJOURNALTOTALTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".LEDGERPOSTINGJOURNALTOTALTMP ADD CONSTRAINT I_5840RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.MARKUPTMPMAXAMOUNTVALIDATION" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".MARKUPTMPMAXAMOUNTVALIDATION ADD CONSTRAINT I_6185RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.INVENTPRICEOVERVIEWTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".INVENTPRICEOVERVIEWTMP ADD CONSTRAINT I_6209RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.MARKUPTMPALLOCATION" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".MARKUPTMPALLOCATION ADD CONSTRAINT I_6474RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot drop index 'I_6648RECID' because it enforces the full-text key for table or indexed view 'CATDISPLAYCATEGORYTRANSLATION'.
SQL statement: ALTER TABLE CATDISPLAYCATEGORYTRANSLATION DROP CONSTRAINT I_6648RECID
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]Table 'CATDISPLAYCATEGORYTRANSLATION' already has a primary key defined on it.
SQL statement: ALTER TABLE "DBO".CATDISPLAYCATEGORYTRANSLATION ADD CONSTRAINT I_6648RECID PRIMARY KEY NONCLUSTERED (RECID)
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]Cannot drop index 'I_6650RECID' because it enforces the full-text key for table or indexed view 'CATDISPLAYSHAREDDATATRANSLATION'.
SQL statement: ALTER TABLE CATDISPLAYSHAREDDATATRANSLATION DROP CONSTRAINT I_6650RECID
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 'I_6650SHAREDDATALANGUAGEIDX' already exists on table 'DBO.CATDISPLAYSHAREDDATATRANSLATION'.
SQL statement: CREATE UNIQUE CLUSTERED INDEX I_6650SHAREDDATALANGUAGEIDX ON "DBO".CATDISPLAYSHAREDDATATRANSLATION (SHAREDDATA,LANGUAGEID)
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]Cannot drop index 'I_6869RECID' because it enforces the full-text key for table or indexed view 'ECORESPRODUCTTRANSLATION'.
SQL statement: ALTER TABLE ECORESPRODUCTTRANSLATION DROP CONSTRAINT I_6869RECID
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]Table 'ECORESPRODUCTTRANSLATION' already has a primary key defined on it.
SQL statement: ALTER TABLE "DBO".ECORESPRODUCTTRANSLATION ADD CONSTRAINT I_6869RECID PRIMARY KEY NONCLUSTERED (RECID)
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]Cannot drop index 'I_6942RECID' because it enforces the full-text key for table or indexed view 'CATEXTERNALCATALOGTRANSLATION'.
SQL statement: ALTER TABLE CATEXTERNALCATALOGTRANSLATION DROP CONSTRAINT I_6942RECID
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]Table 'CATEXTERNALCATALOGTRANSLATION' already has a primary key defined on it.
SQL statement: ALTER TABLE "DBO".CATEXTERNALCATALOGTRANSLATION ADD CONSTRAINT I_6942RECID PRIMARY KEY NONCLUSTERED (RECID)
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]Cannot find the object "DBO.INDIRECTCOSTOVERVIEWTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".INDIRECTCOSTOVERVIEWTMP ADD CONSTRAINT I_6984RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.TRADETMPLINERENUMBERING" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".TRADETMPLINERENUMBERING ADD CONSTRAINT I_7027RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.SUBLEDGERJOURNALACCOUNTENTRYTMPDETAIL" because it does not exist or you do not have permissions.
SQL statement: CREATE CLUSTERED INDEX I_7461SUBLEDGERJOURNALENTRY ON "DBO".SUBLEDGERJOURNALACCOUNTENTRYTMPDETAIL (SUBLEDGERJOURNALENTRY)
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]Cannot find the object "DBO.SUBLEDGERJOURNALACCOUNTENTRYTMPSUMMARY" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".SUBLEDGERJOURNALACCOUNTENTRYTMPSUMMARY ADD CONSTRAINT I_7462RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.AGREEMENTFOLLOWUPTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".AGREEMENTFOLLOWUPTMP ADD CONSTRAINT I_7548RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.TMPNUMBERSEQ" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".TMPNUMBERSEQ ADD CONSTRAINT I_7679RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.SECURITYUSERROLEDBTEMPTABLE" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".SECURITYUSERROLEDBTEMPTABLE ADD CONSTRAINT I_7807RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.DIMENSIONFOCUSBALANCETMP" because it does not exist or you do not have permissions.
SQL statement: CREATE UNIQUE INDEX I_7931BALANCEQUERYIDX ON "DBO".DIMENSIONFOCUSBALANCETMP (GENERALJOURNALENTRY,LEDGER,FOCUSLEDGERDIMENSION,POSTINGLAYER,FISCALPERIODTYPE,ACCOUNTINGDATE,ISSYSTEMGENERATEDULTIMO,ISCREDIT)
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]Cannot find the object "DBO.TRADENONSTOCKEDCONVERSIONTMPCOMPANIES" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".TRADENONSTOCKEDCONVERSIONTMPCOMPANIES ADD CONSTRAINT I_7941RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.SALESLINESEXTENDEDTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".SALESLINESEXTENDEDTMP ADD CONSTRAINT I_10044RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.INVENTCHECKRECEIPTCOSTPRICEPCSTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".INVENTCHECKRECEIPTCOSTPRICEPCSTMP ADD CONSTRAINT I_10222RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.INVENTSUMDATETRANSREPORT" because it does not exist or you do not have permissions.
SQL statement: CREATE CLUSTERED INDEX I_10271ITEMDIMIDX ON "DBO".INVENTSUMDATETRANSREPORT (DATAAREAID,ITEMID,INVENTDIMID)
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]Cannot find the object "DBO.RETURNACKNOWLEDGMENTANDDOCUMENTTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".RETURNACKNOWLEDGMENTANDDOCUMENTTMP ADD CONSTRAINT I_10351RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.COSREPORTPRINTTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".COSREPORTPRINTTMP ADD CONSTRAINT I_10473RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.SYSCOMPANYSIZETMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".SYSCOMPANYSIZETMP ADD CONSTRAINT I_10477RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.CUSTVENDTRANSAGING" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".CUSTVENDTRANSAGING ADD CONSTRAINT I_12143RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.ACCOUNTINGDISTRIBUTIONEVENTTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".ACCOUNTINGDISTRIBUTIONEVENTTMP ADD CONSTRAINT I_100001RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.ACCOUNTINGDISTRIBUTIONTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".ACCOUNTINGDISTRIBUTIONTMP ADD CONSTRAINT I_100002RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.ACCOUNTINGDISTRIBUTIONTMPJOURNALIZE" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".ACCOUNTINGDISTRIBUTIONTMPJOURNALIZE ADD CONSTRAINT I_100003RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.ACCOUNTINGEVENTDATETMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".ACCOUNTINGEVENTDATETMP ADD CONSTRAINT I_100004RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.ACCOUNTINGEVENTTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".ACCOUNTINGEVENTTMP ADD CONSTRAINT I_100005RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.AIFCHANGETRACKINGTABLE" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".AIFCHANGETRACKINGTABLE ADD CONSTRAINT I_100010RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.ASSETSTATEMENTFIXEDASSETSTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".ASSETSTATEMENTFIXEDASSETSTMP ADD CONSTRAINT I_100023RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.COSCALCULATIONREPORTTMPLINE" because it does not exist or you do not have permissions.
SQL statement: CREATE UNIQUE CLUSTERED INDEX I_100045INDEXIDX ON "DBO".COSCALCULATIONREPORTTMPLINE (DATAAREAID,DIVISIONID,COSTDIMENSIONNAME,COSTDIMENSIONVALUE,LINETYPE,LINENAME,DEBITCREDIT)
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]Cannot find the object "DBO.DIMENSIONSYNCHRONIZE" because it does not exist or you do not have permissions.
SQL statement: CREATE CLUSTERED INDEX I_100059ORIGINALDIMATTRVALUECOMBINATION1 ON "DBO".DIMENSIONSYNCHRONIZE (ORIGINALLEDGERDIMENSION)
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]Cannot find the object "DBO.DIMENSIONSYNCHRONIZEACCOUNTSTRUCTURE" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".DIMENSIONSYNCHRONIZEACCOUNTSTRUCTURE ADD CONSTRAINT I_100060RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.DIMENSIONSYNCHRONIZELEDGER" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".DIMENSIONSYNCHRONIZELEDGER ADD CONSTRAINT I_100061RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.GENERALJOURNALACCOUNTENTRYTMP" because it does not exist or you do not have permissions.
SQL statement: CREATE CLUSTERED INDEX I_100098GENERALJOURNALENTRYIDX ON "DBO".GENERALJOURNALACCOUNTENTRYTMP (DATAAREAID,GENERALJOURNALENTRY)
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]Cannot find the object "DBO.GENERALJOURNALENTRYTMP" because it does not exist or you do not have permissions.
SQL statement: CREATE CLUSTERED INDEX I_100099GENERALJOURNALENTRYIDX ON "DBO".GENERALJOURNALENTRYTMP (DATAAREAID,GENERALJOURNALENTRY)
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]Cannot find the object "DBO.HCMMYDEPARTMENTS" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".HCMMYDEPARTMENTS ADD CONSTRAINT I_100109RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.HCMMYDEPARTMENTSNOACCESS" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".HCMMYDEPARTMENTSNOACCESS ADD CONSTRAINT I_100110RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.HCMMYPERSONALCONTACTSNOACCESS" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".HCMMYPERSONALCONTACTSNOACCESS ADD CONSTRAINT I_100111RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.INTERCOMPANYGOODSINTRANSITLINETOTALSTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".INTERCOMPANYGOODSINTRANSITLINETOTALSTMP ADD CONSTRAINT I_100118RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.INTERCOMPANYGOODSINTRANSITORDERSTMP" because it does not exist or you do not have permissions.
SQL statement: CREATE UNIQUE CLUSTERED INDEX I_100119PURCHIDX ON "DBO".INTERCOMPANYGOODSINTRANSITORDERSTMP (PURCHID)
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]Cannot find the object "DBO.INTERCOMPANYGOODSINTRANSITTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".INTERCOMPANYGOODSINTRANSITTMP ADD CONSTRAINT I_100120RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.INVENTCOSTTMPITEMFINANCIALINVENTDIM" because it does not exist or you do not have permissions.
SQL statement: CREATE CLUSTERED INDEX I_100122INVENTDIMFIXEDIDX ON "DBO".INVENTCOSTTMPITEMFINANCIALINVENTDIM (DATAAREAID,FINANCIALINVENTDIMFIXED)
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]Cannot find the object "DBO.INVENTLEDGERCONFLICTTMPCONFLICTTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".INVENTLEDGERCONFLICTTMPCONFLICTTMP ADD CONSTRAINT I_100123RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.INVENTTESTUPDATEDQUANTITYTMP" because it does not exist or you do not have permissions.
SQL statement: CREATE UNIQUE CLUSTERED INDEX I_100126INVENTDIMIDX ON "DBO".INVENTTESTUPDATEDQUANTITYTMP (DATAAREAID,INVENTDIMID)
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]Cannot find the object "DBO.MYADDRESSBOOK" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".MYADDRESSBOOK ADD CONSTRAINT I_100137RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.MYADDRESSBOOKFORXDS" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".MYADDRESSBOOKFORXDS ADD CONSTRAINT I_100138RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.MYDEPARTMENTS" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".MYDEPARTMENTS ADD CONSTRAINT I_100139RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.MYDIRECTREPORTS" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".MYDIRECTREPORTS ADD CONSTRAINT I_100140RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.MYLEGALENTITIES" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".MYLEGALENTITIES ADD CONSTRAINT I_100141RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.MYLEGALENTITIESFORNS" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".MYLEGALENTITIESFORNS ADD CONSTRAINT I_100142RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.MYLEGALENTITIESFORXDS" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".MYLEGALENTITIESFORXDS ADD CONSTRAINT I_100143RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.MYLEGALENTITYFORWORKER" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".MYLEGALENTITYFORWORKER ADD CONSTRAINT I_100144RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.MYROLES" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".MYROLES ADD CONSTRAINT I_100145RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.PRICEDISCSALESLINETMPPRINTOUT" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".PRICEDISCSALESLINETMPPRINTOUT ADD CONSTRAINT I_100153RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.PRICEDISCSALESMULTILINETMPPRINTOUT" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".PRICEDISCSALESMULTILINETMPPRINTOUT ADD CONSTRAINT I_100154RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.PRICEDISCSALESTOTALTMPPRINTOUT" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".PRICEDISCSALESTOTALTMPPRINTOUT ADD CONSTRAINT I_100155RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.PRODFINISHGOODSINPROGRESSTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".PRODFINISHGOODSINPROGRESSTMP ADD CONSTRAINT I_100156RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.PURCHLINEMARKTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".PURCHLINEMARKTMP ADD CONSTRAINT I_100161RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.PURCHRECEIPTSLISTTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".PURCHRECEIPTSLISTTMP ADD CONSTRAINT I_100166RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.PURCHTABLEMARKTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".PURCHTABLEMARKTMP ADD CONSTRAINT I_100172RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.SOURCEDOCUMENTLINEITEMTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".SOURCEDOCUMENTLINEITEMTMP ADD CONSTRAINT I_100200RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.SOURCEDOCUMENTLINETMPJOURNALIZE" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".SOURCEDOCUMENTLINETMPJOURNALIZE ADD CONSTRAINT I_100204SOURCEDOCUMENTLINEIDX PRIMARY KEY CLUSTERED (SOURCEDOCUMENTLINE)
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]Cannot find the object "DBO.SYSCOMPILEILPROJECTTMP" because it does not exist or you do not have permissions.
SQL statement: CREATE UNIQUE CLUSTERED INDEX I_100215PRIMARY ON "DBO".SYSCOMPILEILPROJECTTMP (ELEMENTTYPE,AXID)
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]Cannot find the object "DBO.SYSSECROLEENTRYPOINTSTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".SYSSECROLEENTRYPOINTSTMP ADD CONSTRAINT I_100232RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.SYSSECURITYUSERROLECONDITIONTEMP" because it does not exist or you do not have permissions.
SQL statement: CREATE CLUSTERED INDEX I_100233SECURITYUSERROLEIDX ON "DBO".SYSSECURITYUSERROLECONDITIONTEMP (SECURITYUSERROLE)
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]Cannot find the object "DBO.SYSUSERLICENSECOUNTTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".SYSUSERLICENSECOUNTTMP ADD CONSTRAINT I_100237RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.SYSUSERLICENSEMETADATATMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".SYSUSERLICENSEMETADATATMP ADD CONSTRAINT I_100238RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.SYSUSERROLEEFFECTIVELICENSETYPETMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".SYSUSERROLEEFFECTIVELICENSETYPETMP ADD CONSTRAINT I_100239RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.INVENTDIMTMP" because it does not exist or you do not have permissions.
SQL statement: CREATE UNIQUE CLUSTERED INDEX I_100419INDEX1 ON "DBO".INVENTDIMTMP (DATAAREAID,STORE,VARIANTID,INVENTSERIALID,ITEMID,INVENTBATCHID)
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]Cannot find the object "DBO.INVENTTRANSTMPORIGINKEYVALUETRANSFER" because it does not exist or you do not have permissions.
SQL statement: CREATE UNIQUE CLUSTERED INDEX I_100421FROMINVENTTRANSORIGINIDX ON "DBO".INVENTTRANSTMPORIGINKEYVALUETRANSFER (FROMINVENTTRANSORIGIN)
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]Cannot find the object "DBO.RETAILCONNPREACTIONWORKTABLETMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".RETAILCONNPREACTIONWORKTABLETMP ADD CONSTRAINT I_100481RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.RETAILCONNSCRECIDKEYTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".RETAILCONNSCRECIDKEYTMP ADD CONSTRAINT I_100486RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.RETAILCOSTAMOUNTTMP" because it does not exist or you do not have permissions.
SQL statement: CREATE UNIQUE CLUSTERED INDEX I_100487INDEX1 ON "DBO".RETAILCOSTAMOUNTTMP (DATAAREAID,ITEMID)
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]Cannot find the object "DBO.RETAILDEFAULTDIMENSIONTMP" because it does not exist or you do not have permissions.
SQL statement: CREATE UNIQUE CLUSTERED INDEX I_100488INDEX1 ON "DBO".RETAILDEFAULTDIMENSIONTMP (DATAAREAID,CUSTACCOUNT,TERMINALID,STORE,STAFFID)
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]Cannot find the object "DBO.RETAILPOSBATCHACCOUNTTRANSX" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".RETAILPOSBATCHACCOUNTTRANSX ADD CONSTRAINT I_100514RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.RETAILPOSBATCHTABLEX" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".RETAILPOSBATCHTABLEX ADD CONSTRAINT I_100515RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.RETAILPOSBATCHTENDERTRANSX" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".RETAILPOSBATCHTENDERTRANSX ADD CONSTRAINT I_100516RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.RETAILTRANSACTIONBANKEDTENDERTRANSX" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".RETAILTRANSACTIONBANKEDTENDERTRANSX ADD CONSTRAINT I_100531RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.RETAILTRANSACTIONDISCOUNTTRANSX" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".RETAILTRANSACTIONDISCOUNTTRANSX ADD CONSTRAINT I_100533RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.RETAILTRANSACTIONINCOMEEXPENSETRANSX" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".RETAILTRANSACTIONINCOMEEXPENSETRANSX ADD CONSTRAINT I_100534RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.RETAILTRANSACTIONINFOCODETRANSX" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".RETAILTRANSACTIONINFOCODETRANSX ADD CONSTRAINT I_100535RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.RETAILTRANSACTIONLOYALTYPOINTSTRANSX" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".RETAILTRANSACTIONLOYALTYPOINTSTRANSX ADD CONSTRAINT I_100536RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.RETAILTRANSACTIONORDERINVOICETRANSX" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".RETAILTRANSACTIONORDERINVOICETRANSX ADD CONSTRAINT I_100537RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.RETAILTRANSACTIONPAYMENTTRANSTMP" because it does not exist or you do not have permissions.
SQL statement: CREATE CLUSTERED INDEX I_100538TRANSACTIONLINEIDX ON "DBO".RETAILTRANSACTIONPAYMENTTRANSTMP (DATAAREAID,STORE,TERMINAL,TRANSACTIONID,LINENUM)
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]Cannot find the object "DBO.RETAILTRANSACTIONPAYMENTTRANSX" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".RETAILTRANSACTIONPAYMENTTRANSX ADD CONSTRAINT I_100539RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.RETAILTRANSACTIONSAFETENDERTRANSX" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".RETAILTRANSACTIONSAFETENDERTRANSX ADD CONSTRAINT I_100540RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.RETAILTRANSACTIONSALESTRANSTMP" because it does not exist or you do not have permissions.
SQL statement: CREATE CLUSTERED INDEX I_100541TRANSACTIONLINEIDX ON "DBO".RETAILTRANSACTIONSALESTRANSTMP (DATAAREAID,STORE,TERMINALID,TRANSACTIONID,LINENUM)
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]Cannot find the object "DBO.RETAILTRANSACTIONSALESTRANSX" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".RETAILTRANSACTIONSALESTRANSX ADD CONSTRAINT I_100542RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.RETAILTRANSACTIONTABLEX" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".RETAILTRANSACTIONTABLEX ADD CONSTRAINT I_100543RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.RETAILTRANSACTIONTAXTRANSX" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".RETAILTRANSACTIONTAXTRANSX ADD CONSTRAINT I_100544RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.RETAILTRANSACTIONTENDERDECLARATIONTRANSX" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".RETAILTRANSACTIONTENDERDECLARATIONTRANSX ADD CONSTRAINT I_100545RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.RETAILTRANSACTIONTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".RETAILTRANSACTIONTMP ADD CONSTRAINT I_100546RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.RETAILTRANSCODETMP" because it does not exist or you do not have permissions.
SQL statement: CREATE UNIQUE CLUSTERED INDEX I_100547INDEX1 ON "DBO".RETAILTRANSCODETMP (DATAAREAID,BARCODE,ITEMID)
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]Cannot find the object "DBO.PURCHLINETMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".PURCHLINETMP ADD CONSTRAINT I_100934RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.VENDINVJOURTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".VENDINVJOURTMP ADD CONSTRAINT I_100966RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.CUSTOMERPAYMENTTRANSTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".CUSTOMERPAYMENTTRANSTMP ADD CONSTRAINT I_100992RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.LEDGERTRANSACCOUNTTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".LEDGERTRANSACCOUNTTMP ADD CONSTRAINT I_101075RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.DIMENSIONFOCUSNAMETMP" because it does not exist or you do not have permissions.
SQL statement: CREATE CLUSTERED INDEX I_101192LEDGERDIMIDX ON "DBO".DIMENSIONFOCUSNAMETMP (LEDGERDIMENSION)
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]Cannot find the object "DBO.LEDGERTRANSSTATEMENTOFFSETACCOUNTTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".LEDGERTRANSSTATEMENTOFFSETACCOUNTTMP ADD CONSTRAINT I_101194RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.LEDGERTRANSSTATEMENTTMPACCUMULATED" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".LEDGERTRANSSTATEMENTTMPACCUMULATED ADD CONSTRAINT I_101195RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.LEDGERTRIALBALANCELISTPAGETMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".LEDGERTRIALBALANCELISTPAGETMP ADD CONSTRAINT I_101196RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.LEDGERTRIALBALANCETMPACCUMULATED" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".LEDGERTRIALBALANCETMPACCUMULATED ADD CONSTRAINT I_101197RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.LEDGERTRIALBALANCETMPFOCUS" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".LEDGERTRIALBALANCETMPFOCUS ADD CONSTRAINT I_101198RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.LEDGERTRIALBALANCETMPTRANS" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".LEDGERTRIALBALANCETMPTRANS ADD CONSTRAINT I_101199RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.LEDGERTRIALBALANCETMPTRANSBYFOCUS" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".LEDGERTRIALBALANCETMPTRANSBYFOCUS ADD CONSTRAINT I_101200RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.LEDGERTURNOVERTMPDIMENSIONCRITERIA" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".LEDGERTURNOVERTMPDIMENSIONCRITERIA ADD CONSTRAINT I_101201RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.XXX_COGSPERPRODUCTPERROUTETEMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".XXX_COGSPERPRODUCTPERROUTETEMP ADD CONSTRAINT I_101674RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.XXX_DOCUMENTRECEIVEDTEMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".XXX_DOCUMENTRECEIVEDTEMP ADD CONSTRAINT I_101677RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.XXX_INVENTTRANSFERRECEVIETEMP" because it does not exist or you do not have permissions.
SQL statement: CREATE UNIQUE INDEX I_101687RECID ON "DBO".XXX_INVENTTRANSFERRECEVIETEMP (RECID)
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]Cannot find the object "DBO.XXX_MONTHLYCOGSDETAILSTEMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".XXX_MONTHLYCOGSDETAILSTEMP ADD CONSTRAINT I_101688RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.XXX_RECEIPTLISTTEMP" because it does not exist or you do not have permissions.
SQL statement: CREATE UNIQUE INDEX I_101689RECID ON "DBO".XXX_RECEIPTLISTTEMP (RECID)
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]Cannot find the object "DBO.XXX_SHIPMENTBOOKINGEXPORTDETAILSTEMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".XXX_SHIPMENTBOOKINGEXPORTDETAILSTEMP ADD CONSTRAINT I_101690RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.XXX_SHIPMENTBOOKINGEXPORTTEMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".XXX_SHIPMENTBOOKINGEXPORTTEMP ADD CONSTRAINT I_101691RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.XXX_SHIPMENTBOOKINGIMPORTDETAILSTEMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".XXX_SHIPMENTBOOKINGIMPORTDETAILSTEMP ADD CONSTRAINT I_101692RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.XXX_SHIPMENTBOOKINGIMPORTTEMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".XXX_SHIPMENTBOOKINGIMPORTTEMP ADD CONSTRAINT I_101693RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.XXX_WMSORDERTRANSTEMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".XXX_WMSORDERTRANSTEMP ADD CONSTRAINT I_101696RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.XXX_WMSSHIPMENTHEADERTEMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".XXX_WMSSHIPMENTHEADERTEMP ADD CONSTRAINT I_101697RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.XXX_INVENTMOVEMENTTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".XXX_INVENTMOVEMENTTMP ADD CONSTRAINT I_101700RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.XXX_STOCKRECEIVEDTMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".XXX_STOCKRECEIVEDTMP ADD CONSTRAINT I_101701RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.XXX_VENDORPERFORMANCEPRINCIPALTEMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".XXX_VENDORPERFORMANCEPRINCIPALTEMP ADD CONSTRAINT I_101702RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.XXX_SUBLEDGERJOURNALACCOUNTENTRYTMP" because it does not exist or you do not have permissions.
SQL statement: CREATE CLUSTERED INDEX I_101715SUBLEDGERJOURNALENTRY ON "DBO".XXX_SUBLEDGERJOURNALACCOUNTENTRYTMP (SUBLEDGERJOURNALENTRY)
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]Cannot find the object "DBO.XXX_NEWLYCREATEDCUSTTEMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".XXX_NEWLYCREATEDCUSTTEMP ADD CONSTRAINT I_101716RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.XXX_IMPORTSHIPMENTSTATUSTEMP" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".XXX_IMPORTSHIPMENTSTATUSTEMP ADD CONSTRAINT I_101717RECID PRIMARY KEY CLUSTERED (RECID)
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]Cannot alter 'DBO.SYSMODELMANIFESTCATEGORYOLD' because it is not a table.
SQL statement: ALTER TABLE "DBO".SYSMODELMANIFESTCATEGORYOLD ADD CONSTRAINT I_65420RECIDIDX PRIMARY KEY CLUSTERED (RECID)
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]Cannot alter 'DBO.SYSMODELMANIFESTCATEGORY' because it is not a table.
SQL statement: ALTER TABLE "DBO".SYSMODELMANIFESTCATEGORY ADD CONSTRAINT I_65421RECIDIDX PRIMARY KEY CLUSTERED (RECID)
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]Cannot alter 'DBO.SYSMODELLAYEROLD' because it is not a table.
SQL statement: ALTER TABLE "DBO".SYSMODELLAYEROLD ADD CONSTRAINT I_65422RECIDIDX PRIMARY KEY CLUSTERED (RECID)
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]Cannot alter 'DBO.SYSMODELELEMENTTYPEOLD' because it is not a table.
SQL statement: ALTER TABLE "DBO".SYSMODELELEMENTTYPEOLD ADD CONSTRAINT I_65423RECIDIDX PRIMARY KEY CLUSTERED (RECID)
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]Cannot alter 'DBO.SYSMODELELEMENTLABELOLD' because it is not a table.
SQL statement: ALTER TABLE "DBO".SYSMODELELEMENTLABELOLD ADD CONSTRAINT I_65424RECIDIDX PRIMARY KEY CLUSTERED (RECID)
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]Cannot alter 'DBO.SYSMODELELEMENTSOURCEOLD' because it is not a table.
SQL statement: ALTER TABLE "DBO".SYSMODELELEMENTSOURCEOLD ADD CONSTRAINT I_65425RECIDIDX PRIMARY KEY CLUSTERED (RECID)
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]Cannot alter 'DBO.SYSMODELELEMENTDATAOLD' because it is not a table.
SQL statement: ALTER TABLE "DBO".SYSMODELELEMENTDATAOLD ADD CONSTRAINT I_65426RECIDIDX PRIMARY KEY CLUSTERED (RECID)
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]Cannot alter 'DBO.SYSMODELELEMENTOLD' because it is not a table.
SQL statement: ALTER TABLE "DBO".SYSMODELELEMENTOLD ADD CONSTRAINT I_65427RECIDIDX PRIMARY KEY CLUSTERED (RECID)
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]Cannot alter 'DBO.SYSMODELMANIFESTOLD' because it is not a table.
SQL statement: ALTER TABLE "DBO".SYSMODELMANIFESTOLD ADD CONSTRAINT I_65428RECIDIDX PRIMARY KEY CLUSTERED (RECID)
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]Cannot alter 'DBO.SYSMODELOLD' because it is not a table.
SQL statement: ALTER TABLE "DBO".SYSMODELOLD ADD CONSTRAINT I_65429RECIDIDX PRIMARY KEY CLUSTERED (RECID)
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]Cannot create index on view 'MODELSECPOLRUNTIMEVIEW' because the view is not schema bound.
SQL statement: CREATE UNIQUE INDEX I_65430RECID ON "DBO".MODELSECPOLRUNTIMEVIEW (RECID)
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]Cannot alter 'DBO.SYSMODELLAYER' because it is not a table.
SQL statement: ALTER TABLE "DBO".SYSMODELLAYER ADD CONSTRAINT I_65432RECIDIDX PRIMARY KEY CLUSTERED (RECID)
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]Cannot alter 'DBO.SYSMODELELEMENTTYPE' because it is not a table.
SQL statement: ALTER TABLE "DBO".SYSMODELELEMENTTYPE ADD CONSTRAINT I_65433RECIDIDX PRIMARY KEY CLUSTERED (RECID)
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]Cannot alter 'DBO.SYSMODELELEMENTLABEL' because it is not a table.
SQL statement: ALTER TABLE "DBO".SYSMODELELEMENTLABEL ADD CONSTRAINT I_65434RECIDIDX PRIMARY KEY CLUSTERED (RECID)
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]Cannot alter 'DBO.SYSMODELELEMENTSOURCE' because it is not a table.
SQL statement: ALTER TABLE "DBO".SYSMODELELEMENTSOURCE ADD CONSTRAINT I_65435RECIDIDX PRIMARY KEY CLUSTERED (RECID)
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]Cannot alter 'DBO.SYSMODELELEMENTDATA' because it is not a table.
SQL statement: ALTER TABLE "DBO".SYSMODELELEMENTDATA ADD CONSTRAINT I_65436RECIDIDX PRIMARY KEY CLUSTERED (RECID)
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]Cannot alter 'DBO.SYSMODELELEMENT' because it is not a table.
SQL statement: ALTER TABLE "DBO".SYSMODELELEMENT ADD CONSTRAINT I_65437RECIDIDX PRIMARY KEY CLUSTERED (RECID)
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]Cannot alter 'DBO.SYSMODELMANIFEST' because it is not a table.
SQL statement: ALTER TABLE "DBO".SYSMODELMANIFEST ADD CONSTRAINT I_65438RECIDIDX PRIMARY KEY CLUSTERED (RECID)
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]Cannot alter 'DBO.SYSMODEL' because it is not a table.
SQL statement: ALTER TABLE "DBO".SYSMODEL ADD CONSTRAINT I_65439RECIDIDX PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.SYSSETBASEDHELPER" because it does not exist or you do not have permissions.
SQL statement: ALTER TABLE "DBO".SYSSETBASEDHELPER ADD CONSTRAINT I_65460CANDIDATERECIDIDX PRIMARY KEY CLUSTERED (CANDIDATERECID)
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]Cannot create index on view 'SECURITYPERMISSION' because the view is not schema bound.
SQL statement: CREATE UNIQUE CLUSTERED INDEX I_65468OWNERGROUPOBJECTIDX ON "DBO".SECURITYPERMISSION (OWNER,GROUP_,SECURABLEOBJECT)
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]Cannot create index on view 'SECURITYTASKENTRYPOINT' because the view is not schema bound.
SQL statement: CREATE UNIQUE CLUSTERED INDEX I_65469TASKENTRYPOINTIDX ON "DBO".SECURITYTASKENTRYPOINT (SECURITYTASK,ENTRYPOINT)
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]Cannot create index on view 'SECURITYENTRYPOINTLINK' because the view is not schema bound.
SQL statement: CREATE UNIQUE CLUSTERED INDEX I_65470ENTRYPOINTIDX ON "DBO".SECURITYENTRYPOINTLINK (ENTRYPOINT)
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]Cannot alter 'DBO.UTILMODELS' because it is not a table.
SQL statement: ALTER TABLE "DBO".UTILMODELS ADD CONSTRAINT I_65474RECIDIDX PRIMARY KEY CLUSTERED (RECID)
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]Cannot create index on view 'SECURITYROLEPERMISSIONOVERRIDE' because the view is not schema bound.
SQL statement: CREATE UNIQUE CLUSTERED INDEX I_65477ROLEOBJECTIDX ON "DBO".SECURITYROLEPERMISSIONOVERRIDE (SECURITYROLE,SECURABLEOBJECT)
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]Cannot create index on view 'SECURITYTASKPERMISSIONOVERRIDE' because the view is not schema bound.
SQL statement: CREATE UNIQUE CLUSTERED INDEX I_65478TASKOBJECTIDX ON "DBO".SECURITYTASKPERMISSIONOVERRIDE (SECURITYTASK,SECURABLEOBJECT)
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]Cannot create index on view 'SECURITYTASKEXPLODEDGRAPH' because the view is not schema bound.
SQL statement: CREATE UNIQUE CLUSTERED INDEX I_65480TASKSUBTASKIDX ON "DBO".SECURITYTASKEXPLODEDGRAPH (SECURITYTASK,SECURITYSUBTASK)
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]Cannot create index on view 'SECURITYSUBTASK' because the view is not schema bound.
SQL statement: CREATE UNIQUE CLUSTERED INDEX I_65481TASKSUBTASKIDX ON "DBO".SECURITYSUBTASK (SECURITYTASK,SECURITYSUBTASK)
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]Cannot create index on view 'SECURITYROLEEXPLODEDGRAPH' because the view is not schema bound.
SQL statement: CREATE UNIQUE CLUSTERED INDEX I_65485ROLESUBROLEIDX ON "DBO".SECURITYROLEEXPLODEDGRAPH (SECURITYROLE,SECURITYSUBROLE)
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]Cannot create index on view 'SECURITYSUBROLE' because the view is not schema bound.
SQL statement: CREATE UNIQUE CLUSTERED INDEX I_65486ROLESUBROLEIDX ON "DBO".SECURITYSUBROLE (SECURITYROLE,SECURITYSUBROLE)
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]Cannot alter 'DBO.SECURABLEOBJECT' because it is not a table.
SQL statement: ALTER TABLE "DBO".SECURABLEOBJECT ADD CONSTRAINT I_65487RECIDIDX PRIMARY KEY CLUSTERED (RECID)
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]Cannot alter 'DBO.SECURITYTASK' because it is not a table.
SQL statement: ALTER TABLE "DBO".SECURITYTASK ADD CONSTRAINT I_65489RECIDIDX PRIMARY KEY CLUSTERED (RECID)
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]Cannot create index on view 'SECURITYROLETASKGRANT' because the view is not schema bound.
SQL statement: CREATE UNIQUE CLUSTERED INDEX I_65490ROLETASKIDX ON "DBO".SECURITYROLETASKGRANT (SECURITYROLE,SECURITYTASK)
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]Cannot alter 'DBO.SECURITYROLE' because it is not a table.
SQL statement: ALTER TABLE "DBO".SECURITYROLE ADD CONSTRAINT I_65491RECIDIDX PRIMARY KEY CLUSTERED (RECID)
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]Cannot find the object "DBO.UTILIDELEMENTSOLD" because it does not exist or you do not have permissions.
SQL statement: CREATE UNIQUE INDEX I_65511NAME ON "DBO".UTILIDELEMENTSOLD (RECORDTYPE,PARENTID,NAME,UTILLEVEL)
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]Cannot alter 'DBO.UTILELEMENTSOLD' because it is not a table.
SQL statement: ALTER TABLE "DBO".UTILELEMENTSOLD ADD CONSTRAINT I_65512NAME PRIMARY KEY NONCLUSTERED (RECORDTYPE,PARENTID,NAME,UTILLEVEL)
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]Cannot find the object "DBO.UTILIDELEMENTS" because it does not exist or you do not have permissions.
SQL statement: CREATE UNIQUE INDEX I_65522NAME ON "DBO".UTILIDELEMENTS (RECORDTYPE,PARENTID,NAME,UTILLEVEL)
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]Cannot alter 'DBO.UTILELEMENTS' because it is not a table.
SQL statement: ALTER TABLE "DBO".UTILELEMENTS ADD CONSTRAINT I_65523NAME PRIMARY KEY NONCLUSTERED (RECORDTYPE,PARENTID,NAME,UTILLEVEL)
Problems during SQL data dictionary synchronization.
The operation failed.
Synchronize failed on 178 table(s)

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mahmoud Hakim Profile Picture
    Mahmoud Hakim 17,887 on at

    Check if this indexes not exist , you create it.

    Also if this indexes exist , check fields that contain is available or not.

  • Community Member Profile Picture
    Community Member on at

    Thanks for the reply.

    Mahmoud Hakim 

    It's 100 over tables to check 1 by 1 will be time consuming. 

    Sukrut Parab

    How can I call the rebuild from Ax? Any sample jobs to refer to?

  • Nathan Clouse AX Profile Picture
    Nathan Clouse AX 140 on at

    Hey Richard, check out this article: www.atomicax.com/.../breaking-and-fixing-sqldictionary

    This will help get you the SQL to execute manually and/or inspect.  

    Also, I have used this script in the past to give some insight into what is going on:

    select *, 'delete from SQLDICTIONARY where recid = ' + cast(sd.RECID as nvarchar(30))

    from SQLDICTIONARY sdParent

    join SQLDICTIONARY sd on sd.TABLEID = sdParent.TABLEID

                                     and sd.FIELDID <> 0

    left join sys.all_columns col on OBJECT_ID = OBJECT_ID(sdParent.SQLNAME) and col.name = sd.SQLNAME

    where sdParent.FIELDID = 0

    and sdParent.SQLNAME <> '<source table>'

    and sd.SQLNAME <> '<source table>'

    and col.name is null

    the last column creates a delete statement to clean up SQLDictionary records for columns that do not really exist in the database. Based on the errors, it looks like AX is trying to indexes for fields that do not actually exist but SQLDictionary says do exist. as with anything in Dictionary, use with great caution.

  • Community Member Profile Picture
    Community Member on at

    Hi Nathan Clouse ,

    Thanks for your reply and information. We are highly appreciated and will try it out the script asap. 

    Thank you.

  • Community Member Profile Picture
    Community Member on at

    Hi Nathan,

    I have run the script but nothing shown after the script. Do I need to change the <source table> to my problem listed table?

  • Nathan Clouse AX Profile Picture
    Nathan Clouse AX 140 on at

    Hey Richard,

            If that SQL script doesn't return any results, that's good. That means your SQLDictionary and actual database schema match relatively closely. That script doesn't capture all issues, just the most common where there is a SQLDictionary record for a column that doesn't actually exist. Have you tried using check/sync and looking at the SQL that AX generates to get a better idea what it is attempting to do? You can find out more about that here: www.atomicax.com/.../breaking-and-fixing-sqldictionary

           Also, i'd like to confirm you get the same set of errors each time you try to run a sync. The errors aren't changing in any way, are they?

  • Community Member Profile Picture
    Community Member on at

    Hi Nathan,

    Yes, basically I will get the same set of tables given problem every time I run the Reindex.

    I notice that most of the problem tables is either a Temporary tables or Views. As for SQL it's can't create any indexes on the Temporary table or view. I did try to run the SQL statement from the error messages in SSMS, it's return the error messages.  Is this Ax system programs problem? 

    There is another problem encountered on VendTable as below error message. Ax trying to drop index ("DROP INDEX VENDTABLE.I_505RECID") and it's not allowed to drop. 

    SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot drop index 'I_505RECID' because it enforces the full-text key for table or indexed view 'VENDTABLE'.

    SQL statement: DROP INDEX VENDTABLE.I_505RECID
    Cannot execute a data definition language command on ().
    The SQL database has issued an error.

     

    I did try to manually drop the index in SSMS got this message 

    Msg 7613, Level 16, State 2, Line 1
    Cannot drop index 'I_505RECID' because it enforces the full-text key for table or indexed view 'VENDTABLE'.

     

    Then there is another problem on the same VendTable, Ax trying to create the index I_505YOURACCOUNTNUMIDX without dropping it first and caused "index already exist" error. I tried the "Create Index" statement on SSMS with running "Drop index" statement prior to Create Index statement. It's running successfully.

    SQL error description: [Microsoft][SQL Server Native Client 10.0][SQL Server]The operation failed because an index or statistics with name 'I_505YOURACCOUNTNUMIDX' already exists on table 'DBO.VENDTABLE'.
    SQL statement: CREATE INDEX I_505YOURACCOUNTNUMIDX ON "DBO".VENDTABLE (DATAAREAID,YOURACCOUNTNUM) 

    From what I had tried and encountered this all I suspect is due to Ax Reindex kernel classes does not handle the SQL statement properly and causing this whole bunch of errors. I was trying to look for that programs but it's on kernel layer so not able to check further. Anyone know is there any patch(es) available to fix this problem?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans