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
Quote from: napster_gr8 on 18 Jan 2017 10:05:35 AM
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.
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.
Thanks, i'll try that
-