SQL to Excel

Hi, in the last few weeks we are facing an issue with the plugin failing due to the following error: 

javax.resource.spi.work.WorkCompletedException: java.lang.NoSuchMethodError: org.apache.xmlbeans.XmlCursor.close()V
	at org.springframework.jca.work.SimpleTaskWorkManager$DelegatingWorkAdapter.run(SimpleTaskWorkManager.java:247)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:750)
Caused by: java.lang.NoSuchMethodError: org.apache.xmlbeans.XmlCursor.close()V

Does it seem familiar to you?

Hi, in the last few weeks we are facing an issue with the plugin failing due to the following error: 

javax.resource.spi.work.WorkCompletedException: java.lang.NoSuchMethodError: org.apache.xmlbeans.XmlCursor.close()V
	at org.springframework.jca.work.SimpleTaskWorkManager$DelegatingWorkAdapter.run(SimpleTaskWorkManager.java:247)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:750)
Caused by: java.lang.NoSuchMethodError: org.apache.xmlbeans.XmlCursor.close()V

Does it seem familiar to you?

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.