Package object still referring to Prior DB schema

[jacobsk]

Migrated a package from DEV to TEST. Both has the same Datasource name but different schema names and databases.
When i tried to create a report in TEST, it complained that {DEV_SchemaName}.table doesn't exist. Why is the package referring to the schema in DEV, doesn't it should refer only to the Datasourcename which is same in both DEV and TEST.
I'm using cognos 8.3.
If anyone knows the solution to the problem either with the package or with the imp/exp process let me know.

[technomorph]

Hi,

My understanding is that the datasource configuration in Cognos Connection is used purely to define the physical connection to the required database. The actual schema is selected using the datasource properties within Framework Manager. If you're using different schema names, the work-around is obviously to publish directly to your test environment from Framework Manager.

If the schemas you are using are the default for the database, maybe it's possible to leave the schema datasource property within Framework Manager empty so that it dynamically picks up the schema names?? I haven't tested this, so just a thought.

Cheers

[jacobsk]

thanks. I will remove the schema name and try uploading the package.