Error: 'CPF5029 detected in file AP1003F' when attempting to run any RRM Transaction Reports. (NETIQKB44166)

  • Document ID:7744166
  • Creation Date:02-Feb-2007
  • Modified Date:22-Aug-2008
    • Micro Focus Products:
      Security Solutions for iSeries

Resolution

fact
VigilEnt Security Agent for PSSecure 7.5

fact
Remote Request Management (RRM)

symptom
Error: 'CPF5029 detected in file AP1003F' when attempting to run any RRM Transaction Reports.

cause
Null values are found in certain fields of the report submittal transaction. 

fix

Run the following commands from an extended command entry screen (CALL QCMD, F11). To copy/paste to an AS/400 screen:

  1. Highlight the following text in this document:

    ADDLIBLE PSCOMMON *LAST

    PSRUNSQL 'UPDATE PSCOMMON/AP1003F
    SET DD3CRTTS=''0001-01-01-00.00.00.000000'' WHERE DD3CRTTS IS NULL'

    PSRUNSQL 'UPDATE PSCOMMON/AP1003F
    SET DD3CHGTS=''0001-01-01-00.00.00.000000'' WHERE DD3CHGTS IS NULL'

    PSRUNSQL 'UPDATE PSCOMMON/AP1003F
    SET DD3LSTRUN=''0001-01-01-00.00.00.000000'' WHERE DD3LSTRUN IS NULL'

  2. Press Ctrl + C.
  3. Go to AS/400 extended command entry.
  4. Press Alt.
  5. Press E. 
  6. Press P.


Additional Information

Formerly known as NETIQKB44166