DSXchange

Set the preserve partitioning flag to "Clear" upstream of these stages

Sri

Please check your fork joins.
Please check your network bandwidth.

Hi

Please check your SQL code. It might have some un-printable character in it. You may need to replace them.

regards
Sriram

=> means Parallel to Parallel (SAME).

As Ray said you will study this in Advanced Data Stage course.

1. First check the record lock
2. Second turn the score on and check where it is failing
3. If it is failing as soon as you start the job then reduce the no of nodes.

hope it helps

If you are using a job parameter then it should say something like that

WHERE dq_ExceptionKey = #exception_key#

or if it is going to be a value from one of the table column then you can say as Eric mentioned

WHERE dq_ExceptionKey = ORCHESTRATE.del_ExceptionKey

Sri

Can anyone come across this error before?
What needs to be done to get rid of the error?


main_program: Internal Error: (minIndex < m_outputLinkObjArraySize): pxbridge.C: 3313
Traceback: Could not obtain stack trace; check that 'gdb' and 'sed' are installed and on your PATH

The error is

odbcPopulate,0: Fatal Error: Null value on the accessor interfacing to field "contract_beneficiary_nomination_comment".

Hi I have field contract_beneficiary_nomination_comment that has data type varchar and length 8000. I set this field to "NULL" using setnull() function. When i run the job, I am getting following error. Can anyone help me? If I assign a blank instead of null then it works fine. Thanks Sri

ray.wurlod wrote:Export the entire project, edit the DSX file, then import the entire project with "overwriting" set.

Thanks Ray

How about for the new ones? Is there a place we can change the default settings?

Sriram

Hi

We have to change the array size and record count from 2000 to minimum no say 1 for every odbc stage.

Is there is any way we can change them globally?

Your help on this is much appreciated.

Regards
Sriram

Thanks Ray!

I searched the forum as well. The warning still appears though it is not causing any functional problem.

regards
Sriram

Thanks Ray and Craig for your speedy response.

I am adopting the alternate approach as Ray suggested using the current date and time within Datastage.

Craig, The select statement doesn't work.

We are using MySQL database and using the MYSQL wire protocol ODBC driver supplied by IBM The following SQL statement doesn't work in ODBC connector stage. It works perfectly in MySQL. SELECT GetZZZDate() AS start_date , GetZZZTime() AS start_time , 'N' AS process_completed , GetZZZDate() AS end_dat...

My job has following three stages External Source -> XML Input stage -> ODBC Connector stage The XML Input stage reads the xml and and a table is created in the ODBC stage with values. While running the job, I am getting the following warning and it doesn't populate the table with any values. The ta...