Support Article
Business Intelligence Exchange does not work for History records
SA-68539
Summary
Error occurs when Business Intelligence Exchange Extract rule runs for History records.
Error Messages
error String was not a date "11/02/2018 02:51 PM".
Steps to Reproduce
- Create a Business Intelligence Exchange Extract rule with a filter where .pxTimeCreated is greater than 11/02/2018 02:51 PM
- Run the extract
Root Cause
A software use or operation error. The format of the value of the datetime property specified in the extract filter is not valid.
Resolution
Perform the following local-change:
Configure the filter to use the below format:
From:
11/02/2018 02:51 PM
To:
20181102T145100.000
Published December 29, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.