Page load exception

Oct 27, 2013 at 7:27 AM
Hi,

Somebody knows what to do about the following message in my log file?

Regards, Ton Hermes



AssemblyVersion: 6.1.5

PortalID: 0

PortalName: Webwinkel emailleer benodigheden

UserID: -1

UserName:

ActiveTabID: 64

ActiveTabName: Webwinkel

RawURL: /Webwinkel/tabid/64/ProdID/353/Language/nl-NL/CatID/21/Filligrana_Transparant_klein__20_st_voor_de_emailleerhobby.aspx

AbsoluteURL: /Default.aspx

AbsoluteURLReferrer:

UserAgent: Mozilla/4.0 (compatible; Synapse)

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider

ExceptionGUID: 0f0cce43-d60b-45dd-8e7a-c1b73d6b343d

InnerException: Cannot insert the value NULL into column 'CartID', table 'DB4143_waterman.dbo.NB_Store_Cart'; column does not allow nulls. INSERT fails. The statement has been terminated.

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: System.Data.SqlClient.SqlConnection.OnError

StackTrace:

Message: DotNetNuke.Services.Exceptions.PageLoadException: Cannot insert the value NULL into column 'CartID', table 'DB4143_waterman.dbo.NB_Store_Cart'; column does not allow nulls. INSERT fails. The statement has been terminated. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'CartID', table 'DB4143_waterman.dbo.NB_Store_Cart'; column does not allow nulls. INSERT fails. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 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, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at NEvoWeb.Modules.NB_Store.SqlDataProvider.UpdateNB_Store_Cart(String CartID, Int32 PortalID, Int32 UserID, DateTime DateCreated, Int32 OrderID, String VATNumber, String PromoCode, String CountryCode, String ShipType, Int32 BankTransID, String BankHtmlRedirect, Int32 ShipMethodID, Decimal CartDiscount, String XMLInfo, String Referrer) at NEvoWeb.Modules.NB_Store.CartController.UpdateObjCart(NB_Store_CartInfo objInfo) at NEvoWeb.Modules.NB_Store.CurrentCart.GetCurrentCart(Int32 PortalID, HttpRequest Request) at NEvoWeb.Modules.NB_Store.CurrentCart.GetCalulatedTotals(Int32 PortalID, Int32 ShipMethodID) at NEvoWeb.Modules.NB_Store.CartList.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---

Source:

Server Naam: sknet148
Coordinator
Oct 27, 2013 at 1:43 PM
Hi Ton,

I think this might be linked to the cart cookie having an invalid cart id. I'm not sure how this could happen?...but I think clearing your cookies, or trying another web browser might solve it.

Have a go and let me know what happens. If it is this then we need to put some kind of capture in the code for this situation.

Thanks,
Dave.
Coordinator
Oct 27, 2013 at 1:44 PM
Ah!..you say it's in your logfile?

Maybe the capture code is included and it works around it, but it still triggers the log!...I'll have a quick read of the code.
Nov 1, 2013 at 4:18 PM
Hi Dave,

I got the 2 following errors in the logfile again.
I do not know what this causing.

Regards, Ton



AssemblyVersion: 6.1.5

PortalID: 0

PortalName: Webwinkel emailleer benodigheden

UserID: -1

UserName:

ActiveTabID: 64

ActiveTabName: Webwinkel

RawURL: /Webwinkel/tabid/64/ProdID/414/CatID/18/language/nl-NL/Default.aspx

AbsoluteURL: /Default.aspx

AbsoluteURLReferrer:

UserAgent: Mozilla/4.0 (compatible; Synapse)

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider

ExceptionGUID: dc54a516-e08f-4b00-8a99-ddcef70764ca

InnerException: Cannot insert the value NULL into column 'CartID', table 'DB4143_waterman.dbo.NB_Store_Cart'; column does not allow nulls. INSERT fails. The statement has been terminated.

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: System.Data.SqlClient.SqlConnection.OnError

StackTrace:

Message: DotNetNuke.Services.Exceptions.PageLoadException: Cannot insert the value NULL into column 'CartID', table 'DB4143_waterman.dbo.NB_Store_Cart'; column does not allow nulls. INSERT fails. The statement has been terminated. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'CartID', table 'DB4143_waterman.dbo.NB_Store_Cart'; column does not allow nulls. INSERT fails. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 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, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at NEvoWeb.Modules.NB_Store.SqlDataProvider.UpdateNB_Store_Cart(String CartID, Int32 PortalID, Int32 UserID, DateTime DateCreated, Int32 OrderID, String VATNumber, String PromoCode, String CountryCode, String ShipType, Int32 BankTransID, String BankHtmlRedirect, Int32 ShipMethodID, Decimal CartDiscount, String XMLInfo, String Referrer) at NEvoWeb.Modules.NB_Store.CartController.UpdateObjCart(NB_Store_CartInfo objInfo) at NEvoWeb.Modules.NB_Store.CurrentCart.GetCurrentCart(Int32 PortalID, HttpRequest Request) at NEvoWeb.Modules.NB_Store.CurrentCart.GetCalulatedTotals(Int32 PortalID, Int32 ShipMethodID) at NEvoWeb.Modules.NB_Store.CartList.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace ---

Source:

Server Naam: sknet148

ModuleId: 455

ModuleDefId: 125

FriendlyName: Winkelmandje

ModuleControlSource: DesktopModules/NB_Store/MiniCart.ascx

AssemblyVersion: 6.1.5

PortalID: 0

PortalName: Webwinkel emailleer benodigheden

UserID: -1

UserName:

ActiveTabID: 64

ActiveTabName: Webwinkel

RawURL: /Webwinkel/tabid/64/ProdID/414/CatID/18/language/nl-NL/Default.aspx

AbsoluteURL: /Default.aspx

AbsoluteURLReferrer:

UserAgent: Mozilla/4.0 (compatible; Synapse)

DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider

ExceptionGUID: 72f69942-0c16-42ba-975d-90dc8e9a9d9a

InnerException: Cannot insert the value NULL into column 'CartID', table 'DB4143_waterman.dbo.NB_Store_Cart'; column does not allow nulls. INSERT fails. The statement has been terminated.

FileName:

FileLineNumber: 0

FileColumnNumber: 0

Method: System.Data.SqlClient.SqlConnection.OnError

StackTrace:

Message: DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot insert the value NULL into column 'CartID', table 'DB4143_waterman.dbo.NB_Store_Cart'; column does not allow nulls. INSERT fails. The statement has been terminated. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'CartID', table 'DB4143_waterman.dbo.NB_Store_Cart'; column does not allow nulls. INSERT fails. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 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, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, String spName, Object[] parameterValues) at NEvoWeb.Modules.NB_Store.SqlDataProvider.UpdateNB_Store_Cart(String CartID, Int32 PortalID, Int32 UserID, DateTime DateCreated, Int32 OrderID, String VATNumber, String PromoCode, String CountryCode, String ShipType, Int32 BankTransID, String BankHtmlRedirect, Int32 ShipMethodID, Decimal CartDiscount, String XMLInfo, String Referrer) at NEvoWeb.Modules.NB_Store.CartController.UpdateObjCart(NB_Store_CartInfo objInfo) at NEvoWeb.Modules.NB_Store.CurrentCart.GetCurrentCart(Int32 PortalID, HttpRequest Request) at NEvoWeb.Modules.NB_Store.CurrentCart.GetCalulatedTotals(Int32 PortalID, Int32 ShipMethodID) at NEvoWeb.Modules.NB_Store.MiniCart.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Source:

Server Naam: sknet148
Coordinator
Nov 1, 2013 at 5:21 PM
Hi Ton,

I have looked at the code and oddly I can't see any path that would cause a NULL cartid, obviously there is something, Le me have a think how we can trace it and I'll get back to you.

Dave,

P.S. Buzz me again directly on my email when I forget.
Feb 20 at 5:08 PM
Hi Dave,

I am getting these errors as well. What sort of information you need to find out more and hopefully solve it?

Franco