View not visible after load server

Post Reply
Maxime
Posts: 16
Joined: Mon Mar 24, 2014 1:36 pm
OLAP Product: TM1
Version: CX 10.1 and 10.2
Excel Version: Excel 2012

View not visible after load server

Post by Maxime » Thu Jul 23, 2015 1:36 pm

Hello everyone!

On my server TM1 10.2.2, I currently have a problem after instance startup.

On some cube, no view are present.
On the other, all views have been loaded.

When I look in the data folder, I see always the folder views...

Someone there you an idea of the source of this problem ?

The instance restart hasn't solved the problem.

Thank you in advance !

Maxime

BariAbdul
Regular Participant
Posts: 414
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: TM1,Cognos
Version: 9.5.2
Excel Version: 2007

Re: View not visible after load server

Post by BariAbdul » Thu Jul 23, 2015 2:44 pm

Are the views in question are private views,Because even admin can view private view.Have you check .vue file with for the view in the directory.
"You Never Fail Until You Stop Trying......"

Maxime
Posts: 16
Joined: Mon Mar 24, 2014 1:36 pm
OLAP Product: TM1
Version: CX 10.1 and 10.2
Excel Version: Excel 2012

Re: View not visible after load server

Post by Maxime » Thu Jul 23, 2015 2:54 pm

The views in question aren't private views.

Thank for you reply !

BrianL
MVP
Posts: 262
Joined: Mon Nov 03, 2014 8:23 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2 PA2
Excel Version: 2016

Re: View not visible after load server

Post by BrianL » Thu Jul 23, 2015 9:23 pm

Any error messages in the tm1server.log file?

Are the actual .vue files present in the data directory for the missing views?

Maxime
Posts: 16
Joined: Mon Mar 24, 2014 1:36 pm
OLAP Product: TM1
Version: CX 10.1 and 10.2
Excel Version: Excel 2012

Re: View not visible after load server

Post by Maxime » Fri Jul 24, 2015 7:35 am

I don't have error in the tm1server.log when the server start.
I have error when a user tries to open one of these views in the workflow.

The files .vue are present in the folder.

Yesterday I created a view of a cube where those views are not loaded.
The file has been created in the folder containing the views of cubes.
And when the server restarts tonight, the new view was not loaded.

it's always the same four cubes where the views are not loaded.

Thank you for your reply !

Edit :
I use a "MaximumCubeLoadThreads=31" because i have 32 cores on my server.
On dev server i don't have this problem with a "MaximumCubeLoadThreads=3".
This can it be a source of error?

Maxime
Posts: 16
Joined: Mon Mar 24, 2014 1:36 pm
OLAP Product: TM1
Version: CX 10.1 and 10.2
Excel Version: Excel 2012

Re: View not visible after load server

Post by Maxime » Fri Jul 24, 2015 12:45 pm

I test for the next server re start, to change value of MaximumCubeLoadThreads from 31 to 1 because is the only difference in my tm1s.cfg with dev server.

if you have any idea due to this problem or test to be performed don't hesitate.

User avatar
garry cook
MVP
Posts: 184
Joined: Thu May 22, 2008 7:45 am
OLAP Product: TM1
Version: 10.2.2 SP4
Excel Version: Various

Re: View not visible after load server

Post by garry cook » Fri Jul 24, 2015 1:02 pm

Just a thought - do the 4 cubes share a dimension? May be that you are missing a common subset from one of the dimensions that is used in the views. Worth a quick check of the .sub files maybe.
Yesterday I created a view of a cube where those views are not loaded.
The file has been created in the folder containing the views of cubes.
And when the server restarts tonight, the new view was not loaded.
That wouldn't explain this behaviour though.

Maxime
Posts: 16
Joined: Mon Mar 24, 2014 1:36 pm
OLAP Product: TM1
Version: CX 10.1 and 10.2
Excel Version: Excel 2012

Re: View not visible after load server

Post by Maxime » Fri Jul 24, 2015 1:17 pm

I don't have missing subset, because when i look the missing view on dev server, i can re build the same view on prod server without create new element or subset or other.

declanr
MVP
Posts: 1561
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: View not visible after load server

Post by declanr » Fri Jul 24, 2015 1:19 pm

A long shot but do the views in question have any special characters in their names?

BrianL
MVP
Posts: 262
Joined: Mon Nov 03, 2014 8:23 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2 PA2
Excel Version: 2016

Re: View not visible after load server

Post by BrianL » Fri Jul 24, 2015 1:55 pm

If you can reproduce this at will, you should file a ticket with IBM support. It's clearly a bug if your losing views.

You could try enabling some additional logging
log4j.logger.TM1.View=DEBUG
log4j.logger.TM1.Registration=DEBUG

The view logger outputs whatever info IBM development deemed useful about views. Maybe there's some hint there.
The registration logger should have information about private vs public scope, so it's also possible there might be a hint there.

Ideally, you have logging enabled before creating the view right through a restart and verifying the view no longer exists.

If you really want, you could try attaching the .vue file, but I have no idea if anyone on this board has reverse engineered the file format enough to check if it's corrupted.

User avatar
Steve Rowe
Site Admin
Posts: 1741
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: View not visible after load server

Post by Steve Rowe » Fri Oct 09, 2015 11:14 am

Hi,
We're experiencing a similar issue. 10.2.2. FP2.
Public views not visible in SE
Public views not accessible to TIs
Private views are visible in SE
Public views restored on re-start up
We've not established what causes the views to be dropped from the instance.
We'll probably move to FP4 but just wondering if anyone else has experienced this or has raised a PMR?

Cheers,

silw
Posts: 15
Joined: Wed May 25, 2011 12:39 pm
OLAP Product: TM1
Version: 1022-FP*
Excel Version: 2010-2016

Re: View not visible after load server

Post by silw » Sat Oct 10, 2015 6:48 pm

Hi,

we had this issue on 10.2.2 FP2, but it was not reproducible. So our lab advocate said that they "probably" fix it in FP3 and he "probably" right.

kool2zero
Posts: 5
Joined: Tue Aug 27, 2013 6:26 pm
OLAP Product: TM1 10.2.2.3
Version: TM1 10.2.2.3
Excel Version: 2010

Re: View not visible after load server

Post by kool2zero » Mon Oct 12, 2015 3:01 pm

We're having the same issue and have opened a PMR with IBM. We're on 10.2.2 FP3, so no... FP3 did not fix it.

User avatar
Steve Rowe
Site Admin
Posts: 1741
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Re: View not visible after load server

Post by Steve Rowe » Mon Oct 19, 2015 9:09 am

This issue now has an APAR
- TITLE: PI50558: VIEW FILES DISAPPEAR FROM THE TM1 SERVER'S MEMORY.
- URL: http://www.ibm.com/support/docview.wss? ... SS9RXT-_-E
- ABSTRACT: The view files are still on disk so with a restart of the Tm1 server they come back.

Seems to be a critical defect, most instances won't work very well if all the public views drop....

User avatar
gtonkin
MVP
Posts: 578
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.1
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: View not visible after load server

Post by gtonkin » Thu Jan 11, 2018 12:20 pm

Resurrecting this one as we seem to have the same issue as the OP.

There was a power failure and the server went down at 18 seconds past midnight (in a data center!)
Log file was corrupt and one or two other issues - }Groups attributes cube corrupt and another cube, both restored from earlier backup.

Managed to get server back online but many cubes have lost their views.
-Cubes are fine and new views can be created.
-Old .vue files are present on disk.
-Subsets/Elements referenced in the .vue file are present and can be used to create new views.

As this is a Production environment, we cannot restart until we are given a time slot.

My questions are basically:
1-Did anyone find the cause for this?
2-Did a restart always work?
3-If the restart did not work, what did you need to do to get back the views?

Please let me know if you have any answers on the above.

p.s. The views were not there and then disappeared during operation - they were missing immediately after restarting. Submission deadlines meant we could not stop again and try and deal with the issue then.
Running on TM1 10.2.2. FP4.

User avatar
PowerDim
Posts: 5
Joined: Thu Aug 07, 2014 12:44 pm
OLAP Product: TM1
Version: [9.5.2]_[10.1]_[10.2.2]
Excel Version: Excel 2007_10_13
Location: Moscow, Russia

Re: View not visible after load server

Post by PowerDim » Fri Jan 26, 2018 10:17 am

Hello, Maxime!

If I understand correctly, you have the following situation:
- views are in the folder DATA;
- views consist only of existing subsets and contain existing elements that are displayed at the opening;
- views were previously published and were accessed;
- everything works on the dev, but on another server it doesn`t work.

There is an assumption that the entire path to the views (including the name of the view) on another server is very long, as opposed to the dev. Try, for example, create a view with a shorter name and try to open view again after restart.

Also you wrote about the error, which appears after the user attempts to open the view. Please, send a screenshot.


--
Best regards,
Dmitry

Post Reply