DS code behaving differently in different environment

s_gsl@yahoo.co.in · Post by **s_gsl@yahoo.co.in** » Tue Sep 01, 2015 12:22 pm

Hi, I have same DSX in prod and DEV. But while selecting any value from DUAL in prod it is padding some space where as in dev it is not. I can ensure no change in DS jobs. Could someone put any light what could be the issue?

chulett · Post by **chulett** » Tue Sep 01, 2015 12:26 pm

Are these actually Server jobs? Do you have this issue with all Oracle sources or just literally when you select something from DUAL?

s_gsl@yahoo.co.in · Post by **s_gsl@yahoo.co.in** » Tue Sep 01, 2015 12:42 pm

Yes, this is a server job. We are getting this issue while doing a look up (Oracle -- >Hash File-->Transformer) and the field is CHAR(2). Then we tried to simple querying DUAL table to select any value and see the issue is PROD version is adding extra spaces where as DEV is not. I am not sure how can i attach an image here else i can send the screen shot. Anyway, thanks for your help.

PaulVL · Post by **PaulVL** » Tue Sep 01, 2015 1:03 pm

What is your APT_STRING_PADCHAR set to in each project/environment?

chulett · Post by **chulett** » Tue Sep 01, 2015 1:18 pm

I don't believe that affects Server jobs at all...

ArndW · Post by **ArndW** » Wed Sep 02, 2015 2:39 am

Are the two jobs SELECTing the same database? If not, the basic database settings might be different.

s_gsl@yahoo.co.in · Post by **s_gsl@yahoo.co.in** » Wed Sep 02, 2015 5:38 am

Yes, both the databases are same.

chulett · Post by **chulett** » Wed Sep 02, 2015 8:03 am

'Same' as in exact same database or they are two different databases but set up exactly the same?

Where exactly is this CHAR(2) in your job? I'm more surprised to hear it doesn't get padded with 'an extra space' in DEV than it does happen in PROD. That's the nature of CHAR fields, they automatically pad out to their full size. Parallel jobs have an option to control what character is used for the padding which is why Paul asked his question, Server jobs not so much.

ray.wurlod · Post by **ray.wurlod** » Wed Sep 02, 2015 4:41 pm

You are going to have to work out what is different between the two environments. Clearly something is.