[IIS-CONN-TERA-005004] RDBMS code 8055:

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
Chiya
Participant
Posts: 1
Joined: Wed Jul 30, 2008 11:24 am
Location: Ind

[IIS-CONN-TERA-005004] RDBMS code 8055:

Post by Chiya »

Can anyone help me with the below error . I am reading a file and loading in a teradata table through teradata connectoe Stage.

363 FATAL Thu Feb 11 14:08:43 2010 a7_demographics_wrk,10: [IIS-CONN-TERA-005004] RDBMS code 8055: Session forced off by PMPC or gtwglobal. SQL statement: UPDATE "P_EIW_W_T_UTILWORK_01"."ds_tdconn_sync" SET CheckpointState = 1 WHERE SyncID = 'smadbrme_hist.load.adb_a7_demographics' AND PartitionNo = 10 AND StartTime = TIMESTAMP'2010-02-11 13:39:33.970000' (CC_TeraConnection::execute, file CC_TeraConnection.cpp, line 2,509) [pxbridge.C:2945]
363 FATAL Thu Feb 11 14:08:43 2010 [IIS-CONN-TERA-005004] RDBMS code 8055: Session forced off by PMPC or gtwglobal. SQL statement: UPDATE "P_EIW_W_T_UTILWORK_01"."ds_tdconn_sync" SET ControlState = 1000 WHERE SyncID = 'smadbrme_hist.load.adb_a7_demographics' AND PartitionNo = 10 AND StartTime = TIMESTAMP'2010-02-11 13:39:33.970000' (CC_TeraConnection::execute, file CC_TeraConnection.cpp, line 2,509) [pxbridge.C:2945]
364 FATAL Thu Feb 11 14:08:43 2010 a7_demographics_wrk,10: The runLocally() of the operator failed. [api/operator_rep.C:4032]
365 INFO Thu Feb 11 14:08:43 2010 a7_demographics_wrk,10: Input 0 consumed 924690 records.
366 FATAL Thu Feb 11 14:08:43 2010 a7_demographics_wrk,10: Operator terminated abnormally: runLocally did not return APT_StatusOk [processmgr/rtpexecutil.C:184]
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Show it to your Teradata DBA.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply