Print Manager not releasing jobs with non-English SQL settings

Lexmark Print Manager (LPM) Not Releasing Jobs with Non-English SQL Settings

Issue description

Errors appear as follows:

Unable
to send
and release jobs
from Lexmark Document Distributor
(LDD)

Microsoft® SQL Server
is set to a non-English
language.

LDD logs this error in Lexmark Management Console
(LMC) as:

Error saving print job: org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar []; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException:

"A conversÃ£o de um tipo de dados varchar em um tipo de dados datetime resu."

Translated to English, the error message says, "the
conversion of a varchar data type to a datetime data type resulted in an out of range
."

Solution

Changing the SQL Server
locale to something other than English
changes the date format from mm/dd/yyyy to dd/mm/yyyy
creating a conflict since LPM
uses a static date format mm/dd/yyyy
.

As of writing, the only remedy is to revert SQL Server default language back to English.

Changing MSSQL default language via Log in Properties

Log in
to your MSSQL Management console.

Right-click
on your login
and select Properties from the drop-down menu.

Change the default language
to English and click OK
.

Postchange Test:

Send a print job to observe the results.

If the issue persists, search for more information related to this issue or contact support for further assistance.

LEGACY ID: SO7922