Create Plan Problems (OpenUp)
I am having problems creating and viewing a plan. There is an error on creating the plan, but a plan gets placed in the Team Artifacts Plans folder. Any attempt to look at the plan results in the same error message as on creation. It is not clear if this is a creation problem or a retrieval problem.
This is occurs only in a project that was set up using the OpenUp process template. We are using a new install of RTC v2.0.0.2 iFix5 and Oracle for the database.
An error code associated with this is: CRJAZ1037I. Here is the beginning of the error message itself:
----------------------------------
com.ibm.team.repository.common.TeamRepositoryException: failed to truncate truncate table
at com.ibm.team.repository.jdbcdriver.internal.oracle.OracleProvider.truncateTable(OracleProvider.java:502)
at com.ibm.team.repository.jdbcdriver.internal.oracle.OracleProvider.dropTempTable(OracleProvider.java:476)
at com.ibm.team.repository.service.db.provider.AbstractDbProvider.newLargeInListValueTempTable(AbstractDbProvider.java:1136)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy21.newLargeInListValueTempTable(null)
at com.ibm.team.repository.service.internal.db.util.InListValueTempTableManager.build(InListValueTempTableManager.java:98)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.doQueryData(RdbRepositoryDataMediator.java:913)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.queryData(RdbRepositoryDataMediator.java:884)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.queryData(RdbRepositoryDataMediator.java:873)
at com.ibm.team.repository.service.internal.QueryService.performQuery(QueryService.java:566)
at com.ibm.team.repository.service.internal.QueryService.doExecuteDataQuery(QueryService.java:374)
at com.ibm.team.repository.service.internal.QueryService.access$2(QueryService.java:367)
at com.ibm.team.repository.service.internal.QueryService$4.run(QueryService.java:1062)
at com.ibm.team.repository.service.internal.QueryService$4.run(QueryService.java:1)
---------------------------
Thanks
This is occurs only in a project that was set up using the OpenUp process template. We are using a new install of RTC v2.0.0.2 iFix5 and Oracle for the database.
An error code associated with this is: CRJAZ1037I. Here is the beginning of the error message itself:
----------------------------------
com.ibm.team.repository.common.TeamRepositoryException: failed to truncate truncate table
at com.ibm.team.repository.jdbcdriver.internal.oracle.OracleProvider.truncateTable(OracleProvider.java:502)
at com.ibm.team.repository.jdbcdriver.internal.oracle.OracleProvider.dropTempTable(OracleProvider.java:476)
at com.ibm.team.repository.service.db.provider.AbstractDbProvider.newLargeInListValueTempTable(AbstractDbProvider.java:1136)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy21.newLargeInListValueTempTable(null)
at com.ibm.team.repository.service.internal.db.util.InListValueTempTableManager.build(InListValueTempTableManager.java:98)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.doQueryData(RdbRepositoryDataMediator.java:913)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.queryData(RdbRepositoryDataMediator.java:884)
at com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.queryData(RdbRepositoryDataMediator.java:873)
at com.ibm.team.repository.service.internal.QueryService.performQuery(QueryService.java:566)
at com.ibm.team.repository.service.internal.QueryService.doExecuteDataQuery(QueryService.java:374)
at com.ibm.team.repository.service.internal.QueryService.access$2(QueryService.java:367)
at com.ibm.team.repository.service.internal.QueryService$4.run(QueryService.java:1062)
at com.ibm.team.repository.service.internal.QueryService$4.run(QueryService.java:1)
---------------------------
Thanks
One answer
Hello,
some way similar to 87533, but hard to diagnose here with a partial log
only (I would expect other ORA error in the log).
I propose you open a jazz.net work item (defect) with full details and
logs - check https://jazz.net/wiki/bin/view/Main/FilingDefects
and
https://jazz.net/wiki/bin/viewfile/Main/FilingDefects?rev=1;filename=CLM_MustGather.txt
Please subscribe me to the new work item, or add "@support" in a comment
to the work item.
Thanks.
Eric JODET
Jazz Development - L3 Maintenance
Le 1/11/2011 9:08 PM, jxh a crit :
--
some way similar to 87533, but hard to diagnose here with a partial log
only (I would expect other ORA error in the log).
I propose you open a jazz.net work item (defect) with full details and
logs - check https://jazz.net/wiki/bin/view/Main/FilingDefects
and
https://jazz.net/wiki/bin/viewfile/Main/FilingDefects?rev=1;filename=CLM_MustGather.txt
Please subscribe me to the new work item, or add "@support" in a comment
to the work item.
Thanks.
Eric JODET
Jazz Development - L3 Maintenance
Le 1/11/2011 9:08 PM, jxh a crit :
I am having problems creating and viewing a plan. There is an error
on creating the plan, but a plan gets placed in the Team Artifacts
Plans folder. Any attempt to look at the plan results in the same
error message as on creation. It is not clear if this is a creation
problem or a retrieval problem.
This is occurs only in a project that was set up using the OpenUp
process template. We are using a new install of RTC v2.0.0.2 iFix5
and Oracle for the database.
An error code associated with this is: CRJAZ1037I. Here is the
beginning of the error message itself:
----------------------------------
com.ibm.team.repository.common.TeamRepositoryException: failed to
truncate truncate table
at
com.ibm.team.repository.jdbcdriver.internal.oracle.OracleProvider.truncateTable(OracleProvider.java:502)
at
com.ibm.team.repository.jdbcdriver.internal.oracle.OracleProvider.dropTempTable(OracleProvider.java:476)
at
com.ibm.team.repository.service.db.provider.AbstractDbProvider.newLargeInListValueTempTable(AbstractDbProvider.java:1136)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.invoke(ExportProxyServiceRecord.java:370)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord.access$0(ExportProxyServiceRecord.java:356)
at
org.eclipse.soda.sat.core.internal.record.ExportProxyServiceRecord$ExportedServiceInvocationHandler.invoke(ExportProxyServiceRecord.java:56)
at $Proxy21.newLargeInListValueTempTable(null)
at
com.ibm.team.repository.service.internal.db.util.InListValueTempTableManager.build(InListValueTempTableManager.java:98)
at
com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.doQueryData(RdbRepositoryDataMediator.java:913)
at
com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.queryData(RdbRepositoryDataMediator.java:884)
at
com.ibm.team.repository.service.internal.RdbRepositoryDataMediator.queryData(RdbRepositoryDataMediator.java:873)
at
com.ibm.team.repository.service.internal.QueryService.performQuery(QueryService.java:566)
at
com.ibm.team.repository.service.internal.QueryService.doExecuteDataQuery(QueryService.java:374)
at
com.ibm.team.repository.service.internal.QueryService.access$2(QueryService.java:367)
at
com.ibm.team.repository.service.internal.QueryService$4.run(QueryService.java:1062)
at
com.ibm.team.repository.service.internal.QueryService$4.run(QueryService.java:1)
---------------------------
Thanks
--