Analytics Software

Hi all,

I've been trying to load a file to Planning using Outline Load Utility. The file has 326 records in it. When I first tried to load the whole file, it loaded the first 11 records and then failed. Here is the error message I got:

[Tue Oct 04 08:53:20 PDT 2011] Error occurred loading data record 12: 011621,29702_0002,29702_0002-EAST IOWA REGION-ADMIN (CLOSED 11-11),Never Share,+,ProfitCenter
[Tue Oct 04 08:53:20 PDT 2011] java.lang.RuntimeException: java.lang.Exception: java.lang.OutOfMemoryError: Java heap space
[Tue Oct 04 08:54:00 PDT 2011] Error occurred loading data record 13: 0116211,21210_0002,21210_0002-HARLAN,Never Share,+,ProfitCenter
[Tue Oct 04 08:54:00 PDT 2011] java.lang.RuntimeException: java.lang.Exception: java.lang.OutOfMemoryError: Java heap space
[Tue Oct 04 08:54:00 PDT 2011] Error occurred loading data record 14: 0116211,21212_0002,21212_0002-CARROLL,Never Share,+,ProfitCenter
[Tue Oct 04 08:54:00 PDT 2011] java.lang.RuntimeException: Error loading objects from data source: java.sql.SQLException: [Hyperion][Oracle JDBC Driver]Internal error: Net8 protocol error.
[Tue Oct 04 08:54:00 PDT 2011] Error occurred loading data record 15: 0116211,21214_0002,21214_0002-MANNING,Never Share,+,ProfitCenter
[Tue Oct 04 08:54:00 PDT 2011] java.lang.RuntimeException: Error loading objects from data source: java.lang.ArrayIndexOutOfBoundsException
[Tue Oct 04 08:54:39 PDT 2011]Unable to obtain dimension information and/or perform a data load: java.lang.OutOfMemoryError: Java heap space
[Tue Oct 04 08:54:39 PDT 2011]Planning Outline data store load process finished with exceptions: exceptions occured, examine the exception file for more information. 326 data records were read, 15 data records were processed, 11 were successfully loaded, 4 were rejected.

I increased the heap size to 1000M from 512M.

Then I created 5 test files with 10 records in each file. The first file loaded with no issues. Second file failed with this error message:

[Tue Oct 04 10:24:14 PDT 2011] Error occurred loading data record 2: 011621,29702_0002,29702_0002-EAST IOWA REGION-ADMIN (CLOSED 11-11),Never Share,+,ProfitCenter
[Tue Oct 04 10:24:14 PDT 2011] java.lang.RuntimeException: java.lang.Exception: java.lang.OutOfMemoryError: Java heap space
[Tue Oct 04 10:25:32 PDT 2011] Error occurred loading data record 3: 0116211,21210_0002,21210_0002-HARLAN,Never Share,+,ProfitCenter
[Tue Oct 04 10:25:32 PDT 2011] java.lang.RuntimeException: java.lang.Exception: java.lang.OutOfMemoryError: Java heap space
[Tue Oct 04 10:26:49 PDT 2011] Error occurred loading data record 4: 0116211,21212_0002,21212_0002-CARROLL,Never Share,+,ProfitCenter
[Tue Oct 04 10:26:49 PDT 2011] java.lang.RuntimeException: java.lang.Exception: java.lang.OutOfMemoryError: Java heap space
[Tue Oct 04 10:29:24 PDT 2011] Error occurred loading data record 5: 0116211,21214_0002,21214_0002-MANNING,Never Share,+,ProfitCenter
[Tue Oct 04 10:29:24 PDT 2011] java.lang.RuntimeException: java.lang.Exception: java.lang.OutOfMemoryError: Java heap space
[Tue Oct 04 10:30:41 PDT 2011]Unable to obtain dimension information and/or perform a data load: java.lang.OutOfMemoryError: Java heap space
[Tue Oct 04 10:30:41 PDT 2011]Planning Outline data store load process finished with exceptions: exceptions occured, examine the exception file for more information. 10 data records were read, 5 data records were processed, 1 was successfully loaded, 4 were rejected.
[Tue Oct 04 10:51:42 PDT 2011] Error occurred loading data record 2: 0116211,21210_0002,21210_0002-HARLAN,Never Share,+,ProfitCenter
[Tue Oct 04 10:51:42 PDT 2011] java.lang.RuntimeException: java.lang.Exception: java.lang.OutOfMemoryError: Java heap space

I thought it failed due to the paranthesis in the alias, but I don't think it is the case, since the fifth file that has no special characters or paranthesis also failed.

Any idea why this is not working and driving me nuts? John, are you still up? It is only 8:50 PM in England, come on! :)

Just FYI, we are on 11.1.1.3 and Planning is on UNIX.

Thanks,
Mehmet