After upgrade to SV5.1 Rev A, including upgrade of Crystal Reports to CR 2008 SP3 FP3.3, the interface in Crystal Reports cannot see the PDL Tables/Views.
After upgrade to SV5.1 Rev A, the interface in Crystal Reports cannot see the PDL tables. The table information that is available under 'localhost' > 'OPS$OCSHIS' shows none of the PDL table/view selections.
The Tables & Views that are available do not provide access to the correct objects required to build new reports.
Existing reports that were built prior to the upgrade function correctly.Symptoms:
The following is the solution to the configuration of the setup in Crystal Reports for the problem where the PDL Tables and Views were not visible. The Options/Settings for the Database Expert connection may appear as in Figure 1 below.
The corrected configuration of these settings are as shown in Figure 2 below. When the settings have been changed, close the Options window by selecting 'OK', then close and re-open Crystal Reports. The PDL Tables and Views should now be available.