Toggle Submenu
  1. Forums
  2. Recent
  3. Kategorien
  4. Tags
  5. Benutzer
Antwort hinzufügen Antworten ansehen (19)

Gelöst Format error (0x93505) SQL format command error

  1. Helge Tjelta
    Helge Tjelta
  2. Valentina Server
  3. Freitag, September 06 2019, 08:19 AM
  4.  Abonnieren via E-Mail
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).
Kommentar
There are no comments made yet.
Antworten (19)
Helge Tjelta
Helge Tjelta Akzeptierte Antwort
What do I have to look out for ?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
François Van Lerberghe
François Van Lerberghe Akzeptierte Antwort
Perhaps 9.5 is stricter and accept only number for the FORMAT function ?
Try 


FORMAT(1234.34, '###.#')
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
Helge Tjelta
Helge Tjelta Akzeptierte Antwort
I tried this as well: SELECT FORMAT(123456.123456, '###.##')

still problem. Doing it on a older server works well though.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
Helge Tjelta
Helge Tjelta Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
Ivan Smahin
Ivan Smahin Akzeptierte Antwort
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...
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
Helge Tjelta
Helge Tjelta Akzeptierte Antwort
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 ?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
Helge Tjelta
Helge Tjelta Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
Helge Tjelta
Helge Tjelta Akzeptierte Antwort
No I'm back on 9.3.2 again, and all works well...
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
Hello Helge,

What is the version of Windows Server?
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
Helge Tjelta
Helge Tjelta Akzeptierte Antwort
The version is:

Windows Server 2019 Datacenter
1809
OS-versjon: 17763.292
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
Helge Tjelta
Helge Tjelta Akzeptierte Antwort
Thanks ! I'll look forward to it :)
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
Helge Tjelta
Helge Tjelta Akzeptierte Antwort
Hi Sergey, I have installed the 9.6.2 and still gets this error... has the installer broken this versions as well ?

please fix :)
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
Helge Tjelta
Helge Tjelta Akzeptierte Antwort
Now it says:
603397
Format error: "nb_NO Error: U_UNSUPPORTED_ERROR" .
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
Helge Tjelta
Helge Tjelta Akzeptierte Antwort
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.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
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
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
Helge Tjelta
Helge Tjelta Akzeptierte Antwort
Thanks Sergey, that worked!

Nice. Thank you.
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
Helge Tjelta
Helge Tjelta Akzeptierte Antwort
:D
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
Sergey Pashkov
Sergey Pashkov Akzeptierte Antwort
A new 9.6.3 includes correct ICU library
Kommentar
There are no comments made yet.
  1. vor über einem Monat
  2. Valentina Server
  3. Permalink zu dieser Antwort
  • Seite :
  • 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