You’re offline. This is a read only version of the page.
Hi,
I am running Integration Manager mapping to load approx 30K+ of inventory items.
My mapping works perfectly fine and the data source I use is MS SQL Server db view. Mapping is pretty simple, it has all data pre-formatted and prepared to load as GP expects them. I get no errors or warnings up to approx first 1000 documents, but then all of the sudden I get "too many windows open" error and my GP crashes.
Here is what stack trace looks like in Integration Manager windows:
Opening source query...
Establishing source record count...
Beginning integration...
DOC 830 ERROR: The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT))
DOC 831 ERROR: The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT))
ERROR: Max Errors Exceeded at 11, Integration Canceled
ERROR: Integration canceled during document integration.
Integration Failed
Integration Results
31248 documents were read from the source query.
840 documents were attempted:
829 integrated without warnings.
0 integrated with warnings.
11 failed to integrate.
I have my max error count set to 11, so after the initial error message appears, next 11 items fail and the load terminates.
Can someone please advise on the root cause and how can import my complete set of data preferably in one shot?
Thank you
PS: I am on GP 2016
*This post is locked for comments
Thank you Praveen! I have thought to do exactly what you suggest. I am not using Excel, my staging tables are in MS SQL Server but it does not matter.
The issue seems to be a bug and I found some old posts for GP2010 about similar behavior but the only suggestion in those posts was to restart GP cleanly after the crash.
I have been able to accomplish my data load using different tool which luckily I have access to - SmartConnect from EONE (makers of Extender).
It works exactly just like Integration Manager is supposed to, but its not buggy like IM.
I was able to run my 30K inventory items load in 30 min using SmartConnect.
Eugene
Hi,
Is it possible to make separate Excel with less number of records(Say 1000) and see if it works fine.
If this itself fails, then you can set error count to 100 and prepare the excel with just 100 records.
In other way, i suggest you to split your 30 K excel into 3 with 10 K each and try out.
I faced same issue and was unable to figure out the cause, so i tried the Re-installation of IM itself which helped me to import around 3000 records in one shot which gave me error before.
Thanks,
Praveen
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (