JTenshaw

Upgrade from 13.0.1.0102 to 13.1.0.0248 FAILED

Discussion created by JTenshaw on Mar 14, 2013
Latest reply on Mar 14, 2013 by JTenshaw
All -

We are upgrading from 13.0.1.0102 to 13.1.0.0248 on a Linux server. We have done this in another environment and it worked fine, but when we tried installing in this environment we got the following (the invalid ODF_ objects are ok and don't effect anything) -

3/12/13 11:30 AM (ExecTask) Bootstrap time breakdown:
3/12/13 11:30 AM (ExecTask) Compiling database objects...
3/12/13 11:30 AM (ExecTask) ==========================================
3/12/13 11:30 AM (ExecTask) DBTools Log - Tue Mar 12 11:30:35 EDT 2013
3/12/13 11:30 AM (ExecTask) ==========================================
3/12/13 11:30 AM (ExecTask)
3/12/13 11:30 AM (ExecTask) Command: compile
3/12/13 11:30 AM (ExecTask) Compiling the database....
3/12/13 11:30 AM (ExecTask)
Following object(s) are invalid:
3/12/13 11:30 AM (ExecTask)

ODF_ODC_DETAIL_V2
3/12/13 11:30 AM (ExecTask)

ODF_ODC_DETAIL_V
3/12/13 11:30 AM (ExecTask)

ODF_TEMP_VIEW1240017386299
3/12/13 11:30 AM (ExecTask)

ODF_TEMP_VIEW1236808625085
3/12/13 11:30 AM (ExecTask)
3/12/13 11:30 AM (ExecTask) Total time: 0H:0M:1S
3/12/13 11:30 AM (ExecTask) Applying post-bootstrap xog-seeddata for component = database
3/12/13 11:30 AM (ExecTask)
Applying XOG_ACCESS_RIGHTS.xml
3/12/13 11:30 AM (ExecTask)
Applying menu_rights.xml
3/12/13 11:30 AM (ExecTask)
Applying LOOKUP_USERS.xml
3/12/13 11:30 AM (ExecTask)
Applying LOOKUP_BROWSE_INV_INVESTMENTS.xml
3/12/13 11:30 AM (ExecTask)
Applying PROCESS_AI_STATUS.xml
3/12/13 11:30 AM (ExecTask)
Applying LANGUAGE_LOOKUP.xml
3/12/13 11:30 AM (ExecTask)
Applying DMS_OWNER_BROWSE.xml
3/12/13 11:30 AM (ExecTask)
Applying CMN_DYN_LIC_LOOKUP.xml
3/12/13 11:30 AM (ExecTask)
Applying post_platform_extracted_lookups.xml
3/12/13 11:31 AM (ExecTask)
Applying SCH_BROWSE_ENTITY_DEPT.xml
3/12/13 11:31 AM (ExecTask)
Applying BPM_PROJECT_TEMPLATE_PROCESSES.xml
3/12/13 11:31 AM (ExecTask)
Applying TIME_BROWSE_CALENDAR.xml
3/12/13 11:31 AM (ExecTask)
Applying LOOKUP_LOOKUP_WTYPE_LIST.xml
3/12/13 11:31 AM (ExecTask)
Applying project_rights.xml
3/12/13 11:31 AM (ExecTask)
Applying PROJECTMODIFYBASELINE.xml
3/12/13 11:31 AM (ExecTask)
Applying ppm_lookups.xml
3/12/13 11:31 AM (ExecTask)
Applying INVESTMENT_LOOKUPS.xml
3/12/13 11:31 AM (ExecTask)
Applying LOOKUP_PROCESS_ENABLED_OBJECTS.xml
3/12/13 11:31 AM (ExecTask) Error Applying XOG: Failure occurred while applying LOOKUP_PROCESS_ENABLED_OBJECTS.xml
3/12/13 11:31 AM (ExecTask) Check /apps/clarity/logs/xog-seeddata/out/database/LOOKUP_PROCESS_ENABLED_OBJECTS_out.xml for errors
3/12/13 11:31 AM (ExecTask) ERROR: Upgrade failed for tenant
3/12/13 11:31 AM (ExecTask) /apps/clarity/.setup/scripts/db.xml:1816: The following error occurred while executing this line:
3/12/13 11:31 AM (ExecTask) /apps/clarity/.setup/scripts/db.xml:458: The following error occurred while executing this line:
3/12/13 11:31 AM (ExecTask) /apps/clarity/.setup/scripts/db.xml:450: The following error occurred while executing this line:
3/12/13 11:31 AM (ExecTask) /apps/clarity/.setup/scripts/db.macros.xml:92: Java returned: 2
3/12/13 11:31 AM (ExecTask)
at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:551)
3/12/13 11:31 AM (ExecTask)
at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:444)
3/12/13 11:31 AM (ExecTask)
at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)
3/12/13 11:31 AM (ExecTask)
at com.niku.tools.taskdefs.xpath.Iter.executeTarget(Iter.java:294)
3/12/13 11:31 AM (ExecTask)
at com.niku.tools.taskdefs.xpath.Iter.execute(Iter.java:189)
3/12/13 11:31 AM (ExecTask)
at com.niku.tools.taskdefs.xpath.Iter.execute(Iter.java:145)
3/12/13 11:31 AM (ExecTask)
at com.niku.tools.taskdefs.XPath.execute(XPath.java:407)
3/12/13 11:31 AM (ExecTask)
at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)
3/12/13 11:31 AM (ExecTask)
at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source) ........
++++++

/apps/clarity/logs/xog-seeddata/out/database/LOOKUP_PROCESS_ENABLED_OBJECTS_out.xml file; odf_class does not exist in the db, but it doesn't exist in the db that was successfully installed either, so I don't know -
?xml version="1.0" encoding="UTF-8"?>
<XOGOutput xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/status.xsd">
<Object type="contentPack"/>
<Status elapsedTime="0.091 seconds" state="FAILURE"/>
<Statistics failureRecords="1" insertedRecords="0" totalNumberOfRecords="1" updatedRecords="0"/>
<Records>
<Record>
<KeyInformation>
<column name="code">LOOKUP_PROCESS_ENABLED_OBJECTS</column>
</KeyInformation>
<ErrorInformation>
<Severity>FATAL</Severity>
<Description>com.niku.union.persistence.nsql.NSQLSyntaxException: NSQL Syntax exception: NSQL_SYNTAX_ERROR_DB_ERROR, Info: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

SQL Text:
select code code,
name name,
description description
from (select o.code code, name ,description
from odf_objects o, cmn_captions_nls nls
where o.id = nls.pk_id
and nls.table_name = 'ODF_OBJECTS'
and o.is_process_enabled = 1
and o.is_class_enabled = 0
and nls.language_code = ?
union
select c.code code, name ,description
from odf_objects o , odf_class c, cmn_captions_nls nls
where c.id = nls.pk_id
and nls.table_name = 'ODF_CLASS'
and o.is_process_enabled = 1
and o.is_class_enabled = 1
and c.object_code = o.code
and nls.language_code = ? )x
where 1=1 and 1=? and 1=1

at com.niku.union.persistence.nsql.NSQLQuery.retrieveMetaData(NSQLQuery.java:835)

at com.niku.union.persistence.nsql.NSQLQuery.initialize(NSQLQuery.java:255)

at com.niku.union.persistence.nsql.NSQLQuery.&lt;init&gt;(NSQLQuery.java:308)

at com.niku.union.persistence.nsql.NSQLController.createQuery(NSQLController.java:157)

at com.niku.union.persistence.nsql.NSQLController.createQuery(NSQLController.java:168)

at com.niku.odf.ori.dal.NsqlPersistenceService.seedNsql(NsqlPersistenceService.java:374)

at com.niku.odf.ori.OdfEngine.matchNsqlAttrsWithBrowsePageAttrs(OdfEngine.java:570)

at com.niku.odf.ori.OdfEngine.validateOdfForNewAction(OdfEngine.java:558)

at com.niku.odf.ori.OdfEngine.createLookup(OdfEngine.java:774)

at com.niku.odf.ori.OdfEngine.addLookup(OdfEngine.java:1008)

at com.niku.odf.ori.xblhandlers.LookupsXogImportHandler.addDynamicLookup(LookupsXogImportHandler.java:235)

at com.niku.odf.ori.xblhandlers.LookupsXogImportHandler.addLookup(LookupsXogImportHandler.java:216)

at com.niku.odf.ori.xblhandlers.LookupsXogImportHandler.processXogRequest(LookupsXogImportHandler.java:124)

at com.niku.odf.ori.xblhandlers.LookupsXogImportHandler.postProcess(LookupsXogImportHandler.java:81)

at com.niku.xql2.XQLVisitor.postProcess(XQLVisitor.java:1355)

at com.niku.union.xml.dom.DOMWalker.postProcess(DOMWalker.java:210)

at com.niku.union.xml.dom.DOMWalker.traverseIntern(DOMWalker.java:94)

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.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.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.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.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.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.traverse(DOMWalker.java:36)

at com.niku.xog.service.XOGXBLHandler.processXBL(XOGXBLHandler.java:248)

at com.niku.xog.service.XOGXBLHandler.process(XOGXBLHandler.java:154)

at com.niku.xog.service.ObjectHandler.processRequest(ObjectHandler.java:191)

at com.niku.xog.client.XOGAdminClient.processDoc(XOGAdminClient.java:873)

at com.niku.xog.client.XOGAdminClient.processFileDescriptors(XOGAdminClient.java:704)

at com.niku.xog.client.XOGAdminClient.execute(XOGAdminClient.java:437)

at com.niku.xog.client.XOGAdminClient.main(XOGAdminClient.java:221)
</Description>
</ErrorInformation>
</Record>
</Records>
</XOGOutput>

Please advise

Outcomes