DSXchange

Hi, I marked the jobs for multiple instances and we ran 2 instances of the same job. Always one is running and other is not. Both are not running successfully. My job ran successfully with message ERROR: Failed to lock job Status code = -10 DSJE_JOBLOCKED Finished waiting for job Status code = 2 and...

Actually each file we are using in the job, is made unique by adding a code which comes as a parameter to the job. Will this make sure that multiple instances can run ok? Also, the only way to make each job have multiple instances is to check the multiple instance property in the job? no other way? ...

Hi Ray,

I could not see the premium content, but your first option, of allowing multiple instances, can this be done at the project level, which will imply to all jobs so that we dont need to change each and every job.

Thanks,
Harshada

Hi, I wanted to know, can a same job be run simultaneously in two different sessions with different parameters passed to it? We need to trigger the same job simultaneously with diff parameters. So when I run a job from unix box using command dsjob -run -jobstatus -param <parameter list > <project na...

Hi While using function like trim,substr in the sql for progress database it is working fine.But while using the same query in the ODBC stage and run it is giving syntex error .Any idea why? Select substr(company_name,1,5) from company works fine in the progress database. But the same query giving e...

Thanks for the suggestions.
But the jobs have always throws the warnings and worked. This time also after trying 3 times the job worked without any code or data modofication.
Is it that SIGINT is some kind of interruption from unix server or the server is over loaded.

other warining messages are APT_CombinedOperatorController(2),2: Field 'DESCR' from input dataset '0' is NULL. Record dropped. APT_CombinedOperatorController(2),2: Warning, all other rejected records will be silent. Even if the jobs runs successfully it gives the above two warnings. This is basicall...

I am getting the following error while running the jobs through a sequence.
main_program: ORCHESTRATE step execution terminating due to SIGINT.
Earlier also I have faced the problem.But simply re-running the job has worked out. But now I am geeting this problem everytime.

I cannot do that as I also have to count the number of fields in each record, so I am reading it in a single column. Also there are many fields , I cannot perform all the validations on all the fields tats why I have to first cut the field (e.g 3rd field) and then perform validations on it.

Hi, I have a file which has fields seperated by ","(double quotes comma double quotes. So data is like "LAA","1644/10","+Jul","","","SURNAME-","FORENAME","1 FLOATED ONE " I want to read each record in a single ...

Hi, I have a requirement where I have to read a file having variable record length. My input is like given below: Date Published: 01/12/2006 "PD","ENO","Status","Surname-Su","Forenam","01/01/2008 ","Franchise Flag","Separate ...

Hi,

Runtime Column Propagation (RCP) was a problem. I removed the check and its working now. Thanks for that

Others thanks for the solution provided.

-
Harshada

ohh sorry about that.. thanks for letting me know.

hey...

its resolved...

Just used StringToDate(Trim(INP_2.DATEP),"%yyyy%ddd")

Thanks anyways.. if anyone was trying over this one

Harshada

Hi, Foll is the job. Seq file read --> Transformer-->Oracle table load The column 'FILE_CODE' is not propagated beyond transformer. Still i am getting the error "Oracle_Enterprise_15: Describe failed because of a missing column for FILE_CODE". Write method=load Write mode=append. The colum...