cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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 

 

If my answer helped you today, please give my post a like and be sure to mark the 'Accept Solution' button to help others find the answer!
Cheers
Levon Lyons
Webinar: Keep the modern workforce connected

Unified Communications has always been an important part of companies' digital transformation efforts due to its ability to enable rich virtual collaboration and communication. But with COVID-19, we've reached a break-through point.

Join Bill Haskins, Sr. Analyst & Partner, Unified Communications at Wainhouse Research, and John Ruthven, CEO at IR discuss UC challenges companies are experiencing due to the COVOID-19 crisis.

Join webinar