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.
>
>
>
