Out of memory error

[gabriel_schroedter]

Out of memory error comes up when trying to connect to data when trying to through a webpage, we have connected to this before.

Customer is using Crystal Reports 2013

[Former Member]

So what I am trying to do is create a simple stacked bar chart (Number of Prescriptions by Month Filled and Drug Class). I am connected to the database via ODBC (RDO). In order to connect to the stored procedure in this database on the server, I also have to be logged into Pulse Secure JVPN.

On Friday, I was able to preview the results (18 million records) with no problem. On Monday, I started receiving this "Out of Memory" error. It taps out at 4.7 million records.

I am using CR 2013 SP7 Version 14.1.7.1853.

My PC is an Intel i7 64-bit 3.6 GHz and has 2 internal HDD (500 GB and 2 TB) and 16 GB RAM.

When the "Out of Memory" error box pops up, the Task Manager says only 29% of the RAM is being used.

[former_member11696]

Out of memory is being passed to you through Crystal, it doesn't mean CR is running out of memory. Our database Drivers are Dynamic, meaning we support whatever the client supports. If the client runs out of memory we simply pass that error through to you.

Appears you may be using a Java JDBC connection or Java based VPN client. Talk to the people who support it and see if you can extend the memory to 1 Gig or something like that.

18 mil records is a lot but CR can handle it.

Odd that OLE DB works which shows it's not a CR issue, and also indicates it's an ODBC or VPN client issue.

YOu could try SQLCON or some other ODBC tool, copy the Query from CR and paste it into the ODBC test tool and see what happens.

Microsoft has a tool called ODBCTest, just connect and run SQL and paste in from the report and see what happens.

Don

[former_member11696]

What SDK are you using in your application?

[Former Member]

SQL stored procedure

[Former Member]

Service packs through 7 have been installed.

[former_member11696]

Crystal Reports does not have a WEB page, it's a 32 bit application running on your desktop.