Symptom
When performing a Server side Report Content refresh you receive the Error: Sequence contains more than one element
Individual chapter refresh works.
The log file shows an entry like the one below for every chapter in the Report:
2018-09-06 07:04:24.8917 [104] [ERROR] ==>
-------- Begin --------
ErrorID: 0254671d-478c-43a1-8756-2d05f6f2f5a0
Error in path: Unknown
Raw url: Unknown
Message: Sequence contains more than one element
Source: System.Data.Linq
Stack trace: 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.DataQuery`1.System.Linq.IQueryProvider.Execute[S](Expression expression)
at System.Linq.Queryable.SingleOrDefault[TSource](IQueryable`1 source, Expression`1 predicate)
at SAP.DM.Info.Repository.SqlInfoRepository.GetBriefingBookByChapterId(Int32 chapterId)
at Castle.Proxies.Invocations.IInfoRepository_GetBriefingBookByChapterId.InvokeMethodOnTarget()
at Castle.DynamicProxy.AbstractInvocation.Proceed()
at SAP.DM.Repository.SqlRepositoryExceptionInterceptor.Intercept(IInvocation invocation)
at Castle.DynamicProxy.AbstractInvocation.Proceed()
at Castle.Proxies.IInfoRepositoryProxy.GetBriefingBookByChapterId(Int32 chapterId)
at SAP.DM.Info.InfoManager.SAP.DM.Info.IInfoManager.GetBriefingBookXmlFromCache(Nullable`1 chapterId)
at cundus.enterpriseReporting.Services.ReportService.LoadBriefingBooks(List`1 orderedChapterparts, List`1 orderedChapterContentparts, ConcurrentDictionary`2 chapterBriefingbooks, Dictionary`2 loadedchapterBriefingbooks, String culture, BIPDatasourcesHashTable dsTable, Dictionary`2 chapterLogs, List`1 dataSources, String configValueAspose, Dictionary`2 bbResults, SAMLToken samlToken, String samlUserIdentifier, List`1 globalTagList, Dictionary`2 chapterWTableTagging)
-------- End --------
Read more...
Environment
SAP Disclosure Management 10.1
Product
Keywords
IsSelf, internal, config20, System.Data.Linq , KBA , 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.
SAP Knowledge Base Article - Preview