Bug in pivot stage ???

nagarjuna · Post by **nagarjuna** » Wed Jun 03, 2009 10:32 pm

Hi ,
Today i developed a parallel job .My requirement is to do horizontal pivot .So , i have used the pivot stage .
The job is getting aborted after having a warning arthimetic overflow.So , i have developed another simple job which has pivot stage and that job is working fine .
After an ordeal of 1 hr , i came to know that bigint field is giving the problem Further i observed that whenever the input is having a field of datatype bigint job is failing .

Just i want to know is it a bug or it is as expected ? Is there any restriction on the datatypes to use in pivot stage ?

Please throw some light on this .

Thanks in advance .

ray.wurlod · Post by **ray.wurlod** » Wed Jun 03, 2009 11:56 pm

Is the output field also BigInt, or only Integer or smaller? That would be the typical cause of an arithmetic overflow.

nagarjuna · Post by **nagarjuna** » Thu Jun 04, 2009 4:31 am

Thanks ray for the reply ...
In my case ..Output also BIGINT ...Is it expected behaviour ??

ray.wurlod · Post by **ray.wurlod** » Thu Jun 04, 2009 4:07 pm

Not expected. After all the Pivot stage does not change the value - it only moves it to a different place. What happens if you change the output to unsigned BigInt (int64)?

nagarjuna · Post by **nagarjuna** » Thu Jun 04, 2009 4:16 pm

I am getting the same result for unsigned Bigint also .Its giving a warning of ARTHIMETIC OVERFLOW and after that fatal message as :

Resource bundle corresponding to message key DSTAGE-T0DC-0064 not found ! Check that DSHOME or APT_RESPATH is set .

nagarjuna · Post by **nagarjuna** » Mon Jun 08, 2009 10:36 am

Can anybody test a simple job with pivot stage and giving one of the field as BIGINT in output and input of pivot stage ?

ray.wurlod · Post by **ray.wurlod** » Mon Jun 08, 2009 4:34 pm

The resource bundle message is unrelated to the arithmetic overflow, I believe. The resource bundle message is about finding the text to accompany some particular error code.

chulett · Post by **chulett** » Mon Jun 08, 2009 6:08 pm

nagarjuna wrote:Can anybody test a simple job with pivot stage and giving one of the field as BIGINT in output and input of pivot stage ?

A version 8 job, I assume... 8 dot what?

nagarjuna · Post by **nagarjuna** » Mon Jun 08, 2009 7:04 pm

Version : 8.0.1 ( Information Server )

ray.wurlod · Post by **ray.wurlod** » Mon Jun 08, 2009 7:08 pm

What does your official support provider have to say?

nagarjuna · Post by **nagarjuna** » Mon Jun 08, 2009 7:13 pm

We have submitted the case to support ...We are yet to hear from them ...But , before that i want to find out if its working for anybody else here

anshul_roy · Post by **anshul_roy** » Tue Jun 09, 2009 3:52 am

I tried doing the same. Luckily it ran successfully but the viewdata is giving error.

nagarjuna · Post by **nagarjuna** » Tue Jun 09, 2009 5:10 am

Hi Anshul ,

Could you please eloborate on problem you are facing in viewing the data ??

chulett · Post by **chulett** » Tue Jun 09, 2009 4:38 pm

FWIW, built an 8.1 job with the Pivot Enterprise stage using BigInt fields and it works just fine. And I can't imagine any kind of View Data error would be relevant to this particular topic.

nagarjuna · Post by **nagarjuna** » Tue Jun 09, 2009 6:23 pm

Thank you very much craig for testing .Hope you have given datatype as Bigint in both i/p,o/p of pivot and test data is also Big int ( value greater than int ) .I will update you all once i receive any information from my support team

DSXchange

Bug in pivot stage ???

Bug in pivot stage ???

Re: Bug in pivot stage ???