Are you upgrading to a single or split schema?There is a known Oracle JDBC driver issue with synonyms that you will likely run into if you are upgrading to a split schema and there are synonyms on the pega schema tables, even if the synonyms are in another schema that has nothing to do with the upgrade.If you are upgrading to a single schema, using the schema owner to do the upgrade, you will not run into this issue.
As a user with dba privileges you can run this query to see if there are any synonyms for the pr4_base table.
select owner, object_name, status, object_type from dba_objects where object_name like 'PR4_BASE' and object_type = 'SYNONYM'
I'm curious to know how much free space is currently available. If you're very close to using all the space on your drive, I'm not sure I'd recommend performing the upgrade until you can get more (in addition to clearing some temp space that Pega is using).
That being said, some of this depends on how often you clear up certain areas. For instance, do you keep all your log files (both application server and prpc logs)? If so, you can probably archive them elsewhere if you want to keep them and then delete those from this server.
The pega temp directory could be deleted, but at least some of that is going to be re-created next the application starts.
Beyond those, I'm not sure what else you could delete that isn't necessary that would clear up a lot of space.
You need to make sure that your system must have minimum 20 GB of available space to run the upgrade process. I hope you read platform support guide.
Here are some suggestions:
If you are using Linux/Solaris, than just type the command df -h to see the available space. You can create /tmp folder in the free and available space area (or) if you are using windows machine, press windows button + R to open the run prompt and provide %tmp% to open the system tmp folder as shown in below. you can remove all the content in the tmp folder to get a free space.
If you are going to upgrade from PRPC 6.1 SP2 to Pega 7.1.7, please be aware that there are additional scripts that need to be run when you upgrade to Pega 7.x from a version prior to PRPC 6.2. These scripts can be found in the media under the \ResourceKit\AdditionalUpgradeScripts directory. The ResourceKitREADME.txt file in the \ResourceKit directory provides instructions regarding this.
I suggest you do not run any upgrade scripts by manual. You can just uncheck the "Bypass Automatic DDL Application" in the wizard. It's automatically applies all the scripts to your schema without any manual intervention.
I also recommend to check the two below options.
If you don't want to run this UI wizard or planning to upgrade through scripts. Than go to , 114716_Pega717\scripts and open setupDatabase.properties file and provide the following info.
pega.jdbc.driver.jar=<Path to> ojdbc7.jar
#Uncomment this property and add a list of ; delimited connections properties
#For example jdbc.custom.connection.properties=user=usr;password=pwd
#Rules schema name : Used for all databases.
#The user name is used for default schema name
# Data schema name : Used for systems running on a Split Schema
# The value of rules.schema.name is the default value for data.schema.name
#User Temp Directory. Will use default if not set to valid directory
user.temp.dir= <path > to temp directory
Note:- Since you are going with a single schema upgrade process, make sure to provide the same schema name in all the places likepega.jdbc.username=Schema Name,rules.schema.name=Schema name,data.schema.name=Schema name
Save the setupDatabase.properties file and close it. You don't need to modify anything in the setupDatabase.properties file apart form the above fields if you want to go with an automatic schema apply changes process. As I mentioned above, it's a best practice to go with an automatic approach. Just leave the work to Pega but don't run the scripts manually.
And, run the script upgrade.bat (for windows) and ./upgrade.sh (for Linux)
How are you guys planning to upgrade user interface elements...for example Sections with Old Layout formats and Inline CSS - Is there anyway we can convert these sections with old layout formats ( Free form, Smart) into PEGA 7 Dynamic Layouts programmatically?
IUA is Installation and Upgrade Assistant - this tool performs different tasks depending on the version of PRPC you are upgrading from. Follow the comprehensive Upgrade guide to make sure all of your Rules including UI rules are upgraded correctly to the latest 71 format. The guide talks about running post upgrade tools that also are necessary to ensure you are in good 71 shape.