DSXchange

Was you Import/Export ended up in success? What was the change recently made in your prject. You can try REINDEXing. But I would suggest before doing it, do a COUNT on DS_JOBOBJECTS or DS_JOBS and verify everything is ok. All this can be done in TCL or DS Adminstrator client, command option. Make su...

[quote="dsedi"]Hi Kumar Oracle stage partition type =>Entire Config file=>1 node Why is it that even though I am partitioning the data and then having 2 nodes to work on individual data partions, still the job takes more time. quote] As Arnd mentioned and I mentioned, you may have less to ...

Click on ok, and under locks, select Show All.
You might find your job. Note down the PID. Select the PId from Process block.
Now again click on show by process under Locks.
Click on release All.
Try to use dsadm user id.

Or read as varchar, check for first few digits for "Subscriber" or "Call" or 'Sub" and based on it you can divert it into different stream. And ignore the first 2 lines. And this should be done untill an empty space. Guess it is the end of that paragraph. You can use stage variable and flag for this...

Since your output has "abcd efgh 1", either trim and get the exact output or follow as Ray suggest to get the substirng during the check.

Ray - You teach english too

Are you sure there is no change in the job. What about the unicode for that particular field in that job?

So coincidence. Found by yourself.

Datastage designer based version 6.0 user id and password.

Hi Meena,
The issue is not with the credentials but with change in versions. Hope you got necessary feedback form this post.

Can you post the message while getting aborted.

Try to run the same 17 jobs when the resources are idle.

The metadat for the rejected record will be automatically a chunck, like varchar, and not according to your input metadata.

What is the desigh of the job.
Does it write to a target table (DB). Check for locks.
There are chances where the director or job monitor might show that the job is running, but it would have actually finished. Check for the required output.

Is it a regular proccess to use the word PROCCESOR sorry PROCESSOR in every post

Or read the file and write a Schema file for its structure. User RPC Enabled job. Use the Schema file which changes everyday as the soruce.

Or have a metadata as ID,Name and rest all varchar(225). Have a transformer, detect the missing column and distribute the columns accordingly.