Could not find parent folder

[jschill2628]

I am hoping someone has seen this, or can help with this issue; we are attempting to change all of our Crystal reports from one database to another (point the reports and prompts to the new database)

Business Objects XI3.1 service pack 2. Application on a Windows 2003
Server R2. Tomcat 5.5 and SQL Server 2008 for CMS repository.
Crystal Reports 2008.

There are several different things we have tried, such as downloading the report from the PROD side of BO, to the QA side of BO, and making the necessary changes in QA. The problem lies where if we use the PROD Admin account we can just do everything in PROD, this is great, except that we cannot maintain (update or change ) our reports, due to the fact that I a developer does not have the Admin account for Production, I only have it for QA. I am getting help on the production side. When I open the report in crystal developer using the QA Admin account I immediately received the following error: “Unable to load prompt group from repository. Recreating prompt group locally but some information may be lost.”

It would appear that the repository objects (dynamic cascading prompts) get wiped out, so I cannot execute QA reports with PROD prompts. If I point the prompt to the ones I created in Business View Manger using the QA Admin account, then everything works great, except when we try to load the report to Production, we then get an error, that it “Could not find parent folder” and only bring 29 of the 49 repository objects over. This causes the cascading
prompts to not work correctly in the destination environment. (when I go to run the report in Production my List of Values (LOVs) are not showing up)

THANK YOU!!!

 

[hilfy]

When you import the reports from Prod to QA, you need to make sure that you include the "Repository objects" so that you get your dynamic prompts as well. Crystal handles dynamic prompts two different ways -

1. If you have a stand-alone report or one that is not published to BO or Crystal Server, Crystal will handle the prompt internally.

2. If the report is published to BO or Crystal Server, there are several objects that are created in the repository to handle the "list of values" - you have to use the Business View Manager to modify them. In your particular case you'll need to modify the ones that end in either "_DF" or "_DS" (I don't remember exactly, and I don't have any samples here to work with...) to set the data location.

This needs to be done in addition to setting the data location for the reports.

-Dell

DecisionFirst Technologies - Six-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com