Hi Balu,
First place to check when you get such database errors is the event viewer.
Run the process which generates that error and check the event once you get
the error.
Send the error messages from the event viewer if you can't solve it.
Thanks
Vivek
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED]
Sent: Friday, May 23, 2008 5:05 AM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Digest Number 1847
5a.
http://groups.yahoo.com/group/Axapta-Knowledge-Village/message/17464;_ylc=X
3oDMTJzbHUzamxyBF9TAzk3MzU5NzE1BGdycElkAzEyNzQ4MDYyBGdycHNwSWQDMTcwNTAwMTM4M
ARtc2dJZAMxNzQ2NARzZWMDZG1zZwRzbGsDdm1zZwRzdGltZQMxMjExNDk5Mjc5 Re: Cannot
execute the required database operation.The SQL database
Posted by: tkbsmanian
mailto:[EMAIL PROTECTED]
uired%20database%20operation%2EThe%20SQL%20database%20 [EMAIL PROTECTED]
http://profiles.yahoo.com/tkbsmanian tkbsmanian
Wed May 21, 2008 10:06 pm (PDT)
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 mailto:Axapta-Knowledge-Village%40yahoogroups.com
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 AdministrationPeriodicSQL
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.
Back to top
mailto:[EMAIL PROTECTED]
ed%20database%20operation%2EThe%20SQL%20database%20 Reply to sender |
mailto:[EMAIL PROTECTED]
0execute%20the%20required%20database%20operation%2EThe%20SQL%20database%20
Reply to group |
http://groups.yahoo.com/group/Axapta-Knowledge-Village/post;_ylc=X3oDMTJza2
5lc21xBF9TAzk3MzU5NzE1BGdycElkAzEyNzQ4MDYyBGdycHNwSWQDMTcwNTAwMTM4MARtc2dJZA
MxNzQ2NARzZWMDZG1zZwRzbGsDcnBseQRzdGltZQMxMjExNDk5Mjc5?act=replymessageNum=
17464 Reply via web post