Unsolved
This post is more than 5 years old
1 Rookie
•
2 Posts
0
2031
January 10th, 2012 08:00
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; 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; 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]
.
asifm
1 Rookie
•
2 Posts
0
January 10th, 2012 13:00
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]
.