Search found 49 matches

Go to advanced search

by claudio.piffer
Thu 21 Apr 2022 16:56
Forum: Universal Data Access Components
Topic: Oracle strange exception
Replies: 1
Views: 1426

Oracle strange exception

Hi,

I have a service with UniDAC and EntityDAC. All work fine but today it raise this exception (Even restarting the service does not change the situation)

Exception EUniError: NET: Assertion failure (D:\ProjectsClone1\Delphi\Dac\Oracle\Source\OraNetClasses.pas, line 2064)

The connection with Oracle is up and running. Before raising this exception, the service connects to the DB and executes queries correctly.

What I don't understand is why it raises an Assertion failure on an ODAC unit (which I didn't install in this Delphi installation).

OraNetClasses.pas is a unit of ODAC component. In uniDAC the unit is named OraNetClassesUni.pas.

I see in ODAC source (I use it in another version of delphi on another vm) but on line 2064 there is no assertion (I saw that the source code of the indicated unit is "obfuscated").

I use uniDAC pro version 9.1.1 (tomorrow I upgrade to version 9.2.1) and EntityDAC version 3.0.2

Any help?

Thank you very much!
by claudio.piffer
Sat 23 Oct 2021 08:21
Forum: EntityDAC
Topic: EntityDeveloper error
Replies: 8
Views: 24268

Re: EntityDeveloper error

Hi Maxim

how I can update EntityDeveloper? You must create a new version of EntityDAC with EntityDeveloper updated?

Thank you very much
by claudio.piffer
Wed 20 Oct 2021 13:24
Forum: EntityDAC
Topic: EntityDeveloper error
Replies: 8
Views: 24268

Re: EntityDeveloper error

Only for info:

In Windows 10 the update to uninstall is KB5006670
In Windows 11 the update to uninstall is KB5006674

After uninstalled related KB update the EntityDeveloper work fine

Best Regards
by claudio.piffer
Wed 20 Oct 2021 13:10
Forum: EntityDAC
Topic: EntityDeveloper error
Replies: 8
Views: 24268

Re: EntityDeveloper error

Hi Maxim!

You are my hero! Yes! I uninstalled the KB5006670 update and EntityDeveloper work fine!!

Great and thank you very much!!
by claudio.piffer
Wed 20 Oct 2021 08:01
Forum: EntityDAC
Topic: EntityDeveloper error
Replies: 8
Views: 24268

Re: EntityDeveloper error

Any news?

I'm stopped! I need to an urgent solution! EntityDeveloper is unusable!

Best Regards
by claudio.piffer
Mon 18 Oct 2021 07:30
Forum: EntityDAC
Topic: EntityDeveloper error
Replies: 8
Views: 24268

Re: EntityDeveloper error

Hi

this is a serious problem. I'm stopped.

Can you solve this?

Thank you very much
by claudio.piffer
Sat 16 Oct 2021 13:07
Forum: EntityDAC
Topic: EntityDeveloper error
Replies: 8
Views: 24268

EntityDeveloper error

Hi

I use last version of EntityDAC and when I try to open EntityDAC Developer it raise this error (same error in Windows 10 and Windows 11):

An item with the same key has already been added.

I'm not opening any schema but only run the application

This is the call stack:

=========================
General
=========================
Application: Entity Developer
Product: Entity Developer
Product Locale: English
Assembly: EntityDeveloper, Version=6.4.775.0, Culture=neutral, PublicKeyToken=09af7300eec23701
D:\CtrlD11.0Alexandria\Devart\EntityDAC\EntityDeveloper\EntityDeveloper.exe
Global cache: False
Framework: 4.0.30319.42000

=========================
Exception Information
=========================
Message: Exception has been thrown by the target of an invocation.
Source: mscorlib
TargetSite: System.Object CreateInstance(System.RuntimeType, Boolean, Boolean, Boolean ByRef, System.RuntimeMethodHandleInternal ByRef, Boolean ByRef)
HelpLink:
Type: System.Reflection.TargetInvocationException
Stack:
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
at System.Activator.CreateInstance[T]()
at EntityDeveloper.NetShell.EntityDeveloperModule.ToolWindowCreatableControl`1.CreateControl()
at EntityDeveloper.NetShell.EntityDeveloperModule.CreateToolWindowControl(Guid windowId)
at Devart.Shell.Studio.StudioToolWindow.CreateHostedControl()

Message: An item with the same key has already been added.
Source: mscorlib
TargetSite: Void ThrowArgumentException(System.ExceptionResource)
HelpLink:
Type: System.ArgumentException
Stack:
at System.ThrowHelper.ThrowArgumentException(ExceptionResource resource)
at System.Collections.Generic.Dictionary`2.Insert(TKey key, TValue value, Boolean add)
at System.Collections.ObjectModel.KeyedCollection`2.AddKey(TKey key, TItem item)
at System.Collections.ObjectModel.KeyedCollection`2.InsertItem(Int32 index, TItem item)
at System.Collections.ObjectModel.Collection`1.Add(T item)
at Devart.Diagram.DiagramPalette.GetCenterPen(Color color, Dimension width)
at Devart.Diagram.DiagramPalette..ctor(ViewService viewService)
at Devart.Diagram.ViewService..ctor(DiagramOptions options)
at Devart.Diagram.Diagram..ctor(String diagramTypeId, IServiceProvider parentProvider)
at Devart.Diagram.Overview.OverviewAddIn..ctor()
at EntityDeveloper.DiagramOverviewControl..ctor()

=========================
Window Layout
=========================
Active document window: 'Start Page' (tabbed toolwindow)
No documents

Toolwindows (visible or have been shown in current session):
Caption: 'Model Explorer', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Docked
Caption: 'Start Page', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Tabbed
Caption: 'Properties', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Docked
Caption: 'Database Explorer', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'True', State: Docked
Caption: 'Diagram Overview', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'False', State: Docked
Caption: 'Error List', Visible: 'True', DefaultVisibility: 'Always', IsControlCreated: 'False', State: Docked

=========================
Loaded Assemblies
=========================
mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
EntityDeveloper, Version=6.4.775.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.4.775.0 D:/CtrlD11.0Alexandria/Devart/EntityDAC/EntityDeveloper/EntityDeveloper.exe
EntityDeveloper.Common, Version=6.4.775.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.4.775.0 D:/CtrlD11.0Alexandria/Devart/EntityDAC/EntityDeveloper/EntityDeveloper.Common.DLL
Devart.Shell.Interfaces.ED, Version=1.4.20.1, Culture=neutral, PublicKeyToken=09af7300eec23701 1.4.20.1 D:/CtrlD11.0Alexandria/Devart/EntityDAC/EntityDeveloper/Devart.Shell.Interfaces.ED.DLL
System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
EntityDeveloper.Orm.Common, Version=6.4.775.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.4.775.0 D:/CtrlD11.0Alexandria/Devart/EntityDAC/EntityDeveloper/EntityDeveloper.Orm.Common.DLL
System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
System.Configuration, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 4.0.0.0 C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
EntityDeveloper.Orm.EntityDAC, Version=6.4.775.0, Culture=neutral, PublicKeyToken=09af7300eec23701 6.4.775.0 D:/CtrlD11.0Alexandria/Devart/EntityDAC/EntityDeveloper/EntityDeveloper.Orm.EntityDAC.DLL
Devart.Shell.Studio.ED, Version=1.4.20.1, Culture=neutral, PublicKeyToken=09af7300eec23701 1.4.20.1 D:/CtrlD11.0Alexandria/Devart/EntityDAC/EntityDeveloper/Devart.Shell.Studio.ED.DLL
Devart.Shell.Utils.ED, Version=1.4.20.1, Culture=neutral, PublicKeyToken=09af7300eec23701 1.4.20.1 D:/CtrlD11.0Alexandria/Devart/EntityDAC/EntityDeveloper/Devart.Shell.Utils.ED.DLL
System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
Devart.Shell.CommonRes.ED, Version=1.4.20.1, Culture=neutral, PublicKeyToken=09af7300eec23701 1.4.20.1 D:/CtrlD11.0Alexandria/Devart/EntityDAC/EntityDeveloper/Devart.Shell.CommonRes.ED.DLL
Devart.XBars.v9.3, Version=9.3.11.1, Culture=neutral, PublicKeyToken=09af7300eec23701 9.3.11.1 D:/CtrlD11.0Alexandria/Devart/EntityDAC/EntityDeveloper/Devart.XBars.v9.3.DLL
Devart.XEditors.v9.3, Version=9.3.11.1, Culture=neutral, PublicKeyToken=09af7300eec23701 9.3.11.1 D:/CtrlD11.0Alexandria/Devart/EntityDAC/EntityDeveloper/Devart.XEditors.v9.3.DLL
Devart.XData.v9.3, Version=9.3.11.1, Culture=neutral, PublicKeyToken=09af7300eec23701 9.3.11.1 D:/CtrlD11.0Alexandria/Devart/EntityDAC/EntityDeveloper/Devart.XData.v9.3.DLL
Devart.XUtils.v9.3, Version=9.3.11.1, Culture=neutral, PublicKeyToken=09af7300eec23701 9.3.11.1 D:/CtrlD11.0Alexandria/Devart/EntityDAC/EntityDeveloper/Devart.XUtils.v9.3.DLL
Devart.Shell.Controls.ED, Version=1.4.20.1, Culture=neutral, PublicKeyToken=09af7300eec23701 1.4.20.1 D:/CtrlD11.0Alexandria/Devart/EntityDAC/EntityDeveloper/Devart.Shell.Controls.ED.DLL
System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 4.0.0.0 C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
Devart.Studio.Help.ED, Version=1.4.20.1, Culture=neutral, PublicKeyToken=09af7300eec23701 1.4.20.1 D:/CtrlD11.0Alexandria/Devart/EntityDAC/EntityDeveloper/Devart.Studio.Help.ED.DLL
Devart.XTreeList.v9.3, Version=9.3.11.1, Culture=neutral, PublicKeyToken=09af7300eec23701 9.3.11.1 D:/CtrlD11.0Alexandria/Devart/EntityDAC/EntityDeveloper/Devart.XTreeList.v9.3.DLL
Devart.Diagram, Version=1.20.0.98, Culture=neutral, PublicKeyToken=09af7300eec23701 1.20.0.98 D:/CtrlD11.0Alexandria/Devart/EntityDAC/EntityDeveloper/Devart.Diagram.DLL
Devart.Ole.UndoManager, Version=1.0.878.0, Culture=neutral, PublicKeyToken=09af7300eec23701 1.0.878.0 D:/CtrlD11.0Alexandria/Devart/EntityDAC/EntityDeveloper/Devart.Ole.UndoManager.DLL

=========================
System Information
=========================
Wow64 detected.
Processor architecture: amd64
Processor quantity: 4
Intel(R) Core(TM) i7-9700K CPU @ 3.60GHz Intel64 Family 6 Model 158 Stepping 12
Intel(R) Core(TM) i7-9700K CPU @ 3.60GHz Intel64 Family 6 Model 158 Stepping 12
Intel(R) Core(TM) i7-9700K CPU @ 3.60GHz Intel64 Family 6 Model 158 Stepping 12
Intel(R) Core(TM) i7-9700K CPU @ 3.60GHz Intel64 Family 6 Model 158 Stepping 12

Total physical memory: 8190Mb
Available virtual memory: 5968Mb

Operating System Name: Windows 10 Enterprise
Operating System Version: Microsoft Windows NT 6.2.9200.0
UAC: Enabled
Elevation Level: Default

Instances: 1
Culture: Italian (Italy)
Process started at 10/16/2021 14:57:48
Report created at 10/16/2021 14:57:50
by claudio.piffer
Tue 28 Sep 2021 17:04
Forum: EntityDAC
Topic: Delphi 11 Alexandria
Replies: 3
Views: 15306

Re: Delphi 11 Alexandria

Hi MaximG

great!!! Thank you very much!!!!
by claudio.piffer
Tue 14 Sep 2021 16:36
Forum: EntityDAC
Topic: Delphi 11 Alexandria
Replies: 3
Views: 15306

Delphi 11 Alexandria

Hi,

when you will release the installer for Alexandria?

As soon as available, I take up the API project again, redo all the tests for check then memory leaks and, if necessary, I send you a complete test project

Thank you very much!
by claudio.piffer
Wed 09 Jun 2021 23:16
Forum: EntityDAC
Topic: Memory Management
Replies: 4
Views: 19533

Re: Memory Management

Hi

sorry, after some other test, I found this memory leaks

https://drive.google.com/file/d/172gpth ... sp=sharing

i need a solution! This memory leak is giving me a lot of problems.

Another (little) problem is an access violation in this method:

function TUnmappedMetaTypeList.Find(const MetaAttributeDescs: TMetaAttributeDescs): TUnmappedMetaType;

unit EntityDAC.MetaData;
by claudio.piffer
Wed 09 Jun 2021 06:37
Forum: EntityDAC
Topic: Memory Management
Replies: 4
Views: 19533

Re: Memory Management

Hi,

no answer yet?

I need to URGENTsolutions for this problem. Why does the memory keep growing? Is there anything I need to do to avoid this? There are no memory leaks but the memory continues to grow!

Thank you
by claudio.piffer
Mon 24 May 2021 09:11
Forum: EntityDAC
Topic: Memory Management
Replies: 4
Views: 19533

Re: Memory Management

This is a very sample code only for test:

Code: Select all

  
var
  LContext: TRISDataContext;
  LOrdersExpression: IVOrdersReportExpression;
  LQuery: ILinqQueryable;
  LOrders: IObjectEnumerable< TVOrdersReport >;

  LStudiesExpression: IVAccessionNumberStudyExpression;
  LStudies: IObjectEnumerable< TVAccessionNumberStudy >;

begin
  for var LIndex: Integer := 0 to 1000 do
  begin
    LContext := TRISDataContext.Create(nil);
    LContext.Options.Cache.Enabled := False;
    LContext.Connection := EntityConnection1;
    try
      LOrdersExpression := LContext.VOrdersReport;
      LQuery := Linq.From(LOrdersExpression)
        .Where(LOrdersExpression.PkReport = 20178662)
        .Select();

      LOrders := LContext.GetEntities< TVOrdersReport >(LQuery);

      LStudiesExpression := LContext.VAccessionNumberStudy;
      LQuery := Linq.From(LStudiesExpression)
        .Where(LStudiesExpression.AccessionNumber = '30150343')
        .Select();

      LStudies := LContext.GetEntities< TVAccessionNumberStudy >(LQuery);

      TThread.Sleep(10);
    finally
      LContext.Free;
    end;
  end;
I execute many times this sample procedure, The initial memory allocated is 16 Mb. After running the code a few times the memory allocated is 60 Mb. As you can see in the code each loop destroys the context and recreates it this does not free the allocated memory

In this video you can see what happens:

https://drive.google.com/file/d/1VGbOQP ... sp=sharing

Could you give me feedback quite urgently
by claudio.piffer
Mon 24 May 2021 08:42
Forum: EntityDAC
Topic: Memory Management
Replies: 4
Views: 19533

Memory Management

Hi,

I have developed a REST service with EntityDAC / UniDAC on Oracle. Since the services are backend to backend I have disabled the cache to be able to control and manage the memory.
I create and destroy the context at each use and the Context has the option Options.Cache.Enable: = False

Despite this, the memory continues to grow. Faced with the destruction of the contex, the memory is not freed. This is a big problem because after a few weeks I am forced to restart the service!

I have also activated the verification of memory leaks and there are none. When the application is closed, everything is closed correctly

I have reported other issues for the past 5 months and have not yet received an answer. At this point if I can't solve this memory problem I'm forced to throw away the project and do it again!
by claudio.piffer
Fri 05 Mar 2021 08:14
Forum: EntityDAC
Topic: URGENT: Oracle, EntityDAC and UniDAC
Replies: 7
Views: 21437

Re: URGENT: Oracle, EntityDAC and UniDAC

Hi,

any news?

....more than a month has passed!
by claudio.piffer
Mon 01 Feb 2021 10:13
Forum: EntityDAC
Topic: URGENT: Oracle, EntityDAC and UniDAC
Replies: 7
Views: 21437

Re: URGENT: Oracle, EntityDAC and UniDAC

Any news?

Thank you very much

Go to advanced search