Hi ALL,
I get the below error when i try to schedule the crystal report in infoview by clicking the prompt ‘edit values’.
It says ’ An internal error occurred contact your system administrator [CRCAF00000020].
Please share your ideas on this.
Regards,
Judia
judia (BOB member since 2008-06-24)
Hi All,
I am still facing problem. The error persists in infoview. Please give your suggestions.
Thanks in advance.
Regards,
Judia
judia (BOB member since 2008-06-24)
Hi -
We’re encountering this as well - did you find a fix for it?
Thanks.
Amy Miller 
(BOB member since 2002-06-07)
Anyone ever find a fix for this?
I am on 4.1 sp05 and am also getting this. I really don’t want to reboot the CMS.
Seagrass (BOB member since 2014-11-18)
Are you scheduling a report from scratch or rescheduling an instance?
What type of database are you connecting to? If it’s Oracle, are both the 64-bit and 32-bit versions of the Oracle client software installed?
Are any of the prompts dynamic? If so, have you verified that they are available and working in the Business View Manager (part of Client Tools)?
-Dell
hilfy (BOB member since 2007-04-16)
Connecting to Oracle 11 using ODBC
both 32 and 64 bits are installed
all prompts are static
this is happening when rescheduling an instance, scheduling a new instance or view on demand.
Prompts are taking a crazy long time to come up if they come up at all. We’ve checked the No Printer box on Page Setup. Didn’t help.
These reports were migrated from 3.1XI to 4.1 sp05 but I’ve repeated the results with reports built from scratch.
Not sure where to look next in the architecture! I can’t figure out where it’s going, when trying to bring back the Prompts screen. Although it feels like it’s going to Mars and back.
Seagrass (BOB member since 2014-11-18)
ODBC can be slow when you’re using Oracle, I usually prefer to use Crystal’s Native Oracle connection.
Assuming you’re using “classic” Crystal and not Crystal for Enterprise, did you create the dynamic parameters in the report or in the Business View Manager (BVM). If you created them in Crystal based on the tables in the report, you can usually see a significant speed increase in display time if you’ll recreate the parameters in the BVM using just the tables you need to get the data for the parameter. For example, if you need to display data from a code/description lookup table, you just need to use that table.
In the BVM you will create a single Data Connection to your database - this should have a suffix of “_DC”. All of your params from a specific database will use this. (When you create them in Crystal, each one will have a separate connection!)
You will then create a Data Foundation (suffix “_DF”) for each type of parameter. This will include the tables or command that will be used to get the param data. The Data Foundation will use the Data Connection you just created. It will include any fields and/or filters that you want to apply to the data. A single Data Foundation can potentially be used by multiple Business Elements to provide different views into the data.
Next you’ll create a Business Element (suffix “_BE”). This will connect to the Data Foundation and will define which fields and filters will be available for Business Views.
Next you’ll create a Business View (suffix “_BV”) which connects to the Business Element and define which fields will be available for the List of Values.
The List of Values (no suffix) will use a Business View to define which data is available for a prompt. In the LOV you will define which field is the “value” and which is the “description” for the prompts. LOVs can be scheduled by right-clicking on them and selecting “Schedule”. If you have any that return a lot of data, I would schedule them to run regularly based on how often the data changes. This way the BI Platform will just load the data from the result of the schedule without having to hit the database for the information.
In Crystal, when you select the LOV to use for the dynamic parameter, it will create a Prompt Group (suffix “-Prompt Group”) based on the parameter definition in the report. I will usually create two - one for single select and one for multi-select. In the Repository Explorer in Crystal, you can select either an LOV or a Prompt Group to use for your dynamic parameter.
-Dell
hilfy (BOB member since 2007-04-16)
We are running into the same issue. While trying to schedule, if i try multiple times the prompts come up and i can schedule just takes a few tries. Migrated recently from 3.1 to 4.1 SP4. I hate crystal 
NycPriya (BOB member since 2010-11-04)
There can be issues with the lists of values in the BVM after migration. I would check the data connections and make sure they’re all working correctly. Then, for data that does not change often, schedule the LOVs so that the data is sort of pre-loaded instead of coming directly from the database.
Also, make sure that you migrated the “Repository” objects. If not, you can go into the BVM for the old system, export the objects for the dynamic prompts to XML and then import them into the new system. If you use the UMT, they’ll only come over with the reports.
-Dell
hilfy (BOB member since 2007-04-16)
Wow. Thank you all for the detailed information! I love this forum.
We don’t use BVM. And the reports in question were provided by our EMR vendor. But I did narrow my issue down to the ODBC connection. When I switch to using direct Oracle connection, when I edit Prompts it pops right up.
Seagrass (BOB member since 2014-11-18)