Error: You are receiving the error, "Error -2147189155: Failed to Open the Connection.", when trying to print a Crystal report after a recent upgrade. Cause: Crystal Report data-connectivity issues with DRM are typically related to either an...
Knowledge Base
Error -2147189176 printing a report which pulls from two different databases
I have a Crystal Report created which pulls data from two different databases. When I try printing it in DRM I'm getting an Error -2147189176: Logon Failed message. In order to print reports with multiple connections within DRM the report will need...
Error "C:\Program Files\Microsoft Dynamics\GP\DRMCI11.EXE C:\Program Files\Microsoft Dynamics\GP\DRMreportname.rsci returned 11"
After installing DRM on a workstation I'm receiving an error "C:\Program Files\Microsoft Dynamics\GP\DRMCI11.EXE C:\Program Files\Microsoft Dynamics\GP\DRMreportname.rsci returned 11" when trying to print a Crystal report. How do I fix this? This...
error "DRM_RW_Trigger: Open failed – path does not exist"
How do I resolve the error, 'DRM_RW_Trigger: Open failed - path does not exist' following a recent DRM upgrade? 1. Let’s start by trying to find the trigger causing the error. You can run this script against each database and it will return a list...
Error "Error in File…Invalid parameter value: exceeds the Min or Max or conflicts with existing value or edit mask"
How do I resolve 'Error in File...Invalid parameter value: exceeds the Min or Max or conflicts with existing value or edit mask'? All Lookups in DRM are in uppercase text. Check your report parameter to ensure it is also in uppercase text. For...
Error "The specified DSN contains an architecture mismatch between the Driver and Application"
Why am I getting an error 'The specified DSN contains an architecture mismatch between the Driver and Application.' when running a Crystal Report in DRM? This error can occur if you create an ODBC using the ODBC Applet in the Control Panel on a 64...
Error "C:\Program Files\Microsoft Dynamics\GP\DRMCI11.EXE C:\Program Files\Microsoft Dynamics\GP\DRMreportname.rsci returned 11"
After installing DRM on a workstation I'm receiving an error "C:\Program Files\Microsoft Dynamics\GP\DRMCI11.EXE C:\Program Files\Microsoft Dynamics\GP\DRMreportname.rsci returned 11" when trying to print a Crystal report. How do I fix this? This...
DRM Tables
Where can I find the DRM report tables? The DRM tables can be located using the Tables Resources available in GP under Tools >> Resource Descriptions >> Tables. The DRM table holding the Reports is in the DYNAMICS database and is called...
DRM: Suppress Date Change Dialog at Midnight "Change Date" not staying checked
On the DRM System Settings window the Suppress Date Change Dialog at Midnight has two choices, (1) Don't Change Date and (2) Change Date. If you check the box to Suppress Date Change Dialog at Midnight, then click the 'Change Date' radio button and...
DRM_User_Favorites_VIEW failed accessing SQL data
I'm getting "An open operation on table DRM_User_Favorites_VIEW failed accessing SQL data" error message when trying to print a report. The ANSI settings in the ODBC DSN connection are marked and they will need to be unmarked. Recommendation: 1....