(ATS4-APP01) Tips and Tricks for a Successful Installation/Upgrade of Accelrys Electronic Lab Notebook

Swati Puri McHale

Lead Technical Support Scientist, Customer Support

swati.mchale@accelrys.com

The information on the roadmap and future software development efforts are intended to outline general product direction and should not be relied on in making

a purchasing decision.

Installation/Upgrade of Accelrys ELN 6.7.x

2 Areas of Focus:

• Pre-requisites on Accelrys Vault Server Middle Tier

• Installation + Post-install Checks for Accelrys Vault Server Database and Middle

Tier

Accelrys Vault Server is hereafter referred to as AVS

Pre-requisites for AVS Middle Tier

• Microsoft C++ 2008 Redistributable Package (x86) version = 9.0.21022

• User Account Control (UAC) = “Never Notify”

Pre-requisites for AVS Middle Tier

Application Server Role Services

Pre-requisites: Role Services in Server Manager

Features > Message Queuing

Web Server Role Services

Pre-requisites: Certificate on AVS Middle Tier

Site Binding for https, Port 443

set for SSL Certificate

URL for AVS on Client machine IIS7 window

cd C:\Oracle\product\11.2.0\client_1\jdk\jre\bin\

keytool -list -v -keystore C:\AVSCertificate.pfx -storetype PKCS12

Alias name: a63a34b7-c217-434a-90f4-047eb6dd0bf0

Certificate fingerprints:

SHA1: FD:8C:BF:97:64:43:D8:71:2F:6C:A0:2A:B5:CA:BD:10:95:31:26:49

Pre-requisites: Alias Name and Thumbprint of Certificate

Pre-requisites: Information about Ports

• Important Ports on AVS Middle Tier:

– RAS (Tomcat) = 8080

– Symyx Workflow = 8081

– STS = 8443

• Primary Ports for Client-Server communication = 80 and 443

• Use the command: netstat -ab > C:\ports.txt

– Search “ports.txt” for Ports 8080, 8081 and 8443 confirm ports are not used

• Oracle Client Installation:

– Oracle 11.2.0.2 = patch 10098816 from Oracle Metalink; installed on top of Oracle Client 11.2.0.1

– Oracle 11.2.0.3 Client = zipped file from Oracle Metalink

• Oracle Client MUST be 32-bit:

Pre-requisites: Oracle Client on AVS Middle Tier

• Oracle Client MUST be installed with Administrator option:

Installation + Post-Installation Checks of NEW AVS Database

NEW installs: in order to use Direct 8.0 SP1 with Accelrys ELN 6.7.x:

– Install Direct 7.0 (files and schema), and then, install Direct 8.0 SP1

– Direct 8.0 SP1 is used for Oracle synonyms and domain indices for RAS

Reference Technical Note: T49-2012: Accelrys® Vault Server Database Installer for 6.7 SP1

Requires Accelrys Direct 7.0 and 8.0 SP1 in Order to Use Direct 8.0 SP1 on Unix

Platforms

NEW Installation: Accelrys Direct with Accelrys ELN

NEW Installation of AVS Database: Pre-Install Checks

Updated Pre-install Check scripts from Customer Support:

Check whether Direct 7.0 and/or 8.0 SP1 is installed

Checks Database character set

Reports values for Oracle Processes and Open_Cursors

NEW Installation of AVS Database: Post-Install Checks

JAVA CLASS and JAVA SOURCE in RAS = 11 Updated “check” Scripts from

Customer Support

Granted Privileges for Versioned Repository User Account ALTER SESSION CREATE INDEXTYPE CREATE JOB CREATE PROCEDURE CREATE SEQUENCE CREATE SESSION CREATE SYNONYM CREATE TABLE CREATE TRIGGER CREATE TYPE CREATE VIEW

Upgrade + Post-Upgrade Checks of UPGRADED AVS Database

UPGRADE AVS Database: Pre-Upgrade Checks: Part I

• FindCheckedOut.bat: used to find checked-out documents

• Updated Pre-upgrade Check scripts from Customer Support: checks for Direct, Database character set and values for Oracle Processes and Open_Cursors

• VaultVariables.nbx.config: name of file and sequential numbers (nb1, nb2,…)

UPGRADE AVS Database: Pre-Upgrade Checks: Part II

Database Web Service (ACD, ChemSeek) Configuration:

• Symyx Administration Console > Application Permissions > LookupService | MaterialInfoManager

• Copy information from all rows into Notepad

UPGRADE AVS Database from 6.6.1 to 6.7.x

Vault UpgradeVaultSchemas.bat

RAS SetupRas.bat

UPGRADE AVS Database from 6.4.3 or 6.5.1 or 6.6.0 to 6.7.x

STEP 1: Get RAS Security Update scripts from Customer Support

STEP 2: For Vault, run: UpgradeVaultSchemas.bat

STEP 3: For RAS, run: UpgradeRASSchemas.bat

Upgrade of AVS Database: Post-Install Checks

JAVA CLASS and JAVA SOURCE in RAS = 11 Updated “check” Scripts from

Customer Support

Granted Privileges for Versioned Repository User Account ALTER SESSION CREATE INDEXTYPE CREATE JOB CREATE PROCEDURE CREATE SEQUENCE CREATE SESSION CREATE SYNONYM CREATE TABLE CREATE TRIGGER CREATE TYPE CREATE VIEW

If you UPGRADE AVS Database from 6.6.0 to 6.7 SP1, JAVA SOURCE and JAVA CLASS = 12

Post-Installation Tasks for AVS 6.7.x Middle Tier

Post-Installation Check for AVS 6.7.x Middle Tier

Check “STS_config.xml”: entryAlias = Alias name of PFX file (obtained via keytool command):

<?xml version="1.0" encoding="utf-8"?>

<Configuration>

<Parameter name="SecurityTokenServiceURL" value="https://VM-

AVS66:8443/SecurityTokenService/sts" />

<Keystore keystoreFile="C:\Program Files (x86)\Symyx\Symyx Vault

6.7\SymyxServer\Tomcat6\conf\accelrysstskeystore.jks"

keystorePass="Accl2012"

entryAlias="a63a34b7-c217-434a-90f4-047eb6dd0bf0"

entryPassword="Accl2012" />

</Configuration>

Post-Installation Task for AVS 6.7.x Middle Tier: Publish .vozip File

• If you have used the Vault Deployment Utility from 6.7 SP2 ONLY and your workflow has

Review activities, perform the following steps:

– Get the file, “Symyx.workflow.activities.vozip”:

• Available on Download Center for Accelrys ELN 6.7 SP2 (T51-2012 – Technical Note and .vozip file for

Accelrys Electronic Lab Notebook 6.7 SP2)

– Publish “Symyx.workflow.activities.vozip” in SITE Repository

– Re-start Symyx Workflow and Symyx Vault Message Processing Services

Reference Technical Note: T51-2012: Accelrys® ELN 6.7 SP2 Requires an Additional Assembly in order for a workflow using a Review Activity to not give errors

Post-Installation Task for AVS 6.7.x Middle Tier: Database Web Service

Did you have a previous configuration

of MaterialInfoManager?

YES NO

Correct the information in the row,

“Symyx.Notebook.DiscoveryGateMaterialInfoLookup.

RefDataWebServices.DiscoveryGateWebServiceResolver

WithMolName” in the Application Permission

LookupService | MaterialInfoManager

Provide the license key for Database Web

Service in the file,

“Symyx.Notebook.DiscoveryGateMaterial

InfoLookup.

RefDataWebServices.DiscoveryGateWeb

ServiceResolverWithMolName”

IMPORTANT: Use “notebook.lic” from “\PP85CU2_NB67_win64\licensing\Licenses\”

Post-Installation Task for AVS 6.7.x Middle Tier: Configure Pipeline Pilot

Read-Only accounts for RAS and Vault Site Data Sources in Pipeline Pilot Server Administration Portal:

VAULT_SITE DB Username = vaultro (not VaultSite)

RAS DB Username = SYMYXDBUSER (not SYMYXDB)

Configure End Point for Pipeline Pilot Server

Summary

Role Services in Server Manager

Certificate

Updated pre-install checks for AVS Database and

Middle Tier

Updated post-install checks for AVS Database and Middle Tier

…and One More Thing!

• Contact Accelrys Customer Support: support@accelrys.com

• Join Accelrys Community: https://community.accelrys.com/index.jspa

• Related Tech Summit Sessions: TODAY: • (ATS4-APP02) Symyx Notebook Home Page Administration • (ATS4-APP03) Top 10 Things Every Notebook Administrator Should Know TOMORROW: • (ATS4-DEV06) Building Morphit Binders within Symyx Notebook • (ATS4-DEV07) How to Build a Custom Search Panel for Symyx Notebook • (ATS4-DEV08) Building Widgets for the Symyx Notebook Home Page • (ATS4-APP08) Managing Notebook Configurations with Accelrys Deployment Manager • (ATS4-APP09) Tips and Tricks for Managing Symyx Notebook Server Performance