MSIR.0256 SYBMSG(41101,15,1) Column (colname) not found for table (tabname)

From m204wiki
Jump to navigation Jump to search

This message indicates that the Janus Specialty Data Store received a SQL request sent by the client (probably an Omni Adaptive) that referred to an unknown column in the indicated table. If the SQL was sent by an Adaptive Server or an Omni Connect Gateway server (rather than a direct client connection) make sure that the table definitions in the Adaptive Server or Omni Connect Gateway match the table definitions in Janus Specialty Data Store. If the table definitions are out of synch, they can be brought back into synch by deleting all Janus Specialty Data Store table definitions on the Adaptive Server and then re-running the defgen utility against the Adaptive Server.

Message attributes:

RETCODEO=0Sets online return code
RETCODEB=4Sets batch (single user) return code
CLASS=EError class; the message can be suppressed with the X'04' bit setting of the MSGCTL parameter
AUDITERWrites the message with line type ER to the audit trail
COUNTIncrements the error count (ERCNT) parameter
NOTERMDoes not display the message on the user's terminal

Back to list of messages