Topic
3 replies Latest Post - ‏2012-11-22T08:23:46Z by sbjerry
osesto
osesto
9 Posts
ACCEPTED ANSWER

Pinned topic Unable to insert CSSC DDL structures

‏2012-08-09T14:59:07Z |
I need your help Community.

Every time when I run a Convert Request Optim 8.1 gave this error:

Convert Process Errors:
Unable to insert CSSC DDL structures in destination Extract File, rc = 17484

This happens when I choose more than 1 table and referential relationship is present between them.

Any help would appreciated
Updated on 2012-11-22T08:23:46Z at 2012-11-22T08:23:46Z by sbjerry
  • sbjerry
    sbjerry
    23 Posts
    ACCEPTED ANSWER

    Re: Unable to insert CSSC DDL structures

    ‏2012-11-21T08:14:33Z  in response to osesto
    I've met with the same problem. Have you solved this problem?
  • SystemAdmin
    SystemAdmin
    304 Posts
    ACCEPTED ANSWER

    Re: Unable to insert CSSC DDL structures

    ‏2012-11-21T14:36:13Z  in response to osesto
    Folks:

    It looks like we saw this problem back with Optim 731 and at the time created fix 49 to correct the issue. In reviewing some of the
    notes surrounding the fix, it looks like it should have been included in Optim 8.1.0 FP03. By any chance do you have any fixpacks
    applied? If not, we are already up to FP04, you may want to apply this set when you get a chance.

    Best regards,
    Kevin
    • sbjerry
      sbjerry
      23 Posts
      ACCEPTED ANSWER

      Re: Unable to insert CSSC DDL structures

      ‏2012-11-22T08:23:46Z  in response to SystemAdmin
      I used the version 8.1.0 with FP04 Optim with DB2 V9.7, I met with this problem with the following scenario:

      Extract a file from DB2 of 3 tables, which has primary-foreign key relationship. Then convert it to another file with an table mapping on one of the 3 tables.

      who can tell me in which way to troubleshoot this problem? thanks !