E-MSS/AD: While Building a Record in Application Designer, It Fails With Error "Incorrect syntax near the keyword 'GOTO'"
(Doc ID 2993740.1)
Last updated on FEBRUARY 05, 2024
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.50 and laterMicrosoft Windows x64 (64-bit)
Symptoms
While having "GOTO" field in a record, record build fails in application designer for SQL Server database:
Following error is captured in application designer build logs:
SQL Error. Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'GOTO'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '20'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not
CREATE TABLE PS_SJ_CAPS_POSJOB (EMPLID varchar(11) NOT NULL, EMPL_RCD smallint NOT NULL, EMPL_CLASS varchar(3) NOT NULL, EMPL_STATUS varchar(1) NOT NULL, DEPTID varchar(10) NOT NULL, LOCATION varchar(10) NOT NULL, JOBCODE varchar(6) NOT NULL, DATA_EXISTS varchar(1) NOT NULL, FULL_PART_TIME varchar(1) NOT NULL, EFFDT PSDATE NULL, ACTION varchar(3) NOT NULL, ACTION_REASON varchar(3) NOT NULL, GOTO varchar(20) NOT NULL, ACCESS_GROUP varchar(20) NOT NULL, KEYWORD varchar(8) NOT NULL, LICENSE_PLATE_ID varchar(7) NOT NULL, WORK_SCHEDULE varchar(7) NOT NULL, UNION_CD varchar(3) NOT NULL, BENEFIT_PLAN varchar(6) NOT NULL, ACTUAL_JOBCODE varchar(6) NOT NULL, FICA_STATUS_EE...
Error: Unable to process create statement for SJ_CAPS_POSJOB"
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '20'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not
CREATE TABLE PS_SJ_CAPS_POSJOB (EMPLID varchar(11) NOT NULL, EMPL_RCD smallint NOT NULL, EMPL_CLASS varchar(3) NOT NULL, EMPL_STATUS varchar(1) NOT NULL, DEPTID varchar(10) NOT NULL, LOCATION varchar(10) NOT NULL, JOBCODE varchar(6) NOT NULL, DATA_EXISTS varchar(1) NOT NULL, FULL_PART_TIME varchar(1) NOT NULL, EFFDT PSDATE NULL, ACTION varchar(3) NOT NULL, ACTION_REASON varchar(3) NOT NULL, GOTO varchar(20) NOT NULL, ACCESS_GROUP varchar(20) NOT NULL, KEYWORD varchar(8) NOT NULL, LICENSE_PLATE_ID varchar(7) NOT NULL, WORK_SCHEDULE varchar(7) NOT NULL, UNION_CD varchar(3) NOT NULL, BENEFIT_PLAN varchar(6) NOT NULL, ACTUAL_JOBCODE varchar(6) NOT NULL, FICA_STATUS_EE...
Error: Unable to process create statement for SJ_CAPS_POSJOB"
The issue can be reproduced at will with the following steps:
1. In application designer, go to file and create a record with field name having GOTO
2. Go to Tools > Build > Build this record and run the build script.
3. Notice the error on build logs.
Changes
New field "GOTO" is added to a record.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |