IC81996: ISSUE WITH RUNNING VALIDATOR JOB

APAR status

• Closed as user error.

Error description

• INFO: Importing column CREATE_USER for table
  ISDS1.DM_STG_82D4E614_1 as VARCHAR as its native type is
  VARCHAR2
  Mar 14, 2012 4:18:18 PM
  com.exeros.dv.validation.algorithms.ExpressionValidatorBase
  generateExceptionIterationQuery
  INFO: Exception repare sql:  SELECT
  VALIDATION_EXCEPTION_INFO.ID, ORDLINKS.ORD_SEQ, ORDLINKS.ORD_SEQ
  IDENTITY_0_ FROM ISDS1.VALIDATION_EXCEPTION_INFO
  VALIDATION_EXCEPTION_INFO  INNER  JOIN
  ISDS1.VALIDATION_EXCEPTION_RECORD VALIDATION_EXCEPTION_RECORD
  ON
  (VALIDATION_EXCEPTION_RECORD.VALIDATION_EXCEPTION=VALIDATION_EXC
  EPTION_INFO.ID)  LEFT OUTER  JOIN ISDS1.TABLE_RECORD "tr_0_"  ON
  ("tr_0_".TABLE_ID= '4e90542f72ee4e679be5b843ff912fb6'  AND
  VALIDATION_EXCEPTION_RECORD.ID="tr_0_".EXCEPTION_RECORD)  LEFT
  OUTER  JOIN ISDS1.DM_STG_82D4E614_1 ORDLINKS  ON
  ("tr_0_".RECORD_ID=ORDLINKS.DMIDENTITY)  WHERE
  VALIDATION_EXCEPTION_INFO.VALIDATION_OBJECT= 76936  AND
  VALIDATION_EXCEPTION_INFO.NEW_EXCEPTION= 0  AND
  VALIDATION_EXCEPTION_INFO.TYPE= 1  ORDER BY IDENTITY_0_ ASC,
  ORDLINKS.ORD_SEQ ASC
  Mar 14, 2012 4:18:18 PM
  com.exeros.dv.validation.algorithms.ExpressionValidatorBase$1
  completed
  INFO: Repaired data hash for 0 exceptions of the expression
  ORDLINKS.ORD_SEQ = OMS_ORDERS_NW.MOKYSQ
  com.exeros.querygen.exceptions.BitTableManagerException:
  bittablemanager.metadata_hibernate_ex
   at
  com.exeros.querygen.BitTableManagerImpl.getBitTable(BitTableMana
  gerImpl.java:42)
   at
  com.exeros.dv.validation.algorithms.MapValidationHelper$2.call(M
  apValidationHelper.java:33
  

Local fix

• Re-create a new project
  

Problem summary

Problem conclusion

Temporary fix

Comments

• This issue was resolved by recreating the project.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels