E-UPG: Error Running System Database Script pteng.db

(Doc ID 2365533.1)

Last updated on FEBRUARY 26, 2018

Applies to:

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

Symptoms

 Error running system database script pteng.db in datamover.

- SQL Error. Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Column, parameter, or variable #7: Cannot find data type PSDATETIME.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37000) 8180

CREATE TABLE PS_AEOLTEMPTBLMGR (PROCESS_INSTANCE decimal(10) NOT NULL, RECNAME char(15) NOT NULL, CURTEMPINSTANCE smallint NOT NULL, OPRID char(30) NOT NULL, RUN_CNTL_ID char(30) NOT NULL, AE_APPLID char(12) NOT NULL, RUN_DTTM PSDATETIME NULL, AE_DISABLE_RESTART char(1) NOT NULL, AE_DEDICATED smallint NOT NULL, AE_TRUNCATED smallint NOT NULL, AE_LOCK_CNT decimal(15) NOT NULL, PT_AE_SHARED char(1) NOT NULL)
Error: Unable to process create statement for AEOLTEMPTBLMGR
SQL Spaces: 0 Tables: 6 Triggers: 0 Indexes: 5 Views: 0
Ended: Fri Feb 23 23:00:43 2018
Unsuccessful completion

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