Unable to do MSSQL query after upgrade to 4.2 SP1

Forum|Forum|12 years ago
February 25, 2014
5 replies
2055 views

I just upgraded from 4.1 to 4.2 SP1. My SQL query service is failing. I did not change anything on the MSSQL server side.

In the service creating, I am able to see all my database tables and columns. This tells me the connection is ok. but when I run the test on the service, I am getting:

Unable to Invoke Service QuerySummary on MSSQLServices : Could not execute service [QuerySummary] after making (2) attempts

A

abalousek

11-Garnet

Can you detail your upgrade process steps that you took, i.e. did you go through the full export, undeploy, delete dB, redeploy, import process we typically recommend? If so, did you re-import all of the extension packages (including the MSSQL Extension) prior to importing?

L

luwenya

Author

1-Visitor

I did not need to save anything I had for 4.1 so here are the steps I did:

1. stopped the ThingWorx from the apache, and undeploy the old the version.

2. stop the apache service and remove the c:\ThingworxStorage and c:\ThingworxBackupStorage folders.

3. uninstall the apache older version and reinstalled the apache version 7.0.52.

4. deployed the thingworx 4.2 SP1

5. login thingworx composer and imported mssql extension. I get the mssql extension from here: [https://dl.dropboxusercontent.com/u/73383/MSSQL_ExtensionPackage.zip | https://dl.dropboxusercontent.com/u/73383/MSSQL_ExtensionPackage.zip]

6. created a thing with mssqlserver thing template and configured the connection.

7. created a sql query service and I was able to see all the database tables and column. the sql query is "select * from <tablename>"

8. did a test run and failed.