I am not able to copy and paste task in the work plan. I am on the task id sequence number 998 so it seems to me that PPM has some constraints about maximum tasks per work plan. Is this possible? If yes could this constraint be changed?
I can't restart production instance where we have this issue so I will try to change this parameter later, but I tried to create tasks in the same work plan on development and everything goes fine. I am on number 1050 and no problem. But production goes on PPM 7.5 and development is now on PPM 8.03 - our upgrade is in progress in these days...
I have also checked this Max_Page_Size parameter and documentation says: "Absolute maximum number of work plan lines that can be loaded into the Work Plan page"
So I am not sure if this could help. And on production and development instance, we have MAX_PAGE_SIZE = 500
HP support provided me the patch for this issue. Solution was really quick form their side so it seems to me like known bug. Now it works fine.
@Kerim: this was from server log message:
JSESSIONID=10C3B0889B51C9DA240506415E14F165.F1,USERNAME=admin:http-0.0.0.0-8080-Processor25:org.hibernate.util.JDBCExceptionReporter:2011/09/27-21:00:10.150 CEST: ORA-01795: maximum number of expressions in a list is 1000
JSESSIONID=10C3B0889B51C9DA240506415E14F165.F1,USERNAME=admin:http-0.0.0.0-8080-Processor25:org.hibernate.util.JDBCExceptionReporter:2011/09/27-21:00:25.914 CEST: ORA-01795: maximum number of expressions in a list is 1000
JSESSIONID=10C3B0889B51C9DA240506415E14F165.F1,USERNAME=admin server:http-0.0.0.0-8080-Processor25:SystemErr:2011/09/27-21:00:25.920 CEST: org.hibernate.exception.SQLGrammarException: could not execute query