Optimize IT resource capacity and performance with SAS

Issue Importing MYSQL tables to SAS

Reply
New Contributor
Posts: 2

Issue Importing MYSQL tables to SAS

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  myodbc5aSmiley FrustratedQLSetConnectAttr+0x24408

1003005C  039AF7FC  myodbc5aSmiley FrustratedQLSetConnectAttr+0x2E995

10029B09  039AF830  myodbc5aSmiley FrustratedQLSetConnectAttr+0x28442

10028449  039AF84C  myodbc5aSmiley FrustratedQLSetConnectAttr+0x26D82

100199C8  FFFFFFFF  myodbc5aSmiley FrustratedQLSetConnectAttr+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

Respected Advisor
Posts: 3,065

Re: Issue Importing MYSQL tables to SAS

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.

New Contributor
Posts: 2

Re: Issue Importing MYSQL tables to SAS

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,

Ask a Question
Discussion stats
  • 2 replies
  • 334 views
  • 3 likes
  • 2 in conversation