DSXchange

That is a very common UNIX problem that googling for "The parameter list is too long" would reveal the answers for.

Your script needs to capture the output from the sqlplus session and then grep for problems once it runs. Set the exit status to somthing other than zero when any ORA or SP (etc) messages are found.

Assuming you can connect properly from the job, start the diagnostic work from the Oracle side. ORA-03135: connection lost contact Cause: 1) Server unexpectedly terminated or was forced to terminate. 2) Server timed out the connection. Action: 1) Check if the server session was terminated. 2) Check ...

You can also use the trigger conditions directly for this. Have two triggers from your validation job, one set to 'OK (conditional)' that means all is OK and which leads to your processing jobs and another set to 'Otherwise' which sends an email indicating problems validating the file. This predicat...

I doubt it has anything to do with your "MV" jobs specifically. Schedules are only shown to the scheduling user, are you sure you are checking with the proper userid?

Why did you reply and then put the exact same thing as a new post as well? :? Please delete your other post before someone replies to it. Here, post details on what you've tried so far and clarify what exactly it is you are trying to accomplish. Capturing issues when working with Oracle via the OCI ...

All of which a search would turn up.

An exact search for "smalldatetime" got 24 matches, perhaps one of them will help.

Sreenivasulu wrote:I don't think you can put a 'view data' using a 'pattern'. Datastage would require to apply 'fuzzy logic' to understand this patttern and to apply to one of the file.

Nothing fuzzy about it and of course you can.

Well... out of all that, this is the only bit that really matters: ##W TOIX 000000 15:23:29(000) <Sequential_File_0,0> Couldn't find any files on host PRADEEP-0320510 with pattern D:/Datastage/DX444/ISFiles/Temp/output*.txt. [new-impexp\file_import.C:2624] Silly question perhaps, but are these files...

First suggestion is to search. Looking for "Nonnumeric data when numeric required. Zero used." will turn up quite a number of conversations with what your next steps should be.

Now I know how to say "blahblahblah" in Chinese... just like in English.

That $APT variable helps when you use the 'give me the filename that was matched' option. Right now, it would seem that your wildcard pattern doesn't match any filenames.

OK. How long was 'really long' and what did you have to shorten it to?

As noted in your other thread, posting the actual resolution would be much appreciated.