Page 1 of 1
Please help, report can't be open after updating SSL
Posted: Mon Nov 14, 2016 10:21 pm
by macsir
We have recently updated SSL and overall it is good. But for some tm1 web reports, they can't be opened at all and there is an error in the log,
TM1.Blob CommitDeferredFileCommand - BLOB_FILE_CLOSE is pending all blob readers to drain out. Any updates will not be fully committed until this happens or the server is shutdown.
The mouse is just keeping spinning in tm1 web and finally error pops up in the web with the error above in the server log.
Any idea?
Re: Please help, report can't be open after updating SSL
Posted: Mon Nov 14, 2016 11:08 pm
by macsir
It looks like we are falling into this bug
http://www-01.ibm.com/support/docview.w ... wg1PI51974
I did found similar error in our server log for the reports which can't be opened.
DEBUG 2015-10-28 22:19:32.951 TM1.Blob FreeMemory - Blob
"AFR2C_ListeSalSSAff_CDG_20150320150134.xlsx" has open file
handles, closing now. This will flush and pending writes to
disk.
Re: Please help, report can't be open after updating SSL
Posted: Tue Nov 15, 2016 12:33 am
by tomok
Did you try deleting the report and re-publishing?
Re: Please help, report can't be open after updating SSL
Posted: Tue Nov 15, 2016 1:01 am
by macsir
tomok wrote:Did you try deleting the report and re-publishing?
Yes, I tried. Still doesn't work. They work fine in perspectives. And I can see TM1 try to save the report file back to Externals folder with same file name but xlsx$ extension.
Re: Please help, report can't be open after updating SSL
Posted: Tue Nov 15, 2016 1:03 am
by macsir
And I can see the size of dump and phd files in TM1 installation folder increased a lot when the issue is happening.
Re: Please help, report can't be open after updating SSL
Posted: Tue Nov 15, 2016 4:25 am
by macsir
So, just deleted all unnecessary sheets which are created by someone and problem solved.