Have you ever wanted to check out Visier’s powerful suite of connectors? Or the calculated metrics derived from the people data model? Now you can! Sign up here for your own account!
1 Like
Hi Ike & team… I’ve completed most of the trial exercises and am now trying to add a new Analytical Object (with a sample file/source, mappings, etc.), but I’m facing an error everytime I attempt to “Run Job”. Here’s the error:
[DES0021001] rci=DES0021001 Start date: 1674259200000 [2023-01-21 00:00:00.000] cannot be later than end date: 1674259199999 [2023-01-20 23:59:59.999] on PEX_Case_Stream with granularity: D.Possibly a problem in data, or incorrectly configured date info for table (eg temporal vs transactional) [DP510002] Error occurred in the load data stage of the processing job. Please contact Visier Support for more information.
Any ideas?
1 Like
Hey Neil! Thank you for letting us know. I’ve pinged our teams internally and we’ll get a response back shortly!
Hey Neil, could you confirm that your mapping is set to “Temporal”? Could you try to map with the setting as “Transactional” instead and post the result?
Oh! That worked… but I also applied a record filter to make sure I wasn’t adding data later than 2024-03-01.
date(column("Snapshot Date"), dateFormat("yyyy-MM-dd HH:mm:ss")) < date("2024-03-01", dateFormat("yyyy-MM-dd"))