DSXchange

Can you please be more clear

1.) What kind of pattren.
2.) which job you r referring to eg: Server / Parallel.

Hi, when a remove duplicate stage is used the it is mandatory that data should be sorted on the key column before the data is passed to the remove duoplicate stage. When sorting the data will go the spool space i.e temporary sapce and the location is defined in the configuration file. As it was ment...

Hi Chullet,

I had set the NLS option as NONE. This was done using Administrator.

Then I execute the job the job failed with the same error message.

Hai Ray/Chulet, The problem is that the job is being aborted in the other environment. The error message shown is: main_program: Parameter not resolvable: DSProjectMapName main_program: Parameterization error: Parameterization failed So as a results of our tests we found that the problem is NLS. The...

Hi All, We are trying to run a DS job in prod and we are recieving the below mentioned warning. Warning: main_program: Parameter not resolvable: DSProjectMapName main_program: Parameterization error: Parameterization failed We dont have NLS installed on prod but we have it on DEV environment. We don...

Hi Kunal,

Thanks for your respose. Can you please be more clear and explain me What is the reason for this error.

Hi All, We are facing an issue with lookup stage when running parallel job. Earlear it ran fine. But recently we migrated from DS 7.5.1 to DS 7.5.3. From then the problem has started.Please find the below error bessage what we got in our job. Log: main_program: APT configuration file: /product/datas...

Chulett can you please explain me the importance of this variable. So that I can decide the which value to assign.

I am asking you this question because I dint get anyhelp from the DS document available on ENV variables regarding APT_PM_CONDUCTOR_TIMEOUT

Hi Chulet,

Thanks for your quick response can you please tell me what is the value I can give and on what basis I can decided the value.

In my current configuration it is defined as blank.

Hi, When I am executing the DS job it is giving me the below mentioned warning. Log: FATAL Thu Sep 24 23:00:45 2009 main_program: Fatal Error: Service table transmission failed for node1 (su0096:Broken pipe. This may indicate a network APT_PM_CONDUCTOR_TIMEOUT to a larger value (when unset, it defau...

Hi All, We are having a job which load the TERADATA databse and the job design is as mentioned below. Seqential file---> transformer---> TeradataStage. The job is getting aborted by giving the warning given below. Error Message: main_program: APT configuration file: /product/datastage/Ascential/Data...

Hi can some one tell us how to add the environment variables defined to the dsenv file

ray.wurlod wrote:The log is not a file, so restoring it "with the unix" is not a straightforward procedure. ...

So can you please tell me how to retrive the previous log Reports.

Hi All,

I have to check the datastage Log Reports. But all the log reports were cleared. So I am unable to fetch log report for a particular job.
Is there any way we can see the old log reports on DataStage jobs.

Thanks in advance.

Sandeep.

Hi All Im using an ODBC stage to pull data. But when i try using that its not resolving connection. Errored out with below message. DSR.MetaGeta(GET.DSNINFO)(SQLConnect('pscrm3g','sysadm')): BCI Error: SQLSTATE=08001,CODE=-1,[DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver...