topic Re: WFA to DFM server Connection error in Active IQ Unified Manager Discussions

WFA to DFM server Connection error

sheelnidhig — Thu, 05 Jun 2025 05:32:44 GMT

Hello All,

I tried to add a new DFM server in to WFA's Data source.

When trying to Acquire data from the DFM server i see the following error

"JZ006: Caught IOException: java.net.ConnectException: Connection timed out: connect"

The DFM server is running with version 5.2.

WFA is 2.2.0.2.4RC1.

Anyone have seen this or knows the root cause and how to fix it?

,Sheel

Re: WFA to DFM server Connection error

ag — Thu, 10 Jul 2014 07:21:19 GMT

1. Can you check if the DFM machine is pingable from WFA host?

2. Check if the DFM sql service has stopped using the following command.

$dfm service list

Re: WFA to DFM server Connection error

kirana — Thu, 10 Jul 2014 07:27:55 GMT

This error as i observed appears when selecting incorrect datasource DB type. Check if datasource type you have selected when adding datasource is correct. Should be:

5.2.x 7-mode(Sybase) for managing 7-mode controllers.
5.2.x cDOT(Sybase) for managing cDOT clusters.

Re: WFA to DFM server Connection error

sheelnidhig — Thu, 10 Jul 2014 07:38:05 GMT

The DFM services are up and running we also tried to bounce the dfm services.

because of the security reasons ping is not allowed in this case, but i can still do an RDP and able to open the DFM web console from the server where we have WFA installed.

I have also checked and made sure that i have selected the correct "OnCommnad Unified Manager - 5.2 7 Mode(Sybase)" and the DFM server version is:

Version	5.2.0.17140 (5.2R1)
Executable Type	64-bit
Edition	Standard edition of DataFabric Manager server
Data ONTAP Operating Mode	7-Mode

Re: WFA to DFM server Connection error

ag — Thu, 10 Jul 2014 08:11:32 GMT

Is it a persistent issue or has it happened only once?

Is the DFM or WFA a fresh install?

Re: WFA to DFM server Connection error

sheelnidhig — Thu, 10 Jul 2014 12:08:00 GMT

The WFA is able to acquire the data from other DFM servers in LAB. but not able to get from production DFM server.

If i remember correctly it was able to get the data from Prod DFM till yesterday and after words its not working.

I also tried to add this dfm on other WFA server but no luck.

Re: WFA to DFM server Connection error

ag — Thu, 10 Jul 2014 15:57:21 GMT

Well, it has to be something to do with the DFM server. Can you investigate what changed in the past 24hours?

Was there a new firewall rule added or something that could block access to DFM's sql service?

Re: WFA to DFM server Connection error

sheelnidhig — Thu, 17 Jul 2014 08:37:09 GMT

I tried to install WFA on a new Windows server which is in the same network zone but now i am getting another error:

"Data truncation: Out of range value for column 'id' at row 1"

Any suggestions !

Re: WFA to DFM server Connection error

adaikkap — Thu, 17 Jul 2014 09:05:24 GMT

Sheel,

Can you open a case and upload your WFA autosupport along with a backup of DFM database.

In case the dfm db is huge due to performance data, pls use the cli below to get db only backup from dfm.

The cli to take dfm database only backup excluding PA data is the following.

dfm backup create –B

Backup taken using the above cli should be restored using the below cli only, else restore will fail.

dfm backup restore –R

Regards

adai

PS: The above dfm clis works only on UM 5.2 and later.

Re: WFA to DFM server Connection error

sheelnidhig — Fri, 18 Jul 2014 13:38:28 GMT

Hello Adai,

I did managed to perform an upgrade of WFA to the latest GA release 2.2.0.2.6-2416155 and it worked.

Not if there is some issued with the earlier version (2.2.0.2.4)

,Sheel

Re: WFA to DFM server Connection error

FrankS — Tue, 20 Jan 2015 12:16:44 GMT

Just encountered the same error in a playground (all 7m und cDOT filers are simulators), OCUM and WFA was at different w2k8 OS installations.

Reason here was the active firewall at the OCUM host. Deactivating the firewall solves the issue, but: if was working before and firewall wasnt touched at all...? Strange...