Version: 2020.3.4

Scripts - for manual execution

Here you can find the list of Manual DB scripts and PowerShell scripts, which needs to be executed manually.

Manual database scripts​

There are some manual database scripts which must/can be executed before/after the upgrade located under the following path:

MS SQL: %installdir%\H&S Heilig und Schubert Software AG\Pam.Storage\Tools\DBScripts\MSSQL\Custom ORACLE: %installdir%\H&S Heilig und Schubert Software AG\Pam.Storage\Tools\DBScripts\Oracle\Custom

Upgrading from 2015.4.2.X or earlier releases​

Changing MAIL_DESC and MAIL_DESC_VER field lenghts.sql
Execute this script at customers having huge MAIL archive unit. This script is changing field lengths in PAMAU_MAIL_DESC and PAMAU_MAIL_DESC_VER tables, and can take even hours. It's important that all commands are executed correctly.
Use for: MS SQL
Execute: before the upgrade

s299_00_update.sql
Changes the webdavname column to not null. If you already have 2015.4.3.X or higher release you don't need to execute the scripts above.
Use for: MS SQL
Execute: before the upgrade

Installed version 2015.3.X or higher releases​

Execute these scripts in the following order:

MAILBOX Data integrity check.sql
This script is executing sql statements as SELECT instead of UPDATE and prints output.
Use for: MS SQL
Execute: after the upgrade

MAILBOX fill CONTENTACCESSID [WITHOUT FT REQUEST].sql
Fills the missing CONTENTACCESSID in the PAMAU_MAIL_DESC archive unit.
Use for: MS SQL
Execute: after the upgrade

MAILBOX Remove Guid and defragmented from WEBDAVNAME [WITH FT REQUEST].sql
Removes the ".msg" from SUBJECT.
Use for: MS SQL
Execute: after the upgrade

MAILBOX Remove Guid and defragmented from WEBDAVNAME [WITHOUT FT REQUEST].sql
Removes the ".msg" from SUBJECT.
Use for: MS SQL
Execute: after the upgrade

Installed version 2016.6.5 or higher releases​

MAILBOX_fix_folder_ACLs_on_standard_mailboxes.sql
Use the following script to fix the permissions on folders in the standard mailboxes affected by the public folder permission synchronization (TICKET:2017020801000127)
Use for: MS SQL
Execute: after the upgrade

Installed version 2018.1.4 or higher releases​

Execute this script after the upgrade if there are some Classification images in the doclist and Server/Client version is >= 2018.1.4:

CLASSIFICATION IMAGE hide them.sql
Use for: MS SQL, ORACLE
Execute: after the upgrade

Must be executed for customers using MAIL archiving and the installed version is lower or equals 2018.4.*​

MAILBOX_Extend_EWS_ID.sql
Use this script to FIX the maximum character length allowed for an internet Message-ID (EWS_ID) field in the MAILBOX site for all tenants. Based on RFC-2822 it's 998 characters. (TICKET:2018101801000038)
Use for: MS SQL
Execute: before the upgrade

Installed version 2019.1.* or higher releases​

AddTenantAdminGroupToSites.sql
Use this script to add Tenant Admin group to ACLs used in subfolders of the GLOBAL/MY/GSR's for all tenants (TICKET:2019020801000016)
Use for: MS SQL, ORACLE
Execute: after the upgrade

Execute this for any version​

GLOBALSITE_fix_inherited_ACLs.sql
Use the following script to fix the inherited ACL ids on folders created in earlier versions.
Use for: MS SQL, ORACLE
Execute: before or after the upgrade

MYSITE_fix_inherited_ACLs.sql
Use the following script to fix the inherited ACL ids on folders created in earlier versions.
Use for: MS SQL, ORACLE
Execute: before or after the upgrade

Execute if its needed​

inPoint_Limit_WebDavNames.sql
Limits the WebDavNames on folders and documents
Use for: MS SQL
Execute: after the upgrade

MAILBOX_Update_DOCFILESIZE.sql
Use this script to set the document-size in the Mail hierarchy (filling the column 'DOCFILESIZE' in PAMAU_MAIL_DESC)

  • decide, if fulltext requests should be created or not (1=>;yes; 0=>no)
  • Enter the correct Location-Id (default is 1)
  • Enter the correct Archive-Id (default is 1)
  • in case of SQL-Server older than 2012
    • find the line starting with SELECT @eidPrefix ... and comment it out
    • set the correct eid Prefix e.g. 00000000|001|005| (include the last pipe!!!)

Use for: MS SQL
Execute: after the upgrade

Scripts for fixing the Identity increment and Identity seed in the MY_FOLDERS table​

Use the following scripts to correct the Identity increment and Identity seed in the MY_FOLDERS table:

MYSITE identity increment.sql
Sets the Identity increment to -1 and Identity seed to -1 in the MY_FOLDERS table. Run this scripts only on DMS installations. Read the HOW-TO in that script for more details.
Important: All archiving jobs in contentaccess must be stopped. Setup should be executed again after executing this script.
Use for: MS SQL
Execute: before or after the upgrade

MYSITE identity increment - reindex job.sql
Creates a MS SQL job to insert FT request for reindexing the MY site hierarchy. Run these scripts only on DMS installations. Read the HOW-TO in that script for more details.
Use for: MS SQL
Execute: before or after the upgrade

Merging 2 mailboxes​

Use the following scripts to merge 2 mailboxes in the following order:

MAILBOX merge.sql
Creates all procedures for merging 2 mailboxes. Read the HOW-TO in that script for more details.
Use for: MS SQL
Execute: before or after the upgrade

MAILBOX merge start.sql
Runs the procedures for merging 2 mailboxes. Read the HOW-TO in that script for more details.
Use for: MS SQL
Execute: before or after the upgrade

O365 support with local Exchange and remote mailboxes​

MAILBOX_Sync_REMOTE_SID.sql
Use this script ONLY when you have an O365 environment with local Exchange and remote mailboxes. The script will fill the REMOTE_SID columns in the PAM_USERREFERENCE, PAM_GROUPREF tables. Needs to be manually configured (e.g. location of contentAccess database, db scheme of the contentAccess tables). MUST be executed BEFORE the provisioning job.

This SQL script needs to be scheduled ONLY while still migrating users (from local to remote), as soon as all users are in the Remote AD Cloud, there is no need for it anymore! NOTE: it is also possible to completely skip this script and manually fill in the REMOTE_SID column (for those special cases) in the PAM_USERREFERENCE, PAM_GROUPREF tables.
Use for: MS SQL
Execute: before or after the upgrade

Notes mail archiving​

MAILBOX_Add_EXTENSION_EML.sql

  • creates the EXTENSION column in the MAIL archive unit of the MAILBOX site for all tenants
  • sets the EXTENSION column value to '.eml' in the MAIL archive unit of the MAILBOX site for all tenants
  • updates the WEBDAVNAME computed column definition in the MAIL archive unit of the MAILBOX site for all tenants

NOTE: Script execution might take longer.
Important: Use this script ONLY in environments with mail archiving from Notes.
Use for: MS SQL
Execute: before or after the upgrade
Applies to: NOTES environment

Manual PowerShell scripts​

The manual PowerShell scripts are located under the following path:
%installdir%\H&S Heilig und Schubert Software AG\Pam.Storage\Tools\PSScripts\Custom

Currently there is only one manual PowerShell script which MUST be executed after upgrading the 2020.1 or earlier releases.

001_00_UpdateLASTMODIFIEDIDandNAME.ps1
This script will do the following changes:

  • sets the user id in the following fields 'DOCCREATORID','DOCLASTMODIFIEDID', 'CONCREATORID','CONLASTMODIFIEDID', 'EXTLASTMODIFIEDID' in the archive units for all tenants (in the case the current value is null).
  • changes the user names to the new UPN format in the following fields 'DOCCREATORNAME','DOCLASTMODIFIEDNAME', 'CONCREATORNAME','CONLASTMODIFIEDNAME', 'EXTLASTMODIFIEDNAME' in the archive units for all tenants.
  • creates dummy user in the PAM_USERREFERENCE with USER_NAME=user_name@local and DELETED = 2 (deleted by admin), when the user was not found in inPoint. (report found in the log file)
  • creates fulltext index requests for the "sys..." users

NOTE: Script execution might take longer.
Use for: MS SQL ,ORACLE
Execute: after the upgrade
Applies to: 2020.1 or earlier releases

Parameters:​

List of parameters:

configFile*​

<file path>
Path to config file.

binDir*​

<path>
Path for assemblies of the inPoint server

installType*​

upgrade
Must be set to upgrade.

MsgForUserPath*​

<file path>
Log file.

forceFullUpdate*​

0, 1
If set to 1 => all archive units will be updated regardless of whether it was executed before or not