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

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

DL_12699107 — Thu, 16 Jan 2025 04:16:44 GMT

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.

Re: QueryPropertyHistory throws DataAccessException: [2,006] when start date and end date not spe...

TonyZhang — Thu, 16 Jan 2025 07:03:28 GMT

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,