mirror of
https://github.com/dbeaver/cloudbeaver.git
synced 2026-04-25 05:36:14 +03:00
[GH-ISSUE #3086] Caused by: java.lang.IllegalArgumentException: Invalid char ([) found at index (0) in sheet name '[select 1]' #1110
Labels
No labels
AS
can't reproduce
can't reproduce
deployment
development
documentation
duplicate
duplicate
ee
enhancement
external
new driver
performance
pull-request
third party issue
wait for response
wait for review
wontfix
x:Oracle
x:cassandra
x:clickhouse
x:db2
x:duckdb
x:greenplum
x:h2
x:h2gis
x:hana
x:hive
x:intersystems
x:kyuubi
x:maria
x:mongo
x:mysql
x:postgresql
x:presto
x:sql server
x:sqlite
x:teradata
x:trino
xf:accessibility
xf:administration
xf:ai
xf:authentication
xf:aws
xf:commit-mode
xf:connection
xf:dark theme
xf:data editor
xf:datatransfer
xf:dba
xf:driver management
xf:erd
xf:filters
xf:i18n
xf:i18n
xf:installer
xf:json
xf:kerberos
xf:ldap
xf:local config
xf:log viewer
xf:metadata
xf:metadata editor
xf:navigator
xf:okta
xf:query manager
xf:resource manager
xf:scripts
xf:sql editor
xf:tasks
xf:ui/uix
xo: Firefox
xo:eclipse
xo:internet explorer
xo:macos
xp:major
xrn:internal
No milestone
No project
No assignees
1 participant
Notifications
Due date
No due date set.
Dependencies
No dependencies set.
Reference
starred/cloudbeaver#1110
Loading…
Add table
Add a link
Reference in a new issue
No description provided.
Delete branch "%!s()"
Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?
Originally created by @gdyflxw on GitHub (Nov 20, 2024).
Original GitHub issue: https://github.com/dbeaver/cloudbeaver/issues/3086
Originally assigned to: @HocKu7, @Matvey16 on GitHub.
When I export data from SQL Server using the .xlsx format, it raises an error (the error is described below). And I have tried SQL Server, pg (PostgreSQL), and MySQL; only SQL Server raises the error.
org.jkiss.dbeaver.model.exec.DBCException: Error while exporting table row
at org.jkiss.dbeaver.tools.transfer.stream.StreamTransferConsumer.fetchRow(StreamTransferConsumer.java:247)
at io.cloudbeaver.service.data.transfer.impl.WebServiceDataTransfer$3.fetchRow(WebServiceDataTransfer.java:279)
at org.jkiss.dbeaver.model.sql.data.SQLQueryDataContainer.readData(SQLQueryDataContainer.java:156)
at io.cloudbeaver.service.sql.WebSQLQueryDataContainer.readData(WebSQLQueryDataContainer.java:107)
at org.jkiss.dbeaver.tools.transfer.database.DatabaseTransferProducer.lambda$0(DatabaseTransferProducer.java:271)
at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:192)
at org.jkiss.dbeaver.tools.transfer.database.DatabaseTransferProducer.transferData(DatabaseTransferProducer.java:188)
at io.cloudbeaver.service.data.transfer.impl.WebServiceDataTransfer.exportData(WebServiceDataTransfer.java:332)
at io.cloudbeaver.service.data.transfer.impl.WebServiceDataTransfer$1.run(WebServiceDataTransfer.java:186)
at io.cloudbeaver.model.session.WebSession$1.run(WebSession.java:567)
at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:119)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
Caused by: java.lang.IllegalArgumentException: Invalid char ([) found at index (0) in sheet name '[select 1]'
at org.apache.poi.ss.util.WorkbookUtil.validateSheetName(WorkbookUtil.java:150)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.createSheet(XSSFWorkbook.java:918)
at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet(SXSSFWorkbook.java:712)
at org.jkiss.dbeaver.data.office.export.DataExporterXLSX.createSheet(DataExporterXLSX.java:401)
at org.jkiss.dbeaver.data.office.export.DataExporterXLSX.getWsh(DataExporterXLSX.java:412)
at org.jkiss.dbeaver.data.office.export.DataExporterXLSX.exportRow(DataExporterXLSX.java:427)
at org.jkiss.dbeaver.tools.transfer.stream.StreamTransferConsumer.fetchRow(StreamTransferConsumer.java:242)
... 11 more