on 03-02-2015 3:26 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.