SAP Knowledge Base Article - Preview

1826072 - PI JDBC Receiver adapter error "SQLServerException: Invalid column name"

Symptom

  • The error below is thrown by the Process Integration (PI) JDBC Receiver adapter.
  • The error can be viewed in the defaultTrace file.
  • The trace file is located in the file system under "/usr/sap/[SID]/[instance]/j2ee/cluster/server[N]/log/defaultTrace.[x].trc" for each N server node.

INSERT INTO  <TABLE_NAME> (DATAELEMENT1, DATAELEMENT2...DATAELEMENTn) VALUES (VALUE1, VALUE2...VALUEn) Exception caught when executing statement for table/stored proc. '<TABLE_NAME>' (structure 'Statement'):
com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name '<VALUE>'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError (SQLServerException.java:197)


Read more...

Environment

  • SAP NetWeaver 7.3
  • SAP enhancement package 1 for SAP NetWeaver 7.3

Product

SAP NetWeaver 7.3 ; SAP enhancement package 1 for SAP NetWeaver 7.3

Keywords

KBA , BC-XI-CON-JDB , JDBC Adapter , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.