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.
Flowheater Chart

Parameters read but not used on command line

More
8 years 6 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 6 months ago #2692 by FlowHeater-Team
Replied by FlowHeater-Team on topic Parameters read but not used on command line
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

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.

More
8 years 6 months ago #2694 by Sylvain
Replied by Sylvain on topic Parameters read but not used on command line
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.260 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-2024 by FlowHeater GmbH. All rights reserved.