nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Import Operation using DFC

e234934

Hi,

I am using documentum 6.0. I would like to import a document from my local harddrive to a docbase location in content server. The following is my code.

public void importFiles(String strFilename)

throws Exception

{

IDfSession objSess = null;

IDfClientX objClientX = null;

IDfImportOperation objImpOper = null;

IDfId objDestId = null;

IDfFile objLocalFile = null;

IDfImportNode objImpNode = null;

IDfSessionManager dfSessionManager = null;

try {

objClientX = new DfClientX();

dfSessionManager = MyClass.getSessionMgr(

<Docbase_name>);

objSess = dfSessionManager.newSession(

<Docbase_name>);

IDfLoginInfo loginInfo = dfSessionManager.getIdentity(<Docbase_name>);

objImpOper = objClientX.getImportOperation();

objLocalFile = objClientX.getFile(strFilename);

objImpNode = (IDfImportNode) objImpOper.add(objLocalFile);

objDestId = new DfId ("0b0020ca8002e212");

objImpNode.setDestinationFolderId(objDestId);

objImpNode.setNewObjectName(objLocalFile.getName());

objImpNode.setDocbaseObjectType("reports");

objImpOper.setSession(objSess);

if (objImpOper.execute()) {

System.out.println("Import operation succeeded");

} else {

System.out.println("Import operation failed");

}

this is how I invoke the method

this.importFiles("C:
test
test.doc");

Whenever I call this export method, an exception will be thrown at the execution line in bold:

objImpOper.execute();

The error thrown is as follows:

DfException:: THREAD: http-8080-1; MSG: error: "You have specified a SysObject predicate (folder), but a dm_sysobject subtype was not specified as the first type in the FROM clause in this select or subselect."; ERRORCODE: 100; NEXT: null

at com.documentum.fc.client.impl.docbase.DocbaseExceptionMapper.newException(DocbaseExceptionMapper.java:57)

at com.documentum.fc.client.impl.connection.docbase.MessageEntry.getException(MessageEntry.java:39)

at com.documentum.fc.client.impl.connection.docbase.DocbaseMessageManager.getException(DocbaseMessageManager.java:134)

at com.documentum.fc.client.impl.connection.docbase.netwise.NetwiseDocbaseRpcClient.checkForMessages(NetwiseDocbaseRpcClient.java:191)

at com.documentum.fc.client.impl.connection.docbase.netwise.NetwiseDocbaseRpcClient.applyForCollection(NetwiseDocbaseRpcClient.java:286)

at com.documentum.fc.client.impl.connection.docbase.DocbaseConnection$3.evaluate(DocbaseConnection.java:867)

at com.documentum.fc.client.impl.connection.docbase.DocbaseConnection.evaluateRpc(DocbaseConnection.java:751)

at com.documentum.fc.client.impl.connection.docbase.DocbaseConnection.applyForCollection(DocbaseConnection.java:862)

at com.documentum.fc.client.impl.docbase.DocbaseApi.exec(DocbaseApi.java:69)

at com.documentum.fc.client.impl.session.Session.query(Session.java:3115)

at com.documentum.fc.client.impl.session.SessionHandle.query(SessionHandle.java:2177)

at com.documentum.fc.client.DfQuery.runQuery(DfQuery.java:137)

at com.documentum.fc.client.DfQuery.execute(DfQuery.java:179)

at com.documentum.fc.client.impl.bof.registry.DocbaseModuleRegistry.getListFromRepository(DocbaseModuleRegistry.java:246)

at com.documentum.fc.client.impl.bof.registry.DocbaseModuleRegistry.lookupInRepository(DocbaseModuleRegistry.java:128)

at com.documentum.fc.client.impl.bof.registry.DocbaseModuleRegistry.lookupRaw(DocbaseModuleRegistry.java:93)

at com.documentum.fc.client.impl.bof.compoundclass.CompoundClassMgr.lookupTBOMetadata(CompoundClassMgr.java:218)

at com.documentum.fc.client.impl.bof.compoundclass.CompoundClassMgr.getTboClass(CompoundClassMgr.java:188)

at com.documentum.fc.client.impl.bof.compoundclass.CompoundClassMgr.getTboClass(CompoundClassMgr.java:199)

at com.documentum.fc.client.impl.bof.compoundclass.CompoundClassMgr.getImpClass(CompoundClassMgr.java:67)

at com.documentum.fc.client.impl.objectmanager.AbstractPersistentObjectFactory.getCompoundClassEntry(AbstractPersistentObjectFactory.java:39)

at com.documentum.fc.client.impl.objectmanager.PObjectFactoryWithAspects.makeObject(PObjectFactoryWithAspects.java:47)

at com.documentum.fc.client.impl.objectmanager.PersistentObjectManager.getObjectFromServer(PersistentObjectManager.java:318)

at com.documentum.fc.client.impl.objectmanager.PersistentObjectManager.getObject(PersistentObjectManager.java:275)

at com.documentum.fc.client.impl.session.Session.getObjectWithCaching(Session.java:765)

at com.documentum.fc.client.impl.FormatManager.getFormat(FormatManager.java:49)

at com.documentum.fc.client.impl.session.Session.getFormat(Session.java:1114)

at com.documentum.fc.client.impl.session.SessionHandle.getFormat(SessionHandle.java:863)

at com.documentum.operations.DfFormatRecognizer.removeNonDocbaseFormats(DfFormatRecognizer.java:1063)

at com.documentum.operations.DfFormatRecognizer.getSuggestedFileFormats(DfFormatRecognizer.java:183)

at com.documentum.operations.DfFormatRecognizer.getDefaultSuggestedFileFormat(DfFormatRecognizer.java:206)

at com.documentum.operations.impl.DfXMLUtils.checkFormat(DfXMLUtils.java:191)

at com.documentum.operations.impl.DfXMLUtils.isXML(DfXMLUtils.java:68)

at com.documentum.operations.nodeactions.inbound.impl.DfApplyXMLForImport.applyXMLApplication(DfApplyXMLForImport.java:108)

at com.documentum.operations.nodeactions.inbound.impl.DfApplyXMLForImport.execute(DfApplyXMLForImport.java:57)

at com.documentum.operations.steps.impl.DfOperationStep.execute(DfOperationStep.java:130)

at com.documentum.operations.impl.DfOperation.execute(DfOperation.java:437)

at com.honeywell.documentum.dql.TechArcRepDQL.importFiles(TechArcRepDQL.java:124)

at com.honeywell.documentum.action.TechArcReportAction.execute(TechArcReportAction.java:82)

at com.honeywell.documentum.controller.ControllerServlet.processRequest(ControllerServlet.java:120)

at com.honeywell.documentum.controller.ControllerServlet.doPost(ControllerServlet.java:75)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

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.StandardWrapperValve.invoke(StandardWrapperValve.java:228)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:212)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:818)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:624)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445)

at java.lang.Thread.run(Unknown Source)

Any idea what went wrong here? I am trying to import a document of type .doc. Any help is greatly appreciated. Thanks in advance.

Find more posts tagged with

Comments

mszurap

Hi,

objImpOper.setSession(objSess);

this is quite important call, have you tried to put this line before you get your ImportNode?

Cheers,

Mike

e234934

Hi,

I tried placing the line "objImpOper.setSession(objSess);" before getting ImportNode.But still getting the same exception.

Also the below error got logged.

Error Message--> Could not check in document 'test.doc'

Error Code--> 1013

mszurap

I have a feeling, that your target folder ("0b0020ca8002e212") is restricted for the user you are connected to the docbase. Check if your user has "Folder Restriction" set in DA.

aflowers001

Try these

a. does the type "reports" exist, perhaps a data dictionary publish might be needed?

b. is the "reports" type s subtype of dm_sysobject?

c. does the type "reports" have any TBO associated with it?

e234934

Hi,

Since the type "reports" already exists, the data dictionary publish has already been done.

"reports" type is a subtype of dm_sysobject.

The type "reports" have no TBOs associated with it.

aflowers001

Hi,

Since we know the types are there have you tried turning on DFC & DMCL tracing to see what the client is executing?

e234934

Hi,

I checked that for the user connected to the docbase and found that the target folder ("0b0020ca8002e212") is not restricted for the user.

e234934

Hi,

I have turned on the DFC & DMCL tracing.

The output of the trace is given below.

274.698 0.031 N/A com.documentum.fc.common.DfPreferences@8f3eac.getLoggingLevelToForceStack() ==> "OFF"

274.760 0.000 <N/A|N/A|SM@20197211> com.documentum.fc.client.impl.session.SessionManager@1342f5b.getIdentity("dmhser3") ==> DfLoginInfo{user=dmadmin, force=true}

274.776 1.125 N/A com.documentum.com.DfClientX@92de02.getImportOperation() ==> com.documentum.operations.IDfImportOperation@2d80ae

275.901 0.016 N/A com.documentum.com.DfClientX@92de02.getFile("D:\karthi\test.doc") ==> com.documentum.operations.IDfFile@15b5c1f

275.917 0.000 <dmadmin|s0(0.0)|SM@20197211> com.documentum.operations.impl.DfOperation@2d80ae.setSession(com.documentum.fc.client.impl.session.StrongSessionHandle@fd0a62) ==> <void>

275.917 0.172 N/A com.documentum.operations.impl.DfOperation@2d80ae.add(com.documentum.operations.impl.DfFile@15b5c1f) ==> com.documentum.operations.IDfOperationNode@15837e8

276.089 0.000 N/A com.documentum.fc.client.DfQuery@be6108.<init>() ==> <void>

276.089 0.000 N/A com.documentum.fc.client.DfQuery@d47880.<init>() ==> <void>

276.104 0.000 N/A com.documentum.fc.client.DfQuery@be6108.setDQL(" select s.r_object_id from dm_folder_sp s, dm_folder_r r where s.r_object_id=r.r_object_id and r.r_folder_path like '/TechArc/Memos-Reports-Publications/Reports by Publication Year/%' and r.i_position = -1 and s.object_name = '2007'") ==> <void>

276.104 4.594 <dmadmin|s0(0.0)|SM@20197211> com.documentum.fc.client.DfQuery@be6108.execute(com.documentum.fc.client.impl.session.StrongSessionHandle@fd0a62,0) ==> com.documentum.fc.client.IDfCollection@9c2192

280.698 0.406 <dmadmin|s0(0.0)|SM@20197211> com.documentum.fc.client.impl.collection.CollectionHandle@9c2192.next() ==> true

281.104 0.000 <dmadmin|s0(0.0)|SM@20197211> com.documentum.fc.client.impl.collection.CollectionHandle@9c2192.getString("r_object_id") ==> "0b0020ca8002e212"

281.104 0.000 N/A com.documentum.operations.nodes.inbound.impl.DfImportNode@15837e8.setDestinationFolderId(DfId) ==> <void>

281.104 0.000 N/A com.documentum.operations.impl.DfFile@15b5c1f.getName() ==> "test.doc"

281.104 0.000 N/A com.documentum.operations.nodes.inbound.impl.DfImportNode@15837e8.setNewObjectName("test.doc") ==> <void>

281.104 0.000 N/A com.documentum.operations.nodes.inbound.impl.DfImportNode@15837e8.setDocbaseObjectType("reports") ==> <void>

281.104 0.000 N/A com.documentum.operations.impl.DfFile@15b5c1f.canRead() ==> true

325.291 0.000 N/A com.documentum.fc.client.impl.bof.cache.ClassCacheManager$LastAccessedUpdateTask@1be3bb2.run() ==> <void>

281.104 72.796 N/A com.documentum.operations.impl.DfOperation@2d80ae.execute() ==> false

353.900 0.000 N/A com.documentum.operations.impl.DfFile@15b5c1f.canRead() ==> true

353.900 0.000 N/A com.documentum.operations.impl.DfOperation@2d80ae.getErrors() ==> com.documentum.fc.common.IDfList@1846aed

353.900 0.000 N/A com.documentum.operations.impl.DfOperationError@882dfc.getMessage() ==> "Could not check in document 'test.doc'"

353.900 0.000 N/A com.documentum.operations.impl.DfOperationError@882dfc.getErrorCode() ==> 1013

aflowers001

Hi,

As this code running inside a web server I assume the web server has access to "D:\karthi\test.doc"? I guess it does as canRead() returns true.

Also now we've seen the client trace, what appears in the content server logs? Perhaps you might want to turn on additional tracing there as well?

Have you tried importing the file using Webtop or some other Documentum UI? Does this work for the same combination of user & folder & type?

e234934

Hi,

Yes. The webserver has access to "D:\karthi\test.doc".

I tried importing the file using webtop for the same combination of user , folder & type, the file got imported successfully.

aflowers001

So, we know files can be imported, but not by the code sample shown.

What, if anything, are the server side errors/logs telling us?

Might be worth looking at this sample to see if following a different pattern might work?

I tried out the pattern you have, albeit with DFC 6.5, and it all worked as expected, except I couldn't pass in an IDfFile to the add operation, it required a string with the file name.

e234934

Hi,

I tried using the sample code, but could not compile the code since "DfImportOperation could not be resolved to a type" which is used as shown below.

IDfImportOperation imp = new DfImportOperation();

I am using DFC 6.5. Please let me know the jar file containing the class DfImportOperation

aflowers001

The sample code isn't mine, but DfImportOperation but I had a quick look and it can be found in dfc.jar at com.documentum.operations.inbound.

The sample code I tried pretty much matched yours. One difference is that I ran it a a jav console application. Perhasp you could try the same and that wayyou can exclude any interaction with the servlet container environment.

public void importFiles(String strFilename) throws Exception

{

IDfSession objSess = null;

IDfClientX objClientX = null;

IDfImportOperation objImpOper = null;

IDfId objDestId = null;

IDfFile objLocalFile = null;

IDfImportNode objImpNode = null;

IDfSessionManager dfSessionManager = null;

try

{

objClientX = new DfClientX();

dfSessionManager = objClientX.getLocalClient().newSessionManager();

// Add in the login info for the sample desktop based app

IDfLoginInfo li = new DfLoginInfo();

li.setUser("username");

li.setPassword("password");

dfSessionManager.setIdentity("repositoryname", li);

objSess = dfSessionManager.newSession("repository");

IDfLoginInfo loginInfo = dfSessionManager.getIdentity("repository");

objImpOper = objClientX.getImportOperation();

//objLocalFile = objClientX.getFile(strFilename);

IDfOperationNode n = objImpOper.add(strFilename);

objImpNode = (IDfImportNode)n;

objDestId = new DfId ("folder id");

objImpNode.setDestinationFolderId(objDestId);

objImpNode.setNewObjectName("test.doc");

objImpNode.setDocbaseObjectType("dm_document");

objImpOper.setSession(objSess);

if (objImpOper.execute())

{

System.out.println("Import operation succeeded");

}

else

{

System.out.println("Import operation failed");

}

catch(Exception e)

{

System.out.println("error - " + e.getMessage());

throw e;

}

e234934

Hi,

It is working fine now. The file is getting imported successfully .

Thanks.

aflowers001

Hi,

Can I ask how this was fixed? It might help the community as a whole.

pbyram

Could you plase update how you resolved this error. I have same error while running with a batch file. Work great in eclipse run time.

Thanks