1 Reply Latest reply: Apr 28, 2011 7:28 AM by sdas RSS

    sem_apis.bulk_load_from_staging_table failed with APP-Load:Code=-1

    user10180983
      I was trying to bulk load rdf data from a staging table. It failed with the following:

      sql> exec sem_apis.bulk_load_from_staging_table('CLINICAL_PPE_OWNER_ORG','CLINICAL_PPE_OWNER','ORG_TEMP')
      BEGIN sem_apis.bulk_load_from_staging_table('CLINICAL_PPE_OWNER_ORG','CLINICAL_PPE_OWNER','ORG_TEMP'); END;

      *
      ERROR at line 1:
      ORA-13199: APP-Load:CODE=-1
      ORA-06512: at "MDSYS.SDO_RDF_INTERNAL", line 4026
      ORA-06512: at "MDSYS.SDO_RDF", line 276
      ORA-06512: at "MDSYS.RDF_APIS", line 555
      ORA-06512: at line 1

      Here is what the event log shows: (no comments recorded in the table)
      EVENT_NAME START_TIME END_TIME
      ------------------------------ ------------------------------ ------------------------------
      *BULK_LOAD_FROM_STAGING_TABLE  26-APR-11 09.44.12.398160 PM
      LOAD_BATCH_VALUES_TABLE 26-APR-11 09.44.12.400700 PM 26-APR-11 09.44.12.569672 PM
      -ins_LEX_VALS_INTO_BATCH_VAL 26-APR-11 09.44.12.416285 PM 26-APR-11 09.44.12.538418 PM
      GATHER_BATCH_VALUES_STATS 26-APR-11 09.44.12.570198 PM 26-APR-11 09.44.12.667347 PM
      LOCK_VALUES_TABLE 26-APR-11 09.44.12.668012 PM 26-APR-11 09.44.12.669638 PM
      IS_ZERO_COLLISIONS 26-APR-11 09.44.12.669998 PM 26-APR-11 09.44.12.864852 PM
      MERGE_BATCH_VALUES 26-APR-11 09.44.12.865420 PM 26-APR-11 09.44.13.162888 PM
      RELEASE_VALUES_TABLE 26-APR-11 09.44.13.163399 PM 26-APR-11 09.44.13.163672 PM
      LOAD_BATCH_TRIPLES_TABLE 26-APR-11 09.44.13.221238 PM 26-APR-11 09.44.13.390410 PM
      GATHER_BATCH_TRIPLES_STATS 26-APR-11 09.44.13.391842 PM 26-APR-11 09.44.13.538121 PM
      FIND_AND_RESOLVE_BATCH_DUPS 26-APR-11 09.44.13.554067 PM 26-APR-11 09.44.13.650193 PM
      -find_BATCH_DUP_SELECTIONS 26-APR-11 09.44.13.592301 PM 26-APR-11 09.44.13.646407 PM
      -lock_X_MODEL 26-APR-11 09.44.13.651245 PM 26-APR-11 09.44.13.652172 PM
      LOAD_INTO_EMPTY_MODEL_PARTN 26-APR-11 09.44.13.652490 PM
      -create_UNIQ_IDX_PCSM 26-APR-11 09.44.13.665637 PM 26-APR-11 09.44.13.744477 PM
      -create_IDX_PSCF 26-APR-11 09.44.13.746900 PM 26-APR-11 09.44.13.813775 PM
      -insert_INTO_APP_TABLE 26-APR-11 09.44.13.815826 PM

      Can't find any reference to this problem in google or metalink.

      Edited by: user10180983 on Apr 27, 2011 7:39 AM

      Saw these error codes in a sql trace:
      ...
      The following statements encountered a error during parse:

      INSERT INTO "CLINICAL_PPE_OWNER"."CM_ORG_EXT" ("ORG_TRIPLE") VALUES (1)

      Error encountered: ORA-00932
      --------------------------------------------------------------------------------
      SELECT 1 FROM DUAL WHERE x.hash_id=ov.value_id

      Error encountered: ORA-00904
      --------------------------------------------------------------------------------
      LOCK TABLE FOR INDEX "X_24_8D99420A5411F_82_PCSM" IN EXCLUSIVE MODE NOWAIT

      Error encountered: ORA-01418
      --------------------------------------------------------------------------------
      DROP INDEX x_24_8D99420A5411F_82_pcsm

      Error encountered: ORA-01418
      ********************************************************************************

      Problem solved.