Problem in batch IO job

(0) Share

Report

Posted on by Community Member

Hi!

Here is my code:

void createCSVCurrencyFile()
{
      Commaio file;
    container line;
    ExchRates exRates;
    Str filename;
    Str todayString;
     FileIOPermission       readPermission;
    ;

    todayString = date2Str
        (today(),
        321,
        DateDay::Digits2,
        DateSeparator::Hyphen, 
        DateMonth::Digits2,
        DateSeparator::Hyphen, 
        DateYear::Digits4
        );

    filename ="\\\\servername\\AX\\Currencies\\Rates_"+todayString+"_cmpy.csv";

    readPermission = new FileIOPermission(filename, "w");

    readPermission.assert();

    file =new Commaio(filename , "w");
    file.outFieldDelimiter(';');

    if( !file || file.status() != IO_Status::Ok)
    {
        //throw error("File Cannot be opened");
    }

    while select exRates
           where exRates.DataAreaId == 'cmp'
           && exRates.FromDate == today()
    {
        line = [
        exRates.CurrencyCode,
        //exRates.FromDate,
        date2Str
        (exRates.FromDate,
        321,
        DateDay::Digits2,
        DateSeparator::Hyphen, 
        DateMonth::Digits2,
        DateSeparator::Hyphen, 
        DateYear::Digits4
        ),
        exRates.Exchrate];
        file.writeExp(line);

    }
    CodeAccessPermission::revertAssert();
}

The job received the following error: CommaIo object not initialized.

any suggestion? :)

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

XB 1,875 on at

Like (0)

Report

Exist path? do you have access to the path?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi!

Yes the path is valid. The same code with simple job works perfectly.

Was this reply helpful? Yes No
Martin Dráb 237,880 Most Valuable Professional on at

Like (0)

Report

If you run it in a job, it runs on client under your account.

If you run it in a batch, it runs on AOS (usually a completely different machine) and under the AOS service account (usually a completely different account that yours).

That's why testing the code in a job doesn't say much about how it will behave in batch.

First of all, check if the AOS service account has permissions to write to the file.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

I guess your AOS service account does not have access to the folder. Please check if the AOS service account has read access to the directory.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks for all the responses!

For the folder the permission is set to "Everyone" with write and modify.

Isn't is enough?

Was this reply helpful? Yes No
Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report

Since you are using a network share by telling it from the UNC path, you need to provide access in 2 places. Both in the Security tab, and on the Sharing tabs' permissions as well. If you only have one of them provided, that is the cause of your problem why it does not work.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Thank you, the Sharing tab was the missing step :)

Was this reply helpful? Yes No