SilkTest Workbench: Unexpected Error - The cursor does not include the table...(IN PROGRESS)

SilkTest Workbench: Unexpected Error - The cursor does not include the table...(IN PROGRESS)

Problem:

The following error message has been reported by a number of users running SilkTest Workbench 13.5 with SQL Server 2005 Database. The error tends to occur when launching or closing the Silk Test Workbench, or some individual Test Assets. 

Resolution:

Internal investigation has confirmed that the error can occur if a SQL Server installation was relocated to a different Server, or if the Server name has been modified after deployment. The following SQL queries can be executed to confirm if this is the root cause; the output should be identical in all cases:


select @@servername
The servername should be not NULL
     
select * from sysservers
The “srvname” field must correspond to your server name
     
exec sp_helpserver
The "name" field must correspond to your server name



If the first SQL query returns "null" or if the output for all 3 queries is not identical; then the following Stored Procedures will need to be executed to resolve the problem, per the advice in the following article:

https://support.actividentity.com/LiveTime/WebObjects/LiveTime.woa/wa/ArticleView?kbaId=1622

exec sp_helpserver:    To get the current name of the SQL Server

exec sp_dropserver '<servername>':   To drop the old SQL Servername

exec sp_addserver '<servername>', local:  To add the new name as the local server

exec sp_serveroption '<servername>', 'Data Access', 'True':  Configures server for Data Access

Please note that you must stop and then restart the SQL Server server for the changes to take effect. After restarting the Service; please run "select @@servername" to verify that the changes have been applied. This should return the name of your local server with a server id of 0.


DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2013-04-17 06:32
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.