ERROR: The character variable char has too long a value for the DLIB library

[milind3889]

I had tried this also. I got same error.

[Ksharp]

OK. Running the following code and see what happened.

data mtest2(drop=i);
do i=1 to 10;
aaaa=i;
bbbb=i*i;
xxxx="abc";
output;
end;
run;


options sastrace=',,,d' sastraceloc=saslog ;
proc sql;
create table dlib.mtest2 as
select * from mtest2;
quit;

[milind3889 · Accepted solution]

I got solution for this issue. This issues was related to latest version of redshift ODBC driver 1.4. 

I uninstalled this driver and installed redshift ODBC drive 1.3. After this change, it worked well. 

[prashantpare]

Hi,

Am facing the same issue with Redshift ODBC driver 1.4.2. And am unable to find the Redshift ODBC driver 1.3 to download anywhere on the AWS website. Any suggestions or link to download it?

Any other option that can help resolve the issue?

[BarryParish2]

Same issue with same ERROR message.  Could not resolve, but was able to get around using the below append method instead.  Exact same data that return error message using original methods. 

/* works */

proc datasets library= dbIndLab;
append base = wlslog3 data = work.testData2;
run;

/* error */

ERROR: The character variable category has too long a value for the DBINDLAB library.
proc sql;
INSERT INTO dbIndLab.wlslog3
SELECT * FROM work.testData3;
quit;

/* error */

ERROR: The character variable category has too long a value for the DBINDLAB library.
proc sql;
INSERT INTO dbIndLab.wlslog3 (id,category,type,servername,code,msg)
SELECT id,substr(category,25) as category,type,servername,code,msg FROM work.testData3;
quit;

/* error */

ERROR: The character variable category has too long a value for the DBINDLAB library.
data dbIndLab.wlslog4;
set work.testData3;
run;

/* also works */
proc sql;
INSERT INTO dbIndLab.wlslog3 (id,category,type,servername,code,msg)
VALUES (199,'categoryX','typeX','servernameX','codeX','msgX');
quit;