Notifications
Announcements
No record found.
I am using DIXF for a data migration from R2 to R3. I setup a processing group to handle all data entities related to Products. I've run it in batch mode two nights in a row, and both times it stopped at the exact same place, after 18 records in the second entity in the processing group. The log shows no errors (I checked both the execution history log and the Windows Event Log).Has anyone else experienced this? What did you do to fix it?Thanks in advance for any and all suggestions.
Check event viewer for detailed error massage. from that you will able to find root cause for the issue.
Regards,
Amith Prasanna
Hi Daniel,
How many records do you have in the staging? How many records do you have in the source? You seem to use an ODBC query. Have you verified if the query is correct?
I checked the Application and System event logs in the Windows Event Viewer and neither of them show errors.
The queries are working fine, as the number of records in the Staging phase shows. (337,067 were brought into stage, but only 18 were created in the stage-to-target step). All the entities successfully populated their staging tables.
What is the status of the remaining staging records? Is it an error or not started?
"Not started".
It stops on the pending item prices? Did you set the parameters for this entity to run in to multiple bundles or just one? If you have many bundles, how many bundles? How many threads do you have available on the batch server(s)?
Yes, it appears to stop on the pending item prices. All the entities in this processing group were set to run eight bundles. There are eight threads available on the server.
Thanks,
djz
Have you checked if there might be an illegal character used in one of the fields on e.g. record 19? Does it continue to run if you run it manually without batch processing?
Thanks for the suggestions. I'll try to see if there might be an illegal character, but I doubt I'll find any since the data is coming straight out of our R2 database (test database) via ODBC.
I'll try running it manually without batch processing, but it will be significantly slower that way. (Many hours slower...)
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 660 Most Valuable Professional
André Arnaud de Cal... 549 Super User 2025 Season 2
Sohaib Cheema 307 User Group Leader