asifm
1 Copper

DFS Issue when creating document with name having single quote

I am using DFS .Net Productivity layer  6.6.0.38. It throws the following exception when I try  to create a new document with name having single quote. This happens when I call CreateMethod on the Object service. Please advise how to add a document with name having single quote.

"Create" operation failed for object: [test1's.txt] [id =null] PROPERTIES [object_name=test1's.txt|subject=Asif'Test|account_id=SCMLP-3|fund=SCMLP|doc_date=1/31/2011|doc_category=IPO Status Change|a_content_type=crtext]

 

messageIdjava

.lang.String<value>E_CREATING_OBJECT_TREE_FAILED_WITH_TREE_DUMP</value>com.emc.documentum.fs.services.core.CoreServiceExceptionjava.lang.Exception"Create" operation failed for object: [test1's.txt] [id =null] PROPERTIES [object_name=test1's.txt|subject=Asif'Test|account_id=SCMLP-3|fund=SCMLP|doc_date=1/31/2011|doc_category=IPO Status Change|a_content_type=crtext].

E_CREATING_OBJECT_TREE_FAILED_WITH_TREE_DUMP

.

 

messageIdjava

.lang.String<value>E_CREATE_CONTENTFUL_ACTION_FAILED</value>messageArgs[Ljava.lang.Object;<value><item xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xs="http://www.w3.org/2001/XMLSchema" xsi:type="xs:string">[test1's.txt] [id =null] PROPERTIES [object_name=test1's.txt|subject=Asif'Test|account_id=SCMLP-3|fund=SCMLP|doc_date=1/31/2011|doc_category=IPO Status Change|a_content_type=crtext]</item></value>com.emc.documentum.fs.services.core.CoreServiceExceptionjava.lang.ExceptionCreate contentful action with identity: "[test1's.txt] [id =null] PROPERTIES [object_name=test1's.txt|subject=Asif'Test|account_id=SCMLP-3|fund=SCMLP|doc_date=1/31/2011|doc_category=IPO Status Change|a_content_type=crtext]" failed.

E_CREATE_CONTENTFUL_ACTION_FAILED

 

messageIdjava

.lang.String<value>E_CREATE_CONTENTFUL_ACTION_FAILED</value>messageArgs[Ljava.lang.Object;<value><item xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xs="http://www.w3.org/2001/XMLSchema" xsi:type="xs:string">[test1's.txt] [id =null] PROPERTIES [object_name=test1's.txt|subject=Asif'Test|account_id=SCMLP-3|fund=SCMLP|doc_date=1/31/2011|doc_category=IPO Status Change|a_content_type=crtext]</item></value>com.emc.documentum.fs.services.core.impl.execution.proto.dfc.DfcOperationExceptionjava.lang.ExceptionCreate contentful action with identity: "[test1's.txt] [id =null] PROPERTIES [object_name=test1's.txt|subject=Asif'Test|account_id=SCMLP-3|fund=SCMLP|doc_date=1/31/2011|doc_category=IPO Status Change|a_content_type=crtext]" failed.

E_CREATE_CONTENTFUL_ACTION_FAILED

 

com

.documentum.fc.common.DfExceptionjava.lang.Exception[DM_QUERY_E_SYNTAX]error:

"A Parser Error (syntax error) has occurred in the vicinity of: SELECT COUNT(*) AS cnt FROM dm_document WHERE object_name='test1's"DM_QUERY_E_SYNTAX

 

 

"Create" operation failed

for object: [test1's.txt] [id =null] PROPERTIES [object_name=test1's.txt|subject=Asif'Test|account_id=SCMLP-3|fund=SCMLP|doc_date=1/31/2011|doc_category=IPO Status Change|a_content_type=crtext]

.

0 Kudos
1 Reply
asifm
1 Copper

Re: DFS Issue when creating document with name having single quote

Just to further clarify, it happens only when I am creating custom document type. It works fine when I create dm_document. Again from the error it seems, DFS library is trying to get document using DQL query w/o escaping the single quote. Here is the exception again.

 

"A Parser Error (syntax error) has occurred in the vicinity of: SELECT COUNT(*) AS cnt FROM dm_document WHERE object_name='linked'Document"DM_QUERY_E_SYNTAX

"Create" operation failed

for object: [linked'Document 2634618078258251065] [id =null] PROPERTIES [object_name=linked'Document 2634618078258251065]

.

0 Kudos