Microsoft Dynamics AX (Archived)

Request for the permission of type 'FileIOPermission' failed

(0) Share

Report

Posted on by Prabakaran.R

313

Hi,

I'm using this code for Export CSV file through batch job but got the FileIOPermission error.

fileName = "\\sssdt-006\\ExportCSV\\" + "ItemDetails" + ".csv";

filepermission = new FileIoPermission(fileName, 'w');
commaIO = new CommaIO(fileName, 'r');
filepermission.assert();
q = new Query();
qbds = q.addDataSource(tablenum(InventTable));
qbr = qbds.addRange(fieldnum(InventTable,ItemId));
qr = new QueryRun(q);
commaIO.write("ItemId");
while (qr.next())
{
inventTable = qr.get(tablenum(InventTable));
commaIO.write(inventTable.ItemId);
commaIO.write(output);
}
CodeAccessPermission::revertAssert();

4011.Error.png

Thanks for the help in advance.

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Hi Prabakaran

You could see tutorial below :

https://community.dynamics.com/ax/b/dynamicsaxinsideout/archive/2015/11/13/x-export-data-from-table-to-a-csv-file

NB : If it resolve your problem please mark as answered :D

Was this reply helpful? Yes No
Prabakaran.R 313 on at

Like (0)

Report

Hi Mehdi

Thank you for reply your above link is working fine only for normal job and class but unfortunately its not work for batch job, i got same error, please suggest me some other solution to solve this.

Thank you

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Prabakaran,

Coul you please send me your code ?

Thanks

Was this reply helpful? Yes No
Prabakaran.R 313 on at

Like (0)

Report

Hi Mehdi,

Thank you for your response

This my code , this code take from above link,

Query q;

QueryBuildDataSource qbds;

QueryBuildRange qbr;

QueryRun qr;

CommaIO commaIO;

FileName fileName;

InventTable inventTable;

;

fileName = "C:\\ExportFile\\" + "ItemDetails" + ".csv"; //Destination of the file

commaIO = new CommaIO(fileName,'W');

q = new Query();

qbds = q.addDataSource(tablenum(InventTable));

qbr = qbds.addRange(fieldnum(InventTable,ItemId)); //Range

qr = new QueryRun(q);

commaIO.write("ItemId","Item Type"); //Header of the CSV File

//Loop to insert values in the csv from the table

while( qr.next() )

{

inventTable = qr.get(tablenum(InventTable));

commaIO.write(inventTable.ItemId,enum2str(inventTable.ItemType));

}

WINAPI::shellExecute(fileName);

}

Thank you

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Have you put this code in a class that extends RunBaseBatch ?

Was this reply helpful? Yes No
Prabakaran.R 313 on at

Like (0)

Report

Hi Mehdi,

Thank you for reply, I have used that.

Thank you

Was this reply helpful? Yes No
Suggested answer

Rudi Hansen 4,075 on at

Like (0)

Report

You need to check if the user that your AOS runs under has access to the folder you are trying to write the file too.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Please invert the position of your code:

your code: filepermission = new FileIoPermission(fileName, 'w');

commaIO = new CommaIO(fileName, 'r');

filepermission.assert();

the correct code:

filepermission = new FileIoPermission(fileName, 'w');

filepermission.assert();

commaIO = new CommaIO(fileName, 'r');

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Prabakaran,

So check the file permission or folder permission if user has access to it in write mode

Was this reply helpful? Yes No

Community site session details

Request for the permission of type 'FileIOPermission' failed

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates

Community site session details

Request for the permission of type 'FileIOPermission' failed

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Featured topics

Product updates