TM1 Forum

Hi Everyone,

We are reading records from an Oracle DataMart and have come across a situation where TM1 seems to be interpreting a control character differently in the metadata and data tabs. An asciioutput in the metadata tab shows the field value as "EDL ¿ WKPP" whereas in the Data tab it shows as "EDL ? WKPP". In SQLDeveloper it shows as EDL ¿ WKPP.

Even more interesting is that on some of our TM1 Instances the asciioutput from both tabs is "EDL ¿ WKPP".

All Instances are using TM1 Build 10.2.20100.123.

Anyone seen this before or have any ideas as to why it might be?

thanks,

Gregory

Hello,

I have seen situations before that sound similar.
I would advise to have a look at settings in the TM1s.cfg file:

http://www-01.ibm.com/support/knowledge ... ded_1.html

Parameter type: optional, dynamic

UseSQLFetch=T
UseSQLFetchScroll=T
UseSQLExtendedFetch=T

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

Thanks Wim & Brian for your pointers.

Turning off the "Use Unicode" option caused the field to appear as "EDL ? WKPP" in both Metadata and Data tabs.
So that at least gives a consistent result between the 2 tabs.

Here are the results;

Original Instances - Use Unicode ON or OFF
Metadata Tab - "EDL ¿ WKPP"
Data Tab - "EDL ¿ WKPP"

New Instances - Use Unicode ON
Metadata Tab - "EDL ¿ WKPP"
Data Tab - "EDL ? WKPP"

New Instances - Use Unicode OFF
Metadata Tab - "EDL ? WKPP"
Data Tab - "EDL ? WKPP"

So there are 2 mysteries;

1. Why some instances treat the character differently to others and
2. Why the Unicode setting causes the field to appear differently in the 2 tabs (but only on the new instances).

Go figure...