cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC driver installation EHP1 PI 7.1

Former Member
0 Kudos

Hi Folks,

When I am trying to install JDBC driver for my PI system I am getting status "REVISE" in JSPM. My data base is MS sql 2008.

I have donwloaded the  JDBC.JAR file of version 3.0 rom microsoft side. I have updated LIB with the JAR file and updated the path in Provider.xml  for 

com.sap.aii.adapter.lib.sda that is from the export CD used during installation.

When i am trying to deploy it in force mode in JSPM I am getting the status "REVISE".

Kindly suggest how to proceed further.

Regards,

Satyabrat

 

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Satyabrat

Try this method of adding a JDBC driver.

Login to NWA

Configuration Management --> Infrastructure --> Application Resources --> Create New resource

You can create a new JDBC driver and upload your driver files directly from here. No need to use JSPM. Uploading a new JDBC driver via NWA is a very easy. Let me know if you run into any issues.

also there is a note specific to SQL server.

639702 JDBC Driver for Microsoft SQL Server

Instead of using JSPM you can also use Console Administrator 

Regards

Amit Padmawar

Former Member
0 Kudos

Hi Amit,

I have tried with NWA, but the status is showing unknown. it is grey status after adding the file. How to proceed now?

Regards,

Satyabrat

Former Member
0 Kudos

your driver files "sapjdbc.jar" will be located in one of there directories. Use this file and deploy using the method which i suggested above.

    • (SAP NetWeaver'04, Java:) usr\sap\<SAP SID>\JC<InstanceNumber>\j2ee\jdbc
    • (SAP NetWeaver'04, ABAP+Java:) usr\sap\<SAPSID>\DVEBMGS<InstanceNumber>\j2ee\jdbc
    • (SAP NetWeaver 7.0 and higher:) usr\sap\<SAPSID>\SYS\exe\<NUC|UC>\Platform\mssjdbc

If you are still having issues , please share the screen prints.

Regards

Amit

Former Member
0 Kudos

Thanks All for your inputs..

The issue is resolved after upgrade of JSPM.

Regards,

Satyabrat

Answers (1)

Answers (1)

david_liu1
Advisor
Advisor
0 Kudos

Hello,

Regarding your issue, please find the required information specified below.

Please check the SAP note:

891895 JSPM: required disk space

You can find the following statement:
"NW 7.1 At least 2*S space is required under j2ee directory."

Please check if there is enough space available for patching the java stack.

Please change configuration and provide at least the double of the size of the patches in the stack as freespace under /usr/sap/<SID>.

Hope the above information assist you in resolving the issue.

Regards,

David

Former Member
0 Kudos

Hi David,

There is enough space in the directory.

Regards,

Satyabrat