Subscribe

WFA to DFM server Connection error

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

Frequent Contributor

Re: WFA to DFM server Connection error

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

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

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
Frequent Contributor

Re: WFA to DFM server Connection error

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

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.

Frequent Contributor

Re: WFA to DFM server Connection error

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

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

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

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