Solved

Xtract for DB Scan Credentials Problem

  • 12 March 2018
  • 8 replies
  • 1491 views

Trying to run Xtract for DBs 1.5 against a SQL 2014 FCI on Server 2012R2. Using domain credentials that have the sysadmin role applied. I'm getting "Unable to run SQL queries. Please refer our User Guide and make sure that the SQL Server user [domain\creds] has sufficient privileges. Unable to fetch Node Details" whenever I run the scan against the cluster.

I chose automatic elevation originally but I've deleted the project and tried again and never gotten that option again. I also created a SQL account and receive the same error. Anyone have any idea what's going on here?
icon

Best answer by jlaunier 13 March 2018, 21:14

@swf5002 I think this has been fixed in the latest set of hotfixes which can be applied by running an update command from the console of your xtract VM. Try the following steps:

  1. Connect to the Xtract console as the user "nutanix"
  2. type "sudo update-xtract"
  3. after the updates are finished, logout of the Xtact session, refresh the browser and relogin
  4. Re-attempt the DB scan.
View original

8 replies

Adding on, here are some sanitized extracts from the xplorer log that seem relevant:

code:
[xperience.xplorer.sc...s.mssql.mssql_server] [mssql_server] [481 ][2018-03-12 19:31:04,804] [INFO    ] Thrd[139672341272320]: E[369fa20b] S[72dfdf8d] I[b90014e8]: Executing query number [49] with user [%%%%%%%]. Is FCI clustered? [True]
[xperience.xplorer.sc...s.mssql.mssql_server] [mssql_server] [552 ][2018-03-12 19:31:04,813] [INFO ] Thrd[139672341272320]: E[369fa20b] S[72dfdf8d] I[b90014e8]: Ignoring the failure of query #49 for scanuser [%%%%%%%] as the user is sysadmin.
[xperience.xplorer.sc...s.mssql.mssql_server] [mssql_server] [800 ][2018-03-12 19:31:04,864] [INFO ] Thrd[139672341272320]: E[369fa20b] S[72dfdf8d] I[b90014e8]: Processing query results to desirable format
[xperience.xplorer.sc...s.mssql.mssql_server] [mssql_server] [967 ][2018-03-12 19:31:04,902] [ERROR ] Thrd[139672341272320]: E[369fa20b] S[72dfdf8d] I[b90014e8]: Unable to fetch the Node Details, [{u'node_status': 0, u'ip_address': None, u'is_current_owner': 0, u'node_name': u'SERVER2'}, {u'node_status': 0, u'ip_address': None, u'is_current_owner': 1, u'node_name': u'SERVER1'}]
[xperience.xplorer.sc...s.mssql.mssql_server] [mssql_server] [657 ][2018-03-12 19:31:04,902] [ERROR ] Thrd[139672341272320]: E[369fa20b] S[72dfdf8d] I[b90014e8]: Failed to process results as there is insufficient information
Traceback (most recent call last):
File "/usr/local/lib/python2.7/dist-packages/AMF_Xplorer-1.5.0-py2.7.egg/xperience/xplorer/scanner/apps/mssql/mssql_server.py", line 651, in update_results
self._process_results(warnings)
File "/usr/local/lib/python2.7/dist-packages/AMF_Xplorer-1.5.0-py2.7.egg/xperience/xplorer/scanner/apps/mssql/mssql_server.py", line 719, in _process_results
mssql_results.create_results(warnings)
File "/usr/local/lib/python2.7/dist-packages/AMF_Xplorer-1.5.0-py2.7.egg/xperience/xplorer/scanner/apps/mssql/mssql_server.py", line 968, in create_results
raise InsufficientUserPrivilege(required_cluster_keys[key], mssql_username=self.mssql_username)
InsufficientUserPrivilege: Unable to execute SQL queries. Please refer our User Guide and make sure that the SQL Server user %%%%%%% has sufficient privileges. Unable to fetch Node Details
[xperience.xplorer.sc...s.mssql.mssql_server] [mssql_server] [319 ][2018-03-12 19:31:04,904] [INFO ] Thrd[139672341272320]: E[369fa20b] S[72dfdf8d] I[b90014e8]: Closing connection to MSSQL Server
Userlevel 7
Badge +35
Thanks for sharing @swf5002 - I'll see if we can get some eyes on this
Thanks - I opened a support ticket so we'll see what route that takes too. I'll share the answer here.
Userlevel 7
Badge +35
Sounds good - thanks @swf5002 looking forward to the reply 👍
Userlevel 3
Badge +11
@swf5002 I think this has been fixed in the latest set of hotfixes which can be applied by running an update command from the console of your xtract VM. Try the following steps:

  1. Connect to the Xtract console as the user "nutanix"
  2. type "sudo update-xtract"
  3. after the updates are finished, logout of the Xtact session, refresh the browser and relogin
  4. Re-attempt the DB scan.
@jlaunier That is exactly what support had me do earlier today - I was just clearing out some more warnings before I reported back in case it didn't quite work out, but it got me past that error. Thanks for the help!
Badge
Hello all,

I've the same error message in my environment, even after executing "sudo update-xtract".
It seems it's not exactly the same issue, because in my logs I have the following error :
[xperience.xplorer.sc...s.mssql.mssql_server] [mssql_server] [575 ][2018-04-17 08:44:54,383] [ERROR ] Thrd[140256769394432]: E[19d7e0bf] S[ecafe7c1] I[eae1b57c]: Failed to execute query 21. Exception: (2714, "There is already an object named '#dbsize1' in the database.DB-Lib error message 2714, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")
Traceback (most recent call last):
File "/usr/local/lib/python2.7/dist-packages/AMF_Xplorer-1.5.0-py2.7.egg/xperience/xplorer/scanner/apps/mssql/mssql_server.py", line 497, in _execute_queries
self._execute_query(query, alternatives=alternate_queries)
File "/usr/local/lib/python2.7/dist-packages/AMF_Xplorer-1.5.0-py2.7.egg/xperience/xplorer/scanner/apps/mssql/mssql_server.py", line 444, in _execute_query
raise failures[-1]
OperationalError: (2714, "There is already an object named '#dbsize1' in the database.DB-Lib error message 2714, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")


Any idea ?
Userlevel 7
Badge +35
Thanks for sharing @TKE

@jlaunier any thoughts on the above?

Reply