AnsweredAssumed Answered

Invalid prextension column in PRASSIGNMENT table

Question asked by Lukas_Jezek on Dec 30, 2014
Latest reply on Jan 6, 2015 by urmas

Hello everyone,

 

does anyone have experience with invalid blob ca ppm schema column? We found some (28rows) as invalid. there are 28 assignments with error within application. These rows(assignments) cannot be added(used) to timesheets -> returns server error again.It can not be repaired on DB level and we have no backup from time when these rows had been as valid. Because of this, Post timesheet job is not working - timesheets are not converted from approved to posted status. time slicing where is sliced value from mentioned column is also not working(finishing with error).

 

We tried in dev to delete content of this column, but this is not recommended step after CA support discussion and we have lost all data about assignment. Do you have any idea how to solve it?

 

Thank you very much

Outcomes