1. check/Syncronize the AOT with check index option checked and get the output and see if you get anything. 2. Do you have any tables replicated in axapta for ano other purposes, for example say Datawarehousing?. You need to stop the replicattion agents before you import your code.
--- In Axapta-Knowledge-Village@yahoogroups.com, "tkbsmanian" <[EMAIL PROTECTED]> wrote: > > Dear Sir, > > > I've re-created the issue and observed the details from Event Viewer. > It's giving the following error as below. (i'm using SP2, Appl ver. > 4.0.2501.116, kernel ver. 4.0.2501.116 with SQL Server 2005) > > > > Object Server 04: The database reported (session 4 (Admin)): > [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the > index 'TUTORIAL_AUCTIONPOLL.I_1229DATARECIDIDX', because it does not > exist or you do not have permission.. The SQL statement was: "drop > index TUTORIAL_AUCTIONPOLL.I_1229DATARECIDIDX" > > > > Object Server 04: The database reported (session 4 (Admin)): > [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the > index 'TUTORIAL_AUCTIONBIDS.I_1226DATARECIDIDX', because it does not > exist or you do not have permission.. The SQL statement was: "drop > index TUTORIAL_AUCTIONBIDS.I_1226DATARECIDIDX" > > > > Object Server 04: The database reported (session 4 (Admin)): > [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the > index 'TUTORIAL_AUCTIONITEMS.I_1225DATARECIDIDX', because it does not > exist or you do not have permission.. The SQL statement was: "drop > index TUTORIAL_AUCTIONITEMS.I_1225DATARECIDIDX" > > > > Object Server 04: The database reported (session 4 (Admin)): > [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the > index 'TRANSACTTXT.I_483DATARECIDIDX', because it does not exist or > you do not have permission.. The SQL statement was: "drop index > TRANSACTTXT.I_483DATARECIDIDX" > > > > Object Server 04: The database reported (session 4 (Admin)): > [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot drop the > index 'BUSINESSSTATISTICSDATA.I_032DATARECIDIDX', because it does not > exist or you do not have permission.. The SQL statement was: "drop > index BUSINESSSTATISTICSDATA.I_032DATARECIDIDX" > > > > Object Server 04: The database reported (session 4 (Admin)): > [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE INDEX > terminated because a duplicate key was found for object > name 'dbo.ASSETMAINTENANCEITEMDETAILS' and index > name 'I_30010CONSUMPIDX'. The duplicate key value is (tst, B- pack1, > 00001_060, 5637144576).. The SQL statement was: "ALTER TABLE > ASSETMAINTENANCEITEMDETAILS ADD CONSTRAINT I_30010CONSUMPIDX PRIMARY > KEY NONCLUSTERED (DATAAREAID,ITEMID,INVENTDIMID,REFRECID) " > > > > The description for Event ID ( 17895 ) in Source ( > MSSQL$MICROSOFT##SSEE ) cannot be found. The local computer may not > have the necessary registry information or message DLL files to > display messages from a remote computer. You may be able to use > the /AUXSOURCE= flag to retrieve this description; see Help and > Support for details. The following information is part of the event: > 172072, 1944077. > > > > Object Server 04: The database reported (session 4 (Admin)): > [Microsoft][ODBC SQL Server Driver][SQL Server]CREATE UNIQUE INDEX > terminated because a duplicate > > key was found for object name 'dbo.ASSETMAINTENANCEITEMDETAILS' and > index name 'I_30010CONSUMPIDX'. > > The duplicate key value is (tst, B-pack1, 00001_060, 5637144576).. > The SQL statement was: "ALTER TABLE ASSETMAINTENANCEITEMDETAILS ADD > CONSTRAINT I_30010CONSUMPIDX PRIMARY KEY NONCLUSTERED > (DATAAREAID,ITEMID,INVENTDIMID,REFRECID) " > > > > > > As the error message says, i can understand that, the indexes > mentioned above in the error messages were not available. > > > > But still, i dont have any idea to resolve this problem.Will the > problem be solved if i create the index against the table mentioned > and do the synchronization?. > > Please advise me how to resolve this problem. > > > > Thanks && Regards, > > Balu. > > --- In Axapta-Knowledge-Village@yahoogroups.com, "Vivek" <vivek@> > wrote: > > > > Hi Balu, > > > > > > > > First place to check when you get such database errors is the event > viewer. > > > > > > > > Run the process which generates that error and check the event once > you get > > the error. > > > > > > > > Send the error messages from the event viewer if you can't solve it. > > > > > > > > Thanks > > > > Vivek > > > > > > > > From: Axapta-Knowledge-Village@yahoogroups.com > > [mailto:[EMAIL PROTECTED] > > Sent: Friday, May 23, 2008 5:05 AM > > To: Axapta-Knowledge-Village@yahoogroups.com > > Subject: [Axapta-Knowledge-Village] Digest Number 1847 > > > > 5a. > > > > > > <http://groups.yahoo.com/group/Axapta-Knowledge- > Village/message/17464;_ylc=X > > > 3oDMTJzbHUzamxyBF9TAzk3MzU5NzE1BGdycElkAzEyNzQ4MDYyBGdycHNwSWQDMTcwNTA > wMTM4M > > ARtc2dJZAMxNzQ2NARzZWMDZG1zZwRzbGsDdm1zZwRzdGltZQMxMjExNDk5Mjc5> > Re: Cannot > > execute the required database operation.The SQL database > > > > Posted by: "tkbsmanian" > > <mailto:[EMAIL PROTECTED] > 20req > > uired%20database%20operation%2EThe%20SQL%20database%20> > tkbsmanian@ > > <http://profiles.yahoo.com/tkbsmanian> tkbsmanian > > > > Wed May 21, 2008 10:06 pm (PDT) > > > > Hi Sumit, > > > > I encountered the above said problem immediately after importing > > the .dat and .def files into the application. > > > > If it is related to permissions issue, where can i see the > > permissions and how to rectify this problem? Plz advise me. > > > > \Balu. > > --- In <mailto:Axapta-Knowledge-Village%40yahoogroups.com> > > Axapta-Knowledge-Village@yahoogroups.com, "Sumit Loya" > > <loya.sumit@> wrote: > > > > > > Hi, > > > > > > This error is related to the permissions see if the code is > running > > on > > > server or client or the user running the job has rights to > execute > > the SQL > > > statements generated. > > > > > > Regards, > > > Sumit > > > > > > On Fri, May 16, 2008 at 4:57 PM, tkbsmanian <tkbsmanian@> wrote: > > > > > > > Hi All, > > > > > > > > I'm encountering a problem while synchronizing Tables and the > > error > > > > message is as below. > > > > > > > > Cannot execute the required database operation. > > > > The SQL database has issued an error. > > > > > > > > Cannot execute a data definition language command on (). > > > > The SQL database has issued an error. > > > > > > > > Request for the permission of > type 'SqlStatementExecutePermission' > > > > failed. > > > > (S)\Classes\SqlStatementExecutePermission\demand > > > > (S)\Classes\Statement\executeQuery > > > > (C)\Forms\SysSQLShowRows\Methods\buildListView - line 25 > > > > (C)\Forms\SysSQLShowRows\Methods\run - line 8 > > > > (S)\Classes\SqlScanMain\checkUniqueRule - line 34 > > > > (S)\Classes\SqlScanMain\checkIndexesForTable - line 187 > > > > (S)\Classes\SqlScanMain\handleTable - line 46 > > > > (S)\Classes\SqlScanMain\run - line 53 > > > > (S)\Classes\SysSqlAdminClass\handleSelectedItems - line 125 > > > > (C)\Forms\SysSqlAdmin\Methods\runThroughTablesAndIndexes - line > 44 > > > > (C)\Classes\FormButtonControl\Clicked - line 4 > > > > (C)\Classes\FormMenuButtonControl\Clicked > > > > > > > > I've done as many ways as i know like... > > > > 1. Synchronized the table on AOT. > > > > 2. Synchronized through Administration>Periodic>SQL > > Administration> > > > > a. All Tables > Table actions > Synchnonize > > > > b. All Tables > Table actions > Check\Synchronize > Start > > > > c. All Tables > Table actions > Check\Synchronize > {checked > > > > Remove unknown indexec} > Start > > > > 3. Deleted all *.ali & *.aoi files from application and re- > started > > > > the AOS. > > > > > > > > But, still i'm getting the same problem as i mentioned above. > > > > > > > > I'll appreciate, if anybody give me the solution for the same. > > > > > > > > Thanks in advance, > > > > Balu. > > > > > > > > > > > > > > > > > > > Back to top > > > > > > <mailto:[EMAIL PROTECTED] > 20requir > > ed%20database%20operation%2EThe%20SQL%20database%20> Reply to > sender | > > <mailto:[EMAIL PROTECTED] > 20Cannot%2 > > 0execute%20the%20required%20database%20operation%2EThe%20SQL% > 20database%20> > > Reply to group | > > <http://groups.yahoo.com/group/Axapta-Knowledge- > Village/post;_ylc=X3oDMTJza2 > > > 5lc21xBF9TAzk3MzU5NzE1BGdycElkAzEyNzQ4MDYyBGdycHNwSWQDMTcwNTAwMTM4MARt > c2dJZA > > MxNzQ2NARzZWMDZG1zZwRzbGsDcnBseQRzdGltZQMxMjExNDk5Mjc5? > act=reply&messageNum= > > 17464> Reply via web post > > >
