Question

PLSQLAP is red on Apps10

  • 1 December 2022
  • 2 replies
  • 138 views

Badge +5

We have troubleshooted this as per the docs (https://docs.ifs.com/techdocs/Foundation1/040_administration/240_integration/300_ifs_connect/100_connect_troubleshooting/default.htm#PLAP_troubleshooting) but we don’t see any issues on it. The below query 

SELECT Plsqlap_Server_API.Ping_Result__ FROM sys.dual;

takes a lot of time (10-15mins only for this query remaining day to day activities are working fine) to given the output as zero. Apart from that oracle batch queues are working fine and restarted the MainServer1 many times and ran reconfiguration as well.

When you run the below command to check the HTTP connectivity,

SELECT utl_http.request((SELECT value FROM ifsapp.PLSQLAP_ENVIRONMENT_TAB t WHERE t.name = 'CONN_STR') || '?test=true') FROM dual;

It was giving certificate error and host connection before and we have come to a point where it says “ORA-29259: end-of-input reached” which is somewhat related to the Network ACL on the database. Can I know the right Network ACL commands and how it should look like for an APP10 UPD9 environment using SSL. Please share me a screenshots (you may hide the confidential values) of the PLSQLAP_ENVIRONMENT_TAB, dba_network_acl_privileges and dba_network_acls tables of a proper SSL working environment and the command to add the necessary ACL and the permissions to them.

Your quick response is highly appreciated.


2 replies

Badge +5

We have noticed there are many garbage values in the table instead of a normal table. 

 


Can we take a backup of the table and delete it and recreate it through any method? How do we generate the Blob values for each parameter. Do any of you have an idea on how to recreate the table through any IFS mechanism?

Userlevel 3
Badge +10

You seem to be listing multiple issues in the same thread.  I will only address the first one.  The ACL and the certificate should be managed through the IFS Middleware Server Admin Console.  The link to that in case you do not know is https://YourServer:48080/index_admin.html.  This will be a login established when you created the instance.  Typically, the user id is ifs.

Once you log into the console click on Common on the left.  Then click Database.  You now have a row of buttons.  You need to click the Update DB Wallet.  Please try this in a test instance first if you have never done it before.

This should clear up the certificate issue because the client cert is in the wallet now on the database and an ACL entry for your application server should now appear in the following query.  By default you will not be able to run this as ifsapp.  You need to either grant this to ifsapp or log into the database  as sys or system.

SELECT *

  FROM dba_network_acls;

 

Reply