JDBC lookup error in 7.1

[Former Member]

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'.

[baskar_gopalakrishnan2]

>>> invalid argument: unknown column name COLUMN_NAME

Your external definition which represents the table definition has wrong column name i.e column_name is not available in the database table. Use describe command for the table in database and check those fields are in the external definition or your message type.

Possible reasons: Your database table might be changed after loading the external definition in pi . You can import the metadata of the table again and check whether any change in the column names. This error is very straightforward.

[Former Member]

When I give the CC name and communication component and select the display option in the Table import I see the tables displayed.I am following the below blog.I get this error when I select the finish button at the end.

/people/william.li/blog/2008/01/02/sap-pi-71-mapping-enhancements-series-import-sql-tables-metadata

[former_member200962]

select the display option in the Table import I see the tables displayed

did you try to login to the DB and check for the table structure?

If still not working then it seems to be a bug....you can raise an OSS ticket for this.

the channel is working fine for file to jdbc

is it working on the same table that is giving error?

Edited by: abhishek salvi on Jan 20, 2011 9:50 AM

[Former Member]

Yes the DB guy checked the table structure.

yes the same table is working for other scenarios

and also it is working fine for SQL server DB

Thanks

[markangelo_dihiansan]

Hello,

Could you check the logon credentials that you are using? We had an issue before, similar to this one but instead of using the DB Lookup, we used XML SQL. RWB monitoring gives us an invalid column name, it just happened that the credentials we are using is not correct although the database table is visible in PI. You could give it a try and revert back.

Hope this helps,

Mark

[Former Member]

Raised issue with SAP and they have recommended to install service pack