FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
See also the general examples available, which may answer your question: Hello World 1 / 2 / 3 , format numbers as character strings , simple If-Then-Else , complex If-Then-ElseIf , filtering and grouping data , consolidate grouped values
  • Page:
  • 1

TOPIC: Terminate (STOP) Process

Terminate (STOP) Process 3 weeks 3 days ago #3546

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.

Terminate (STOP) Process 3 weeks 2 days ago #3547

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.



File Attachment:

File Name: stop-heater.zip
File Size:3 KB


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.
Attachments:

Please Log in or Create an account to join the conversation.

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.

Terminate (STOP) Process 3 weeks 12 hours ago #3548

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.

Terminate (STOP) Process 2 weeks 6 days ago #3549

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.

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.

Terminate (STOP) Process 2 weeks 6 days ago #3550

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.
  • Page:
  • 1

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

Copyright © 2009-2020 by FlowHeater GmbH.
All rights reserved.

Follow us on

twitter  facebook

YouTube

 de en