We have cloned the DEV environment from the PRD database and recreated the IFS Middleware for the DEV environment. During the installation, we encountered the following error:
F:\IFS\IFSMws\IFSD\repository\server\install_fndbas.xml:309: Error when configuring PL/SQL Access Provider.
Importing report images, signatures, and logos to the database.
Although we can log into the application, we are seeing the following error in the Application Monitoring Console:
Ifs.Fnd.FndSystemException: Unexpected error while calling server method MonitorEntry/QueryFndMonitorEntry ---> Ifs.Fnd.FndServerFaultException: Unable to fetch result from database. Error is: ORA-20110: FndMonitorEntry.EXECUTEERROR: An error occured while executing the statement SELECT Plsqlap_Server_API.Ping_Result__ FROM sys.dual!
ORA-06512: at "IFSAPP.ERROR_SYS", line 140
ORA-06512: at "IFSAPP.ERROR_SYS", line 356
ORA-06512: at "IFSAPP.FND_MONITOR_ENTRY_API", line 2135
ORA-06512: at "IFSAPP.FND_MONITOR_ENTRY_API", line 2139
ORA-06512: at "IFSAPP.FND_MONITOR_ENTRY_API", line 1582
ORA-06512: at "IFSAPP.FND_MONITOR_ENTRY_API", line 1596
ORA-06512: at line 1
ORA-20110: FndMonitorEntry.EXECUTEERROR: An error occured while executing the statement SELECT Plsqlap_Server_API.Ping_Result__ FROM sys.dual!
ORA-06512: at "IFSAPP.ERROR_SYS", line 140
ORA-06512: at "IFSAPP.ERROR_SYS", line 356
ORA-06512: at "IFSAPP.FND_MONITOR_ENTRY_API", line 2135
ORA-06512: at "IFSAPP.FND_MONITOR_ENTRY_API", line 2139
ORA-06512: at "IFSAPP.FND_MONITOR_ENTRY_API", line 1582
ORA-06512: at "IFSAPP.FND_MONITOR_ENTRY_API", line 1596
ORA-06512: at line 1
at Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions)
at Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection decisions)
at Ifs.Fnd.AccessProvider.FndConnection.HandleHttpSuccessResult(HttpWebResponse result, FndManualDecisionCollection decisions, String operation, FndBodyType responseBodyType, Object responseBody)
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.Activity.FndActivityDataAdapter.Fill(FndDataRow condition, FndQueryOptions queryOptions, Int32 initialQueryChunkSize, FndQueryChunkNotifyDelegate queryChunkNotify, Object tag)
at Ifs.Fnd.Feature.FndDataFeatureBase.DoSearch(FndDataRow row, FndQueryOptions options)
at Ifs.Fnd.Feature.FndDocumentCollectionFeatureBase.DoSearch(FndDataRow row, FndQueryOptions options)
at Ifs.Fnd.Feature.FndDocumentCollectionFeatureBase.FeaturePopulate()
at Ifs.Application.ApplicationMonitoring.MonitorJobs.FeaturePopulate()
at Ifs.Fnd.FeatureContainer.FndFeatureContainer.NavigateToFeature(FndUrlAddress newUrlAddress, Boolean forceRepopulate, Boolean loadCommands, Boolean refresh)
at Ifs.Fnd.FeatureContainer.FndFeatureContainer.NavigateInternal(FndUrlAddress url, FndNavigatorEntry navigatorEntry, Boolean forceRepopulate, NavigationDirection navigationDirection, Int32 historyIndex, Boolean resolveNode)
Could someone please provide a resolution to this issue? We appreciate your support on this matter.
Thank you.
