DSXchange

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 .

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

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

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)?

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 .

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

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.

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?

Version : 8.0.1 ( Information Server )

What does your official support provider have to say?

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

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

Hi Anshul ,

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

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.

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