- Purchasing in Microsoft Dynamics SL
- Order Management in Microsoft Dynamics SL
- Inventory in Microsoft Dynamics SL
- Time and Expense for Projects in Microsoft Dynamics SL
When you take this action, you receive one of the following series of error messages:
Cause 1The Data Execution Prevention (DEP) feature blocks some files from successfully running when Microsoft Dynamics SL or Microsoft Business Solutions - Solomon program files are on a computer that is running one of the following operating systems:
- Windows Server 2008 or Windows Server 2008 R2
- Windows 7
- Windows Server 2003 with Service Pack 1 (SP1)
- Windows Vista with Service Pack 1 (SP1)
- Windows XP Professional with Service Pack 2 (SP2)
Cause 2:There are corrupted records in the Microsoft Dynamics SL application database or in the Microsoft Business Solutions - Solomon application database.
Cause 3:The Capicom.dll file was registered incorrectly.
Cause 4:Microsoft Dynamics SL uses Crystal Reports 10. This version of Crystal Reports is an upgrade from an earlier version. Therefore, some program settings are no longer compatible.
Cause 5:This problem occurs because there is a supression formula on a subreport that is associated with the report that you are trying to print.
Cause 6:The MSDSL application role or the E7F575915A2E4897A517779C0DD7CE SQL user is not synchronized correctly with the Microsoft Dynamics SL databases. Or, both the role and the user are not synchronized correctly. This situation can occur if the following conditions are true:
- You select the Synchronize All Ownership and Security update scenario in the Database Maintenance (98.290.00) screen and the Database Maintenance (98.290.00) screen is from an earlier version of Microsoft Dynamics SL.
- You run the update scenario on any database that exists on the same instance of SQL Server as a Microsoft Dynamics SL 7.0 database.
Set the Data Execution Prevention feature to enable the Crpehlpr.exe file and the Roi.exe file to run. To do this, follow these steps:
- Right-click My Computer, and then click Properties.
- In Windows Server 2003 or Windows XP, click the Advanced tab. In Windows Vista, Windows 7, or Windows Server 2008, click the Advanced system settings link.
- In the Performance section, click Settings.
- On the Data Execution Prevention tab, click Add.
Note The default option is Turn on DEP for all programs and services except those I select.
- Browse to the Microsoft Dynamics SL program installation directory or the Microsoft Business Solutions - Solomon program installation directory. If you have an additional drive that is a mapped drive to this installation directory, you must add the file through both paths.
For example, you install Microsoft Dynamics SL 7.0 to the following folder:C:\Program Files\Microsoft Dynamics\SL\ApplicationsOn the same computer, you map the S drive to the following folder:C:\Program Files\Microsoft Dynamics\SLWhen you follow this step, you must add the files by using both of the following paths:
- C:\Program Files\Microsoft Dynamics\SL\Applications\
- Locate and then click to select the following file:Crpehlpr.exe.
- Click Open, click Apply, and then click OK.
- Repeat step 1 through step 7 for the Roi.exe file.
Delete the corrupted records from the Microsoft Dynamics SL application database or from the Microsoft Business Solutions - Solomon application database. To do this, follow these steps.
Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.
- Make sure that all Microsoft Dynamics SL users or all Microsoft Business Solutions - Solomon users are logged off.
- Start Microsoft SQL Query Analyzer. Or, start Microsoft SQL Server Management Studio.
- Connect to the appropriate Microsoft Dynamics SL application database or to the Microsoft Business Solutions - Solomon application database.
- Run the following statements.
Delete from Roidetail
Delete from Rptcompany
Delete from Rptruntime
To resolve this problem, manually register the Capicom.dll file. To do this, follow these steps:
- Locate the Capicom.dll file on the local computer. By default, this file is in the following folder: SystemDrive:\Windows\System32
- Verify that the version of the Capicom.dll file is 18.104.22.168 or a later version. To do this, follow these steps:
- Right-click the Capicom.dll file, and then click Properties.
- On the Version tab, verify that the file version is 22.214.171.124 or a later version.
- Click OK.
- Right-click the Capicom.dll file, and then click Open With.
- In the Windows dialog box, click Select the program from a list, and then click OK.
- In the Open With dialog box, click Browse.
- Locate, and then open the following folder: SystemDrive :\Windows\System32
- Double-click the Regsvr32.exe file, and then click OK.
- Click OK when you receive the following message:
To resolve this problem, select the No Printer check box in the report file in Business Objects Crystal Reports. To do this, follow these steps:
- Open Crystal Reports, and then click the report file to open it.
- Click File.
- Click Printer Setup.
- Click to select the No Printer check box, and then click OK.
- Click Save.
Change the report in Business Objects Crystal Reports to remove the suppression on the subreport.
- In Business Objects Crystal Reports, open the report file that is producing the error.
- If there is a subreport within any section of the report, right-click the subreport. Note: If there is no subreport, this resolution will not work.
- Click Format Sub-Report. The Suppress Formula button that appears should contain red text. The presence of this red text indicates that there is a suppression formula. When the formula uses variables from the parent report, the variables must be removed. Notes
- If you do not receive indication that a suppression formula exists, this resolution will not work.
- If the suppression formula uses a combination of subreport variables and parent report variables, these variables must be separated so that the parent report variables can be removed.
- If the section that contains the subreport also contains other displayed variables, the variables must be separated.
- If the section that contains the subreport already has a suppression formula, you must decide whether to merge the formulas and how to do this.
- Click Suppress Formula to open the Format Editor dialog box, and then click Select All on the Edit menu.
Notes: If the suppression formula uses only variables from the subreport, this workaround will not work.
- On the Edit menu, click Copy to copy the formula.
- Delete the formula.
- Click OK to close the Format Editor dialog box.
- Right-click the left section of the screen where the subreport appears, and then click Section Expert.
- In the Section Expert dialog box, click Suppress Formula, and then click Paste on the Edit menu to paste the formula.
- Click Save and Close, and then click OK.
- On the File menu, click Save.
Synchronize the user. To do this, follow these steps:
- Use SQL Server Management Studio to run the following statement against the Microsoft Dynamics SL system database:
DELETE FROM RPTExtra
- Select the Synchronize All Ownership and Security update scenario in the Database Maintenance (98.290.00) screen, and then click Begin Processing.
Article ID: 905595 - Last Review: Apr 24, 2012 - Revision: 1