Permission Denied for SqlDataDictionary

(0) Share

Report

Posted on by Community Member

I am trying to truncate one of our tables in a class to run as a batch job, but keep getting a "Request for permission of type SqlDataDictionaryPermission failed. This is on an AX 4.0 system. I followed MSDN example on acquiring permissions and I am an admin. Here's the code:

//Truncate table

new SqlDataDictionaryPermission(

methodstr(SqlDataDictionary, tableTruncate)).assert();

sqlDict = new SqlDataDictionary();

sqlDict.tableTruncate(tableNum(PMF_INVENTTABLEMODULELOG),false);

CodeAccessPermission::revertAssert();

As I stated, I have admin access to this, so should have the required security key. Though this is displaying the (usr) environment in the class list.

Any help appreciated.

*This post is locked for comments

I have the same question (0)

All responses (16)

Answers (1)

Denis Macchinetti 16,444 on at

Like (0)

Report

Hi

I have recreated the same scenario in a my local AX 4.0 env. with no issues, also in batch mode.

You are sure that the code is executed on Server side ?

Look also msdn.microsoft.com/.../bb190039(v=ax.10).aspx

Regards

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

yes, i am using server (i am new to AX/X++) here's the lions share of the function:

server static void run()

{

SqlDataDictionary sqlDict;

;

//Truncate table

new SqlDataDictionaryPermission(

methodstr(SqlDataDictionary, tableTruncate)).assert();

sqlDict = new SqlDataDictionary();

sqlDict.tableTruncate(tableNum(PMF_INVENTTABLEMODULELOG),false);

CodeAccessPermission::revertAssert();

}

Was this reply helpful? Yes No
Denis Macchinetti 16,444 on at

Like (0)

Report

Hi

Then, how do you move your code in batch ?

Regards

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

This is encased in a class that is attached to a journal that runs on a batch server

Was this reply helpful? Yes No
Denis Macchinetti 16,444 on at

Like (0)

Report

Hi

What's happen if you try to call your class with a Job ?

Regards

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Same thing: Denial

Was this reply helpful? Yes No
Klaas Deforche 2,433 on at

Like (0)

Report

Hi,

Create a new table and try truncating that one using the same code. Does it work then?

Also check the properties on that table. For example is the configuration key enabled? Is the table set to visible? Maybe the cachelookup is playing a role? Is the table set to temp table (I guess not otherwise you would not have to truncate it)? Are you calling the code from withing a transaction?

Also try just running the code you pasted here without all the rest of your customizations.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I can truncate the table manually (via sql). This is a user created table, not a system table.

Even running the truncate code by itself gives me the error. Without the truncate code, the program executes, unfortunately without truncating the needed table

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Why cant you use DELETE_FROM command?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Something like this

ttsBegin;

PMF_INVENTTABLEMODULELOG.skipDataMethods(true);

delete_from PMF_INVENTTABLEMODULELOG;

ttsCommit;

Was this reply helpful? Yes No