Skip to content

Limit of 32000 rows has been exceeded in P3

Robin ReyesMember for 20 years
Created
11
1
0
Our project using the P3 already has almost 28000 activities. And if we filter all activities, a message will appear that "Limit of 32000 rows has been exceeded." Is there a way to tweak the registry to revise the 32000 rows limit?

Can anyone knows? Thanks.

11 replies

Oldest first
  1. 0
    Samer Zawaydeh ·
    Dear Robin,

    You can split it into two projects.

    With kind regards,

    Samer
  2. 0
    Alexandre Faulx-Briole ·
    Robin,
    Split your initial 28000+ activity project into smaller projects, based on the WBS
    Then create a master project in which you will insert the "smaller projects"; this way, all your sub projects will share the same data dictionary: wbs, resources, activity codes, ...
    Alexandre
  3. 0
    Shah. HB ·
    Hi to all

    Another option is to convert P3 programme to P6 which is very easy step for you to carry on
  4. 0
    Rafael Davila ·
    P3 version 3.0 or 3.1?
  5. 0
    Robin Reyes ·
    Thanks for the replies guys.
    I am using P3 Version 3.1
    I cannot use P6 since it is the client/Engineer requirement to use P3.
    Moreover, I cannot split the project into two and cannot do a subproject since we already used all ten digits Activity ID.

    The only solution applicable for me is to tweak the P3 registry that limit the maximum rows to 32,000 but apparently, I cannot find the P3 register so I can edit it.

    Goodluck to me.

  6. 0
    Alexandre Faulx-Briole ·
    Robin
    why can’t you split your huge project because of 10 digit Activity Codes?
    it is possible to use the same Activity Codes sequence in more than one project, look at the CLIN sample project that ships with P3
    about P3 registry: P3 is a 16 bit application, which does not use the Windows registry; it uses a P3.INI file located in the C:\Windows folder
    You should try splitting your project on a small scale, and advise.
    Alexandre
  7. 0
    Ian Nicholson ·
    The limit is only on the layout, not on the file itself. I can’t imaging why you would want a layout to show > 32,000 activities but P3 won’t lose the data if you go over, it just won’t display it all on the screen at the same time.

    Primavera has run test files up to 100k activities and 100k relationships. Make sure you are backing your schedule up religiously and run PFXW.exe on the file on a regular basis. You dont want a file corruption to ruin your day - been there, done that.

    You might want to look at running an upgraded Pervasive database to manage that large a file. P3 on Btrieve 6 is very sensitive to network hiccups, so don’t try to run it over a WAN.

    Ian

    http://www.emerald-associates.com
  8. 0
    Alexandre Faulx-Briole ·
    Ian,
    ouf! I have always believed that P3 was able to accommodate huge files, much higher than 30000 activities, and I could not understand why Robin was asking the question this way.
    Thanks for your info
    Alexandre
  9. 0
    Shah. HB ·
    You can convert P3 to P6 ,work on P6 then convert the same to P3 but it is time consuming
  10. 0
    Robin Reyes ·
    Yes, There is no limitation in the number of activities for P3. The only thing that I am asking is how to remove the warning that the number of rows exceeded the maximum limit of 32,000 rows when I want to filter all activities. Because in the generation of Baseline, we wanted to filter all activities and make a printout.

    Nevertheless, it is still calculating properly, though we cannot make a print-out of all activities for the purpose of official submission. What we did is we just filter the activities part by part to make printout.

    I am still hoping that a better solution will come-out.
    Merci.
  11. 0
    David Kelly ·
    The tabular reports have no limit, unlike layouts - so you can report all actvities there.

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?