I am getting the following error running a job from a job sequence.
ERROR
main_program: Dataset: /apps/ascential/data/DEV_QTE/ds/Ds_ORA_PS_PRDSVC2_HistoricProductStatus_Upsert.ds, expecting 0 segments, read 1 segments.
main_program: When deleting data set /apps/ascential/data/DEV_QTE/ds/Ds_ORA_PS_PRDSVC2_HistoricProductStatus_Upsert.ds, previous delete attempt not complete; removing /apps/ascential/data/DEV_QTE/ds/Ds_ORA_PS_PRDSVC2_HistoricProductStatus_Upsert.ds.being_deleted in order to proceed.
However, when I run the job by hand, the job runs without problem. I therefore assume that it is the Job Sequence that is causing the problem
PARAMETERS
I have compared both sets of parameters and they are the same
By Hand
$APT_DUMP_SCORE = Faux
GpPathDs = /apps/ascential/data/DEV_QTE/ds/
GpPathReject = /apps/ascential/data/DEV_QTE/reject/
GsSchemaCib = PRDSVC2
LsBase = ORA
LsApplication = PS
LsTable = HistoricProductStatus
LsReference1 = Product
LsReference2 = ProductStatus
LiFlowNumber = 10
By Job Sequence
Starting Job JsQTE_E20_Nv3_HistoricProductStatus_ORA.
$APT_CONFIG_FILE = /apps/ascential/Ascential/DataStage/Configurations/Qte_TwoNode.apt
$APT_DISABLE_COMBINATION = Faux
$APT_DUMP_SCORE = Faux
GpPathDs = /apps/ascential/data/DEV_QTE/ds/
GpPathReject = /apps/ascential/data/DEV_QTE/reject/
GsSchemaCib = PRDSVC2
LsBase = ORA
LsApplication = PS
LsTable = HistoricProductStatus
LsReference1 = Product
LsReference2 = ProductStatus
LiFlowNumber = 10
DSJobController = JsQTE_E20_Nv3__PreLoad
JOB
The job is consists of three dataset transformations. It is a replica of one of 20 jobs which run without problem in the same job sequence.
NODE
The job is configured to run on two nodes in both instances
CHECKS
I have checked to ensure that the dataset in question is not used twice within the Job Sequence
Any Suggestions ?
ERROR : expecting 0 segments, read 1 segments
Moderators: chulett, rschirm, roy
ERROR : expecting 0 segments, read 1 segments
Colin Larcombe
-------------------
Certified IBM Infosphere Datastage Developer
-------------------
Certified IBM Infosphere Datastage Developer
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Looks like there's a problem with partial deletion of the Data Set.
Try deleting it using the GUI or orchadmin command before running the job sequence that populates it.
Are you using the same configuration file when populating the Data Set as when reading from it?
Try deleting it using the GUI or orchadmin command before running the job sequence that populates it.
Are you using the same configuration file when populating the Data Set as when reading from it?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ERROR : expecting 0 segments, read 1 segments
which parameter you changed?
Ulab----------------------------------------------------
help, it helps you today or Tomorrow
help, it helps you today or Tomorrow
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: ERROR : expecting 0 segments, read 1 segments
Versions after 8.0 (the IBM versions) work somewhat differently - actually a lot differently - to the version 7 environment of the ten year old post to which you responded.ulab wrote:which parameter you changed?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.