【填表&采集】报表启动报错

gaotao

1.没有修改LY_REPORT下数据源信息，报错连接不上数据源

UPDATE T_DATASOURCE SET CONFIG='isaddtilde="false";convertdata="false";extend="";casesentence="false";type="1";password="aafeaafcaaenaafa";url="jdbcracle:thin192.168.6.41:1521/orcl";clientcharset="GBK";convertsql="false";dstype="0";useschema="false";driver="oracle.jdbc.driver.OracleDriver";dbcharset="UTF-8";user="TRMP";isautocommit="true"' WHERE NAME = 'TRMP';

b修改报表中间件数据源

UPDATE T_DATASOURCE SET CONFIG='password="aaemaafjaafpaafcaaefaafaaaepaafcaafe";user="LY_REPORT";type="1";dstype="0";isaddtilde="false";driver="oracle.jdbc.driver.OracleDriver";useschema="false";extend="";clientcharset="GBK";convertdata="false";casesentence="false";isautocommit="true";convertsql="false";dbcharset="UTF-8";url="jdbcracle:thin192.168.6.41:1521/orcl"' WHERE NAME = 'LY_REPORT';

c修改官方库数据源

UPDATE T_DATASOURCE SET CONFIG='isaddtilde="false";convertdata="false";extend="";casesentence="false";type="1";password="aaemaafjaafpaafdaaeeaaed";url="jdbcracle:thin192.168.6.41:1521/orcl";clientcharset="GBK";convertsql="false";dstype="0";useschema="false";driver="oracle.jdbc.driver.OracleDriver";dbcharset="UTF-8";user="LY_SDC";isautocommit="true"' WHERE NAME = 'LY_SDC';

2.没有修改GEEZNV5.0的配置文件../GEEZNV5.0\tomcat\conf\Catalina\localhost\reportmis.xml

3.报表连接12c数据库，需要添加兼容客户端语句SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8

4.查看报表账号是否被锁定




select * from dba_users where  account_status = 'LOCKED(TIMED)';
--C##LY_REPORT
alter user C##LY_REPORT account unlock;

xieyuefeng

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8
亲测可用