on 11-20-2006 5:31 AM
Hello Everyone,
We are facing a strange problem while running an <b>Integration Process</b>, <b>BPM</b> in PI. In the process, we are trying to read a .CSV File and convert it into a .XML File via FCC. The .CSV file is placed in the XI box itself, under a certain directory. We have configured the process such that whenever the .CSV file is read, its attributes are set to <b>'read only'</b>. After configuring the process, the required XML file did not show up. So we checked that whether the .CSV file was read and it showed up attributes of 'read only'.We cross checked
-First by going to <b>SXMB_MONI</b>; here it said 'No messages available for selection'
-Then by examining the 'channel monitoring' in AE; where we found both the sender and receiver channel are showing green. The sender channel first shows up that <b>'Processing started'</b> and then <b>'Processing Completed Successfully'.</b> The receiver channel does not show up any messages.
-we checked for the XML messages that are in the Adapter in <b>IDX5</b>; it shows <b>'no messages selected'</b>.
-We anticipated that it may be a cache problem and cleared all the caches; but when we tried to clear the Adapter Framework Cache, it popped up an authorization error and the problem persisted.
We are using NW2004s with SP6 at the ABAP and BASIS stack and SP 9 at the Java Stack. Also, all the required connections made in SM59 are in order.
Now, <b>What can be the problem? Is it the difference in SP level that is causing the problem? Or is it something else? What have we missed?</b> Guys, please help us solve this problem.
Need Help. Pleae Reply. Points will be awarded.
Thanking in anticipation.
Amitabha
Hi people,
We have been able to refresh the Adapter Engine Cache...and the message is showing in SXMB_MONI...but still the problem persists. We searched the SDN forums and found out we have to maintain some pipeline URL. We believe we have done so, still, for a check..can anybody tell us exactly in which places we need to maintain pipeline url?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can anybody please help us in this regards?
Thanks in anticipation....
Amitabha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Seems your file is not picked up properly.
Can you just mention the parameter you set in sender file adapter.
Thanks,
Tuhin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Tuhin,
We have four fields in our CSV file: <b>EMPLOYEEID,NAME,ADDRESS,DESIGNATION.</b>
The corresponding configuration of sender adapter is:
Document Name: MESSAGE_TYPE_XML
Document namaspace: http://filetoxmlfcc
RecordSet Name: EmployeeDetails
Recordset structure: row,1
Recordset sequence: Ascending
Recordsets per message: 1
row.fieldNames: EMPLOYEEID,NAME,ADDRESS,DESIGNATION
row.processFieldNames: fromConfiguration
row.fieldSeparator: ,
just do a basic check of the following points;
1. document name sud be the messge type of your source str.
2. try the following;
RecordSet Name: EmployeeDetails
Recordset structure: row,*
Recordset sequence: Ascending
Recordsets per message: *
row.fieldNames: EMPLOYEEID,NAME,ADDRESS,DESIGNATION
row.fieldSeparator: ,
row.endSeparator: 'nl'
3. put your file in delete mode and also check the polling interval.
Hi Shabarish,
1.Document name <b>is indeed</b> the name of message type in our case.
2. We did not use delete mode; but once the file was read- we manually changed its attributes from 'RA' to 'A'..and it became 'RA' again after 2 seconds; which is our polling interval.
3. And we have discovered that the file is being read properly..because we can see the XML payload of it and it contains the correct data.But still it does neither show up in SXMB_MONI..nor in IDX5.
<b>Can you please tell us what are the necessary roles for the User PIAFUSER?</b> We suspect that somewhere's an authorization error we are getting; because the AF cache refresh attempt shows "Forbidden" and we are getting an error in Tcode SXI_SHOW_MESSAGE as:
<b>AE_DETAILS_GET_ERROR: no_adapter_engine_found: Unable to find Adapter Engine:</b>; Stack trace shows:<b>Error while reading access data (URL, user, password) for the Adapter Engine</b>
ref this to find the roles assigned; (same for PI)
http://help.sap.com/saphelp_bankanalyzer50/helpdata/en/56/361041ebf0f06fe10000000a1550b0/content.htm
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.