Need Help!! Unable to view models in publisher after ARIS 7.2 SR2 upgrade

by Mr. Atreya Das (2012-02-03) in group We Love BPM

Hi,

I am new to ARIS and have been instructed to upgrade ARIS 7.2 with the latest service release.The installer ran successfully and even the ARIS designer is working fine, but I am unable to view models in the business publisher. On clicking on a certain model the publisher window just keeps showing the page as "loading information". I have the below logs which has been generated. But I am unable to make anything out of it. It would be or great help if someone can help out and point out what went wrong.have tried connecting to the DB using SQL+ and the connection is successful.

Please suggest

_____________________________________________________________________

IT_13543683b43_SEVERE 2012-02-03T08:29:58,866 BPError - .

Error loading newsFeed: 49sb-proxy1-v.me.corp.ids-scheer.com

- Original request query: /businesspublisher/layouts/default/home.jsp?IDSConversationID=R_3

IT_1354368bf48_SEVERE 2012-02-03T08:30:32,648 BPError - com.idsscheer.aris.businesspublisher.application.dao.ADAOFacade.getAllModelCxnDefHierarchies

NO MESSAGE AVAILABLEcom.idsscheer.aris.businesspublisher.application.dao.ADAOException: ADAOException

at com.idsscheer.aris.businesspublisher.application.dao.ADAOFacade.getAllModelCxnDefHierarchies(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.business.aris.context.model.ABPModelContext.loadCxnDefHierarchies(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.business.aris.context.model.ABPModelContext.loadHierarchies(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.business.aris.context.util.ABPContextHelper.getHierarchy(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.business.aris.context.util.ABPContextHelper.isAssignedToOtherModel(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.business.aris.context.connection.ABPCxnOccContext.hasHierarchy(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.business.aris.context.model.ABPModelContext.calcCxnAssignmentSymbolPos(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.business.aris.context.model.ABPModelContext.getCxnOccsImpl(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.business.aris.context.model.ABPModelContext.getCxnOccs(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.gui.view.modelgraphic.views.transformation.ABPContextTransformer.transformCxnOccs(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.gui.view.modelgraphic.views.transformation.ABPContextTransformer.transformHasUnions(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.gui.view.modelgraphic.views.transformation.ABPContextTransformer.transformModel(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.gui.view.modelgraphic.views.transformation.ABPContextTransformer.transformContext(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.gui.view.modelgraphic.views.transformation.ABPContextTransformer.transform(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.gui.view.modelgraphic.ABPModelGraphic.getARISGraphic(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.gui.view.modelgraphic.ABPModelGraphicProvider.getModelGraphic(Unknown Source)

at com.idsscheer.aris.businesspublisher.common.util.ABPGraphicHelper.getModelGraphic(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.business.aris.context.model.ABPModelContext.getModelGraphicFile(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.business.aris.context.model.ABPModelContext.getGfxDimensionImpl(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.business.aris.context.model.ABPModelContext.getGfxDimension(Unknown Source)

at org.apache.jsp.layouts.default_.mod_005fgfx_jsp._jspService(mod_005fgfx_jsp.java:2897)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)

at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)

at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)

at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)

at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1085)

at org.apache.struts.tiles.TilesRequestProcessor.doForward(TilesRequestProcessor.java:263)

at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:398)

at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(TilesRequestProcessor.java:318)

at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:241)

at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)

at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.idsscheer.aris.businesspublisher.application.web.filter.ABPWebRequestResponseSensorFilter.doFilterInternal(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.web.filter.ABPServletFilter.doFilter(Unknown Source)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.idsscheer.aris.businesspublisher.application.web.filter.ABPBadInputFilter.doFilterInternal(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.web.filter.ABPServletFilter.doFilter(Unknown Source)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.idsscheer.aris.businesspublisher.application.web.filter.ASessionFilter.doFilterInternal(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.web.filter.ABPServletFilter.doFilter(Unknown Source)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.idsscheer.aris.businesspublisher.application.web.filter.ABPForwardBackwardFilter.doFilterInternal(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.web.filter.ABPServletFilter.doFilter(Unknown Source)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.idsscheer.aris.businesspublisher.application.web.filter.ABPScopeFilter.doFilterInternal(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.web.filter.ABPServletFilter.doFilter(Unknown Source)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at com.idsscheer.aris.businesspublisher.application.web.filter.AEncodingFilter.doFilterInternal(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.web.filter.ABPServletFilter.doFilter(Unknown Source)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)

at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:861)

at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)

at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1584)

at java.lang.Thread.run(Thread.java:662)

Caused by: com.idsscheer.aris.businesspublisher.application.dao.util.ADAOSystemException: SQLException while getting CxnDefs Hierarchies;

at com.idsscheer.aris.businesspublisher.application.dao.util.ADAOUtils.translateException(Unknown Source)

at com.idsscheer.aris.businesspublisher.application.dao.model.ADbModelDAO.getAllCxnDefHierarchies(Unknown Source)

... 82 more

Caused by: org.springframework.jdbc.UncategorizedSQLException: SQLException while getting CxnDefs Hierarchies;; uncategorized SQLException for SQL []; SQL state [60000]; error code [600]; ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []

; nested exception is java.sql.SQLException: ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)

... 85 more

Caused by: java.sql.SQLException: ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:110)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:171)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)

at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:785)

at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:860)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)

at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3425)

at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1202)

at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)

... 83 more

- Original request query: /businesspublisher/defaultVisualisation.do?IDSConversationID=R_3&modelId=1152921530376650752&scale=&viewKey=

IT_1354368bf48_SEVERE 2012-02-03T08:30:32,663 BPError - com.idsscheer.aris.businesspublisher.application.dao.util.ADAOUtils.translateException

Exception while transforming of model DuPont Enterprise Processes (ID of ARIS model: 1152921530376650752)

- Original request query: /businesspublisher/defaultVisualisation.do?IDSConversationID=R_3&modelId=1152921530376650752&scale=&viewKey=

IT_1354368bf57_SEVERE 2012-02-03T08:30:32,663 BPError - com.idsscheer.aris.businesspublisher.application.dao.util.ADAOUtils.translateException

NO MESSAGE AVAILABLE

- Original request query: /businesspublisher/defaultVisualisation.do?IDSConversationID=R_3&modelId=1152921530376650752&scale=&viewKey=

Comments

by Mr. Vijaykumar Ijeri (2012-02-06)

Hi,

the below line suggests there is a failure in Db query.

You should get in touch with Oracle DBA for this.

nested exception is java.sql.SQLException: ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []

Regards,

Vijay