Hi,
I am getting this error while loading a table from Mysql to cas.
We have SAS?ACCESS interface to odbc.Through this, I am trying to pull the data from mysql using a DSN defined in odbc.ini.
here are the queries I used.
caslib sqldata datasource=(srctype="odbc" username="read_only_test_user"
password="xxxxxxxxxxxx" odbc_dsn="MYSQL_DENODO_DIRECT" dm_unicode="utf-16") global;
proc casutil;
list files incaslib="sqldata";
proc casutil;
load casdata="test_portugal" incaslib="SQLDATA"
casout="test_portugal" outcaslib="DBDATA" ;
run;
And im getting the below error:
ERROR: Table test_portugal variable ? offset exceeds the varying data buffer.
ERROR: The action stopped due to errors.
Is this related to the SAS/ACCESS interface. Do we need to have SAS?ACCESSinterface to MySql for this. I hope thats not required as we are anyways connecting to mysql using ODBC DSN.
Please clarify. Thanks!!
Hot Fix is currently under development. When it will be available, you will be able to install it by upgrading package: sas-tkcdfts.x86_64. If you want to add your company name to the defect, open the technical support track.
The error occurs when a row contains an empty or null value for the VARCHAR or VARBINARY option and a large object such as a BLOB or a CLOB. There is no workaround for this issue. A hot fix is planned for this issue.
Hot Fix is currently under development. When it will be available, you will be able to install it by upgrading package: sas-tkcdfts.x86_64. If you want to add your company name to the defect, open the technical support track.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.