i have mistakenly deleted the ms sqlserver from the Nolio Server 4.7. Now i am not able to access the Nolio Automation Studio. How can i proceed further.

[Anon Anon]

i have deleted the ms sqlserver db from the Nolio Server 4.7. This is a standalone installation. I have not taken a backup. Now i am unable to access the Nolio Automation Studio. How can i proceed further. What are the various options available to me.

[Keith Puzey]

Hi,

 

    You can rerun the installer and see if an upgrade will recreate the DB but i think this will fail. Or you could recreate the DB in MS SQL and then modify the wrapperContext.xml config folder in the datamanager/WEB-INF folder on the NAC and change the value    <prop key="hibernate.hbm2ddl.auto">update</prop> from update to create and restart the NAC this should force the creation of the DB tables. Once the NAC is working change the setting back to update.

 

   Finally as the data is all lost the other solution is to uninstall the NAC and then rerun the installer.

 

Regards

Keith

[Anon Anon]

Hi Keith,

 

Thank you for the reply. Will the nolio schema be created by changing the config file content from update to create?

 

Thanks,

Prasanth.

[Keith Puzey]

Hi,

 

    Yes this should recreate the schema, please bear in mind that all of your application and configuration data is stored in the database so all of this data is lost without a backup. so you may find the best approach to be uninstall the NAC and install the NAC using the installer.

 

Regards

Keith

[James Panetti]

By any chance, do you have a backup you can restore from?

[Anon Anon]

Hi Keith,

 

i have re-installed the Nolio Server on the machine with mySQL as the DB. Now the Nolio is working fine.

 

 

Thank you,

Regards,

Prasanth Sinha.