2 Replies Latest reply on Aug 2, 2006 11:19 AM by 439096

    problems importing CBR with repository import

    439096
      Hi,

      When we use the repository export end import processes to create a new repository, the CBR is not fully imported. It only copies 6 out of the 20 rules.
      The error reported is ORA01438: the specified value larger than specified precision allowed for this column.

      It looks like the import process expects a smaller number that we can write in the column using iStudio. The CBR-rules are quit large in our case...

      Has anybody expierenced the same, and how did you solve this? We now have to rebuild CBR every time
        • 1. Re: problems importing CBR with repository import
          436342
          Never seen this issue before.

          What version are you using?

          I've used 9.0.4 and the CBR table only has 3 columns.
          CREATE TABLE CBR
          (
          EVENTID NUMBER(10) NOT NULL,
          EXPRESSION VARCHAR2(4000 BYTE) NOT NULL,
          DESTINATION VARCHAR2(4000 BYTE) NOT NULL
          )

          Are you sure the export has worked OK?
          There is a foreign key constraint so may be an issue if the EVENT table wasn't exported properly.

          Can you upload the export and import log?

          Stuart
          • 2. Re: problems importing CBR with repository import
            439096
            thanks for th ehelp so far.

            We are using 10.1.2 release 2
            It is in there quit a while. I will let our administrator check the logging when he is back from his holiday and see if your hint about EVENT table gives us a clue.