I receive an error "Malformed \uxxxx encoding" when using db-tools

KB Home   |   I receive an error "Malformed \uxxxx encoding" when using db-tools

Main.MalformeduxxxxEncoding History

Hide minor edits - Show changes to output

July 05, 2018, at 11:09 PM by Aaron Pouliot - Changed category to Databases
Changed line 17 from:
''Categories:''
to:
''Categories:'' [[Category.Databases|+]]
Changed lines 14-15 from:
More specifically, this error is because \u is reserved in Java.
to:
More specifically, this error is because \u is reserved in Java for escaping Unicode strings.
Changed line 17 from:
''Categories:'' [[Category.Misc|+]],
to:
''Categories:''
Changed lines 5-6 from:
PaperCut Supports both [[https://www.papercut.com/products/ng/manual/ch-ext-db-upsizing.html#id727676 | SQL Authentication]] (preferred) and [https://www.papercut.com/kb/Main/SQLServerWindowsAuthentication | Windows Authentication]] when connecting to the Microsoft SQL database.
to:
PaperCut Supports both [[https://www.papercut.com/products/ng/manual/ch-ext-db-upsizing.html#id727676 | SQL Authentication]] (preferred) and [[https://www.papercut.com/kb/Main/SQLServerWindowsAuthentication | Windows Authentication]] when connecting to the Microsoft SQL database.
Added lines 1-19:
(:title I receive an error "Malformed \uxxxx encoding" when using db-tools:)

The PaperCut Support team recently came across this error when a customer was [[https://www.papercut.com/products/ng/manual/ch-ext-db-upsizing.html | Up Sizing]] their PaperCut installation to use an external [[https://www.papercut.com/products/ng/manual/ch-ext-db.html#id705020 | Microsoft SQL database]].

PaperCut Supports both [[https://www.papercut.com/products/ng/manual/ch-ext-db-upsizing.html#id727676 | SQL Authentication]] (preferred) and [https://www.papercut.com/kb/Main/SQLServerWindowsAuthentication | Windows Authentication]] when connecting to the Microsoft SQL database.

In this particular instance, the Windows User was [@companydomain\universal@]. The [@universal@] is non-generic in this example. This meant that when running [@db-tools init-db@], the Java environment that PaperCut is developed in returned the following error:

[@Error ocurred running db-tools, command: init-db.
Malformed \uxxxx encoding.@]

The server.properties file would require the \ to be escaped if this was the correct method of entering the Windows Authentication details. When using Windows Authentication, the username and password is not required.

More specifically, this error is because \u is reserved in Java.

----
''Categories:'' [[Category.Misc|+]],
----
[-Keywords: -]

Comments

Share your findings and experience with other PaperCut users. Feel free to add comments and suggestions about this Knowledge Base article. Please don't use this for support requests.

Article last modified on July 05, 2018, at 11:09 PM
Printable View   |   Article History   |   Edit Article