DSXchange

Hi, One job in my sequence just reads a source table and writes to a hash file. While reading records from source table Only records for past 100 days are selected by a where clause. All the jobs give results as expected even the number of records written to the hash file are as expected. Still the ...

Thanks Mike,Naveen and Arnd.

Hi naveen,
1. yes.
3. you can develop a logic for the reject link constraint by doing a comparison using DIGITS or LETTERS transform at job level.
Not sure about best way to simultaneously sending mail part of question2.
Thanks,
Ash.

Hi All,.....Mike,
Is there a upper limit for number of columns that can be compared using CRC32 function and how will be the performance be affected by having around 80 columns to be compared using crc32.Did a quick search on the discussed pls direct me to the link.
Thanks,
Ash.

ok..thanx..got it.

Thanks naveen,
I will try deleting the Rt_LOGnn file...better than waiting for 10 mins i guess.
thanks,
Ash.

Hi, I had a job running which created a error log of more than 800000 entries. :lol: Now the error is fixed ,job running fine etc. Can i use the cleanup resouces tab to just clear the log entries before the last run. was curious to know of a way to clear the director log entries without opening the ...

Hi Sai/Craig, rerun was successful.....obviusly was some db problem.... and my apologies..... My mistake....my project manager pointed out that the other jobs never completed sucessfully...the status "finished" seeing which i was confused was from the previous day..big oops Sorry and thank...

Hi,
Checked..Yes they are....
We are going to run the job again.shoudnt be a problem but still wondering what would have made one job abort. Because as per the error I guess all jobs should have been aborted.
thanx,
Ash.

Thanks craig :D
but all other jobs accessing the same dbase executed properly...all started at the same time...only 1 job..1 sequence aborted...why would that be?
Thanks,
Ash.

Hi All, One of our jobs failed in a sequence was aborted with the following error ORA-01089: immediate shutdown in progress - no operations are permitted we are guessing that possibly the server went down so the sequence aborted. the job was running properly previously. What could be the possible re...

Hi Ranga,
Null Value handling is rather a precaution to be takeb while using CRC32. It does not limit using the function.So make sure you are handling the null values properly as john has mentioned by using nulltoempty() or nulltozero()
Ash.

Hi,
sorry,
I could not delete the post..I dont know why.
Anyways i got it..I was wrongly capturing the change. When i got the change code 1 the apply stage worked as it should.
thanks for your attention.
Ash.

Like to add that the change_code is 1 which is for insert..right?. I am inserting a row in the after for capture .
thanks.

Hi, I am trying to apply the changes captured. But somehow In the output file I am getting only the before records and error as Change_Apply_2,2: missing before record: change keys = (column name:column value). The changes record which was captured is not written to the output.Link order is before a...