Skip to Content
avatar image
Former Member

CC Importing Rules from 4.0 to 5.2 Error

I am importing our current ruleset from 4.0 to 5.2. We ran /VIRSA/ZVFAT_L03 to export our rules and then went into Compliance Calibrator 5.2 to import the text file. We are getting the following error.

Error in Table Data ==>VIRSA_CC_FUNCPRM

SQL:=>Insert into VIRSA_CC_FUNCPRM(FUNCTID,ACTIONS,VSYSKEY,AUTHTREE,FROMVAL,TOVAL,SEARCHTYPE,STATUS ) Values(?,?,?,?,?,?,?,?,?)

Record:=>D VIRSA_CC_FUNCPRM

Has anyone imported their existing ruleset? If so, have you encountered any issues when trying to convert them?

Do you know if we need to modify our input file before we import?

Thanks,

Jes Behrens

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 14, 2008 at 03:56 PM

    Hi Jes,

    the conversion sometimes doesn't work 100% correctly.

    As you can see from the error, a data set of 9 fields is trying to be written into the database table consisting of 8 fields.

    Please check in the file you exported from CC 4.0, which line could cause this error (database fields are tab separated).

    Sometime searching for the error can be a little bit tricky, but from my experience it was always some line with an incorrect format.

    Regards

    Daniela

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Jerome;

      Do you have an example of table VIRSA_CC_MITUSER as i am getting the same error

      PRD

      M VIRSA_CC_MITUSER MITREFNO RISKID USERID VALIDTO MONITORID STATUS

      D VIRSA_CC_MITUSER R1 R6120W401 LKHOURI 9999-12-31 MKIDAMBI 0

      D VIRSA_CC_MITUSER R1 R6120W501 LKHOURI 9999-12-31 MKIDAMBI 0

      Error in table dataVIRSA_CC_MITUSER

      SQL:=>Insert into VIRSA_CC_MITUSER(MITREFNO,RISKID,USERID,VALIDTO,MONITORID,STATUS ) Values(?,?,?,?,?,?)

      Record::Line Number :3 : D VIRSA_CC_MITUSER

      Thanks & Regards

      Ayaz

  • avatar image
    Former Member
    Aug 19, 2008 at 07:10 PM

    Thank you Daniela and Jérôme.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Daniela/Jérôme/Jes;

      I am really stuck importing the mitigating .txt file for the users & having the same errors in 5.3, do you'll have the format for mitigating users ? below is my file format please suggest if i am doing something wrong here

      PRD

      M VIRSA_CC_MITUSER MITREFNO RISKID USERID VALIDTO MONITORID STATUS

      D VIRSA_CC_MITUSER R1 R6120W401 LKHOURI 9999-12-31 MKIDAMBI 0

      D VIRSA_CC_MITUSER R1 R6120W501 LKHOURI 9999-12-31 MKIDAMBI 0

      Appreciate it

      Regards

      Ayaz