Question

Caught exception when validating the table was empty 'pr4_base'

Hi all,

During first install of a new environment we get the following errors

BUILD FAILED
/opt/ws/share/applicaties/pega/install/115631_Pega731/scripts/setupDatabase.xml:472: The following error occurred while executing this line:
/opt/ws/share/applicaties/pega/install/115631_Pega731/scripts/setupDatabase.xml:1437: Caught exception when validating the table was empty 'pr4_base'

We checked the records within our database, but they are really empty.

Anyobody any idea whats wrong?

Kind regards,

Arjan Maus

***Edited by Moderator: Lochan to update platform capability tags***

Correct Answer
August 28, 2019 - 6:43am

We have found it.

This is a new installation of PEGA within an already created database which was empty, that idea was correct.

What was the issue is that de user with which we wanted to install did not have the correct priviliges. It could not even perform a select.

After granting the correct rights is worked.

Comments

Keep up to date on this post and subscribe to comments

August 27, 2019 - 10:11am

That table should not even there for new installation, possibly you installation failed before (i.e., pega thinks it is an upgrade but that table is empty). Suggest you truncate all db objects in your db before trying a new installation.

August 28, 2019 - 6:43am

We have found it.

This is a new installation of PEGA within an already created database which was empty, that idea was correct.

What was the issue is that de user with which we wanted to install did not have the correct priviliges. It could not even perform a select.

After granting the correct rights is worked.