DSXchange

Two things to be checked:

1. Permission for 'WORK' database
-Check whether you have appropriate permissions for the 'WORK' database.

2. Space allocated to 'WORK' database
-Check whether sufficient space has been allocated to 'WORK' db.

Two things to be checked:

1. Permission for 'WORK' database
-Check whether you have appropriate permissions for the 'WORK' database.

2. Space allocated to 'WORK' database
-Check whether sufficient space has been allocated to 'WORK' db.

I am using to unlock my jobs.
The message says: Cant we unlock our own jobs? Otherwise everytime a job hangs, we need to trouble the DS Admin.

Hi,

I am also getting the same error. Can the original poster please provide the resolution to this issue.

Thanks in advance.

Duplicate row error in <DB_NM>.<TBL_NM>. Teradata DB. ------------------------------------------------------ RowGen -----> TeradataPX Stage There is an INSERT sql in the Teradata PX stage. There are a series of insertions happening on the target tbl in this job. Insert into #TBL_NM_2# ( Select * fro...

There were formatting issues with the job design in the prev. post. Plz chk the following.

Job Design:

ODBC
|
LOOKUP ===> TRANS ===> SEQ_FILE
^
|
TRANS
^
|
SEQ_FILE

Job Design: ODBC ^ | | SEQ_FILE ===> TRANS ===>LOOKUP ===> TRANS ===> SEQ_FILE This job was running fine a couple of days back and now it is aborting every 3rd or 4th run with the following error messages: CLI : [TID: B75F42A0]:[Tue Mar 20 15:14:32 2007] rdacutl.c:496: *** RDA_cliPrepareSQL: can't e...

Hi All,

'Yes' is the answer to all questions asked by Kumar_S & Sainath. I really dont have a clue as to what might be the reason for this. Please let know if anybody has any leads on this.

Thanks,

Hi Ray/Kumar,

Tried Kumar's suggestion. Both are having the same values. No change. (No space, No junk characters etc ).

Moreover I had the same job running successfully a week back with the same inputs. Now, with the same input, same scenario the job is failing.

Rather strange.

Thanks,

Thanks for the reply Kumar. I am afraid there is no other error message other than this. I have cross-checked the extracted value. No issues with it. Is it a possibility that the Stages can get corrupted?

From Sequential File, i pick up a column value and pass it to the Transformer and then pass it to STP.

Right now, I pass a value from Job Parameters to the column in Transformer. And it works fine.

Job Design 1: Seq_File1 ==> TRANSFORMER1 ===> STP(Stored Proc) ===> TRANSFORMER2 ==> Seq_File2 I was getting the following error. Error: ORA-12154: TNS:could not resolve service name Checked all the ODBC entries in the respective locations. They look ok as there are other jobs using the same connect...

Hi,

I have a project where only the executables have been imported. How do i get the version number of the jobs present here.
I couldnt get it in the DS Manager/Designer through the properties.

Thanks,

In fact I am using default.apt which has a symbolic link to mellaswds01_11.apt. BTW, the issue is solved. The configuration file was using MELLARWDS01 as the head node before it was changed by the admin to use MELLASWDS01. The DataStage engine had to be restarted(uv -admin -stop/-start) to make the ...

I get the following error when I run a job. My project details are: Project Name: METL_SIT_R1 Server Name: mellaswds01 main_program: Fatal Error: An ORCHESTRATE program must be started on a node in the configuration file. This program is running on MELLARWDS01 which is not in the configuration file:...