MSIR.0254 Invalid COLUMN numbers for TABLE (tabname): Difference between revisions

From m204wiki
Jump to navigation Jump to search
m (1 revision)
(Automatically generated page update)
 
(6 intermediate revisions by 3 users not shown)
Line 1: Line 1:
This message indicates that a table was defined in the JANCAT file for a ''[[Janus Specialty Data Store]]'' port but the column number field (COL_NUM) in the column descriptor records (RECTYPE=C) for that table did not go from 1 to the number of columns in the table. While the port is started (or reloaded) in spite of the error, the indicated table is marked as invalid and is not usable after this error. This error is indicative of an error in an ad hoc or user application run against the JANCAT file or a bug in the JANCAT application distributed by Sirius Software. In the former case (and maybe even the latter) correct the data in the JANCAT file with another ad hoc or restore the JANCAT file to the state it was in before the bad data was added to the file. In the latter case, call Sirius Software technical support.  
This message indicates that a table was defined in the JANCAT file for a [http://m204wiki.rocketsoftware.com/images/e/e4/JsdsrNew.pdf Janus Specialty Data Store] port, but the column number field (COL_NUM) in the column descriptor records (RECTYPE=C) for that table did not go from 1 to the number of columns in the table. While the port is started (or reloaded) in spite of the error, the indicated table is marked as invalid and is not usable after this error.  


Note that the column numbers don't have to appear in sequential order in the file since that ''[[Janus Specialty Data Store]]'' sorts the records by COL_NUM before processing them. It is only essential that, once sorted, the COL_NUM values go from 1 to the number of columns.
This error is indicative of an error in an ad hoc or user application run against the JANCAT file or a bug in the JANCAT application. In the former case (and maybe even the latter) correct the data in the JANCAT file with another ad hoc or restore the JANCAT file to the state it was in before the bad data was added to the file. In the latter case, call [[Contacting Rocket Software Technical Support|Technical Support]].  


[[Category:Sirius Mods Messages]]
<p class="note"><b>Note:</b> The column numbers don't have to appear in sequential order in the file, since the <var class="product">Janus Specialty Data Store</var> sorts the records by COL_NUM before processing them. It is only essential that, once sorted, the COL_NUM values go from 1 to the number of columns. </p>
 
{{Template:MSIR.0254 footer}}
[[Category:MSIR.0200 - MSIR.0399]]

Latest revision as of 23:08, 3 March 2017

This message indicates that a table was defined in the JANCAT file for a Janus Specialty Data Store port, but the column number field (COL_NUM) in the column descriptor records (RECTYPE=C) for that table did not go from 1 to the number of columns in the table. While the port is started (or reloaded) in spite of the error, the indicated table is marked as invalid and is not usable after this error.

This error is indicative of an error in an ad hoc or user application run against the JANCAT file or a bug in the JANCAT application. In the former case (and maybe even the latter) correct the data in the JANCAT file with another ad hoc or restore the JANCAT file to the state it was in before the bad data was added to the file. In the latter case, call Technical Support.

Note: The column numbers don't have to appear in sequential order in the file, since the Janus Specialty Data Store sorts the records by COL_NUM before processing them. It is only essential that, once sorted, the COL_NUM values go from 1 to the number of columns.


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

Back to list of messages