Sap PI Rfc to Jdbc(Sqlserver)

[Former Member]

Hello,

I am new to Sap PI. Version is Sap PI 7.3

After creating  Rfc destination in sm59 and config the business system I am getting a the following message.

Have checked the parameters.

Program id created name same as in PI.

Scenario is Rfc to sqlserver.

sqlsever.jar has been installed by basis.

Abap ECC end :

Commit fault: com.sap.aii.adapter.rfc.afcommunication.RfcAFWException: lo.

PI end :

Database not recognised error.

How to check this scenarios. Kindly help. Have checked many links in sdn for the same

and done the recommendation.

Thanks in advance

Regards

Sharada

[Former Member]

Hi,

Thanks for the response.

Rajesh => Ping error gives Could not open jdbc:microsoft:sqlserver.

                 XPI instector tool will check

                 from sdn the sqlserver.jar has been installed . where to check for the

                 connection string as per sdn given .

As we are in the installation stage => configuration in SAP Pi is done.

Is there any steps to be done in development application server as

the RFC is not working.

Just put sldcheck in ECC and gave the following error.

ECC => sldcheck

Exchange Infrastructure: Test LCR Connection

Communication mode: RFC + HTTP (deprecated)

Properties of RFC destination SAPSLDAPI
  RFC host:
%%RFCSERVER%%
  program id:      RFCSAP2
  gateway host:
pidevl
  gateway service: sapgw00

Testing the RFC connection to the SLD java client...
RFC ping returned exception with message:
Error when opening an RFC connection (CPIC-CALL: 'ThSAPOCMIN

Summary: Connection to SLD does not work
=> Check SLD function and configurations

In sap pi the sldcheck worked fine.

Summary: Connection to SLD works correctly

How to check this? Am I checking the right way.

Regards

Sharada

[iaki_vila]

Hi Sharada,

The problem could be with the program id registration, check Shabarish Vijayakumar's blog

Also this thread has several tips to try with the configuration.

Regards.

[Former Member]

Hi

Are you trying to connect to an external SQL Server Database from your SAP PI system.,,

Please see the following link : SAP PI 7.1 - Communication Channel error | SCN

Thanks

Rishi

[Former Member]

Hi

Please check the RFC and JDBC communication channel in the runtime workbench and see the error message in the log.

Please provide us the screen shot if possible so that we can help you better.

Check this document

http://saptechnical.com/Tutorials/XI/RFC2JDBC/Index.htm

[Former Member]

Hi,

Check the status of the Receiver Communication channel and also i think you can do a ping on channel level which provides the status of the connection...

Also if possible install the XPI Inspector tool which can be helpful to generate/anlayze the error logs...

Search SDN on how to install the same.

As I understood that data reached to PI and failed in PI due to Sql Server connection issue...you need to fix the driver installation/ connection issue..

Also Check the credentials provided are correct..

HTH

Rajesh