TM1 Forum

Thanks BrianL, that WORKED!!! Apparently this cogstartup.xml file is only used by a local server. Our "remote" TM1 server and admin server are configured to use the v2 certificate. I just couldn't figure out how to get a "local" admin server to use it. Thanks again. I would have...

If I'm understanding correctly, you've updated your local instance tm1s.cfg to use the V2 certificates, but NOT the admin server. Unfortunately, the IBM documentation only describes how to change the certificate version via Cognos Config. If you're not using that, you'll need to edit the cogstartup....

Wait state indicated is IXC. Just FYI, threads in an IXC wait state will resume running one at a time. Here's an example. If you have one thread running and ten more in an IXC behind that one running thread, when the running thread completes a single thread in IXC state will be 'woken' up and start...

Did you run importsslcert.exe as administrator? Looks like the certificates aren't properly registered on the server machine.

If you're using CAM, group membership is refreshed from the CAM directory at every login.

If your colleague is just adding you to the group inside of TM1 (while you are already logged in) but not the related group in CAM, it would nicely explain your issue.

I believe the reason you see changes in the .cub file at various times when re-ordering is that TM1 does not do a complete re-write of the .cub file every time data is stored, this would greatly slow down the system when saving. It does an incremental save some of the time which saves just changes,...

I prefer using LogOutput over AsciiOuput. I can then leave the debug statements in the code all the time and only enable the logging as needed via the tm1s-log.properties file.

But I think I still have a fundamental question that goes to how tries work and how they are built. In this case the set of updated cells will be unique for each of the 24 threads, but what level is the commit made, cell-by-cell or whole trie? I'm pretty sure whole trie, so what does a trie contain...

I'll answer to the best of my knowledge from both my own experience and things I've been told by IBMers. First about the lock manager and contention. As you are already aware (and taking advantage of) PI removes much of the lock contention from cell data writes. TM1 will allow multiple TI processes ...

IBM *just* released a support alert for the expiring certificates.

http://www-01.ibm.com/support/docview.w ... wg21990869

Not sure if it has any new information as I have yet to read through all the links, but maybe someone will find it helpful.

I found a workaround for Turbo Integrator (TI) processes: - use the new function DisableMTQViewConstruct() in the Prolog if you use a view as a datasource: You can also disable the MTQ feature for all TI datasources globally by setting MTQQuery=F in your tm1s.cfg. The option doesn't appear to be do...

At the moment installing V2 certs seems to be the only way before a new 1024 certs are made available via fix. Not entirely true. You could always take the more secure path and use your own certificates. Not that IBM makes this easy either, but when done right is more secure than using the same sha...

The tm1s.cfg file for both model is using the same ports property (PortNumber=5010, ClientMessagePortNumber=12346). But the strange thing is only the model which started at the later time is able to show ‘TM1 Server Ready’ status. This will NOT work. At best only one TM1 server will be able to star...

IBM has been shipping updated SSL certificates for a while. They're just not the default. The 'v2' certificates expire in 2022 and contain a 2048 bit key instead of the default 1024 bits. Using these certificates is a much better option than disabling SSL, and is one you can already start testing/de...

Do you have the "use unicode" checkbox enabled for this datasource?

tomok wrote:Since you can't do that in TI, in conjunction with ASCIIOutout, then you'll have to write a bunch of loops inside loops.

This is one case where java extensions could provide useful as recursive functions and calls to AsciiOutput are trivial in java.

Hi we are currently running TM1 10.2.2 FP4 (64bit), Development - Planning Sample model We are trying to test the latest version and having some issues. While it's not clear what version you are attempting to test, the latest fixpack (10.2.2 FP6) has deprecated some older SSL algorithms by default ...

Have you seen the new native support for MTQ as a view datasource added in 10.2.2 FP6?

http://www-01.ibm.com/support/docview.w ... wg27048366

This should completely leverage stargates for the calculation and consumption of the view.

No idea why the APAR is still open, but this issue is fixed in FP5 and newer.

It looks like the the TI process is touching the client objects. Are you doing anything with the TM1User() function or the }Clients dimension in the TI?