My Oracle Support Banner

EAP: Data Conversion AE - DCAP29368274 Step Abends While Upgrading to FSCM Image 33 on SQL Server Database (Doc ID 2590605.1)

Last updated on FEBRUARY 21, 2023

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

 

On a MS SQL database, upgrade to FSCM 9.2 Image 33 is abending during the Data Conversion Step DCAP29368274 with SQL error.


Error:

PeopleTools 8.57.09 - Application Engine
Copyright (c) 1988-2019 Oracle and/or its affiliates.
All Rights Reserved
SQL error. Function:  SQLExec
  Error Position:  0
  Return:  8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'SYS.VIEWS'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 42000) 8180
  Statement:  SELECT TOP 1  'Y' FROM SYS.VIEWS WHERE NAME = 'PS_SP_GF_PYC_NONVW'
  Original Statement:  select 'Y' from sys.views where name = 'PS_SP_GF_PYC_NONVW'
 Message Set Number: 0
 Message Number: 0
 Message Reason: SQL error. Function:  SQLExec
  Error Position:  0
  Return:  8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'SYS.VIEWS'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE 42000) 8180

  Statement:  SELECT TOP 1  'Y' FROM SYS.VIEWS WHERE NAME = 'PS_SP_GF_PYC_NONVW'
  Original Statement:  select 'Y' from sys.views where name = 'PS_SP_GF_PYC_NONVW' (0,0)
SQL error in Exec. (2,280) DCAP29368274.MAIN.GBL.default.1900-01-01.Step01.OnExecute  PCPC:679  Statement:8
 Message Set Number: 2
 Message Number: 280
 Message Reason: SQL error in Exec. (2,280)
Process XXXXX ABENDED at Step DCAP29368274.MAIN.Step01 (PeopleCode) -- RC = 8 (108,524)
 Message Set Number: 108
 Message Number: 524
 Message Reason: Process XXXXX ABENDED at Step DCAP29368274.MAIN.Step01 (PeopleCode) -- RC = 8 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

 

Steps:

1.  Upgrade to PUM Image 33 on a MS SQL database.

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.