Sodius extensions deployment with database errors

When you run the script to install the Sodius extensions for PTC Windchill, you may have errors in your console. Here are some tips to fix them.

Check the dabatase credentials

The extensions deployment error may be due to wrong database credentials. To fix them:

  1. Open the
    extension.properties
    file
  2. Locate
    wcadmin/wcadmin@wind
    in the file
  3. Change the first
    wcadmin
    by the user login used to create the Windchill database
  4. The second
    wcadmin
    must be replaced by the password of the login used to create the Windchill database
  5. The
    wind
    term must be replaced by the Windchill database name

Run again the deployment of the extensions, things should be better now.

Windchill SQL Database is located on a different server

When the SQL Database used by Windchill is not co-located with the Windchill application on the same server, the extensionInstall.xml Ant script cannot (easily) update that SQL server. Typically, this is because a database administration shell like Oracle’s sqlplus utility is not installed on the Windchill server.

If this applies to your deployment of Windchill, you must manually copy the SQL schema scripts from the _path to Windchill install_/Windchill/db/sql/com/sodius folder, copy these to the remote database server, and run the SQL administration utility to properly configure the dabatase. Please have your designated database administrator and your Windchill administrator perform this critical task for you

Exemple commands to run for an Oracle Database:

sqlplus _Windchill DB login_/_Windchill DB Password_@_Windchill DB Name_ @Make_pkg_adapterlink_Table.sql
sqlplus _Windchill DB login_/_Windchill DB Password_@_Windchill DB Name_ @Make_pkg_adapterlink_Index.sql

Run again the deployment of the extensions, things should be better now.