ERROR: Relation 'pcdw_fact_chargeability_goal' does not exist RSV-SRV-0042

[itsan713]

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.

[sivabisani]

Hi,

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

Thanks and Regards
siva

[arkchowdary]

Hi,

You have entered data which you have create schema.

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