Abnormal termination as Pivot Detected

Prashantoncyber · Post by **Prashantoncyber** » Tue Aug 31, 2004 3:43 am

HI All,

I am loading the fact_table .
At one place before transformation we have used Pivot stage.
while running the job after loading around 1 lac records to fact table ,its giving following error and susequently aborting the job.

Abnormal termination of stage FCT_TRNEBL1_7_TEST..Pivot detected

Job FCT_TRNEBL1_7_TEST aborted.

While the same job ran successful with loading of around 80000 records in fact table lasl time.

My collegue though himself not sure suggested could be becuse of bigger loading of Records?

Can any one suggest the Remedy?

Thanks
Prashant

victorbos · Post by **victorbos** » Thu Jun 08, 2006 3:04 am

Hello everybody,

I am facing this exact problem as described in this old post.
Anyone who knows what could be the problem?
I am running DS 7.01

thanks in advance,

Victor

loveojha2 · Post by **loveojha2** » Thu Jun 08, 2006 4:43 am

victorbos wrote:Hello everybody,

I am facing this exact problem as described in this old post.
Anyone who knows what could be the problem?
I am running DS 7.01

thanks in advance,

Victor

What is the error message you are getting ? Please paste it here.
What message it show from previous run when you reset it.

ray.wurlod · Post by **ray.wurlod** » Thu Jun 08, 2006 3:38 pm

What is your volume of data? How much physical memory and how much swap space does the server have?