DSXchange

AmeyJoshi14 wrote:I am not able to understand even if we have set the quota time as unlimited why it is throwing the SIGSEGV error message ??

Mostly because it's not a 'quota time' related problem.

OK, so what's different about this one problematic server? I'd mostly be curious about the exact Oracle version and the roles/grants the connecting user has there v. elsewhere.

That plus this should help, and there's no need to concat that extra delimiter.

ps. The Field() usage could be made more generic to always return the last field regardless of the number of delimiters rather than hard-coding it like that. FYI.

svColumnAisValid: Link.ColumnA = 'O13' Or Link.ColumnA = 'S10' Or Link.ColumnA = ' ' Assuming you mean literally *a* space. You may need to throw a Trim() into the last check if not. svColumnBisValid : Num(Link.ColumnB) And ((Link.ColumnB > 0 And (Link.ColumnA = 'O13' Or Link.ColumnA = 'S10')) Or L...

Missing the 'then' from sv2.

Before version 8.x the import/export process is all client based. There's some export capacity on the Server side, but the expectation is that is all handled on the client. The two basic commands are dscmdexport.exe and dsexport.exe off the top of my head - the former is for all jobs in a project wh...

Welcome! One 'condition' that you could set in the child sequence would be for it to log a warning (use UtilityWarnToLog) when this email is sent and nothing else should run. The trigger from the Child Seq to Activity2 could check that and not run Activity2 and Activity3 in that case. However, you m...

That will happen automatically as long as the child sequence has checkpoints. They are completely separate processes each with (or without) their own checkpoints, it's not like it's an "all or nothing" affair. Your trouble spot will be if a check-pointed child sequence aborts and you want ...

Funny - that reply looks like a poem. Not a helpful comment, I know, but that is the first thing that popped into my mind and I had to check to see if anything rhymed.

Don't add checkpoints to the Master Sequence.

Not directly, no. I would build static output files, land the column data in another file and then script a rename of the static files keying from the landed data. If I was doing this.

Get. More. Memory.

Forget the stage and just use a script with command line ftp. You can run it after job or as part of a Sequence job.

I'm not following your issue. You get 'deletes' for records that are in the before but not in the after.

That's no 'option' that I've ever seen that would differentiate 'run ability' between the Director versus the Designer - it should be both or neither. I would suggest you open a case with your official support provider and see if this is perhaps a known issue.