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