BIEE12c迁移后obis1服务启动失败

0
求大神赐教,问题如下:
环境:BIEE12c
操作:做了catalog迁移和rpd迁移
操作步骤:catalog迁移方法同11g;rpd迁移使用命令:BIEE12c/Middleware/Oracle_Home/user_projects/domains/bi_domain/bitools/bin/data-model-cmd.sh uploadrpd -u weblogic -p weblogic1 -i 155_20160314.rpd -w Admin123 -S biee123 -SI ssi,提示迁移成功
问题:迁移成功后重启整个服务后,obis1组件无法启动,前端analytics界面无法登录,截图如下:

fw.png


dl.png


rpd.png

日志报错信息:Oracle BI Server starting...
errCode:0 errSQLStateBuf:HYT00 errMsg:[DataDirect][ODBC Oracle Wire Protocol driver]Timeout expired.
errCode:0 errSQLStateBuf:08003 errMsg:[DataDirect][ODBC lib] Connection not open
Oracle BI Server startup failed.
nqsserver:    Oracle BI Server shutdown.
<Mar 16, 2016 8:43:19 AM PDT> <INFO> <NodeManager ComponentManager> <The server 'obis1' with process id 28278 is no longer alive; waiting for the process to die.>
<Mar 16, 2016 8:43:19 AM PDT> <FINEST> <NodeManager ComponentManager> <Process died.>
<Mar 16, 2016 8:43:19 AM PDT> <FINEST> <NodeManager ComponentManager> <get latest startup configuration before deciding/trying to restart the server>
<Mar 16, 2016 8:43:19 AM PDT> <INFO> <NodeManager ComponentManager> <Server failed but will not be restarted because the maximum number of restart attempts has been exceeded>
<Mar 16, 2016 8:43:19 AM PDT> <FINEST> <NodeManager ComponentManager> <runMonitor returned, setting finished=true and notifying waiters>
补充:之前做过相同的迁移重启后并没有报错
已邀请:
1

Umasou 2018-11-27 回答

我的解决方案是这样的,亲测有效
1、定位到如下目录:
/home/Oracle/Middleware/Oracle_Home/user_project/domain/bi_domain/bidata/service_instance/ssi/metadata/datamodel/customizations
2、备份并删除rpd文件和xml文件
执行命令:rm default/default-diff.xml liverpd.rpd_1
执行命令:cp liverpd.rpd liverpd.rpd.bak
3、运行 ./stop.sh 停止BIEE服务
4、运行 ./start.sh 启动BIEE服务
5、执行rpd上传命令上传需要迁移的rpd即可!
 
 
 
0

seng - 从事BI、大数据、数据分析工作 2016-03-17 回答

nqserver的日志怎么说?
0

黑衣者 - 90后 2016-05-10 回答

请问一下,你的问题解决了么?

要回复问题请先登录注册