Any idea where I can go as you mentioned "as far back" & also change the "filter" to see more logs.
Thanks chulett
Search found 42 matches
- Fri Oct 18, 2013 6:03 pm
- Forum: General
- Topic: How to Check old job log
- Replies: 3
- Views: 2826
- Fri Oct 18, 2013 4:16 pm
- Forum: General
- Topic: How to Check old job log
- Replies: 3
- Views: 2826
How to Check old job log
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 ?
- Wed Aug 14, 2013 10:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Row getting rejected for decimal point data
- Replies: 3
- Views: 2866
- Mon Aug 12, 2013 10:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Row getting rejected for decimal point data
- Replies: 3
- Views: 2866
Row getting rejected for decimal point data
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...
- Thu Oct 11, 2012 10:15 am
- Forum: General
- Topic: Cant view job log in Director & get this error
- Replies: 2
- Views: 1940
Cant view job log in Director & get this error
When I right click on the job in Director & click view log I get this error, any ideas anyone ...
- Tue Aug 21, 2012 2:33 pm
- Forum: General
- Topic: Pass date parameter
- Replies: 12
- Views: 8333
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...
- Thu Aug 16, 2012 3:08 pm
- Forum: General
- Topic: Pass date parameter
- Replies: 12
- Views: 8333
- Thu Aug 16, 2012 1:52 pm
- Forum: General
- Topic: Pass date parameter
- Replies: 12
- Views: 8333
- Thu Aug 16, 2012 1:19 pm
- Forum: General
- Topic: Pass date parameter
- Replies: 12
- Views: 8333
- Thu Aug 16, 2012 12:58 pm
- Forum: General
- Topic: Pass date parameter
- Replies: 12
- Views: 8333
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:...
- Wed Aug 15, 2012 9:11 am
- Forum: General
- Topic: Parallel job is not running
- Replies: 6
- Views: 2790
Re: Parallel job is not running
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.
Check the sequence's job log in detail, especially warnings or fatal errors.
I found my problem in the log.
- Wed Aug 15, 2012 8:51 am
- Forum: General
- Topic: Pass date parameter
- Replies: 12
- Views: 8333
- Tue Aug 14, 2012 5:08 pm
- Forum: General
- Topic: Pass date parameter
- Replies: 12
- Views: 8333
Pass date parameter
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#...
- Tue Apr 10, 2012 7:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error Checking Composite Operator
- Replies: 3
- Views: 2569
- Tue Apr 10, 2012 3:33 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error Checking Composite Operator
- Replies: 3
- Views: 2569
Error Checking Composite Operator
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 ...