AnsweredAssumed Answered

Error occured trying to materialize object "project"

Question asked by gangadharishankar4205679 on Oct 9, 2012
Latest reply on Jul 26, 2013 by mohzu02
Hi

When i am trying to do a db upgrade from 13.0 to 13.1 from CSA console i am getting this error. please help me out:



10/9/12 12:09 PM (admin) Command: extract row count
10/9/12 12:09 PM (admin) To URL: jdbc:clarity:oracle://10.136.79.7:1523;SID=GENDB;BatchPerformanceWorkaround=true;InsensitiveResultSetBufferSize=0;ServerType=dedicated;supportLinks=true
10/9/12 12:09 PM (admin) As user: niku
10/9/12 12:09 PM (admin) For vendor: oracle
10/9/12 12:09 PM (admin) Total time: 0H:0M:17S
10/9/12 12:09 PM (admin) -----------------------------------------------------
10/9/12 12:09 PM (admin) 2012-10-09 12:09:23: Finished updating database
10/9/12 12:09 PM (admin) -----------------------------------------------------
Oct 9, 2012 12:09:23 PM Error executing command: db -javaHome E:\Java\jdk1.7.0_04\jre core-upgrade
E:\niku\clarity\.setup\scripts\db.xml:1662: The following error occurred while executing this line:
E:\niku\clarity\.setup\scripts\db.xml:1595: The following error occurred while executing this line:
E:\niku\clarity\.setup\scripts\db.xml:1608: The following error occurred while executing this line:
E:\niku\clarity\.setup\scripts\db.xml:1689: The following error occurred while executing this line:
E:\niku\clarity\.setup\scripts\db.xml:1895: ERROR: Upgrade failed. Please review the upgrade logs for details.

at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:551)

at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:444)

at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)

at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:68)

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

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at com.niku.tools.taskdefs.ChooseTask.execute(ChooseTask.java:146)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)

at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at org.apache.tools.ant.Target.execute(Target.java:391)

at org.apache.tools.ant.Target.performTasks(Target.java:412)

at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)

at org.apache.tools.ant.Project.executeTarget(Project.java:1368)

at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExecutor.java:41)

at org.apache.tools.ant.Project.executeTargets(Project.java:1251)

at com.niku.nsa.service.AntUtil.executeTargets(AntUtil.java:119)

at com.niku.nsa.service.AntUtil.executeAntScript(AntUtil.java:81)

at com.niku.nsa.service.AdminManager.invokeAction(AdminManager.java:280)

at com.niku.nsa.service.AdminManager.execute(AdminManager.java:127)

at com.niku.nsa.service.Admin.main(Admin.java:77)

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

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

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

at com.werken.forehead.Forehead.main(Forehead.java:581)
Caused by: E:\niku\clarity\.setup\scripts\db.xml:1595: The following error occurred while executing this line:
E:\niku\clarity\.setup\scripts\db.xml:1608: The following error occurred while executing this line:
E:\niku\clarity\.setup\scripts\db.xml:1689: The following error occurred while executing this line:
E:\niku\clarity\.setup\scripts\db.xml:1895: ERROR: Upgrade failed. Please review the upgrade logs for details.

at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:551)

at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:444)

at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)

at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:68)

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

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at com.niku.tools.taskdefs.ChooseTask.execute(ChooseTask.java:146)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)

at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:68)

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

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at com.niku.tools.taskdefs.ChooseTask.execute(ChooseTask.java:146)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)

at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at org.apache.tools.ant.Target.execute(Target.java:391)

at org.apache.tools.ant.Target.performTasks(Target.java:412)

at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)

at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)

at org.apache.tools.ant.Project.executeTargets(Project.java:1251)

at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:442)

... 38 more
Caused by: E:\niku\clarity\.setup\scripts\db.xml:1608: The following error occurred while executing this line:
E:\niku\clarity\.setup\scripts\db.xml:1689: The following error occurred while executing this line:
E:\niku\clarity\.setup\scripts\db.xml:1895: ERROR: Upgrade failed. Please review the upgrade logs for details.

at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:551)

at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:444)

at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)

at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at org.apache.tools.ant.Target.execute(Target.java:391)

at org.apache.tools.ant.Target.performTasks(Target.java:412)

at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)

at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)

at org.apache.tools.ant.Project.executeTargets(Project.java:1251)

at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:442)

... 79 more
Caused by: E:\niku\clarity\.setup\scripts\db.xml:1689: The following error occurred while executing this line:
E:\niku\clarity\.setup\scripts\db.xml:1895: ERROR: Upgrade failed. Please review the upgrade logs for details.

at org.apache.tools.ant.ProjectHelper.addLocationToBuildException(ProjectHelper.java:551)

at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:444)

at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)

at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at com.niku.tools.taskdefs.IfTask.execute(IfTask.java:204)

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

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at com.niku.tools.taskdefs.ChooseTask.execute(ChooseTask.java:132)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)

at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at org.apache.tools.ant.Target.execute(Target.java:391)

at org.apache.tools.ant.Target.performTasks(Target.java:412)

at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)

at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)

at org.apache.tools.ant.Project.executeTargets(Project.java:1251)

at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:442)

... 92 more
Caused by: E:\niku\clarity\.setup\scripts\db.xml:1895: ERROR: Upgrade failed. Please review the upgrade logs for details.

at org.apache.tools.ant.taskdefs.Exit.execute(Exit.java:164)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)

at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at com.niku.tools.taskdefs.IfTask.execute(IfTask.java:204)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)

at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at org.apache.tools.ant.taskdefs.Sequential.execute(Sequential.java:68)

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

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at com.niku.tools.taskdefs.ChooseTask.execute(ChooseTask.java:146)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)

at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at org.apache.tools.ant.Target.execute(Target.java:391)

at org.apache.tools.ant.Target.performTasks(Target.java:412)

at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)

at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)

at org.apache.tools.ant.Project.executeTargets(Project.java:1251)

at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:442)

... 119 more


And when i see upgrade logs:

ERROR 2012-10-09 12:09:04,747 [main] odf.ObjectController (clarity:admin:-1:none) Error occured trying to materialize object "project"
com.niku.union.odf.exception.ODFException: com.niku.union.persistence.PersistenceException:
SQL error code: 942
Error message: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist

Executed:
select * from ODF_ACTIONS where object_code=?
Derived from statement:
<?xml version="1.0" encoding="UTF-8"?>
<statement location="objects.xml" id="odf.getObjectActions" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" inputSource="none" xmlns="http://schemas.niku.com/2002/pmd">
<sql dbVendor="all">
<text>
select * from ODF_ACTIONS where object_code=?
</text>
<param name="object_code" type="string" direction="IN" expressionListDelimiter=","/>
</sql>
<outputMapping rowElementName="actionMap"/>
</statement>

Referenced by:
<?xml version="1.0" encoding="UTF-8"?>
<statementRef id="odf.getObjectActions" inputSource="map" sortColumnPath="/data/header/sortInfo/@sortColumn" sortDirectionPath="/data/header/sortInfo/@sortDirection" slicePath="/data/header/pagination/sliceInfo/@slice" sliceSizePath="/data/header/pagination/sliceInfo/@sliceSize" xmlns="http://schemas.niku.com/2002/pmd"/>

Using input:
{object_name=project, target=project, object_code=project, targetType=object}


at com.niku.odf.object.DBObjectMetaDataHolder.read(DBObjectMetaDataHolder.java:282)

at com.niku.odf.object.AbstractODFMetaData.readObjectMetaDataFromDB(AbstractODFMetaData.java:336)

at com.niku.odf.object.ODFAbstractObjectImpl.<init>(ODFAbstractObjectImpl.java:214)

at com.niku.odf.object.ODFObjectImpl.<init>(ODFObjectImpl.java:172)

at com.niku.odf.object.ObjectControllerImpl.getNewODFObject(ObjectControllerImpl.java:337)

at com.niku.union.odf.ObjectController.getODFObject(ObjectController.java:264)

at com.niku.union.odf.ObjectController.getODFObject(ObjectController.java:205)

at com.niku.odf.object.ObjectControllerImpl.getODFObject(ObjectControllerImpl.java:322)

at com.niku.union.odf.ObjectController.getODFObject(ObjectController.java:105)

at com.niku.odf.upgrade.AuditTrailReEnableUpgrade.reEnableAuditForObject(AuditTrailReEnableUpgrade.java:117)

at com.niku.odf.upgrade.AuditTrailReEnableUpgrade.reEnableAuditForObjects(AuditTrailReEnableUpgrade.java:92)

at com.niku.odf.upgrade.AuditTrailReEnableUpgrade.doUpgrade(AuditTrailReEnableUpgrade.java:65)

at com.niku.union.utility.AbstractUpgrade.run(AbstractUpgrade.java:267)

at com.niku.odf.upgrade.AuditTrailReEnableUpgrade.main(AuditTrailReEnableUpgrade.java:71)

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

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

at org.apache.tools.ant.taskdefs.ExecuteJava.run(ExecuteJava.java:217)

at org.apache.tools.ant.taskdefs.ExecuteJava.execute(ExecuteJava.java:152)

at org.apache.tools.ant.taskdefs.Java.run(Java.java:771)

at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:221)

at org.apache.tools.ant.taskdefs.Java.executeJava(Java.java:135)

at org.apache.tools.ant.taskdefs.Java.execute(Java.java:108)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)

at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at org.apache.tools.ant.Target.execute(Target.java:391)

at org.apache.tools.ant.Target.performTasks(Target.java:412)

at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1399)

at org.apache.tools.ant.helper.SingleCheckExecutor.executeTargets(SingleCheckExecutor.java:38)

at org.apache.tools.ant.Project.executeTargets(Project.java:1251)

at org.apache.tools.ant.taskdefs.Ant.execute(Ant.java:442)

at org.apache.tools.ant.taskdefs.CallTarget.execute(CallTarget.java:105)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)

at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at com.niku.tools.taskdefs.IfTask.execute(IfTask.java:204)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)

at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at com.niku.tools.taskdefs.IfTask.execute(IfTask.java:204)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)

at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at com.niku.tools.taskdefs.IfTask.execute(IfTask.java:204)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:291)

at sun.reflect.GeneratedMethodAccessor5.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

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

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.java:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at org.apache.t

Outcomes