Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Error while creating time sheet

Highlighted
Govardhan07
Regular Collector

Error while creating time sheet

I am currently using HP PPM 6.5

 

I am getting following error while creating time sheet.

 

 

ORA-01403: no data found ORA-06512: at "PPM_MAIN.KTMG_TIME_SHEET_LINE_D_T1", line 93 ORA-04088: error during execution of trigger 'PPM_MAIN.KTMG_TIME_SHEET_LINE_D_T1'

java.sql.SQLException: ORA-01403: no data found
ORA-06512: at "PPM_MAIN.KTMG_TIME_SHEET_LINE_D_T1", line 93
ORA-04088: error during execution of trigger 'PPM_MAIN.KTMG_TIME_SHEET_LINE_D_T1'

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
at com.kintana.core.db.pool.PooledPreparedStatement.executeUpdate(PooledPreparedStatement.java:164)
at com.kintana.core.arch.DataBeanPersister.doInsert(DataBeanPersister.java:391)
at com.kintana.core.arch.DataBeanPersister.save(DataBeanPersister.java:347)
at com.kintana.core.arch.BizBeanCollectionDBAdapter.invokeSaver(BizBeanCollectionDBAdapter.java:321)
at com.kintana.core.arch.BizBeanCollectionDBAdapter.save(BizBeanCollectionDBAdapter.java:195)
at com.kintana.tmg.server.TimeSheetLineDBAdapter.saveChildren(TimeSheetLineDBAdapter.java:57)
at com.kintana.core.arch.BizBeanCollectionDBAdapter.save(BizBeanCollectionDBAdapter.java:206)
at com.kintana.tmg.server.TimeSheetDBAdapterImpl.justSave(TimeSheetDBAdapterImpl.java:186)
at com.kintana.tmg.server.TimeSheetDBAdapterImpl.save(TimeSheetDBAdapterImpl.java:145)
at com.kintana.core.arch.DBAdapter.saveWrapper(DBAdapter.java:132)
at com.kintana.core.arch.Home.save(Home.java:142)
at com.kintana.tmg.web.ctrl.TimeSheetSaveController.saveTimeSheet(TimeSheetSaveController.java:57)
at org.apache.jsp

 

1 REPLY
Oscar_Pereira
Frequent Visitor

Re: Error while creating time sheet

Hello Govard,

 

1-Did you check the status for the trigger?

 

select object_name,status from user_objects where object_name like 'KTMG_TIME_SHEET_LINE_D_T1';

 

2-Does it happen for all timesheets?

 

3-Does it happen for all users?

 

4-Does it happen for every single time period?

 

Sounds like an issue with a id sequence.

 

Regards

Oscar P

//Add this to "OnDomLoad" event