KB30004: “ORA-08007: Further changes to this block by this transaction not allowed” error occurs when performing a Data Load in MicroStrategy Enterprise Manager 9.x against Oracle databases.

SYMPTOM:
While performing a Data Load in Strategy Enterprise Manager 9.x, the following error occurs:
 

 
Error executing SQL: Execute Query failed. Error type: Odbc error. Odbc operation attempted: SQLExecDirect. ORA-8007: Further changes to this block by this transaction not allowed<SQL Query>
 
CAUSE:
Oracle databases have a maximum number of locks to grant per transaction. When an operation is performed on a table row, a lock is created and linked to this specific row. If a large amount of data is involved in the Data Load operation, the number of locks for table rows can reach its limit, preventing the successful completion of the transaction performing it.
 
ACTION:
Two options are available to avoid this error:

• Increase the maximum number of locks per transaction at the database level
• Reduce the time window for the Data Load process. When less data is involved in the operation, a smaller number of locks will be necessary to complete all operations inside the Data Load transaction 

 
 
 
KB30004