Skip to main content
domderose1-Visitor
1-Visitor
Oct 10, 2018 1:46 PM UTC
Question

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

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

posipova20-Turquoise
20-Turquoise
Oct 11, 2018 6:23 PM UTC

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"?

Translate
domderose1-VisitorAuthor
1-Visitor
Oct 11, 2018 6:28 PM UTC

Hello posipova, 

 

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

Translate
posipova20-Turquoise
20-Turquoise
Oct 11, 2018 6:30 PM UTC

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
Translate
DCraig1-Visitor
1-Visitor
Dec 6, 2018 5:43 PM UTC

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.

Translate
Terms & ConditionsAccessibility statement