SAP Knowledge Base Article - Preview

3553480 - MSS: Database Error 207 at OPC Invalid Column Name 'requid'

Symptom

Huge amount of following error is found in SAP system log.

BY2 Database error 207 at OPC
BY0 Invalid column name 'requid'


The corresponding SAP work process trace gives the details:

B  Connection 2 opened (DBSL handle 1)

C  ERROR: -1 in function StartSelect (execute) [line 17870]

C  (207) [42S22] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'requid'.

C  (207) [42S22] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'datapakid'.

C  (207) [42S22] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'step'.

C  (207) [42S22] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'substep'.

C  (207) [42S22] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name 'runid'.

C  (207) [42S22] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name '$rowid$'.

C  (207) [42S22] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name '$trex_udiv$'.

C  (8180) [42000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could not be prepared.

C  Error 100 (dbcode 207) in StartSelect

C  StartSelect: stmt of 0 CL_RSBM_LOG_DTP_DP============CP

C  SELECT "$rowid$", "$trex_udiv$" FROM RSBMREQ_DTP WHERE requid = ?   AND datapakid = ?   AND step = ?   AND substep = ?   AND runid = ? 

C  /* R3:CL_RSBM_LOG_DTP_DP============CP:163 T:RSBMREQ_DTP M:200 */

 


Read more...

Environment

  • SQL Server
  • Solution Manager 7.2 SP30 or lower

Product

SAP Solution Manager 7.2

Keywords

Database error 207, OPC, Invalid column name, "$rowid$", "$trex_udiv$", RSBMREQ_DTP, requid, datapakid, step, substep, runid , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BW-WHM-DST-DTP , Data Transfer Process , 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.