Incorrect values in Created On field after the record was imported into BPM
Hi all!
I faced an issue in the process of configuring an instance. I tried to import the records from website database to BPM instance database, and the overall process was successful. But after the data had been imported, I noticed, that despite the fact that the time zones on our website and in BPM instance are the same (CST, UTC -06:00), values in the field ‘CreatedOn’ of my imported records are running behind 2 hours.
I'm making a POST request to the URL xxxxx.bpmonline.com. In the request body there is a JSON which among other things includes the field CreatedOn with a string type "2016-09-15T11:30:11.4412941". This date is in UTC time zone and definitely is correct and valid. But later, in the BPM’online interface I see that it trails the real value by 2 hours, and it doesn’t depend on the time zone I'm setting in the BPM instance. BPM version sales commerce 7.9.1
Did anyone here face the same issue? How can it be solved?
Thanks!
Like
Dear Tatyana,
We are not aware of such an issue in 7.9.1, so, I believe, it should be investigated directly. Please send a request to support@bpmonline.com along with full description.
Thank you!
Dear Adam,
I already did so, but the Support Team told me that consultation on development is not available under my SLA, so they recommended me to ask this question here.
Thanks.
It's hard to believe that it doesn’t depend on the time zone. Try to log out and log in again after you change the timezone. The time will be different. Try to restart the application if it doesn't help.
Check the value in the database. The system stores all of the datetime values in UTC in the DB and converts it according to the clients time zone any time you open a page.
Try to check the Default TimeZone system setting value. Check who is in the CreatedBy field and check his timezone. You'll see the delta if your timezones are different.