November 14, 2011, 04:36 PM
sarma_433DataMigrator -- Error: Disconnect (NGH_REMOTE_ERROR)
Hi,
I am getting the following exception while trying to extract data from SAP in DM 7.7.02M,
Error: Disconnect (NGH_REMOTE_ERROR) received from server
SQLCODE IS -1 (HEX: FFFFFFFF)
: Server name is xxx.
SQL OPEN CURSOR ERROR. : SQLIN
It looks like its an issue with size of data (500 bytes * 2.2 M rows), when I try to extract few columns (50 bytes * 2.2 M rows) it is working fine,
So, want to find out how to get rid off this size limitation?, any help would be appreciated.
Thanks,
Srini
November 15, 2011, 10:45 AM
ClifI checked with the Product Manager for SAP. He suggests the first thing to look for in long running queries or ones that return a large answer set is that the default timeout is exceeded. Normally in SAP the it's 600 seconds. If that's the case check for the existence of file rfc*.trc or dev_rfc.trc. They will provide the SAP event that may have caused the disconnect.
If that's not it please open a hottrack case, start the server with traces, and upload a full savediag package.
November 16, 2011, 01:14 PM
sarma_433quote:
the
Hi,
it didn't getnerate any dev_rfc file under SAPSDK folder, and the flow is failing with in few mins only, so its something to do with size of data,
anyways...we've opened a case for the same and we'd be uploading the traces/savediag to case.
Srini