Skip to main content
5-Regular Member
July 25, 2017
Solved

CreateDashboard fails in Thingworx 7.2 (PostgreSQL)

  • July 25, 2017
  • 4 replies
  • 6162 views

We have integrated PostgreSQL (version 9.4/9.5)  with Thingworx7.2 . We are getting below error when calling CreateDashboard

Resources["DashboardFunctions"].CreateDashboard(params);


NOTE: Please note that this works fine with Thingworx 7.2 WITHOUT PostgreSQL

Error =>

: Wrapped java.lang.Exception: Import Failed: Not authorized for Create Cause: Import Failed: Not authorized for

Best answer by ThomasMathew

there were permissions defined in data table.
The data table was not imported correctly.

After importing the issue is resolved.

4 replies

20-Turquoise
July 25, 2017

Are you logged in as  Administrator?

5-Regular Member
July 25, 2017

Hi Thomas, could you please clarify what you meant with integrated PostgreSQL version 9.4 & 9.5? Which version is used as the persistence provider for ThingWorx 7.2?

What sort of user did you use to create the dashboard?

5-Regular Member
July 25, 2017

We are using  PostgresSQL 9.5 as thingsworx storage.

We are using  ThingworxPersistenceProvider (Persistence provider package :).

CreateDashboard is being executed by user .

Please note that it works fine with Thingworx 7.2 with Neo4j as ThingworxPersistenceProvider .

20-Turquoise
July 25, 2017

PostgreSQL 9.5 is currently not supported. Please install the latest minor version of 9.4 (9.4.12)

5-Regular Member
July 27, 2017

Thanks a lot for the help. We got the resolution.

20-Turquoise
July 27, 2017

Could you please mark the answers as correct or helpful if any of them were? This will help improve searching for our community in the future.

Thank you!

ThomasMathew5-Regular MemberAuthorAnswer
5-Regular Member
July 28, 2017

there were permissions defined in data table.
The data table was not imported correctly.

After importing the issue is resolved.