DS Migration 4.2.4 variable value - showing special char

[Former Member]

Hi,

After migrating from DS 4.2.3 to 4,2,4, one of the data flow conditional variable value is passing as '¿¿¿'  instead of actual character.

Following activities have been made to see whether this will resolve.

1. Global variable value in script and print - OK

2. run in debug mode - OK

3. change the scope to Local and pass parameter value - Not working

4. passing variable as a condition in data flow - Not working in fact its converting actual value into "inverted question mark".

any ideas or help will be much appreciated.

Thanks

Jagan

[former_member106536]

SAP had to provide us with a special patch to fix our global variables.

Global variables contained within certain jobs would become corrupt as it executed.

You could print the contents in a script, but then as it executed ... somehow it would become corrupted.

[Former Member]

I believe you are working in an Oracle environment since the inverted question mark is the Oracle SQL*Net character replacement.You will need to modify your NLS_LANG settings to UTF-8 on the server as well as all datastores.

-Chaitanya

[Former Member]

Thanks Chaitanya,

Yes, source and target is oracle. Also, metadata is in SQL Server. However these settings are same across ours landscape in both DS3 and DS4 with UTF 8.

The DS4 server is set to AMERICAN_AMERICA.UTF8 the same as DS3

Moreover its only happening in one dataflow condition and script is showing the right value - 'Actual'

EX_PCM_POST_ALLOCATION"."PCM_VERSION" = '¿¿¿'.

Cheers,

Jagan

[Former Member]

I am not very sure and maybe others on the forum can help. But just to make sure, can you also verify your datastore settings as well as your AL_ENGINE settings in the ds config file/

-Chaitanya