RE: IDT Error when testing relational connection to SAP BW cube
the following error pop up when testing the relational connection to SAP BW cube..
com.sap.connectivity.cs.java.drivers.DBDError: [Data Federator Driver] [Server] [Connector ‘testSourceConnection1351056304611’] An error occurred while trying to ping the server: com.sap.conn.jco.JCoRuntimeException: (136) JCO_ERROR_ILLEGAL_STATE: JCo server is currently running. Current server state is DEAD.
Also i check the RFC destination in SM59, and get the following error when testing the connection:
Logon Connection Error
Error Details Error when opening an RFC connection (CPIC-CALL: ‘ThSAPOCMINIT’ : cmRc=2 thRc=67
Error Details ERROR: program DF_JCO_CNSSAPBOD_0 not registered
Error Details LOCATION: SAP-Gateway on host XXXXXX / sapgw00
Error Details DETAIL: TP DF_JCO_CNSSAPBOD_0 not registered
Error Details COMPONENT: SAP-Gateway
Error Details COUNTER: 5329
i just wondering whether i need to registeer the DF_JCO_CNSSAPBOD, but it is created automatically by Data federator.
any suggestions and idea ?
I would recommnend you to implement the following steps:
1. Insert the fully qualified domain name of the gateway server in the RFC Tcp/IP connection in SM59 in BW
2. Insert the fully qualified domain name of the gateway server in the hosts file of the BI 4.0 server
3. Restart the BI4.0 SIA