APT_SC error

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kittu.raja
Premium Member
Premium Member
Posts: 175
Joined: Tue Oct 14, 2008 1:48 pm

APT_SC error

Post by kittu.raja »

Hi,

I am getting a error
STARTED Fri Mar 20 15:57:42 2009
Starting Job Jp_INT_INT_Tfm_Payload. (...)
1 INFO Fri Mar 20 15:57:42 2009
Environment variable settings: (...)
2 INFO Fri Mar 20 15:57:42 2009
Parallel job initiated
3 INFO Fri Mar 20 15:57:43 2009
main_program: IBM WebSphere DataStage Enterprise Edition 8.0.1.4665 (...)
4 INFO Fri Mar 20 15:57:43 2009
main_program: The open files limit is 100; raising to 65536.
5 INFO Fri Mar 20 15:57:43 2009
main_program: orchgeneral: loaded (...)
6 INFO Fri Mar 20 15:57:44 2009
PSct_Write_ABC_Paylaod.Odbc_Ref_ABC_Prcs_Step: Process meta data not available in database
7 INFO Fri Mar 20 15:57:44 2009
PSct_Write_ABC_Paylaod.Odbc_Ref_ABC_Obj_Typ: Process meta data not available in database
8 INFO Fri Mar 20 15:57:44 2009
PSct_Write_ABC_Paylaod.Odbc_Upi_Audit_Bal_Instc: Process meta data not available in database
9 INFO Fri Mar 20 15:57:46 2009
main_program: APT configuration file: /opt/etl/IBM/InformationServer/Server/Configurations/config2a.apt (...)
10 FATAL Fri Mar 20 15:57:46 2009
main_program: Internal Error: (APT_SC::downcast(pConsumer())->kind() == APT_Operator::eParallel): sc/sc.C: 3984 (...)
11 STARTED Fri Mar 20 15:57:51 2009
Job Jp_INT_INT_Tfm_Payload aborted.

My job is working fine in development and failing in production. I searched but could not find the right solution. Can anybody help me out.

Thanks
Rajesh Kumar
sjfearnside
Premium Member
Premium Member
Posts: 278
Joined: Wed Oct 03, 2007 8:45 am

Post by sjfearnside »

Need to see the detailed information for the following =>

9 INFO Fri Mar 20 15:57:46 2009
main_program: APT configuration file: /opt/etl/IBM/InformationServer/Server/Configurations/config2a.apt (...)
10 FATAL Fri Mar 20 15:57:46 2009
main_program: Internal Error: (APT_SC::downcast(pConsumer())->kind() == APT_Operator::eParallel): sc/sc.C: 3984 (...)
11 STARTED Fri Mar 20 15:57:51 2009
Job Jp_INT_INT_Tfm_Payload aborted.
thumati.praveen
Participant
Posts: 106
Joined: Wed Oct 04, 2006 5:21 am

Post by thumati.praveen »

Hi,

Any one have solution for the above problem.

Could you please let us know?

Thanks,
Praveen.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

How about you provide detail of log events 9, 10, and 11, as you were asked to do?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
thumati.praveen
Participant
Posts: 106
Joined: Wed Oct 04, 2006 5:21 am

Post by thumati.praveen »

Hi,

If you put the transformer stage in sequential execution mode in parallel job and job is running more than one node config it will give above error.

Please make parallel the transformer execution mode.

Thanks,
Praveen
Post Reply