# Dremio 3.0 - oracle data source - maxClauseCount is set to 1024 **URL:** \ **Category:** Uncategorized\ **Created:** [November 2, 2018, 7:51pm UTC](https://community.dremio.com/t/dremio-3-0-oracle-data-source-maxclausecount-is-set-to-1024/2163 "2018-11-02T19:51:48Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![bharath\_natarajan](https://avatars.discourse-cdn.com/v4/letter/b/94ad74/32.png) [@bharath\_natarajan](https://community.dremio.com/u/bharath_natarajan)\ **Post date:** [November 2, 2018, 7:51pm UTC](https://community.dremio.com/t/dremio-3-0-oracle-data-source-maxclausecount-is-set-to-1024/2163/1 "2018-11-02T19:51:48Z")
Cannot connect to a reasonable big database in Oracle. Getting this error when trying to open up the schema - maxClauseCount is set to 1024 ---
**Author:** ![ben](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/ben/32/1367_2.png) [@ben](https://community.dremio.com/u/ben)\ **Post date:** [November 2, 2018, 8:16pm UTC](https://community.dremio.com/t/dremio-3-0-oracle-data-source-maxclausecount-is-set-to-1024/2163/2 "2018-11-02T20:16:47Z")
Hello @bharath_natarajan, This looks like a bug we have identified in 3.0.0 and are working to fix. Can you give a count of the number of tables in the schema? Using sqlplus or sqldeveloper, ``` select owner, count(*) from dba_tables group by owner; select owner, count(*) from dba_views group by owner; ``` If you do not have access to dba\_ dictionary then use below (connect to sqlplus/sqldeveloper _as the same user you are connecting to Dremio_) ``` select count(*) from dba_tables; select count(*) from dba_views; ``` ---
**Author:** ![bharath\_natarajan](https://avatars.discourse-cdn.com/v4/letter/b/94ad74/32.png) [@bharath\_natarajan](https://community.dremio.com/u/bharath_natarajan)\ **Post date:** [November 2, 2018, 8:35pm UTC](https://community.dremio.com/t/dremio-3-0-oracle-data-source-maxclausecount-is-set-to-1024/2163/3 "2018-11-02T20:35:03Z")
The schema I’m looking for has 1396 objects. Over all around 5500. ---
**Author:** ![bharath\_natarajan](https://avatars.discourse-cdn.com/v4/letter/b/94ad74/32.png) [@bharath\_natarajan](https://community.dremio.com/u/bharath_natarajan)\ **Post date:** [November 2, 2018, 8:35pm UTC](https://community.dremio.com/t/dremio-3-0-oracle-data-source-maxclausecount-is-set-to-1024/2163/4 "2018-11-02T20:35:50Z")
Also, any ideas when this will be fixed. Can’t proceed with testing without this fix much. ---
**Author:** ![pisces312](https://avatars.discourse-cdn.com/v4/letter/p/b487fb/32.png) [@pisces312](https://community.dremio.com/u/pisces312)\ **Post date:** [November 9, 2018, 2:32am UTC](https://community.dremio.com/t/dremio-3-0-oracle-data-source-maxclausecount-is-set-to-1024/2163/5 "2018-11-09T02:32:03Z")
Is there any workaround for that? Such as modify a system property or configuration file? ---
**Author:** ![igreg](https://avatars.discourse-cdn.com/v4/letter/i/bcef8e/32.png) [@igreg](https://community.dremio.com/u/igreg)\ **Post date:** [November 13, 2018, 5:17pm UTC](https://community.dremio.com/t/dremio-3-0-oracle-data-source-maxclausecount-is-set-to-1024/2163/6 "2018-11-13T17:17:43Z")
We also face the same “maxClauseCount is set to 1024” issue while connecting to Elasticsearch as the source. As soon as we try to connect it shows this error in the UI. This started happening in Dremio 3.0. We are able to successfully connect to the same Elasticsearch with Dremio 2.1 and 1.0. Is there any setting that should be changed in Dremio 3.0? ---
**Author:** ![anthony](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/anthony/32/670_2.png) [@anthony](https://community.dremio.com/u/anthony)\ **Post date:** [November 14, 2018, 3:50pm UTC](https://community.dremio.com/t/dremio-3-0-oracle-data-source-maxclausecount-is-set-to-1024/2163/7 "2018-11-14T15:50:39Z")
@bharath_natarajan @pisces312 @igreg Sorry for the troubles. This has been fixed, expect a hotfix patch likely next week to address this ---
**Author:** ![anthony](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/anthony/32/670_2.png) [@anthony](https://community.dremio.com/u/anthony)\ **Post date:** [November 17, 2018, 3:27pm UTC](https://community.dremio.com/t/dremio-3-0-oracle-data-source-maxclausecount-is-set-to-1024/2163/8 "2018-11-17T15:27:32Z")
@bharath_natarajan @pisces312 @igreg new hotfix patch is now available - [https://www.dremio.com/download/](https://www.dremio.com/download/) ---
**Author:** ![igreg](https://avatars.discourse-cdn.com/v4/letter/i/bcef8e/32.png) [@igreg](https://community.dremio.com/u/igreg)\ **Post date:** [November 18, 2018, 1:13am UTC](https://community.dremio.com/t/dremio-3-0-oracle-data-source-maxclausecount-is-set-to-1024/2163/9 "2018-11-18T01:13:42Z")
Thanks for the quick turnaround Anthony. ---
**Author:** ![david.lee](https://avatars.discourse-cdn.com/v4/letter/d/ed655f/32.png) [@david.lee](https://community.dremio.com/u/david.lee)\ **Post date:** [November 19, 2018, 8:07pm UTC](https://community.dremio.com/t/dremio-3-0-oracle-data-source-maxclausecount-is-set-to-1024/2163/10 "2018-11-19T20:07:34Z")
I’m still seeing this problem after the patch with Microsoft SQL Server… “maxClauseCount is set to 1024” ---
**Author:** ![pisces312](https://avatars.discourse-cdn.com/v4/letter/p/b487fb/32.png) [@pisces312](https://community.dremio.com/u/pisces312)\ **Post date:** [November 21, 2018, 1:50am UTC](https://community.dremio.com/t/dremio-3-0-oracle-data-source-maxclausecount-is-set-to-1024/2163/11 "2018-11-21T01:50:20Z")
Thanks for the update. ---
**Author:** ![kieranclulow](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/kieranclulow/32/1156_2.png) [@kieranclulow](https://community.dremio.com/u/kieranclulow)\ **Post date:** [December 12, 2018, 7:19am UTC](https://community.dremio.com/t/dremio-3-0-oracle-data-source-maxclausecount-is-set-to-1024/2163/12 "2018-12-12T07:19:10Z")
This is still a bug in 3.0.5-201812021947440442-9a23f45 ---
**Author:** ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)\ **Post date:** [December 13, 2018, 2:22pm UTC](https://community.dremio.com/t/dremio-3-0-oracle-data-source-maxclausecount-is-set-to-1024/2163/13 "2018-12-13T14:22:21Z")
Hi @pisces312 The complete fix for this issue is in 3.0.6. Kindly download from the Dremio Downloads page > **[Download Dremio](https://www.dremio.com/download/)** > > Download Dremio. Dremio gives you unprecedented time to insight, and simplifies and accelerates your analytics. Thanks @balaji.ramaswamy ---
**Author:** ![shinwachi](https://avatars.discourse-cdn.com/v4/letter/s/a9a28c/32.png) [@shinwachi](https://community.dremio.com/u/shinwachi)\ **Post date:** [December 14, 2018, 12:19am UTC](https://community.dremio.com/t/dremio-3-0-oracle-data-source-maxclausecount-is-set-to-1024/2163/14 "2018-12-14T00:19:34Z")
Thank you! Could the docker image (dremio/dremio-oss) be updated as well? This is a critical error that stopped us on PoC as well. ---
**Author:** ![nsen](https://avatars.discourse-cdn.com/v4/letter/n/c68b51/32.png) [@nsen](https://community.dremio.com/u/nsen)\ **Post date:** [December 14, 2018, 3:10am UTC](https://community.dremio.com/t/dremio-3-0-oracle-data-source-maxclausecount-is-set-to-1024/2163/15 "2018-12-14T03:10:43Z")
A 3.0.6 docker image for community edition (OSS) has been published. ---
**Author:** ![pisces312](https://avatars.discourse-cdn.com/v4/letter/p/b487fb/32.png) [@pisces312](https://community.dremio.com/u/pisces312)\ **Post date:** [February 28, 2019, 7:16am UTC](https://community.dremio.com/t/dremio-3-0-oracle-data-source-maxclausecount-is-set-to-1024/2163/16 "2019-02-28T07:16:04Z")
Thanks @balaji.ramaswamy. I have seen it’s fixed.