Project number conflicts with project number ######

(0) Share

Report

Posted on by Community Member

I have changed my proj id number sequence to manual and then I have created one project such as 1234 and after that I have created a new project 12345, while creating this project I have encountered an error stating "Project number conflicts with project number 1234."

how can this be resolved ?

Thanks in advance

*This post is locked for comments

I have the same question (0)

All responses (15)

Answers (1)

Crispin John Augustine 37,081 on at

Like (0)

Report

Yes, that is because the number 1234 (which you manually created) is not stored as the last generated number in the number sequence. So it tries to create the same number..

You can fix this by going to the number sequence, and update the next number to 1235, and it should work smooth from there..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks John for your quick response.

But as my business wants number sequence to be manual, so I cannot edit next number to 1234 because in manual condition the field becomes non editable.

Was this reply helpful? Yes No
Crispin John Augustine 37,081 on at

Like (0)

Report

I guess, you are getting this error from a number sequence Validation.

You can confirm/get more Details by Debugging the form datasource validateWrite() method of the form ProjTableCreate.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
yes, I have already debugged through all the codes.

Issue is coming from the below code :-

if (!projTable.RecId) { if (!projTable.ParentId) { while (projHier) { projHier = subStr(projHier,1,strLen(projHier)-1); if (ProjTable::exist(projHier) && projHier != projTable.ParentId) { return checkFailed (strFmt("@SYS53140",projHier)); } } if (ProjTable::like(projTable.ProjId+'*')) { return checkFailed (strFmt("@SYS53140",ProjTable::findLike(projTable.ProjId+'*').ProjId)); } } }

in this case whenever i am giving any project Id such as 12345 then it is going into while loop and removing the last digit or character of id and finding weather this is available in ProjTable. I wanted to know that why this validation is there if i remove this validation for manual number sequence where it will have impact.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Tarak Pandey,

When and where have you encountered this error message?

I have seen this for IC-Project invoices.

When did it pop up in your case?

Best regards,

Ludwig

Was this reply helpful? Yes No
Crispin John Augustine 37,081 on at

Like (0)

Report

This is to validate the Project tree. (Parent-Child Projects..)

Yes, you can consider, removing the Validation inside the while Loop. (provided it is not required, given your Manual definition for projectId)

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Ludwig,

I have changed my project Id number sequence to manual as per business requirement and then as i have explained earlier, i have tried creating projects as e.g 1234 and and 12345 respectively the first project is getting created but when i am trying to create second project i am getting this error.

So i have done a complete debugging and found that the above validation of project ID is creating this issue.

Now the major issue is that why this validation is written because this validation will only pass when my numseq is in continuous mode.

It will be very helpful for me, if you can share your thoughts on this.

Best Regards,

Tarak Pandey

Was this reply helpful? Yes No
Verified answer

David Massey on at

Like (0)

Report

This validation is in place to avoid reporting issues with subprojects. Large portions for the codebase use a LIKE command in selection of records. The subproject Id will include the parents project Id. In your example Project Id 12345 will be seen as a subproject of Project ID 1234.

Was this reply helpful? Yes No
darshana.parnaik 210 on at

Like (0)

Report

Hi Tarak ,

I have same issue regarding Project ID. So can you pls help me for the same.

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

Like (0)

Report

Hi Nikita,

As moderator, I have now marked the answer from David as verified answer. You cannot have a number like 1234 and another main project with 12345. The reason is explained by David.

Was this reply helpful? Yes No