TM1 10.2.2 - Issue with TI -- DSN

[Radhika]

Hello Everyone,

We have recently upgraded from 9.5.2 to 10.2.2, we are facing below issue, please help me to fix the issues.

We have created a DSN: EDW in the both the physical boxes ( 952 & 10.2.2), in TI (9.5.2) --> ODBC --> DSN even if i provide edw or EDW preview works (DSN is not case sensitive). But in 10.2.2 --> ODBC --> DSN , here if I type edw..preview does not work but it works if i type EDW, is the DSN name case sensitive in 10.2.2. We have hundreds of TI process where in few have edw and the others have EDW, it would be diifcult to open each and every TI process and modify it. How can we fix the issue ..?

Thanks,
Radhika

[David Usherwood]

Simplest solution is probably to create 2 dsn's - edw and EDW - if Windows will let you.

[Radhika]

Hi David,

I tried, we cannot create two dsn's with the same name (EDW/edw)

Thanks,
Radhika

[dr.nybble]

This is a defect that has been identified in 10.2.2 and fixed for the next release.

It should take only a minute to search/replace your TI processes using an editor like Notepad++ that can do multi-file search/replace.

[Radhika]

Thank you Nybble for the option.
Is there any Fix pack that is released to fix this issue.

Thanks,
Radhika

[dr.nybble]

It will be fixed in 10.2.2 FP1 (which is not released yet).