Troubleshooting
For troubleshooting articles. Predominantly problem / error, and workaround / solution.
- Troubleshooting "INVALID_ARGUMENT: Unable to get query profile. Profile not found for the given queryId."
- Troubleshooting "waited too long in the command pool"
- Troubleshooting "java.io.IOException: Connection reset by peer"
- Queries against Hive 2 tables fail with "java.lang.NoSuchMethodError: 'sun.misc.Cleaner sun.nio.ch.DirectBuffer.cleaner()"
- Queries to an Oracle source fail with the error "ORA-00910: specified length too long for its datatype"
- MongoDB data source creation fails with "Connection to Mongo failed. No collections were visible."
- MongoDB data source creation fails with "Could not find/access authentication database"
- "java.lang.NoSuchMethodError: java.nio.ByteBuffer.rewind()Ljava/nio/ByteBuffer" running Arrow Flight SQL JDBC client
- Troubleshoot: Coordinator Pod Restarting Linked to ZooKeeper
- Error when uploading to files to home space when fs.s3a.buffer.dir is inaccessible
- StringIndexOutOfBoundsException: Not enough space to pivot single record
- Using wildcards in query paths
- "Unable to coerce from the file's data type 'int64' to the column's data type 'timestamp'" error when reading Parquet dataset
- Sources missing post Dremio upgrade
- ERROR: "IllegalStateException: Record count not set for this vector container"
- Dremio UI can report "not found" when a non-admin user accesses a folder or dataset that they have inherited SELECT privileges on
- PERMISSION ERROR: Not authorized to use external query.
- CTE fails with NullPointerException but Individual Queries from the CTE Run
- Hostname errors in Dremio Cloud
- Dremio Users Unable to Navigate and see Views despite Correct Privileges
- Engines fail to start executors with "Execution nodes didn't start within the start timeout" in v25.x
- HANDSHAKE_COMMUNICATION error when using JayDeBeApi library to connect to Dremio
- Job failing with the error "List field 'value' exceeded the maximum number of elements 4196, actual number of elements is 4457"
- Handling Field Size Limit Errors When Querying sys.jobs_recent
- Algebraic reflection matching can cause excessive heap usage on queries with many joins
- Column limitation - Error: At most 800 columns including leaf level fields of complex type are allowed to be scanned
- Drop tables on object storage sources is not deleting the folder path
- SYSTEM ERROR: GandivaException - Failed to cast the string <string value> to int64_t
- October Power BI release of the Connector for Dremio causing queries to fail with "String value resulted in invalid numeric."
- HOW TO: Create and Manage Roles in Dremio