Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Up to 100,000 records can be processed with the freeware version!
Flowheater Chart

Parameters read but not used on command line

More
8 years 8 months ago #2691 by Sylvain
Hello,
I am using FlowHeater 4.0.2
I am facing an issue with parameters, when using MySQL Adapter.
I have defined parameters to tell IP Addresses on command line : 'src_IPaddr' and 'dst_IPaddr'. For both parameters, I have also defined default values :
src_IPaddr = 127.0.0.1
dst_IPaddr = 1.2.3.4
Now let's say that destination IP address is NOT 127.0.0.1, but another machine - ex = 10.32.49.52

I run Batch Modul using following command line : FHBatch.exe /SetParameter src_IPAddr=127.0.0.1 /SetParameter dstIPAddr=10.32.49.52 myTransfer.fhd

I get confirmation that both parameters have been read :
Set Parameter [src_IPaddr], Value [127.0.0.1]
Set Parameter [dst_IPaddr], Value [10.32.49.52]

But I also get this error : "Can't connect to MySQL server on '1.2.3.4' (xxxx) ..."
This means that value given on command line is read, but is not used - instead, default value is always used for MySQL Servername or IP.
Other MySQL params are correctly read and used : Database/Catalog, Port, User, Password
32bits and 64 bits FlowHeater versions are facing this issue.

Any idea ?
Thanks for your help.

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

More
8 years 8 months ago #2692 by FlowHeater-Team
Replied by FlowHeater-Team on topic Parameters read but not used on command line - Post(2692)
Hi Sylvain

I’ve made a short test with MySQL and in my opinion this feature works like expected :-)

I suppose you’ve just made a typing mistake with the Parameter names. In your second FHBatch /SetParameter option I miss the underline character like this “dst_IPAddr”

Note: With one of the next version I’ll raise a warning in case of the Parameter name dosn't exit in the Definition.

Best wishes
Robert Stark

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

More
8 years 8 months ago #2694 by Sylvain
Hi Robert,
You suppose well ! It's my mistake : even though I've double checked, underscore character was missing...
I do apologize for this wrong request !
Your suggestion would be nice : a warning could have told me my mistake.

Thanks for your quick reply ;-)

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

Time to create page: 0.265 seconds
FlowHeater Logo

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Legal information

Support & Contact

Contact

Phone:
0951 / 9933 9792

eMail:
This email address is being protected from spambots. You need JavaScript enabled to view it.


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