Search found 14 matches

by TBartfai
Thu Aug 31, 2006 2:01 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Rare Error Messsage
Replies: 20
Views: 11802

So I found out the solution... :P :idea:

Ray was right, they installed scripts deleting files during the night.
But this script is not deleting any directory, so hash's directory remained.

Very big thanks for all your ideas and help!
by TBartfai
Tue Aug 29, 2006 10:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Rare Error Messsage
Replies: 20
Views: 11802

Again thanks for all your answers :) We are not doing any manual or own developed hash file manipulation, we are using only built-in stage properties. But I have checked the uvconfig files on our test, production-like and production servers and its value is either 2000 or 2050. I do not exactly unde...
by TBartfai
Tue Aug 29, 2006 9:05 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Rare Error Messsage
Replies: 20
Views: 11802

:oops: I meant we have create file option, allow stage write cache and clear before writing enabled, It is not creating a file again and again. I have to take a rest before writing silly things. :) But I am still interested in how to avoid this floating point exception, maybe we will open a case...
by TBartfai
Tue Aug 29, 2006 8:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Rare Error Messsage
Replies: 20
Views: 11802

Deleting the hash file solves the problem, I forgot to mention that I have already tried :oops: Why I am so interested in this case, because our customer does not accept this workaround, and keep insist on opening a defect on us and prevent this behaviour :( Do not you know accidentaly how to preven...
by TBartfai
Tue Aug 29, 2006 6:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Rare Error Messsage
Replies: 20
Views: 11802

First thanks for you reply. Unfortunately it is not rare :( And it happened this week in 2 different processes with 2 different hash files. I thought that the hash file is responsible as it looks ugly in the file system and disabling memory pre-load eliminates the problem. But I would like to have t...
by TBartfai
Tue Aug 29, 2006 3:50 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Rare Error Messsage
Replies: 20
Views: 11802

We are also facing the same error, when looking up from a hash file in a transformer stage. There are no divisions with numbers, all the data-types are set accordingly. There is only one constraint Not(IsNull()), and thats all in the transformer. It occurs only with hash files. If pre-load to memory...
by TBartfai
Thu Dec 08, 2005 11:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSD.GetStatus - Improper data type
Replies: 8
Views: 4073

Re: DSD.GetStatus - Improper data type

I finally find the solution. In the big amount of the data input we had an empty field.

This caused the job to pass null value to the DSSetUserStatus function.

Thanks for your ideas and help!
by TBartfai
Thu Dec 08, 2005 9:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSD.GetStatus - Improper data type
Replies: 8
Views: 4073

Re: DSD.GetStatus - Improper data type

The problem is with one of the stage variables:

Code: Select all

IF9DSR.UtilitySetUserStatus(svAccumulator)
This routine's code is the following:

Code: Select all

$INCLUDE DSINCLUDE JOBCONTROL.H

Call DSSetUserStatus(Arg1)


Ans=0
Without the abovementioned variables everything goes fine.
by TBartfai
Thu Dec 08, 2005 8:41 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSD.GetStatus - Improper data type
Replies: 8
Views: 4073

You state that you are using an invocation id to run the sequencer. Do all the jobs that the sequncer calls have "Allow multiple Instance" turned on? Did you call them using the invocation id? After you reimported the jobs did you validate them with the correct invocation id? Hi, The sequ...
by TBartfai
Thu Dec 08, 2005 8:18 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSD.GetStatus - Improper data type
Replies: 8
Views: 4073

Do you still have the problem if you make your sequence call only the one job and do nothing else? I deleted everything, only 1 stage remained, the calling of the job. It is finished successfully, but with the following strange info: IF9MIF_LTRC_SEQ_CollectionLetter..JobControl (DSWaitForJob): Job ...
by TBartfai
Thu Dec 08, 2005 7:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSD.GetStatus - Improper data type
Replies: 8
Views: 4073

The code generated is most likely correct, as it did work for you before; but something else around your job must have changed. Was the job's last run "OK" or did it have an aborted status that was reset from the sequencer? First of all thanks for your quick reply. I could not find any ab...
by TBartfai
Thu Dec 08, 2005 7:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DSD.GetStatus - Improper data type
Replies: 8
Views: 4073

DSD.GetStatus - Improper data type

Hi, I tried to search on my error, but I have not found any regarding answers. It is a sequencer job, what was working fine. But from today it is giving the following message in the relevant file in &PH& dir: Program "DSD.GetStatus": Line 25, Improper data type. And the status of t...
by TBartfai
Wed Jul 28, 2004 6:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Export routines, transforms etc. from code
Replies: 3
Views: 2656

Re: Creating Export via command line

Unfortunately with this you can export the whole project. I need to export only specified routines or transforms and so on :(
by TBartfai
Wed Jul 28, 2004 6:30 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Export routines, transforms etc. from code
Replies: 3
Views: 2656

Export routines, transforms etc. from code

Hello! I would like to write a client program, that exports routines, transforms etc. from code. I am using Visual Basic. I have added DataStage Repository interface. I am able to export jobs with ExportNoForm. But this method does not exist for stage types, routines etc. I found an interface called...