Question Java Heap Space error

Hi,

I am loading 190 MB excel file in stambia
excel file have 12 sheet, when I try to consult data I am getting java heap space error

I have check my stambia.ini file
where min and max size is -Xms512m
-Xmx1024m

Please guide me to resolve error.

Thanks and Regards,
Prashant Sangle

Hi,

Please find error screen shot of it.

Update: Also if I create mapping between source and target tables then mapping arrow not coming.
If I run such mapping then empty process executed.
I am confused not getting what is happening

Thanks and Regards,
Prashant Sangle

Hi,

I also have memory overflows when trying to consult data from big excel files. I will ask my dev team colleagues if there are plans to improve this.

I don't understand what may be the cause for the non-working mapping. Can you send an "Export models and dependencies" of your mapping to the Support?

Hi,

Actually mapping arrow issue is coming with that excel file only. Other wise it is working fine.

Thanks and Regards,
Prashant Sangle

OK, feel free to send the "Export models and dependencies" to the Support if you are still blocked.

Hi,

Sorry for late reply.

Please find attached file which have mapping arrow issue.

Let me know if details required.

Thanks and Regards,
Prashant Sangle

I had a look, it seems to be due to the Sheet node name, starting with number (01-Apr-15$).
Try prefixing the Name attribute with letters, for example "A_01-Apr-15$" and let me know if it maps.
Note: no need to rename your Excel Sheets, really just set the logical "Name" attribute in the metadata.