Change Assistant gives off error

 

Issue: While upgrading PeopleTools 8.53.16 to 8.54 I receive the below error in change assistant:

 

Step failed at running Long to LOB Script 1 to 8.

 

Searching for file of longtolobalter7.sql in E:\PSOFT\CA\XXDMO\OUTPUT\SOFTWAREUPDATEPEOPLETOOLS_ONLY_UPGRADE{3A7E4C9A-4E1D-11E4-A9A7-

 

A2F2734730C4}\ using variable #DIRECTORY.

 

Searching for file of longtolobalter7.sql in E:\PSOFT\CA\XXDMO\OUTPUT\SOFTWAREUPDATEPEOPLETOOLS_ONLY_UPGRADE{3A7E4C9A-4E1D-11E4-A9A7-

 

A2F2734730C4}\ – File Not Found.

 

Searching for file of longtolobalter7.sql – Unsuccessful:File Not Found.

 

Change Assistant Failure: Unable to find script file.

 

The database is Non-Unicode.

 

 

More info on the error

 

In the PeopleTools Only Upgrade to 8.54 documentation, see section Understanding Converting Database Data Types (which says)

 

As of PeopleSoft PeopleTools 8.54, new database data types are supported for PeopleTools system databases

running Microsoft SQL Server 2005 or later and Oracle 9i or later. If you are using a PeopleSoft application database (for example, HCM, FSCM, CRM, or ELM), you should not run this conversion as part of the PeopleTools only upgrade. Do not run this task unnecessarily.

 

 

Your action should be

 

Your action should be to skip those steps, mark them as complete,  and proceed.

 

 

What is a PeopleTools system database?

 

Um, what is a PeopleTools system database?

There is the option to create a custom application that uses PeopleTools.  Those sites would license PeopleTools and utilize Tools to build their custom app.  This is called a "PeopleTools system" database.  This requires a special license.  It is a bit unusual, but there are customer sites that license PeopleTools for this purpose.

 

 

System vs Demo database

 

I confuse this with System vs Demo database?

Yes, that's a good point.  When installing a PeopleSoft environment, you choose between System and Demo.

Demo includes sample data that can be used to navigate around the environment and readily learn more about how things work.

System does not include sample data -- this would be appropriate when installing a new environment that would be taken into production.

The PeopleTools system database referred to above means the unique situation where customers have chosen to license PeopleTools and build their own custom application.

 

 

Reference

 

See PeopleSoft PeopleTools Installation Guides (specific PTools release) section

Understanding Database Creation   (which says)

When performing a PeopleSoft installation, you will create these types of PeopleSoft databases:

• System (also called SYS) databases, which contain the PeopleSoft PeopleTools and product-specific metadata

required for development of a production database.

• Demo (DMO) databases, which are populated with sample data for study, demonstration, or training purposes.

Install guides can be found on PeopleSoft PeopleTools 8.54 Installation Home Page (Doc ID 1905010.1).