Search code examples
databaseopenedgeprogress-db

I'm trying to rebuild the indexes on a Progress database after a huge binary load, getting this error


Just imported 655 tables via binary load using a batch script to a newly created database on a 650gb hard drive.

Idxbuild is running with threads, the maximum number of threads is 1. (13942) TMB value is 8, TM value is 8, SG value is 48, packing factor is 100. (16141) Temporary sort file at: C:\Progress\OpenEdge\bin will use the available disk spa ce. (11443) SYSTEM ERROR: Unable to extend database within area Schema Area. (8897)

I can't find any solution to this in the documentation.

Tom Bascom -- I know you know a solution to this.

Thank You community!


Solution

  • What version of Progress?

    As Tim says, that's a very odd place for your temp files. How did that happen? My guess is that your working directory is %DLC%\bin.

    You're extending the schema area? Why? Did you forget to move all of your data, indexes and LOBs to type 2 storage?

    By eliminating all of the AREA information from the structure file you put everything in the schema area.

    You probably also did not create a structure file with multiple extents and so forth? Thus there is just the single initial extent.

    It also seems likely that you did not enable large files. Which means that once that extent hits 2GB it cannot grow.

    So the quick and easy solution is probably:

    proutil dbName -C enablelargefiles
    

    Note: this is a terrible way to set setup a database -- don't do it for a real system. But, as I understand it, you are just trying to do a one-time load of this data so that you can export it as CSV data.