Tablespace Error

Today, we had trouble with a SQL Server installation of PeopleSoft asking for a tablspace.  We created a new record, and when we saved it, it asked for a tablespace name.  The problem was that we had no tablespaces setup in PeopleSoft.  Therefore, we couldn’t pick a tablespace and essentially couldn’t save a new record.

What was more frustrating was the fact the SQL Server does not have tablespaces.  On a SQL Server system the tablespace settings are completely ignored.  It should not show the tablespace dialog.

The solution was to turn off platform compatibility mode.  The compatibility mode allows you to create records that could be migrated to a database such as Oracle.  With this option turned on, it will ask you for the tablespace so that it will have it when it gets on the Oracle database.  You can turn it on or off in the PeopleTools Options page (PeopleTools > Utilities > Administration > PeopleTools Options).

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: