TOPIC:

I’m working on a large definition with six processing steps.  The process generates customer daily invoices.  At the second step I create an InMemory table from an ODBC customer pricing table.  If step two is unable to find any active pricing I want to terminate the process at that point to avoid flagging the shipments as invoiced.  I’ve tried the Stop Heater but I’m guessing with no data there’s nothing to trigger the stop.  

Any help would be greatly appreciated. JD

Hi JD,

Thanks for this question. It seems that´s a gap. In the current Beta Version “4.1.6.2 Beta6” I´ve made a few modifications to handle this.

1. In the Stop Heater  you can now decide what do you want to stop. The complete Definition or just the current processing step. Also you can now define an alternate exit code. This could be helpful with automated processing via CMD scripts in the Batch Module  or the FlowHeater server .
   
   
2. The SQL Heater  can now perform a “select count(*) form ” on InMemory Tables

With these two new features, you can handle your desired process. You just have to add a IF-THEN-ELSE condition whether records in the InMemory Adapter table available or not. This condition must placed after the step that filled your InMemory table. In case the record count just zero, you have to stop the complete definition.

Attached you´ll find a short example.





Beta Version Download
FlowHeater Beta 32 Bit
FlowHeater Beta 64 Bit
FlowHeater Server Beta

Thanks for the solution Robert.  I want to terminate the entire process.  At the end of the processes I will flag all the shipments as invoiced.  If there’s no pricing the values will be NULL.  Since the definitions will run late at night from a win scheduler it could be a few days before it’s noticed.

Can we download the beta version 4.1.6.2 onto our network?  I’m kinda guessing not.  I’m at the beginning of this project so I have plenty of time before it’s released and I can take steps to be sure there’s pricing at the interim.  Any idea when it would be ready?

JD

Hi JD,

Whether you can use the BETA version depends on your free updates subscription. As long they is still valid, you can use BETA versions as well.

It´s planned to release the new features in mid of February.

Thanks again for your continued support Robert. I think we’re good on the license but I’ll wait till mid-February on the new release.

JD

Thanks Robert

We got the update today and the STOP heater works as needed.