AD
Hi,
I have been encountering a find errror while searching models in ARIS business server. The find error works at the root level of a repository but it throws an error if i search for a particular model or object down in the sub groups. The error surfaced few months back but it vanished automatically. Now it has resurfaced again. I am attaching the logs below. Can anyone help me out with a solution to this. Below is the log.
2012-03-06T03:13:05,792 com.idsscheer.aris.server.Exceptions - Exception, userinfo: DB: XY_BPM, user: dasa, client: app=ARIS Business Architect for SAP; user=XXXX; pid=; exe=ARIS Business Architect for SAP; ip=X.X.X.X; pattern=ArchitectmySAP com.idsscheer.aris.server.bl.logic.web.ABLHelper.printUnexpectedException com.idsscheer.aris.server.ul.AULLoginException: Unexpected param datatype id '101' at param ':p0' define plan ExtSearch( IOID[100] :p0 , int :p1 , IOID :p2 , string :p3 , int :p4 , IOID :p5 ) as ( select * from ObjDef where (((ID in ( select ParentItemId from AttrTextDefTbl<ObjDef> where AttrTypeNum = :p1 and LanguageId = :p2 and TextValue TNFEQ :p3 using wildcards ) OR ID not in ( select ParentItemId from AttrDefTbl<ObjDef> where AttrTypeNum = :p0 and LanguageId = :p1 ) AND 1 = 1) AND ID in ( select ParentItemId from AttrDefTbl<ObjDef> where AttrTypeNum = :p4 and LanguageId = :p5 ) )) and GroupID in :p0 ) at com.idsscheer.aris.server.ul.aris.logic.AUserObjectManager.loadArisObjects(Unknown Source) at com.idsscheer.aris.server.bl.logic.queryexecution.AQueryExecution.newSearch(Unknown Source) at com.idsscheer.aris.server.bl.logic.queryexecution.AQueryExecution.simpleSearchWithIterableResult(Unknown Source) at com.idsscheer.aris.server.tl.queryexecution.AQueryExecutionComponent.extQuery(Unknown Source) at com.idsscheer.aris.cltech.common.core.queryexecution.IQueryExecutionDelegate.extQuery(Unknown Source) at com.idsscheer.aris.cltech.common.corba.queryexecution.IQueryExecutionServant.extQuery(Unknown Source) at com.idsscheer.aris.cltech.common.corba.queryexecution.IQueryExecutionPOATie.extQuery(Unknown Source) at com.idsscheer.aris.cltech.common.corba.queryexecution.IQueryExecutionPOA._OB_op_extQuery(Unknown Source) at com.idsscheer.aris.cltech.common.corba.queryexecution.IQueryExecutionPOA._invoke(Unknown Source) at com.ooc.OBPortableServer.ServantDispatcher.dispatch(Unknown Source) at com.ooc.OBPortableServer.POA_impl._OB_dispatch(Unknown Source) at com.ooc.OB.DispatchRequest_impl.invoke(Unknown Source) at com.ooc.OB.ThreadPool$Dispatcher.run(Unknown Source) Caused by: OLException: Unexpected param datatype id '101' at param ':p0' define plan ExtSearch( IOID[100] :p0 , int :p1 , IOID :p2 , string :p3 , int :p4 , IOID :p5 ) as ( select * from ObjDef where (((ID in ( select ParentItemId from AttrTextDefTbl<ObjDef> where AttrTypeNum = :p1 and LanguageId = :p2 and TextValue TNFEQ :p3 using wildcards ) OR ID not in ( select ParentItemId from AttrDefTbl<ObjDef> where AttrTypeNum = :p0 and LanguageId = :p1 ) AND 1 = 1) AND ID in ( select ParentItemId from AttrDefTbl<ObjDef> where AttrTypeNum = :p4 and LanguageId = :p5 ) )) and GroupID in :p0 ) at com.idsscheer.aris.server.ol.logic.AOLExceptionFactory.createOLException(Unknown Source) at com.idsscheer.aris.server.ol.logic.AObjectManager.load(Unknown Source) at com.idsscheer.aris.server.ol.logic.AObjectManager.loadDBObjects(Unknown Source) ... 13 more Caused by: DLException: Unexpected param datatype id '101' at param ':p0' define plan ExtSearch( IOID[100] :p0 , int :p1 , IOID :p2 , string :p3 , int :p4 , IOID :p5 ) as ( select * from ObjDef where (((ID in ( select ParentItemId from AttrTextDefTbl<ObjDef> where AttrTypeNum = :p1 and LanguageId = :p2 and TextValue TNFEQ :p3 using wildcards ) OR ID not in ( select ParentItemId from AttrDefTbl<ObjDef> where AttrTypeNum = :p0 and LanguageId = :p1 ) AND 1 = 1) AND ID in ( select ParentItemId from AttrDefTbl<ObjDef> where AttrTypeNum = :p4 and LanguageId = :p5 ) )) and GroupID in :p0 ) at com.idsscheer.aris.server.usecasemgt.AUseCaseExecutor.createPlan(Unknown Source) at com.idsscheer.aris.server.usecasemgt.AUseCaseExecutor.getPlan(Unknown Source) at com.idsscheer.aris.server.usecasemgt.AUseCaseExecutor.executePlan2(Unknown Source) at com.idsscheer.aris.server.usecasemgt.AUseCaseExecutor.executePlan(Unknown Source) at com.idsscheer.aris.server.recordprovider.APlanRecordProvider.getRecords(Unknown Source) ... 15 more Caused by: DLException: Unexpected param datatype id '101' at param ':p0' at com.idsscheer.dl.mapimpl.ora.dl.AORAQueryPlanEngine$1.buildConditionClause(AORAQueryPlanEngine.java:59) at com.idsscheer.dl.logic.jdbcbased.qpleng.APlanNodeBuilder.buildThisWhereClause(APlanNodeBuilder.java:586) at com.idsscheer.dl.logic.jdbcbased.qpleng.APlanNodeBuilder.createPlanNode(APlanNodeBuilder.java:241) at com.idsscheer.dl.logic.jdbcbased.qpleng.APlanNodeBuilder.createPlanNodes(APlanNodeBuilder.java:164) at com.idsscheer.dl.logic.jdbcbased.qpleng.APlanBuildNode.buildQueryPlanNodes(APlanBuildNode.java:119) at com.idsscheer.dl.logic.jdbcbased.qpleng.AQueryPlanEngine.generateQueryPlan(AQueryPlanEngine.java:185) at com.idsscheer.dl.logic.jdbcbased.qpleng.AQueryPlanEngine.createQueryPlan(AQueryPlanEngine.java:103) ... 20 more Caused by: Unexpected param datatype id '101' at param ':p0' at com.idsscheer.dl.logic.jdbcbased.qpleng.AConditionBuilder.simple_buildConditionClauseRec(AConditionBuilder.java:1769) at com.idsscheer.dl.logic.jdbcbased.qpleng.AConditionBuilder.simple_buildPredicateClause(AConditionBuilder.java:1854) at com.idsscheer.dl.logic.jdbcbased.qpleng.AConditionBuilder.simple_buildConditionClauseRec(AConditionBuilder.java:1405) at com.idsscheer.dl.logic.jdbcbased.qpleng.AConditionBuilder.simple_buildConditionClauseRec(AConditionBuilder.java:1425) at com.idsscheer.dl.logic.jdbcbased.qpleng.AConditionBuilder.buildConditionClauseRecSubSelect(AConditionBuilder.java:1266) at com.idsscheer.dl.logic.jdbcbased.qpleng.AConditionBuilder.buildConditionClauseRec(AConditionBuilder.java:400) at com.idsscheer.dl.logic.jdbcbased.qpleng.AConditionBuilder.buildConditionClauseRec(AConditionBuilder.java:475) at com.idsscheer.dl.logic.jdbcbased.qpleng.AConditionBuilder.buildConditionClauseRec(AConditionBuilder.java:494) at com.idsscheer.dl.logic.jdbcbased.qpleng.AConditionBuilder.buildConditionClauseRec(AConditionBuilder.java:475) at com.idsscheer.dl.logic.jdbcbased.qpleng.AConditionBuilder.buildConditionClauseRec(AConditionBuilder.java:475) at com.idsscheer.dl.logic.jdbcbased.qpleng.AConditionBuilder.buildConditionClause(AConditionBuilder.java:187) at com.idsscheer.dl.mapimpl.ora.dl.AORAQueryPlanEngine$1.buildConditionClause(AORAQueryPlanEngine.java:55) ... 26 more In the attached below, In the lookin field if i search for the object/model in the dupont_bpm level,then either it shows "no records found" or comes up with all the search output. but doesnt throw an error.It throws the error if a go a level down in the hierarchy.As shown in the second attachment. The find works if i use it at the root level (1), but it throws the unknown error if i use the find functionality at 2.
