SAS VA: Could not execute the JDBC batch update

Carrot17 — Wed, 13 Apr 2016 01:57:47 GMT

Hi Experts,

Anyone here knows the "server error: could not execute JDBC batch update"? For additional information, we encountered this error when saving case statement with more than 5 statements comparison and the query validation is valid. Please find attached error and case statement.

Best Regards,

Carrot17

Re: SAS VA: Could not execute the JDBC batch update

EWS — Fri, 15 Apr 2016 12:10:24 GMT

Hi Carrot17,

When your statement contains more then 1024 characters system will fail to execute the expression. Validation works fine but you vannot run the query.

http://support.sas.com/kb/51/510.html

topic SAS VA: Could not execute the JDBC batch update in SAS Visual Analytics

SAS VA: Could not execute the JDBC batch update

Re: SAS VA: Could not execute the JDBC batch update