Print Manager 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

1. Log in to your MSSQL Management console.



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



3. 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.