Post Timesheet ORA-01400 ("CLARITY"."NBI_PROJ_RES_RATES_AND_COSTSCP"."TEAM_ID")

book

Article ID: 140153

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

After running the Post Tiemsheet job, I see there is an approved timesheet that is not moving to a Posted status
Looking at bg-ca.log file, we see the following error:
Stored Procedure application error java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error in CMN_JOB_RATE_MATRIX_SP - ORA-20000: Error in NBI_PROJ_RATES_AND_COSTS_SP - Performing project-related activities, inserting rows associated with the specific assignments: ORA-01400: cannot insert NULL into ("CLARITY"."NBI_PROJ_RES_RATES_AND_COSTSCP"."TEAM_ID") 
ORA-06512: at "CLARITY.CMN_JOB_RATE_MATRIX_SP", line 15 
ORA-06512: at line 1 

Cause

There is an assignment where the team_id is NULL

Resolution

select * from prassignment where team_id is null

If any data is returned, please contact support

Additional Information

Please also check 


I am having problems to post a specific timesheet. What could be the reasons?

articleId=140155