15-Moonstone

Solved

Postgres Persistence provider [Data store unknown error]

Forum|Forum|4 years ago
August 24, 2021
1 reply
6191 views

I tried to create Postgres persistent provider to store stream and value stream data.

I am able to connect DB( checked using isConnected service) but not able to store and retrieve data, when I use the default service of add stream-entry I am not getting any errors. but I tried to access row count by calling GetStreamEntryCount then I got the error below-mentioned error message.

I am getting errors like this :

Unable to Invoke Service GetStreamEntryCount on Demo.Manual.STREAM : com.thingworx.common.exceptions.DataAccessException: [1,018] Data store unknown error: [Error occurred while accessing the data provider.]

Best answer by Jimwang

@sabharees ,

You can refer to the article CS262935 (https://www.ptc.com/en/support/article/CS262935) to setup 2nd persistence provider.

The key steps are:

1> Create a DB User and grant the permission

2> Create a new Database

3> Grant enough permission for the new User to access to the database

4> Create Thingworx DB schema

5> In Thingworx Composer, Create a 2nd Persistence Provider and Configure the connection

B

bchaudhary_448008

5-Regular Member

Hi @sabharees ,

This issue seems similar resolved in the given article.

Kindly check and revert back the results Similar case .

Regards

Bhawna

S

sabharees

Author

15-Moonstone

Hi @bchaudhary_448008 ,

Thanks for the link. But still, I am not able to resolve these issues.

Also in my application log, I found this error log: Transaction has been marked as a failure for request /Thingworx/Things/Test.PP.Stream/Services/QueryStreamEntriesWithData.

Regards,

Sab.

B

bchaudhary_448008

5-Regular Member

Hi @sabharees ,

Can you please attach the application logs?

Regards

Bhawna

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded