[6.2.2] System.OutOfMemoryException - VisualCron

Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.

Welcome Guest! To enable all features please Login or Register.

ErikC
Free support Topic Starter

12 years ago

Hi,

I had this before, reading an Excel file generates an out of memory exception.
Yesterday again and I had to restart the server to get VC up and running again.

6/27/2013 9:03:54 AM	Err	Error saving jobfile: System.InvalidOperationException: There was an error generating the XML document. ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
   at System.Number.FormatDouble(Double value, String format, NumberFormatInfo info)
   at System.Xml.XmlConvert.ToString(Double value)
   at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationWriterJobClassArray.Write85_TaskStatsClass(String n, String ns, TaskStatsClass o, Boolean isNullable, Boolean needType)
   at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationWriterJobClassArray.Write442_TaskClass(String n, String ns, TaskClass o, Boolean isNullable, Boolean needType)
   at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationWriterJobClassArray.Write445_JobClass(String n, String ns, JobClass o, Boolean isNullable, Boolean needType)
   at Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationWriterJobClassArray.Write446_ArrayOfJobClass(Object o)
   --- End of inner exception stack trace ---
   at System.Xml.Serialization.XmlSerializer.Serialize(XmlWriter xmlWriter, Object o, XmlSerializerNamespaces namespaces, String encodingStyle, String id)
   at OBOKIIHBDBPMCFALPGECCIFHCDJPEDKODDGK.GHAMFGCEDFOEIDCMEENNAFIOCECPBDKLJMLG.FCKIFCEPFBIFEKINIIGIEHLEGDKONOFFKELJ(String , List`1 lstIncludeOnly, Boolean )

I'm reading three columns of a specific sheet. This took 157 seconds.
Today the task went fine and took 220 seconds to complete.

It takes a lot of time, I think this has to do with lookups in the excel file. Isn't there a better way handling this? a Sheet without lookups takes a few seconds...

Regards,
Erik

Uses Visualcron since 2006.

Sponsor

Forum information

Wanna join the discussion?! Login to your Forum forum account or Register a new forum account

Support
Official support

12 years ago

Sounds like there is a memory leak in the Excel component or in our implementation of it. When you run this - how is memory affected?

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!

ErikC
Free support Topic Starter

12 years ago

Hi Henrik,

Today I looked at the memory usage of the VisualCronService.exe:

29 Mb - idle
614 Mb - running Excel task
45 Mb - idle
running Excel task
302 Mb - idle
.. after some minutes ..
32 Mb - idle

Last friday I had again an out of memory:

6/28/2013 9:37:58 PM	Err	An unhandled error has occured (please send the information below to support@visualcron.com):

Server version: 6.2.2.14786 - (2013-04-10 09:36:46)
Protocol: 6.1.7
OS: Windows2003
Architecture: x86


System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
   at System.Threading.Thread.StartInternal(IPrincipal principal, StackCrawlMark& stackMark)
   at System.Threading.Thread.Start(StackCrawlMark& stackMark)
   at System.Threading.Thread.Start()
   at OBOKIIHBDBPMCFALPGECCIFHCDJPEDKODDGK.NGCCHFEFCLIGHJNAJNHPHMGIFKPMHBAEDJDG.BICEPINJBIKOMFOMCHOKPFACPEIBPIHEKMEP(JobClass , TaskClass , NotificationClass , TaskStatsClass )
   at OBOKIIHBDBPMCFALPGECCIFHCDJPEDKODDGK.NGCCHFEFCLIGHJNAJNHPHMGIFKPMHBAEDJDG.BAMFMGFJEGCDFIFJDLPGGGLKNFKAKPBNJPIF(JobClass , TaskClass , TaskStatsClass , Boolean )
   at OBOKIIHBDBPMCFALPGECCIFHCDJPEDKODDGK.NGCCHFEFCLIGHJNAJNHPHMGIFKPMHBAEDJDG.EMAEKOKEGECJICOBJOMADGHNLJAMJHHHHEBC(TaskProcessClass )
   at OBOKIIHBDBPMCFALPGECCIFHCDJPEDKODDGK.CCEDIKOJOACMABGAIHHOHPJCDMJPDMLJKHNK.BIKHMHFBJJMBIEBBONCGOFGNHCFLLDODFPBH.Invoke(TaskProcessClass tpc)
   at OBOKIIHBDBPMCFALPGECCIFHCDJPEDKODDGK.CCEDIKOJOACMABGAIHHOHPJCDMJPDMLJKHNK.FPDFJBKIDPGOHFPMFHLFLCAEFAPNIPNIICAI()
   at OBOKIIHBDBPMCFALPGECCIFHCDJPEDKODDGK.OFLFDCMHONPFIPBDMCNJBDDBBMOMHNCKPHME.Dispose(Boolean )
   at OBOKIIHBDBPMCFALPGECCIFHCDJPEDKODDGK.OFLFDCMHONPFIPBDMCNJBDDBBMOMHNCKPHME.Dispose()
   at OBOKIIHBDBPMCFALPGECCIFHCDJPEDKODDGK.OFLFDCMHONPFIPBDMCNJBDDBBMOMHNCKPHME.Run()
   at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean ignoreSyncCtx)
   at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
   at System.Threading.ThreadHelper.ThreadStart()

This error came out of the blue. There were no excel tasks running at that time.

Regards
Erik

Uses Visualcron since 2006.

ErikC
Free support Topic Starter

12 years ago

I also have this is my trayclient logs:

6/28/2013 4:03:40 PM		Connected to Server
6/28/2013 9:38:49 PM		Connecting to VisualCron Server
6/28/2013 21:39:13		Connecting to VisualCron Server
6/28/2013 9:39:18 PM		Ping failed, ex: System.NullReferenceException: Object reference not set to an instance of an object.
   at BOANPKPNPJHOGNCDNBHABJKPDJLGJNAGHADB.BFKKBFHNMCPNGKDAMGHAALAAGFILDGDNGLPK.AENHFKOMDOELCJJKFJCDPBLMPIFDPLMEIOHL(Object )
   at BOANPKPNPJHOGNCDNBHABJKPDJLGJNAGHADB.BFKKBFHNMCPNGKDAMGHAALAAGFILDGDNGLPK.CABHALEMBBLGLBEJGAOMNEDLNCGBBIADJFIE()
6/28/2013 9:39:18 PM		Error in PingCheck, err: System.NullReferenceException: Object reference not set to an instance of an object.
   at BOANPKPNPJHOGNCDNBHABJKPDJLGJNAGHADB.BFKKBFHNMCPNGKDAMGHAALAAGFILDGDNGLPK.AENHFKOMDOELCJJKFJCDPBLMPIFDPLMEIOHL(Object )
   at BOANPKPNPJHOGNCDNBHABJKPDJLGJNAGHADB.BFKKBFHNMCPNGKDAMGHAALAAGFILDGDNGLPK.FJICFLCONLLFDJMFDIBNCOIEEOLLFFJJPBIL(Object )
6/28/2013 21:39:41		Ping failed, ex: System.NullReferenceException: Object reference not set to an instance of an object.
   at BOANPKPNPJHOGNCDNBHABJKPDJLGJNAGHADB.BFKKBFHNMCPNGKDAMGHAALAAGFILDGDNGLPK.AENHFKOMDOELCJJKFJCDPBLMPIFDPLMEIOHL(Object )
   at BOANPKPNPJHOGNCDNBHABJKPDJLGJNAGHADB.BFKKBFHNMCPNGKDAMGHAALAAGFILDGDNGLPK.CABHALEMBBLGLBEJGAOMNEDLNCGBBIADJFIE()
6/28/2013 21:39:41		Error in PingCheck, err: System.NullReferenceException: Object reference not set to an instance of an object.
   at BOANPKPNPJHOGNCDNBHABJKPDJLGJNAGHADB.BFKKBFHNMCPNGKDAMGHAALAAGFILDGDNGLPK.AENHFKOMDOELCJJKFJCDPBLMPIFDPLMEIOHL(Object )
   at BOANPKPNPJHOGNCDNBHABJKPDJLGJNAGHADB.BFKKBFHNMCPNGKDAMGHAALAAGFILDGDNGLPK.FJICFLCONLLFDJMFDIBNCOIEEOLLFFJJPBIL(Object )

Regards,
Erik

Uses Visualcron since 2006.

Support
Official support

12 years ago

This error happens when trying to run a notification after a File write Task. Not sure if related or a general memory problem but perhaps you can try to re-run the Job which this Task is in.

The Tray client logs are ok because whenever a crash like that happens the service is restarted which results in these errors when trying to reconnect in the Tray Client.

Henrik
Support
http://www.visualcron.com
Please like VisualCron on facebook!