Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

In Data Management, I am getting this Error: Not all dimensions were specified for 44 rows out of 24

859053Apr 27 2018 — edited May 1 2018

In Data Management, I am getting this Error: Not all dimensions were specified and there are no information which row is causing the error. In this file,

24104 data records were read, 24105 data records were processed, 24061 were accepted for loading (verify actual load with Essbase log files), 44 were rejected.

[Fri Apr 27 22:25:08 UTC 2018]Successfully located and opened input file.

[Fri Apr 27 22:25:08 UTC 2018]Input file being read with UTF-8 encoding.

[Fri Apr 27 22:25:08 UTC 2018]Date format pattern "DD-MM-YYYY" specified for date data type loading.

[Fri Apr 27 22:25:08 UTC 2018]Header record fields: Driver Member Point-of-View Data Load Cube Name Value

[Fri Apr 27 22:25:08 UTC 2018]Located and using "OFADataLoadDimension" dimension for loading data in "BRCC" application.

[Fri Apr 27 22:25:08 UTC 2018]Parent-child ordering option (/H switch) will not be performed: this option is not available for the "OFADataLoadDimension" dimension.

[Fri Apr 27 22:25:08 UTC 2018]Input file member load ordering option (/O switch) will not be performed: this option is only available for (non /IE) import operations.

[Fri Apr 27 22:25:08 UTC 2018]HspOutlineLoad::dateFormatSpecified is true, SessionHalDateFormat stored on session: dd/MM/yy, sessionId: 2132800271

[Fri Apr 27 22:25:08 UTC 2018]Not all dimensions were specified.

[Fri Apr 27 22:25:09 UTC 2018]Not all dimensions were specified.

[Fri Apr 27 22:25:10 UTC 2018]Not all dimensions were specified.

[Fri Apr 27 22:25:11 UTC 2018]Not all dimensions were specified.

[Fri Apr 27 22:25:12 UTC 2018]Not all dimensions were specified.

[Fri Apr 27 22:25:13 UTC 2018]Not all dimensions were specified.

Outline data store load process finished. 24104 data records were read, 24105 data records were processed, 24061 were accepted for loading (verify actual load with Essbase log files), 44 were rejected.

[Fri Apr 27 22:25:14 UTC 2018]Outline data store load process finished. 24104 data records were read, 24105 data records were processed, 24061 were accepted for loading (verify actual load with Essbase log files), 44 were rejected.

2018-04-27 22:25:14,347 DEBUG [AIF]: loadStatus.errorsWereLogged: True, loadStatus.warningsWereLogged: True

2018-04-27 22:25:14,575 DEBUG [AIF]: Session ID: 1068501, Status: ERROR, Status Message: Session Failed :1068501 : ODI-1217: Session COMM_EXECUTE_GENERIC_PROCESS (1068501) fails with return code 7000.

ODI-1226: Step Execute Data Load - OLU fails after 1 attempt(s).

ODI-1232: Procedure COMM Execute Data Load - OLU execution fails.

Caused By: org.apache.bsf.BSFException: exception from Jython:

Traceback (most recent call last):

File "<string>", line 8, in <module>

File "<string>", line 223, in performLoadOluFile

RuntimeError: CommHpl - performLoadOluFile did not complete successfully

Locked Post

New comments cannot be posted to this locked post.

Locked on May 29 2018

Added on Apr 27 2018

#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting

11 comments

1,875 views