XOG null pointer exception

[Anon Anon]

Hello!   I am having issues getting XOG to work.   I'm new to XOG, and am just trying to execute a few reads, to see how it works.   So far, I have tried reading the resource object, the team object, and the projmgr.resourceWorkloads portlet.   I believe I have the read XML set up correctly, because the data being retrieved looks right, and each time my output file has 3MB - 6MB of data.   However, in each case, at the end of the file, there's a NullPointerException.   I'm assuming that means that not all of the data was retrieved, but I have not been able to figure out what is causing it.   This happens when I run XOG from my desktop, and when I run XOG in the xog.client UI.  

Does anyone know how to get past this error?

<XOGOutput>
        <Object type="contentPack"/>
        <Status state="SUCCESS"/>
        <Statistics failureRecords="0" insertedRecords="0"
            totalNumberOfRecords="46" updatedRecords="0"/>
        <Records>
            <Record>
                <KeyInformation>
                    <column name="view">reqResFinderList</column>
                </KeyInformation>
                <ErrorInformation>
                    <Severity>FATAL</Severity>
                    <Description>XOG-3002: Fatal Error Exception occurred loading filter view information from db. viewCode=reqResFinderList</Description>
                    <Exception><![CDATA[
java.lang.NullPointerException
 at com.niku.odf.griphendor.dal.FilterObjectAdapter.getObject(FilterObjectAdapter.java:57)
 at com.niku.odf.griphendor.dal.FilterObjectAdapter.<init>(FilterObjectAdapter.java:39)
 at com.niku.odf.view.filter.FilterViewLoader.loadObjectInfo(FilterViewLoader.java:2331)
 at com.niku.odf.view.filter.FilterViewLoader.loadViewFromDatabase(FilterViewLoader.java:511)
 at com.niku.odf.view.filter.FilterViewLoader.loadFromDatabase(FilterViewLoader.java:837)
 at com.niku.odf.view.filter.FilterViewLoader.load(FilterViewLoader.java:319)
 at com.niku.odf.view.filter.FilterViewLoader.getLoadedInstance(FilterViewLoader.java:214)
 at com.niku.odf.view.filter.ODFFilterView.load(ODFFilterView.java:150)
 at com.niku.odf.view.filter.ODFFilterView.<init>(ODFFilterView.java:82)
 at com.niku.odf.view.filter.ODFFilterView.<init>(ODFFilterView.java:129)
 at com.niku.odf.view.xbl.ViewHandler.getView(ViewHandler.java:200)
 at com.niku.odf.view.xbl.ViewHandler.preProcess(ViewHandler.java:163)
 at com.niku.odf.view.xbl.XOGFilterViewHandler.preProcess(XOGFilterViewHandler.java:37)
 at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1342)
 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.MatchHandler.preProcess(MatchHandler.java:129)
 at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1342)
 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:1342)
 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:161)
 at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:91)
 at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1342)
 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.MatchHandler.preProcess(MatchHandler.java:129)
 at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1342)
 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:161)
 at com.niku.xql2.handlers.LoopHandler.preProcess(LoopHandler.java:91)
 at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1342)
 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.TryHandler.preProcess(TryHandler.java:50)
 at com.niku.xql2.XQLVisitor.preProcess(XQLVisitor.java:1342)
 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.traverseIntern(DOMWalker.java:92)
 at com.niku.union.xml.dom.DOMWalker.traverse(DOMWalker.java:36)
 at com.niku.xog.service.XOGXBLHandler.processXBL(XOGXBLHandler.java:243)
 at com.niku.xog.service.XOGXBLHandler.process(XOGXBLHandler.java:149)
 at com.niku.xog.service.ObjectHandler.processRequest(ObjectHandler.java:167)
 at com.niku.xog.service.ObjectHandler.process(ObjectHandler.java:90)
 at com.niku.xog.service.XOGDispatch.processMessage(XOGDispatch.java:114)
 at com.niku.xog.service.XOGSOAPServlet.processMessage(XOGSOAPServlet.java:265)
 at com.niku.xog.service.XOGSOAPServlet.doPost(XOGSOAPServlet.java:87)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
 at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1143)
 at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1084)
 at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:118)
 at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
 at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:832)
 at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:679)
 at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:587)
 at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:481)
 at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3453)
 at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:267)
 at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:815)
 at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1466)
 at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:119)
 at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)
 at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387)
 at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
 at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:556)
 at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:606)
 at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:979)
 at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1064)
 at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1473)
]]></Exception>
                </ErrorInformation>
            </Record>
        </Records>
    </XOGOutput>

[Anon Anon]

Hi,         Can you please share, the xog write(XML) file which  you are trying to xog.    ThanksSenthil.

[Anon Anon]

Thanks for looking at this, Senthil!  This is the read file (I am not writing, only reading so far):
http://www.w3.org/2001/XMLSchema-instance " xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
 
     
     
 
 
      projmgr.resourceWorkloads
 
 
   I get the same error when trying to read the Resource object: 
http://www.w3.org/2001/XMLSchema-instance " xsi:noNamespaceSchemaLocation="../xsd/nikuxog_read.xsd">
 
     
     
     
     
     
     
 
 
      resource
 
   When I check my Java version, I am using 1.5.0_11:  Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.  H:\>java -version
java version "1.5.0_11"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_11-b03)
Java HotSpot(TM) Client VM (build 1.5.0_11-b03, mixed mode)     

[Deactivated User]

I can run the second file in XOG.client GUI without error and the second one, too after removing the commented section.That is in r8.1fp03That suggest that the input files are OK.  If you are running them from the comman linde XOG client are all your property paramters properly setin the porperties file?  You can check them one by one by entering the on the command line.   Maybe you can then pinpoint what is giving the error.Just issue run on the command line and you'll see what paramters are expected.  Martti K.

[Anon Anon]

I have tried running this in the xog client GUI; from the XOG command line using a properties file; and from the XOG command line using login, output, call commands.   All create identical output, and all have the null pointer exception.   Note that in every case, I am getting some results; I just cannot tell if the results are complete as I do not have a "good" read to compare with.   For example, with the "resource" object read, the output file has over 43000 lines of xml before the end content pack tag.  I have been trying to do this in our development environment (r8.1), so I also tested against our stage environment (r8.1 fp03) to see if that worked any better, but I ended up with the same error.  Any other ideas?

[Anon Anon]

Digging into this further, I find that the error only occurs when I am trying to read data related to resources.   I have no idea what the information in the output means (if you know of a good reference for this, please let me know!), but I noticed that in every case, there's an attribute of view_code=reqResFinderList.   I opened Clarity, and navigated to Views in the admin UI, and sure enough, there's a reqResFinderList view.   But when I try to open it, I get a system error.   This view is apparently part of Clarity itself, not something that was created or modified at our company.   It causes a system error when trying to open the view in the admin tool, in all environments.  This leads me to two new questions:1.   How can I exclude a view from XOG?   I want to include all views except for this one.   Is that possible??2.   What is reqResFinderList?   Where is it used?

[Anon Anon]

It turned out that this  is a known issue.   The 'reqResFinderList' & 'roleProjectsCapacity' views are not supported by newer versions of clarity.   Configuration for these two views no longer exist, but these views are still present in the database after the upgrades to 8.1+ versions.    CA recommended to deleting these two views from the database.   Once deleted, XOG completed successfully for all objects.

[Deactivated User]

The next thing I would do is check the rights of the user doing the XOG.Does the user have all XOG rights needed and all resource rights needed?  1. I don't think you can exclude views/any view when reading an object with the XOG object api..2. Sounds like a resource listv view related to Resource requests.  Martti K. Message Edited by another_martink on 03-12-2009 11:03 AM [left]

[Anon Anon]

Hi,

The error you are encountering is actually due to the existence of deprecated views still in your system. Here's how you can workaround that...

Have your DBA run the following query:

select * from odf_views where code in ('reqResFinderList', 'roleProjectsCapacity')

Take back up of the following 3 tables:
odf_view_attributes
odf_view_sections
odf_views

Using the ID's from the select query, construct the delete queries below:

1. delete odf_view_attributes where id in (select id from odf_view_attributes where view_id in ( xxxxxxx, xxxxxxx))

2. delete odf_view_sections where id in
(select id from odf_view_sections where view_id in (xxxxxxx,xxxxxxx))

3. delete odf_views where id in (xxxxxxx,xxxxxxx)

This will remove the deprecated views and allow you to move forward with your XOG.

In regard to getting started with XOG, I've got some "XOG Basics" tips I will be posting on this site to help get you started beyond what our documentation provides.

Hope this helps!
--Kathy