topic Re: In a reload script and reload task, raise exception if "0 lines fetched" in App Development

In a reload script and reload task, raise exception if "0 lines fetched"

Anonymous — Wed, 30 Nov 2016 16:15:32 GMT

Hi. How can I raise an exception if I have a "0 lines fetched" during any point in the reload task?

2016-11-30 08:00:06 0104 FROM [myDatabase].[dbo].[myTransactionsTable]

2016-11-30 08:00:06 0105 WHERE TranType IN (

2016-11-30 08:00:06 0106 'buy'

2016-11-30 08:00:06 0107 ,'sell'

2016-11-30 08:00:06 0108 )

2016-11-30 08:00:06 0109 AND InvCode NOT LIKE '%collateral%'

2016-11-30 08:00:06 0110

2016-11-30 08:00:06 0111 ORDER BY TDate DESC

2016-11-30 08:00:07 30 fields found: *** OMITTED FOR BREVITY ***

2016-11-30 08:00:07 0 lines fetched

Re: In a reload script and reload task, raise exception if "0 lines fetched"

rubenmarin — Wed, 30 Nov 2016 16:28:13 GMT

Hi Khoa, the function NoOfRows('TableName') returns the number of rows, you can check if it's equal to zero.

Re: In a reload script and reload task, raise exception if "0 lines fetched"

Anonymous — Wed, 30 Nov 2016 16:33:31 GMT

How do I then raise an exception? Thus marking reload task as failure?

Re: In a reload script and reload task, raise exception if "0 lines fetched"

rubenmarin — Wed, 30 Nov 2016 16:38:28 GMT

Hi Khoa, you can finish the reload with "Exit Script;" Is this what you want?

You can use it like:

Exit script when NoOfRows('TableName')=0

or:

IF NoOfRows('TableName')=0 THEN

Exit Script;

ENDIF

Re: In a reload script and reload task, raise exception if "0 lines fetched"

Anonymous — Wed, 30 Nov 2016 16:42:40 GMT

Would Exit Script; cause the task to end in failure in QMC? Because this is what I want. I need an easy way to, at a glance, tell fail from success of my tasks.

Re: In a reload script and reload task, raise exception if "0 lines fetched"

rwunderlich — Wed, 30 Nov 2016 16:44:43 GMT

The only way to raise an exception is to introduce an intentional syntax error like this:

IF NoOfRows('TableName')=0 THEN

Failing due to no rows;

ENDIF

The "Failing due to no rows" is an invalid statement, but it will nicely show as the error cause as well.

-Rob