Project and Portfolio Management Practitioners Forum
cancel

Maximum number of tasks per work plan?

SOLVED
Go to solution
Highlighted
roxor
Honored Contributor.

Maximum number of tasks per work plan?

Hello,

 

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 dind't  see nothing in the documentation...

 

Thanks a lot,

r.

7 REPLIES
Celil
Acclaimed Contributor.

Re: Maximum number of tasks per work plan?

Hi roxor,

 

please try to increase MAX_PAGE_SIZE parameter.

 

Celil

Celil

IT Governance Professional
& PPM Solution Architect
roxor
Honored Contributor.

Re: Maximum number of tasks per work plan?

Hello Celil,

 

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

I would say, that this is another problem...

 

Thanks,

r.

Celil
Acclaimed Contributor.

Re: Maximum number of tasks per work plan?

Hi roxor, you could be right but it is worth to try.

 

 

Celil

IT Governance Professional
& PPM Solution Architect
roxor
Honored Contributor.

Re: Maximum number of tasks per work plan?

hmm, this didn't help :(
MAG_PAGE_SIZE=700 and still not possible to create a task.
roxor
Honored Contributor.

Re: Maximum number of tasks per work plan?

I have opened ticket for this. From server log it seems to be related to this error:

ORA-01795: maximum number of expressions in a list is 1000

Kerim KILIC
Honored Contributor.

Re: Maximum number of tasks per work plan?

can you please paste log file part that contains ora error, there is hotfix available through hp if you got this error from basetaskpersister(something like this) class.

roxor
Honored Contributor.
Solution

Re: Maximum number of tasks per work plan?

Hello,

 

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

 

Thanks for help,

r.