1. Helge Tjelta
  2. Valentina Server
  3. Пятница, Сентябрь 06 2019, 08:19 AM
  4.  Подписаться через email
Hi, I have upgraded from 7.4.3 to 9.5.3... and now I run into a lot of Format errors...

Kernel error: 0x93505. Format error: "nb_NO Error: U_UNSUPPORTED_ERROR" .

I get this all the time...

A simple : FORMAT('1234.34', '###.#'). gives this error, why....

I have moved to a server in Amazon, (Stockholm).
Комментарий
There are no comments made yet.
Helge Tjelta Ответ принят
What do I have to look out for ?
Комментарий
There are no comments made yet.
François Van Lerberghe Ответ принят
Perhaps 9.5 is stricter and accept only number for the FORMAT function ?
Try

FORMAT(1234.34, '###.#')
Комментарий
There are no comments made yet.
Helge Tjelta Ответ принят
I tried this as well: SELECT FORMAT(123456.123456, '###.##')

still problem. Doing it on a older server works well though.
Комментарий
There are no comments made yet.
Helge Tjelta Ответ принят
Old mac server at 7.4.3 works nice.

Amazon, windows, server at 9.3.1 worked nice.

Amazon, windows, server at 9.5.3 DOES NOT.
Комментарий
There are no comments made yet.
Ivan Smahin Ответ принят
This is from ICU -
U_UNSUPPORTED_ERROR = 16, /**< Requested operation not supported in current context */

Checking it on Mac, vStudio, v.9.6 - no problems. And there is no visible changes in this area in 9.3, 9.5...
Комментарий
There are no comments made yet.
Helge Tjelta Ответ принят
I have checked with local server at 9.5.3, on mac. That works.

Same command on my windows server at amazon, gives error...

What do I have to look out for on my server? is the locale mismatched or something else,,, I have tried to use both English and Norwegian as language, but still the same error.

What could be wrong ?
Комментарий
There are no comments made yet.
Helge Tjelta Ответ принят
I uninstalled the 9.5.3. Delete everything. installed 9.3.2. Now the code format works.

uninstalled 9.3.2, deleted all. Installed 9.5.3 again, not it does not work. I get that same errer again.
Комментарий
There are no comments made yet.
Helge Tjelta Ответ принят
No I'm back on 9.3.2 again, and all works well...
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello Helge,

What is the version of Windows Server?
Комментарий
There are no comments made yet.
Helge Tjelta Ответ принят
The version is:

Windows Server 2019 Datacenter
1809
OS-versjon: 17763.292
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Thank you, we reproduced this issue, the problem is that icudt58.dll library used for formatting was broken during saving to the installer.
The next build will fix this issue.
Комментарий
There are no comments made yet.
Helge Tjelta Ответ принят
Thanks ! I'll look forward to it :)
Комментарий
There are no comments made yet.
Helge Tjelta Ответ принят
Hi Sergey, I have installed the 9.6.2 and still gets this error... has the installer broken this versions as well ?

please fix :)
Комментарий
There are no comments made yet.
Helge Tjelta Ответ принят
Now it says:
603397
Format error: "nb_NO Error: U_UNSUPPORTED_ERROR" .
Комментарий
There are no comments made yet.
Helge Tjelta Ответ принят
Doing the same sql that my app is sending to the server I get:

Kernel error: 0x93505. Format error: "nb_NO Error: U_UNSUPPORTED_ERROR" .

removing all format from that SQL all is fine...

So the FORMAT command is still making trouble.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hi Helge,

Yes, looks like it is broken again, not sure how.

A workaround is to put the correct library manually:
1. Stop VServer_x64 service
2. Download library
https://www.dropbox.com/s/id0dtygnpx8facu/icudt58.dll.zip?dl=0
3. Unzip to c:\Program Files\Paradigma Software\VServer x64\
4. Start VServer_x64 service
Комментарий
There are no comments made yet.
Helge Tjelta Ответ принят
Thanks Sergey, that worked!

Nice. Thank you.
Комментарий
There are no comments made yet.
Helge Tjelta Ответ принят
:D
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
A new 9.6.3 includes correct ICU library
Комментарий
There are no comments made yet.
  • Страница :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories