Clarity

Expand all | Collapse all

XOG in Documents to Knowledge store folder

  • 1.  XOG in Documents to Knowledge store folder

    Posted Jun 12, 2016 08:27 AM

    Hi,

     

    I am trying to upload file to previously existing folder in KS. Below is the XOG File I used and the Error I got.

    The document location is shared to everyone(read/write access). Also tried changing the document location to filestore.

    user_name used in the document owner has read/edit/delete rights on KS folder.

     

    My requirement is to upload files from local folder to into existing KS folder.

    Any suggestion on this issue or any script that match my requirement  will be very helpful.

     

     

    Input FIle

     

    Output File

    <XOGOutput xmlns:xsi="
    http://www.w3.org/2001/XMLSchema-instance
    "
    xsi:noNamespaceSchemaLocation="../xsd/status.xsd">


    <Object type="document"/>
    <Status elapsedTime="0.172 seconds" state="FAILURE"/>
    <Statistics failureRecords="1" insertedRecords="2" totalNumberOfRecords="2" updatedRecords="0"/>
    <Records>
    <Record>
    <KeyInformation/>
    <ErrorInformation>
    <Severity>FATAL</Severity>
    <Description>XOG-4002: Failed to import documents.</Description>
    <Exception><![CDATA[
    com.niku.dms.util.DMSException: Could not retrieve file from file store.
    at com.niku.dms.util.FileUtil.readBinaryFile(FileUtil.java:757)
    at com.niku.dms.util.FileUtil.retrieveFileContentsFromLocation(FileUtil.java:93)
    at com.niku.dms.service.DocumentXOGService.importVersion(DocumentXOGService.java:454)
    at com.niku.dms.xql2.functions.ImportVersionFunction.eval(ImportVersionFunction.java:56)
    at com.niku.xql2.eval.XQLFunctionNode.eval(XQLFunctionNode.java:27)
    at com.niku.xql2.eval.XQLEvaluator.parse(XQLEvaluator.java:40)
    at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1078)
    at com.niku.xql2.XQLVisitor.eval(XQLVisitor.java:1052)
    at com.niku.xql2.XQLVisitor.process(XQLVisitor.java:1284)
    at com.niku.xql2.XQLVisitor.process(XQLVisitor.java:1332)
    at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:191)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
    at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
    at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)
    at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
    at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
    at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)
    at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
    at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
    at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)
    at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
    at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
    at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)
    at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
    at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
    at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)
    at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
    at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
    at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)
    at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
    at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
    at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)
    at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
    at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
    at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)
    at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
    at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
    at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)
    at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
    at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
    at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)
    at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
    at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
    at com.niku.xql2.handlers.TryHandler.preProcess(TryHandler.java:50)
    at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)
    at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
    at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:51)
    at com.niku.xql2.handlers.LoopHandler.processObject(LoopHandler.java:384)
    at com.niku.xql2.handlers.LoopHandler.processSet(LoopHandler.java:255)
    at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:212)
    at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1377)
    at com.niku.union.xml.dom.DOMWalker.preProcess(DOMWalker.java:194)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:74)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
    at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:92)
    at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:36)
    at com.niku.xog.service.XOGXBLHandler.processXBL(XOGXBLHandler.java:260)
    at com.niku.xog.service.XOGXBLHandler.process(XOGXBLHandler.java:167)
    at com.niku.xog.service.ObjectHandler.processRequest(ObjectHandler.java:197)
    at com.niku.xog.service.ObjectHandler.process(ObjectHandler.java:99)
    at com.niku.xog.service.XOGDispatch.processMessage(XOGDispatch.java:133)
    at com.niku.xog.service.XOGSOAPServlet.processMessage(XOGSOAPServlet.java:599)
    at com.niku.xog.service.XOGSOAPServlet.doPost(XOGSOAPServlet.java:359)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:647)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at com.niku.union.web.filter.ClarityContentFilter.doFilter(ClarityContentFilter.java:145)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at com.niku.union.web.filter.CharsetFilter.doFilter(CharsetFilter.java:68)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:88)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
    at com.niku.union.web.valves.ErrorPageRedirectValve.invoke(ErrorPageRedirectValve.java:70)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:724)
    ]]>
    </Exception>
    </ErrorInformation>
    </Record>
    </Records>
    </XOGOutput>

     

    Thanks,

    Shiva



  • 2.  Re: XOG in Documents to Knowledge store folder

    Posted Jun 13, 2016 01:14 AM

    Have you checked this ?

     

    Error while uploading document using XOG

     

    NJ



  • 3.  Re: XOG in Documents to Knowledge store folder

    Posted Jun 13, 2016 03:32 AM

    Hi NJ,

     

    I had already tried the suggestion from that thread but it didn't help in fixing the issue.

     

    Thanks,

    Shiva



  • 4.  Re: XOG in Documents to Knowledge store folder

    Posted Jun 13, 2016 03:49 AM


  • 5.  Re: XOG in Documents to Knowledge store folder

    Posted Jun 13, 2016 08:07 AM

    Yup checked that as well.

    I found this helpful but with my requirement I will loose UI friendliness of the requirement and the script error out as well.

    https://communities.ca.com/message/241801615#comment-241801615

     

    Here is my requirement in detail:

    We are planning to decommission old application by making its functionality clarity through custom Object. We have implemented everything through custom object but there is a attachment of document feature needed. We could have done it through attachment attribute in custom object but the custom attribute has limitation of 10 attachment as max. There are some instance which have more than 50 attachments to be added. We thought instead having multiple attachment attributes which looks odd to users, create a KS folder fro each instance and upload the documents to KS folder and grant rights.

     

    The old system used to store files in database. I have extracted the files from database to local folder. Now I have to upload these files to respective instances linked folder in KS.

     

    Thanks,

    Shiva



  • 6.  Re: XOG in Documents to Knowledge store folder

    Posted Jun 13, 2016 04:09 AM

    If your requirement is to upload docs from local(non filestore) to KS, then documents_write_ext.xml is the template for it. Are you doing the same?



  • 7.  Re: XOG in Documents to Knowledge store folder

    Posted Jun 13, 2016 05:48 AM

    Getting below error on running the command.

     

    input xml

    <?xml version="1.0" encoding="UTF-8"?>
    <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_document.xsd">
      <Header action="write" externalSource="OS" objectType="document" version="13.3.0.286" />
      <Documents>
        <Parent parentObjectId="6143805" parentObjectType="new folder" documentLocation="\\eacdevclarity01\xog\xml\test">
          <General addedBy="c-aaahcl-skumar" addedDate="2016-01-01" />
        </Parent>
      </Documents>
    </NikuDataBus>
    
    

     

    > output c:\xog\out2.xml

    Directing command output to c:\xog\out2.xml

    > call c:\xog\prj_rd.xml

    Request Document: c:\xog\prj_rd.xml

    Writing output to c:\xog\out2.xml

    Failed to retrieve response document

    com.niku.xog.XOGException: java.lang.RuntimeException: HTTP Error: Status-Code:

    403: Forbidden

            at com.niku.xog.client.XOGClient.processRequest(XOGClient.java:1096)

            at com.niku.xog.client.XOGClient.processRequest(XOGClient.java:1007)

            at com.niku.xog.client.XOGClient.processRequest(XOGClient.java:679)

            at com.niku.xog.client.XOGClient.processRequest(XOGClient.java:589)

            at com.niku.xog.client.XOGClient.processRequests(XOGClient.java:1435)

            at com.niku.xog.client.XOGClient.processCmd(XOGClient.java:1358)

            at com.niku.xog.client.XOGClient.startShell(XOGClient.java:1287)

            at com.niku.xog.client.XOGClient.invokeCommand(XOGClient.java:1248)

            at com.niku.xog.client.XOGClient.main(XOGClient.java:142)

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.

    java:57)

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces

    sorImpl.java:43)

            at java.lang.reflect.Method.invoke(Method.java:606)

            at com.werken.forehead.Forehead.run(Forehead.java:551)

            at com.werken.forehead.Forehead.main(Forehead.java:581)

    Caused by: java.lang.RuntimeException: HTTP Error: Status-Code: 403: Forbidden

            at com.niku.union.xml.SimpleSOAPMessage.processRequest(SimpleSOAPMessage

    .java:316)

            at com.niku.union.xml.SimpleSOAPMessage.send(SimpleSOAPMessage.java:88)

            at com.niku.union.xml.SimpleSOAPMessage.send(SimpleSOAPMessage.java:79)

            at com.niku.union.xml.SimpleSOAPMessage.send(SimpleSOAPMessage.java:56)

            at com.niku.xog.client.XOGClient.processRequest(XOGClient.java:1092)

            ... 14 more

    >

     

    Thanks,

    Shiva



  • 8.  Re: XOG in Documents to Knowledge store folder

    Posted Jun 13, 2016 06:27 AM

    Can you try removing the first line in your XML(xml version etc )?



  • 9.  Re: XOG in Documents to Knowledge store folder

    Posted Jun 13, 2016 07:47 AM

    Hi Sridhar,

     

    Tried it but same issue.

     

    Thanks,

    Shiva



  • 10.  Re: XOG in Documents to Knowledge store folder
    Best Answer

    Posted Jun 14, 2016 12:53 AM

    Found the issue and fixed. Able to xog file into KS folder. I was trying externalSource as niku instead OS in header tab.

    <Header action="write" externalSource="OS" objectType="document" version="13.3.0.286">

     

    Thanks,

    Shiva



  • 11.  Re: XOG in Documents to Knowledge store folder

    Posted Jun 14, 2016 12:59 AM

    In your previous post, it reads:

      <Header action="write" externalSource="OS" objectType="document" version="13.3.0.286" />

     

    and you wrote,

    "Found the issue and fixed. Able to xog file into KS folder. I was trying externalSource as niku instead OS in header tab.

      <Header action="write" externalSource="OS" objectType="document" version="13.3.0.286">"

     

    what is the difference in the two ?

     

    NJ



  • 12.  Re: XOG in Documents to Knowledge store folder

    Posted Jun 14, 2016 02:24 AM

    actually I was copying only <document> tab contents and use it in write XML. later used whole XML and it worked.

     

    regards,

    shiva



  • 13.  Re: XOG in Documents to Knowledge store folder

    Posted Sep 14, 2016 02:35 AM

    Hi Shiva,

     

    I'm trying to XOG a document from my local machine to the knowledge store. In your scenario, were you trying to do the same? or did you copy to the file to the application server? It looks like the documentlocation is respective to the server and not my local machine.

     

    Thanks,

     

    Leo.