Question

Error 404 SQL Quick Report Creation

  • 31 August 2023
  • 5 replies
  • 90 views

Userlevel 2
Badge +6

Dear Community,

I am currently experiencing an error while attempting to create a new SQL Quick Report. Despite refreshing the server cache, the issue persists. I have confirmed that there are no issues with the middleware services as they are up and running smoothly.

I kindly request assistance from anyone who may have encountered a similar situation or possesses expertise in troubleshooting such issues. Your guidance and insights on resolving this matter would be greatly appreciated.

Thank you for your time and support.

more details:
 

Ifs.Fnd.FndSystemException: Explorer: An Unhandled Exception has occurred ---> Ifs.Fnd.FndSystemException: Unexpected error while calling server method ManageQuickReports/GetWarnings ---> Ifs.Fnd.FndSystemException: ifs.fnd.gateway.MissingOperationException: Operation 'getWarnings' does not exist
--- IFS Extended Server exception stack trace ---
    at ifs.fnd.gateway.client.EJBServerConnection.invoke(EJBServerConnection.java:96)
    at ifs.fnd.gateway.client.ServerCommunicator.invoke(ServerCommunicator.java:86)
    at ifs.fnd.gateway.client.StandardInvokeManager.doInvoke(StandardInvokeManager.java:41)
    at ifs.fnd.gateway.client.IfsClientGateway.doPostImpl(IfsClientGateway.java:410)
    at ifs.fnd.gateway.IfsAbstractGateway.doPost(IfsAbstractGateway.java:431)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
    at ifs.fnd.gateway.IfsAbstractGateway.service(IfsAbstractGateway.java:134)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
    at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:286)
    at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
    at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
    at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:350)
    at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:247)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3705)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3672)
    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:328)
    at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)
    at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)
    at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)
    at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2443)
    at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2291)
    at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2269)
    at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1705)
    at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1665)
    at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:272)
    at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)
    at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)
    at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)
    at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
    at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:652)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)
 ---> Ifs.Fnd.FndSystemException: The URI https://main/default/clientgateway/ManageQuickReports/GetWarnings cannot be found. Please contact your system administrator.

Error 404 - ifs.fnd.gateway.MissingOperationException: Operation 'getWarnings' does not exist
   --- End of inner exception stack trace ---

Server stack trace: 
   at Ifs.Fnd.AccessProvider.FndConnection.CallGetResponse(String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Byte[] requestHeaderBytes, Byte[] requestBodyBytes, FndApfAsyncInvoke asyncInvokeHandle, Boolean integrationGateway)
   at Ifs.Fnd.AccessProvider.FndConnection.AsyncGetResponse(String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Byte[] requestHeaderBytes, Byte[] requestBodyBytes, FndApfAsyncInvoke asyncInvokeHandle, Boolean integrationGateway)
   at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Object[]& outArgs)
   at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink replySink)

Exception rethrown at [0]: 
   at System.Runtime.Remoting.Proxies.RealProxy.EndInvokeHelper(Message reqMsg, Boolean bProxyCase)
   at System.Runtime.Remoting.Proxies.RemotingProxy.Invoke(Object NotUsed, MessageData& msgData)
   at Ifs.Fnd.AccessProvider.FndConnection.GetResponseDelegate.EndInvoke(IAsyncResult result)
   at Ifs.Fnd.AccessProvider.FndConnection.InvokeGetResponse(String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Byte[] requestHeaderBytes, Byte[] requestBodyBytes, Boolean& abandoned, Boolean forcedSync, Boolean integrationGateway)
   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync, Boolean integrationGateway)
   --- End of inner exception stack trace ---
   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync, Boolean integrationGateway)
   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(String intface, String operation, Object requestBody, Object responseBody, FndRequestContext requestContext, Boolean forcedSync, Boolean integrationGateway)
   at Ifs.Fnd.AccessProvider.Activity.FndActivityContext.Invoke(String intface, String operation, Object request, Object response)
   at Ifs.Fnd.AccessProvider.Activity.FndActivityCommand.ExecuteNonQuery(Object body)
   at Ifs.Application.QuickReporting.ServerInterface.Ifs.Application.QuickReporting.IManageQuickReports.GetWarnings(String sqlStatement)
   at Ifs.Application.QuickReporting.QuickReportDetail.Save()
   at Ifs.Fnd.Feature.FndDataFeatureBase.commandSave_Execute(Object sender, FndCommandExecuteEventArgs e)
   at Ifs.Fnd.Windows.Forms.FndCommand.OnExecute(Component component)
   at Ifs.Fnd.Windows.Forms.FndToolStripSplitButton.OnButtonClick(EventArgs e)
   at System.Windows.Forms.ToolStripSplitButton.OnMouseUp(MouseEventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
   at System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e, ToolStripItemEventType met)
   at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
   at Ifs.Fnd.Windows.Forms.FrameworkControls.FndToolStrip.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ToolStrip.WndProc(Message& m)
   at Ifs.Fnd.Windows.Forms.FrameworkControls.FndToolStrip.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
   --- End of inner exception stack trace ---


5 replies

Userlevel 7
Badge +31

Hi @XitSakunE,

Please also check whether all the deployments are in active state from IFS Middleware Server Admin Console. Since this is a 404 error, it could be that one of the deployments have failed, even though the servers are running. 

Check in both Main and Integration clusters. 

Hope this helps!

Userlevel 2
Badge +6

Hi @XitSakunE,

Please also check whether all the deployments are in active state from IFS Middleware Server Admin Console. Since this is a 404 error, it could be that one of the deployments have failed, even though the servers are running. 

Check in both Main and Integration clusters. 

Hope this helps!

Hi @Charith Epitawatta 
Thank you very much for your quick response. There are no failed deployments.

 

Userlevel 2
Badge +6

Dear Community,

An Update:

I've discovered that the same error has occurred in different environments, both hosted on the same server. I suspect this issue may be related to the server's network policies. Could someone please provide guidance on which areas to investigate in order to resolve this issue? Your assistance would be greatly appreciated.

Thank you.

Userlevel 2
Badge +6

@XitSakunE 

 

Do you have any update on this?

 

Thanks & Regards

Shitanshu

Userlevel 2
Badge +6

@shitanshu sharan 
Still no, but I've discovered an alternative method to create quick reports.

Thank you and best regards

Reply