Skip to Main Content

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!

Export from file to PBCS application failing

User_N9Z3IMay 18 2017 — edited May 19 2017

Hi all, I am new to Management and struggling to create a simple integration to load data from flat file to PBCS planning application. My import step completed successfully. But my export is failing. Below is the error log. Can any one please help me in fixing this. 2017-05-18 09:58:02,833 INFO  [AIF]: -------START EXPORT STEP------- 2017-05-18 09:58:02,890 INFO  [AIF]: EssbaseService.exportData - START 2017-05-18 09:58:03,001 INFO  [AIF]: cloudServiceType: Planning, Resolved user name for application access: username 2017-05-18 09:58:03,101 INFO  [AIF]: Creating data file: /u03/inbox/outbox/HavenPow_136.dat 2017-05-18 09:58:03,170 INFO  [AIF]: Data file creation complete 2017-05-18 09:58:03,170 INFO  [AIF]: EssbaseService.exportData - END (true) 2017-05-18 09:58:03,329 INFO  [AIF]: EssbaseService.loadData - START 2017-05-18 09:58:03,438 INFO  [AIF]: cloudServiceType: Planning, Resolved user name for application access: username [Thu May 18 09:58:04 UTC 2017]Batch Mode (/B) turned off (/-B) for data loads. [Thu May 18 09:58:04 UTC 2017]Saving metadata on data loads (/IMD) Property file arguments: /D:Scenario /SDM: /DF:DD-MM-YYYY /I:***HavenPow_136.dat No arguments were derived from the command line.Submitted (merged) command line: /D:Scenario /SDM: /DF:DD-MM-YYYY /I:***HavenPow_136.dat [Thu May 18 09:58:04 UTC 2017]Successfully located and opened input file. [Thu May 18 09:58:04 UTC 2017]Input file being read with UTF-8 encoding. [Thu May 18 09:58:04 UTC 2017]Date format pattern "DD-MM-YYYY" specified for date data type loading. [Thu May 18 09:58:04 UTC 2017]Header record fields: Scenario, Point-of-View, Data Load Cube Name, 70151, 70152 [Thu May 18 09:58:04 UTC 2017]Input file member load ordering option (/O switch) will not be performed: this option is not available for the "Period" dimension. [Thu May 18 09:58:04 UTC 2017]HspOutlineLoad::dateFormatSpecified is true, SessionHalDateFormat stored on session: dd/MM/yy, sessionId: 1111539359 [Thu May 18 09:58:04 UTC 2017]Setting autodetected driver member settings: Driver Members: 70151, 70152, Data Load Cube Name: "PlanBud", Load Dimension: "Scenario" Property file arguments: /D:Scenario /SDM: /DF:DD-MM-YYYY /I:***HavenPow_136.dat No arguments were derived from the command line.Submitted (merged) command line: /D:Scenario /SDM: /DF:DD-MM-YYYY /I:***HavenPow_136.dat [Thu May 18 09:58:04 UTC 2017]Successfully located and opened input file. [Thu May 18 09:58:04 UTC 2017]Input file being read with UTF-8 encoding. [Thu May 18 09:58:04 UTC 2017]Date format pattern "DD-MM-YYYY" specified for date data type loading. [Thu May 18 09:58:04 UTC 2017]Header record fields: Scenario, Point-of-View, Data Load Cube Name, 70151, 70152 [Thu May 18 09:58:04 UTC 2017]HspOutlineLoad::dateFormatSpecified is true, SessionHalDateFormat stored on session: dd/MM/yy, sessionId: 1111539359 [Thu May 18 09:58:04 UTC 2017]Setting autodetected driver member settings: Driver Members: 70151, 70152, Data Load Cube Name: "PlanBud", Load Dimension: "Scenario" [Thu May 18 09:58:04 UTC 2017]java.lang.RuntimeException: Not all dimensions were specified. [Thu May 18 09:58:04 UTC 2017]Load dimension "Scenario" has been unlocked successfully. Outline data store load process finished. 1 data record was read, 1 data record was processed, 0 were accepted for loading (verify actual load with Essbase log files), 1 was rejected. [Thu May 18 09:58:04 UTC 2017]Outline data store load process finished. 1 data record was read, 1 data record was processed, 0 were accepted for loading (verify actual load with Essbase log files), 1 was rejected. 2017-05-18 09:58:04,883 INFO  [AIF]: Number of rows loaded: 0, Number of rows rejected: 1 2017-05-18 09:58:05,030 ERROR [AIF]: The data load process has failed. 2017-05-18 09:58:05,034 INFO  [AIF]: EssbaseService.loadData - END (false) 2017-05-18 09:58:05,054 FATAL [AIF]: Error in CommData.loadData Traceback (most recent call last):   File "", line 4769, in loadData RuntimeError: false 2017-05-18 09:58:05,133 FATAL [AIF]: Error in COMM Load Data 2017-05-18 09:58:05,139 INFO  [AIF]: FDMEE Process End, Process ID: 136 Thanks Sri

This post has been answered by JohnGoodwin on May 18 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 16 2017
Added on May 18 2017
13 comments
1,459 views