DSXchange

more is not active when i close the error message. and when i click the error message ok button it is giving a message like "(40503) a call to an OLE server has failed, or a runtime error occurred within the OLE server itself" when i hit show error it is giving a message like "(40908...

anilraj8 wrote: I am getting all the time even i stopped all services and again restarted DS engine. I closed Designer also and restarted even though it is comming same error.

Sometime the underlying hash files get corrupted. Did you try renaming the job to something else and then compile?

Hi, We have just recently upgraded to DS 7.5 on a Solaris 2.8 SUN server. We are having problems with jobs (not any job in particular) aborting with "Abnormal termination of stage P331LoadAssetSourceNEMS00..Transform detected". This can happen to just about any jobs but one observation is...

I am getting an error when i compile the Job. It is giving a Message like "Error calling subroutine: DSR_JOB (Action=5); check DataStage is set up correctly in Project DataStage (Subroutine failed to complete succesfully (30107))" I checked everything in DS Admin, DS Manager and DS Direct...

Verify the path to the hash file. If you're using the project as the default, do a sanity check and View data. Sometimes the hash file being written to is not the same one being referenced. Also double-check the filename is still the same. DataStage Server has this "feature" of updating t...

How can you update anything then if you only have one of these? If there is a change to an existing record (a record that was written during a previous day's batch). The hash file is created by a job that reads from the database and populate the hash file. This job runs at the beginning of the batc...

kduke wrote:What if you inserted 2 records before? It is not in the hash file. You job says it is an insert. Really it is an update.

I will ALWAYS be getting a single record for a given security number + start date + type combination.

There is your problem. You need to reflect in the hash file all the keys in the target otherwise your insert needs to be an update. Kim - I don't need to update the hash file. My objective is to find the action (insert or update) for the incoming record based on the records already existing in the ...

kduke wrote:When you insert a record do you also update your hash file?

Ken is correct cache needs to off. All these need to be in one split file as well.

I don't update the hash file in the job. It is only read. The hash file is created by another job that runs before this job.

I do not get it. It looks like it is working perfect then. What is it that we do not understand. I explained in the initial post. I am having a strange problem with one particular security. There are 8 records for this security in my main input file. After split, all 8 records are falling into the ...

kduke wrote:I think your key to the hash file needs to be just the first field not the first 3 fields.

I need to determine if the record exists for the given security, start date and type and based on that I need to either insert or update the record. That is the reason I have the 3 fields as keys.

As for intermittent finding of a row, that usually is either a caching issue, or an in the case of a multi-instance job the hash target is getting cleared and since all instances are clones, they all clear the hash file. In that case, one instance may already be writing data to the hash file when a...

Please tell me that your hash reference lookup has the primary key boxes checked for all three columns that make up the natural key, and that when you write to the hash file you have those same three columns checked. If there's anything wrong at this point, it's probably your hash file metadata. ye...

Well, Kim and I verified your example data should work. :x Now how about actual data? From your stated example, "security" is only 1 column of 3 on which you have to match a lookup. When you say "one security in the input file", are you saying one row, or one set of rows with th...

FYI - I am using the dates as YYYY-MM-DD HH24:MI:SS only. That was just an example.

The row IS MATCHING the hash lookup when I have only one security in the input file. However, it is failing with the complete data set.

How can I send an attachment to the post?