DSXchange

environment is pointing to 8i client same as in dev. I wish i could resolve this issue though, This is driving me crazy. We opened a ascentail ticket 5 days back and they couldnt figure out what is happening.

Siva.

Can you let us know how you solved the problem. I'm kind of having the same problem as you are facing.

Thanx,
Siva.

Thanx for the reply... Yes, i can access the database using a native connection from command line in datastage server. Does any one know whether we need to have the oracle client ver installed for the database version we are trying to connect. apparently we are trying to connect to TST which is oral...

Go Datatstage admin and select your project and on General tab click the environment button and goto user defined category and create a ENV variable called PWD with the correct path of the project. this should be the path where Project is sitting.

cheers,
Siva.

Did any one see this error at the run time. This is a simple PX job which has a OCI stage user defined query to fetch data and put into a sequential file. >##F TFCM 000011 09:19:10(000) <main_program> Requirements Failure: Null arg. job works fine in DEV(i mean when i connect to DEV database), when ...

Where ever i attach the job, before coming out I'm detaching the job from the jobhandle.

Thanx for your inputs though.

Here is the code, DEFFUN JobControlReset(JobList) Calling "DSU.JobControlReset" DEFFUN RunBatch(JobList, Params) Calling "DSU.RunBatch" DEFFUN RunRestartableJob(JobName,NumOfInsts) Calling "DSU.RunRestartableJob" DEFFUN PurgeFiles(DATASETPATH) Calling "DSU.PurgeFil...

Hi All, I have a problem with jobcontrol logic that is not working as i thought it would. Have a batch job that calls say 4 jobs( job1,job2,job3,job4) Jobcontrol Looks like this Repeat: Run Job1 See if it processed any records If Yes Then Run Job2 Run Job3 Run Job4 Wait for a min then go to Repeat D...

Thank you for the reply. I believe you will witness this behavior if you do not specify key columns and a sort and sort order on the input tab of the aggregation stage That might be the case becuase i didnt specify any key fields in the input tab. Let me try that and get back to you in the morning. ...

Hi all, The job has a oracle source and aggregator and target. aggregator stage is getting some 5million records which are ordered by the group fields. This is what happens, if the source has 5million it aggregates and writes to the target and writes this to log JOBNAME..STAGE_NAME: DSD.StageRun Act...

Thank you so much.

Did anybody face this before? DataStage Job 2004 Phantom 25658 Program "JOB.1064986963.DT.1327547383.TRANS1": Line 938, Improper data type. Attempting to Cleanup after ABORT raised in stage CopyOfCurrentWeeklyItemRptDlyLoad..Xfm_Weekly DataStage Phantom Aborting with @ABORT.CODE = 3 What d...

Hi Every one, The job aborts with the following warning ORA-01438: value larger than specified precision allows for this column . How to take care of this problem? I used the Trim function to remove every thing after decimal to debug but it doesnt work. any inputs will be greatly appreciated. Thanx.

Thanx ken, That is what it is. It was 1000 now i changed to 1. it works.

Thanks a lot,
Siva.

Hi, I'm using ODBC stage Pulling data from a oracle table. This is the error what i get. I never got this error before. is this becuase the column length is 255? internal column storage exceeded. LImit is 8192 items, reduce specified array size is there any thing i should do? in ODBC config or simet...