Project and Portfolio Management Support and News Forum
Showing results for 
Search instead for 
Do you mean 

Request Numbers sequence and maximum length

SOLVED
Go to Solution
Highlighted
ur1
Occasional Advisor

Request Numbers sequence and maximum length

Can anyone tell me if what rules or constraints are around request Numbers sequence and maximum length.

For exampl we are in the five digit count around 48000.

Does this increment to a maximum like 99999?

We want to use the number in document naming rules and wish to know if this number will grow and to what number of digits?

 

 

| CMC (HP PPM) Administration| Change Portfolio Office | Change Division |
| Bendigo and Adelaide Bank Limited|PO Box 480 Bendigo Vic 3552|
| email: changeportfolioofficemailbox@bendigobank.com.au |
1 ACCEPTED SOLUTIONS
HPE Expert

Re: Request Numbers sequence and maximum length

Hi,

 

PPM will not put any limit to sequence numbers maximum length.

 

The upper bound on the PPM IDs in DB is that of Oracle NUMBER data type, i.e.  999...(38 9's) x10125 (according to http://docs.oracle.com/cd/B28359_01/server.111/b28320/limits001.htm#i287903 ).

 

However, there are many IDs that are stored in Java Integers in PPM code, which will cause issues if the value exceeds 2,147,483,647. 

 

In other words, I think it's safe to assume that PPM IDs will always remain under that limit. This may look like a relatively small number (at least compared to the Oracle limit), but considering that PPM IDs start at 30k, if your users create 100k new entities of a type per day (which is a very high estimate you'll agree), your PPM environment can still run for about 60 years before reaching that limit. 

 

Thanks,

Etienne.

4 REPLIES
HPE Expert

Re: Request Numbers sequence and maximum length

Hi,

 

PPM will not put any limit to sequence numbers maximum length.

 

The upper bound on the PPM IDs in DB is that of Oracle NUMBER data type, i.e.  999...(38 9's) x10125 (according to http://docs.oracle.com/cd/B28359_01/server.111/b28320/limits001.htm#i287903 ).

 

However, there are many IDs that are stored in Java Integers in PPM code, which will cause issues if the value exceeds 2,147,483,647. 

 

In other words, I think it's safe to assume that PPM IDs will always remain under that limit. This may look like a relatively small number (at least compared to the Oracle limit), but considering that PPM IDs start at 30k, if your users create 100k new entities of a type per day (which is a very high estimate you'll agree), your PPM environment can still run for about 60 years before reaching that limit. 

 

Thanks,

Etienne.

ur1
Occasional Advisor

Re: Request Numbers sequence and maximum length

Thanks Etienne much appreciated.

 

Wayne

| CMC (HP PPM) Administration| Change Portfolio Office | Change Division |
| Bendigo and Adelaide Bank Limited|PO Box 480 Bendigo Vic 3552|
| email: changeportfolioofficemailbox@bendigobank.com.au |
Occasional Contributor

Re: Request Numbers sequence and maximum length

We did a fresh install of HPPM 9.3 instead of upgrading our KIntana 7.5. Our Package numbers are up tto 48,000. We want to start the new installation with 50,000. How can we do it? Is there a specia l script or just adjust the Oracle sequence..which one or ones. Thanks in advance.

-Ned Leonor, ILO

Valued Contributor

Re: Request Numbers sequence and maximum length

You need to drop and recreate the sequence and specified the min value in 50000.