IBM WebShpere Portal导出页面层次结构报错

在导出内容根时选择导出层次结构,报以下错误:

        com.ibm.wps.command.xml.XmlCommandException: EJPXA0033E: An error occurred while retrieving the configuration of the resource. [content-node 6_000000000000000000000000A0 uniquename=wps.content.root]

        com.ibm.wps.util.DataBackendException: EJPDB0001E: Error occurred during database access. Last SQL statement is [SELECT OID, CREATED, MODIFIED, IS_ACTIVE, IS_SYSTEM, IS_SHARED, IS_PROVIDED, ALL_PORT_ALLOWED, ORDINAL, PARENT_OID, PARENT_SL, CONT_PARENT_OID, CONT_PARENT_SL, SKIN_DESC_OID, SKIN_DESC_SL, THEME_DESC_OID, THEME_DESC_SL, CREATE_TYPE, TYPE, TF_INST_OID, SERVER_INFO_OID, SERVER_INFO_SL FROM customization.PAGE_INST START WITH CONT_PARENT_SL IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) CONNECT BY (PRIOR OID = CONT_PARENT_OID)].

        java.sql.SQLException: ORA-00600: internal error code, arguments: [qkacon:FJswrwo], [10], [], [], [], [], [], []

   

请各位大神帮忙解决,谢谢

参与8

2同行回答

frankyfwhfrankyfwh软件开发工程师JH
在排查问题的时候犯了傻,最后面那句报错的语句没有发现,主要是数据库的问题,解决方式如下:是有关connect by的一个bug1.altersystem set "_optimizer_connect_by_cost_based" = FALSE scope=both;2.altersystem set "_allow_level_without_connect_by" = true scope=both;...显示全部

在排查问题的时候犯了傻,最后面那句报错的语句没有发现,主要是数据库的问题,解决方式如下:

是有关connect by的一个bug

1.altersystem set "_optimizer_connect_by_cost_based" = FALSE scope=both;

2.altersystem set "_allow_level_without_connect_by" = true scope=both;

收起
软件开发 · 2016-05-12
浏览1024
liufei930812liufei930812研发工程师lumeda
这是数据库问题啊显示全部

这是数据库问题啊

收起
系统集成 · 2016-05-26
浏览857

提问者

frankyfwh
软件开发工程师JH
擅长领域: portal中间件

问题状态

  • 发布时间:2016-05-10
  • 关注会员:3 人
  • 问题浏览:2483
  • 最近回答:2016-05-26
  • X社区推广