OBIA 12c: Errors during data store imports

Question

Hi -

We have done a fresh install of 11.1.1.10.3. We are attempting to import our customizations from OBIA 11.1.1.10.1, as per https://blogs.oracle.com/biapps/obia-12c:-odi-customizations-migration-utility. This is for the 'ODI12c Data Stores Migration Utility'.

The export seemed to work fine and generated the necessary flat files. Some of the imports succeeded, but many did not. I am getting the following errors for those that failed (not very much detail) to go on ...

java.lang.NullPointerException
2021-04-30 16:33:04,479 -0400 [main] ERROR (CreateModel.java:868) - File BIAPPS_DIMENSION_BalancingSegmentDimension.omm is processed with some exception java.lang.NullPointerException
2021-04-30 16:33:04,646 -0400 [main] ERROR (CreateModel.java:868) - File BIAPPS_DIMENSION_W_COST_CENTER_D.omm is processed with some exception java.lang.NullPointerException
2021-04-30 16:33:04,700 -0400 [main] ERROR (CreateModel.java:868) - File BIAPPS_DIMENSION_STAGE_W_BALANCING_SEGMENT_DS.omm is processed with some exception java.lang.NullPointerException
2021-04-30 16:33:04,755 -0400 [main] ERROR (CreateModel.java:868) - File BIAPPS_DIMENSION_STAGE_W_NATURAL_ACCOUNT_DS.omm is processed with some exception java.lang.NullPointerException
2021-04-30 16:33:04,855 -0400 [main] ERROR (CreateModel.java:868) - File BIAPPS_DIMENSION_STAGE_W_COST_CENTER_DS.omm is processed with some exception java.lang.NullPointerException
2021-04-30 16:33:04,991 -0400 [main] ERROR (CreateModel.java:868) - File BIAPPS_FACT_W_AP_HOLDS_F.omm is processed with some exception java.lang.NullPointerException
2021-04-30 16:33:05,481 -0400 [main] ERROR (CreateModel.java:868) - File BIAPPS_FACT_AP Transaction.omm is processed with some exception java.lang.NullPointerException
2021-04-30 16:33:05,844 -0400 [main] ERROR (CreateModel.java:868) - File BIAPPS_FACT_Requisition Lines Cost.omm is processed with some exception java.lang.NullPointerException
2021-04-30 16:33:06,449 -0400 [main] ERROR (CreateModel.java:868) - File BIAPPS_FACT_General Ledger Journal Entries.omm is processed with some exception java.lang.NullPointerException

Curious to know if anyone has gotten the same.

Regards,

Charles

User_QRFTM · Answer

thanks for your response

User_QRFTM · Answer

no, there is not much out there.  they did update the utility.  I'm going to update my version and try it again

Regards,

Steve

Charles M · Answer

Hi User_QRFTM,

I never did get an answer to this. Possibly, there is something on MOS now (haven't checked in some time).

Ultimately, we decommissioned our OBIA instances last year ... in part because of the complexity of the 11g -> 12c migration.

Hopefully, there are some more answers out there now than before (assuming more folks have run into this scenario).

Regards,

Charles