topic Re: Error: Table testdata variable ? offset exceeds the varying data buffer. in SAS Viya

Error: Table testdata variable ? offset exceeds the varying data buffer.

AmitSri — Mon, 26 Mar 2018 10:47:47 GMT

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!!

Re: Error: Table testdata variable ? offset exceeds the varying data buffer.

alexal — Mon, 26 Mar 2018 11:00:06 GMT

@AmitSri,

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.

http://support.sas.com/kb/61/928.html

Re: Error: Table testdata variable ? offset exceeds the varying data buffer.

AmitSri — Mon, 26 Mar 2018 11:56:22 GMT

Hi Alex, Thanks for that!!

Yes, As soon as I searched for this error in google, I found this link. I had gone through this link before posting the query. However, I could not understand it, as its stating about a hotfix. How, can I get this hotfix to be done here? I wanted to know about performing the hotfix for this. Thanks!!

Re: Error: Table testdata variable ? offset exceeds the varying data buffer.

alexal — Mon, 26 Mar 2018 12:22:26 GMT

@AmitSri,

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.

Re: Error: Table testdata variable ? offset exceeds the varying data buffer.

AmitSri — Tue, 27 Mar 2018 07:14:48 GMT

Okay...Got it. Thank you Alex!!