FlowHeater

I had the earlier version of flowheater (the first version) and now that I have upgraded to version 2, my Lookup functions stop working. They all look correct, as per version 1. Any suggestions?

thanks Tim

Hi Tim

There are some changes about SQL Server user/owner tables and schemas. Do you use the SQL-Server Adapter with the database Lookup Heater?

Best practices) The Lookup Heater is very strength. Please try to use the new SQL Heater instead of the Lookup Heater. With the SQL Heater it is very simple to implement a Database Lookup.

Here you can find an example how you can use the SQL Heater. Dynamic SQL Filter

If you want to use the Lookup Heater furthermore please post you’re FlowHeater Definition (zip) for more analytic.

Hi, thanks for the reply. I am using the sqlServerSdapter. As I said in the first post, this worked in version 1; the first time I opened the V1 .FHD file, a message came up and asked if I wanted to convert it for V2 which I answered yes to.
When I tried the SQL heater, I received a message that stated “There is already an open DataReader associated with this Command which must be closed first.”

Any suggestion would be greatly appreciated.
Thanks tim

Hi Tim

Ups! This is an error with the SQL-Server Adapter on READ in connection with the SQL Heater. Maybe this is also the reason why your Database Lookup doesn’t work.
I’ve fix it. You can download the Fix (Beta) here. In the ZIP archive there’s no setup, you have to start FlowHeater.exe by double-click!

With the next version this is official fixed!

Thanks for the notification.

HI, I loaded your beta version of flowheater 2 and the lookup works, but I am still having problems withe the sql heater.

I have added an sql statement that is "Select [Address1] from Communication_old where CommType = $comm$ and
CommLocation = $location$". I have attached a picture of the heater properties.
When I run this I get the error message "lookup error - Select [] from []" The read side is using the communication_old table as per the image.


I would appreciate any help as I don't think I can use the lookup heater to perform the function I need.

Hi Tim,

Are you sure that this error message occurs from the SQL Heater? This error occurs usually form the database Lookup Heater.

Verify that no database Lookup Heater is on your definition and try it again please. If the error message occurs again please post your FlowHeater definition (ZIP).

In case of you want to select some information from the same table on READ you have choose in the READ Adapter please try the following. Go to the Adapter properties on the READ side and enter for the property "AutoCommitAfter" the value -1.