Maximo Open Forum

I notice that in Maximo 7.6.1.2, selecting auto-layout instead of Fixed-layout can cause heap exhaustion eg out of memory for large reports- but this is the only way I have been able to get single tab xlsx output/exports. Does anyone know how to figure out how to ameliorate this?
#EverythingMaximo

------------------------------
Jeff Kish
interloc solutions
------------------------------

Are you saying that in 7.6.1.2 the auto layout is more problematic than it was in previous versions? Or just that even in 7.6.1.2 there's an issue when you utilize auto vs fixed layout? If something has gotten worse, I would definitely open a case as there hasn't been a significant version update to the version of BIRT for a while (though it's listed on our roadmap to update the BIRT platform https://ibm-ai-apps.ideas.ibm.com/ideas/MASM-I-427). 

It's been a few years since I was heavily involved in report development but I don't believe I've ever switched to fix layout. I worked on some extremely long running reports (like the Asset rollup) but those problems weren't so much in the amount of data being received but the calculations being done for the report so my focus was always on the SQL & the database. The out of memory issues I saw related to reports tended to be long running QBRs where they didn't provide the appropriate filter during report creation. I've unfortunately never had to tweak a report from a memory perspective that was returning the proper dataset.

------------------------------
Steven Shull
IBM
------------------------------

I am just getting into reports despite decades of consulting- I just found that I could cause xlsx output to be one tab if i had autolayout and certain pagebreaks selected, but it would run out of memory if i used all sites as a parameter. if i did exactly the same with fixed layout it runs fine but i can get a hundred tabs on the clsx output. I cant speak to a comparison to past versions

------------------------------
Jeff Kish
interloc solutions
------------------------------

Original Message:
Sent: 10-24-2021 20:04
From: Steven Shull
Subject: Birt

Are you saying that in 7.6.1.2 the auto layout is more problematic than it was in previous versions? Or just that even in 7.6.1.2 there's an issue when you utilize auto vs fixed layout? If something has gotten worse, I would definitely open a case as there hasn't been a significant version update to the version of BIRT for a while (though it's listed on our roadmap to update the BIRT platform https://ibm-ai-apps.ideas.ibm.com/ideas/MASM-I-427). 

It's been a few years since I was heavily involved in report development but I don't believe I've ever switched to fix layout. I worked on some extremely long running reports (like the Asset rollup) but those problems weren't so much in the amount of data being received but the calculations being done for the report so my focus was always on the SQL & the database. The out of memory issues I saw related to reports tended to be long running QBRs where they didn't provide the appropriate filter during report creation. I've unfortunately never had to tweak a report from a memory perspective that was returning the proper dataset.

------------------------------
Steven Shull
IBM
------------------------------

Hello Jeff

I always use auto layout and in maximo either of the two options 

Xls microsoft spreadsheet
or
xlsx microsoft 2007 spreadsheet 
works to get the output in one tab. 

I am not sure how much data is retrieved but it does work. 

------------------------------
vineet joshi
Asset Analytix
------------------------------

Original Message:
Sent: 10-24-2021 20:43
From: Jeff Kish
Subject: Birt

I am just getting into reports despite decades of consulting- I just found that I could cause xlsx output to be one tab if i had autolayout and certain pagebreaks selected, but it would run out of memory if i used all sites as a parameter. if i did exactly the same with fixed layout it runs fine but i can get a hundred tabs on the clsx output. I cant speak to a comparison to past versions

------------------------------
Jeff Kish
interloc solutions
------------------------------


Original Message:
Sent: 10-24-2021 20:04
From: Steven Shull
Subject: Birt

Are you saying that in 7.6.1.2 the auto layout is more problematic than it was in previous versions? Or just that even in 7.6.1.2 there's an issue when you utilize auto vs fixed layout? If something has gotten worse, I would definitely open a case as there hasn't been a significant version update to the version of BIRT for a while (though it's listed on our roadmap to update the BIRT platform https://ibm-ai-apps.ideas.ibm.com/ideas/MASM-I-427). 

It's been a few years since I was heavily involved in report development but I don't believe I've ever switched to fix layout. I worked on some extremely long running reports (like the Asset rollup) but those problems weren't so much in the amount of data being received but the calculations being done for the report so my focus was always on the SQL & the database. The out of memory issues I saw related to reports tended to be long running QBRs where they didn't provide the appropriate filter during report creation. I've unfortunately never had to tweak a report from a memory perspective that was returning the proper dataset.

------------------------------
Steven Shull
IBM

Yes but auto layout fails when my report brings back the maximum data, however fixed does not fail. However fixed yields multiple xlsx tabs

Sent from my iPhone


Original Message:
Sent: 11/1/2021 9:04:00 AM
From: vineet joshi
Subject: RE: Birt

Hello Jeff

I always use auto layout and in maximo either of the two options 

Xls microsoft spreadsheet
or
xlsx microsoft 2007 spreadsheet 
works to get the output in one tab. 

I am not sure how much data is retrieved but it does work. 

------------------------------
vineet joshi
Asset Analytix
------------------------------


Original Message:
Sent: 10-24-2021 20:43
From: Jeff Kish
Subject: Birt

I am just getting into reports despite decades of consulting- I just found that I could cause xlsx output to be one tab if i had autolayout and certain pagebreaks selected, but it would run out of memory if i used all sites as a parameter. if i did exactly the same with fixed layout it runs fine but i can get a hundred tabs on the clsx output. I cant speak to a comparison to past versions

------------------------------
Jeff Kish
interloc solutions
------------------------------

Yes its a bit tough to troubleshoot this - the worst part is putting it in the desired format allows printout of xlsx on one tab which I want but cant seem to get


---------------------------------
Jeff Kish
interloc solutions
---------------------------------