cancel
Showing results for 
Search instead for 
Did you mean: 

Required JAR's for developing custom adapter modules for PI 7.31 SP 09

Former Member
0 Kudos

Hello experts,

I have a new development wherein i have to consume .xlsx files in PI 7.31

i have gone through a lot of blogs but did not find any relevant JAR's specially for PI 7.31, I am planning  to go for custom module development for conversion of .xlsx file into xml


so need your help for finding the JAR's for PI 7.31 and also some custom JAVA source code for conversion of excel spreadsheet into XML.


Regards,

Sushant.Shinde

Accepted Solutions (1)

Accepted Solutions (1)

iaki_vila
Active Contributor
0 Kudos

Hi Sushant,

If you have the SAP Netweaver Developer Studio, for your PI and SP version, you will have the libraries. Check this link: NWDS Download Links - Java Development - SCN Wiki

Regards.

Former Member
0 Kudos

Hi Inaki,

you mean to say that for every PI version we have a subsequent NWDS version ???

please correct me if i am wrong

and also if i download the version compatible with my PI version, i would get the needed libraries??

presently, i have a java source code and the PI jar's and i am using the traditional way to develop a module in NWDS, so by installing this new version of NWDS, do you mean to say the i dont have to search for the JAR's in my PI OS level???

eagerly waitin for your reply

thanks & regards,

sushant

engswee
Active Contributor
0 Kudos

Hi Sushant

If you are on PI 7.31, then you should use NWDS 7.31 - in general you should have the same SP and patch level if possible.

If you are on NWDS 7.31, the JAR files should already be bundled in, so you don't need to search and extract them from PI OS level.

Check out Anand's reply on the following thread

Issue in Excel to XML Conversion

Rgds

Eng Swee

iaki_vila
Active Contributor
0 Kudos

Hi Sushant,

AFAIK you can download NWDS and all the external features in one page:https://nwds.sap.com/swdc/downloads/updates/netweaver/nwds/nw/731/index.html

Later you will need to add the libraries in your project.

Regards.

Answers (2)

Answers (2)

jyothi_anagani
Active Contributor
0 Kudos

Hi Sushanth,

Please follow this blog for converting excel file to xml file.

http://www.saptechnical.com/Tutorials/XI/Adapter/Index.htm

You need these jar files

aii_af_mp.jar à the interface       Module
aii_af_ms_api.jar       à  Dealing with payload and attachment
aii_af_trace.jar à Writing Trace
aii_af_svc.jar à Adapter Services
aii_af_cpa.jar à Reading Channel Entries
aii_af_ms_spi.jar
aii_af_cci.jar          
Please let us know if you need more details.   
Thanks
Jyothi A
Former Member
0 Kudos

hi Jyothi,

i cant find these jar's in the PI OS level, according to my knowledge these jar's are for PI 7.1 or lesser versions, i have searched each and every folder in PI for the above mentioned jar files can't find them

If you can provide me the path for the files for PI 7.31 version, it would be of great help

Thanks & Regards,

Sushant

jyothi_anagani
Active Contributor
Former Member
0 Kudos

Hi Jyothi,

Thanks for the above link.

not at all familiar with ABAP coding, so out of my scope an i have full access to my server level file, so the above code not actually needed for me.

really thankful to you for the help, but still stuck up in finding some classes

Former Member
0 Kudos

Hi Jyothi,

I have developed a custom adapter module to read excel file and deployed it on my server.

I have mentioned below parameters in sender communication channel,

but i am stuckup with the following error.

Error: com.sap.engine.services.jndi.persistent.exceptions720.NameNotFoundException: Path to object does not exist. First missing component is [XLModule_EAR] the whole lookup name is [localEJBS/sap.com/XLModule_EAR/XLModule]

i have created the following objects in NWDS:

Package : com.ril

Project : XLModule_EAR

Enterprise bean and class name : XLModule

please let me know the parameters maintained in module tab of the communication channel level were correct or not.

Regards

Sushant

vicky20691
Active Contributor
0 Kudos

Hi Sushant,

  1. com.sap.aii.af.lib.mod.jar
  2. sap.com~tc~logging~java~impl.jar
  3. com.sap.aii.af.svc_api.jar
  4. com.sap.aii.af.cpa.svc_api.jar
  5. com.sap.aii.af.ms.ifc_api.jar

These are jar files for PI 7.3 and higher. Except these you have to use the jars specific to your code.

Now regarding your error-

You remember a place where you would have given JNDI name in NWDS.

Suppose your JNDI name is "XLModule"

Then in the channel please use just "localejbs/XLModule"... i.e. localejbs/<JNDI Name>

Please try this, it will work

Regards,

Vikas Kumar Singh

Former Member
0 Kudos

Hi Vikas,

I have followed this document

we have tried the same thing  and ending up with the same error, can you tell me the steps to be performed in NWDS orally and also the module key value to be maintained against the module parameter?

regards

Sushant

vicky20691
Active Contributor
0 Kudos

Hi sushant,

The module key seems correct ffor you. But the blog you shared is cozy. I developed 4 adapter modules using a document. Please refer that.

And NWDS EHP1 is available you can use that to be perfectly sure on compatibility.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0b39e65-981e-2b10-1c9c-fc3f8e674...

use the above document to verify the steps you followed-

Please provide following screenshots

NWA->configuration->infrastructure->Application Modules-> and search for *xlmodule*

if you find your module then click on it and at the bottom there will be a window with JNDI Name. Share that JNDI name and use that JNDI name in your Module. (localejbs/JNDIName).

Also go to NWA->TroubleShooting-> JNDI Browser and see where is your Adapter module situated. I mean under which directory. Either directly inside root/localejbs/ or root/localejbs/sap.com.

Please verify your steps according to that and redeploy and share result.

and Go to NWA- Site Map-> find Start & Stop

In that go to Java Applicaitons Tab and search for your module. It must be started. If it is stopped try starting it.

Regards,

Vikas

Former Member
0 Kudos

Hi Vikas,

I have checked all the paths and everything seems to be fine.

Now please find the error description as shown below.

I have downloaded .jxl jar from web/internet. I think the problem is in SAP PI server, system is not able to find the location of jxl jar. So please let me know where should i place this jar file manually on SAP PI server(because rest of the jar files were downloaded from native PI server OS level  itself)

Regards

Sushant

adityavempati
Participant
0 Kudos