E-CA: Deploy Scripts Type Step error Failure: Database Type not matched. (Doc ID 2210905.1)

Last updated on DECEMBER 05, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
Information in this document applies to any platform.

Symptoms

On : 8.54 version, PeopleSoft Update Manager

The Deploy Scripts Type Step fails when deploying a script (file) that is for an Oracle script. The target platform is SQL Server and the package is defined with SQL Server as the platform.

File: CR8_TRIGGER.sql

ERROR
------------
Retrieving file: CR8_TRIGGER.sql
Matching Target Location.
Contacting EM Hub.
Failure: Database Type not matched.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the deploy scripts step in CA

BUSINESS IMPACT
-----------------------
The issue has the following business impact: Major impact as this is stopping the update process.

Changes

The message is correct because the TARGET is running on MS SQL and the file is for ORACLE. However, it flags the step as FAILED.

Cause

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