Support Article
Unable to create pr_pegafsm_data_productscatalog table
SA-41588
Summary
Query 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 Messages
Error at Command Line:1 Column:27
Error report:
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 Reproduce
Run 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 Cause
Installation of Pega Field Service application on Oracle DB is not supported.
Resolution
Use PostgreSQL DB for installation of Pega Field Service application.
Published August 8, 2017 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.