An error occurred saving changes. Invalid object name 'InvHist_Ownership_Details'

This issue has been solved. See solution.
pmakaveev's picture
pmakaveev
March 25th, 2009

I am not able to edit any computer resource. When I edit a computer  resource and then try to save tha changes I always get the following error:
"An error occurred saving changes. Invalid object name 'InvHist_Ownership_Details'".
I have checked on the SQL server that this table exists in the database.
What does this means?
Here is what the NS log shows:
========================

Log File Name: E:\Altiris\Notification Server\Logs\a.log

Priority: 1

Date: 3/25/2009 4:37:19 PM

Tick Count: -2116275061

Host Name: ENTCMS01

Process: w3wp.exe (14432)

Thread ID: 17204

Module: AltirisNativeHelper.dll

Source: Altiris.Resource.Web.Manager.EditCreateResource.ButtonsStatusCtrl_Click

Description: An error occurred saving changes. Invalid object name 'InvHist_Ownership_Details'. ( Unhandled exception. Type=Altiris.Resource.UI.Controls.ResourceDetailsEditCtrl+RDEditCtrlSaveException Msg=Invalid object name 'InvHist_Ownership_Details'. Src=Altiris.Resource.UI

StackTrace=

at Altiris.Resource.UI.Controls.ResourceDetailsEditCtrl.SaveChanges(String newName)

at Altiris.Resource.UI.Controls.ResourceDetailsEditCtrl.SaveChanges()

at Altiris.Resource.Web.Manager.EditCreateResource.SaveChanges()

at Altiris.Resource.Web.Manager.EditCreateResource.ButtonsStatusCtrl_Click(Object sender, CommandButtonStatusCtrlEventArgs e) )

=========================

Has anybody seen this or have any ideas?

Filed under: , ,
+1 (1 vote)
pmakaveev's picture
pmakaveev
34 weeks 6 days ago

Schema ownership transfered to dbo

Solution

This was happening because half of the tables, views, stored procedures etc. had db_owner as schema owner, instead of dbo. I called Altiris Support and they fixed it for me by transfering the ownership to dbo using the method described in AKB 36056:

https://kb.altiris.com/display/1/articleDirect/index.asp?aid=36056&r=5.262393E-02

This happened when we moved the database to another remote SQL server. In addition the SQL account that Altiris Notification server uses to connect was changed.

0 votes
SOLUTION