How to Change Existing Attachment Path References - MSSQL Server

(Doc ID 907535.1)

Last updated on NOVEMBER 23, 2016

Applies to:

Primavera Contract Management - Version 13.1 and later
All Platforms
Database: Microsoft SQL Server


Goal

Change existing attachment path references, when using the Microsoft SQL Server database platform.

When attachment files are physically moved to a new location, the attachment path references in the group database(s) are still pointing to the old location. For that reason, simply updating the attachment location(s) in Administration is not sufficient. Although new attachments will most likely upload successfully, the old attachments will not be accessible in the application, until these attachment path references are updated via a database script.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms