DSXchange

Greetings, During my recent evaluation of MetaStage i found that it helps you to maintain the Techinical Metadata from DB objects, DS Jobs, Reporting Models & Reports and also maintain the Operational Metadata from DataStage and other Reporting ststems using the MetaBrokers. I see there is a a B...

No, is a simple job with simple transformations. No routines are used.

Badhri ...

mandyli wrote:Hi Badhri,


are you using any of DS_LINKRow count routine in your job..


Thanks
Man

Greetings, When i open the job it throws up some error message like "Record <> in file DS_JOBOBJECTS does not exist". And finall it throws up the error message "(40521) Unable to retrive the link details for the stage" PLease let me know if you have encounted this and the correct...

Hi Ray, It is a job sequencer. It had been scheduled to run daily for the past one year and we face this issue just for the past 2 weeks. Also, when i compiled the job and ran it it picked up the Rows/Warn as 0/50. This was really weird?. Does this give you any clue. I just checked the job sequencer...

Hi Ray, Thanks for your input. We just found the next level to this. The job sequencer which calls this job logs in the below Mode (row/warn limits) = 2000/50. We don;t encounter the issue when we have this logged as Mode (row/warn limits) = 0/50 Why is that 2000 popping up? Kindly help. Badhri ... ...

Greetings: I get a message as below in the transformer stage. The message shows after the target load starts. StageDWCommissionInitCit..Tr_Commission_Init: At row 2000, link "Read_Commission_Init" Run stopped StageDWCommissionInitCit - Job Name Tr_Commission_Init - Transformer Name Read_Co...

Greetings,

When i use a XML plugin i get the above error msg ( Line 295, Square root of a negative number) ...

Any clue when this will happen and the fix for the same?

Regards,
Badhri ...

Hi Ray,

Thanks for your input. I tried this dsjob and get the update. But everytime someone wants to know the status of the jobs i need to run this dsjob command for all the jobs which is very time consuming. Is there anyway i can erive the status of the all the jobs in one go?

Badhri ...

Greetings: I am trying to get the status of the jobs from the Command line and help monitor the jobs without using DS Director. For this i just loop through all the jobs and run dsjob to get the log details and spool into a text. Then parse this text to derive the required info. This whole process i...

Greetings, My mapping has a output OCI Plugin and I populate my target table there withe several source tables. In the "After SQL" tab I have a update script that updates one of my target columns to Zero if it NULL. When I stop this job for some reason I find that the job comes to the &quo...

Greetings,

What is the use of the "Use OS Level Authentication" checkbox in the Oracle OCI PLug-ins. How does that work?. Kindly let me know your thoughts

Thanks & regards,
Badhri ...

Badhrinath Krishnamoorthy
www.cognizant.com

Greetings, We are using Data Stage 6.0.1 on Sun Solaris and the Prime Database we connect to is Oracle 9i. All our database operations are performed using the ORAOCI9 plug-in. But just thought of these things, When I use a Update/Insert strategy in my update action the Plug-in generated a update and...

Greetings, Similar to the DSGetJobInfo where I can retrive the Start time, End Time and the status is their a function where I can retrive the complete Error message from the job incase of any Warning/Abort. I guess the notification activity does this and I would like to know the DS function that it...

Hi Micheal, Thanks for the input that this an known DS issue. Do you have any idea what the next steps in this regard from Ascential. Are you facing the similar issue or do you know anybody facing the similar issue. To addup to this. When we did the installation we had this working and eventually en...

Greetings, No matter whether it is version 5 or 6. Of i go to the bin directory of the server and type dsjob I get the error message "Segmentation Fault(coredump)". Ideally when we do this it would return Command Syntax: dsjob [-file | [-server ][-user ][-passwor d ]] [] Valid primary comm...