DSXchange

Hi ray, Folowing is the input and ouput parameter values in 2 env. Input Job starting ---- Env 2 Ouptut ---- Env1 Output AB\",\"CD ---- AB\",\"CD ---- AB","CD AB\',\'CD ---- AB\,\CD ---- AB','CD (Desired o/p) AB','CD ---- AB,CD ---- AB,CD AB','CD ---- AB,CD ---- "A...

Yes ray. that issue is not being resolved yet.

In my previous replies, i have posted the output using peek stage and passeing only parameter value to it. with all the option i checked as suggested by you and craig

let me know if you want more detials, i will provide

Hi,

The sample job which was created with the row generator and trasnformer and output to peek stage. There was no ODBC or oracle stage used.

In this case the output was same as mentioned earlier.

So, is there any specific env. variable which can cause this issue

Please suggest

Hi Craig, I have checked on the environment variable in both env. The difference observed is as follows in the job log environment variable of the job ran as i have listed the o/p in previous posts- Env 1- ORACLE_HOME=/opt/oracle/lin-10.1.0.4 ORACLE_SID=ABC CONSOLE=/dev/console LD_LIBRARY_PATH has l...

Here i am using Oracle Database!!

Ray,
I have asked the admin of the ds env. they told me both the env. are same in term of OS and hardware.

Only diffrence i can see is that in Env 1 there are 2 nodes
and Env 2 there are 4 node configuration.

Please suggest if this can create such an issue?

Hi Arndw and Craig, I have seen the output of the job in both the environemnt using peek stage. given mulpile intput to the paramter value, it is as follows - Input Env 2 Output (in which Env 1 Output issue is there) AB\",\"CD AB\",\"CD AB","CD AB\',\'CD AB\,\CD AB','CD...

The fix has been applied, New version of CASS DB was installed in the server and it resolved the errors.

Hi,

Is there any Environemnt variable which shows the query that is used to retrive data from Database in job log

Hi Craig,

we have used Peek stage just after the ODBC stage (where clause) is been given but as mentoined earlier the data is not been picked from the Database (0 records).

Please suggest how to write the query been given to Database to peek stage.

Hi Craig,

In other environment i am fecthing the data from same database and same job as used in env. in which job is working.

I have cofirmed that both environments are on same operating system/hardware platform

Thanks craig for the reply!!

But if this is not the environment issue then what is causing the job to behave diffrently in both environments?

Can you please guide on this

Thanks for the response!!

Should i have peek stage as output to the stage where i am using where clause?

Hi, I facing a problem while using mutiplie parameters in where clause. the sql query is as below - Where code in ('#$CODE#') The value of parameter #$CODE# is AB\',\'CD I have seen a post in the forum on this to use "\" slash as the complier does not identify the parameter value correctly...