Please help, report can't be open after updating SSL

Post Reply
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Please help, report can't be open after updating SSL

Post 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?
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Please help, report can't be open after updating SSL

Post 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.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Please help, report can't be open after updating SSL

Post by tomok »

Did you try deleting the report and re-publishing?
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Please help, report can't be open after updating SSL

Post 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.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Please help, report can't be open after updating SSL

Post 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.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Please help, report can't be open after updating SSL

Post by macsir »

So, just deleted all unnecessary sheets which are created by someone and problem solved.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Post Reply