DSXchange

Looks like you are handling failure explicitly due to which the master job sequence is not aborted. Verify whether this design works. S1 ---OK Trigger -----> S2 ------OK Trigger ----->S3 And Set "Automatically handle activites that fail" to true by selecting the check box in master sequen...

Actually, Craig did specifically ask him to remove the Exception Handler. Oops! i had misinterperted your statement. Sorry for that. Parag, Also post your custom trigger code. Hey Not a problem... Basically for e.g, My job design after using custom trigger, is restartable. There are 3 subsequences ...

Craig did not ask you to remove exception handler. He had asked you to remove custom triggers and use OK triggers instead. May be you have not read my full reply properly. I've done the same thing...Later I said the alternative to it is to use the custom trigger. May be if you have some good soluti...

Hi Chulett, As you suggested, I tried running the master sequence after removing the exception handler and kept the triggers intact. But still the master sequence was showing 'Finished(See Log)'. And it was not getting aborted. I think the only way is now to connect each subsequence activity to a se...

That's not how the Exception Handler works. And adding it overrides the 'automatically handle' option. Remove it, use just OK triggers and let us know what happens. ... As per the documentation on 'Automatically Handle' option, It will not work if there are any sort of triggers involved. And if the...

I do not understand, why the exception handler in master sequence is not working if in this case the subsequence is getting aborted. The exception handler is not able to send a signal to the connected Terminator if the subsequence is having an abort.

After browsing through all the posts on restartability, I am still not able to achieve it in my scenario. The condition goes like: - We are having a scenario where we are having multiple subsequences. Lets say S1, S2, S3 Now these sequences are having a custom trigger where we are checking job statu...

This is what the documentation says: The stage assumes that the incoming data is key-partitioned and sorted in ascending order. The columns the data is hashed on should be the key columns used for the data compare. You can achieve the sorting and partitioning using the Sort stage or by using the bu...

I am having following scenario: - I am doing a change capture between the source table and the target table. In source table I am taking the incremental load. currently the data present in both source and target is: - SOURCE: - RefNO. ApplicantNo. ApplicantID Val1 Val2 111 1 1 Y N 111 1 1 NULL NULL ...

Hi, When we are running the jobs or sequences, we are getting the following error and it is getting aborted: - main_program: Internal Error: (APT_SC::downcast(pConsumer())->kind() == APT_Operator::eParallel): sc/sc.C: 3984 Traceback: Could not obtain stack trace; check that 'dbx' and 'sed' are insta...

The "not enough space" is in /u04/tmp. ... Hi, we were monitoring the memory and disk usage while running the job. What we found out is, The temp file getting created is of 4 GB size, also it created 300 partitions in the disk, but we could not monitor the RAM usage. Also the problem is i...

Sorry to mention in earlier post: -

There are 40 million plus records comming in. Also I had to use lookup because business wants to use the data of reject link. and hence I had to use lookup stage so that, the reject records will be used by business

Hi All, After reading many posts in the forum and trying many options given, My job is still failing due to insufficient memory. The error I am getting is: - Lkp_CoverDetail_Ins_Upd,0: Could not map table file "/u03/Datasets/lookuptable.20071219.suos0lb (size 1700927896 bytes)": Not enough...

iDomz wrote:floor returns integer as far as I know.

If that is so, then it should not give warnings while I am reading it as a Decimal type.

But its giving me that warning

I am using the OCI stage as aninput source for one of my job. I have to do a calculation on two date fields and take the difference of dates in years. Finally I have to apply a floor function on it. So the final code in query is : - FLOOR((MONTHS_BETWEEN(QED.QUOTE_DATE, IP.BIRTH_DATE)/12)) AS "...