The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
The community will be in read-only from Tuesday 11:59pm (PST) to Wednesday 7:30am (PST)
Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

New Project Type Error

Highlighted
JLPPMC
Occasional Advisor

New Project Type Error

Hello,

 

I am new to PPMC v9.1 and I am trying to configure a new Project Type with a custom (basic) Request Type and associated custom (basic) workflow. The Request Type contains a small number of additional fields.

 

When attempting to create the new Project Type I have continually received an error stating that an unknown exception has occurred.

 

I have tried creating Project Types with standard PPMC Request Types, as well as standard workflow. All attempts have resulted in the same error.


Can anyone offer any assistance?


Thanks!

 

9 REPLIES
Shilpesh_Pathak
Occasional Advisor

Re: New Project Type Error

Hi,

Can you share the screen shot of error message?

Thanks
Shilpesh
dirkf
Honored Contributor

Re: New Project Type Error

Hi JLPPMC,

 

can you also let us know in which session language you are creating the project type and if it contains any special language chars?

 

Best regards,

Dirk

JLPPMC
Occasional Advisor

Re: New Project Type Error

The error message is included below:

 

An Error has Occurred

An unknown exception has occurred. Please reload the page you were editing and try again.

The following is a stack trace of the exception:

com.kintana.core.server.RuntimeBaseException:

An HP Internal error has occurred. Please contact HP Project and Portfolio Management support if the problem persists. (KNTA-10023)

 

Exception Correlation: GUID-F10A9BD0-C877-1700-F004-B78ECF0A70FF

Generated Time

Server Node Name: kintanta

 

For the session language, I am using the standard English test configuration. I have not made any changes other than some Request Type and Workflow configurations from the Admin account.


Thanks again for all of your help!

dirkf
Honored Contributor

Re: New Project Type Error

Hi JLPPMC,

 

the GUI correlation exception that you gave (showing the runtimexception) is generic and while being a hint, not real helpful. Can you please check in the serverlog.txt if you can still locate the string "GUID-F10A9BD0-C877-1700-F004-B78ECF0A70FF" (whithout quotes), which should then give the full stack trace. Please either give back THAT stack trace or reproduce the problem and then use that GUID to search for the stack in the log, then either attach the log or copy and paste the full available stack trace from the log into a file and attach that here.

 

Reason is that the RuntimeException can occur in many places and modules and doesn't really give us a hint of the problem.

Please also indicate -

- when exactly this problem happens - upon save?

- if this is an upgraded environment (from which version) or a fresh install

- which jdk is installed - version, build and bit

- which database is lying under PPM?

 

I think we have a valid support case here but if you can supply the data here, we can have a look, else supply the data when logging a support case if you prefer that.

 

Best regards,

Dirk

 

JLPPMC
Occasional Advisor

Re: New Project Type Error

Hello Dirk,

 

I believe that this is what you are looking for:

 

server:ppmLightServiceListenerContainer-2:com.kintana.services:2011/06/29-13:13:57.578 MDT: An HP internal error has occurred. Please contact HP Project and Portfolio Management support if the problem persists. (KNTA-10023)

Exception Correlation: GUID=3CB3DFC9-585C-2D78-AD11-8D45EFC60CB2

Generated Time=2011/06/29-13:13:57.578 MDT

Server Node Name: kintana

nested detail:ORA-31495: error in synchronous change table on "PPM"."PGM_PROGRAMS"

ORA-01688: unable to extend table PPM.PGM_PROGRAMS_CDC partition P1 by 1024 in tablespace USER_DATA

An HP internal error has occurred. Please contact HP Project and Portfolio Management support if the problem persists. (KNTA-10023)

Exception Correlation: GUID=3CB3DFC9-585C-2D78-AD11-8D45EFC60CB2

Generated Time=2011/06/29-13:13:57.578 MDT

Server Node Name: kintana

                at com.kintana.pfm.server.PFMEntityAgent.updateProgramFinancialMetrics(PFMEntityAgent.java:3090)

                at com.kintana.pfm.server.FinancialMetricsUpdateService.updateFinancialMetrics(FinancialMetricsUpdateService.java:175)

                at com.kintana.pfm.server.FinancialMetricsUpdateService.updateFinancialMetrics(FinancialMetricsUpdateService.java:201)

                at com.kintana.pfm.server.FinancialMetricsUpdateService.runService(FinancialMetricsUpdateService.java:247)

                at com.mercury.itg.core.jms.service.impl.GenericServiceMessageHandler.handleMessage(GenericServiceMessageHandler.java:62)

                at com.mercury.itg.core.monitor.impl.BackgroundServiceMonitorAspect.monitorService(BackgroundServiceMonitorAspect.java:103)

                at com.mercury.itg.core.jms.service.impl.ServiceMessageListenerImpl.onServiceMessage(ServiceMessageListenerImpl.java:297)

                at com.mercury.itg.core.jms.service.impl.ServiceMessageListenerImpl.onMessage(ServiceMessageListenerImpl.java:165)

Caused by: java.sql.SQLException: ORA-31495: error in synchronous change table on "PPM"."PGM_PROGRAMS"

ORA-01688: unable to extend table PPM.PGM_PROGRAMS_CDC partition P1 by 1024 in tablespace USER_DATA

 

                at com.kintana.core.db.pool.PooledPreparedStatement.executeUpdate(PooledPreparedStatement.java:177)

                at com.kintana.pfm.server.PFMEntityAgent.updateProgramFinancialMetrics(PFMEntityAgent.java:3087)

                ... 7 more

 

                Filtered Out 78 Stack Trace Lines.

 

 

1. The issue occurs when I attempt to select "create" for a new Project.

2. The environment is a fresh install

3. jdk info:

-java version "1.6.0_12"

-Java(TM) SE Runtime Environment (build 1.6.0_12-b04)

-Java HotSpot(TM) Client VM (build 11.2-b01, mixed mode, sharing)

4. Oracle version 11.2.0

 

Thanks again!

dirkf
Honored Contributor

Re: New Project Type Error

Hi JLPPMC,

 

the error that you are showing in the last update can't really be what you initially reported. We don't see a runtime-exception but instead the following:

 

nested detail: ORA-31495: error in synchronous change table on "PPM"."PGM_PROGRAMS"

ORA-01688: unable to extend table PPM.PGM_PROGRAMS_CDC partition P1 by 1024 in tablespace USER_DATA

 

 I’ve searched around a bit and found that the table that is referred is ONE table of a couple as shown here:

 

KCRT_FG_PFM_ASSET_CDC
KCRT_FG_PFM_PROJECT_CDC
KCRT_FG_PFM_PROPOSAL_CDC
PGM_PROGRAMS_CDC
KCRT_REQUESTS_CDC

 

 The "Financial Metrics Update Service" scheduled to run is the updating these CDC tables.
PFMEntityAgent.java contains the code for these updates.

 

it seems that every time the services run - even if there are no actual changes to the data in the entities - possibly except last_update_date - the data capture routines are registering that as a change and copying off the data to the appropriate _CDC tables at a rate of about x records per minute, where x depends on the amount of entities present.

 

 This has been reported in QCCR1L40255

http://support.openview.hp.com/selfsolve/document/FID/DOCUMENTUM_QCCR1L40255

 

I suggest you check the above tables, export them and log a support case with the problem description, table exports, serverlog.txt etc soonest to get assistance on that matter.

As to the other (initial) issue - when you reproduce the issue and use the GUID to search the log, you should see a runtime-exception there as well. Please show that to let me know how to proceed.

 

Best regards,

Dirk

JLPPMC
Occasional Advisor

Re: New Project Type Error

Dirk,

 

I have attempted to create a new workflow, request type, request header and project type in order to recreate the error originally reported. Now, when I select "create" during the project type step I receieve the following error:

 

An unknown exception has occurred. Please reload the page you were editing and try again.

 

The following is a stack trace of the exception:
com.kintana.core.server.RuntimeBaseException:

An HP internal error has occurred. Please contact HP Project and Portfolio Management support if the problem persists. (KNTA-10023)

 

Exception Correlation: GUID=CCF97829-4CA0-2FC8-3526-C3F33FC9A564

Generated Time=2011/07/06-11:20:55.171 MDT

Server Node Name: kintana

 

The server logs for that error are included below:

JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.171 MDT: An HP internal error has occurred. Please contact HP Project and Portfolio Management support if the problem persists. (KNTA-10023)

Exception Correlation: GUID=CCF97829-4CA0-2FC8-3526-C3F33FC9A564
Generated Time=2011/07/06-11:20:55.171 MDT
Server Node Name: kintana
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT: nested detail:com.mercury.dashboard.arch.provider.DashboardAsynchronicAPIException: com.mercury.dashboard.arch.InternalDashboardException: Could not execute JDBC batch update
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:


JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT: An HP internal error has occurred. Please contact HP Project and Portfolio Management support if the problem persists. (KNTA-10023)

Exception Correlation: GUID=CCF97829-4CA0-2FC8-3526-C3F33FC9A564
Generated Time=2011/07/06-11:20:55.171 MDT
Server Node Name: kintana
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.mercury.itg.common.web.ITGExceptionHandler.execute(ITGExceptionHandler.java:123)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.mercury.itg.common.web.PortletTilesRequestProcessor.process(PortletTilesRequestProcessor.java:53)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.mercury.itg.servlet.ActionMonitorFilter.doFilter(ActionMonitorFilter.java:86)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.mercury.itg.servlet.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:79)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.kintana.core.web.filter.MLUFilter.applyFilter(MLUFilter.java:110)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:59)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.kintana.core.web.filter.stinger.ValidationFilter.applyFilter(ValidationFilter.java:93)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.kintana.core.web.filter.stinger.ValidationFilter.doFilter(ValidationFilter.java:66)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.kintana.core.web.filter.MultipartRequestFilter.applyFilter(MultipartRequestFilter.java:108)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:59)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.kintana.core.web.filter.ControlFilter.applyFilter(ControlFilter.java:841)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.kintana.core.web.filter.ControlFilter.doFilter(ControlFilter.java:1334)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.mercury.itg.servlet.I18NFilter.doFilter(I18NFilter.java:40)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.kintana.core.web.filter.Log4jFilter.applyFilter(Log4jFilter.java:49)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:59)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT: Caused by: java.lang.RuntimeException: com.mercury.dashboard.arch.provider.DashboardAsynchronicAPIException: com.mercury.dashboard.arch.InternalDashboardException: Could not execute JDBC batch update
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.mercury.itg.util.SpringHibernateTemplate$1.doInTransactionWithoutResult(SpringHibernateTemplate.java:85)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.mercury.itg.util.SpringHibernateTemplate.doRun(SpringHibernateTemplate.java:74)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.mercury.itg.pm.project.web.SaveProjectTypeAction.doExecute(SaveProjectTypeAction.java:143)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.mercury.itg.common.web.BaseAction.execute(BaseAction.java:168)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  ... 14 more
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT: Caused by: com.mercury.dashboard.arch.provider.DashboardAsynchronicAPIException: com.mercury.dashboard.arch.InternalDashboardException: Could not execute JDBC batch update
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.mercury.dashboard.arch.provider.util.DashboardAsynchronicAPIImpl.cloneEM(DashboardAsynchronicAPIImpl.java:259)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.kintana.dsh.util.EntityModuleHandler.clonePTEM(EntityModuleHandler.java:59)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.mercury.itg.pm.project.web.SaveProjectTypeAction.saveSettings(SaveProjectTypeAction.java:690)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.mercury.itg.pm.project.web.SaveProjectTypeAction.doExecuteWithSession(SaveProjectTypeAction.java:233)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.mercury.itg.pm.project.web.SaveProjectTypeAction$1.run(SaveProjectTypeAction.java:135)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.mercury.itg.util.SpringHibernateTemplate$1.doInTransactionWithoutResult(SpringHibernateTemplate.java:80)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  ... 17 more
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT: Caused by: com.mercury.dashboard.arch.InternalDashboardException: Could not execute JDBC batch update
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.mercury.dashboard.arch.hibernate.HibernateTransaction.commit(HibernateTransaction.java:49)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.mercury.dashboard.app.module.ModuleUtils.cloneEMModule(ModuleUtils.java:315)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.mercury.dashboard.arch.provider.util.DashboardAsynchronicAPIImpl.cloneEM(DashboardAsynchronicAPIImpl.java:256)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  ... 22 more
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT: Caused by: org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.mercury.dashboard.arch.hibernate.SessionWrapper.commitTrasaction(SessionWrapper.java:53)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  at com.mercury.dashboard.arch.hibernate.HibernateTransaction.commit(HibernateTransaction.java:45)
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  ... 24 more
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT: Caused by: java.sql.BatchUpdateException: ORA-01653: unable to extend table PPM.DSH_PORTLETS_LOC by 128 in tablespace USER_DATA

JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:  ... 26 more
JSESSIONID=7AA4D69D7DEDEC237642DB54190B2CC9.kintana,USERNAME=admin server:http-0.0.0.0-8082-Processor9:SystemErr:2011/07/06-11:20:55.187 MDT:
 Filtered Out 331 Stack Trace Lines.
:ppmHeavyServiceListenerContainer-2:com.mercury.itg.core.cost:2011/07/06-11:20:55.359 MDT: cost rollup with id 54473 failed.
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT: java.lang.RuntimeException: com.mercury.itg.exceptions.ObjectNotFoundException
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at com.mercury.itg.util.SpringHibernateTemplate$1.doInTransactionWithoutResult(SpringHibernateTemplate.java:85)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at com.mercury.itg.util.SpringHibernateTemplate.doRun(SpringHibernateTemplate.java:74)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at com.mercury.itg.core.cost.rollup.ProposalRollupService.rollupSingle(ProposalRollupService.java:161)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at com.mercury.itg.core.cost.rollup.AbstractRollupService$1.run(AbstractRollupService.java:79)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at com.mercury.itg.util.HibernateTemplate.doRun(HibernateTemplate.java:200)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at com.mercury.itg.core.cost.rollup.AbstractRollupService.runRollups(AbstractRollupService.java:93)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at com.mercury.itg.core.cost.rollup.AbstractRollupService.runServiceImpl(AbstractRollupService.java:39)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at com.mercury.itg.core.cost.CostRollupService.runServiceImpl(CostRollupService.java:89)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at com.mercury.itg.core.server.mdServices.PluggableHibernateMDService.runService(PluggableHibernateMDService.java:37)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at com.mercury.itg.core.jms.service.impl.GenericServiceMessageHandler.handleMessage(GenericServiceMessageHandler.java:62)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at sun.reflect.GeneratedMethodAccessor273.invoke(Unknown Source)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at java.lang.reflect.Method.invoke(Method.java:597)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at com.mercury.itg.core.monitor.impl.BackgroundServiceMonitorAspect.monitorService(BackgroundServiceMonitorAspect.java:103)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at sun.reflect.GeneratedMethodAccessor272.invoke(Unknown Source)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at java.lang.reflect.Method.invoke(Method.java:597)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:627)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:616)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:64)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at $Proxy110.handleMessage(Unknown Source)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at com.mercury.itg.core.jms.service.impl.ServiceMessageListenerImpl.onServiceMessage(ServiceMessageListenerImpl.java:297)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at com.mercury.itg.core.jms.service.impl.ServiceMessageListenerImpl.onMessage(ServiceMessageListenerImpl.java:165)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at sun.reflect.GeneratedMethodAccessor268.invoke(Unknown Source)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at java.lang.reflect.Method.invoke(Method.java:597)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at $Proxy112.onMessage(Unknown Source)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.jms.listener.AbstractMessageListenerContainer.doInvokeListener(AbstractMessageListenerContainer.java:543)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.jms.listener.AbstractMessageListenerContainer.invokeListener(AbstractMessageListenerContainer.java:482)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.jms.listener.AbstractMessageListenerContainer.doExecuteListener(AbstractMessageListenerContainer.java:451)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.doReceiveAndExecute(AbstractPollingMessageListenerContainer.java:323)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.jms.listener.AbstractPollingMessageListenerContainer.receiveAndExecute(AbstractPollingMessageListenerContainer.java:261)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.invokeListener(DefaultMessageListenerContainer.java:982)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.executeOngoingLoop(DefaultMessageListenerContainer.java:974)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.jms.listener.DefaultMessageListenerContainer$AsyncMessageListenerInvoker.run(DefaultMessageListenerContainer.java:876)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at java.lang.Thread.run(Thread.java:619)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT: Caused by: com.mercury.itg.exceptions.ObjectNotFoundException
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at com.mercury.itg.fm.service.impl.FMServiceImpl.getParentFsId(FMServiceImpl.java:1573)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at sun.reflect.GeneratedMethodAccessor1241.invoke(Unknown Source)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at java.lang.reflect.Method.invoke(Method.java:597)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at $Proxy78.getParentFsId(Unknown Source)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at com.mercury.itg.core.cost.rollup.ProposalRollupService$2.run(ProposalRollupService.java:89)
server:ppmHeavyServiceListenerContainer-2:SystemErr:2011/07/06-11:20:55.359 MDT:  at com.mercury.itg.util.SpringHibernateTemplate$1.doInTransactionWithoutResult(SpringHibernateTemplate.java:80)

 

Thank you again for all of your help!


 

Toby Harvey
Super Collector

Re: New Project Type Error

I suspect you might want to get your DBAs involved in this one.  the initial error about not being able to extend Tablespace by 1024 looks like it might be a DB error, specifically that your allocation of space in Oracle for PPM has reached a limit and no more data can be stored ...

 

If this is the case then you might start seeing other weird stuff happening that is hard to pin down, hence the series of errors in your last post.

 

No guarantees of course but it would be worth checking out :)

AlexSavencu
Honored Contributor

Re: New Project Type Error

Hi,

 

99.99% this is an issue related to disk space allocation for Oracle.

 

BTW, I know that PPM does not use partitioned tables by default - did you partition the table by yourself?

 

cheers

alex


--remember to kudos people who helped solve your problem
//Add this to "OnDomLoad" event