DSXchange

Search the forum for that particular error number - 39202. You'll find tons of posts that mention it and it all seems to have to do with improperly setup permissions on the server install.

Mine was the direct result of the improper use of the 'Enabled, Locked for Updates' option in a hashed file lookup, which rather quickly filled the lock table to capacity and had all kinds of nasty consequences to everyone else on the server. We either needed to UNLOCK everything for that user, or p...

Posting a 'BUMP' message is a mechanism used by people on other web-boards to get their issue 'bumped' back up to the top of the forum when they have nothing else to add and are just waiting for someone to notice.

Not really appropriate here.

vimali balakrishnan wrote:There are no issues with the Filename or File permissions.

There is, you just haven't found it yet.

Actually, you can double-click on any log message. The Event Detail dialogue box that pops up has an area for User - as in the user that logged the message, i.e. ran the job.

2. Call the Job Which will Read from the source table and create a file called "triggerfile" in the predefined directory, if the source table has a record with Null extract date. Out of curiousity, how are you keeping it from creating the file regardless of the outcome of the source query? Just hav...

You would write a 'generic' routine that takes the three required bits of information as arguments. Check the syntax of the command - you'll need a handle to the job to check and the name of the link and the transformer it comes from. Your routine would then take the jobname you passed in and try to...

Well... you could always start by checking the online help for the command, the syntax will be fully documented there and in the pdf 'Docs' files installed on your pc.

Well, you are connect to an instance, that's for sure. So, you either connected to the wrong instance, you've spelled the table name incorrectly, you are connecting as someone who doesn't own the table and you haven't specified the owner or you've just plain old specified the owner of the table inco...

I wasn't thinking about stage variables for this. Was wondering if there is a known upper limit to the count then you could simply have that number of output links from the transformer and constrain the output based on the count such that each record went down the first n links. Then a Link Collecto...

In other words, stop focusing on the DS upgrade as the culprit and look into what changed in the query or database to cause this to 'run long'. Your stats may be out of date and the query plan changed dramatically. I'd suggest working with your DBA unless you feel comfortable doing the analysis your...

Or fully path the script in your ExecSH call and make sure it has execute permissions on it.

... and DSLink3.key is defined as what datatype in your job?

All that tells you is the fact that it tried to run a job called SEQ_J_Stage_PS_S_BUS_UNIT_FS_CRM and that job aborted. The next step is to go to the job it tried to run and look at its job log to find out why. What does it say in there?

How comfortable are you with writing your own Job Control? This would be pretty straight-forward if you are but you may be able to do something in the GUI with the new Start/End Loop constructs as well. You could create a simple job that sources that row from the table in question. It doesn't really...