This describes upgrading an existing Contenta S1000D database from Contenta S1000D 5.3, 5.4, 5.5, 5.6, 5.7, or 5.8 to Contenta S1000D 5.9. There is no database upgrade program for Contenta S1000D 5.11. Perform this task on an Contenta Explorer Administration client that has been upgraded to Contenta S1000D 5.11.
Before you begin
Before upgrading databases to
Contenta S1000D 5.9, you must upgrade the following servers and clients to
Contenta S1000D 5.11.
- Contenta application server
- Contenta Web server
- Contenta Explorer clients
In addition, if you haven't already done so, upgrade the
Contenta database to
Contenta 5.6 by running the upgrade_56 program. See the
Contenta installation documentation for more information.
CAUTION:
The delivered CSDB contains a configuration named
S1000D; do not delete or rename this configuration;
Contenta S1000D requires a configuration with that name.
Important: The Contenta database must be upgraded to version 5.6. There are no Contenta 5.7 or later database upgrades.
Note: An Contenta Explorer Administration client workstation is a workstation that was installed using the Custom option and has administrative programs in the Contenta_home/bin directory.
Restriction: Your databases must be at Contenta S1000D version 5.3 or later before you can upgrade them to version 5.11 as noted above. To verify this, in Contenta Explorer, select and navigate to . The ContentaS1000D keyword should be CaS_5.3 or later.
When adding new templates to an existing database, the upgrade script creates a new container under and copies the new version of the templates into the new container. The templates in the default container are not modified or replaced.
- If you have customized your templates, you must edit the new templates to include the customizations.
- To use the new templates as the default, remove the current templates in the default container and copy the new ones into that container.
Procedure
- If your site uses Microsoft SQL Server, set the MSSQL_HOME system environment variable on the client machine to the full path to the MS SQL Server installation, such as C:\Program Files\Microsoft SQL Server\Client SDK\ODBC4.
Important: This environment variable is used to resolve SQLCMD.EXE pathing and must be set before running the database maintenance scripts on the client machine.
- On a Contenta Explorer Administration client workstation, from a command prompt, navigate to the Contenta_home/bin/Upgrade_S1000D directory, and enter the following command, with the appropriate switches for your database:
- For an Oracle database:
upgrade_S1000D_59.pl -n node -user user -pw password -dbase <dbase|dbase@sid> -s socket-sid OracleSID [-dbpw dbase_password] [-help]
where:
- node is the name of the Contenta server.
- user is sysadmin.
- password is the Contenta sysadmin password.
- dbase@sid is the name of the database and Oracle SID to be upgraded.
Note: Include the
@sid only when the database you are upgrading is not in the default Oracle SID. To determine the default SID, in the Windows Registry, navigate to:
HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\XyEnterprise\Content@\5.0. The default SID is the value of the
XYE_PDM_DATABASE_SID key.
If upgrading a database in the default SID, use: -dbase db_name -sid OracleSID
If upgrading a database in a different SID, use: -dbase db_name@sid -sid OracleSID
- socket is the port number of the portal (PcmPortal).
- OracleSID is the Oracle database SID.
- dbase_password is the database password. This switch is required only when the database you are upgrading does not use the default database password (pdmuser).
- For a Microsoft SQL Server database:
upgrade_S1000D_59.pl -n node -user user -pw password -dbase dbase -s socket -dsn dsnserver -sqlsrv SQLServerNamedInstance [-dbpw dbase_password] [-help]
where:
- node is the name of the Contenta server.
- user is sysadmin.
- password is the Contenta sysadmin password.
- dbase is the name of the MS SQL Server database to be upgraded.
- socket is the port number of the portal (PcmPortal).
- dsnserver is the Windows ODBC_DSN data source name. If not specified, the default is used-as defined in the registry for XYV_PDM_ODBC_DSN.
- SQLServerNamedInstance is the SQL Server name with instance, if configured.
- dbase_password is the database password. This switch is required only when the database you are upgrading does not use the default database password (pdmuser).
- To verify that the database upgrade program completed successfully, do the following:
- View the log file, particularly the last line which indicates whether the database upgrade program completed successfully.
Note: Any errors about removing tools may be ignored; these errors may occur when trying to remove a tool that does not exist.
- In Contenta Explorer, select and navigate to . Alternatively, in Contenta Web, as the
sysadmin user, select Edit AppData and navigate to .
The ContentaS1000D keyword should be CaS_5.9.
What to do next
After upgrading your Contenta S1000D database, modify new or upgraded AppData settings as needed. See Modifying AppData settings after installing or upgrading Contenta S1000D.