Microsoft Dynamics GP (Archived)

Integration Fails when . . .

(0) Share

Report

Posted on by Bill Campbell

We first encountered this problem when we were importing a CSV file of approx 8600 records.

We did the integration on the same workstation we have for years and until recently not encountered errors.

Error Message

The Following problem was encountered during destination uninitialization

The RPC server is unavailable. (Exception from HRESULT 0x800706BA)

Similar issue - larger value in the number of records in the import - same error message

https://community.dynamics.com/gp/f/32/t/127852.aspx

Our Solution

We first cut the number of lines on the CSV in half and that did not solve the problem.

We then cut the number in half again and we were able to run the import.

The difference it appears was the number of Integrations with Warnings
was dropped below 1,000.

In the first pass (all 8563 records) when it failed there were 1,729 Warnings

We have the number of errors and warnings set to 10,000 on each but yes the system still fails.

Wondering if there has been a resolution to this for the general release of the software.

We are running GP2013 and IM 12

*This post is locked for comments

All responses (9)

Answers (0)

Suggested answer

Frank Hamelly | MVP... 46,527 Super User 2025 Season 1 on at

Like (1)

Report

RE: Integration Fails when . . .

Bill, have a look at this blog post - gp2themax.blogspot.com/.../issue-with-integration-manager-and-new.html. I forgot I had written this. Old age is hell! :)
Bill Campbell 12 on at

Like (0)

Report

RE: Integration Fails when . . .

Thanks Tim - this problem was not there prior to the move to IM12 I know we would have heard about it long before now.

Funny part is as long as the data is small - no errors and clean - we get no issues and no warnings. Only with either large data, large errors or large warnings.
Bill Campbell 12 on at

Like (0)

Report

RE: Integration Fails when . . .

I am going to have a problem getting permission for an AP Clerk to access the SQL Server to run an application each week - that will not be an easy sell.

If this were a one time deal, maybe - but not as an ongoing integration.

Will review the notes from Mariano, however, it seems that he is discussing the 'multi' session problem.

I will update soon.
Tim W 2,925 on at

Like (0)

Report

RE: Integration Fails when . . .

Hi Bill,

Exact scenario for us on 2013R2 and IM12. We upgraded from 10 to 2013 in October and a couple months later tripped over this issue with IM12 whereas the GP10 IM handled the large file without issue.

It was platform independent in that server or multiple client same issue it was at about 1007 or so rows as I recall. We had a 10k file done as a refresh and it was painful to break it into 10 smaller files so we could process the file. It's rare for us to have this large an IM file so we've probably not pursued this with MSFT yet but I'd have to check with our support person.

You are not alone, there is a bug in IM12.

Best

Tim
Frank Hamelly | MVP... 46,527 Super User 2025 Season 1 on at

Like (0)

Report

RE: Integration Fails when . . .

Bill, I ran into a similar issue last year where my integration would run in about a 1,000 records and then fail. I discovered that I had to be on the SQL box itself running the integration to prevent the failure. Also, if you're running IM as a published app, that can cause issues as well - dynamicsgpblogster.wordpress.com/.../im-troubleshooting-rpc-errors-when-running-integration-manager
Bill Campbell 12 on at

Like (0)

Report

RE: Integration Fails when . . .

Additional Information

Here is a snap shot of the Integration Log for the last time we ran this IM. As you will see there are 3 simple errors as we work through the IM and then - BAM - at 4681 we get this error message and the resulting notes for the remaining 2,700 records.

Interesting to note, we changed the number of Fail and Warning to 10,000 each just to see if that was the cause and it changed nothing.

Question:

Is there a way to change the Timeout - if that is such a thing - for IM to make it wait longer before it fails? When we were first getting this situation I was thinking it was due to the large number of failed or warning messages we were piling into the Log - but, as you see before the 'failure' we had only 3 entries.
Bill Campbell 12 on at

Like (0)

Report

RE: Integration Fails when . . .

Frank that was one of the first things we thought of - but we were sure of the single instance from the start.

Thanks.
Frank Hamelly | MVP... 46,527 Super User 2025 Season 1 on at

Like (0)

Report

RE: Integration Fails when . . .

The RPC server error typically is caused by more than one instance of GP running on the machine you're trying to run IM from. Check Task Manager and kill any GP sessions other than the one you're importing to.
Bill Campbell 12 on at

Like (0)

Report

RE: Integration Fails when . . .

Should also point out that we can duplicate this error from three different workstations, and two different servers - one the SQL Server and the other the Application server when I connect remotely.

Not likely a network connection matter or a specific workstation matter.