Michal Krawczyk

Michal Krawczyk

Consultant at BCC
EMail: This e-mail address is being protected from spambots. You need JavaScript enabled to view it
SDN Blogger Page

Mastering Idoc Business Scenarios with SAP NetWeaver PI

Log in to ask Michal a question below.

Comments (23)

Hi Michal,

We have following scenario; SAP -> PI -> Third party (TP). A trigger is sent from SAP which causes PI to get an URL from TP. PI should then this URL to get some data. The URL will change every 24 hours and hence cannot be maintained in CC.

Is this scenario possible in PI 71? If yes, kindly guide how to go about it?

Thanks,
Rahul

Hi Michal,

Is there any way in which we can download the value mappings from the RWB Cache that we had uploaded using ValuemappingReplication. I have searched SDN for this but all I could find was a how to upload the valu mapping table to XI but the not the reverse.

Thanks,
Merrilly

We are getting the following error on JDBC Receiver CC and it seems to be related to the number of records being inserted with Batch Mode on and sqlBinding=true, ANY HELP!

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error during batched statement execution: java.sql.BatchUpdateException: Io exception: Broken pipe

Hi Michal,

I am getting the following error.My scenario is File to Proxie.
My error -OUTBINDING -CO_TXT_OUTBINDING_ERROR
When i went to SXMB_moni in Soap header- main - the message is taking the value of Message Type and not message interface. I have developed the scenario in pi7.0 and now its upgarded to pi7.1.
Please let me know how to fix the issue.

Regards
Santosh

Hi Michal,
I noticed that this question has not yet been answered. Is this a common problem for 7.1? In 7.0 below, there were SP that were released. How about for 7.1?

HI Master Michal,

I am new for XI/PI, now I've got new development requirement, the client company want to inbound sales order/invoice from their customer's B2B web system, so I am wandering which way following will be best to implement this development?
1. B2B->XML->XI/PI(mapping)->IDOC->SAP
2. B2B->XML->SAP(Programming to convert XML into IDOC)
3. SAP(Webservice)->XI/PI->B2B
...

I did same development before without XI/PI system, that is, just read and convert the inbound XML into inbound IDOC, then process IDOC.

Best Regards

ABAPSydney

Hi Michal,
one question regarding Enhanced Interface Determination in PI 7.1.

I have a scenario where I want to split an outbound message with N entries into N messages of Service Interface SI_A and one message of service interface SI_B with N entries. Both will be routed to the same target system which is a file system. So in Mapping I specified the two target messages with an occurrence of 0...unbounded and 1. But in Interface Determination I can only specify one of the target service interfaces. When I specify both the mapping is executed two times which is not what I want.

I already tried it with only one Service Interface in the Interface Determination and it works since both messages are created by the mapping program. But thats not what it should be since I can not control the routing of the second message explicitely.

Thanks in advance,
Manfred

HI Experts

i have a problem with the SOAP adapter ..

If client sending soap file greater than 100 kb, then XI is not able to process the file. if the file size is less than 100 kb (ex 6 kb etc .. ) able to pick up the file and processed successfully.

I would appreciate if you provide the solution ..

for your reference, this is the log file from the client system

Stack Trace:
org.apache.commons.httpclient.NoHttpResponseException: The server agwp1.pg.com failed to respond
at org.apache.commons.httpclient.HttpMethodBase.readStatusLine(HttpMethodBase.java:1835)
at org.apache.commons.httpclient.HttpMethodBase.readResponse(HttpMethodBase.java:1590)
at org.apache.commons.httpclient.HttpMethodBase.execute(HttpMethodBase.java:995)
at org.apache.commons.httpclient.HttpMethodDirector.executeWithRetry(HttpMethodDirector.java:397)
at org.apache.commons.httpclient.HttpMethodDirector.executeMethod(HttpMethodDirector.java:170)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:396)
at org.apache.commons.httpclient.HttpClient.executeMethod(HttpClient.java:324)
at com.xx.igcs.ws.client.SOAPSender.sendMessage(SOAPSender.java:67)
at com.pg.igcs.ws.client.DefaultWSClient.seperatedSendMessages(DefaultWSClient.java:264)
at com.xx.igcs.sap.ws.client.annasui.AnnasuiOrderWSClient.sendOrders(AnnasuiOrderWSClient.java:58)
at com.xx.igcs.sap.ws.client.SapMessagesSendJobDetail.sendAnnasuiReplenishmentMessages(SapMessagesSendJobDetail.java:64)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:276)
at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:260)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:525)

Hi Micheal and experts,

I need your thoughts and help on the scenario listed below.

We have PI 7.1 with local SLD (7.1) which connects to a central SLD (7.0) and syncs up the content from Central.

Is the following assumption correct for the SLD connections?

RZ70 - Central SLD
SLDAPICUST - Local SLD
SLD Data Supplier Configuration: SLD Data Supplier in NWA - Central
com.sap.aii.connect.cr.name in Exchange Profile - Local
com.sap.aii.connect.landscape.name in Exchange Profile - Local

Regards,
PP

Hi Michal,

when I try to launch on Enterprise Services Builder , it gives me following error. Unable to launch the application , in details it show's
jar resources in jnlp file are not signed by same certificate

Regards,
Amar Yadav

Need to execute stored procedures against a DB2 database on a z/OS platform through a Java program. Would like to call the java program from XI/PI, is this possible, if so, how?

Is there a DB2-adapter in order to permitt direct connection between DB2 and XI/PI?

Is it possible to use Java proxies in order to execute the stored procedures, if so how?

Hello,

Can you tell me the XI Content for FSCM-Credit Management for PI7.0?

I have downloaded the content SAP APPL 600 from service market place and i am getting the below error while importing in to the Integration Repository.

_____________________________________________________________________
The SQL statement "INSERT INTO "XI_REPTPINFO" ("TRANSPORTID","IMPORTUSER","IMPORTDATE","EXPORTUSER","EXPORTDATE","

CREATIONUSER","CREATIONDATE","ANONYMIZED","SOURCESYSTEM","SOURCETYPE","CONTENTTYPE","NUMIMPORTOBJS",

"SPNR","SWCV","VERSIONSETID","ORGFILENAME","TRANSPORTFILENAME","FILESIZE","NUMFILEOBJS","EXPORTID","TRANSPORTTYPE",

"TRANSPORTDIRECTION","ISSYSTEMCOPY","ISDELTATP","ISMIGTP","XIRELEASE","XISP","LANGUAGES","TPSTATE","ISSNAPSHOT","VERSIONSETTYPE",

"TPREQUESTID","TPREQUESTCAPTION") VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" contains the semantics error[s]: - 1:471 - the column >>TPREQUESTIDTPREQUESTCAPTION the current scope

_____________________________________________________________________________

why i am getting this error ?Can you help me to fix this?

Thanks,
Lakshmi.

HI,

Our client is using additional adapter functions, which they deployed packages in module processor ofadapter libaries and using it in the adapter by module tab.Where can i see these functionalities in the adapters,i just imagine that in these way the adapter is deploying as i above mentioned, if u provide me the proper way where to deploy the functionalities and how we can see these additional functionalities .

Hi,
I am trying to call an SQL SERVER 2005 web service via the PI 7.1 SOAP adapter. I am getting an HTTP 505 indicating an HTTP Version mismatch. I am able to force an RFC connection to HTTP 1.1 and connect but that does me no good for the SOAP Adapter. Is there some way to get the SOAP adapter to use HTTP 1.1? Surely someone in the world has worked out how to call a SQL Server WS?
Thanks,
Stephen

Hi Michal,

I have a requirement in which JDBC query result will be mapped to the target flat file. For some of the target fields, the data is coming from JDE tables as a result of Join query (say for example by joining tables A & B). For some of the fields, the data is coming as a result of some different Join query (say for example, by joining tables C & D). For some fields, the data is coming from only onle table(For example, A.Element is mapped).

How do we achieve this in PI????

Regards,
Jamuna

Hi Michal,

We are working on JDBC-JDBC scenario and the flow is as below. Source is ORACLE and Target is SQL SERVER.

We need to pick up 2000 records from Source . PI should split them ito 4 batches of 500 each and should insert in SQL DB.While inserting the records, if there are any errors, those records should sent back to Source again. It is Synchronous scenario.

1) But as far as I know Batch Processing mode, INSERT option cannot be used.(From SAP help)
2) Will the connection break if we are sending the error records back to sender.

Any pointers would be helpful.

Regards,
Srinivas.M

Hi Michal,

I just finished an installation of PI 7.1, SP07. Everything looks fine, except when I want to perform a test scenario.
I can see my operation mapping in the value list of my interface determination, but when I select it, nothing happens.
Do you have any idea what might cause this? I already tried a different JAVA runtime enviroment, checked and refreshed my caches, rebuilding the scenario, restarting the SAP server...

Greetings,
Iddo

Hi Sobha,

this is possible in standard with multi mapping message splits
if you use java adapters on tobh ends

Regards,
Michal Krawczyk

Hi,

Have migrated the objects from PI 7.0 to PI 7.10 and got error as
" Error: com.sap.engine.interfaces.messaging.api.exception.ConfigException: Some of the IS access information is not available. SLDAccess property may be set to true, but SLD is not available."

Checked: SLDAPICUST - Successful
SLDCHECK - Successful
SLD - Running
File adapter - Running fine.

Thanks in advance,
Sunil.

I have a requirement in which a flat file(xml) should be generated for each person_name present in the department

for eg if i have 5 person_name in one department, at the receiver 5 flat files should be created.

Is it possible to create multiple files at receiver by splitting the target message????

You can also check out the article at http://mypigenie.com/ask-an-expert/71 on some of the benefits of XI

Hi Madhu, PI (old name XI) is a middleware from SAP (the only middleware from SAP except old business connector). Since it's made by SAP it supports many SAP specific things: - it's based on web application server (the same one on which your SAP ERP is based) - it supports native XML connectivity to all other SAP components via so called ABAP proxies - you can even create mappings in an ABAP language - so SAP's language - PI is an open platform supporting various standards like WSDL/SOAP/JDBC etc. - PI serves as an SOA platform for the whole SAP landscape - so it your customer thinks about SOA then also PI (7.1) would be a good choice hope this helps a little bit :) Regards, Michal Krawczyk

Hi Michal,

Can you please brief me in what way PI is more when compared with Seebeyond.
and i need to present to my customer.it will be a great thing if you can help in doing so...........

Thanks,
Madhu

yvComment v.1.19.2

Login

Main Menu

FAQ Menu

Michal Krawczyk