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 Axapta-Knowledge-Village@yahoogroups.com, "Sumit Loya"
<[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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.
> >
> >
> >
>
