Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

SAS VA: Could not execute the JDBC batch update

Accepted Solution Solved
Reply
Contributor
Posts: 54
Accepted Solution

SAS VA: Could not execute the JDBC batch update

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

 

 

 


case statement.jpgsas error 1.jpg

Accepted Solutions
Solution
‎04-18-2016 11:14 PM
Occasional Contributor EWS
Occasional Contributor
Posts: 19

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

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

 

 

 

View solution in original post


All Replies
Solution
‎04-18-2016 11:14 PM
Occasional Contributor EWS
Occasional Contributor
Posts: 19

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

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

 

 

 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 563 views
  • 2 likes
  • 2 in conversation