|
By Supermac - Thu 10 Sep 2015
|
I'm battling with this problem: I can open backend promotions' page (I don't have promotions actually so nothing is listed in page) but when I try to create new promotion nothing happens and this error is logged... suggestions?
-----------------------------------------------------------------------------
>> Version:2,8004
>> Page:
-----------------------------------------------------------------------------
>> 10/09/2015 10:47:02
>> 192.168.169.254
>> DESCRIPTION:
System.Data.ConstraintException: Impossibile attivare i vincoli. Una o più righe contengono valori che violano il vincolo non-null, unique o foreign-key.
in System.Data.DataTable.EnableConstraints()
in System.Data.DataTable.set_EnforceConstraints(Boolean value)
in System.Data.DataTable.EndLoadData()
in System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
in System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
in System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
in System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
in System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
in kartrisPromotionsDataTableAdapters.PromotionStringsTblAdptr._GetByType(String PartNo, Nullable`1 LANG_ID)
in PromotionsBLL._GetPromotionStringsByType(Char charType, Byte languageID)
in UserControls_Back_PromotionStringBuilder.CreatePromotionPart(Char chrPartNo)
in UserControls_Back_EditPromotion.PrepareNewPromotion()
in UserControls_Back_EditPromotion.EditPromotion(Int32 PromotionID)
in Admin_Promotions.lnkBtnNewPromotion_Click(Object sender, EventArgs e)
in System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)
in System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)
in System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
in System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
in System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
in System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
==================================================
|
|
By Supermac - Thu 10 Sep 2015
|
I had to complete information: I tried on two pc, a local installation and a remote installation.
The local installation works, the remote installations shows the problem.
If I create a promotion using EN language in backend in remote installation it works, If I do the same thing with IT language it shows the problem.
I opened the tables involved in PromotionStringsTblAdptr creation (tblKartrisLanguageElements and tblKartrisLanguageStrings, if I'm not wrong) but can't say which is data that generates not-null, unique or foreign-key violation in datatable.... what should I check?
thank you
|
|
By Supermac - Fri 11 Sep 2015
|
Another piece of puzzle:
Once I created working promotion using backend in EN language, I changed user's language in Login menu, relogged and tried to open the promotion previously made but unsuccessfully... same error logged.
|
|
By Paul - Mon 14 Sep 2015
|
|
I think the problem is that parts of a promotion have language specific records created for them. When you view the italian language in the back end, does it indicate missing language strings or elements?
|
|
By Supermac - Mon 14 Sep 2015
|
No, regional settings/language&mail setup page tells it's all right...
Using italian language in backend I can see in _Promotions.aspx the promotion made using english language listed with no lacks, but can't edit it (see attchment)
|
|
By Supermac - Mon 14 Sep 2015
|
|
This is english detail of promotion viewed by english backend...
|
|
By Supermac - Mon 14 Sep 2015
|
|
... and this is italian version of promotion (inserted/viewed using english backend)
|
|