In our company we are using Windchill 10.1 (M030), we found one of the issue, while creating the project, number created with random auto number generation, like 000021 and 000041. We raise ptc case, based on case, PTC tech support, attend the call and identify the error, database cache size 20, so that incremented with 20.
Issue: If we creating the project within a day continuously without delay getting continuous number with the increment of 1, like 000021, 000022, 000023, 000024, 000025 .....000030, no issues, but when we create the project with the interval of hour/day/week/month we found the random number like 00021,000041 etc.,. This will affecting our business area. Many company may facing this type of OOTB issues.
We have made customize sequence number in our Windchill 10.1 (M030) and working fine.
We also found some of the information document from PTC tech support, there was a solution to resolve this issue....to reduce the cache size from 20 to 0, but some of the oracle document says not advisable to change the cache, because it may affecting the performance issue.
My suggestion/idea to resolve the issue of jumping number in Windchill permanently in the current version with the patch updation, every customer appreciate and may suggest to other customer also with the statement of "now Windchill come up with problem/issue free software". Business may boost and product moving to reliable. Thanks