Hi Team,
We are trying to open dataype from designer studio and we are getting"Insufficient privileges"
DatabaseException caused by prior exception: java.sql.SQLTimeoutException: ORA-01013: user requested cancel of current operation
@NaveenS0683 Hi Naveen, did you get a solution for this please ? I am also facing the same issue in my application now . Please respond for any solution or pointers.
@GAURAVTYAGI this post is a year old, so it may be worth you logging a new forum question, clearly detailing your Pega version and your configuration.
The ORA-01031 42000 ORA-01031: insufficient privileges issue is just that, a permissions issue.
This oracle error has been known to occur after upgrades where users try to configure local data storage and add records to newly created data types when the data type is pointing to pr_other table. (not recommended)
The error “ORA-01013: user requested cancel of current operation” is an “information” error from Oracle indicating that the current operation has been cancelled. This error will be generated if the user cancels the current operation or in response to other errors such as timeouts.
Please check the following
Is this an upgrade? When did this data type last work correctly?
Verify alert log to nail down the queries causing the issue.
Involve your DBA to verify all the indexes are proper if not rebuild the same (perform gather stats).
Whether your entire application is slow or only for some use case?
If your DB is oracle, Involve your DBA to verify the AWR report which will give the list of queries causing the issue and take necessary tuning mechanism.
FYI, refer below link for similar issue reported.
It would help if you could provide clear details of other errors you see in your log.
@MarijeSchillern Not sure how, but the restarts of the servers fixed the issue.
