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


ErikC
  •  ErikC
  • Free support Topic Starter
2013-06-28T07:09:24Z
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
Support
2013-06-28T07:15:34Z
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
  •  ErikC
  • Free support Topic Starter
2013-07-01T06:53:37Z
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
  •  ErikC
  • Free support Topic Starter
2013-07-01T07:16:41Z
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
2013-07-01T12:13:13Z
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!
2026-11-02T10:36:08Z
When I originally commented I clicked the -Notify me when new surveys are added- checkbox now when a comment is added I receive four emails with similar comment. Will there be however you possibly can get rid of me from that service? Thanks! situs togel 
2026-11-03T08:53:11Z
Aw, i thought this was an exceptionally good post. In notion I must set up writing like that additionally – taking time and actual effort to produce a very good article… but what / things I say… I procrastinate alot and by no means manage to go completed. EREDETI KAMAGRA RENDELÉS 
2026-11-04T11:24:49Z
Greetings! This is my first visit to your blog! We are a group of volunteers and starting a new project in a community in the same niche. Your blog provided us useful information to work on. You have done a wonderful job! 소액결제 현금화 
2026-11-04T13:37:28Z
This is a good blog. Keep up all the work. I too love to blog. This is great everyone sharing opinions patrickstash 
2026-11-05T09:49:27Z
주소콘에서 필요한 사이트를 분야별로 살펴보세요. 뉴스, 커뮤니티, 영상, 웹툰, 쇼핑, 생활 정보와 온라인 도구를 찾는 방법부터 주소 확인, 즐겨찾기 관리, 접속 오류 해결까지 안내합니다. 목적에 맞는 링크를 고르고 더 편리하게 이용하세요. 주소콘 
2026-11-09T12:44:08Z
What I wouldnt get for possess a controversy along with you relating to this. You just let them know a lot of things that come from nowhere fast in which Internet marketing fairly certain Identity use a fair picture. Your weblog is extremely good creatively, After all people will not be bored stiff. But other people who is able to see past the video clips and also the design will not be thus pleased using your generic knowledge of this specific matter. chatgpt代充 
2026-11-15T13:53:37Z
Outstanding post, I conceive people should larn a lot from this weblog its very user friendly . discount luxury travel packages
2026-11-17T08:22:08Z
Hello. Great job. I did not expect this. This is a excellent articles. Thanks! golf elbow brace 
2026-11-22T12:43:23Z
Nice post. I find out some thing tougher on various blogs everyday. Most commonly it is stimulating to learn to read content from other writers and exercise a specific thing at their store. I’d would prefer to apply certain while using the content on my own blog whether or not you don’t mind. Natually I’ll supply you with a link on your own internet blog. Thank you for sharing. Keo Truc Tuyen 
Scroll to Top