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 for Me (Login required).

Search for additional results

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