-
JD Cox
-
Topic Author
-
Offline
-
Posts: 95
-
-
|
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
|
Please Log in or Create an account to join the conversation.
|
-
FlowHeater-Team
-
-
Offline
-
Posts: 391
-
-
-
-
|
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.
- 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
.
- The
SQL Heater
can now perform a “select count(*) form
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
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
|
Please Log in or Create an account to join the conversation.
|
-
JD Cox
-
Topic Author
-
Offline
-
Posts: 95
-
-
|
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
|
Please Log in or Create an account to join the conversation.
Last edit: by JD Cox.
|
-
FlowHeater-Team
-
-
Offline
-
Posts: 391
-
-
-
-
|
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.
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
|
Please Log in or Create an account to join the conversation.
|
-
JD Cox
-
Topic Author
-
Offline
-
Posts: 95
-
-
|
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
|
Please Log in or Create an account to join the conversation.
Last edit: by JD Cox.
|
-
JD Cox
-
Topic Author
-
Offline
-
Posts: 95
-
-
|
Thanks Robert
We got the update today and the STOP heater works as needed.
|
Please Log in or Create an account to join the conversation.
|
Time to create page: 0.245 seconds