Toggle Submenu
  1. Forums
  2. Recent
  3. カテゴリ
  4. タグ
  5. ユーザ
返信を追加 返信を表示 (19)

解決済み Format error (0x93505) SQL format command error

  1. Helge Tjelta
    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.
返信 (19)
Helge Tjelta
Helge Tjelta 承諾済みの回答
What do I have to look out for ?
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
François Van Lerberghe
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.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
Helge Tjelta
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.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
Helge Tjelta
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.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
Ivan Smahin
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.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
Helge Tjelta
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.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
Helge Tjelta
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.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
Helge Tjelta
Helge Tjelta 承諾済みの回答
No I'm back on 9.3.2 again, and all works well...
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
Sergey Pashkov
Sergey Pashkov 承諾済みの回答
Hello Helge,

What is the version of Windows Server?
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
Helge Tjelta
Helge Tjelta 承諾済みの回答
The version is:

Windows Server 2019 Datacenter
1809
OS-versjon: 17763.292
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
Sergey Pashkov
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.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
Helge Tjelta
Helge Tjelta 承諾済みの回答
Thanks ! I'll look forward to it :)
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
Helge Tjelta
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.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
Helge Tjelta
Helge Tjelta 承諾済みの回答
Now it says:
603397
Format error: "nb_NO Error: U_UNSUPPORTED_ERROR" .
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
Helge Tjelta
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.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
Sergey Pashkov
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.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
Helge Tjelta
Helge Tjelta 承諾済みの回答
Thanks Sergey, that worked!

Nice. Thank you.
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
Helge Tjelta
Helge Tjelta 承諾済みの回答
:D
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
Sergey Pashkov
Sergey Pashkov 承諾済みの回答
A new 9.6.3 includes correct ICU library
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Server
  3. この返信へのパーマリンク
  • ページ :
  • 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