1. Helge Tjelta
  2. Valentina Server
  3. 金, 9月 06 2019, 08:19 AM
  4.  メールで購読
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.