Re: Query processor failure

On 3/14/11 1:13 PM, Albert York wrote:

I recently had to reload a system from scratch and now I am getting
the messages below when I try running WRKLICKEY or RMVLICKEY and other
processes that use the query processor. Does anyone have any
suggestions how I can resolve this?

<ed:> msgMCH5003 "Scalar operand contains a value that is not valid."
  Cause . . . . . :   The length of the invalid scalar operand is 1.
 The bit offset to the invalid field is X'0000'. The operand number
 is 3.  The invalid data is X'0A'.

<ed:> msgCPF4204 "Internal failure occurred in query processor."
  Cause . . . . . :   A system failure has occurred in the query
  processor program.  The query definition template number is 1.
  Recovery  . . . :   See the low-level messages.  Correct any
  errors and try your request again.  If the problem continues,
  report the problem (ANZPRB command).

  IIRC that is typically the result of a mismatch in code levels
between the LIC and the OS.  The means\media used to recover may be at
fault.

  For v5r4 there is a PTF for an APAR documenting specifically the
latter generic error [alwas F/QQQQUERY as I recall] on a "disaster
recovery" but appears specific only to restore of the SQL catalog VIEW
objects into QSYS2 and\or SYSIBM, and thus unlikely a match:
http://www-01.ibm.com/support/docview.wss?uid=nas3987a36f75e3bd0f68625730d0057f88b
"SI27680 - OSP-DB-MSGCPF4204 Internal failure during disaster recovery"

  Given the full message details instead of just what was selected for
cut\paste, e.g. the messages from a spooled joblog or F6=Print, a better
search might find a more appropriate PTF.  Which release is also a very
useful detail.  Of course as the message implies, that internal failure
is a defect condition which would best be reported to your service provider.

Regards, Chuck
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.