Giridhar Raj's Blog on Microsoft Dynamics AX

Temporary Tables defaulted to DAT company in AX 2009

noreply@blogger.com (Giridhar Raj) — Mon, 16 Jan 2012 20:52:16 PST

Hi Folks,

I think its been a long time that I have posted some post on my blog.

2-3 weeks back, One of my customer has been facing a continous AOS crash issue then when I have googled it using the event log messages, I have come across a resolution for a support issue from Microsoft, saying that "In User Group permission, make sure all users belong to a user group where the user group's domain contains the DAT company. Also, ensure that the DAT company is not used to save any data."

The reason for this is that due to design limitation tempoary tables are defaulted to the DAT company similar to entire table caches and so the all User groups domain should contain DAT company.

So, remember to include DAT company in User groups domain as practise which would avoid AOS crashes.

Probably this might help someone who is facing the same kind of issue.

The Error messages in the event viewer are as follows:

Application Object server (AOS) crashed with error:

Log Name: Application

Source: Dynamics Server 02

Event ID: 110

Task Category: None

Level: Error

Description:

Object Server 02: Unexpected situation

More Information: Delayed change company RPC failed.

And then:

Log Name: Application

Source: Application Error

Event ID: 1000

Task Category: (100)

Description:

Faulting application name: Ax32Serv.exe, version: 5.0.1500.2189, time stamp: 0x4b73d211

Faulting module name: KERNELBASE.dll, version: 6.1.7600.16385, time stamp: 0x4a5bdfe0

Exception code: 0xc0000005

Fault offset: 0x000000000000aa7d

Faulting process id: 0x%9

Faulting application start time: 0x%10

Faulting application path: %11

Faulting module path: %12

Report Id: %13
Reference : http://support.microsoft.com/kb/2258719

"An error occurred during this operation" error when you try to print a SSRS report from Enterprise Portal (EP) website in Internet Explorer 8

noreply@blogger.com (Giridhar Raj) — Thu, 01 Dec 2011 17:51:46 PST

Recently, For one of our customers we have developed an SSRS report and published it on Enterprise portal using Internet Explorer 8. When trying to print the report we were getting an error message box "An error occurred during this operation" When I tried to google it, I found a support link from Microsoft.

The workaround given in the following link has resolved the SSRS printing issue.

http://support.microsoft.com/kb/2445751

The workaround is as follows:

To work around this issue, disable the protected mode for the Local intranet zone and for the Trusted siteszone in Internet Explorer 8. To do this, follow these steps:

Run Internet Explorer 8, click Tools on the menu, and then click Internet Options to open theInternet Options dialog box.
In the Internet Options dialog box, click the Security tab.
On the Security tab, click the Local intranet zone, and then click to clear the Enable Protected Modecheck box.
On the Security tab, click the Trusted sites zone, and then click to clear the Enable Protected Modecheck box.

Thus, the above solution resolves the SSRS report printing issue.

Happy DAxing...............

How to read a CSV , txt file in AX 2009

noreply@blogger.com (Giridhar Raj) — Mon, 28 Nov 2011 19:29:49 PST

Hi Folks,

In this post, I am going to explain you on how to read a CSV file in AX 2009.

1. First of all, make sure that the file is accessible and has sufficient permissions to read the file.

2. Now follow the below code which reads the file, reads all the lines in the file and inserts into the table.

#File
CommaIo aSCIIFile;
Container recordsCon;
FileIoPermission perm;
StudentTable studentTable;
#define.ExampleFile(@"c:\test.txt")
;

perm = new FileIoPermission(#ExampleFile, #io_read);

if (perm == null)
{
       return;
}
// Grants permission to execute the CommaIo.new method.
    // CommaIo.new runs under code access security.
    perm.assert();

// BP deviation documented.

aSCIIFile = new CommaIo(#ExampleFile,#io_read);
ttsbegin;
while (aSCIIFile.status()== IO_Status::Ok) //Reading the ASCII file if records are there
{
recordsCon = aSCIIFile.read();
for(j=1;j<=Conlen(recordsCon);j++)
{
studentTable.(fieldName2Id(tableNum(studentTable), "Id")) = conpeek(recordsCon,j);
}
studentTable.insert();
}
ttscommit;