Overview
Key Features & Functionality
Hi Team, is there any configurable timeout setting. we are getting error saying "The following error was raised by the Export to Excel function: (conn=2467368) Query execution was interrupted (max_statement_time exceeded)". Can i set it up to 70 or 90 sec for the query to run. Please help.
Hi, Executing query similar to this one returns MariaDB syntax error: SET @pivot_sql = 'SELECT * FROM paqsurveyrawreport'; PREPARE stmt FROM @pivot_sql; EXECUTE stmt; DEALLOCATE PREPARE stmt; Any workaround ?
An error occurred while executing a save: java.lang.NoSuchMethodError: org.apache.xmlbeans.XmlCursor.close()V
We also tried the fix with applying Trim on sql.
Getting the following exception when trying to export 200 columns to an excel:
Exception in thread "ThreadPoolTaskExecutor-329094" java.lang.NoSuchMethodError: org.apache.xmlbeans.XmlCursor.close()V
Hello, we had this problem. We were using the fields "cell keys" and "cells values" and the problem was that some values had unnecessary spaces. We fixed it with a trim in the previous rule that calculates the values.
Try using trim function in your SQL query on text columns which has space in the start of the value. for e.g. your sql query should be something like "SELECT TRIM(ADDRESS) AS Address from ADDRESS_TABLE"
Me too
I am facing the same issue. Is there any update on when it is expected to be solved?
I am facing same issue.