DSXchange

We regularly pulled data from BW 4.2 to Datastage 7.1 and last 6 months suddenly gives following problem when we pulled data from BW.

We stop and start ref process then run the jobs, sometimes jobs run perfectly and sometimes not run.


1. ERROR RfcReceive() rc=3 (loadBW.c): SYSTEM_FAILURE

2. ERROR: Sending Last Packet In Close()
RFC_ERROR_SYSTEM_FAILURE: Syntax error in program GP3SBQ53HZH9P39G8YC8GFH3X8Z . (group 104)


Pls provide solution.


Regards

Vikas

Looks like the local or remote RFC system is complaining due to some reason. I found some information on the net that might help you.

RFC_SYS_EXCEPTION means that the local or remote RFC system has raised an exception. Also '*exception' points to the name of the exception. The connection was automatically closed by the system and RfcLastError may give more information on the origin of the error. Two exceptions may occur now: SYSTEM_FAILURE and COMMUNICATION_FAILURE

And you are getting SYSTEM_FAILURE. I am suspecting its not necessarily a datastage issue. Its the BW part of the process. Maybe the system is getting overloaded. The connection is getting closed for some odd reason. If you want more info on the error message, google RfcReceive(). You will find some pages that might help you pin point the problem.
Regards,