Tables issues

[cristianradu]

I had run the following command: 

DBCheck -d '/usr/local/ess/data/ngcp.dfl' -c

and got this output:

NitroEDB checking "/usr/local/ess/data/ngcp.dfl"
Table "ADGroupSM" Not Ok: File/Table in use by another process (135)
Table "ADGroup" Not Ok: File/Table in use by another process (135)
Table "AggException" Not Ok: File/Table in use by another process (135)
Table "ArchiverSearchJobs" Not Ok: File/Table in use by another process (135)
Table "ArchiverSearchHistory" Not Ok: File/Table in use by another process (135)
Table "AssetGroup" Not Ok: File/Table in use by another process (135)
Table "AssetGroupXRef" Not Ok: File/Table in use by another process (135)
Table "AssetSoftware" Not Ok: File/Table in use by another process (135)
Table "AssetSoftwareDetails" Not Ok: File/Table in use by another process (135)
Table "AssetThreat" Not Ok: File/Table in use by another process (135)
Table "AutoCreateRule" Not Ok: File/Table in use by another process (135)
Table "AutoCreateRuleCriteria" Not Ok: File/Table in use by another process (135)
Table "Access" Not Ok: File/Table in use by another process (135)

and there are multiple tables that are not ok. What can I do to solve this problem?

Thanks,

Cristian

[akerr · Accepted solution]

You need to stop cpservice and dbserver before doing a DBCheck.

You can do this by running NitroStop

And after, NitroStart.