Skip to Content Information Center
Lexmark CX924

Lexmark CX924

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

Affected Products:

Lexmark Document Distributor LDD 4.9.1.1 for use by LPM

Lexmark Print Management LPM 2.5.1

MS SQLServer for use by LPM DB

Issue Description:

Errors may appear as the 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):

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, this says that " theconversion of a varchar data type to a datetime data type resulted in an out of range."

Explanation and Suggested Remedy:

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

The only remedy at this time is to revert SQL Server's default language back to English.

Changing MSSQL's default language via Login Properties

  1. Login to you MSSQL Management console.

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

  1. Change the default language to English and click OK.

Postchange Test:

Send a print job to observe the results.

Still Need Help?

Have the following available when calling Lexmark Technical Support;

  • Printer model(s)

  • Printer serial number

LEGACY ID: SO7922

Da li vam je ovaj članak pomogao?
Top