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 (40)

Hi Michal,
We have PI 7.0 SP 13 and currently use FTP for PI object transports. We are looking for a better method than FTP. Considering our version and SP level, what do you recommend out of the options listed below?
1. Stay with FTP
2. Implement CMS
3. Implement STMS (CTS). (I am not sure if this is even possible with our SP level)
4. Any Solution Manager based method?

I appreciate your help on this.

Thank you.

Dharmasiri Amith

Hi Michael,

I'm familiar with the PI communications channel External Control feature utilizing HTTP and XML to query status of, start and stop PI channels. Is there also a way to externally query channel properties e.g. JMS host, port and queue name, etc.?

External control seems of limited value if you can't also externally preview or confirm what it is you're controlling.

Thanks in advance!

Hi Michael,

I'm trying to get what event queue is all about and how it is useful and implemented in XI scenarios. Could you post your expert advice on this topic please?

Regards
Prabhu

Hi Michal,
We are testing a new JDBC Driver to connect to Data bases as being recommended by SAP,as far as i understood from my Basis consultors its using new SQLJDBC.Jar.I changed this in one communication channel to test and the interface worked as usual , the only thing which is bothering me before going ahead and changing all the interfaces is how can i be assured that the connection used the new driver libraries, is there any way to find a log where it says which .jar or driver CC used to connect.

Thanks in advance.

I am trying to use a Oracle function and created a structure of type : SQL_QUERY but cannot since my Oracle function has Boolean parameters I get the function to work correctly , but using SQL Developers Tools i noticed that declaring variables of type boolean and passing them in the Call to ORacle function I can successfully execute this function.

Hence want to know if we can make use of PLSQL commands like DECLARE .. BEGIN ..END to get the results from the table.

IF yes then how should the structure be framed as it returns a parameter back

Hi Michal, Is there any real use for the Alert Category objects available in the Integration Repository? Do these have any actual relationship to the alerts created in ALRTCATDEF or are they just for modelling? Thanks

Hi,

We have very high volume transactions with very tight SLAs. At the peak time, we have to process 90 inbound and 140 outbound IDOC based messages per second(on an average each idoc is 100k). I did some research and had discussions with SAP also. Seems like with some fine tuning and PI7.1 idoc packaging we will be able to achieve the required results. I am also put on a task to find out whether any clients use XI/PI for their application integration for a such high volume transactions. Any of you know any client names, I appreciate your help.

thanks..HP

Dear Gurus,
I am able to successfully login to ECC from ESR , but when I righ click on RFC and select import, it is going for ever without loading any Remote function modules, I did not see any errors, appreciate any immediate help.
Thanks.
Paul.

Hi,
my scenario is a jdbc to idoc using a java mapping. If I test the java mapping in the test tool of integration repository it produce all the segment that i have define in the mapping, but when i execute the interface and check the payload one segment is missing. Idoc is orders05. any idea???
kind regards.
Noelia

Hi Michal,
I am sending IDOC to WebService through PI. If my Web Service is down or the receiver side connection do not work properly then I need a mail notification.

could you please help me.

HI MIcheal/Experts,
I have configured an INtegration process in IR and can see that in SXI_CACHe with return code "0". But, i am not able to see the interfaces used in the Integration Process when it is imported into my INtegration Directory.Bcoz of this i am stuck with my BPM.
This is the first BPM implementaion in our PI7.1 server.Please suggest if any intial setups are required.
I have run "SWF_XI_CUSTOMIZING" tcode and all the nodes are in green.

Hi Michal.
I'm new in SAP PI 7.1 and i want create a home lab for myself practice.
I search in SAP Service MarketPlace and SDN.SAP.COM for a version to download of NetWeaver PI 7.1 but nothing appear for download PI. I send a email to SDN and SAP Service but until now i dont have a response.
Please tell me where i can find that for download and create my home lab.
Thanks in advance.
Patricio

hi michal,

i am new to xi, pleas send me some screen shots on sld page creation.
in ides server.
thanks and regards,
k.v.kumar

Hi Michal,

My scenario is a Mail to JDBC one.Incoming mail attachment contents needs to inserted into the database.Requirement over here is, I need to only process mails with single attachment.Incase multiple attachments are there, i need to reject the processing.I dont want to use a module adapter over here, rather i need to handle this in a java mapping.Any solution to this will be highly appreciable.

Thanks,
Shafeek

HI Michal,
We are capturing CX_AI_SYSTEM_FAULT exception, but i want to know how can we capture CX_ST_SERIALIZATION_ERROR error when we have field mismatch during XML transformation.I want to know which field had failed to transform and the value with which it failed?

Hi Michal,

I'm having a problem with RFC to JDBC scenario Asyc.
This appeared the following message in RWB:

Transmitting the message to endpoint connection using http://sdev-pi-01:50300/sap/xi/engine?type=entry JDBC_http: / / sap.com / xi / XI / System failed, due to: com.sap. aii.af.ra.ms.api.RecoverableException: Received HTTP response code 404: Not Found.

Could you give me a hand?

Thanks,

MBF

Hi,
I have a very simple file to file scenerio. In which I am trying to send a file from SAP system to some other system. I have configured everything including 1)FTP on my SAP system 2) sender and reciever communication channels 3) sender agreement, reciever agreement 4) interface determination 5)reciever determination.

The file is not getting transferred and when I am monitoring this by runtime workbench> component monitoring> adapter engine> communication channel monitoring, and when I search for my sender communication channel I get following errors:
Time Stamp Status Description
23.03.2010 17:04:42 Success Send text file "SAPLGCCNPPAYSLPTI20100220123456.TXT" from FTP server "172.17.102.197:\DATA\flat-file\CN\ABAP\202\IN\PAYSLIP", size 512 bytes with QoS EO
23.03.2010 17:04:42 Success Application attempting to send an XI message asynchronously using connection AFW.
23.03.2010 17:04:43 Error Returning to application. Exception: com.sap.aii.af.ra.ms.api.ConfigException: Some of the IS access information is not available. SLDAcess property may be set to true, but SLD is not available.
23.03.2010 17:04:43 Error Attempt to process file failed with com.sap.aii.af.ra.ms.api.ConfigException: Some of the IS access information is not available. SLDAcess property may be set to true, but SLD is not available.
23.03.2010 17:10:02 Success Send text file "SAPLGCCNPPAYSLPTI20100220123456.TXT" from FTP server "172.17.102.197:\DATA\flat-file\CN\ABAP\202\IN\PAYSLIP", size 512 bytes with QoS EO
23.03.2010 17:10:03 Success Application attempting to send an XI message asynchronously using connection AFW.
23.03.2010 17:10:05 Error Returning to application. Exception: com.sap.aii.af.ra.ms.api.ConfigException: Some of the IS access information is not available. SLDAcess property may be set to true, but SLD is not available.
23.03.2010 17:10:05 Error Attempt to process file failed with com.sap.aii.af.ra.ms.api.ConfigException: Some of the IS access information is not available. SLDAcess property may be set to true, but SLD is not available.
23.03.2010 17:20:02 Success Send text file "SAPLGCCNPPAYSLPTI20100220123456.TXT" from FTP server "172.17.102.197:\DATA\flat-file\CN\ABAP\202\IN\PAYSLIP", size 512 bytes with QoS EO
23.03.2010 17:20:02 Success Application attempting to send an XI message asynchronously using connection AFW.

Regards,
Lokesh

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