SAP Knowledge Base Article - Preview

2481447 - Exception in Copy Period error during Period Roll Forward

Symptom

During a Period Roll Forward the error: "Exception in Copy Period" is displayed.

Log file shows a maintenance and Transaction error:

-------- Begin --------

ErrorID: 87acf10d-2a0e-48a4-a9fe-362ff60cb5da
Error in path: /NotificationAsync
Raw url: /NotificationAsync?currentCount=0&_=1495794448530
Message: Verletzung der PRIMARY KEY-Einschränkung "PK_Session". Ein doppelter Schlüssel kann in das Objekt "Maintenance.Session" nicht eingefügt werden. Der doppelte Schlüsselwert ist (lo02oz3oq4cte5uikowgkm5j        ).
Die Anweisung wurde beendet.
Source: .Net SqlClient Data Provider
Stack trace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
   at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
   at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
   at System.Data.Linq.ChangeDirector.StandardChangeDirector.DynamicInsert(TrackedObject item)
   at System.Data.Linq.ChangeDirector.StandardChangeDirector.Insert(TrackedObject item)
   at System.Data.Linq.ChangeProcessor.SubmitChanges(ConflictMode failureMode)
   at System.Data.Linq.DataContext.SubmitChanges(ConflictMode failureMode)
   at cundus.enterpriseReporting.Data.SqlMaintenanceRepository.cundus.enterpriseReporting.Data.IMaintenanceRepository.SaveSession(Session session)

-------- End --------

------- Begin --------
ErrorID: 3d926394-c01a-45e0-8ff1-0572cd460146
Error in path: /Settings/RollForwardPeriod
Raw url: /Settings/RollForwardPeriod
Message: Error 'Das Transaktionsprotokoll für die dmcattolicaassicurazioni-Datenbank ist voll. Die log_reuse_wait_desc-Spalte von 'sys.databases' enthält Informationen dazu, warum Protokollspeicherplatz nicht erneut verwendet werden kann.' at line [101]
Source: .Net SqlClient Data Provider
Stack trace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
   at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
   at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
   at System.Data.Linq.DataContext.ExecuteMethodCall(Object instance, MethodInfo methodInfo, Object[] parameters)
   at cundus.enterpriseReporting.Data.DataAccess.SqlServer.DB.sp_CopyPeriod(Nullable`1 periodId, String newPeriodName, Nullable`1 validFrom, Nullable`1 validTo, String user, Nullable`1 removeLocalPermissions)
   at cundus.enterpriseReporting.Data.SqlReportRepository.cundus.enterpriseReporting.Data.IReportRepository.CopyPeriod(Int32 periodId, String newName, DateTime validFrom, DateTime validTo, String user, Boolean removeLocalPermissions)
-------- End --------


Read more...

Product

SAP Disclosure Management 10.1

Keywords

Exception in Copy Period, Roll Forward, Period, PK_Session, Maintenance.Session, sys.databases, Exception in CopyPeriod() , KBA , troubleshooting , 3rd party tools config and system admin , EPM-DSM-GEN , DM core functionalities , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.