DSXchange

Kumarjit - please start using the Reply to topic 'button' rather than Reply with quote and quoting everything every time you post. Quote when you need to, just not all the time by default.

Thanks.

I'll chime in on (i) and say it sounds just fine to me, assuming you mean the max() values from the refreshed tables.

Stick with 'call'. As noted, save the anonymous block for something that speaks sqlplus.

Fails how?

Can you post the syntax you are using, please?

Odd that something like that would cause such an error.

Glad you got it sorted out.

FYI - Given the nature of the conversation in this thread, decided to move it from the Enhancement Request forum to here. Enjoy!

Next time just post your question once in the proper forum. As Arnd noted, spamming multiple forums just tends to make the natives restless. I've deleted the duplicates since this is the correct forum for your issue.

Not much to go on here... are perhaps any of them of an unusual size, as in 'very large'? What's your target stage? What settings are you using there, for example Array Size? Details please.

I hear when one is expecting it takes around nine months to find out what the answer is. :wink: One a more serious note, you've been given a direction towards a solution - dig into each job's log. Make sure you double-click on them to see the details in each one, especially the passive stage closing...

For grins, verify that that is indeed the actual location of the shell on your O/S.

For grins have you tried sending an email to a single email address to see if that works? I've seen odd behaviour with distribution lists in the past, depending on the email server and how exactly it was set up.

Ah yes, uvbackup and uvrestore, forgot about those.

I've never had to deal with that many as we kept as few as possible in the Projects, so I've handled them manually. And that meant validating the jobs that create them, so they create an empty hashed file and the VOC record and then copying over the Type30 directory contents from the old server / sy...

One thing to note is the "server" is not needed on a UNIX system, hence it not being mentioned in the template. Unless AIX is different in that regard...