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 ONE Support launchpad (Login required).

Search for additional results

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