cancel
Showing results for 
Search instead for 
Did you mean: 

Doubts in SAP PI 7.3

Former Member
0 Kudos

Hi all

Very happy new year.

Please send me how to  do JDBC to SAP PI and vice versa.

I  have searched and found many documents on 7.1 please help on SAP PI 7.3.

Urgent required.

Thanks in Advance

Regards

Sharada

Accepted Solutions (0)

Answers (9)

Answers (9)

Former Member
0 Kudos

Hi,

In our scenario wish to connect to Sql server from PI.

Wish to get some links for connection to sql server .

Regards

Sharada


former_member184720
Active Contributor
0 Kudos
marksmyth
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Sharada

We expect that you can use the search functionality to find these links yourself. There are numerous examples available and a quick search will return these to you. If you have specific questions please post on the forum.

This thread will be locked.

Regards

Moderator

Former Member
0 Kudos


Hello ,

The connection error solved after activate the RFC in sender channel.

Have wriiten a call function in abap as

CALL FUNCTION 'ZTEST' in background task DESTINATION 'RFC2JDBC'

When I am running the abap code after completing for sending data from R3 to JDBC  in SM58 this error is coming.

The status message is given as follows.

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

For adapter checking in SAP PI what tcodes to be used for this particular error.

Thanks in Advance

Sharada

Former Member
0 Kudos

Hi,

Did you registered the business system of ECC in PI via SLD or created the business service ...

if you used business service then check the adapter specific identifiers of the service contains the relevant systems details of ECC...

For monitoring the Channels in PI go to you configuration and monitoring link in PI and there select communication channel monitoring and check for your channel state...

HTH

Rajesh

Former Member
0 Kudos

Hi,

1.Created a business system .

   Host name added in SAP R3 for sql server with support of Basis.

2.While checking in Monitoring in PI in receiver

Monitoring in ping of adapter engine getting

an error in

Database connectivity test .:Could not open connection jdbc:microsoft.sqlserver://<hostname> : <Portname> ;DatabaseName=test.

3.RFC_SEND_communication channal

                     Gateway test - no error

                      metadata repository - no error

                     mock message send  - no error

                       *Interface metadata availability test - (Error ) No bindings found

How to check if the sqlserver driver is installed or JDBCODBC driver is installed properly.

Regards

Sharada

Bhargavakrishna
Active Contributor
0 Kudos

Hi Prabhaker,

Go through the below link to check the JDBC drivers deployed properly  or not?

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/8000cffc-6b92-2d10-3493-f2ac13992...

You should download the drivers which are given for that particular database version.

If it the drivers are properly configured, ask your basis team to ping the JDBC server from the server.

check whether it is working or not?

Also check if any firewalls are blocking the connection..

Regards

Bhargava krishna

former_member184720
Active Contributor
0 Kudos

Hi Sharada -

SAP provides an ear file to do such validations you just need to deploy an EAR file "FTP_JDBC_ConnectionValidation_731.EAR"

Please refer to the below note  for process steps..

1085539 - XI JDBC/FTP connection Test and XML Validation Application

After the deployment check the below blog.

http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/01/18/michals-pi-tips-3-ways-to-check-a...

marksmyth
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello Sharada,

Perhaps you are new to the SCN forums? Please familiarise yourself with the forum Rules of Engagement.

Regards

Moderator 

Former Member
0 Kudos

thanks mr Amit Srivastava

Former Member
0 Kudos

Thanks Mr Rajesh pasupala.

Got stuck in creating the TCP/IP connection in SM59

Error

Logon Connection Error

Error Details Error when opening an RFC connection (CPIC-CALL: 'ThSAPOCMINIT' : cmRc=2 thRc=67

Error Details ERROR: program ZPRODTOJDBCSH not registered

Error Details LOCATION: SAP-Gateway on host bidevl / sapgw00

Error Details DETAIL: TP ZPRODTOJDBCSH not registered

Error Details COMPONENT: SAP-Gateway

Error Details COUNTER: 1100

Error Details MODULE: gwr3cpic.c

Error Details LINE: 1833

Error Details RETURN CODE: 679

Error Details SUBRC: 0

Error Details RELEASE: 720

Error Details TIME: Thu Jan 16 11:47:30 2014

Error Details VERSION: 2

Kindly help

Former Member
0 Kudos

Hello,

Once you create the TCP/IP destination with program id...dont test it unless the same program id has been configured in the RFC sender channel in PI System...

Once you activate the RFC sender channel then test the RFC destination....connection should work that time... if require more info on this advice you to search on SDN for configuring the same...

HTH

Rajesh

Former Member
0 Kudos

Thanks Mr Rajesh pasupala.

Got stuck in creating the TCP/IP connection in SM59

Error

Logon Connection Error

Error Details Error when opening an RFC connection (CPIC-CALL: 'ThSAPOCMINIT' : cmRc=2 thRc=67

Error Details ERROR: program ZPRODTOJDBCSH not registered

Error Details LOCATION: SAP-Gateway on host bidevl / sapgw00

Error Details DETAIL: TP ZPRODTOJDBCSH not registered

Error Details COMPONENT: SAP-Gateway

Error Details COUNTER: 1100

Error Details MODULE: gwr3cpic.c

Error Details LINE: 1833

Error Details RETURN CODE: 679

Error Details SUBRC: 0

Error Details RELEASE: 720

Error Details TIME: Thu Jan 16 11:47:30 2014

Error Details VERSION: 2

Kindly help

Former Member
0 Kudos

Scenario is R3 to PI and PI to JDBC adapter to sql server  and vice versa


Former Member
0 Kudos

Hi,

you cannot get step by step guides for every version & scenario of PI here....

if you are using the single stack of PI then you can configure your scenario with ICO objects.

else same existing how to guides applies for your PI system also.

Start the scenario and post your queries if you get stuck up some one here can help you out..

Gud Luck

Rajesh

Former Member
0 Kudos

Hello,

Did u search SDN?

Sometime typing few letters can do wonders for u...

Redirecting...

Thanks

Amit Srivastava

Former Member
0 Kudos

Im new to SAP PI . So difference does matter can you give some step by step documents.


former_member184720
Active Contributor
0 Kudos

Hi Sharada - There are no major changes b/w 7.1 and 7.3

- confirms no changes b/w 7.1 and 7.3

Configuring the Sender JDBC Adapter - Advanced Adapter Engine - SAP Library

You can follow the documents on 7.1.

Let us know if you are facing any issue/ looking for specific requirement.

Have a look at the below notes..

1931899 - AEX/PI - Deploying external drivers with SUM

831162 - FAQ: XI 3.0 / PI 7.0 / PI 7.1 / PI 7.3 JDBC Adapter

Message was edited by: Hareesh Gampa