DSXchange

Yes i have searched for this error but my first question was :

Did the stage Routine accept arrays in a value return ?


Ray's reponse help me about the way to make sequencer jobs and i will make them as he told.

Hi all, I have wroten a basic routine that read a flat file and return values in an array. If i test it in a "routine way" (with the test button) or if i use it in a job control of a job Server, it's ok. The problem occurs if i want to call in a routine stage through a job sequencer. :?: T...

Hello,

for dsn ODBC, you have to declarate them in the DSEngine/ODBC.ini AND in the uvodbc.config for each projects.

Good luck

Hi all, Got some problems with OCI decimals. My job is OCI => dataset My select is basic and do not have any conditions and i just take three key columns not nullable. I import metadata and let DS choose columns type. First is decimal 6, second is varchar and last one decimal 11. In the DB source, i...

Do you happen to know the eCase number? If so could you post it here please? Our case was Case No - 503782*FR but IBM have closed it to open an engineering case and they will reopen it as soon as the engineering have resolved this ecase the 16 April. Don't know much more. IBM have made a patch for ...

ray.wurlod wrote:Do you happen to know the eCase number?
If so could you post it here please?

Our case was Case No - 503782*FR but IBM have closed it to open an engineering case and they will reopen it as soon as the engineering have
resolved this ecase the 16 April.
Don't know much more.

It's a PX bug.
IBM have opened an engineering case for that.

Welcome aboard. :D Does this occur if you use auto-generated DBoptions, supplying user ID and password through explicit properties? (Yes, I know the array size will default in this case, but let ... Same thing : Orchestrate generate automatically the code with something like password=&[my_passw...

Resolved ! My problem was => too many stages and a trsfmr at the end that gone crazy. Explication: My job was DS => colImport => 2 JOINs => TSFMR => OCI The conversions type gone crazy in transformer so i create 3 jobs One for the Joins One for the tranformations One for the Insert in Oracle Table I...

The field is nullable everywhere in the stages and in Oracle too. I have to check if fields are null or not and sometimes they are but the transformer reject the rows because the field is null. I'm going crazy with this problem. Server Edition is easier to work with. :roll: the message is that the c...

chulett wrote:But is the field nullable in your metadata?

And make sure you haven't checked the 'Disable BBCode in this post' option, that makes all your quoting / etc go a little wonky.

Yes the field is nullable.
Thanks for the BBCode

[quote="DSguru2B"]Does your table accept NULL for the timestamp field? If you get rid of the database stage and load it to a flat file with the timestamp field set to null, can you load the data into a file?[/quote] if i put a flat file with link reject i can see these rows and there's not...

[quote="chulett"]What is the [i]actual error[/i] that you get? And is your target Oracle field [b]nullable[/b] or not?[/quote]

My error is something (because i'm at home) like the column from node 0 is NULL row is dropped.
The target is nullable yes

Hi all, Got a problem with Timestamp. I read data from a dataset then join with datasets then go throught a transformer and then make an upsert into an Oracle table. I have some columns that i have to check in the transformer. If data_from_the_beginning is NULL then take_the_data_from_joiner (timest...

FOUND.

OCI PX stage need to read/write an Oracle view using LOAD (SqlLoader) and it seems that in Oracle 9i or in the Database i want to insert data 9.2.0.1 version, there's just a column MESSAGE and not MESSAGE_NUM.
I changed to upsert and it works,

Thanks.