MS SQL - can't see my DB in device tree on the left

alexo

Hello,

running 1.8.5.

Added a new MS SQL, and I see that fetch jobs are completing successfully in the SQL Server Jobs.

But my SQL DB is not appearing.

I've decided to rename it and now I see it two times in Health Status but not yet in the tree:

Also I have these in the /home/xormon/xormon-ng/server-nest/logs/sqlserver-error.log :

2025-03-27 13:10:01: [saveArchitecture] [XXXXXXS2016] Error: {"statusCode":400,"message":["[ItemRelations] Key (parent)=(1b581f7cd6dc2414b9bcf5c6fc77fe56) is not present in table \"object_items\"."],"error":"error occurred while saving architecture data"}

2025-03-27 13:10:01: DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/xormon/xormon-ng/server-nest/microservices/sqlserver/sqlserver-service.pl line 428.

2025-03-27 13:10:01: DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/xormon/xormon-ng/server-nest/microservices/sqlserver/sqlserver-service.pl line 428.

2025-03-27 13:10:01: DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/xormon/xormon-ng/server-nest/microservices/sqlserver/sqlserver-service.pl line 428.

2025-03-27 13:10:01: DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/xormon/xormon-ng/server-nest/microservices/sqlserver/sqlserver-service.pl line 428.

2025-03-27 13:10:01: DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/xormon/xormon-ng/server-nest/microservices/sqlserver/sqlserver-service.pl line 428.

2025-03-27 13:10:01: DBD::ODBC::st fetchrow_hashref warning: no select statement currently executing at /home/xormon/xormon-ng/server-nest/microservices/sqlserver/sqlserver-service.pl line 428.

Can you please advise how to sort this?

Thanks

damerva

Hello Alexo,

send us logs

UI --> settings --> Logs --> support logs: follow the form

Send us generated file via https://upload.xormon.com

Note a reference pls.

alexo

Logs were submitted.

Can you please also explain about instances and dbnames.

Shall I put instance name if it is the default one(single instance)?

And what about DB name and DB whitelist, not sure how to use them?

Thank you

damerva

DB name and Instance are meant to be the same. To make it more clear we will change "DB name" and LDB" in forms to Instance

Shall I put instance name if it is the default one(single instance)?

Yes just put in the Instance you want the application to connect through

For a single instance SQLServer cluster you can use the same name as Alias and DB name in the form

And what about DB name and DB whitelist, not sure how to use them?

If you have many Instances in your SQLServer cluster. You can specify which of them you want monitored => see in the menu