Changing DB of existing Package

[napster_gr8]

Hi,

Im facing a very unusual problem, using Cognos 10.2.2 with SQL Server 2012.
I have PackageA, data source as DS1 and Database as DB1 published on DEV server.
I export the same package from DEV to PROD server.
Now keeping the same data source (DS1), I need to change the Database to DB2 (that is a replica of DB1, say with full data)

On PROD Server i have both DBs (DB1 and DB2)
Problem is, when i create a report using PackageA, it still gets the data from DB1 and not DB2 on PROD Server.
I have tried logging on/off, package refresh, but it wont pick up the updated DB (DB2) from DS1

Did my best to define the problem.
Anybody faced a similar issue? Any help?

-
Naps

[MFGF]

Hi,

Im facing a very unusual problem, using Cognos 10.2.2 with SQL Server 2012.
I have PackageA, data source as DS1 and Database as DB1 published on DEV server.
I export the same package from DEV to PROD server.
Now keeping the same data source (DS1), I need to change the Database to DB2 (that is a replica of DB1, say with full data)

On PROD Server i have both DBs (DB1 and DB2)
Problem is, when i create a report using PackageA, it still gets the data from DB1 and not DB2 on PROD Server.
I have tried logging on/off, package refresh, but it wont pick up the updated DB (DB2) from DS1

Did my best to define the problem.
Anybody faced a similar issue? Any help?

-
Naps

Does this post help?

http://www.cognoise.com/index.php/topic,32191.0.html

MF.

[CognosAdmn]

here is how I overcame that issue in the past:

1. in DEV env, point DS1 to DB2;
2. publish package A to DEV;
3. deploy package A to prod;
4. in DEV again, point DS1 to DB1;
5. republish package A to DEV;

Probably not the best solution but it works.

[napster_gr8]

Thanks, i'll try that

-