knowage:An error has occurred. Retry later.


SpagoBI/Knowage 登录首页后报错:

1
2
An error has occurred. Retry later.
If the problems persists, contact the system administrator.

刷新多次可能正常登录。

跟踪日志发现错误:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 69,949,658 milliseconds ago.  The last packet sent successfully to the server was 69,949,659 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
at sun.reflect.GeneratedConstructorAccessor249.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1036)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3661)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2417)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4842)
at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.setAutoCommit(DelegatingConnection.java:371)
at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.setAutoCommit(PoolingDataSource.java:328)
at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:87)
... 43 more
Caused by: java.net.SocketException: Connection reset
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3643)
... 50 more

解决方案

修改server.xml中JNDI配置:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<Resource auth="Container" driverClassName="com.mysql.jdbc.Driver"
maxActive="200"
maxIdle="50"
maxWait="-1"
name="jdbc/knowage"
type="javax.sql.DataSource"
url="jdbc:mysql://a.x:3306/knowagedb" username="knowageuser" password="knowagepassword"
logAbandoned="true"
removeAbandoned="true"
removeAbandonedTimeout="10"
validationQuery="select 1 from dual"
testWhileIdle="true"
testOnBorrow="false"
timeBetweenEvictionRunsMillis="30000"
minEvictableIdleTimeMillis="1800000"
numTestsPerEvictionRun="3"
/>

使用过程中遇到任何问题欢迎留言或加入Knowage开源BI中国社区:QQ 158245788


文章作者: KavenRan
版权声明: 本博客所有文章除特別声明外,均采用 CC BY 4.0 许可协议。转载请注明来源 KavenRan !
 上一篇
Knowage汉化Document不能保存中文字符问题修复 Knowage汉化Document不能保存中文字符问题修复
Knoage-6.x社区版(spagoBI升级版)在使用时发现Document不能保存中文字符。 TAG:Knowage汉化,SpagoBI汉化,Knowage中文版,Knowage中文乱码 场景现象如果想报表名或描述保存为中文
2018-08-20
下一篇 
令人称赞的13个shell脚本技巧 令人称赞的13个shell脚本技巧
脚本代是开发人员写给开发人员看的,如果你想让后面看你代码的人称赞的话你应该考虑你的代码风格。 失败代码风格会导致一些问题: 混乱的脚本——我知道,我们都是工程师,读得懂代码,但即使这样,也请为我们这些对 Shell 脚本不是很熟练的
2018-06-19
  目录