When I execute “Application Monitoring” - “PL/SQL Access Provider configuration test” is returning 0 instead of 1 (SELECT Plsqlap_Server_API.Ping_Result__ FROM sys.dual) I checked connection string, ACL and SSL setup and everything seems OK and rest of IFS is working fine (except IFS Business Reporting report ordering). I started Debug log while executing Plsqlap_Server_API.Ping_Result__ and it shows timeout from AQ.Any idea what can be problem? 6^283439910^FRAMEWORK^DEBUG^Framework^Invoking operation through AQ...12^283439914^FRAMEWORK^INFORMATION^Framework^Batch_Processor_Jms_API: Dbms_AQ.Enqueue on [BATCH_PROC_QUEUE_MAIN] completed in [.02] sec10^283441415^FRAMEWORK^DEBUG^Framework^Timeout [15 sec] occured while waiting for [1125193]12^283441415^CALLSTACK^DEBUG^^__anonymous_block at line 5PLSQLAP_SERVER_API.PING_RESULT__ at line 715PLSQLAP_SERVER_API.INVOKE_RECORD_ at line 573PLSQLAP_SERVER_API.INVOKE___ at line 1975PLSQLAP_SERVER_API.INVOKE_AQ___ at line 1839PLSQLAP_SERVER_API.INVO
Hi AllWe are on IFS9.We had applied Update 17 to our test environment back in March/April. We recently refreshed Test with a backup of the Live database. Now we were hit with something I haven't seen since our earlier versions of IFS. We now have a mismatch between the Application and the database. e.g. wrong number of arguments... (yes, I should have spotted this, but furlough etc...)Obviously the middleware is at Up17 and the database as per live is Up16.Can I run the Update patch against the database only?? by checking only the option ‘Deploy database files’? Has anyone else had to do this? We used to see similar issues back when we ran executables, and often a user would be using the same executables for both Live and Test, of which were often at different patch levels.Surprisingly we have not hit this issue for years, i think because we would normally test the Update, and apply to Live fairly quickly afterwards. With Furlough etc, we have not kept up with this.Any advice would be
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.