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.
