+12We are currently testing 15.4, and have an issue in the Web EMployee Portal. Every time we log on, we get the following error (3 times). The message pops up every 10 minutes (I assume from refreshing ). If I log on with the Employee Portal Browser (as Customizer), no errors are flagged:
On the server we get this in the log:
Here’s the query that fails. I think I may have found the issue. But how to fix this?
Best answer by Phil Seifert
Hi Bjørn,
Please change the regional settings for the time and date formats on the SERVER hosting the Alliance application so that they use / separators for the date and : separators for the time. MS states the Norwegian uses the full stop (period) as separators.
Make sure you keep your Chrome language setting to Norwegian so the users see the format they normally would expect.
So what should happen is the server communicate and sets up the transactions using the new separators and the users see their format as expected and no more errors, hopefully.
+24Hi Bjørn,
Do the involved users have widgets defined on their home screen which came from v15.2? If so, please remove them. I suspect this is the problem as it appears trying to do queries for for a start_work_counter.
+12I have removed all widgets from my user. And disabled being a customizer (just to test). Still the same (using Incognito mode).
We also find the same issue doing Contract Billing Batch
If we run the queries in SQL Studio we get the samme errors - so I have a feeling it is a date format error
The time format is not correct. It’s supposed to be ‘00:00:00’.
Will check with R&D what may have caused the incorrect time conversion.
+24Hi Bjørn,
Please change the regional settings for the time and date formats on the SERVER hosting the Alliance application so that they use / separators for the date and : separators for the time. MS states the Norwegian uses the full stop (period) as separators.
Make sure you keep your Chrome language setting to Norwegian so the users see the format they normally would expect.
So what should happen is the server communicate and sets up the transactions using the new separators and the users see their format as expected and no more errors, hopefully.
+24Happy to see this worked out for you and now you can continue your testing of Alliance v15.4.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
