5 Replies Latest reply: May 12, 2014 8:44 AM by JeffJon RSS

    FDM Import Error

    Vivek Chetiaparath

      Hi All,

       

      Getting the following error during import.Integration script to  Oracle DB/View to import data.

       

      -------------------------------------------------------------

      ERROR:

      Code............................................. -2147217900

      Description...................................... ORA-00972: identifier is too long

      CREATE  BITMAP  INDEX IX_tWepmadm101690810170046859_BA ON tWepmadm101690810170046859 (CalcAcctType) TABLESPACE USERS COMPUTE STATISTICS

       

       

      ERROR:

      Code............................................. -2147217900

      Description...................................... ORA-00972: identifier is too long

      CREATE  INDEX IX_tWepmadm101882410188285850_1 ON tWepmadm101882410188285850  (ACCOUNT) TABLESPACE USERS COMPUTE STATISTICS

       

      The issue seems to be caused bez the index name cannot be more than 30 characters and some how FDM seems to create this index.In the configuration setting tried changing the bitmap switch to ON and OFF but did not make any difference.

       

       

      Thx

      Vivek