Skip to Content
0
Former Member
Jan 20, 2011 at 12:04 AM

JDBC lookup error in 7.1

35 Views

I get the below error while importing the metadata from table in the external definition dbtab, I am using the receiver communication channel,the channel is working fine for file to jdbc,any help appreciated

Error in CC

Error processing request in sax parser: Error when executing statement for table/stored proc. 'metadataRequest' (structure 'statement'): com.ibm.db2.jcc.b.SqlException: Invalid argument: unknown column name COLUMN_NAME

Error in ED

Error occurred while attempting to connect to database (LOOKUPEXCEPTION)

Exception during processing the payload. Error when

calling an adapter by using the communication channel

CC_GeoRestrictions_JDBC_Receiver (Party: , Service:

BC_GeoRestrictions_SAP_To_Legacy, Object ID: c0adebcbf7603e82a2b6a1b100139c8b)

XI AF API call failed. Module exception: (No information

available). Cause Exception: 'Error processing request

in sax parser: Error when executing statement for table/stored

proc. 'metadataRequest' (structure 'statement'): com.ibm.db2.jcc.b.SqlException:

Invalid argument: unknown column name COLUMN_NAME'.

com.sap.aii.mapping.lookup.LookupException: Error when

calling an adapter by using the communication channel

CC_GeoRestrictions_JDBC_Receiver (Party: , Service:

BC_GeoRestrictions_SAP_To_Legacy, Object ID: c0adebcbf7603e82a2b6a1b100139c8b)

XI AF API call failed. Module exception: (No information

available). Cause Exception: 'Error processing request

in sax parser: Error when executing statement for table/stored

proc. 'metadataRequest' (structure 'statement'): com.ibm.db2.jcc.b.SqlException:

Invalid argument: unknown column name COLUMN_NAME'.