E-CA UPD17013905_01_IMP_B_DMS Failing In Bootstrap Mode UPD17013905_01_IMP_B_DMS [IBM][CLI Driver][DB2] SQL0104N An unexpected token "." was found following "". (Doc ID 1678013.1)

Last updated on JULY 18, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.53 to 8.54 [Release 8.4]
Information in this document applies to any platform.

Symptoms

When applying HCM P006 to a demo environment on DB2,

the following error occurs:

Importing TL_VAL_LIST_TBL
Creating Table TL_VAL_LIST_TBL
Message Set Number: 200
Message Number: 0
Message Reason: File: E:\pt85312b-retail\peopletools\src\psbld\bldutil.cppSQL error. Stmt #: 2954 Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2] SQL0104N An unexpected token "." was found following "". Expected tokens may include: "". SQLSTATE=42601

(SQLSTATE 42601) -104
Failed SQL stmt: CREATE TABLE .PS_TL_VAL_LIST_TBL (LIST_ID CHAR(12) NOT NULL, LIST_TYPE CHAR(4) NOT NULL, DESCR CHAR(30) NOT NULL, DESCRSHORT CHAR(10) NOT NULL, TRC_SUM_CATEGORY CHAR(6) NOT NULL) IN PS (200,0)
- SQL Error. Error Position: 0 Return: 8601 - [IBM][CLI Driver][DB2] SQL0104N An unexpected token "." was found following "". Expected tokens may include: "". SQLSTATE=42601
(SQLSTATE 42601) -104
CREATE TABLE .PS_TL_VAL_LIST_TBL (LIST_ID CHAR(12) NOT NULL, LIST_TYPE CHAR(4) NOT NULL, DESCR CHAR(30) NOT NULL, DESCRSHORT CHAR(10) NOT NULL, TRC_SUM_CATEGORY CHAR(6) NOT NULL) IN PSHRDMO.TLAPP
Error: Unable to process create statement for TL_VAL_LIST_TBL
Ended: Thu May 29 10:07:24 2014
Unsuccessful completion


This can be reproduced by running the change package step UPD17013905_01_IMP_B_DMS.



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