"Cannot find the object "dbo.<table_name>" because it does not exist or you do not have permissions

[Levon_Lyons]

typically when you see the error it is because your ETL job is failing and in the error log you find this;

error: "Cannot find the object "dbo.<table_name>" because it does not exist or you do not have permissions."

There will be an error for each missing table, write down each table so you know which table you need to re-create;

- Once you have the list of tables, navigate to the Prognosis reporter node.

1. On the Prognosis Management (reporter) server navigate to \Prognosis\Server\Configuration\BigDataInsight\UC\SQLScripts
2. Copy the files named exactly the same as the missing tables (IR_CUCDAST will be the file called IR_CUCDAST.sql) and paste into a folder on the desktop
   <List of missing tables here>
3. Move the files to the SQL Server
4. Open and log into SSMS
5. Click on New Query
6. You can drag and drop the files into the new query and it will populate the script
7. Then click on Execute
8. Repeat steps 5 – 7 for all missing tables

manually start the ETL job and it should succeed