My Oracle Support Banner

Refresh Diversity Analytics process HRS_PG_DA Abends In Steps #14 And #15 (Doc ID 2437328.1)

Last updated on AUGUST 20, 2018

Applies to:

PeopleSoft Enterprise HCM Talent Acquisition Manager - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When using SQL SERVER DATABASE , Refresh Diversity Analytics Process HRS_PG_DA Abends in Step #14 and also Step #15.

 

ERROR
-----------------------
File: e:\pt85610b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 8601 - [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Incorrect syntax near 'LOW'.
[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Statement(s) could not be prepared. (SQLSTATE 37000) 8180
Failed SQL stmt: RECSTATS PS_HRS_DIV_OV_STG1 LOW


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigation:Recruiting > Administration > Refresh Diversity Analytics > Run HRS_PG_DA

Changes

 

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!


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