366 Star 3.4K Fork 1.5K

JEECG / JimuReport

 / 详情

jeecg使用积木报表,页面配置mongodb数据库,点击测试报错

已完成
创建于  
2021-11-24 14:26
版本号:1.4.0
问题描述:页面上点击新建报表,数据集管理,sql数据集,数据源维护中添加mongodb数据源,点击测试报错。
错误日志&截图:输入图片说明输入图片说明
重现步骤:项目中maven依赖有mongodb和jimu1.4.0的依赖包,启动项目后,页面点击报表的数据源维护,添加mongodb数据源,点击测试就报错。

友情提示(为了提高issue处理效率):

  • 积木报表是一款免费报表产品,功能免费源码不开放;
  • 未按格式要求发帖,会被直接删掉;
  • 请针对问题提供报表设计SQL脚本或在官网制作报表示例并提供ID;
  • 针对不好重现的问题,请录制操作视频或详细的重现步骤;

评论 (6)

丁守祥 创建了任务

看看是不是跟你本地的依赖版本冲突了

<dependency>
            <groupId>org.mongodb</groupId>
            <artifactId>mongo-java-driver</artifactId>
            <version>3.12.10</version>
        </dependency>

已尝试,排除mongo-java-driver 3.12.10依赖版本冲突并不可以解决

<dependency>
  <groupId>org.jeecgframework.jimureport</groupId>
  <artifactId>jimureport-spring-boot-starter</artifactId>
  <version>1.4.11</version>
</dependency>
            <!--Java链接mongodb驱动-->
	<dependency>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-data-mongodb</artifactId>
	</dependency>

1.因为项目要使用mongodb开发,所以必须引入以上的依赖。
2.jimureport-spring-boot-starter升级到1.4.1版本依然会报驱动的错误。

3.

org.springframework.boot
spring-boot-starter-parent
2.2.1.RELEASE

把spring-boot-starter-parent版本降低到2.2.1时报以下的错误

2021-12-02 09:36:31.739 [QuartzScheduler_MyScheduler-DESKTOP-8C07LG71638408640104_ClusterManager] INFO o.s.scheduling.quartz.LocalDataSourceJobStore:3644 - ClusterManager: detected 1 failed or restarted instances.
2021-12-02 09:36:31.739 [QuartzScheduler_MyScheduler-DESKTOP-8C07LG71638408640104_ClusterManager] INFO o.s.scheduling.quartz.LocalDataSourceJobStore:3503 - ClusterManager: Scanning for instance "DESKTOP-GNLN4KD1638407823771"'s failed in-progress jobs.
2021-12-02 09:38:14.281 [http-nio-8080-exec-5] INFO org.mongodb.driver.cluster:71 - Cluster created with settings {hosts=[192.168.0.247:27017], mode=MULTIPLE, requiredClusterType=UNKNOWN, serverSelectionTimeout='3000 ms', maxWaitQueueSize=500}
2021-12-02 09:38:14.281 [http-nio-8080-exec-5] INFO org.mongodb.driver.cluster:71 - Adding discovered server 192.168.0.247:27017 to client view of cluster
2021-12-02 09:38:14.283 [http-nio-8080-exec-5] INFO org.mongodb.driver.cluster:71 - Cluster description not yet available. Waiting for 3000 ms before timing out
2021-12-02 09:38:14.288 [cluster-ClusterId{value='61a82386c4e3a81c502578aa', description='null'}-192.168.0.247:27017] INFO org.mongodb.driver.connection:71 - Opened connection [connectionId{localValue:8, serverValue:3562}] to 192.168.0.247:27017
2021-12-02 09:38:14.289 [cluster-ClusterId{value='61a82386c4e3a81c502578aa', description='null'}-192.168.0.247:27017] INFO org.mongodb.driver.cluster:71 - Monitor thread successfully connected to server with description ServerDescription{address=192.168.0.247:27017, type=STANDALONE, state=CONNECTED, ok=true, version=ServerVersion{versionList=[5, 0, 2]}, minWireVersion=0, maxWireVersion=13, maxDocumentSize=16777216, logicalSessionTimeoutMinutes=30, roundTripTimeNanos=985400}
2021-12-02 09:38:14.290 [cluster-ClusterId{value='61a82386c4e3a81c502578aa', description='null'}-192.168.0.247:27017] INFO org.mongodb.driver.cluster:71 - Discovered cluster type of STANDALONE
2021-12-02 09:38:16.345 [http-nio-8080-exec-4] INFO org.jeecgframework.minidao.aop.MiniDaoHandler:424 - page countsql===> SELECT count(0) FROM jimu_report_data_source jrds WHERE 1 = 1
2021-12-02 09:38:16.347 [http-nio-8080-exec-4] INFO org.jeecgframework.minidao.aop.MiniDaoHandler:435 - page executeSql===> SELECT * FROM jimu_report_data_source jrds where 1=1
LIMIT 10
2021-12-02 09:38:21.805 [http-nio-8080-exec-3] INFO o.j.m.jmreport.dyndb.JmreportDataSourceCachePool:40 - 获取动态DB数据源: JmreportDynamicDataSourceVo(id=622644967619649536, code=, dbType=MYSQL5.7, dbDriver=com.mysql.cj.jdbc.Driver, dbUrl=jdbc:mysql://192.168.0.247/nyzr_resource?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8&tinyInt1isBit=false, dbName=null, dbUsername=root, dbPassword=Rybt@2021, connectTimes=0)
2021-12-02 09:38:21.827 [http-nio-8080-exec-3] WARN com.zaxxer.hikari.HikariConfig:1001 - HikariCP - idleTimeout is close to or more than maxLifetime, disabling it.
2021-12-02 09:38:21.828 [http-nio-8080-exec-3] INFO com.zaxxer.hikari.HikariDataSource:110 - HikariCP - Starting...
2021-12-02 09:38:22.353 [http-nio-8080-exec-3] INFO com.zaxxer.hikari.HikariDataSource:123 - HikariCP - Start completed.
2021-12-02 09:38:31.759 [http-nio-8080-exec-6] INFO o.j.m.jmreport.dyndb.JmreportDataSourceCachePool:40 - 获取动态DB数据源: JmreportDynamicDataSourceVo(id=623052719827410944, code=, dbType=mongodb, dbDriver=, dbUrl=192.168.0.247:27017/com_sat_dev, dbName=null, dbUsername=, dbPassword=, connectTimes=0)
2021-12-02 09:38:39.411 [http-nio-8080-exec-7] INFO org.jeecgframework.minidao.aop.MiniDaoHandler:424 - page countsql===> SELECT count(0) FROM jimu_report_data_source jrds WHERE 1 = 1
2021-12-02 09:38:39.413 [http-nio-8080-exec-7] INFO org.jeecgframework.minidao.aop.MiniDaoHandler:435 - page executeSql===> SELECT * FROM jimu_report_data_source jrds where 1=1
LIMIT 10
2021-12-02 09:38:59.269 [http-nio-8080-exec-9] INFO org.mongodb.driver.cluster:71 - Cluster created with settings {hosts=[192.168.0.247:27017], mode=MULTIPLE, requiredClusterType=UNKNOWN, serverSelectionTimeout='30000 ms', maxWaitQueueSize=500}
2021-12-02 09:38:59.270 [http-nio-8080-exec-9] INFO org.mongodb.driver.cluster:71 - Adding discovered server 192.168.0.247:27017 to client view of cluster
2021-12-02 09:38:59.271 [http-nio-8080-exec-9] INFO org.mongodb.driver.cluster:71 - Cluster description not yet available. Waiting for 30000 ms before timing out
2021-12-02 09:38:59.276 [cluster-ClusterId{value='61a823b3c4e3a81c502578ab', description='null'}-192.168.0.247:27017] INFO org.mongodb.driver.connection:71 - Opened connection [connectionId{localValue:9, serverValue:3563}] to 192.168.0.247:27017
2021-12-02 09:38:59.277 [cluster-ClusterId{value='61a823b3c4e3a81c502578ab', description='null'}-192.168.0.247:27017] INFO org.mongodb.driver.cluster:71 - Monitor thread successfully connected to server with description ServerDescription{address=192.168.0.247:27017, type=STANDALONE, state=CONNECTED, ok=true, version=ServerVersion{versionList=[5, 0, 2]}, minWireVersion=0, maxWireVersion=13, maxDocumentSize=16777216, logicalSessionTimeoutMinutes=30, roundTripTimeNanos=1245300}
2021-12-02 09:38:59.278 [cluster-ClusterId{value='61a823b3c4e3a81c502578ab', description='null'}-192.168.0.247:27017] INFO org.mongodb.driver.cluster:71 - Discovered cluster type of STANDALONE
2021-12-02 09:38:59.285 [http-nio-8080-exec-9] INFO org.mongodb.driver.connection:71 - Closed connection [connectionId{localValue:10}] to 192.168.0.247:27017 because there was a socket exception raised by this connection.
2021-12-02 09:38:59.285 [http-nio-8080-exec-9] INFO org.jeecg.modules.jmreport.dyndb.JmreportNoSqlUtil:159 - Mongodb数据源信息异常
com.mongodb.MongoSecurityException: Exception authenticating MongoCredential{mechanism=SCRAM-SHA-1, userName='', source='com_sat_dev', password=, mechanismProperties=}
at com.mongodb.internal.connection.SaslAuthenticator.wrapException(SaslAuthenticator.java:173)
at com.mongodb.internal.connection.SaslAuthenticator.access$300(SaslAuthenticator.java:40)
at com.mongodb.internal.connection.SaslAuthenticator$1.run(SaslAuthenticator.java:70)
at com.mongodb.internal.connection.SaslAuthenticator$1.run(SaslAuthenticator.java:47)
at com.mongodb.internal.connection.SaslAuthenticator.doAsSubject(SaslAuthenticator.java:179)
at com.mongodb.internal.connection.SaslAuthenticator.authenticate(SaslAuthenticator.java:47)
at com.mongodb.internal.connection.InternalStreamConnectionInitializer.authenticateAll(InternalStreamConnectionInitializer.java:156)
at com.mongodb.internal.connection.InternalStreamConnectionInitializer.initialize(InternalStreamConnectionInitializer.java:63)
at com.mongodb.internal.connection.InternalStreamConnection.open(InternalStreamConnection.java:129)
at com.mongodb.internal.connection.UsageTrackingInternalConnection.open(UsageTrackingInternalConnection.java:50)
at com.mongodb.internal.connection.DefaultConnectionPool$PooledConnection.open(DefaultConnectionPool.java:398)
at com.mongodb.internal.connection.DefaultConnectionPool.get(DefaultConnectionPool.java:115)
at com.mongodb.internal.connection.DefaultConnectionPool.get(DefaultConnectionPool.java:101)
at com.mongodb.internal.connection.DefaultServer.getConnection(DefaultServer.java:92)
at com.mongodb.binding.ClusterBinding$ClusterBindingConnectionSource.getConnection(ClusterBinding.java:126)
at com.mongodb.operation.CommandOperationHelper$5.call(CommandOperationHelper.java:207)
at com.mongodb.operation.OperationHelper.withReadConnectionSource(OperationHelper.java:463)
at com.mongodb.operation.CommandOperationHelper.executeCommand(CommandOperationHelper.java:203)
at com.mongodb.operation.CommandOperationHelper.executeCommand(CommandOperationHelper.java:198)
at com.mongodb.operation.CommandReadOperation.execute(CommandReadOperation.java:59)
at com.mongodb.client.internal.MongoClientDelegate$DelegateOperationExecutor.execute(MongoClientDelegate.java:189)
at com.mongodb.client.internal.MongoDatabaseImpl.executeCommand(MongoDatabaseImpl.java:186)
at com.mongodb.client.internal.MongoDatabaseImpl.runCommand(MongoDatabaseImpl.java:155)
at com.mongodb.client.internal.MongoDatabaseImpl.runCommand(MongoDatabaseImpl.java:150)
at com.mongodb.client.internal.MongoDatabaseImpl.runCommand(MongoDatabaseImpl.java:140)
at org.jeecg.modules.jmreport.dyndb.JmreportNoSqlUtil.mongodbCommandFind(JmreportNoSqlUtil.java:257)
at org.jeecg.modules.jmreport.dyndb.JmreportNoSqlUtil.getMogodbResult(JmreportNoSqlUtil.java:156)
at org.jeecg.modules.jmreport.dyndb.JmreportNoSqlUtil.getListByMongodb(JmreportNoSqlUtil.java:106)
at org.jeecg.modules.jmreport.dyndb.JmreportNoSqlUtil.findList(JmreportNoSqlUtil.java:49)
at org.jeecg.modules.jmreport.desreport.service.a.i.parseReportSql(JmReportDbServiceImpl.java:648)
at org.jeecg.modules.jmreport.desreport.service.a.i$$FastClassBySpringCGLIB$$4daca655.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:685)
at org.jeecg.modules.jmreport.desreport.service.a.i$$EnhancerBySpringCGLIB$$39bb9797.parseReportSql()
at org.jeecg.modules.jmreport.desreport.a.a.a(DesignReportController.java:683)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:888)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:450)
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:92)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:108)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:526)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1579)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.mongodb.MongoCommandException: Command failed with error 18 (AuthenticationFailed): 'Authentication failed.' on server 192.168.0.247:27017. The full response is {"ok": 0.0, "errmsg": "Authentication failed.", "code": 18, "codeName": "AuthenticationFailed"}
at com.mongodb.internal.connection.ProtocolHelper.getCommandFailureException(ProtocolHelper.java:175)
at com.mongodb.internal.connection.InternalStreamConnection.receiveCommandMessageResponse(InternalStreamConnection.java:303)
at com.mongodb.internal.connection.InternalStreamConnection.sendAndReceive(InternalStreamConnection.java:259)
at com.mongodb.internal.connection.CommandHelper.sendAndReceive(CommandHelper.java:83)
at com.mongodb.internal.connection.CommandHelper.executeCommand(CommandHelper.java:33)
at com.mongodb.internal.connection.SaslAuthenticator.sendSaslStart(SaslAuthenticator.java:130)
at com.mongodb.internal.connection.SaslAuthenticator.access$100(SaslAuthenticator.java:40)
at com.mongodb.internal.connection.SaslAuthenticator$1.run(SaslAuthenticator.java:54)
... 115 more
2021-12-02 09:39:11.789 [QuartzScheduler_MyScheduler-DESKTOP-8C07LG71638408640104_ClusterManager] INFO o.s.scheduling.quartz.LocalDataSourceJobStore:3644 - ClusterManager: detected 1 failed or restarted instances.
2021-12-02 09:39:11.790 [QuartzScheduler_MyScheduler-DESKTOP-8C07LG71638408640104_ClusterManager] INFO o.s.scheduling.quartz.LocalDataSourceJobStore:3503 - ClusterManager: Scanning for instance "DESKTOP-GNLN4KD1638409002885"'s failed in-progress jobs.

升级1.4.11 还有问题吗?

因长时间未回复,暂时关闭此问题。

lvdandan 任务状态待办的 修改为已完成

登录 后才可以发表评论

状态
负责人
里程碑
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
开始日期   -   截止日期
-
置顶选项
优先级
参与者(4)
57093 jeecg 1662000782 8546150 czlhsms 1610020743
Java
1
https://gitee.com/jeecg/JimuReport.git
git@gitee.com:jeecg/JimuReport.git
jeecg
JimuReport
JimuReport

搜索帮助