Support Article
Cannot create index through ‘Schema tools’
SA-103886
Summary
In Pega Developer Studio, unable to create an index when using the 'Schema tools' to create it.
Error Messages
Create index failed
You are not authorized to execute the API createIndex
Steps to Reproduce
- Log in with an operator with the PRPC:DatabaseAdministrators access group.
- Navigate to Configure > System > Database > Schema tools.
- Navigate to ‘PegaDATA > Tables > table_name > Indexes.
- Expand the node.
- Click ‘Add index’.
- Fill the form.
- Click ‘Create index’.
- Click the ‘table_name’ node to view the table history.
Root Cause
Operator has multiple access groups. The default access group does not have Index creation privileges; however ,the alternate access group has this privilege. The QueueBatchActivity establishes the Authorization information from the current user context using the default access group.
Resolution
Perform the following local-change:
Change the operator's default access group to that access group which has Index creation privileges.
Published April 10, 2020 - 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.