Symptom
When running a content refresh on the report, there is an error
Note: running it on the chapter works OK
The application server log shows:
2018-09-18 05:22:07.8966 [89] [ERROR] ==>
-------- Begin --------
ErrorID: 53306bf0-1921-4d3a-b6b4-46200bb98157
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
Disclosure Management 10.1
Product
Keywords
Sequence contains more than one element , KBA , dm , 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