How to deploy JDBC/JMS Drivers in SAP PI 7.3 EHP1 AS Java

[Former Member]

Dear All,

Even after extensive search, i couldn't find a way to deploy JDBC/JMS drivers in SAP PI 7.31 AS Java system.

I basically want to deploy oracle jdbc driver. The document says to include the ojdbc6.jar in com.sap.aii.adapter.lib.sda and update provider.xml. And then use JSPM for deployment.

Now I found the com.sap.aii.adapter.lib.sda file in SAPXI3RDPARTY01_0.SCA. I extracted com.sap.aii.adapter.lib.sdato include ojdbc6.jar and to update provider.xml. Now when I try to use JSPM, it clearly says that with this version of SAP PI i.e. 7.31 you can not use JSPM and instead you need to use SUM.

Can someone please tell how to user SUM for this update? Even help.sap.com asks to execute the old process.

Thanks,

Shreyansh

[Former Member]

Hi Shreyansh,

Any solution?

we have the same problem!!!

Regards.

[Former Member]

I faced the same problem while trying to update the JDBC driver. I could solve it using a work-around solution below. There should be a proper way to do this, but I don't know what it is.

Problem - SUM doesn't seem to deploy a component if the component with same version number is already deployed.

Work around solution - Update the version numbers in MANIFEST.MF and SAP_MANIFEST.MF (part of com.sap.aii.adapter.lib.sda). There is one version number in MANIFEST.MF and two version numbers in SAP_MANIFEST.MF.

Example - Version number in MANIFEST.MF -

Implementation-Version: 7.3107.20130802123808.0000

changed to -

Implementation-Version: 7.3107.20131116123808.0000

Regards,

Sameej

[Former Member]

Hi Sameej,

We can solve too, but we had 7.3101...  version and we can update to 7.3106 without problems...

It's good to know your workaround.

Regards.

[former_member211162]

Hi Yassir,

How were you able to solve it without Sameej's work around? Are you referring to solving as deploying the com.sap.aii.adapter.lib.sda via SUM or deploying the whole SAPXI3RDPARTY08_0-10009499.SCA?  The reason being, I am able to update the .sda's that are part of the SAPXI3RDPARTY08_0-10009499.SCA but the actual version of the SCA doesn't get updated if I go to system info.

Thanks in advance.

Thanks

Dhee

[Former Member]

Hi Dheerendra,

on this post i describe how i did.

Regards.

[former_member211162]

Thanks Yassir.

[Former Member]

Can you solve it?

[former_member211162]

Yes, but in my case it is the JMS adapter with the wlfullclient.jar and its on UNix.

Thanks

[Former Member]

Hi Dheerendra,

I am trying to Install JDBC driver using JSPM but its show error like

<component location="\\xxxxxx\sapmnt\trans\EPS\in\com.sap.aii.adapter.lib.sda" status="ABORTED" dplorder="0" description="1. Runtime name of component [sap.com~com.sap.aii.adapter.lib] is changed from [sap.com~SAP-XI3RDPARTY~com.sap.aii.adapter.lib] to [com.sap.aii.adapter.lib]. Please, first remove the DC and then proceed with deployment" vendor="sap.com" name="com.sap.aii.adapter.lib" csn="BC-XI-CON-AFW" type="DC" version="7.3001.20110318104827.0001" size="0">

I have also searched for sap.com~SAP-XI3RDPARTY~com.sap.aii.adapter.lib but nothing found. Please suggest how to remove DC?

In provider.xml wrongly I change provider property from sap.com to sap.com/SAP-XI3RDPARTY and deploy it. But when I am trying to deploy it with sap.com then it's showing me the error.

[Former Member]

Hi,

The following note explains why JSPM nor SUM can deploy the SAP-XI3RDPARTY SC

1401570 - PI Upgrade: SAP-XI3RDPARTY SC Version not updated

"Since customers deploy their own 3rd-party drivers with them, they must not be overwritten by during an update or upgrade. For this reason these Development Components (DCs) are handled in a special manner by SUM (Software Update Manager) and the version of SC SAP-XI3RDPARTY remains unchanged. Note that JSPM was replaced by SUM (see SAP note 1589311) and should not be used anymore."

In my case, I successfully deployed the SAPXI3RDPARTY12_0-10009499.SCA containing some IBM's MQ Server drivers following the note above mentioned:

Connect to your Engine with "telnet <host_name> <telnet_port>", where the telnet port is by default "5<system_number>08", e.g. 50008 for instance number 00. You can deploy the archives with command

DEPLOY <path>/SAPXI3RDPARTY.SCA

Regards,

Luis Clemente

[Former Member]

Hi Sameej,

I have able to deploy the JDBC Drivers using this workaround.

Thank you very much.

Thanks,

Prajwal

[Former Member]

Hi Shreyansh,

Did you get anywhere updating the JDBC driver with SUM. Can you please advise.

Regards

Kalyan

[Former Member]

Shreyansh,

You can JSPM by applying hot fix.

Regards,

Ashish

[Former Member]

Dear Ashish,

JSPM is not allowed to be used with SAP NW/PI 7.3 EHP1 AS JAVA platform. If we run the "go" script available under /usr/sap/<SID>/J00/j2ee/JSPM, it gives following message:

"Java Support Package Manager (JSPM) is no longer supported for this SAP NetWeaver release.

Use Software Update Manager (SUM) to perform this maintenance procedure."

Do you mean to say by applying some hotfix, we can make JSPM to work on this SAP NetWaver release? If so, please refer to some doc/discussion on how to apply this hotfix.

Regards,

Shreyansh

[Former Member]

Shreyanh,

You need to disucess arrd the same with your Basis ppl..We recently got AXIS adapter installed on PO box using JSPM hot fix.

Regards,

Ashish

[iaki_vila]

Hi Sheryanash,

I think you can start reading Boris Rubarth's blog about this tool http://scn.sap.com/community/it-management/alm/software-logistics/blog/2012/11/07/software-update-ma.... The blog provides the most important links about this new tool.

Regards.

[Former Member]

Hi Inaki,

I tried reading this blog, but unfortunately couldn't find exact information how to use SUM to deploy oracle jdbc driver on my SAP PI 7.31 AS Java platform.

I even tried using SUM with the option of "Manually Prepared directory" providing the location of updated com.sap.aii.adapter.lib.sda (with addition of ojdbc6.jar and additional entry in provider.xml). The entire process runs fine, but still not reflect the jar files under /usr/sap/<SID>/J00/j2ee/cluster/bin/ext/com.sap.aii.adapter.lib/lib folder.

Appreciate you provide a pointer to exact process.

Thanks!

[gagandeep_batra]

Hi Shah,

Did you check the following doc

http://scn.sap.com/docs/DOC-25113

or you can try to deploy using NWDS also:

http://scn.sap.com/community/pi-and-soa-middleware/blog/2011/06/08/pixi-nwds-not-only-for-java-devel...

Regards

gAgan