JDBC Lookup !

[Former Member]

Hi Guys,

//write your code here
String Query = " ";
Channel channel = null;
DataBaseAccessor accessor = null;
DataBaseResult resultSet = null;
// Build the Query String
Query = "Select BASE_ID from  SAP_BASE where BASE_ID = '" + "BASE_ID[0]"; 
try{
//Determine a channel, as created in the Configuration
channel = LookupService.getChannel("BS","CC_BASE"); 
//Get a system accessor for the channel. As the call is being made to an DB, an 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("BASE_ID"));
}
}
catch(Exception ex){
result.addValue(ex.getMessage())
}
finally{
try{
if (accessor!=null) accessor.close();
}
catch(Exception e){
result.addValue(e.getMessage())
}
}

I get below error

Problem when calling an adapter by using communication channel CC_BASE(Party: , Service: BS, Object ID: 3a9ec0b92330329980a80ca13202779a) XI AF API call failed. Module exception: (No information available). Cause Exception: 'Error: invalid receiver channel '3a9ec0b92330329980a80ca13202779a''

CC_BASE -- Receiver JDBC Adapter (BS - Business System)

Any view on above

Rgds

srini

[Former Member]

hi

views

srini

[Former Member]

Thx

Srini

[Former Member]

HI

Any ibouts

rgd

srini

[former_member181985]

Do you have an active version of Business System (BS) and Channel (CC_BASE) in ID?

If not create them and activate.

Else you already have them do a cache refresh.(SXI_CACHE and CPA Cache)

Edited by: Praveen Gujjeti on Mar 23, 2009 4:35 PM

[Shabarish_Nair]

channel = LookupService.getChannel("BS","CC_BASE"); 

check

1. Is the business systems name BS?

2. Does CC_BASE exist in ID under the Business system BS?

Note that you should use a valid Business system and a valid receiver JDBC adapter under that business system.

[Former Member]

Hi

BS - Business Sytem,

CC_BASE -- Receiver JDBC Adapter

both are present , activte

Any more views

rgd

srini

[Former Member]

Hi,

Ask your basis guys to do a full CPA Cache refresh using XIDIRUSER..........they will know how to do it.... then rerun your scenario.

Regards,

Rajeev Gupta

[Former Member]

Hi

Still same issue continues

Any more ideas

srini