DSXchange

I found a stage that, at least in theory,can handle a fatal error message from the db as a warning. The Stored Procedure stage. I ask again. Is there a way to tweak Oracle Enterprise or to write a Custom Stage that would behave like Oracle Enterprise but handle errors as the ODBC Enterprise stage, o...

Yes they cannot be demoted by message handler. With message handlers you can either promote an informational message to a warning or you can demote a warning to an informational message or you can suppresed a message from the log. Nothing about fatals, which somehow makes sense (i agree with miwinte...

Hello, I was wondering about some differences between odbc enterprise and oracle enterprise. On short, I would like to use Oracle Ent. but do to some contraints in my db, my jobs fail because Oracle Ent. raises fatal errors, while Odbc Ent. only warnings (warnings that can be sent down a reject link...

Hello again, "Disable contraints" apears only at the Load Write Method. But my case requires i update/insert records (basically it compares 2 tables and then i "update" - add or modify records - one table with the difference set of records).And in the Upsert method there isn't an...

Hello,
what if the enviroment variable seemed ok. could it have another cause ?

Regards,
Maria

to miwinter : the log reports fatals. And the job fails. I made some tests and it appears that the reject link works with ...warnings. Let me explain : - i've tried to see if a null to a not null column would be rejected. Result : it did. In log appeared warning and the record got down the reject li...

chulett: What do you mean by they are "completely ignored"? Are you saying that, even with the reject link, nothing goes down it for a FK violation? Yes, exactly. Nothing goes down on it. Except when i set InsertAraySize =1, when i get always (on any job) 2 records on the reject link. miwi...

still, i thought reject links were supposed to capture data that failed integrity constraints, so why does my job completelly ignore the existence of a reject link from the destination stage when it comes to FK contraints ? What would capture that link if not exactly this type of things ? I thought ...

I'm afraid it is not related to the array size. I want to use the reject link to reject those record that fail FK constraint. Is it possible to reject these records trough them (reject link from the transformer or from the destination db stage) and the job to succed or i must use look-ups for every ...

I've tried also from the db stage ...it is the same thing. The only diferrence seem to happen when i choose "insert array size =1", then i'm getting 2 records rejected, and then the job fails ...due to fk constraints.

hello, I'm failing in using reject links from transformer and from oracle ent. I have a 2 sources as oracle ent stages,a change capture stage,a transformer and a destination oracle ent stage. I want to insert/update in the destination (which is also one of the sources) what differes in source1 from ...