Hi Dojo,
I am currently using the Factory Reset Tool (SLReset.exe) to clean a DMA that is configured with two remote Elastic nodes. The DB.xml file looks as follows:
<DataBase active="true" search="true" type="Elasticsearch">
<DBServer>10.11.12.13,10.11.12.14</DBServer>
<UID></UID>
<PWD>myPassword</PWD>
</DataBase>
I execute the tool as follows:
SLReset.exe -u administrator -p myOtherPassword -y
Checking the output generated, I see the following error:
Cleaning db of type Elastic hosted on 10.11.12.13,10.11.12.14
Executing: C:\Skyline DataMiner\Files\x64\SLDataGateway.Tools.Database.exe
INFO |Tools.Database|FactoryResetOptions:
Ip: 10.11.12.13,10.11.12.14
Type: Elastic
User:
Timeout: 00:05:00
LogLevel: 1
INFO |Tools.Database.FactoryReset|Overview of databases to be cleaned:
Elastic - 10.11.12.13,10.11.12.14
ERROR|Tools.Database.Elastic.Cleaner|Invalid URI: The hostname could not be parsed.
ERROR|Tools.Database.FactoryReset|Execution for Elastic - 10.11.12.13,10.11.12.14 failed: System.NullReferenceException: Object reference not set to an instance of an object.
at SLDataGateway.Tools.Database.DatabaseCleanUtil.ElasticCleaner.<CleanAsync>d__16.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
INFO |Tools.Database.FactoryReset|Finished cleaning databases.
Finished action: Calling the DB Reset tool to reset the database.
Please could you confirm if the factory reset tool supports cleaning remote Elastic nodes?
If it is supported, should I use SLDataGateway.Tools.Database.exe instead of SLReset.exe?
Hello,
About this tool, we are currently disabling any Elastic reset that it does by default. Since it's a clustered database, it has too many edge cases and possibilities where an unexpected outcome would occur. We feel that including this in the tool may lead to unrecoverable situations for a cluster.
I think initially, it was designed to delete all indices from a cluster (remote or local).
Kind regards,
Hello Miguel,
Once this change is pushed, we will change documentation accordingly 🙂
Hi Thomas,
Thanks for the information. Please, if possible, could you update the Dojo page with this information?