New Project : Number sequence format issue while creating a new subProject

(0) Share

Report

Posted on by vicky1234

hi,

We are getting the below standard error message while creating a subproject from a main Project .

Main project as in the first project you created and then from that project you will create subproject. Instead of new we click on subproject from below screen.

I have defined a format at the Project hierarchy level however whenever I am creating a record it gives me below error.

"New subproject ID cannot be created because systems alphanumeric character conversion to integer value exceeds integer length limit."

On debugging I have found that the below method is getting called from ProjTable "generateNextSubProjectId".

There are different formats which are getting checked and eventually i get a number is -1614 and based on that it is throwing an error.

Can someone please guide me what is wrong in this format or I am i missing something.

The format of number sequence that we have defined in the sytem is "PRJ######".

thanks,

I have the same question (0)

All responses (7)

Answers (0)

André Arnaud de Cal... 301,053 Super User 2025 Season 2 on at

Like (1)

Report

Hi VK,

What is the reason to have the '&' character in the subproject ID format? With the current format, it thinks to have 2 or 3 positions for the number. The current number is having 4 positions which is larger than the format provided.

Was this reply helpful? Yes No
vicky1234 66 on at

Like (0)

Report

Hi Andre,

thanks for replying,

The '&' is basically to imply a alphabet in the format. So in case the format is &## and the current project number is 1234PRJ-005 then the subproject will be 1234PRJ-A01

or else if the format is "###" then the subproject created will be 1234PRJ-005-001 .
this works fine for a child project however the error I am getting is only for the main parent Project so in the above case for format "&##" and not "###".

1234PRJ-005 - > create sub project - >1234PRJ-005-A01

1234PRJ -> create sub project - > get error.

1234PRJ-005-001

Was this reply helpful? Yes No
André Arnaud de Cal... 301,053 Super User 2025 Season 2 on at

Like (1)

Report

Hi VK,

I just tested it on a 10.0.30 environment. I did get the subproject with A01 as per expectation. I wonder why you get the value -1614 in your environment? What is the version of your environment? Do you have customizations in this area?

Was this reply helpful? Yes No
vicky1234 66 on at

Like (0)

Report

hi Andre,

Many thanks for trying it on your environment.

environment Version : 10.0.29 and no customization wrt this section of code is done in my environment.

The issue is that when the below method is called for a parent Project in that case the "projidLastSon" value is available for eg. "-005" and then it checks

the value in the NumberSeq method which gives the output as "-1673" and just below this we have the authentication to give error in case the values is less than 0.

Number sequence method

If i run the same for the prroject "1234PRJ-005" -> then it will give me a proper output as that validation part itself is skipped for this project.

However If I run for proejct "1234PRJ" it does give me an error.

Below is the screen for a child project,

And all this is because the std code of Number sequence returns a value greater than zero for the format shared.

Thanks,

VM

Was this reply helpful? Yes No
vicky1234 66 on at

Like (0)

Report

Hi Andre

just to inform the screens are taken for the project having current projidlastson as "-027" and not "-005"

Was this reply helpful? Yes No
André Arnaud de Cal... 301,053 Super User 2025 Season 2 on at

Like (1)

Report

Hi VK,

Are you able to test it also on a 10.0.30 environment? Maybe something got fixed in this version.

Was this reply helpful? Yes No
vicky1234 66 on at

Like (0)

Report

hi Andre,

I have also checked the code in the 10.0.30 environment and its same.

the problem is that the system calculates values based on some std logic in the number sequence format and it causes the error.

I will try to create with some other format.

But I am curious to know whether changing the current format of the project ID will help in any case.

Thanks,

VM

Was this reply helpful? Yes No