IPC_out stage not writing rows to Target table

tirumal_nit · Post by **tirumal_nit** » Tue Jan 06, 2009 1:22 am

Hi,

One of our OWS job is hanging at IPC_out (IPC out stage) stage. Even after 10, 12 hrs IPC out stage is not writing a single row to the Target table.

I've tried with different set of IPC paramter values (AZ, TZ and turned on the row buffering option) but nothing is worked out.

Please help me out on this issue.

Thanks in advance.

ray.wurlod · Post by **ray.wurlod** » Tue Jan 06, 2009 1:44 am

Please advise what you mean by "IPC_out stage". I am not aware of any such stage type, particularly in version 5.

Please advise all the stage types used in your job design.

tirumal_nit · Post by **tirumal_nit** » Tue Jan 06, 2009 2:18 am

Hi Rey,

I am sorry, it is version 7x.

This is actually a incremental loading job using the CRC logic.

IPC_out is a Inter-process stage.

The job mainly have Source DRS stage, IPC_in, CRC logic (row merge, Transformer and row split stages), IPC_out and target DRS stage.

JOb is running fine till the IPC_out stage input link but hanging at IPC_out without writing any rows to the target DRS stage.

I've tried with different set of IPC paramater values but still experiencing the same problem.

Please advise me.

DS_SUPPORT · Post by **DS_SUPPORT** » Tue Jan 06, 2009 3:07 am

Might be your target table is locked, Check for any locks on your target table and release it.

Based on the design, it seems you are using Peoplesoft Delivered Jobs, why cant you raise a case with your official support?