topic Issue Importing MYSQL tables to SAS in Administration and Deployment

Issue Importing MYSQL tables to SAS

CaseK — Mon, 26 Aug 2013 21:56:28 GMT

Hello,

I am trying to read in some fairly large MYSQL datasets (~40GB) with SAS/ACCESS through ODBC. I get the following error:

ERROR: Write Access Violation In Task [ DATASTEP (2) )

Exception occurred at (10025ACF)

Task Traceback

Address Frame (DBGHELP API Version 4.0 rev 5)

10025ACF 039AF7E0 myodbc5a:SQLSetConnectAttr+0x24408

1003005C 039AF7FC myodbc5a:SQLSetConnectAttr+0x2E995

10029B09 039AF830 myodbc5a:SQLSetConnectAttr+0x28442

10028449 039AF84C myodbc5a:SQLSetConnectAttr+0x26D82

100199C8 FFFFFFFF myodbc5a:SQLSetConnectAttr+0x18301

I have read on the SAS site that this may be caused by not having enough memory to allocate, but I'm not sure. Does anyone know a better way to get the data in?

I am running SAS 9.1.3 EG 4.1. The problem seems to be specific to the MYSQL datasets, as I've been able to work with larger datasets that are in SQL Server 2008.

Thanks

Re: Issue Importing MYSQL tables to SAS

SASKiwi — Mon, 26 Aug 2013 23:35:37 GMT

Have you tried searching SAS support? I found this which might help:

http://support.sas.com/kb/16/329.html

Do smaller tables work OK? Are you using EG local server or remote server? What is your SAS memsize setting?

Also worth raising a track with SAS Support for more help.

Re: Issue Importing MYSQL tables to SAS

CaseK — Wed, 28 Aug 2013 22:42:30 GMT

Thanks, I have searched SAS support, but none of the Problem Notes seemed to help.

I'm using EG remote server, with memsize = 0. Smaller tables import fine from the same MySQL server.

I have a request in to change the ODBC settings, hopefully that works.

Thanks for your help,