页面树结构
转至元数据结尾
转至元数据起始

(本文档仅供参考)

问题现象

          以达梦7作为知识库,这时候空库部署启动的时候,会抛出如下错误:

[2019-06-10 18:13:54] [INFO] [System.out] [06-10 18:13:54 INFO doUpgrade(smartbi.repository.RepositoryUpgradeHelper:422) - Upgraded module 'smartbi.repository' version from 0.0.12 to 0.0.13
]
[2019-06-10 18:13:54] [INFO] [System.out] [06-10 18:13:54 ERROR doUpgrade(smartbi.repository.upgrade.UpgradeTask_0_0_13:86) - upgrade failed
java.sql.SQLException: 第1 行附近出现错误:
表[t_operationlog]中不能同时包含聚集KEY和大字段
at dm.jdbc.dbaccess.DBError.throwSQLException(DBError.java:44)
at dm.jdbc.dbaccess.Request_Response.resp_checkErr(Request_Response.java:2464)
at dm.jdbc.dbaccess.Request_Response.resp_prepare(Request_Response.java:679)
at dm.jdbc.dbaccess.DmdbCSI.prepareSQL(DmdbCSI.java:399)
at dm.jdbc.driver.DmdbStatement_bs.directExec(DmdbStatement_bs.java:1804)
at dm.jdbc.driver.DmdbPreparedStatement_bs.initialize(DmdbPreparedStatement_bs.java:246)
at dm.jdbc.driver.DmdbPreparedStatement_bs.<init>(DmdbPreparedStatement_bs.java:186)
at dm.jdbc.driver.DmdbConnection_bs.prepareStatement(DmdbConnection_bs.java:2088)
at dm.jdbc.driver.DmdbConnection_bs.prepareStatement(DmdbConnection_bs.java:707)
at dm.jdbc.driver.DmdbConnection.do_prepareStatement(DmdbConnection.java:1498)

解决方案

         此问题经咨询达梦官方的技术支持,在达梦7.15版本之后聚集主键和大字段不能共存,需要修改达梦数据库的配置文件,将默认主键创建为普通主键,即非聚集,修改./data/数据库实例/dm.ini中的参数PK_WITH_CLUSTER改为0即可。修改配置后需要重启达梦数据库的相关服务。


Viewtracker License Missing

There is a problem with the license of the Viewtracker addon. Please check if you have a valid license.

授权码细节


  • 无标签