We are using unbraco with our one of our domain and suddenly receiving errors at - http://mumstadka.com/ can you please shad some light on this and help us to resolve issues.
=============================================
erver Error in '/' Application. Invalid object name 'umbracoDomains'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'umbracoDomains'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
And has there been made any changes to the installation? (Installing of 3rd party packages or custom API integration?)
Did something happen on the webserver? What about the SQL server?
Umbraco errors
Hello,
We are using unbraco with our one of our domain and suddenly receiving errors at - http://mumstadka.com/ can you please shad some light on this and help us to resolve issues.
=============================================
erver Error in '/' Application.
Invalid object name 'umbracoDomains'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'umbracoDomains'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): Invalid object name 'umbracoDomains'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +1767866
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5352418
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +244
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +1691
System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +61
System.Data.SqlClient.SqlDataReader.get_MetaData() +90
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +365
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) +1406
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) +177
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +53
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +134
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +81
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +147
umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters) +37
umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +81
[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader]
umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +136
umbraco.cms.businesslogic.web.Domain.<GetDomains>b__0() +76
umbraco.cms.businesslogic.cache.Cache.GetCacheItem(String cacheKey, Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, CacheDependency cacheDependency, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) +123
umbraco.cms.businesslogic.web.Domain.GetDomains() +173
umbraco.cms.businesslogic.web.Domain.GetDomain(String DomainName) +44
umbraco.requestHandler.CreateXPathQuery(String url, Boolean checkDomain) +227
umbraco.requestHandler..ctor(XmlDocument umbracoContent, String url) +546
umbraco.UmbracoDefault.Page_PreInit(Object sender, EventArgs e) +1084
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +51
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.UI.Page.OnPreInit(EventArgs e) +9531286
System.Web.UI.Page.PerformPreInit() +31
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +335
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.18446
Request Details
Session Id: o0xyn25hhygnvpebjey3mped Request Type: GET
Time of Request: 4/29/2014 12:15:46 PM Status Code: 500
Request Encoding: Unicode (UTF-8) Response Encoding: Unicode (UTF-8)
Trace Information
Category Message From First(s) From Last(s)
umbracoGlobalsettings reserverd urls: '/config/splashes/booting.aspx,/config/splashes/nonodes.aspx,/install/,/umbraco/,'
aspx.page Begin PreInit 0.000418 0.000418
umbracoInit handling request 0.000451 0.000032
request handler current url '' 0.003172 0.002721
Unhandled Execution Error
Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
at umbraco.cms.businesslogic.web.Domain.<GetDomains>b__0()
at umbraco.cms.businesslogic.cache.Cache.GetCacheItem[TT](String cacheKey, Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, CacheDependency cacheDependency, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem)
at umbraco.cms.businesslogic.web.Domain.GetDomains()
at umbraco.cms.businesslogic.web.Domain.GetDomain(String DomainName)
at umbraco.requestHandler.CreateXPathQuery(String url, Boolean checkDomain)
at umbraco.requestHandler..ctor(XmlDocument umbracoContent, String url)
at umbraco.UmbracoDefault.Page_PreInit(Object sender, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Page.OnPreInit(EventArgs e)
at System.Web.UI.Page.PerformPreInit()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) 0.003803 0.000631
Control Tree
Control UniqueID Type Render Size Bytes (including children) ViewState Size Bytes (excluding children) ControlState Size Bytes (excluding children)
__Page ASP.default_aspx 0 0 0
Session State
Session Key Type Value
Application State
Application Key Type Value
vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 4/29/2014 12:15:46 PM
umbracoUrl System.String www.mumstadka.com:80/umbraco
umbracoNeedConfiguration System.Boolean False
vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 4/29/2014 12:15:46 PM
vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 4/29/2014 12:15:46 PM
Request Cookies Collection
Name Value Size
__utma 77983368.561471537.1392880818.1392880818.1392880818.1 60
__utmz (77983368.1392880818.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)) 76
Response Cookies Collection
Name Value Size
Headers Collection
Name Value
Cache-Control max-age=0
Connection keep-alive
Accept text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Encoding gzip, deflate
Accept-Language en-US,en;q=0.5
Cookie __utma=77983368.561471537.1392880818.1392880818.1392880818.1; __utmz=77983368.1392880818.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)
Host www.mumstadka.com
User-Agent Mozilla/5.0 (Windows NT 6.1; WOW64; rv:28.0) Gecko/20100101 Firefox/28.0
Response Headers Collection
Name Value
X-AspNet-Version 4.0.30319
Cache-Control private
Content-Type text/html
Form Collection
Name Value
Querystring Collection
Name Value
Server Variables
Name Value
ALL_HTTP HTTP_CACHE_CONTROL:max-age=0 HTTP_CONNECTION:keep-alive HTTP_ACCEPT:text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 HTTP_ACCEPT_ENCODING:gzip, deflate HTTP_ACCEPT_LANGUAGE:en-US,en;q=0.5 HTTP_COOKIE:__utma=77983368.561471537.1392880818.1392880818.1392880818.1; __utmz=77983368.1392880818.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none) HTTP_HOST:www.mumstadka.com HTTP_USER_AGENT:Mozilla/5.0 (Windows NT 6.1; WOW64; rv:28.0) Gecko/20100101 Firefox/28.0
ALL_RAW Cache-Control: max-age=0 Connection: keep-alive Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Encoding: gzip, deflate Accept-Language: en-US,en;q=0.5 Cookie: __utma=77983368.561471537.1392880818.1392880818.1392880818.1; __utmz=77983368.1392880818.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none) Host: www.mumstadka.com User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:28.0) Gecko/20100101 Firefox/28.0
APPL_MD_PATH /LM/W3SVC/102/ROOT
APPL_PHYSICAL_PATH C:\inetpub\vhosts\mumstadka.com\httpdocs\
AUTH_TYPE
AUTH_USER
AUTH_PASSWORD
LOGON_USER
REMOTE_USER
CERT_COOKIE
CERT_FLAGS
CERT_ISSUER
CERT_KEYSIZE
CERT_SECRETKEYSIZE
CERT_SERIALNUMBER
CERT_SERVER_ISSUER
CERT_SERVER_SUBJECT
CERT_SUBJECT
CONTENT_LENGTH 0
CONTENT_TYPE
GATEWAY_INTERFACE CGI/1.1
HTTPS off
HTTPS_KEYSIZE
HTTPS_SECRETKEYSIZE
HTTPS_SERVER_ISSUER
HTTPS_SERVER_SUBJECT
INSTANCE_ID 102
INSTANCE_META_PATH /LM/W3SVC/102
LOCAL_ADDR 92.48.118.139
PATH_INFO /
PATH_TRANSLATED C:\inetpub\vhosts\mumstadka.com\httpdocs
QUERY_STRING
REMOTE_ADDR 92.48.118.139
REMOTE_HOST 92.48.118.139
REMOTE_PORT 49656
REQUEST_METHOD GET
SCRIPT_NAME /
SERVER_NAME www.mumstadka.com
SERVER_PORT 80
SERVER_PORT_SECURE 0
SERVER_PROTOCOL HTTP/1.1
SERVER_SOFTWARE Microsoft-IIS/7.5
URL /
HTTP_CACHE_CONTROL max-age=0
HTTP_CONNECTION keep-alive
HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING gzip, deflate
HTTP_ACCEPT_LANGUAGE en-US,en;q=0.5
HTTP_COOKIE __utma=77983368.561471537.1392880818.1392880818.1392880818.1; __utmz=77983368.1392880818.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)
HTTP_HOST www.mumstadka.com
HTTP_USER_AGENT Mozilla/5.0 (Windows NT 6.1; WOW64; rv:28.0) Gecko/20100101 Firefox/28.0
Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.18446
=============================================
Hi Leon
What version of Umbraco are you using?
And has there been made any changes to the installation? (Installing of 3rd party packages or custom API integration?) Did something happen on the webserver? What about the SQL server?
/Jan
Hi Leon
Don't know if this article might help - but think it's worth a read and a try http://www.carbonsoft.co.uk/articles/2012/07/invalid-object-name-umbracodomains-resolved.aspx
But remember to keep a backup of everything before having a go :)
/Jan
is working on a reply...