Cannot refresh Entity. Record does not exist.

Discussion of open issues, suggestions and bugs regarding LinqConnect – Devart's LINQ to SQL compatible ORM
Post Reply
KKirchhoff
Posts: 14
Joined: Fri 03 Oct 2008 07:43

Cannot refresh Entity. Record does not exist.

Post by KKirchhoff » Wed 24 Feb 2010 20:03

Hello,
I have a Problem to add a new Entry and Submit it .. I Use dbConnect for MySQL Version 5.50.62.0.

Hear my ExcampleCode:

Code: Select all

        private void insertParamObject(string _inParamName, object _inDevValue)
        {  
            jobbots24Datacontext _DB =  new jobbots24Datacontext();
            appParamItem = new AppParameter();
            // appParamItem.ParID is an Autoincremt Integer .. 
            appParamItem.AnwId = aktAnwenderID;
            appParamItem.ParName = _inParamName;
            appParamItem.ParValue = _inDevValue.ToString();
            _DB.AppParameters.InsertOnSubmit(appParamItem);
            _DB.SubmitChanges();  // here is the Error ..

        }
if the Entry Exits, the SubmitChanges() will work correcly.

I Use the Entry Developer Version 2.50.55 to create the Entry Model.
Top
AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Thu 25 Feb 2010 14:00

Could you please specify the error message and the structure of the entity?
As far as I understand, the problem is associated with the fact that the AppParameter entity has master aktAnwender entity.
If so, there will be a designed error in the situation when there is no parent entity for the child one.
Top
KKirchhoff
Posts: 14
Joined: Fri 03 Oct 2008 07:43

Submit don´t work: Cannot refresh Entry: Record does not exi

Post by KKirchhoff » Wed 24 Mar 2010 20:30

The ErrorMessage: Cannot refresh Entry: Record does not exits

A part of the Debug Message:

************** Ausnahmetext **************
System.InvalidOperationException: Cannot refresh Entity. Record does not exist.
bei Devart.Data.Linq.Provider.DataProvider.GetAutoSyncValues(MetaType type, IDbCommand dbCommand, IList`1 autoSyncFields, IList`1 autoSyncParameters, IList`1 keyFields, IList`1 keyParameters)
bei Devart.Data.MySql.Linq.Provider.MySqlDataProvider.GetAutoSyncValues(MetaType type, IDbCommand dbCommand, IList`1 autoSyncFields, IList`1 autoSyncParameters, IList`1 keyFields, IList`1 keyParameters)
bei Devart.Data.Linq.v.b(MetaType A_0, q A_1, Boolean A_2)
bei Devart.Data.Linq.e.a(h A_0, Object A_1, ModifiedMemberInfo[] A_2, Boolean A_3)
bei Devart.Data.Linq.k.a(DataContext A_0, ConflictMode A_1)
bei Devart.Data.Linq.k.b(DataContext A_0, ConflictMode A_1)
bei Devart.Data.Linq.DataContext.SubmitChanges(ConflictMode failureMode)
bei Devart.Data.Linq.DataContext.SubmitChanges()
Top
AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Thu 25 Mar 2010 11:03

Thank you for the clarification.
We have found and fixed this problem, the fixed build will be available in several days.
Top
KKirchhoff
Posts: 14
Joined: Fri 03 Oct 2008 07:43

Post by KKirchhoff » Thu 25 Mar 2010 19:08

How get I the Information the the problem is fixed, and how can i get the new Version after fix the problem .. thx
Top
AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Fri 26 Mar 2010 08:19

Information about bug fixes is available in the announcement on the forum. You can also check the History for each provider.
Top
KKirchhoff
Posts: 14
Joined: Fri 03 Oct 2008 07:43

Post by KKirchhoff » Tue 30 Mar 2010 11:34

When is the fixed Build available? To add a new record is not a future it is a basic function ... and I the Update ...

thx
Top
AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Tue 30 Mar 2010 11:48

We plan to release the build in several days.
Top
KKirchhoff
Posts: 14
Joined: Fri 03 Oct 2008 07:43

Post by KKirchhoff » Fri 02 Apr 2010 07:06

I have seen that the update is in the trial version is online, but when are the update online for you custoumers .. and when i can download it ?
Top
AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Fri 02 Apr 2010 08:01

Non-trial versions are available in Registered Users Area.
Use username and password you have obtained while purchasing.
Top
KKirchhoff
Posts: 14
Joined: Fri 03 Oct 2008 07:43

Post by KKirchhoff » Fri 02 Apr 2010 08:47

Yes, but the Version in my Registered Users Area is not the latest.. In my Registered Users Area is the Version 5.50.79 (14-Jan-2010). When will be the latest Version available in the Registered Users Area? or is it possible to get it via EMail ?
Top
AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Fri 02 Apr 2010 09:19

Thank you for the report, we are investigating the problem.
I will let you know as soon as it is fixed.
Top
KKirchhoff
Posts: 14
Joined: Fri 03 Oct 2008 07:43

Post by KKirchhoff » Fri 02 Apr 2010 14:39

I think it was my problem, because i must renew the licence..

Thx for your help :)
Top
KKirchhoff
Posts: 14
Joined: Fri 03 Oct 2008 07:43

Post by KKirchhoff » Sat 03 Apr 2010 09:44

Now I have the new Version and I have the same problem, I can´t insert an submit a new reccord. What is wrong?

I can not wait any longer ... to insert a new record is a basic function !!!!!!

Informationen über das Aufrufen von JIT-Debuggen
anstelle dieses Dialogfelds finden Sie am Ende dieser Meldung.

************** Ausnahmetext **************
System.InvalidOperationException: Cannot refresh Entity. Record does not exist.
bei Devart.Data.Linq.Provider.DataProvider.GetAutoSyncValues(MetaType type, IDbCommand dbCommand, IList`1 autoSyncFields, IList`1 autoSyncParameters, IList`1 keyFields, IList`1 keyParameters, Boolean inUpdate)
bei Devart.Data.MySql.Linq.Provider.MySqlDataProvider.GetAutoSyncValues(MetaType type, IDbCommand dbCommand, IList`1 autoSyncFields, IList`1 autoSyncParameters, IList`1 keyFields, IList`1 keyParameters, Boolean inUpdate)
bei Devart.Data.Linq.o.a(a A_0, MetaType A_1, h A_2, ModifiedMemberInfo[] A_3, Boolean A_4)
bei Devart.Data.Linq.l.a(i A_0, z A_1, Object A_2, Boolean A_3)
bei Devart.Data.Linq.u.a(l A_0, z A_1, Boolean A_2)
bei Devart.Data.Linq.u.a(DataContext A_0, ConflictMode A_1)
bei Devart.Data.Linq.u.b(DataContext A_0, ConflictMode A_1)
bei Devart.Data.Linq.DataContext.SubmitChanges(ConflictMode failureMode)
bei Devart.Data.Linq.DataContext.SubmitChanges()
bei jobbots24.de.Core.ApplicationConfig.writeParam(String _inParamName, Object _inParamValue) in X:\Projekte\WinFormProjekte\jobbots24\jobbots24.de\Tools\ApplicationConfig.cs:Zeile 61.
bei jobbots24.de.Core.ApplicationConfig.set_LastModul(String value) in X:\Projekte\WinFormProjekte\jobbots24\jobbots24.de\Tools\ApplicationConfig.cs:Zeile 38.
bei jobbots24.de.frmHaupt.showModul(BarLargeButtonItem _inButton, String _inModuleName) in X:\Projekte\WinFormProjekte\jobbots24\jobbots24.de\Views\HauptForm.cs:Zeile 199.
bei jobbots24.de.frmHaupt.btnPlaner_DownChanged(Object sender, ItemClickEventArgs e) in X:\Projekte\WinFormProjekte\jobbots24\jobbots24.de\Views\HauptForm.cs:Zeile 164.
bei DevExpress.XtraBars.BarBaseButtonItem.RaiseDownChanged()
bei DevExpress.XtraBars.BarBaseButtonItem.set_Down(Boolean value)
bei DevExpress.XtraBars.BarBaseButtonItem.Toggle(BarItemLink link)
bei DevExpress.XtraBars.BarBaseButtonItem.OnClick(BarItemLink link)
bei DevExpress.XtraBars.BarItemLink.OnLinkClick()
bei DevExpress.XtraBars.BarItemLink.OnLinkAction(BarLinkAction action, Object actionArgs)
bei DevExpress.XtraBars.BarButtonItemLink.OnLinkAction(BarLinkAction action, Object actionArgs)
bei DevExpress.XtraBars.BarItemLink.OnLinkActionCore(BarLinkAction action, Object actionArgs)
bei DevExpress.XtraBars.ViewInfo.BarSelectionInfo.ClickLink(BarItemLink link)
bei DevExpress.XtraBars.ViewInfo.BarSelectionInfo.UnPressLink(BarItemLink link)
bei DevExpress.XtraBars.Controls.CustomLinksControl.OnMouseUp(MouseEventArgs e)
bei System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
bei System.Windows.Forms.Control.WndProc(Message& m)
bei DevExpress.XtraBars.Controls.DockedBarControl.WndProc(Message& msg)
bei System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
bei System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


----------------------------------------
Devart.Data.MySql
Assembly-Version: 5.70.120.0.
Win32-Version: 5.70.120.0.
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Devart.Data.MySql/5.70.120.0__09af7300eec23701/Devart.Data.MySql.dll.
----------------------------------------
System.Data
Assembly-Version: 2.0.0.0.
Win32-Version: 2.0.50727.4927 (NetFXspW7.050727-4900).
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll.
----------------------------------------
System.Transactions
Assembly-Version: 2.0.0.0.
Win32-Version: 2.0.50727.4927 (NetFXspW7.050727-4900).
CodeBase: file:///C:/Windows/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll.
----------------------------------------
Devart.Data
Assembly-Version: 5.0.81.0.
Win32-Version: 5.0.81.0.
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Devart.Data/5.0.81.0__09af7300eec23701/Devart.Data.dll.
----------------------------------------
Devart.Data.Linq
Assembly-Version: 1.0.33.0.
Win32-Version: 1.0.33.0.
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Devart.Data.Linq/1.0.33.0__09af7300eec23701/Devart.Data.Linq.dll.
----------------------------------------
System.Data.Linq
Assembly-Version: 3.5.0.0.
Win32-Version: 3.5.30729.4926.
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Data.Linq/3.5.0.0__b77a5c561934e089/System.Data.Linq.dll.
----------------------------------------
Devart.Data.MySql.Linq
Assembly-Version: 1.0.33.0.
Win32-Version: 1.0.33.0.
CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Devart.Data.MySql.Linq/1.0.33.0__09af7300eec23701/Devart.Data.MySql.Linq.dll.
----------------------------------------
Crad.Windows.Forms.Actions
Assembly-Version: 1.1.1.0.
Win32-Version: 1.1.1.0.
CodeBase: file:///X:/Projekte/WinFormProjekte/jobbots24/jobbots24.de/bin/Debug/Crad.Windows.Forms.Actions.DLL.

************** JIT-Debuggen **************
Um das JIT-Debuggen (Just-In-Time) zu aktivieren, muss in der
Konfigurationsdatei der Anwendung oder des Computers
(machine.config) der jitDebugging-Wert im Abschnitt system.windows.forms festgelegt werden.
Die Anwendung muss mit aktiviertem Debuggen kompiliert werden.
Top
AndreyR
Devart Team
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Post by AndreyR » Tue 06 Apr 2010 11:15

Could you please send me (support * devart * com, subject "LINQ: Cannot refresh entity") a small test project reproducing the error?
The problem is that we have fixed a bug with the same call stack in the release 5.70.120 version.
Top
Post Reply

Return to “LinqConnect (LINQ to SQL support)”