DSXchange

Does anybody know what may cause a job not to run? We have this problem once in a few months. CCSCDialerDistBatch.JobControl (DSRunJob): Job control error (-14) (DSRunJob) Job IfmxCcshtitItmXrefCreate1 has not logged any events since #1010, and appears not to have started after 1800 secs Thank you, ...

Paul, actually it should work exactly as you describe it. If done it same way many many times. Please check the exact spelling of your parameter names and variable names. Its all uppercase/lowercase sensitive! After reading the hash-file, write your variables to the logfile to see if their values is...

Hello, I wish to pass a parameter value to a job from a batch control job. Realizing the fact that I can use DSSetParam to do that, I still have an issue. Here is my situation. I have the required parameters stored in a hash table. My batch control job will first read those parameters and assigned t...

Hello, I have a question about sybase plug-in. This is the first time I work with sybase, When I doing a lookup with sybase stage, the result I get is always a null value. This is what in my sybase lookup stage. Its a generated sql query: SELECT DISTRICT,CUSTOMER_ACCOUNT,CUSTOMER_SUB_ACCOUNT,SERVICE...

I had the same thing happen twice during the few months we were on version 5.1 (HP-UX 11.0). These jobs have been in production for 18 months and I had never seen this happen before. We upgraded to 5.2 a couple of week ago and Im hoping the problem doesnt recur. We never found a reason why the DSWai...

Henry, I,ve to create a NET8 entry in the tnsnames.ora file and I no problem, but I would to test performance between OCI8 connection with protocol NET8 (tcp/ip) and BEQ. In Windows 2000 with datastage 5.2 (same server); I,ve two entry in tnsnames.ora for same ORACLE_SID, the first (alias A) use NET...

I cant repeat the problem. Ill just log it as another mystery of the world. Chris. Quoting Chris Kearns : > I already have logged this one with Ascential, but no joy (yet). > Anyway, Ill try and repeat the problem and let you know what I find. > > Thanks, > Chris. > > Quoting David Barham : > > > Ch...

I already have logged this one with Ascential, but no joy (yet). Anyway, Ill try and repeat the problem and let you know what I find. Thanks, Chris. Quoting David Barham : > Chris, > > Yes, you spotted the anomaly. DSRunJob is supposed to wait for the > job to start (as indicated in the log). My und...

Chris, Yes, you spotted the anomaly. DSRunJob is supposed to wait for the job to start (as indicated in the log). My understanding is that it looks for a log entry to detect the fact that the job has started. I find it very strange when comparing the logs to see that DSRunJob has returned and DSWait...

Hi David, Thanks for your response. Here are the relevant log entries for the controlling job: * 07/06/2002 01:27:49 AM BuildRosterFactNewJC -> (LoadWorkCodeStage891): Job run requested * 07/06/2002 01:27:49 AM BuildRosterFactNewJC..JobControl (DSRunJob): Waiting for job LoadWorkCodeStage891 to star...

Chris, Could you please post the entries from the log of the controlling job for the run corresponding to the logs below? -----Original Message----- From: Chris Kearns [mailto:chrisk@zing.com.au] Sent: Friday, 7 June 2002 12:10 PM To: datastage-users@oliver.com Subject: DSWaitForJob problem? Hi All,...

We had FTP stage problem when we transfered to win2000 server, there were a patch released from Asential software. Good luck! Yuzhou Fan DP Application Developer II Oklahoma Department of Human Services Data Warehouse project yuzhou.fan@okdhs.org -----Original Message----- From: Kavney Damien [mailt...

Hi, We have been running Datastage 4.1 on Windows 2000 Server for 12 months now with no issues due to Win2k. My advice in any installation would be to set-up a test machine and test all jobs in a test environment before moving to production. Regards, Damien Kavney Technical Consultant Dialog Pty Ltd...

Hi, I am pretty new to this listserve. We are currently doing some big upgrades of hardware and wanted to see if there was anyone else on the list that is currently using: A) An IBM Shark - SAN - primarily what your configuration looks like - we use Sun Solaris for our Unix machines that run DataSta...

Christiano, I dont know why the OCI8 connected with BEQ when the source name was omitted. Maybe it is a documented feature of the OCI stage to before BEQ connections in the absence of a data source name. If it works--great. No problem leaving well enough alone. I would probably check the documentati...