DSXchange

Then I would ensure you do not cache the lookup to this hashed file you are updating and see if that resolves your problem.

A couple of points. First, that message is not an error or even a warning, it is strictly informational and means you told it to cache a hashed file lookup and it couldn't fit into memory. It simply reads it from disk in that case as if you hadn't asked it to be cached. Not a problem. And increasing...

Ah... you can't. That's the only downfall to this method is the files cannot have parameters in them. I was able to "work around" this issue because I had a limited number of parameter values and so created a file for each parameter value with that coded into the file and the actual parame...

You only get those stages on a Windows server, as far as I know.

If you do an Exact Search here for that error message, you'll find it doesn't just happen on string fields but can happen with unbound NUMBER fields as well. I'd suggest you search and see if any of the previous posts on the subject here help.

Never seen that error before and the only post a search reveals here with that in it was for Informix and there was no resolution posted. :( Seems to me you'll need to get help from your official support provider on this one. Out of curiousity, what Oracle ODBC drivers are you using - wired or non-w...

debrujr wrote:

chulett wrote:To me, it sounds like you are doing everything correctly. ...

Can you call my boss and tell them that?!?!?!

You might want to ping your official support provider and ask if there are any issues doing what you are doing in your version. To me, it sounds like you are doing everything correctly.

Ah... that pesky Filter will do that to you if you don't notice it's on.

To me that's odd as I've been doing that very thing for quite some time now - check just those two compiler options, use only an "OK" trigger to the next object and for any issues the job aborts, triggering the checkpoint handling. And for the Execute Command stage, any non-zero return sta...

Yoda says: "Odd, I have always found that."

Remind us what version of Oracle is required for this, plese - 10gR2 I do believe, but not positive.

Sounds like a job for USERSTATUS. Search here for that word and also "SetUserStatus" to find discussions on its use and example code.

Are those two options you mentioned the only ones checked?

What kind of help are you looking for?