I looked this up… SQL Data Type 101 is a binary double. https://docs.oracle.com/database/121/SQLRF/sql_elements001.htm#SQLRF30020 <https://docs.oracle.com/database/121/SQLRF/sql_elements001.htm#SQLRF30020>
> On Jun 24, 2020, at 4:52 PM, Charles Givre <[email protected]> wrote: > > Some more questions… > 1. Are there other tables you can query? I want to see if we can at least > get something to work ;-) (Although we can read the schema via SHOW TABLES) > 2. Can you try the following query: > SELECT CAST(<some field> AS INT) > FROM merchant…. Basically I’m wondering if we force Drill to map the field > to a type, if we can get it to read the data. > > > >> On Jun 24, 2020, at 4:44 PM, Christopher Kane >> <[email protected]> wrote: >> >> Hey Charles, >> >> I ran a couple of different queries selecting only a single column from the >> table and it seems multiple columns are all giving me the same unknown sql >> type -101 error. >> The stacktrace also appears to be the same per column, so to me it appears >> that the issue is maybe with the format of the data itself coming from >> Oracle, I'm not too sure at this point. >> >> -Chris >> >> -----Original Message----- >> From: Charles Givre <[email protected]> >> Sent: Wednesday, June 24, 2020 3:30 PM >> To: user <[email protected]> >> Subject: Re: Initial Oracle Setup >> >> Hey Christopher, >> Can you run a query with individual columns so we can see which column is >> causing the issue? >> Thx, >> --C >> >> >> >>> On Jun 23, 2020, at 5:25 PM, Christopher Kane >>> <[email protected]> wrote: >>> >>> Rafael >>> -Okay so doing "show schemas;" (I didn't include the semicolon before) >>> resulted in all of the schemas I was expecting to see be listed, so it's >>> awesome that Drill was actually able to make the connection. So I do think >>> my issue might be with the data types of the columns in the table I'm >>> trying to query. >>> >>> Charles >>> -here are the data types on the table "merchant": NUMBER, VARCHAR2, DATE, >>> TIMESTAMP(6) WITH TIME ZONE. >>> -if I had to take a guess, I would bet money that the problem child here is >>> the timestamp data type. >>> >>> -----Original Message----- >>> From: Christopher Kane <[email protected]> >>> Sent: Tuesday, June 23, 2020 5:19 PM >>> To: [email protected] >>> Subject: RE: Initial Oracle Setup >>> >>> Rafael >>> -I am running this in embedded mode on my Windows Laptop and I believe I >>> have access to the shell but I'm not too familiar with the syntax so I'll >>> have to look that up and I'll let you know what I get. >>> >>> Charles >>> -I'm glad you were able to find something about that error because I was >>> having a tough time finding something related to it. I actually thought >>> something similar and actually changed my query to only return the >>> merchant_id of the merchant because I thought maybe there was a column that >>> Drill didn't know how to handle. I will take a look at the stackoverflow >>> link that you sent me and will let you know what I come up with. >>> -Here is the stacktrace for the VALIDATION ERROR: >>> 2020-06-23 17:15:56,017 [qtp409347742-245] ERROR >>> o.a.d.e.server.rest.QueryResources - Query from Web UI Failed: {} >>> org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR: >>> Unknown SQL type -101 >>> >>> >>> [Error Id: def7533c-bb11-48da-b770-28c6730a1799 ] at >>> org.apache.drill.exec.server.rest.RestQueryRunner.submitQuery(RestQueryRunner.java:181) >>> at >>> org.apache.drill.exec.server.rest.RestQueryRunner.run(RestQueryRunner.java:70) >>> at >>> org.apache.drill.exec.server.rest.QueryResources.submitQueryJSON(QueryResources.java:96) >>> at >>> org.apache.drill.exec.server.rest.QueryResources.submitQuery(QueryResources.java:114) >>> at jdk.internal.reflect.GeneratedMethodAccessor16.invoke(Unknown Source) at >>> java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >>> at java.base/java.lang.reflect.Method.invoke(Method.java:564) >>> at >>> org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81) >>> at >>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144) >>> at >>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161) >>> at >>> org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205) >>> at >>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99) >>> at >>> org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389) >>> at >>> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347) >>> at >>> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102) >>> at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326) >>> at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271) >>> at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267) >>> at org.glassfish.jersey.internal.Errors.process(Errors.java:315) >>> at org.glassfish.jersey.internal.Errors.process(Errors.java:297) >>> at org.glassfish.jersey.internal.Errors.process(Errors.java:267) >>> at >>> org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317) >>> at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305) >>> at >>> org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154) >>> at >>> org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473) >>> at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427) >>> at >>> org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388) >>> at >>> org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341) >>> at >>> org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228) >>> at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:848) >>> at >>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1780) >>> at >>> org.apache.drill.exec.server.rest.header.ResponseHeadersSettingFilter.doFilter(ResponseHeadersSettingFilter.java:71) >>> at >>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1767) >>> at >>> org.apache.drill.exec.server.rest.CsrfTokenValidateFilter.doFilter(CsrfTokenValidateFilter.java:55) >>> at >>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1767) >>> at >>> org.apache.drill.exec.server.rest.CsrfTokenInjectFilter.doFilter(CsrfTokenInjectFilter.java:54) >>> at >>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1767) >>> at >>> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583) >>> at >>> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:224) >>> at >>> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1180) >>> at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:513) >>> at >>> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185) >>> at >>> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112) >>> at >>> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) >>> at >>> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134) >>> at org.eclipse.jetty.server.Server.handle(Server.java:539) >>> at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:333) >>> at >>> org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251) >>> at >>> org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:283) >>> at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:108) >>> at >>> org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93) >>> at >>> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303) >>> at >>> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148) >>> at >>> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136) >>> at >>> org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671) >>> at >>> org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589) >>> at java.base/java.lang.Thread.run(Thread.java:832) >>> Caused by: java.lang.IllegalArgumentException: Unknown SQL type -101 at >>> org.apache.calcite.avatica.SqlType.valueOf(SqlType.java:383) >>> at >>> org.apache.calcite.adapter.jdbc.JdbcSchema.getRelDataType(JdbcSchema.java:385) >>> at >>> org.apache.calcite.adapter.jdbc.JdbcSchema.getRelDataType(JdbcSchema.java:362) >>> at org.apache.calcite.adapter.jdbc.JdbcTable.getRowType(JdbcTable.java:117) >>> at org.apache.calcite.sql.validate.EmptyScope.resolve_(EmptyScope.java:159) >>> at >>> org.apache.calcite.sql.validate.EmptyScope.resolveTable(EmptyScope.java:99) >>> at >>> org.apache.calcite.sql.validate.DelegatingScope.resolveTable(DelegatingScope.java:203) >>> at >>> org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:105) >>> at >>> org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:177) >>> at >>> org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84) >>> at >>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1009) >>> at >>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:969) >>> at >>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3129) >>> at >>> org.apache.drill.exec.planner.sql.conversion.DrillValidator.validateFrom(DrillValidator.java:63) >>> at >>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3111) >>> at >>> org.apache.drill.exec.planner.sql.conversion.DrillValidator.validateFrom(DrillValidator.java:63) >>> at >>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3383) >>> at >>> org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60) >>> at >>> org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84) >>> at >>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1009) >>> at >>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:969) >>> at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:216) >>> at >>> org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:944) >>> at >>> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:651) >>> at >>> org.apache.drill.exec.planner.sql.conversion.SqlConverter.validate(SqlConverter.java:189) >>> at >>> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:641) >>> at >>> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateAndConvert(DefaultSqlHandler.java:195) >>> at >>> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:169) >>> at >>> org.apache.drill.exec.planner.sql.DrillSqlWorker.getQueryPlan(DrillSqlWorker.java:283) >>> at >>> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPhysicalPlan(DrillSqlWorker.java:163) >>> at >>> org.apache.drill.exec.planner.sql.DrillSqlWorker.convertPlan(DrillSqlWorker.java:128) >>> at >>> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:93) >>> at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:593) >>> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:274) >>> at .......(:0) >>> >>> >>> >>> -----Original Message----- >>> From: Charles Givre <[email protected]> >>> Sent: Tuesday, June 23, 2020 4:35 PM >>> To: [email protected] >>> Subject: Re: Initial Oracle Setup >>> >>> One more thing... >>> >>> Could you run the query that is producing the VALIDATION ERROR and send the >>> full stack trace? I'm thinking that can be fixed on the Drill end of >>> things, at least until Calcite fixes that. >>> -- C >>> >>>> On Jun 23, 2020, at 3:58 PM, Christopher Kane >>>> <[email protected]> wrote: >>>> >>>> Yes thank you! To your point about using 1.17, I could always take the >>>> config from 1.18 and copy it over and see if that fixes my issue. >>>> >>>> I think the only thing I'm having an issue with now I think is related >>>> to this: >>>> https://urldefense.proofpoint.com/v2/url?u=https-3A__issues.apache.org >>>> _jira_browse_CALCITE-2D3533&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCB >>>> lPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=g39OzDxVVrucBo3nnaZNaIqoh9SZZi >>>> dthZ3H6QSOkWE&s=oVohCx-25EZLkSVY7yEV1FtFZ-nNDTnGvek4Sx67nYc&e= >>>> >>>> Everything appears to be setup now but when executing a query for the data >>>> source I setup, I receive >>>> org.apache.drill.common.exceptions.UserRemoteException: VALIDATION ERROR: >>>> Unknown SQL type -101. Any suggestions there? >>>> >>>> -----Original Message----- >>>> From: Rafael Jaimes III <[email protected]> >>>> Sent: Tuesday, June 23, 2020 3:43 PM >>>> To: [email protected] >>>> Subject: Re: Initial Oracle Setup >>>> >>>> Glad you got it working with the new version regardless! >>>> >>>> On Tue, Jun 23, 2020 at 3:38 PM Christopher Kane >>>> <[email protected]> wrote: >>>>> >>>>> Wow, I gotta hand it to you, I don't know what I was expecting to happen >>>>> but I got a Success! So that's awesome, thank you so much for your help! >>>>> I am going to quickly run a test query on this data source now and see >>>>> what happens. >>>>> >>>>> -----Original Message----- >>>>> From: Christopher Kane <[email protected]> >>>>> Sent: Tuesday, June 23, 2020 3:31 PM >>>>> To: [email protected] >>>>> Subject: RE: Initial Oracle Setup >>>>> >>>>> Yeah I am not the most familiar with building from source, so I'll check >>>>> out your pre-release, install it like I did 1.17.0 and see what happens! >>>>> >>>>> -----Original Message----- >>>>> From: Charles Givre <[email protected]> >>>>> Sent: Tuesday, June 23, 2020 3:23 PM >>>>> To: user <[email protected]> >>>>> Subject: Re: Initial Oracle Setup >>>>> >>>>> It hasn't been released yet, so you'd have to d/l from github >>>>> (https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_apac >>>>> h >>>>> e_drill&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCBlPlEiTy68EGn8lfllmV >>>>> q >>>>> BXbraSyDLC7XDswJU&m=b6gHt-qP_soEwZSNloM5zPbmSepKW4FaAKoOwoxYlUk&s=C8v >>>>> 5 -xTogFlPrAmfl-0zcAfmZZUP5ZIkcddMxV8aGcg&e= >>>>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_apac >>>>> h >>>>> e_drill&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCBlPlEiTy68EGn8lfllmV >>>>> q >>>>> BXbraSyDLC7XDswJU&m=b6gHt-qP_soEwZSNloM5zPbmSepKW4FaAKoOwoxYlUk&s=C8v >>>>> 5 -xTogFlPrAmfl-0zcAfmZZUP5ZIkcddMxV8aGcg&e= >) and build from >>>>> source. >>>>> If you can't do that, I have a pre-release here: >>>>> https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_cgivr >>>>> e >>>>> _drill_releases_tag_1.18.0-2DSNAPSHOT&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-D >>>>> P >>>>> w&r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=b6gHt-qP_soEwZSNloM >>>>> 5 >>>>> zPbmSepKW4FaAKoOwoxYlUk&s=3IE3kzUlrMTuhmPxkBggBYoK9fszW_xrb--95H-qXY0 >>>>> & >>>>> e= >>>>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_cgiv >>>>> r >>>>> e_drill_releases_tag_1.18.0-2DSNAPSHOT&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0- >>>>> D >>>>> Pw&r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=b6gHt-qP_soEwZSNlo >>>>> M >>>>> 5zPbmSepKW4FaAKoOwoxYlUk&s=3IE3kzUlrMTuhmPxkBggBYoK9fszW_xrb--95H-qXY >>>>> 0 >>>>> &e= > >>>>> >>>>> >>>>>> On Jun 23, 2020, at 3:21 PM, Christopher Kane >>>>>> <[email protected]> wrote: >>>>>> >>>>>> You might have to provide a link for Drill 1.18, I'm not seeing that >>>>>> available on the downloads section of the site. >>>>>> >>>>>> -----Original Message----- >>>>>> From: Christopher Kane <[email protected]> >>>>>> Sent: Tuesday, June 23, 2020 3:14 PM >>>>>> To: [email protected] >>>>>> Subject: RE: Initial Oracle Setup >>>>>> >>>>>> I'm all for it honestly, I've never used Apache Drill before and am >>>>>> trying it out as a POC for something I'm trying to do at work. So you're >>>>>> saying in addition to the driver required by whichever RDBMS you're >>>>>> setting up, there is an Apache Drill JDBC plugin that works in >>>>>> combination with the driver? >>>>>> >>>>>> -----Original Message----- >>>>>> From: Charles Givre <[email protected]> >>>>>> Sent: Tuesday, June 23, 2020 3:11 PM >>>>>> To: [email protected] >>>>>> Subject: Re: Initial Oracle Setup >>>>>> >>>>>> Another qq: Would you be willing to try Drill 1.18? There were some >>>>>> significant changes made to the JDBC plugin in 1.18 and I wonder if that >>>>>> might solve the issue. >>>>>> >>>>>>> On Jun 23, 2020, at 3:05 PM, Christopher Kane >>>>>>> <[email protected]> wrote: >>>>>>> >>>>>>> On both the directory of drill and on startup I am running Apache >>>>>>> Drill 1.17.0 >>>>>>> >>>>>>> -----Original Message----- >>>>>>> From: Charles Givre <[email protected] <mailto:[email protected]>> >>>>>>> Sent: Tuesday, June 23, 2020 3:03 PM >>>>>>> To: user <[email protected] <mailto:[email protected]>> >>>>>>> Subject: Re: Initial Oracle Setup >>>>>>> >>>>>>> One more question.. what version of Drill are you using? >>>>>>> >>>>>>> >>>>>>>> On Jun 23, 2020, at 3:01 PM, Christopher Kane >>>>>>>> <[email protected]> wrote: >>>>>>>> >>>>>>>> Rafael >>>>>>>> -I did place it in the jars/3rdparty folder. >>>>>>>> >>>>>>>> Storage Plugin Config: >>>>>>>> { >>>>>>>> "type": "jdbc", >>>>>>>> "enabled": true, >>>>>>>> "driver": "oracle.jdbc.driver.OracleDriver", >>>>>>>> "url": >>>>>>>> "jdbc:oracle:thin:username/password@chris-ora-scan:1521/chris_app" >>>>>>>> } >>>>>>>> (it's been modified to remove sensitive information) >>>>>>>> >>>>>>>> Charles >>>>>>>> -I did turn Verbose on as you instructed, below is the full >>>>>>>> stacktrace. Now I will say that the one DBA I was conversing with >>>>>>>> mentioned something about JRE, and I find interesting in this stack >>>>>>>> trace that it seems to be a RunTime exception. >>>>>>>> -I'm not sure if I was aware they were at a version 10? This is the >>>>>>>> link I was using to download the JDBC driver: >>>>>>>> https://urldefense.proofpoint.com/v2/url?u=https-3A__www.oracle.com_database_technologies_jdbc-2Ddrivers-2D12c-2Ddownloads.html&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=8cPWOW4PY_sKPTUxECbL9XacM9DQCSnBbAJL9oQht0s&s=zddp1Im2FovgkwAQ3SyRaJzBS1FxeOgiwYdViTSn4H4&e= >>>>>>>> >>>>>>>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__www.oracle.com_database_technologies_jdbc-2Ddrivers-2D12c-2Ddownloads.html&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=8cPWOW4PY_sKPTUxECbL9XacM9DQCSnBbAJL9oQht0s&s=zddp1Im2FovgkwAQ3SyRaJzBS1FxeOgiwYdViTSn4H4&e=> >>>>>>>> and the only options I see available and relevant are either >>>>>>>> ojdbc7.jar or ojdbc6.jar. At this point I've tried both but am willing >>>>>>>> to change my configuration while troubleshooting. In addition the >>>>>>>> recommended driver for Oracle by Apache seems to be >>>>>>>> ojdbc7.12.1.0.2.jar referenced from this page here: >>>>>>>> https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.apache.org_docs_rdbms-2Dstorage-2Dplugin_&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=8cPWOW4PY_sKPTUxECbL9XacM9DQCSnBbAJL9oQht0s&s=rzaAsfW2VGICMfzMAhjoT2vZqBRkti6X56uH4Uv1HU0&e= >>>>>>>> >>>>>>>> <https://urldefense.proofpoint.com/v2/url?u=https-3A__drill.apache.org_docs_rdbms-2Dstorage-2Dplugin_&d=DwIFAg&c=rE3mhBYFJfJGqQ7WI0-DPw&r=BYRbCBlPlEiTy68EGn8lfllmVqBXbraSyDLC7XDswJU&m=8cPWOW4PY_sKPTUxECbL9XacM9DQCSnBbAJL9oQht0s&s=rzaAsfW2VGICMfzMAhjoT2vZqBRkti6X56uH4Uv1HU0&e=> >>>>>>>> and that is the one I am currently using, ojdbc7.jar from the >>>>>>>> 12.1.0.2 release of Oracle Database. >>>>>>>> >>>>>>>> 2020-06-23 14:52:37,017 [qtp377017996-50] ERROR >>>>>>>> o.a.d.e.server.rest.StorageResources - Unable to create/ update >>>>>>>> plugin: QA2 Oracle >>>>>>>> org.apache.drill.common.exceptions.ExecutionSetupException: >>>>>>>> Failure setting up new storage plugin configuration for config >>>>>>>> org.apache.drill.exec.store.jdbc.JdbcStorageConfig@7d9c9e53 >>>>>>>> at >>>>>>>> org.apache.drill.exec.store.StoragePluginRegistryImpl.create(Stora >>>>>>>> ge >>>>>>>> P >>>>>>>> l >>>>>>>> uginRegistryImpl.java:536) at >>>>>>>> org.apache.drill.exec.store.StoragePluginRegistryImpl.createOrUpda >>>>>>>> te >>>>>>>> ( >>>>>>>> S >>>>>>>> toragePluginRegistryImpl.java:132) >>>>>>>> at >>>>>>>> org.apache.drill.exec.server.rest.PluginConfigWrapper.createOrUpda >>>>>>>> te >>>>>>>> I >>>>>>>> n >>>>>>>> Storage(PluginConfigWrapper.java:56) >>>>>>>> at >>>>>>>> org.apache.drill.exec.server.rest.StorageResources.createOrUpdateP >>>>>>>> lu >>>>>>>> g >>>>>>>> i >>>>>>>> nJSON(StorageResources.java:212) at >>>>>>>> org.apache.drill.exec.server.rest.StorageResources.createOrUpdateP >>>>>>>> lu >>>>>>>> g >>>>>>>> i >>>>>>>> n(StorageResources.java:233) at >>>>>>>> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Na >>>>>>>> ti >>>>>>>> v >>>>>>>> e >>>>>>>> Method) at >>>>>>>> java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Nat >>>>>>>> iv >>>>>>>> e >>>>>>>> M >>>>>>>> ethodAccessorImpl.java:62) at >>>>>>>> java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke >>>>>>>> (D >>>>>>>> e >>>>>>>> l >>>>>>>> egatingMethodAccessorImpl.java:43) >>>>>>>> at java.base/java.lang.reflect.Method.invoke(Method.java:564) >>>>>>>> at >>>>>>>> org.glassfish.jersey.server.model.internal.ResourceMethodInvocatio >>>>>>>> nH >>>>>>>> a >>>>>>>> n >>>>>>>> dlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:8 >>>>>>>> 1) >>>>>>>> at >>>>>>>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMet >>>>>>>> ho >>>>>>>> d >>>>>>>> D >>>>>>>> ispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144) >>>>>>>> at >>>>>>>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMet >>>>>>>> ho >>>>>>>> d >>>>>>>> D >>>>>>>> ispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161) >>>>>>>> at >>>>>>>> org.glassfish.jersey.server.model.internal.JavaResourceMethodDispa >>>>>>>> tc >>>>>>>> h >>>>>>>> e >>>>>>>> rProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherPr >>>>>>>> ov >>>>>>>> i >>>>>>>> d >>>>>>>> er.java:205) at >>>>>>>> org.glassfish.jersey.server.model.internal.AbstractJavaResourceMet >>>>>>>> ho >>>>>>>> d >>>>>>>> D >>>>>>>> ispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99) >>>>>>>> at >>>>>>>> org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(Res >>>>>>>> ou >>>>>>>> r >>>>>>>> c >>>>>>>> eMethodInvoker.java:389) at >>>>>>>> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(Reso >>>>>>>> ur >>>>>>>> c >>>>>>>> e >>>>>>>> MethodInvoker.java:347) at >>>>>>>> org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(Reso >>>>>>>> ur >>>>>>>> c >>>>>>>> e >>>>>>>> MethodInvoker.java:102) at >>>>>>>> org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java >>>>>>>> :3 >>>>>>>> 2 >>>>>>>> 6 >>>>>>>> ) at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271) >>>>>>>> at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267) >>>>>>>> at org.glassfish.jersey.internal.Errors.process(Errors.java:315) >>>>>>>> at org.glassfish.jersey.internal.Errors.process(Errors.java:297) >>>>>>>> at org.glassfish.jersey.internal.Errors.process(Errors.java:267) >>>>>>>> at >>>>>>>> org.glassfish.jersey.process.internal.RequestScope.runInScope(Requ >>>>>>>> es >>>>>>>> t >>>>>>>> S >>>>>>>> cope.java:317) at >>>>>>>> org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java: >>>>>>>> 3 >>>>>>>> 05) at >>>>>>>> org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationH >>>>>>>> an >>>>>>>> d >>>>>>>> l >>>>>>>> er.java:1154) at >>>>>>>> org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent >>>>>>>> .j >>>>>>>> a >>>>>>>> v >>>>>>>> a:473) at >>>>>>>> org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java: >>>>>>>> 4 >>>>>>>> 2 >>>>>>>> 7) at >>>>>>>> org.glassfish.jersey.servlet.ServletContainer.service(ServletConta >>>>>>>> in >>>>>>>> e >>>>>>>> r >>>>>>>> .java:388) at >>>>>>>> org.glassfish.jersey.servlet.ServletContainer.service(ServletConta >>>>>>>> in >>>>>>>> e >>>>>>>> r >>>>>>>> .java:341) at >>>>>>>> org.glassfish.jersey.servlet.ServletContainer.service(ServletConta >>>>>>>> in >>>>>>>> e >>>>>>>> r >>>>>>>> .java:228) at >>>>>>>> org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java: >>>>>>>> 84 >>>>>>>> 8 >>>>>>>> ) >>>>>>>> at >>>>>>>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(Serv >>>>>>>> le >>>>>>>> t >>>>>>>> H >>>>>>>> andler.java:1780) at >>>>>>>> org.apache.drill.exec.server.rest.CsrfTokenValidateFilter.doFilter >>>>>>>> (C >>>>>>>> s >>>>>>>> r >>>>>>>> fTokenValidateFilter.java:55) at >>>>>>>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(Serv >>>>>>>> le >>>>>>>> t >>>>>>>> H >>>>>>>> andler.java:1767) at >>>>>>>> org.apache.drill.exec.server.rest.CsrfTokenInjectFilter.doFilter(C >>>>>>>> sr >>>>>>>> f >>>>>>>> T >>>>>>>> okenInjectFilter.java:54) at >>>>>>>> org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(Serv >>>>>>>> le >>>>>>>> t >>>>>>>> H >>>>>>>> andler.java:1767) at >>>>>>>> org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java: >>>>>>>> 583) at >>>>>>>> org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHa >>>>>>>> nd >>>>>>>> l >>>>>>>> e >>>>>>>> r.java:224) at >>>>>>>> org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHa >>>>>>>> nd >>>>>>>> l >>>>>>>> e >>>>>>>> r.java:1180) at >>>>>>>> org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java: >>>>>>>> 5 >>>>>>>> 13) at >>>>>>>> org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHan >>>>>>>> dl >>>>>>>> e >>>>>>>> r >>>>>>>> .java:185) at >>>>>>>> org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHan >>>>>>>> dl >>>>>>>> e >>>>>>>> r >>>>>>>> .java:1112) at >>>>>>>> org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler. >>>>>>>> j >>>>>>>> a >>>>>>>> va:141) at >>>>>>>> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper. >>>>>>>> java:134) at >>>>>>>> org.eclipse.jetty.server.Server.handle(Server.java:539) >>>>>>>> at >>>>>>>> org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:333) >>>>>>>> at >>>>>>>> org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection. >>>>>>>> ja >>>>>>>> v >>>>>>>> a >>>>>>>> :251) at >>>>>>>> org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(Abs >>>>>>>> tr >>>>>>>> a >>>>>>>> c >>>>>>>> tConnection.java:283) at >>>>>>>> org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:108) >>>>>>>> at >>>>>>>> org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndP >>>>>>>> oi >>>>>>>> n >>>>>>>> t >>>>>>>> .java:93) at >>>>>>>> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.execu >>>>>>>> te >>>>>>>> P >>>>>>>> r >>>>>>>> oduceConsume(ExecuteProduceConsume.java:303) >>>>>>>> at >>>>>>>> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produ >>>>>>>> ce >>>>>>>> C >>>>>>>> o >>>>>>>> nsume(ExecuteProduceConsume.java:148) >>>>>>>> at >>>>>>>> org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(E >>>>>>>> xe >>>>>>>> c >>>>>>>> u >>>>>>>> teProduceConsume.java:136) at >>>>>>>> org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThread >>>>>>>> Po >>>>>>>> o >>>>>>>> l >>>>>>>> .java:671) at >>>>>>>> org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool. >>>>>>>> java:589) at java.base/java.lang.Thread.run(Thread.java:832) >>>>>>>> Caused by: java.lang.RuntimeException: Rule description >>>>>>>> 'JDBC_DREL_ConverterJDBC.QA2 Oracle' is not valid at >>>>>>>> org.apache.calcite.plan.RelOptRule.<init>(RelOptRule.java:104) >>>>>>>> at >>>>>>>> org.apache.calcite.rel.convert.ConverterRule.<init>(ConverterRule. >>>>>>>> ja >>>>>>>> v >>>>>>>> a >>>>>>>> :78) at >>>>>>>> org.apache.drill.exec.store.jdbc.JdbcStoragePlugin$JdbcDrelConvert >>>>>>>> er >>>>>>>> R >>>>>>>> u >>>>>>>> le.<init>(JdbcStoragePlugin.java:224) >>>>>>>> at >>>>>>>> org.apache.drill.exec.store.jdbc.JdbcStoragePlugin$DrillJdbcConven >>>>>>>> ti >>>>>>>> o >>>>>>>> n >>>>>>>> .<init>(JdbcStoragePlugin.java:119) >>>>>>>> at >>>>>>>> org.apache.drill.exec.store.jdbc.JdbcStoragePlugin.<init>(JdbcStor >>>>>>>> ag >>>>>>>> e >>>>>>>> P >>>>>>>> lugin.java:103) at >>>>>>>> java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newIn >>>>>>>> st >>>>>>>> a >>>>>>>> n >>>>>>>> ce0(Native Method) at >>>>>>>> java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newIn >>>>>>>> st >>>>>>>> a >>>>>>>> n >>>>>>>> ce(NativeConstructorAccessorImpl.java:62) >>>>>>>> at >>>>>>>> java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.n >>>>>>>> ew >>>>>>>> I >>>>>>>> n >>>>>>>> stance(DelegatingConstructorAccessorImpl.java:45) >>>>>>>> at >>>>>>>> java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Cons >>>>>>>> tr >>>>>>>> u >>>>>>>> c >>>>>>>> tor.java:500) at >>>>>>>> java.base/java.lang.reflect.Constructor.newInstance(Constructor.java: >>>>>>>> 4 >>>>>>>> 81) at >>>>>>>> org.apache.drill.exec.store.StoragePluginRegistryImpl.create(Stora >>>>>>>> ge >>>>>>>> P >>>>>>>> l >>>>>>>> uginRegistryImpl.java:528) >>>>>>>> ... 56 common frames omitted >>>>>>>> >>>>>>>> -----Original Message----- >>>>>>>> From: Charles Givre <[email protected]> >>>>>>>> Sent: Tuesday, June 23, 2020 2:51 PM >>>>>>>> To: [email protected] >>>>>>>> Subject: Re: Initial Oracle Setup >>>>>>>> >>>>>>>> One more thing... >>>>>>>> Did you try with the current Oracle JDBC driver? I believe they are >>>>>>>> at version 10 now. >>>>>>>> Thanks, >>>>>>>> -- C >>>>>>>> >>>>>>>>> On Jun 23, 2020, at 1:59 PM, Rafael Jaimes III <[email protected]> >>>>>>>>> wrote: >>>>>>>>> >>>>>>>>> Hi Chris, >>>>>>>>> >>>>>>>>> You put the JDBC driver in the 3rd party folder? >>>>>>>>> >>>>>>>>> You're right you might be onto something if you get the password >>>>>>>>> failed message. Can you post the exact text (JSON) of the storage >>>>>>>>> plugin config? >>>>>>>>> >>>>>>>>> -Rafael >>>>>>>>> >>>>>>>>> On Tue, Jun 23, 2020 at 1:56 PM Christopher Kane >>>>>>>>> <[email protected]> wrote: >>>>>>>>>> >>>>>>>>>> Hey Everyone, >>>>>>>>>> >>>>>>>>>> I'm looking to setup and create a new Oracle Storage Plugin for my >>>>>>>>>> local Apache Drill instance. I have determined that a correct oracle >>>>>>>>>> connection string with an incorrect password results in the >>>>>>>>>> following message: Please retry: Error while creating / updating >>>>>>>>>> storage : java.sql.SQLException: Cannot create >>>>>>>>>> PoolableConnectionFactory (ORA-01017: invalid username/password; >>>>>>>>>> logon denied ). Now updating the connection string to use the >>>>>>>>>> correct password results in the following message: Please retry: >>>>>>>>>> Error while creating / updating storage : Rule description >>>>>>>>>> 'JDBC_DREL_ConverterJDBC.QA2 Oracle' is not valid. >>>>>>>>>> >>>>>>>>>> I have confirmed with our DBAs and through my own testing that my >>>>>>>>>> connection string is correct. When attempting to google anything >>>>>>>>>> related to the message 'JDBC_DREL_Converter' unfortunately I am not >>>>>>>>>> able to find anything useful. At this point I'm kind of grasping at >>>>>>>>>> straws as to what my issue is at this point. In addition I also have >>>>>>>>>> the correct oracle thin driver installed, which was the recommend >>>>>>>>>> one from the RDBMS page within the Apache Drill documentation and >>>>>>>>>> I've also added this line to my drill-override.conf, >>>>>>>>>> drill.exec.sys.store.provider.local.path = "ojdbc7.jar". But I'm >>>>>>>>>> assuming if any of that wasn't setup correctly, I wouldn't be able >>>>>>>>>> to get an error message back from Oracle saying that my password was >>>>>>>>>> incorrect. Any help in regards to this would be greatly appreciated. >>>>>>>>>> >>>>>>>>>> Christopher Kane >>>>>>>>>> Software Test Engineer | Clover, CardConnect, FiServ >>>>>>>>>> [email protected]<mailto:[email protected]>, >>>>>>>>>> [email protected]<mailto:Christopher.Kane@cardconnect. >>>>>>>>>> com>, >>>>>>>>>> [email protected]<mailto:Christopher.Kane2@firstdata. >>>>>>>>>> c >>>>>>>>>> o >>>>>>>>>> m>, >>>>>>>>>> m>[email protected]<mailto:[email protected] >>>>>>>>>> m>om >>>>>>>>>> m>> >>>>>>>>>> >>>>>>>>>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any >>>>>>>>>> attachments are proprietary and confidential information protected >>>>>>>>>> from disclosure and intended only for the use of the recipient(s) >>>>>>>>>> named above. If the reader of this message is not the intended >>>>>>>>>> recipient, or an employee or agent responsible for delivering this >>>>>>>>>> message to the intended recipient, you are hereby notified that any >>>>>>>>>> dissemination, distribution or copying of this message or any >>>>>>>>>> attachments is strictly prohibited. If you have received this >>>>>>>>>> communication in error, please notify CardConnect immediately by >>>>>>>>>> replying to this message and then delete this message and any >>>>>>>>>> attachments from your computer. >>>>>>>> >>>>>>>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments >>>>>>>> are proprietary and confidential information protected from disclosure >>>>>>>> and intended only for the use of the recipient(s) named above. If the >>>>>>>> reader of this message is not the intended recipient, or an employee >>>>>>>> or agent responsible for delivering this message to the intended >>>>>>>> recipient, you are hereby notified that any dissemination, >>>>>>>> distribution or copying of this message or any attachments is strictly >>>>>>>> prohibited. If you have received this communication in error, please >>>>>>>> notify CardConnect immediately by replying to this message and then >>>>>>>> delete this message and any attachments from your computer. >>>>>>> >>>>>>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments >>>>>>> are proprietary and confidential information protected from disclosure >>>>>>> and intended only for the use of the recipient(s) named above. If the >>>>>>> reader of this message is not the intended recipient, or an employee or >>>>>>> agent responsible for delivering this message to the intended >>>>>>> recipient, you are hereby notified that any dissemination, distribution >>>>>>> or copying of this message or any attachments is strictly prohibited. >>>>>>> If you have received this communication in error, please notify >>>>>>> CardConnect immediately by replying to this message and then delete >>>>>>> this message and any attachments from your computer. >>>>>> >>>>>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments >>>>>> are proprietary and confidential information protected from disclosure >>>>>> and intended only for the use of the recipient(s) named above. If the >>>>>> reader of this message is not the intended recipient, or an employee or >>>>>> agent responsible for delivering this message to the intended recipient, >>>>>> you are hereby notified that any dissemination, distribution or copying >>>>>> of this message or any attachments is strictly prohibited. If you have >>>>>> received this communication in error, please notify CardConnect >>>>>> immediately by replying to this message and then delete this message and >>>>>> any attachments from your computer. >>>>>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments >>>>>> are proprietary and confidential information protected from disclosure >>>>>> and intended only for the use of the recipient(s) named above. If the >>>>>> reader of this message is not the intended recipient, or an employee or >>>>>> agent responsible for delivering this message to the intended recipient, >>>>>> you are hereby notified that any dissemination, distribution or copying >>>>>> of this message or any attachments is strictly prohibited. If you have >>>>>> received this communication in error, please notify CardConnect >>>>>> immediately by replying to this message and then delete this message and >>>>>> any attachments from your computer. >>>>> >>>>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments are >>>>> proprietary and confidential information protected from disclosure and >>>>> intended only for the use of the recipient(s) named above. If the reader >>>>> of this message is not the intended recipient, or an employee or agent >>>>> responsible for delivering this message to the intended recipient, you >>>>> are hereby notified that any dissemination, distribution or copying of >>>>> this message or any attachments is strictly prohibited. If you have >>>>> received this communication in error, please notify CardConnect >>>>> immediately by replying to this message and then delete this message and >>>>> any attachments from your computer. >>>>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments are >>>>> proprietary and confidential information protected from disclosure and >>>>> intended only for the use of the recipient(s) named above. If the reader >>>>> of this message is not the intended recipient, or an employee or agent >>>>> responsible for delivering this message to the intended recipient, you >>>>> are hereby notified that any dissemination, distribution or copying of >>>>> this message or any attachments is strictly prohibited. If you have >>>>> received this communication in error, please notify CardConnect >>>>> immediately by replying to this message and then delete this message and >>>>> any attachments from your computer. >>>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments are >>>> proprietary and confidential information protected from disclosure and >>>> intended only for the use of the recipient(s) named above. If the reader >>>> of this message is not the intended recipient, or an employee or agent >>>> responsible for delivering this message to the intended recipient, you are >>>> hereby notified that any dissemination, distribution or copying of this >>>> message or any attachments is strictly prohibited. If you have received >>>> this communication in error, please notify CardConnect immediately by >>>> replying to this message and then delete this message and any attachments >>>> from your computer. >>> >>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments are >>> proprietary and confidential information protected from disclosure and >>> intended only for the use of the recipient(s) named above. If the reader of >>> this message is not the intended recipient, or an employee or agent >>> responsible for delivering this message to the intended recipient, you are >>> hereby notified that any dissemination, distribution or copying of this >>> message or any attachments is strictly prohibited. If you have received >>> this communication in error, please notify CardConnect immediately by >>> replying to this message and then delete this message and any attachments >>> from your computer. >>> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments are >>> proprietary and confidential information protected from disclosure and >>> intended only for the use of the recipient(s) named above. If the reader of >>> this message is not the intended recipient, or an employee or agent >>> responsible for delivering this message to the intended recipient, you are >>> hereby notified that any dissemination, distribution or copying of this >>> message or any attachments is strictly prohibited. If you have received >>> this communication in error, please notify CardConnect immediately by >>> replying to this message and then delete this message and any attachments >>> from your computer. >> >> >> THIS MESSAGE IS CONFIDENTIAL. This e-mail message and any attachments are >> proprietary and confidential information protected from disclosure and >> intended only for the use of the recipient(s) named above. If the reader of >> this message is not the intended recipient, or an employee or agent >> responsible for delivering this message to the intended recipient, you are >> hereby notified that any dissemination, distribution or copying of this >> message or any attachments is strictly prohibited. If you have received this >> communication in error, please notify CardConnect immediately by replying to >> this message and then delete this message and any attachments from your >> computer. >
