Missing title elements in a view, TM1 9.5 and up

[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

[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]

Thank you Herman, I will play around.

[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]

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]

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]

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

[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]

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]

What are the *.exd files and where can I find them?
Same problem on Windows 2003 server when using TM1 architect or TM1 perspectives

[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

[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

[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

[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

[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

[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]

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

[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

[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.

[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.