Cleardown for go live

[derekgreen]

We are about to go live with our Hornbill instance so I have downloaded the zip file containing the relevant conf.json to perform a clear down of all of our test calls. I'm having issue with running the conf command, the configuration and error message are attached - I've taken out our username and password for obvious reasons! Hope someone can advise.

Thanks.

conf.json

[Conor]

Hi Derek

You need to specify that you want to clear the requests from your instance within the conf file, so the string in the conf file needs to read:

"CleanRequests": true,

At the moment yours reads:

"CleanRequests": false,

Give it a try and let us know if you are still having problems

[derekgreen]

Hi Conor,

Thanks for the advice, still not working. I'm pretty sure it will be something I'm doing wrong, I've attached a screen shot of the error message. I've tried both the w32 and w64 versions of the cleaner, same result.

Thanks.

[Conor]

Hi Derek

This could be because a particular setting needs to be enabled. Can you check if the setting security.database.allowSqlQueryOperation in the advanced system settings is set to true, and if it is not then please change it to true (ON), and try the clear down script again.

• SQL Query was unsuccessful - this occurs when the utility is prevented from running the query to obtain the list of requests to delete. This happens when the system setting security.database.allowSqlQueryOperation is set to false (OFF). To successfully run the utility, this setting must be set to true (ON). It can be found in Hornbill Administration > System > Settings > Advanced, and filter on "security".

Give this a try and it us know how you get on

Thanks

Conor

[derekgreen]

Hi Conor ,

                Took your advice re the setting for SQL queries, set it to ON and the clear down worked! Thanks for your prompt response. Reset the counters to zero and have just dealt with our first incident.