Optimize for operating_ORA-14411: The DDL cannot be run concurrently with other DDLs
Hi Team,
When i am trying to expose the property i am getting below error.
and in Data Type on Records Tab
"Warning : We were unable to create columns to match the new properties added. This will cause performance problems when using this data type. Please click here to fix this."
"ORA-14411: The DDL cannot be run concurrently with other DDLs ".
How to stop running ddl's .
Regards,
Sri
Pegasystems Inc.
IN
Hi srivishnup1816,
Is there any activity going on the database side which might be conflicting with the DDL that is getting generated while you are trying to expose the property?
Also, if this property is a part of Database table rule, try resaving the rule and then check.
Pegasystems Inc.
IN
This error generally comes when a conflicting DDL already running.
Possible reason could be
1. Some other user has triggered the optimization
2. Some other user has tried to save/ delete the same property which you are trying to optimize.
We dont have any out of the box way to kill a script like that on DB. The best you can do is to wait for sometime and try again. If the issue still persists, then you might need to contact your DBA to identify the long running thread which is executing the script and KILL that particular thread using KILL CONNECTION or KILL QUERY .
Just a thought. Others can comment.
CAPGEMINI
IN
Pegasystems Inc.
IN
Hello,
Thanks for your reply. In that case, I would like to know, is it happening for each and every property that you are trying to expose. Just try creating a new property and then and there expose it and see the result.
If you experience the same issue then please check the ALERT log file once and see whether any DB specific ALERT is coming or not. See this post for detail of all the PEGA ALERT .