This project has moved. For the latest updates, please go here.

Problem in parsing More than 10 MB file.

Apr 16, 2014 at 7:39 AM
Hi dstrubhar,

Im using your OppFactory for parsing EDI 837 files. That file size is more than 10 MB. When i parsing the file, Im getting the Memory out of Exception . Please guide me to solve the issue and also i have seen some other threads regarding this issue. You replied like "There is a batch size setting in the app.config " to solve this issue. But i dont have Appconfig file to resolve. Please advise me to use appconfig and solve the issue.


Thanks,
Gnanadesigan K
Coordinator
Apr 16, 2014 at 3:08 PM
If you are parsing 837s out of the box you are either using the X12Parser.exe or the OopFactory.X12.Hipaa.ClaimParser.exe. By convention in .NET when we refer to app.config it really means the config with the same name as the exe.

If you are using X12Parser.exe the the config file would be X12Parser.exe.config. Your windows explorer should identify it as an XML Configuration File rather than an Application. The app setting is MAxBatchSize.

It appears that I have not added that app setting to the ClaimParser.exe, so this would require a code change if this is where you need to be able to batch.

Another way to solve your problem would be to use the UnbundleX12.exe and break the file into smaller files (probably by ST transaction), than you can run the individual files through the ClaimParser.exe without waiting for a change.

I personally use SQL Server so most of my parses go into a SQL Server database using the OopFactory.X12.ImportX12.exe described here (https://x12parser.codeplex.com/wikipage?title=Sql%20Server%20Database%20Integration). The out of memory exception occurs when it loads the xslt to transform to XML and has to render the entire file as XML. Loading into SQL directly avoids needing that transformation at all. This might not be an option for you if all if your code already expects the XML or the ClaimDocument object.
Apr 21, 2014 at 7:52 AM
Hi dstrubhar,

Do you have code that included of appconfig in your code, if So please share. I will try to sort it out either Unbundle and sqlserver Mode. Can you explain how to configure the sqlserver ?