DSXchange

Any idea where I can go as you mentioned "as far back" & also change the "filter" to see more logs.
Thanks chulett

Since datastage only keeps log for a couple of days, is there anyway to go back & check the job log from a particular day in last month ?

Tried that did not help.

Any ideas ...

Thanks

I am getting this error. The job is running with Warning & not Failing: Transformer_5: At row 2, link "DSLink9" DSTAGE-DRS-0513`:`Row rejected. At row 2, link "DSLink9" DBMS.CODE=0, SQLSTATE=22001, [IBM (DataDirect OEM)][ODBC SQL Server Driver]String data, right truncation At...

When I right click on the job in Director & click view log I get this error, any ideas anyone ...

SOLUTION: THE EASIEST WAY (FOR ME) TO PASS A DATE PARAMETER THESE JOBS GO IN A SEQUENCE JOB1 SELECT ISNULL(MAX(Update_Dt),current_timestamp) Inserteddt FROM Table_Name Save as MaxDate.txt Sequential file as varchar format JOB2 Execute command activity cat: location/MaxDate.txt JOB3 User variable ac...

I tried CONVERT(DATETIME,'#p_MaxDate#') still same error.

If I hard code the date
p_MaxDate = "2012-08-14" instead of #p_MaxDate#, the jobs works perfect.

I tried where UpdateDateTime >(select CONVERT(DATETIME, ('#p_MaxDate#', 111)) & tried where UpdateDateTime >(select CAST ('#p_MaxDate#' as DATETIME)) Still same error: [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string. Any ide...

Can you please tell me more about that conversion if you can ...

If I run it quoted where UpdateDateTime >'#p_MaxDate#' now I get error: vItem_SRC,0: [Microsoft][ODBC SQL Server Driver][SQL Server]Conversion failed when converting date and/or time from character string. I also tried where UpdateDateTime > (select convert(datetime, '#p_MaxDate#', 111)) Same error:...

I had a similar situation where the sequence would run but the parallel job wont.

Check the sequence's job log in detail, especially warnings or fatal errors.

I found my problem in the log.

IN the SQL I have:

where UpdateDateTime > #p_MaxDate#

In the job sequence I have : Job1 - Creates a Location\MaxDate.txt Seq file Job2 - Execute command activity - Command: Type Parameter: E:\ETL\ETL_Datasets\MaxDate.txt Job3 - Job activity - Parameter p_MaxDate - EReplace(Read_MaxDate.$CommandOutput, @FM,"") Job4 - SQL stage has #p_MaxDate#...

Those are the only Fatal errors I see.
The metadata & all the fields are matching as per the table.

Hi I am getting this error while developing a job. The Source is SQL, Target is Netezza & there is 1 look up & a transformer in the job. Log: Fatal:Netezza_Enterprise_7: Error when checking composite operator: Caught unknown exception during wrapDescribeOperator(). Fatal:main_program: Could ...