on 12-07-2009 3:17 PM
Hello all,
I have followed Siva's blog for a JDBC mapping lookup: https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/2219. [original link is broken] [original link is broken] [original link is broken]
I get this error message:
Exception during processing the payload.Problem when calling an adapter by using communication channel LOOKUP_CHANNEL (Party: , Service: DBLOOKUP, Object ID: e7209753aa25312a9e5dbe1151be4496) XI AF API call failed. Module exception: (No information available). Cause Exception: (No information available).
com.sap.aii.mapping.lookup.LookupException: Problem when calling an adapter by using communication channel LOOKUP_CHANNEL(Party: , Service: DBLOOKUP, Object ID: e7209753aa25312a9e5dbe1151be4496) XI AF API call failed. Module exception: (No information available). Cause Exception: (No information available).
All the other JDBC receiver comminucation channles work well , but the channel that is called from the message mapping fails .
Can anyone help me how to solve this problem.
Regards,
Kalpana.
>
> Hello all,
>
> I have followed Siva's blog for a JDBC mapping lookup: https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/2219. [original link is broken] [original link is broken] [original link is broken]
>
> I get this error message:
>
> Exception during processing the payload.Problem when calling an adapter by using communication channel LOOKUP_CHANNEL (Party: , Service: DBLOOKUP, Object ID: e7209753aa25312a9e5dbe1151be4496) XI AF API call failed. Module exception: (No information available). Cause Exception: (No information available).
> com.sap.aii.mapping.lookup.LookupException: Problem when calling an adapter by using communication channel LOOKUP_CHANNEL(Party: , Service: DBLOOKUP, Object ID: e7209753aa25312a9e5dbe1151be4496) XI AF API call failed. Module exception: (No information available). Cause Exception: (No information available).
>
>
> All the other JDBC receiver comminucation channles work well , but the channel that is called from the message mapping fails .
>
> Can anyone help me how to solve this problem.
>
> Regards,
> Kalpana.
1. Did you use the same name as of the JDBC receiver CC in the lookup code?
2. is the CC created under the BS as mentioned in your code?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Shabharish,
I have given the correct name for the BS and the CC.
I have also seen that when I use the SelectMethod=cursor in the communication channel connection string like:
jdbc:oracle:thin:<uname>/<pwd>@<server>:<port>:<SID>;SelectMethod=cursor
I get an error:SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor.
If I remove the jdbc:oracle:thin:<uname>/<pwd>@<server>:<port>:<SID> and test the message mapping I get the errorwhich i got earlier.
With the help of the DBA, i could see that I could see that the connection is established from XI server to oracle server...but I get the same response which i have mentioned earlier.
Please tell me if I have to make some changes in the code.
here is my code:
String Query = " ";
Channel channel = null;
DataBaseAccessor accessor = null;
DataBaseResult resultSet = null;
// Build the Query String
Query = "Select USI_ID from sapmlnd.SAP_EXT_ITEM_MAP where MATNR=' "LookUpData[0]" ' ";
try{
//Determine a channel, as created in the Configuration
channel = LookupService.getChannel("DBLOOKUP","LOOKUP_CHANNEL");
//Get a system accessor for the channel. As the call is being made to an DB, a DatabaseAccessor is obtained.
accessor = LookupService.getDataBaseAccessor(channel);
//Execute Query and get the values in resultset
resultSet = accessor.execute(Query);
for(Iterator rows = resultSet.getRows();rows.hasNext();){
Map rowMap = (Map)rows.next();
result.addValue((String)rowMap.get("IDTNR"));
}
}
catch(Exception ex){
result.addValue(ex.getMessage());
}
finally{
try{
if (accessor!=null) accessor.close();
}
catch(Exception e){
result.addValue(e.getMessage());
}
}
Hello all,
I was very busy and henc could not update the thread,The problem is solved now.
There was no problem in the code written and no problem in the communication channels or the servics.
It was a typo istake that there was an extra space in the SQL query
.
Once again thank you all for your support.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.