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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!