DSXchange

The possible explanations for an error fitting the pattern below appear to be: <<jobname>>..JobControl (UtilityWarningToLog): USER INFO: Error in sub-routine JOB=> <<jobname>> STAGE=> JobControl LINK=> -8 1. Passing an empty or invalid parameter to a job from the .$UserStatus of the previous job e.g...

Hi, We have just experienced a dramatic decrease of performance of large hash file lookups on our Test server and are having a lot of trouble diagnosing the reason for this. Summary: - As an example - a step in job looks up a 4.7M row hash file with a DATA.30 file of 650Mb and OVER.30 of 208Mb - We ...

We just encountered tghe same issue and thanks to your post figured out quickly that it was the weekly backup job that caused the DataSatge failures. We're also using Windows Server and Veritas backup. BTW - even after the backup was finished there were some files locked by rogue/interrupted uvsh.ex...

I just had the same error message and it turned out to be because the login in SQL server that I had created had a security policy with "expire password at first login" turned on. In other words the error message seems to be a bit generic and can represent a variety of parameter/login prob...