Skip to Content

I am writing this blog as we faced multiple issues while deploying JDBC driver in our PI system through SUM and finally NWDS made it easy. I hope it will be useful for others as well.

Our requirement was to connect our PI system to SQL 2012 DB used for staging tables. Major steps involved in this are- Downloading JDBC driver from Microsoft site, Bundling SCA file and Deploying through NWDS.

1. Download sqljdbc4.jar from Microsoft.

http://www.microsoft.com/en-in/download/details.aspx?id=11774

2. Download  SAPXI3RDPARTY07_0-10008107.SCA  (SCA file for NW 7.3) from SAP  service market place, depending on your PI system version.

TIP : Use ‘Search for Software’ in Support packages and patches.

3. Rename SAPXI3RDPARTY07_0-10008107.SCA to SAPXI3RDPARTY07_0-10008107.zip.

4. Open with winzip

S1.jpg

Double click on DEPLOYARCHIVES folder.

S2.jpg

Double click on com.sap.aii.adapter.lib.sda and again open with winzip.

S3.jpg

Click on lib and then Add

S5.jpg

Add sqljdbc4.jar downloaded from Microsoft site

S6.jpg

S7.jpg

Click on OK

Now click on server

S8.jpg

Right click on  provider.xml and edit

S9.jpg

Add the sqljdbc4 jar entry in provider.xml as per screen shot.

S11.jpg

Save this file and close Winzip(where you have opened com.sap.a11.adapter.lib.sda), it will ask to save changes made. Click on YES and then OK.

S12.jpg

S13.jpg

5. Rename SAPXI3RDPARTY07_0-10008107.zip to SAPXI3RDPARTY07_0-10008107.SCA

6. Now open NWDS.

Click on window and click on preference.

S14.jpg

Click on SAP java and click on Add

S15.jpg

Add SAP PI system by providing below details-

S16.jpg

Click OK.

It may take 1 to 5 minutes for adding system in NWDS, it will asks for administrator user and password. Once added close Preferences window.

Now Click on Windows and open Perspective and Other.

S18.jpg

S19.jpg

Select deployment and click on OK.

S20.jpg

Click on import.

Select File System and click on Finish.

S21.jpg

Select SCA file which we created and click on Open.

S22.jpg

7. Select File and click on Start

S23.jpg

Once imported successfully, it will give Import successful message.

————————————————————————————————————————————————————————————————————————-

You may face below error or issues while deploying sca file through NWDS.

1. While adding PI system in NWDS, it is asking for operating system user and password

– Refer SAP Note#1834579 and make changes accordingly.

2. Got error as JVM vendor is not supported.

Er1.jpg

– You can ignore this error or Install JDK 1.6 patch 26 or above. If you install it then restart NWDS and select javaw.exe from proper path.

3. If you are using Windows 7 64bit and get error ‘JVM terminated. Exit code =-1’ on starting NWDS, as below-

Er2.jpg

– Refer SAP note#1566977 – NWDS on Windows 7 – Solution is to install 32bit JDK.

4. Deployment failed with error : [ERROR CODE DPL.DCAPI.1031] AllItemsAlreadyDeployedValidationException. Reason: ASJ.dpl_dc.003456 All batch items are marked as AlreadyDeployed because of Version check.

– In NWDS before starting deployment of file, click on Settings and change below setting, it is for force deployment which we use while deploying through Telnet/SUM.

Er3.jpg

Important SAP notes and KBA on this topic-

SAP KBA 1829286 – PI: How to check which drivers are installed for the JMS and JDBC Adapters

SAP KBA 1770206 PI: How to extract the archive for deploying 3rd party drivers

SAP KBA 1770304 PI: How to prepare the com.sap.aii.adapter.lib.sda for deployment

SAP KBA 1770384 Cannot deploy the archive com.sap.aii.adapter.lib.sda to PI

SAP KBA 1816456 PI: Deploying new JMS/JDBC drivers overwrites existing deployed drivers

SAP note 1138877 How to Deploy External Drivers JDBC/JMS Adapters

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

  1. Pablo Lopez

    Hi,

    For JDBC adapter, from PI 7.31, deploying through NWDS or SDA files is no longer needed.

    You can now deploy using NWA–> Configuration –> Infrastructure –> Application Resources –> Create New Resource –> Deploy New JDBC Driver.

     

    Regards,

    Pablo

    (1) 

Leave a Reply