AD

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.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.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.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) 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=  
by Vijaykumar Ijeri
Posted on Mon, 02/06/2012 - 19:46

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

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock