Skip to main content
D
DL_126991071-Visitor
1-Visitor
January 16, 2025
Question

QueryPropertyHistory throws DataAccessException: [2,006] when start date and end date not specified

  • January 16, 2025
  • 1 reply
  • 401 views
I am using ThingWorx Platform Release 9.3.

QueryPropertyHistory does not work when start date and end date not specified, throws DataAccessException: [2,006] Unknown error occurred.

Here are the errors that I faced
Unable to Invoke Service QueryPropertyHistory on TE2-SEAL_PUMP1-M1 : com.thingworx.common.exceptions.DataAccessException: [2,006] Unknown error occurred. Contact the administrator if this re-occurs.

1 reply

T
TonyZhang16-Pearl
16-Pearl
January 16, 2025

Hi @DL_12699107,

 

Please refer to this similar community post.

Could you please review and share the value stream configuration for entity TE2-SEAL_PUMP1-M1? (is it RemoteValueStream or ValueStream? What persistent provider is configured?)

And please check database.log and Error.log from ThingworxStorage/logs and the logs directly on the database server.

Also, can you please confirm whether QueryPropertyHistory can always be executed successfully if you specify a start date and/or end date?

 

Thanks,

Terms & ConditionsCookie settingsAccessibility statement