Dotcom Support Forums

To post in the forums you need to register and log in .

HomeHomeLicence MasterLicence MasterLicence Master ...Licence Master ...errors on version 1,1errors on version 1,1
Previous
 
Next
New Post
22/11/2011 16:47
 

 Message: DotNetNuke.Services.Exceptions.ModuleLoadException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_LicenceMaster_SnowCoveredAdaptor_Order_LicenceMaster_SnowCoveredAdaptor_OptionTranslation". The conflict occurred in database "mydatabase", table "dbo.LicenceMaster_SnowCoveredAdaptor_OptionTranslation". The statement has been terminated. ---> System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_LicenceMaster_SnowCoveredAdaptor_Order_LicenceMaster_SnowCoveredAdaptor_OptionTranslation". The conflict occurred in database "mydatabase", table "dbo.LicenceMaster_SnowCoveredAdaptor_OptionTranslation". The statement has been terminated. 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.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at Dotcom.Modules.SnowCoveredLicenceMasterAdaptor.SqlDataProvider.AddOrder(Int32 portalId, String invoiceId, DateTime date, Int32 packageId, String packageName, Nullable`1 optionId, String optionName, Int32 quantity, Decimal price, Decimal retailPrice, Decimal discount, Decimal amount, String billToFirstName, String billToLastName, String billToEmail, String billToRegion, String billToCountry) at Dotcom.Modules.SnowCoveredLicenceMasterAdaptor.AdaptorController.AddOrder(OrderInfo order) at Dotcom.Modules.SnowCoveredLicenceMasterAdaptor.SnowCoveredIONResponder.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---


 
New Post
23/11/2011 22:03
 

Chris,

I would suggest that this error occurred because your received an order for a SC package option that you haven't defined in the adaptor. Could that be the case? If so, the exception is correct. However, a more friendly message is required.

If the error did not arise in these circumstances, please let me know what steps are needed to reproduce it.

Regards,

 


Dotcom Technical Support
 
New Post
23/11/2011 22:05
 

 The package has no options at all.

 
New Post
24/11/2011 11:05
 

Hi Chris,

Yes, have been able to reproduce this. Snowcovered is passing the ION data in an unexpected way when the package has no options. I will release a solution shortly.

 


Dotcom Technical Support
 
New Post
24/11/2011 13:04
 

Snowcovered Adaptor v1.1.1 solves this problem. Please download here.

 


Dotcom Technical Support
 
Previous
 
Next
HomeHomeLicence MasterLicence MasterLicence Master ...Licence Master ...errors on version 1,1errors on version 1,1



 Search   Home