Error while associating Data source to report

(0) Share

Report

Posted on by Omar

230

I am facing issue while associating a data source to report. I think the issue is due to permissions. The error shown in Visual Studio while connecting to Data Source.

cannot create a record a in system events (SysEvent). Event ID: 5637144, Refresh AOD. The Record Already Exists.

and when i check from event viewer then the following error is shown.

The description for Event ID 110 from source Dynamics .NET Business Connector 6.0 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer

If somebody can immediately help in sorting out this issue????//

When I check the Eventviewer then found following message. May be its relevant to this problem

--------------------------------------------------------------------

The description for Event ID 180 from source Microsoft Dynamics AX cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

Microsoft Dynamics AX Business Connector Session 3.

RPC exception 1722 in Ping occurred in session 8 ,process: Ax32.exe ,thread: 117812

*This post is locked for comments

All responses (5)

Answers (0)

Omar 230 on at

Like (0)

Report

RE: Error while associating Data source to report

Thanks Nitesh reply, we did these steps before but it allows for one step to move forward but in next step the error again appear.

Now, what we did we connected the same AX client with Production Server it did not generate that issue. So it worked fine for us. Then we tried AX Client from Production to AOS on stage which did not work. So it seems there is a problem on AOS Server.

There seems to be two sort of issues either the problem with DB which we restore from Production to Stage as it is OR there is some component problem on AOS Server on stage. Could you please suggest any solution to identify the real cause of this issue and solution.

Even we removed/reinstall all development tools or components other than AOS but still issue is appearing. Any solution??
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Error while associating Data source to report

Consider refreshing the cache

Open Dynamics AX in Development workspace

go to menu Tools> Caches >

execute Refresh Directory/ Refresh Data / Refresh element

Please verify and update if this solves your issue.
Omar 230 on at

Like (0)

Report

RE: Error while associating Data source to report

After the above issue, when I check the event viewer, I found following warning and description.

---------------------------------------------------------------------------------------------------------

The description for Event ID 180 from source Microsoft Dynamics AX cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

Microsoft Dynamics AX Business Connector Session 3.

RPC exception 1722 in Ping occurred in session 8 ,process: Ax32.exe ,thread: 117812
Omar 230 on at

Like (0)

Report

RE: Error while associating Data source to report

Dear

Thank you very much for quick reply. Please see the following steps which i am taking

Sometimes, the error does not display and it loads all the queries list but after selection or next step it appears again.

Could you please let us know what is the problem and solution quickly????

Regards
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Error while associating Data source to report

You could try refreshing your Business Connector configuration.

Steps.

1. Open your AX Client configuration utility

2. Click on the First dropdown and select 'Business Connector'

3. Verify your settings and the connection tab if its pointing to the right AOS.

Also make sure the Security account the Business connector is running has permissions enabled. System Administration > System > System Security Accounts

Link :msdn.microsoft.com/.../aa496652(v=ax.10).aspx

Regards,

Saravanan L | Enterprise Architect | My Blog