Epicor Crystal reports error in local laptop

[lalit (Lalit Garg)]

Dear All Seniors,

I have installed Epicor 10.2.100.9 version in my local laptop. I have installed in our app server also.
Recently I have taken back up of server database and restored the same in local laptop also.

In local laptop, base ssrs reports are working fine after setting the system agent again as per local wwwroot folder location in system agent but while crystal reports, I am getting following error as follows: Please help if you have any idea for viewing crystal reports properly.

No Records Selected
at Ice.Services.Lib.RunTaskSvc.InnerRunTask(Int64 ipTaskNum, Boolean suppressTransaction) in C:_Releases\ICE\ICE3.2.100.9\Source\Server\Services\Lib\RunTask\RunTask.cs:line 542
at Ice.Services.Lib.RunTaskSvcFacade.RunTask(Int64 ipTaskNum) in C:_Releases\ICE\ICE3.2.100.9\Source\Server\Services\Lib\RunTask\RunTaskSvcFacade.cs:line 138
at SyncInvokeRunTask(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 C:\_Releases\ICE\ICE3.2.100.9\Source\Framework\Epicor.System\Hosting\OperationBoundInvoker.cs:line 59 at Epicor.Hosting.OperationBoundInvoker.Invoke(Object instance, Func2 func) in C:_Releases\ICE\ICE3.2.100.9\Source\Framework\Epicor.System\Hosting\OperationBoundInvoker.cs:line 28
at Epicor.Hosting.Wcf.EpiOperationInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs) in C:_Releases\ICE\ICE3.2.100.9\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)

I have no idea on how to resolve this issue…plz suggest.

Regards,
Lalit Garg

[aidacra (Nathan your friendly neighborhood Support Engineer)]

@lalit

No Records Selected

The RDD (or BAQ) that is behind this Crystal report didn’t return any records/results with the parameters it was passed, so the client presented this message.

1. Is this a BAQ or RDD based Crystal Report? If RDD, which RDD is this using?
2. Have Crystal reports ever worked for you in E10.2?
3. Have you already reviewed the KB article Support put together that references all of the known Crystal articles in our system? Those articles go over how to implement Crystal reports in E10.x, talk about where the .rpts need to be located, which runtimes need to be used, etc: Sign In
   
   

[lalit (Lalit Garg)]

Hi,

I have got the solution now. Actually what I have done earlier is taken the back up of the live database server to the local laptop and trying to run the Epicor Help and all reports.

I face many challenges and resolved.

Challenges:
Epicor help was not working. There was error of authorization of webconfig access file. So what has happened is my server application pool and website configuration in IIS was different and local laptop setting of IIS website and app pool was different. So authentication and authorization was the issue in accessing the Epicor Help through Epicor Application itself. Then I reset the IIS app pool and website basic settings to resolve that error.

Regarding reports, there was no error at all and I was just confused on how to access the reports. When I tried to access the report on live server also, I was trying to open different PO prepared in different branch and that was the error only. When I tried to open it in right branch where the PO was made, then it opened in both live server and local laptop also. All settings were actually fine.

So now I am happy that my local laptop is also working like a live server where i can do lot of multi testing before replicating the same on live server.

Thanks All once again.

Regards,
Lalit Garg