[longlam]

I’m getting this error at result 10,000 from one of my reports that use to work just fine.

Here is the error message:

Database Connector Error: ‘00000:[OpenAccess][OpenRDA ODBC]No error [Database Vendor Code:52509]’

This report usually takes around 20 minutes or so to run. Does Netsuite have any sort of record limits that I don’t know about?
This is a cached copy. Click here to see the original post.

[ivan.parra]

RE: Weird Connections Error

Can you please file a case and attach the SQL you are running? Thank you.

NetSuite has an internal page size limit of 10,000 rows, but we send multiple pages. We have successfully returned millions of rows in Excel, Aquodata Studio, Crystal and a few command line tools. I’d like to recreate this issue so that I can appropriately address the problem.

-Ivan

[longlam]

RE: Weird Connections Error

Will do. I think the issue lies in the fact that we can’t do sub queries using the current ODBC driver, there was a thread about this earlier that wasn’t resolved. The way we are doing it instead in Crystal Reports is by doing a command line sql and appending the result set to existing table information. Things that have taken me a few minutes to run are now taking 20-30 minutes. I will post the case # once I submit it.

[Author]

Posts