Print Page - ERROR: Relation 'pcdw_fact_chargeability

Title: ERROR: Relation 'pcdw_fact_chargeability_goal' does not exist RSV-SRV-0042
Post by: itsan713 on 16 Dec 2008 05:37:46 PM

Hello-

I created a new table in the database, import the table in the FM, add relationships, and then republished the package successfully. However when I used the new table 'pcdw_fact_chargeability_goal', I got the error message below:

UDA-SQL-0353 An error was detected while processing the SQL request. ERROR: Relation 'pcdw_fact_chargeability_goal' does not exist RSV-SRV-0042

I'm thinking this error occurred because there are no data in new table. Can someone please help me? I'm working with our DBAs to put data however none of them are available until next week.

Please advise.

Title: Re: ERROR: Relation 'pcdw_fact_chargeability_goal' does not exist RSV-SRV-0042
Post by: sivabisani on 17 Dec 2008 12:40:44 AM

Hi,

The root cause of this issue is that the user is not explicitly assigned to the database schema.

Thanks and Regards
siva

Title: Re: ERROR: Relation 'pcdw_fact_chargeability_goal' does not exist RSV-SRV-0042
Post by: arkchowdary on 17 Dec 2008 06:38:13 AM

Hi,

You have entered data which you have create schema.

Then do 1 thing --------------------- You can import Existing Tables.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: itsan713 on 16 Dec 2008 05:37:46 PM