When trying to create a report from an existing BAQ, that consists of only 1 table and a few columns, I receive the error at the bottom of the post, here’s the main error:
(Error creating or updating the report:
System.Web.Services.Protocols.SoapException: The operation you are attempting on item ‘Folder’ is not allowed for this item type. —> Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation you are attempting on item ‘Folder’ is not allowed for this item type.)
I’m just looking for where in the server settings and client settings I can look to ensure that the proper link is entered. This error looks like somewhere on the server is not pointed correctly. Where would the server link to the SSRS BAQ reports or Custom Report folder for the purposes of creating BAQ reports?
This error appeared after upgrading from 10.1.500.10 to 10.1.500.32. Creating BAQ reports wasn’t working at all in the previous version if the baq had sub-queries. I’ve been told by Epicor, and read in the patch notes that our current update resolves that. So I’m thinking that our consutlant who upgraded our software simply missed updating a link somewhere? Does this sound correct? If so, where can I look to determine if it is set up properly?
Business Layer Exception
Error creating or updating the report:
System.Web.Services.Protocols.SoapException: The operation you are attempting on item ‘Folder’ is not allowed for this item type. —> Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation you are attempting on item ‘Folder’ is not allowed for this item type. at Microsoft.ReportingServices.Library.ReportingService2010Impl.GetItemDefinition(String ItemPath, Byte[]& Definition) at Microsoft.ReportingServices.WebServer.ReportingService2010.GetItemDefinition(String ItemPath, Byte[]& Definition)
Exception caught in: Epicor.ServiceModel
Error Detail
Description: Error creating or updating the report:
System.Web.Services.Protocols.SoapException: The operation you are attempting on item ‘Folder’ is not allowed for this item type. —> Microsoft.ReportingServices.Diagnostics.Utilities.WrongItemTypeException: The operation you are attempting on item ‘Folder’ is not allowed for this item type. at Microsoft.ReportingServices.Library.ReportingService2010Impl.GetItemDefinition(String ItemPath, Byte[]& Definition) at Microsoft.ReportingServices.WebServer.ReportingService2010.GetItemDefinition(String ItemPath, Byte[]& Definition)
Program: Ice.Services.BO.DynamicReport.dll
Method: UpdateReportFields
Line Number: 81
Column Number: 17
Server Trace Stack: at Ice.Services.BO.CustomReportCreator.UpdateReportFields(String baqRptId, Func2 getReport, Action1 afterUpdateReport) in D:_Releases\ICE\3.1.500.32\Source\Server\Services\BO\DynamicReport\CustomReportCreator.cs:line 81
at Ice.Services.BO.DynamicReportSvc.CreateReportFromTemplate(String baqRptID) in D:_Releases\ICE\3.1.500.32\Source\Server\Services\BO\DynamicReport\DynamicReport.cs:line 687
at Ice.Services.BO.DynamicReportSvcFacade.CreateReportFromTemplate(String baqRptID) in D:_Releases\ICE\3.1.500.32\Source\Server\Services\BO\DynamicReport\DynamicReportSvcFacade.cs:line 122
at SyncInvokeCreateReportFromTemplate(Object , Object[] , Object[] )
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at Epicor.Hosting.OperationBoundInvoker.InnerInvoke(Object instance, Func2 func) in D:\_Releases\ICE\3.1.500.32\Source\Framework\Epicor.System\Hosting\OperationBoundInvoker.cs:line 59 at Epicor.Hosting.OperationBoundInvoker.Invoke(Object instance, Func2 func) in D:_Releases\ICE\3.1.500.32\Source\Framework\Epicor.System\Hosting\OperationBoundInvoker.cs:line 28
at Epicor.Hosting.Wcf.EpiOperationInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs) in D:_Releases\ICE\3.1.500.32\Source\Framework\Epicor.System\Hosting\Wcf\EpiOperationInvoker.cs:line 23
at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)
at System.ServiceModel.Dispatcher.ChannelHandler.DispatchAndReleasePump(RequestContext request, Boolean cleanThread, OperationContext currentOperationContext)
at System.ServiceModel.Dispatcher.ChannelHandler.HandleRequest(RequestContext request, OperationContext currentOperationContext)
at System.ServiceModel.Dispatcher.ChannelHandler.AsyncMessagePump(IAsyncResult result)
at System.ServiceModel.Dispatcher.ChannelHandler.OnAsyncReceiveComplete(IAsyncResult result)
at System.Runtime.Fx.AsyncThunk.UnhandledExceptionFrame(IAsyncResult result)
at System.Runtime.AsyncResult.Complete(Boolean completedSynchronously)
at System.ServiceModel.Channels.SecurityChannelListener1.ReceiveItemAndVerifySecurityAsyncResult2.InnerTryReceiveCompletedCallback(IAsyncResult result)
at System.Runtime.Fx.AsyncThunk.UnhandledExceptionFrame(IAsyncResult result)
at System.Runtime.AsyncResult.Complete(Boolean completedSynchronously)
at System.ServiceModel.Channels.TransportDuplexSessionChannel.TryReceiveAsyncResult.OnReceive(IAsyncResult result)
at System.Runtime.Fx.AsyncThunk.UnhandledExceptionFrame(IAsyncResult result)
at System.Runtime.AsyncResult.Complete(Boolean completedSynchronously)
at System.ServiceModel.Channels.SynchronizedMessageSource.ReceiveAsyncResult.OnReceiveComplete(Object state)
at System.ServiceModel.Channels.SessionConnectionReader.OnAsyncReadComplete(Object state)
at System.Runtime.Fx.AsyncThunk.UnhandledExceptionFrame(IAsyncResult result)
at System.Net.LazyAsyncResult.Complete(IntPtr userToken)
at System.Net.LazyAsyncResult.ProtectedInvokeCallback(Object result, IntPtr userToken)
at System.Net.Security.NegotiateStream.ProcessFrameBody(Int32 readBytes, Byte[] buffer, Int32 offset, Int32 count, AsyncProtocolRequest asyncRequest)
at System.Net.Security.NegotiateStream.ReadCallback(AsyncProtocolRequest asyncRequest)
at System.Net.AsyncProtocolRequest.CompleteRequest(Int32 result)
at System.Net.FixedSizeReader.CheckCompletionBeforeNextRead(Int32 bytes)
at System.Net.FixedSizeReader.ReadCallback(IAsyncResult transportResult)
at System.Runtime.AsyncResult.Complete(Boolean completedSynchronously)
at System.ServiceModel.Channels.ConnectionStream.IOAsyncResult.OnAsyncIOComplete(Object state)
at System.Net.Sockets.SocketAsyncEventArgs.OnCompleted(SocketAsyncEventArgs e)
at System.Net.Sockets.SocketAsyncEventArgs.FinishOperationSuccess(SocketError socketError, Int32 bytesTransferred, SocketFlags flags)
at System.Net.Sockets.SocketAsyncEventArgs.CompletionPortCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* nativeOverlapped)
at System.Threading._IOCompletionCallback.PerformIOCompletionCallback(UInt32 errorCode, UInt32 numBytes, NativeOverlapped* pOVERLAP)
Client Stack Trace
at Epicor.ServiceModel.Channels.ImplBase`1.ShouldRethrowNonRetryableException(Exception ex, DataSet[] dataSets)
at Ice.Proxy.BO.DynamicReportImpl.CreateReportFromTemplate(String baqRptID)
at Ice.Adapters.DynamicReportAdapter.CreateReportFromTemplate(String baqRptID)
at Ice.UI.App.DynamicReportDesigner.Transaction.CreateSsrsReportFromTemplate(BAQReportRow baqReportRow)