Database schema name changed

[Desperado]

Hi,

I'm using a different database schema from my cognos connection for the reports. The schema name is xyz. Now after creating most of the reports, the schema name is changed to abc.

Do i need to create all the reports again? is there any work around to make the reports work with the new schema name ? the tables in both the schemas are same .but abc is an updated one for xyz. thats the only difference. the database i'm using is oracle.
Can anyone help me with a Solution. Plz dont advice me to create all the reports.. :)

Thanks in Advance

[ratikant]

Hi,
Export a package and unzip it. edit the package1.xml find and replace ur old schema to new schema. I hope this will help you...

[Desperado]

Hi,

I rename the schema name in Framework Manager and updated the tables (reimported the metadata from the database only for the updated tables) and then published the package. But when i'm trying to  open the report in report studio, while updating the report, i'm getting the following error.

DPR-ERR-2056
The Report Server is not responding

Handler trace back:
[the_dispatcher] com.cognos.pogo.handlers.performance.PerformanceIndicationHandler
[the_dispatcher] com.cognos.pogo.handlers.logic.ChainHandler
[service_lookup] com.cognos.pogo.handlers.engine.ServiceLookupHandler
[load_balancer] com.cognos.pogo.handlers.logic.ChainHandler
[lb_forwarder] com.cognos.p2plb.clerver.LoadBalanceHandler
[reportservicechain] com.cognos.pogo.handlers.logic.ChainHandler
[warp_with_authenticate] com.cognos.pogo.handlers.logic.ChainHandler
[do_warp] com.cognos.pogo.handlers.logic.ChainHandler
[warpmta] com.cognos.pogo.reportservice.ReportServerHandler


Can anyone tell me the reason for the error and help me with the fix for this ?

Thanks in Advance