Looking for the old forum?

For topics posted before June 2015, please click here to visit the old support forum. Post your questions in this forum if you have any questions.

Support Forums
PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 19 Apr 2016 12:21 PM by  Jeff
SQL Errors
 9 Replies
Sort:
You are not authorized to post a reply.
Author Messages


New Member


Posts:6
New Member


--
19 Apr 2016 12:21 PM
    I've been working on moving an old 7.0 version of DNN to a new server. I thought I was going to be slick and do a data replication between the two SQL servers. Not only did it not work but it apparently broke something in a big way. I suspect it altered the schema of the database in some way and even restoring it to a previous version didn't fix it.Below is the error text. Does anyone have any thoughts on how to fix this?

    UserAgent: Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/49.0.2623.112 Safari/537.36
    DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke
    ExceptionGUID: 1d97e261-03d1-4999-9a8c-b11c2d589cd2
    InnerException: Operand type clash: uniqueidentifier is incompatible with int Operand type clash: uniqueidentifier is incompatible with int
    FileName:
    FileLineNumber: 0
    FileColumnNumber: 0
    Method: System.Data.SqlClient.SqlConnection.OnError
    StackTrace:
    Message: DotNetNuke.Services.Exceptions.PageLoadException: Operand type clash: uniqueidentifier is incompatible with int Operand type clash: uniqueidentifier is incompatible with int ---> System.Data.SqlClient.SqlException: Operand type clash: uniqueidentifier is incompatible with int Operand type clash: uniqueidentifier is incompatible with int at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at BizModules.UltraPhotoGallery.Data.SqlDataProvider.ListAlbum(Int32 moduleId, Int32 parentId) at BizModules.UltraPhotoGallery.AlbumController.List(Int32 moduleId, Int32 parentId) at BizModules.UltraPhotoGallery.DisplayCtlBase.ListAlbums(Int32 intparentId) at BizModules.UltraPhotoGallery.UMGClassic.GenerateDataXml(XmlDocument objXml, XmlElement parentNode, Int32 parentId) at BizModules.UltraPhotoGallery.UMGClassic.get_DataHtml() at ASP.desktopmodules_ultramediagallery_umgclassic_ascx.__Render__control1(HtmlTextWriter __w, Control parameterContainer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) at System.Web.UI.Control.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at Telerik.Web.UI.RadAjaxPanel.RenderChildren(HtmlTextWriter writer) at Telerik.Web.UI.RadAjaxPanel.RenderContents(HtmlTextWriter writer) at System.Web.UI.WebControls.WebControl.Render(HtmlTextWriter writer) at Telerik.Web.UI.RadAjaxPanel.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at Telerik.Web.UI.ControlRenderer.Render(HtmlTextWriter writer) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderControl(HtmlTextWriter writer) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) at System.Web.UI.Control


    Basic Member


    Posts:240
    Basic Member


    --
    24 Apr 2016 11:54 PM
    I didn't hear this error before. Maybe you can simply install UMG fresh?


    New Member


    Posts:6
    New Member


    --
    27 Apr 2016 04:31 PM
    If I reinstall will I lose all of the existing data? I have one portal with quite a few images loaded in it.
    Also, the whole goal here is to upgraded the server and DNN, including to the newer version of your module. Is there a process or documentation on how to accomplish that without losing everything?


    Basic Member


    Posts:240
    Basic Member


    --
    01 May 2016 10:48 PM
    If you can email me your directly sql server access credential, I should be able to fix it for you. If that possible?


    New Member


    Posts:6
    New Member


    --
    02 May 2016 08:53 AM
    That would be fine if you think you can fix it. Do you need access to the SQL Server itself or just Admin Access to the DNN Portal? Either one is fine.

    Let me know and send me your email address and I'll set up credentials and send them to you.

    Thanks you so much.
    Jeff


    New Member


    Posts:6
    New Member


    --
    04 May 2016 10:32 AM
    Were you able to get in an fix this yet?

    Thanks
    Jeff


    New Member


    Posts:6
    New Member


    --
    10 May 2016 02:02 PM
    Pengtsen, Did you receive the email I sent with the credentials to look into this SQL issue? Please let me know.
    Jeff


    Basic Member


    Posts:240
    Basic Member


    --
    14 May 2016 10:10 PM
    The login doesn't work.


    New Member


    Posts:6
    New Member


    --
    15 May 2016 10:24 AM
    I'd typo'd the login name. duh.....

    I just tested it again and I logged in fine

    Thanks
    Jeff


    Basic Member


    Posts:240
    Basic Member


    --
    25 May 2016 10:30 AM
    The problem was caused by a misconfigured sql server replication, and it has been manually fixed.
    You are not authorized to post a reply.


    Copyright © 2005-2013 BizModules Contact us