Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X
I have TWX 8.5 with MS SQL server as persistent (model and data) provider. Created a VS with MSSQL persistentprovider. Created a thing with 2 integer properties with logged option, data change type as Always.
I tried to add property values, but the message in log is seen as below:
######################################################
2019-11-02 17:24:48.658+0530 [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: SuperUser] [S: ] [P: ] [T: pool-3-thread-1] Unable to write entry in stream [VS] from source [TestVSThing] at 2019-11-02T17:24:20.236+05:30 [com.thingworx.common.exceptions.DataAccessException: [2,006] Unknown error occurred. Contact the administrator if this re-occurs.]
#########################################################
Please let me know if I missed any configuration for VS with MS SQL as persistent provider
Solved! Go to Solution.
Please find below link
Check whether NHK_MSSQL_PP is configured correctly or not?
Hi @nhksrd ,
Try to create value stream using following settings.
Thing Template : ValueStream
Persistence Provider : ThingworxPersistenceProvider
and attached value stream to TestVSThing.
Execute QueryPropertyHistory service in Thing.
Thanks for response.
The Value stream works with ThingworxPersistenceProvider. But if we create a new Persistence provider NHK_MSSQL_PP with MssqlPersistenceProviderPackage, the issue is observed.
Does VS work with only default ThingworxPersistenceProvider.
Please find below link
Check whether NHK_MSSQL_PP is configured correctly or not?
I see difference in system ThingworxPersistenceProvider and custom provider in JDBC URL string. Corrected the same and it works for custom "NHK_MSSQL_PP" Persistence provider.
Thanks,
Hari