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 July 28, 2017 - Updated August 8, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.