DSXchange

Larry, Craig, interesting point - thanks I'm exploring your suggestions now. The Row Buffering isn't available in 5.x therefore my spontainious thought was - is it on by default in 5.x? .. well, perhaps not. Hoping it will inspire you to give me even more hints I'll answer your questions: Truncate :...

Okay, option a) seems to be the issue (but still can't rule out b) is also an issue). A question then: some of my jobs do a truncate on a given table - is it possible the DS ignores doing a truncate before inserting rows? If so, then a) isn't an option really and perhaps b) isn't either because that...

I get this error when either quering a Hash or an ORAOCI8 - and in most cases I'm just doing the batch/lookup on one single value, a number. I received this error about 2 months ago and when analysing the wrote the output from the "Transformer" stage to both the ORAOCI8 object and a sequen...

Hi, in several jobs i've been experiencing "random" cases where I'm doing a lookup on say PORTFOILIO_ID (have some other examples also) and the reference returns a wrong row (having a different portfolio_id). In all cases that I've found the error has happened in two consecutive loads of m...

Alraight, don't think it will help but here you are: USEREXISTS IF IsNull(hLoadUserLifeCycle.ID) THEN 0 ELSE 1 Desc: used in the CONSTRAINT only - if I find a user, I insert that users current row into my staging table. ENTRYOK IF IsNull(IDimensionsAllocated.CUSTOMER_TYPE_ID) OR (IsNull(IDimensionsA...

Yes, I'm using staging variables, partly to decide if a row should be inserted and partly to decide if I can use an existing USER_ID or if I need to create a new one.

/Tobbi

Hi! I'm getting strange results in one of my jobs. It feels like sometimes (not always) when I do an insert, the value of ONE column is cached or something similar so when I do the next insert to row the value from my previous insert is used for this particular column. The problem is that there does...

Okay,

the solution in this case was to export the ControlJob (DSControlJob), delete it in Designer, import it again, compile and everything was fine!

man, why didn't I do this in the first place!

Lesson - when all else fails, export, delete, import =D

Thanks for your input guys!
/Tobbi

True, and I've tried all- recompiling, resetting and "clear status file" of the original job - no success! Although this is happening in our production environment I'm gonna start exporting and deleting stuff to try to solve this - if that doesn't help I guess I'll try to change the name o...

Thanks for the input but guys - but I'm still stuck. 1: "Job administration in director" has always been checked -> "clear status file" option is greyed out anyway -> "cleanup resources" wount help - there are no processess active 2: i've learned that the way I'm runnin...

Hi! I'm having a problem with a job that is stuck with the status "Running" when I know it is not! (I've shut down the DS demon and restarted it). To complicate things (I think) this job is a "phantom" job??!! We use an external scheduler that starts a control job that then creat...

Hi, I had something similar with oracle 8 the cause was locks that were not cleard due to some crash of the job leaving connections which lock the table. please check with your DBA to release all locks on your target table. once our DBA cleaned the conections locking the table the job worked fine. ...

Thanks for you reply and I'll try to be a little bit more specific! What I did (this morning) was that I removed all the hashed files - I still have the same problem as before (without the hashed files). - I'm accessing an Oracle 8.1.7 database - I'm doing reads and writes to and from the same datab...

Hi, I'm having problem with a job that seems to hang. Since I'm testing I'm only running it on approx. 5000 rows. When I do a "Monitor" on the job I see that all Hashfiles are populated but all the transformations aren't fetching a single row!! Background info: During the past two days it'...