Skip to main content
D
domderose1-Visitor
1-Visitor
October 10, 2018
Question

ThingWorx 8 Part 2 Error: Unable to Invoke Service GetAllRecords on ACMESQLDatabase : null

  • October 10, 2018
  • 8 replies
  • 5916 views

Summary of Issue:

While taking the Training Course: ThingWorx 8 Part 2: Connecting to External Data, I'm at the section: "SQL Queries and SQL Commands">"Verifying the Database Connection".

 

When attempting to test the service, I receive the following error: 

"Error Executing Service, Unable to Invoke Service GetAllRecords on ACMESQLDatabase : null"

Checking the Application logs reveals about the same information. 

 

Question:

I've double and triple checked a lot of details but can't determine my error. 

Has anyone come across this?

 

Additional Details:

The ACMESQLDatabase thing has the following properties/configuration:

JDBC Driver Class Name = com.mysql.jdbc.Driver

JDBC Connection String = jdbc:mysql://127.0.0.1:3306/thingworxtrainingsample?allowMultiQueries=true

connectionValidationString = SELECT NOW()

Maximum Number of Connections = 5

Database UserName and Pass = root

 

8 replies

P
posipova20-Turquoise
20-Turquoise
October 11, 2018

When you go to the service creation screen, click on the tab "tables/columns" - does it actually load the data from the db or does it say "not found"?

D
domderose1-VisitorAuthor
1-Visitor
October 11, 2018

Hello posipova, 

 

It says "No tables found" and has an infinite "Loading..." nearby.

P
posipova20-Turquoise
20-Turquoise
October 11, 2018

That means your db is not connected.

 Try this

Connection Test/String Query
SELECT GetDate()
JDBC Connection URL
jdbc:sqlserver://<Server>\<Instance>;databaseName=<Database name>
JDBC Driver Class Name
com.microsoft.sqlserver.jdbc.SQLServerDriver
D
DCraig1-Visitor
1-Visitor
December 6, 2018

I had this same problem.  I think the issue is caused by the .zip file being blocked by Windows when it is downloaded.  Before you unzip the package, right click the archive, select "Properties" and then click "Unblock" in the lower right.  You can then unzip the archive.  If you have already imported the extensions you will need to delete anything from your project that uses/references the extension objects, then you can delete them from the Manage Extensions page and import them again.

Terms & ConditionsAccessibility statement