DSXchange

the issue was resolved by restarting the services

Thanks Craig. We were able to login to the server few hours ago. One of our support team was busy importing jobs from other server using istool command and it started failing with "peer not authenticated" and "Java heap space" issues. Then we started observing issue while logging...

Hi All,
we are trying to login to datastage designer/director version 11x but facing the below error. Please can any one suggest how to fix this?

Failed to authenticate the current user against select Services Tier
IllegalStateException : Timer already cancelled

Thanks,
Ravi.

I'd look into scripting a loop around dsjob. Iterate through a list of job names, fire them off one at a time without a "wait" option, sleep for a short period of time. Lather, rinse, repeat until you run out of jobs. Or until the system goes kaboom. :wink: I would go with the option Crai...

Hi, We are running our jobs on 11.3 version in both the environments. Both the environments have WLM disabled. There is a datastage installation team who does the installations for us. Once they finish the installation and give box back to us, we import our jobs and start executing. So from our side...

Hi Craig, Thanks for the response. Is there any way I can get the details why the job is starting after 2mins it was requested to run? :roll: I am trying to understand this so that I can reduce this time, currently we have around 1500 jobs executing in different sets. Some times we obeserved that at...

Hi, Please can anyone help me understand what is happening with my job logs. We have a sequence in which we call 3 jobs and 3 shell scripts all called in a sequence one after the other. Below is the summary of the sequence LD_EXTR_SEQ_SB_ADAPTIV.SZ.JobControl (@Coordinator): Summary of sequence run ...

The issue was indeed because of the Before SQL statement.
Thanks everyone for the help

pssstttt... he's suggesting you skip 9.1 and aim your upgrade sights a little... higher. :wink: I guess I did not read it right :lol: Currently we have the datastage upgraded to 9.1. Not sure when will we reach the 11.x version which Eric was mentioning :roll: Please can you advise where can I find...

Thanks Eric

Thanks Everyone. I guess I will have to stick with shell script for now. Hopefully we will migrate to 9.1 and I will get to use Workload Management or Do I have it in 8.7 already?
I would love to see how that helps me with my design scenario.

Thanks again for you suggestions.

Hi, I am not sure as to which forum my question goes. So I have posted in General forum. Requesting moderator to move the post to appropriate forum. My Question: We are working on Datastage 8.7 and have around 200 jobs in a datastage project. There is no dependency between jobs . We want to design t...

I can try removing the before SQL statement. But when we see the logs the Before SQL statment log is being shown only after 2secs. Is it that before showing the config file log, the Before SQL statement is executed? Also there are only 7000 records in the table and an Index also is defined on the ke...

Hi, We have a job with three stages. OracleConnector ->Copy->OracleConnector. The job does a simple pull from Source. And in the target we INSERT the records with a DELETE statement defined in BeforeSQL Statement . When I observe this particular job there is a log showing the configuration file. But...

Hi, I have kind of a weird situation in one of the Datastage projects. There are two subroutines(R1 and R2) which I am using as the BeforeJobSubroutines. Both these subroutines have almost same funcationality as below 1. When a job is started i call the subroutine through the job, connect to databas...