Missing title elements in a view, TM1 9.5 and up

Post bug reports and the status of reported bugs
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Missing title elements in a view, TM1 9.5 and up

Post by Wim Gielis »

Hello,

It seems that in TM1 9.5 and TM1 9.5.1, a number of views are incorrect as they do not show the title elements. They all work well in TM1 9.4 and below.

Unfortunately, it is not the case on all cubes, nor on all views of the same cube. Nothing special happens in the dimensions, just normal dimensions with simple structures. No security whatsoever. I am logged in as Admin.

Anyone seen this before? Thanks.

Tested environment: 4 GB RAM laptop, Win 7, TM1 9.5, TM1 9.5.1

Wim
Attachments
Ontbrekende titel elementen.doc
(47 KiB) Downloaded 2145 times
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Herman Moller
Posts: 70
Joined: Thu May 22, 2008 3:38 pm

Re: Missing title elements in a view, TM1 9.5 and up

Post by Herman Moller »

Wim,

I have noticed that before with a client running Windows 7. The client installed the client on another machine and it worked(non windows 7). I had thought afterwards they could have deleted the tm1p.ini file and this could have cured the problem.

Herman
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Missing title elements in a view, TM1 9.5 and up

Post by Wim Gielis »

Thank you Herman, I will play around.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Quail
Posts: 5
Joined: Mon Jul 05, 2010 6:02 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Re: Missing title elements in a view, TM1 9.5 and up

Post by Quail »

Hi
I have also come across this issue and as suggested on this thread, have deleted and reinstated the tm1p.ini file but to no avail. Does anyone have any other idea of how to solve this issue?

Interestingly, earlier this year I was using TM1 9.5 on a different Windows 7 machine and had no issue at all. Now I am using TM19.5.1 on a new HP notebook and I have the issue.

cheers
Quail
laenen
Posts: 47
Joined: Tue Mar 09, 2010 6:40 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2003

Re: Missing title elements in a view, TM1 9.5 and up

Post by laenen »

Does this happen for every view or just some?
Have you checked your available memory when this occurs?
If you reboot the machine does it go away?
Quail
Posts: 5
Joined: Mon Jul 05, 2010 6:02 am
OLAP Product: TM1
Version: 9.5
Excel Version: 2007

Re: Missing title elements in a view, TM1 9.5 and up

Post by Quail »

Hi Ianen

Its not a memory issue - I am working in a dev environment - very little data, no rules and only one cube! It happens with all views and rebooting has no effect at all!

Would it be anything to do with the fact that we are working with Windows 7 in a 64 bit environment?

cheers

Quail
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Missing title elements in a view, TM1 9.5 and up

Post by Wim Gielis »

Me too, I'm on TM1 9.5 and 9.5.1.

No memory issue as far as I know.

I have WIN 7 in a 64 bits environment.

Strange thing is, it is not with all views and / or all cubes. Also, if you shift some of the title dimensions (that has missing elements) to the columns for instance, there the elements show up. Moving back to the title elements, it's stuck again.

But keeping the dimension in the columns, it could be that the other title dimensions are okay again!!!

I don't understand this at all.

Thanks,

Wim
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
laenen
Posts: 47
Joined: Tue Mar 09, 2010 6:40 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2003

Re: Missing title elements in a view, TM1 9.5 and up

Post by laenen »

I have seen it in 9.4.1 FP3 so far it has only been customers with x64 bit installations. I am not aware of anyone that has had this problem with x86.

Have either of you run Dependency Walker to see if there is a dll issue?
laenen
Posts: 47
Joined: Tue Mar 09, 2010 6:40 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2003

Re: Missing title elements in a view, TM1 9.5 and up

Post by laenen »

This issue seems to be caused by .exd files in the user profiles. I have been able to resolve it after removing these files
gabi
Posts: 25
Joined: Thu Jun 19, 2008 12:44 pm

Re: Missing title elements in a view, TM1 9.5 and up

Post by gabi »

What are the *.exd files and where can I find them?
Same problem on Windows 2003 server when using TM1 architect or TM1 perspectives
Gabi Cohen
Biconix International
User avatar
Olivier
Community Contributor
Posts: 159
Joined: Thu Jun 26, 2008 5:46 am
OLAP Product: TM1
Version: Tm1 10.2.2fp4 -> 2.09
Excel Version: Excel 2013 - 2019
Location: Sydney

Re: Missing title elements in a view, TM1 9.5 and up

Post by Olivier »

Hi All,

I posted a similar bug in the main forum as i forgot about this specific bug section.

I guess i will start the quest of the ".exd" files and post the outcome.
Few monthes ago, i tryed a base 9.4 version install and migrated our production model hosted in 9.1sp3 ( just a copy ).

The installation was done without any issue.
The server started just fine and so far everything looked good.

When started exploring the cubes/views in this new 9.4 environment , i quickly noticed 2 major issues :
1 - some of the title selections were changed compaired to the original view settings
(i. a high level ebit monitor view suddently display total cost as account selection while the view was saved with EBIT selected)
2 - In certain views ( not all of them and not for the same dimensions), some title dimensions were not showing the active selection giving the impression that nothing is selected.
Note : if the view is sliced, then the title field would be showing correctly in the excel spreadsheet.
I have attached a screenshot of what the view looks like with 3 of the title fields impacted. (the last 3 title fields.)

I believed at the time that it was one of the reason that MR1 was made
and stopped the testing phase to plan another one using MR1 and the 3 Fix Packs.

We have started to test 9.4mr1 including FP1, 2 and 3 and unfortunatly it reproduces these inconsistent views bugs.
This is definetly a no go for using this in production.

My assumption is that it can be a side effect of a "conversion" from a Datafolder from 9.1sp3 to 9.4mr1...
Which would mean upgrading mean recreating all the cubes and the rest from scratch in the new environment ? (the risquiest upgrade ever).

Did anybody encounter a similar type of bug when upgrading an old TM1 database from 9.1sp3 or older to 9.4, 9.4mr1 or 9.5version ?
Our server OS is Window server 2003 and Perspective is run through Excel 2003.

Thanks for your inputs,

Kind Regards,
Olivier
Attachments
View Bug - 9.4mr1 SP3.jpg
View Bug - 9.4mr1 SP3.jpg (69.37 KiB) Viewed 142292 times
HTH
Olivier
User avatar
Olivier
Community Contributor
Posts: 159
Joined: Thu Jun 26, 2008 5:46 am
OLAP Product: TM1
Version: Tm1 10.2.2fp4 -> 2.09
Excel Version: Excel 2013 - 2019
Location: Sydney

Re: Missing title elements in a view, TM1 9.5 and up

Post by Olivier »

Ho ho ho,

I cannot locate the .exd files that are mentioned in earlier posts...
Does anyone have an idea where to find these ?

Otherwise it sounds like it s time to send a letter to IBM support Santa :)

Kind Regards,
Olivier
HTH
Olivier
User avatar
Olivier
Community Contributor
Posts: 159
Joined: Thu Jun 26, 2008 5:46 am
OLAP Product: TM1
Version: Tm1 10.2.2fp4 -> 2.09
Excel Version: Excel 2013 - 2019
Location: Sydney

Re: Missing title elements in a view, TM1 9.5 and up

Post by Olivier »

ho ho ho,

I have send a support request to IBM and it is already actionned.
I will post the resolution if any as soon as it comes back to me.

Kind Regards,

Olivier
HTH
Olivier
User avatar
Olivier
Community Contributor
Posts: 159
Joined: Thu Jun 26, 2008 5:46 am
OLAP Product: TM1
Version: Tm1 10.2.2fp4 -> 2.09
Excel Version: Excel 2013 - 2019
Location: Sydney

Re: Missing title elements in a view, TM1 9.5 and up

Post by Olivier »

Quick update,

I noticed that the bug does not reproduce when exploring the cubes/views from a perspective client installed on another machine then the tm1 server itself.
So the bug might not be a show stopper as we barely use the server explorer from the server box itself.

I had some feedback that the issue itself might be related to non tm1 component installed of the server such as anti virus as it was observed and resolve by IT department of another company by installing server component one by one untill isolating the bug source item.
I am a bit challenge to test that as my tm1 test server is also production server for other applications.

If anybody as a clue of which server software is likely to produce the issue please let me know. :?:

The support process from IBM consists in attempting to apply hot fixes 4, 7 and 12.
HF 4 and 7 do not solve the issue.
HF 12 prevents my server from starting so we will stay with HF7 for now.
IBM is not able to reproduce the bug from their end.

I will now focus my testing on the client PC with perspective to check if this bug or any other impact us.


Kind Regards,
Olivier
HTH
Olivier
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Missing title elements in a view, TM1 9.5 and up

Post by Wim Gielis »

Hi

I just tried TM1 9.5.2 on Windows 7, 64 bits, to no avail. Oftentimes, subsets in the title dimensions of the Cube viewer appear empty and hence very narrow.

Wim
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
applix_mc
Posts: 16
Joined: Mon Jun 02, 2008 3:11 pm

Re: Missing title elements in a view, TM1 9.5 and up

Post by applix_mc »

Some new updates on this one as it is effecting a lot of users running win7 x64. At first I thought it had to do with laptops only and specifically Dell ones as the IBM thinkpads in house did not display this problem. However in one of the earlier threads this was reported on an HP so there goes that theory.

While working with Partner Revelwood yesterday we had them run a series of test where they had a Tm1 (x64 bit) server running on their Dell laptop which was running Win7 x64.

1. Connected to my server from another box (W7 x64) – No cube viewer issues
2. Connected to my server from another box (W7 x86) – No cube viewer issues
3. Connected to my server from another box (XP) – No cube viewer issues
4. Ran server on another box (W7 x64) – Connected to that server from my laptop – Same cube viewer header issues
5. Ran server on another box (W7 x86) – Connected to that server from my laptop – Same cube viewer header issues
6. Ran server on another box (XP) – Connected to that server from my laptop – Same cube viewer header issues

Now what Revelwood found was if they run in safe mode and re-ran steps 4, 5 and 6 as well as running both client and server on their same laptop - the problem went away.

After further investigation there seems to be some "bloatware" installed on the laptops called DigitalPersona Pro.

From Revelwood:
"This is some type of fingerprint software that came pre-installed in all of our Dells.
To troubleshoot, in case anyone else has the issue caused by other conflicting software, I booted in Safe Mode, then noticed problem went away.
Then I went to msconfig, turned off all startups, and narrowed it down to the conflicting software
"


Hope this information helps and big thanks to Revelwood for debugging this one.
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Missing title elements in a view, TM1 9.5 and up

Post by Wim Gielis »

Hi there

I followed the useful information above, and pinpointed the problem with a startup item called "nwiz" (nwiz.exe).

I disabled it in msconfig and now the title elements show up nicely.

Thanks for the guidance, much appreciated.

Wim
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
thomaskday
Posts: 8
Joined: Mon Apr 26, 2010 2:38 am
OLAP Product: TM1 / Planning Analytics Local
Version: PA2 Local 2.0910, PAW 2.074
Excel Version: 2016 and 365
Location: Sydney, Australia

Re: Missing title elements in a view, TM1 9.5 and up

Post by thomaskday »

Wim,

I came across a similar experience when using HP laptops. It appears that some of the pre-installed HP utilities casused a similar issue. Problem was the HP Protectection tools (HP Protect and HP manager) that were causing the loss of title elements. Remove them and TM1 is happy. :?

Cheers
Thomas
User avatar
BigDSter
Posts: 55
Joined: Thu May 15, 2008 8:02 am
OLAP Product: TM1
Version: 9.4.1
Excel Version: 2007
Location: Preston

Re: Missing title elements in a view, TM1 9.5 and up

Post by BigDSter »

Just had the same problem on a Windows 7 64bit laptop

Tried
Office 2010 32bit with 9.5.1 - Missing title dimensions
Office 2010 32bit with 9.4.1 - Still some missing
Office 2007 32bit with 9.5.1 - Missing
Office 2007 32bit with 9.4.1 - Still missing

So in a bit of inspiration our ops guys disabled running apps one at a time until it worked, seemed it was down to some single sign in software we use called imprivata.

Close that and it worked fine, thankfully, as this was our test user for a new Win 7 64bit Office 2010 rollout.
David Newton
Burtons Foods
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Missing title elements in a view, TM1 9.5 and up

Post by Alan Kirk »

I had this one just tonight (9.5.2). It wasn't happening on all views on all cubes but I once it started happening I could reproduce it on the same cubes repeatedly.
- Did a search and found this thread.
- Deleted .exd files - Did nothing.
- Deleted .ini file - Did nothing.
- Deleted contents of Temp folder - Did nothing.
- Found this link on IBM's site which was... not entirely helpful, given that this is clearly happening on machines which have never had "DigitalPersona Pro" anywhere near them, and which were NOT necessarily Dell or HP. (Mine was neither, and indeed I do not deal with Dell, a company which I consider to be parasitic scum, in any way that doesn't involve needles and voodoo dolls.)
- Reinstalled base client.
- Reinstalled FP1.
- Problem no longer occurred.

Which brings me to the reason that I don't consider the Support document to be that helpful. I did not disable any startup programs. I did not uninstall any software other than the TM1 client. Does it not seem reasonable to assume that this is, in fact, something that is going wrong in the client? For if it was truly and always an issue with the client interacting with other software... all of that software is still there, and you would expect that the interaction problem would persist.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Post Reply