WMS printing error: Database logon failed , table PMX_OSCO

Crystal Report Printing Issue System.Runtime.InteropServices.COMException: Database logon failed.

Article Type: Problem

Product AREA: WMS

TOPIC / SYSTEM AREA (WMS/SCAN): Crystal reports / Printing issues

System Functionality: Printing

This article was created to troubleshoot the issue related to the printing issue in Produmex WMS. The Printing doesn’t work after upgrading to the latest Produmex version. However, in SAP the standard Crystal Reports print without issue. 

Scenario: -

If you print an Item Label form the Inventory Report for example as below it asks for database login every time.

You get a logon error. Database logon failed.

ERROR Produmex.Sbo.Logex.Data.Devices.CrystalReportPrinter [(null)] - There was an exception when printing the report '3' on the printer 'WHS_LBL1' and windows printer '\\172.16.1.7\MF GK420D WMS'

CrystalDecisions.CrystalReports.Engine.LogOnException: Database logon failed. --->

Crystal Report connection string:

Solutions: -

You need check the table PMX_OSCO in sql and set this column to null with this query. 

update PMX_OSCO set "CrystalReportConnectionName" = NULL