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 17: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 23: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 23:05
 

 The package has no options at all.

 
New Post
24/11/2011 12: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 14: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