No Tablespaces

After completing an PeopleSoft installation, I found that I had missed a step as there were no table spaces available to save a new record definition into.

You can check this in application designer using the following steps:

  • Open a record definition
  • Tools > Data Administration > Set Table Space
  • Look at the available space Name-DB Name. If you have no options (<Blank>) then no table spaces are defined.

Another way to check this is through PeopleTools > Utilities > Administration > Tablespace Utilities:

no-tablespaces-defined.png

No tablespaces! Behind the scenes, the table that needs to be populated is PSTBLSPCCAT.

The step that I had missed as part of the installation was to run the SQR, setspace.sqr.

Start sqrw.exe (found under PS_HOME\bin\sqr\<DB>\binw\). Specify the appropriate parameters and run.

running-setspace-sqr.png

Replace PS_HOME above with the appropriate location for your PeopleSoft installation.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License