DSXchange

You're close. It is looking for YYYY-MM-DD HH24:MI:SS so:
Should work more better.

Sounds like you missed a configuration step... don't you already have a post on this issue?

OK but let's not muddy the waters. The question was specifically about Server job "migration" not what a PITA an 8.x upgrade can be in general nor anything about Parallel jobs.

OK, better.

Outside of the "8-ness" of everything, Server jobs should work (and upgrade) just like they have in the past - painlessly and automatically. To the best of my knowledge.

Is the number of comma delimited fields fixed or variable? Or do you at least know what the maximum number of fields there can be?

Something wrong with using the Surrogate Key stage?

1.5?

What database and what is the "NLS setting" of that database?

You can't use the Job Activity stage for this. You'll either need a Routine that uses DSExecute and DSSetJobLimit or a script via Execute Command with dsjob and "-warn 100" to run the job.

Actually, it *is* true... in Oracle.

What stage? And we would need to see the actual query to help, not something 'similar' to it. In that same vein, please post the actual unedited error from the job's log. You've no idea how many of the wild gooses we've chased because people felt the need to obfuscate their problem by giving incompl...

They do or they wouldn't work when rerun individually. Sounds to me like a resource issue, one that I would take to my DBA if it was happening to me and see if any session limits need to be bumped up.

whenry6000 wrote:Is this just a behavior of DS? is it the Copy stage that's doing it or the Oracle Enterprise stage? Is there some environment variable I can change to alter this behavior?? Or is this a funciton of the database itself?

And just to answer the question - database itself.

Those commands are used to validate the control records in the repository for the project. I posted his complete suggestion from the post I found, which basically was to search for those terms to find the discussions we've already had on this subject. There are some caveats to using them that you'll...

I guess one question would be - do you want to attempt to recover the existing project, or clear it so that it can be recreated again, empty?