Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Kingswaysoft Dynamics ...
Finance | Project Operations, Human Resources, ...
Unanswered

Kingswaysoft Dynamics AX source fails with errors

(0) ShareShare
ReportReport
Posted on by sandeepbantupalli 5

I am using Kingswaysoft Dynamics AX source connector to load data from MS Dynamics AX (CasCustomerV3 entity) and it fails with the following errors. I am able to connect to another entity (CustomerV2) using the same connection and load the data without any issue but am not able to connect to a custom-created entity called CasCustomerv3. I was able to load the data using the same CasCustomerv3 entity 2 days ago but stopped working since the last day. The only change I know is that there was a change in the field name in the CasCustomerV3 entity, so I created SSIS from scratch to capture the change but still no luck. 

I contacted kingswaysoft and they suggested applying filters and refreshing the source component and pointed to this link (1) Exception when using FixedAssets data entity. D365FO - Microsoft Dynamics AX Forum Community Forum. I tried all of them with no luck. Posted screenshots of my SSIS and connection. 

Did anyone have a similar issue? Thoughts on the root cause?

SSIS Package Explorer:

SSIS package "C:\Users\sandeep.bantupalli\source\repos\Customer_Dynamics_AX\Package.dtsx" starting.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Warning: 0x80049304 at Data Flow Task, SSIS.Pipeline: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console.
Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning.
Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning.
Error: 0xC002F304 at Data Flow Task, Dynamics AX Source [2]: An error occurred with the following error message: "KingswaySoft.IntegrationToolkit.DynamicsAx.Odata.AxOdataServiceException: The remote server returned an error: (400) Bad Request. (Error Type / Reason: BadRequest, Detailed Message: {
"error": {
"code": "",
"message": "An error has occurred.",
"innererror": {
"message": "Cannot select a record in Sub Query (Subquery).\nThe SQL database has issued an error.",
"type": "Microsoft.Dynamics.Ax.Xpp.ErrorException"
}
}
}) (SSIS Integration Toolkit for Microsoft Dynamics 365, v21.2.0.31501 - DtsDebugHost, v15.0.2000.170)System.Net.WebException

(Status Reason: BadRequest): The remote server returned an error: (400) Bad Request.".
Error: 0x80004005 at Data Flow Task, Dynamics AX Source [2]: Attempt to read message string for 0xc02090f5 failed with error 0xc02090f2. Make sure all message related files are registered.
Error: 0xC0047038 at Data Flow Task, SSIS.Pipeline: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on Dynamics AX Source returned error code 0xC02090F5. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages posted before this with more information about the failure.
Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning.
Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "OLE DB Destination" wrote 0 rows.
Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning.
Task failed: Data Flow Task
Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "C:\Users\sandeep.bantupalli\source\repos\Customer_Dynamics_AX\Package.dtsx" finished: Failure.
The program '[2332] DtsDebugHost.exe: DTS' has exited with code 0 (0x0).

Connection Manager: Dynamics AX

AX-connection-Manager.png

Dynamics AX source component for CasCustomerV3 entity:

2047.SSIS.png

CasCustomerV3 (custom created entity): Fails with errors mentioned

6215.Failure.PNG

CustomerV2 loading without any issue:

CustomerV2.PNG

  • Daniel Cai Profile Picture
    Daniel Cai 935 on at
    RE: Kingswaysoft Dynamics AX source fails with errors

    Based on the error message, it is basically a server-side error. It appears that there is some server-side logic in place which would perform a subquery when reading from the CasCustomerV3 entity. You could have a try of the following. 

    • Try to limit the number of fields that you are reading from - you could try to use a binary search approach to find out the offending fields - essentially you would select/unselect half number of fields for reading until you find the exact offending fields. 

    You might want to check with your F&O developer to see if there is any custom server-side logic that has been implemented which might trigger this particular issue. 

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    RE: Kingswaysoft Dynamics AX source fails with errors

    The Dynamics 365 Office connector is retrieving the information using the OData protocol. There is no separate Dynamics AX portal.

    Are you able to see your custom entity via the 'Workbook designer' form in Dynamics 365?

    Can you share the steps you have done to open the Dynamics Office connector and how you got this error?

  • sandeepbantupalli Profile Picture
    sandeepbantupalli 5 on at
    RE: Kingswaysoft Dynamics AX source fails with errors

    Andre Arnaud de Calavon 

    I don't have access to make any modifications to the custom data entity in Dynamics AX. As mentioned there was a change in the field name in the custom entity. The entity was recompiled by AX team after which I tried to connect with no luck. So to answer your question I am not able to revert the changes to entity.

    I tried using the Dynamics Office connector in Excel and got the following error. To use Dynamics Office connector in Excel or Postman, I will need access to Dynamics AX portal I believe ?

    6428.Connector.PNG

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,269 Super User 2024 Season 2 on at
    RE: Kingswaysoft Dynamics AX source fails with errors

    HI Sandeep,

    You shared logs from a third-party tool which I'm not familiar with. I can only see a common error in both logs: '400 - bad request'.

    When you revert the changes on the custom data entity, are you able to get it working again?

    You can also try if the custom data entity is working properly using e.g. the Dynamics Office connector in Excel or a call using Postman.

    If you keep having issues, you can search on internet what an error 400 is about. It might be a wrong syntax in the call or something different.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans