3

I am facing some database error while saving the page. I am using SDL Tridion 2011 Sp1 version and using Oracle Database 6.1.0.996.

Unable to save Page (tcm:202-12456-64).
ORA-01013: user requested that the current operation is interrupted
ORA-06512: at "TCMDBUSER.EDA_ORG_ITEMS", line 4026
ORA-06512: at line 1

Error Code:
0x8004033F (-2147220673)

Call stack:
Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32,OracleConnection,IntPtr,OpoSqlValCtx*,Object,String,Boolean)
Oracle.DataAccess.Client.OracleException.HandleError(Int32,OracleConnection,String,IntPtr,OpoSqlValCtx*,Object,Boolean)
Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean,Boolean,CommandBehavior)
Oracle.DataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior)
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior)
Tridion.ContentManager.Data.AdoNet.DatabaseUtilities.ExecuteReader(StoredProcedureInvocation,CommandBehavior)
Tridion.ContentManager.Data.AdoNet.Oracle.OracleDatabaseUtilities.ExecuteReader(StoredProcedureInvocation,CommandBehavior)
Tridion.ContentManager.Data.AdoNet.DatabaseUtilities.ExecuteReader(StoredProcedureInvocation)
Tridion.ContentManager.Data.AdoNet.Oracle.OracleDatabaseUtilities.ExecuteReader(StoredProcedureInvocation)
Tridion.ContentManager.Data.AdoNet.ContentManagement.OrganizationalItemDataMapper.Tridion.ContentManager.Data.ContentManagement.IOrganizationalItemDataMapper.GetUniquenessConflicts(TcmUri,TcmUri,IDictionary`2)
Tridion.ContentManager.ContentManagement.RepositoryLocalObject.GetConflicts(Dictionary`2)
Tridion.ContentManager.ContentManagement.RepositoryLocalObject.AssertNoUniquenessConflicts(IDictionary`2)
Tridion.ContentManager.ContentManagement.RepositoryLocalObject.OnSaving(SaveEventArgs)
Tridion.ContentManager.ContentManagement.VersionedItem.OnSaving(SaveEventArgs)
Tridion.ContentManager.CommunicationManagement.Page.OnSaving(SaveEventArgs)
Tridion.ContentManager.IdentifiableObject.Save(SaveEventArgs)
Tridion.ContentManager.ContentManagement.VersionedItem.Save(Boolean)
Tridion.ContentManager.ContentManagement.VersionedItem.Save()
Tridion.ContentManager.BLFacade.ContentManagement.VersionedItemFacade.UpdateAndCheckIn(UserContext,String,Boolean,Boolean)
XMLState.Save
Page.Save

Any ideas on how to solve this error.

3

That is a timeout error, so you might need to do some database maintenance to improve the performance. For some help in that area, see "Maintaining an Oracle database" on LiveContent (login required). Contact Customer Support if taking those steps doesn't improve the situation.

As a short-term workaround you can try to increase the relevant database timeout values in the SDL Tridion Content Manager configuration. You should focus on solving the performance issue, though, as it will be increasingly frustrating for your users if every action takes forever to complete.

4
  • Thank you for the answer. For time being I would like to increase the time out period values. It would be great if you can show some some steps to do that.
    – Patan
    Nov 1 '13 at 9:31
  • 1. Open SDL Tridion Content Manager configuration 2. Click Timeout settings in the tree on the left. 3. Change the timeout values on the right. Nov 1 '13 at 9:59
  • 4. restart your server after saving the change Nov 1 '13 at 10:06
  • 3
    Better yet, login to the documentation and search for "timeout"...
    – Nuno Linhares
    Nov 1 '13 at 11:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.