DSXchange

I faced the same issue. I was grouping on Column X,Y and Z and taking maximum of Column A which is CHAR(9). Data loaded in target was in exponential format something like this 12312e5+. After figuring out that in DS v8.1 Aggregator stage does not perform agg functions on varchar columns, I then adde...

I was facing same issue with my query where I was using INNER JOIN. SELECT count(*) FROM EPIMART.MUT_FUD_TRANS_FACT_0_V MFTF INNER JOIN EPIMART.SECURITIES_0_V SECURITIES ON MFTF.SECURITIES_KEY = SECURITIES.SECURITIES_KEY INNER JOIN EPIMART.SECURITIES_0_V TO_SECURITIES ON MFTF.TO_SECURITIES_KEY = TO_...

Datastage solution :

Read the record as a single field, use the Field() function to split up the columns.

I have a job that extracts data from SQL server and loads to a dataset. DSN has been created to connect to SQL server. I am using DRSPX stage to connect to SQL server and could view data with the given credentials. Database type used in DRSPX stage is "MSSQL Server" But when I run the job,...

I faced same issue. Resolution was to delete datasets and create some space. Job then ran fine. tCopy,0: Write to dataset on [fd 8] failed (Success) on node node1, hostname mphewddes001 tCopy,0: Orchestrate was unable to write to any of the following files: tCopy,0: /node1/res/DS_C_MP_MSTR_PFL.ds.ds...

Environment variables like APT_CONFIG_FILE are specific for that datastage server on which many projects are running.

Whereas $PROJDEF which is mostly used for passwords is project specific which is set through Administrator.

I am facing an error which involves datasets, funnel stage and UDBLoadPX stage. The job design is simple. Data extracted from 5 dataset files is combined using a funnel. Funnel Type used is "Continous". Finally data is loaded into DB2 table using UDBLoad PX stage. Settings in UDBLoad PX st...

Hi, I am running a server job. Calling it through Tivoli Scheduler Tool. When I run this job from Datastage Director its running fine. But when called from Tivoli, its aborting with the following error. FAILED return code 255 The logs in Director is not giving sufficient information. Resetting stage...

Hi,

I forgot to mention this in my previous mail. The job was not locked and I was able to open this in Designer too after I received the error notification mail.

regards
Anand

Hi, I am facing the same issue with the following error log: -------------------------------------------------------------------- Status code = 0 ERROR: Failed to lock job Status code = -10 DSJE_JOBLOCKED Status code = 0 Error -4 getting log summary Status code = -4 DSJE_BADVALUE Error running job S...

Hi, I am facing the same mutex issue in a server job. Error found. SBL_SMP_CR_SLX_Extract_HashData..TRN_SPLIT.HASH_note: ds_ipcgetnext() - timeout waiting for mutex The job is running state. I can always stop the process through Unix. But I would like to know the reason. I am using a Basic Transform...

Hi,

Could you please share your experience with this issue, your understanding on the reason and what was the resolution.

I am facing the same issue.

Thanks in advance.

Anand

Hi Ananda, What Force option you selected in the Copy stage after Teradata stage? If Force=False make it Force=True then copy stage will work as a Optimiser. I think it will solve your problem. If your doing the above one already then think about Lookup, lookup reference file unable to store the hu...

What is the volume of data your are gettting out of teradata. How much space is available in your server?... Hi Rasi, The server space does not seems to be an issue. bidev1:/etld/datastage/data/datasets/node01 >bdf . Filesystem kbytes used avail %used Mounted on /dev/vx/dsk/apps/appsdsadm 330301440...

hi, I am running a parallel job where data is extracted from Teradata table and through copy stage is moved into lookup file and dataset files. This job had been running successfully for many cycles. It is now getting aborted with the following error logs in Director: -------------------------------...