DSXchange

Hi, previously, I've some batch which run without warning in the server A. But, the compilations on the server B are OK but the batch don't work. The warning is : Attempting to Cleanup after ABORT raised in stage Batch::.....JobControl No more information. So, I create a routine and put in the code ...

The problem has disappeared after reboot the server and restart DS services... Now, the job previously hang is run in 31sec instead of more than 15hours... This problem doesn't appear in exploitation... only in project. But, previously we didn't have this problem with bigger projects and more develo...

Hi,

I've the same problem toda...

viewtopic.php?t=106909
"job running but no log, no PID, too long, CPU Pb ?"

Big coincidence !

I don't know if it is possible to know how many cost the upgrade from 7.1 to 7.5 ?... ========================= ken_gathmann Participant Post Posted: Wed Nov 01, 2006 2:15 pm Had this same problem with stuburn jobs that would not cleanup from director in 7.1. It was observed that the most significan...

Hi, we've a strange problem : some job which had run without warning yesterday doesn't "work" today. In Manager, I can view all stages (file, H, table) without delay. In Director, the job is running but it is locked during many hours instead of 15" yesterday. The job doesn't have PID ...

Thanks ray.wurlod.
I'll swap some first stage variable derivations.

Thanks DSGuru2B and narasimha. You help me a lot. Please, tell me if I'm wrong or in the right way. =================================== I resume the problem which is a bit complexed (the title of the post would change to "Sum, initials Values for 1 or many rows"...) Input : 3 columns Id1, ...

Thanks for all reply. The problem is I want to sum 2 value and conserve the initial value. Input Id1, Type1, Amount1 Id1, Type2, Amount2 Id2, Type1, Amount3 Id3, Type2, Amount4 output Id1, Type1, Amount1+Amount2, Amount1, Amount2 Id2, Type1, Amount3, 0, 0 Id3, Type2, Amount4, 0, 0 I hope this explic...

sorry, i'm confused. The reply corrected is : =================== Sorry DSguru2B, I missed that I have must keep the initial amount to insert in the table. StageVar derivation: ID row StageVar1 derivation: Amount StageVar2 derivation: if input ID row=StageVar then "NOCHANGE" else "CHA...

Sorry chulet, I missed that I have must keep the initial amount to insert in the table. StageVar derivation: ID row StageVar1 derivation: Amount StageVar2 derivation: if input ID row=StageVar then "NOCHANGE" else "CHANGE" Insert table Derivation : if StageVar2="CHANGE" ...

Hi, I've a new problem and hope you can help me to resolve it. In input, i've a file with sometimes 2 record with the same ID but different amounts : Id1, Type1, amount11 Id1, Type2, amount12 Id2, Type1, amount21 Id3, Type2, amount32 And I want to know HOW MANY input record with amount=0 and want to...

You're right.

I'm lucky, the row has just 31 fields so the pb is resolved.
Now, I know that sometimes I could not have the row number...

Thanks chulett !

Hi, A simple problem ? ------------------------------------- Project:... Job name:... Event #:756 Timestamp:15/01/2007 11:23:46 Event type:Warning User:.../... Message: .....TR40: At row 135, link "vers_T_..." Inserted value too large for column, row rejected. -----------------------------...

Thanks DSGuru2B. I've found a lot of intersting reply when searching "unlock job" :P My problem is located and "solved". It is due to the 7.1r1 version and IBM senior consultant asked us to upgrade to 7.1r2. Effectively, we don't have any problem since this upgrade. =============...

Hi, We have a problem with a job which is running with an abnormal termination : Project: ... Job name: ... Event #:476 Timestamp:10/01/2007 14:14:31 Event type:Warning User: .../... Message: Abnormal termination of stage ... ..TR10 detected And I can't edited the job : Job FERMAT_Alim_Provision_CBI...