DSXchange

The file is not open.

The file is created by the job. None of the user that are supposed to use the file have the rights to access this instance of it. I transfer the file to a different server once the job is complete.

The thing is that the job has procesed about 16000 rows and seems to be standing still.

m.

I have a job that seems to have stopped. It still shows up as running and seems OK, only that it's been running for 5 hrs when it usually takes about 3 mins. The number of rows processed has been standing still for the last 4 hrs. The job is quite simple. Reads from a table and writes to a sequentia...

I strongly doubt that it's the comment causing this error. We use this kind of commenting in a lot of our server jobs and none of the others fail. When it comes to non-numeric data colums no. 3 and 6-9 are char or varchar. However since this is a generated SQL statement I can't add quotes without ch...

I have a target OCI stage that is set to "Update existing, Insert...". The SQL of this stage is generated from the column list. And gives med the following: UPDATE ANSATT /* PDB - AnsattFraStage */ SET BANKKODE=:2,LOGON_ID=:3,ANSATT_FOM=TO_DATE(:4, 'YYYY-MM-DD HH24:MI:SS'),ANSATT_TOM=TO_DA...

We actually took over a project develop by another company. Mission: to clean up

This can be related to two things: 1. The first attempt to install the new server was unsuccesful. The user tights on the server were not properly configured. 2. The job of migrating the old datastage jobs from version 5.2 was not as trivial as originally said. We had a problem with the new server d...

I have been involved with an upgrade from version 5.2 to 7.5.1A. A process which is still ongoing. The upgrade on our part has been less than trivial to put i mildly.

Hopefully we'll have the new environment up and running soon (has taken 3 months so far).

Michael

The hash-file is both used for lookups and updates in the same job. No other jobs use this same hash-file concurrently. The job is being migrated from a (rather old) server running DS 5.2 to 7.5.1. In 5.2 preloading was disabled and the job ran at 1000 rows/second. In the 7.5.1 environment, the hash...

I went ahead and did some further investigations on this subject. It seems that the job somehow messes up the hash-file. I have one job that can regenerate the hash-file from the backup-table mentioned above. After running this job, the hash-file is correct and contains all the rows that create prob...

Hi I have a problem with a server-job after migrating to 7.5.1A from 5.2. The job reads from a flat file and loads into two tables in a database. One table contains the actual data, the other is used as a backup for the hashfiles. When processing a new row Datastage looks up the ID in a hash-file. I...

Hi We tried some different values for the array size of a job included in our datawarehouse etl-jobs. What we found was that we were able to double the performance of the job by setting the arraysize to 20 (higher than this and it went back down). What I'd like to know is if there are any formuales ...

I went ahead and tested this issue a bit more, and as far as I can tell the problem only surfaces when I press the view data button in the output pane of the stage's properties. I have found that I can use parameters in the column derication field on compiled jobs that are sterted through DS Directo...

This is not a transformer stage, it is in the column derivation field in the ouput pane of an Oracle8-stage. SQL functions work smoothly here (the wiseness of using an sql function here is another discussion, I'm just modifying an old job created by someone else). When placing an SQL function here i...

Hi I'm trying to use use a job parameter in the derivation field for a column i a DB stage. My formula looks like this: ADD_MONTHS(TO_DATE('#Periode#', 'YYYYMM') -1, 1) Somehow it seems that datastage does not replace #Periode# with the correct value set for the parameter. The same parameter is used...