An error occurred saving changes. Invalid object name 'InvHist_Ownership_Details'
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?
Comments
Schema ownership transfered to dbo
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.
Would you like to reply?
Login or Register to post your comment.