Unable to create pr_pegafsm_data_productscatalog table
SummaryQuery to create pr_pegafsm_data_productscatalog table does not execute while installing Pega Field Service 7.22 and manually running the SQL DDL scripts.
Error at Command Line:1 Column:27
SQL Error: ORA-00972: identifier is too long
00972. 00000 - "identifier is too long"
*Cause: An identifier with more than 30 characters was specified.
*Action: Specify at most 30 characters.
Steps to ReproduceRun the SQL query to create pr_pegafsm_data_productscatalog table, which is provided as part of SQL DDL scripts of Pega Field Service 7.22 media on Oracle DB.
Root CauseInstallation of Pega Field Service application on Oracle DB is not supported.
ResolutionUse PostgreSQL DB for installation of Pega Field Service application.
Published July 28, 2017 - Updated August 8, 2017