Hello Rajesh, Please find my answers for your questions and help me out.
1. It's not live/production environment.It's a full installation of the application in a server machine testing for pilot stage. 2. I'm sure there are no duplicates in the tables.I didn't make any changes to the tables.I was using different .dat and .def files in different company and tried to import demo data and did synchronization.That time only, it thrown the error. 3. I didn't checked it that time and now i'm not using that application (un-installed) and didn't tried to import the .dat and .def file which gave me the error after importing. Hope these things will make you to understand my problem and make you to answer in detail. Thanks in advance, Balu. --- In [email protected], Rajesh Hari <[EMAIL PROTECTED]> wrote: > > 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] >
