Hello Balu I will try to answer this by asking a few questions. Maybe it points you in the right direction. 1. Is it in your live/production environment that you are facing this problem ? I assume not , but you can always see issues when you try to deploy a customization. 2. Are you sure there are no duplicates in this table ? The reason is that AX tries to create or update indexes as part of the synchronize process. What changes did you make to the table before the synchronize ? Was there data in the table before your changes ? 3. Can you check the event viewer and retrieve the error message logged on the AOS server when you execute the synchronize action ? I will add to this post based on answers to the above . Hope this helps Thanks Rajesh Hari
----- Original Message ---- From: tkbsmanian <[EMAIL PROTECTED]> To: [email protected] Sent: Friday, May 16, 2008 1:25:26 PM Subject: [development-axapta] Cannot execute the required database operation.The SQL database has issued an er 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 'SqlStatementExecut ePermission' failed. (S)\Classes\ SqlStatementExec utePermission\ demand (S)\Classes\ Statement\ executeQuery (C)\Forms\SysSQLSho wRows\Methods\ buildListView - line 25 (C)\Forms\SysSQLSho wRows\Methods\ run - line 8 (S)\Classes\ SqlScanMain\ checkUniqueRule - line 34 (S)\Classes\ SqlScanMain\ checkIndexesForT able - line 187 (S)\Classes\ SqlScanMain\ handleTable - line 46 (S)\Classes\ SqlScanMain\ run - line 53 (S)\Classes\ SysSqlAdminClass \handleSelectedI tems - line 125 (C)\Forms\SysSqlAdm in\Methods\ runThroughTables AndIndexes - line 44 (C)\Classes\ FormButtonContro l\Clicked - line 4 (C)\Classes\ FormMenuButtonCo ntrol\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. [Non-text portions of this message have been removed]
