DM_QUERY_E_CURSOR_ERROR in xCP 2.0 sample application

Hello,

In xcp 2.0 sample application, I face the error shown below.I have just downloaded and deployed the sample application from community website. Do you have an idea about a possible cause of this problem? It seems as if the system can't query dm_document objects. The same error occurs in place shown the picture attached and also in folder navigation tree when a folder has some dm_documents as children.

Thanks in advance

==========

An error occurred while performing the requested operation. Please try again.

Details

An error has occurred during query execution. Please contact your administrator.

Error code: Failure while executing realtime search; nested exception is DfException:: THREAD: http-bio-8282-exec-2; MSG: [DM_QUERY_E_CURSOR_ERROR]error: "A database error has occurred during the creation of a cursor ('ORA-00936: missing expression')."; ERRORCODE: 100; NEXT: null
Failure while executing realtime search; nested exception is DfException:: THREAD: http-bio-8282-exec-2; MSG: [DM_QUERY_E_CURSOR_ERROR]error: "A database error has occurred during the creation of a cursor ('ORA-00936: missing expression')."; ERRORCODE: 100; NEXT: null

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

ssumic

I have solved my problem by installing the latest patch (P12) for Content Server.

The bug was described in Patch Release Notes as fixed in patch 4:

Patch 4 Fixed Issues List

CS-40638

In an environment where reference application is deployed on SQL Server 2012 , folder navigation is tried DM_QUERY_E_CURSOR_ERROR error which was thrown is not seen when DM_LEFT_OUTER_JOIN_FOR_ACL=T is used.

I know that you are using Oracle, but it might be worth trying with the latest patch. If it solves your problem too, please mark the question as answered...

Best regards,

Stipe

All comments

PanfilovAB

Could you share sample application? Looks like there is a database activity with wrong SQL.

ssumic

I'm getting almost the same error, also in sample application "Concordant Insurance" from XCP 2.0 Self Paced Tutorial:

ci_1.PNG.png

Also, similar error occurs whenever the application is trying to show contents of the folder:

ci_2.PNG.png

Looking at the logs, this is the stack trace:

INFO | jvm 1 | 2013/12/05 16:19:02 | Caused by: DfException:: THREAD: tomcat-http--173; MSG: [DM_QUERY_E_CURSOR_ERROR]error: "A database error has occurred during the creation of a cursor (' STATE=42000, CODE=4104, MSG=[Microsoft][ODBC SQL Server Driver][SQL Server]The multi-part identifier ".i_folder_id" could not be bound.

INFO | jvm 1 | 2013/12/05 16:19:02 | ')."; ERRORCODE: 100; NEXT: null

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.documentum.fc.client.impl.docbase.DocbaseExceptionMapper.newException(DocbaseExceptionMapper.java:57)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.documentum.fc.client.impl.connection.docbase.MessageEntry.getException(MessageEntry.java:39)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.documentum.fc.client.impl.connection.docbase.DocbaseMessageManager.getException(DocbaseMessageManager.java:137)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.documentum.fc.client.impl.connection.docbase.netwise.NetwiseDocbaseRpcClient.checkForMessages(NetwiseDocbaseRpcClient.java:310)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.documentum.fc.client.impl.connection.docbase.netwise.NetwiseDocbaseRpcClient.applyForCollection(NetwiseDocbaseRpcClient.java:434)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.documentum.fc.client.impl.connection.docbase.DocbaseConnection$3.evaluate(DocbaseConnection.java:1210)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.documentum.fc.client.impl.connection.docbase.DocbaseConnection.evaluateRpc(DocbaseConnection.java:1072)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.documentum.fc.client.impl.connection.docbase.DocbaseConnection.applyForCollection(DocbaseConnection.java:1198)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.documentum.fc.client.impl.docbase.DocbaseApi.exec(DocbaseApi.java:83)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.documentum.fc.client.impl.session.Session.query(Session.java:3485)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.documentum.fc.client.impl.session.SessionHandle.query(SessionHandle.java:2322)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.documentum.fc.client.DfQuery.runQuery(DfQuery.java:167)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.documentum.fc.client.DfQuery.execute(DfQuery.java:211)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.emc.xcp.datalist.common.impl.Util.runQuery(Util.java:64)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.emc.xcp.datalist.common.impl.DataListCachedCollection.runDQL(DataListCachedCollection.java:1039)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.emc.xcp.datalist.common.impl.DataListCachedCollection.runDQLInternal(DataListCachedCollection.java:1029)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.emc.xcp.datalist.common.impl.DataListCachedCollection.executeQuery(DataListCachedCollection.java:997)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.emc.xcp.datalist.common.impl.DataListCachedCollection.executeQuery(DataListCachedCollection.java:985)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.emc.xcp.datalist.common.impl.DataListCachedCollection.cacheNextBlock(DataListCachedCollection.java:549)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.emc.xcp.datalist.common.impl.DataListCachedCollection.setPage(DataListCachedCollection.java:363)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.emc.xcp.datalist.common.impl.DataListMediator.fillDataList(DataListMediator.java:234)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.emc.xcp.datalist.common.impl.DataListMediator.fill(DataListMediator.java:87)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.emc.xcp.datalist.common.impl.AbstractDataList.fillMediator(AbstractDataList.java:328)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.emc.xcp.datalist.common.impl.AbstractDataList.getPage(AbstractDataList.java:156)

INFO | jvm 1 | 2013/12/05 16:19:02 | at com.emc.xcp.services.datasource.realtime.documentum.RealtimeQueryExecutor.execute(RealtimeQueryExecutor.java:39)

INFO | jvm 1 | 2013/12/05 16:19:02 | ... 106 more

It seems that the following DQL:

SELECT DISTINCT a1."acl_name" AS a1_acl_name,a1."r_creation_date" AS a1_r_creation_date,a1."r_lock_date" AS a1_r_lock_date,a1."a_content_type" AS a1_a_content_type,a1."r_object_type" AS a1_r_object_type,a1."owner_name" AS a1_owner_name,a1."owner_permit" AS a1_owner_permit,a1."r_frozen_flag" AS a1_r_frozen_flag,a1."r_immutable_flag" AS a1_r_immutable_flag,a1."r_object_id" AS a1_r_object_id,a1."r_lock_owner" AS a1_r_lock_owner,a1."r_modify_date" AS a1_r_modify_date,a1."r_link_cnt" AS a1_r_link_cnt,a1."object_name" AS a1_object_name,a1."r_creator_name" AS a1_r_creator_name,a1."r_modifier" AS a1_r_modifier,a1."acl_domain" AS a1_acl_domain,a1."i_chronicle_id" AS a1_i_chronicle_id FROM dm_sysobject a1 WITH(SQL_SERVER('FORCESEEK')) WHERE ( ANY a1."i_folder_id"='0c0386c980000107' AND a1."a_is_hidden"=false) ENABLE(RETURN_RANGE 1 11 11 'a1.r_object_id ASC', RETURN_TOP 11, OBJECT_BASED)

is translated into an invalid SQL command:

select * from ( select distinct TOP 11 a1.acl_name "a1_acl_name", a1.r_creation_date "a1_r_creation_date", a1.r_lock_date "a1_r_lock_date", a1.a_content_type "a1_a_content_type", a1.r_object_type "a1_r_object_type", a1.owner_name "a1_owner_name", a1.owner_permit "a1_owner_permit", a1.r_frozen_flag "a1_r_frozen_flag", a1.r_immutable_flag "a1_r_immutable_flag", a1.r_object_id "a1_r_object_id", a1.r_lock_owner "a1_r_lock_owner", a1.r_modify_date "a1_r_modify_date", a1.r_link_cnt "a1_r_link_cnt", a1.object_name "a1_object_name", a1.r_creator_name "a1_r_creator_name", a1.r_modifier "a1_r_modifier", a1.acl_domain "a1_acl_domain", a1.i_chronicle_id "a1_i_chronicle_id", CAST(ROW_NUMBER() OVER(ORDER BY a1.r_object_id ASC) as int) as dm_rnum from dm_sysobject_sp a1 ( FORCESEEK), dm_sysobject_r where ( ((.i_folder_id=N'0c0386c980000107') and (a1.a_is_hidden=0)) ) and (a1.i_has_folder = 1 and a1.i_is_deleted = 0) and .r_object_id=a1.r_object_id ) dm_inline_view_1 where dm_rnum >= 1 AND dm_rnum <= 11 OPTION ( FAST 11)

Imran_Yusubov

I thought, I was the only one getting error in this application.

ssumic

I have solved my problem by installing the latest patch (P12) for Content Server.

The bug was described in Patch Release Notes as fixed in patch 4:

Patch 4 Fixed Issues List

CS-40638

I know that you are using Oracle, but it might be worth trying with the latest patch. If it solves your problem too, please mark the question as answered...

Best regards,

Stipe

Imran_Yusubov

Thanks.