Skip to main content
Question

PL/SQL Access Provider is RED due to Certificate validation failure

  • Sep 11, 2024 11:03 AM UTC
  • 8 replies
  • 267 views

Forum|alt.badge.img+1

PL/SQL Access Provider is RED due to Certificate validation failure in app10.

Below solutions tried, still no luck

https://docs.ifs.com/techdocs/Foundation1/040_administration/240_integration/328_configure_plsqlap/default.htm

8 replies

Forum|alt.badge.img+1
  • Author
  • Do Gooder (Partner)
  • Sep 11, 2024 11:27 AM UTC
When execute "SELECT utl_http.request((SELECT value FROM TOSO_APP.PLSQLAP_ENVIRONMENT_TAB t WHERE t.name = 'CONN_STR') || '?test=true') FROM dual;” query above error generates

 


Forum|alt.badge.img+11
  • Hero (Employee)
  • Sep 11, 2024 11:37 AM UTC

If you are on Apps10 UPD7 (ish) or higher the plap cert is not used. If you are on lower UPD - update! :)

 


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Partner)
  • Sep 11, 2024 11:59 AM UTC

@hhanse : we are on APP10 UPD9. If the cert is not the issue, what can be the issue?


Forum|alt.badge.img+11
  • Hero (Employee)
  • Sep 11, 2024 12:47 PM UTC

Checked some old mails - seems the cert plap was deprecated in UPD5

If outbound connect integrations works then ignore the  “RED ” in monitoring console.

if i remember correctly the monitoring entry was not removed even if the connect architecture was changed.

 


Forum|alt.badge.img+15
  • Superhero (Employee)
  • Sep 12, 2024 12:02 AM UTC

Hi Chathura,

For reference please check the following two knowledge base articles:

KB0052718: How To Investigate on PL/SQL Red check
KB0013648: How to Troubleshoot PLSQL Access Provider
 

Best regards -- Ben


Forum|alt.badge.img+11
  • Hero (Employee)
  • Sep 12, 2024 5:38 AM UTC

I would say these KBA’s only apply on Apps10 UPD4 and earlier.
In UPD5 the connection between db and middle tier changed completely and some old plap api procedures stopped working, but was not properly removed from the code.
New way of troubleshooting PLAP might be:  https://docs.ifs.com/techdocs/24r1/030_administration/030_integration/300_ifs_connect/100_connect_troubleshooting/#batch_processor_troubleshooting
 


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Partner)
  • Sep 30, 2024 5:45 PM UTC

Hi Chathura,

For reference please check the following two knowledge base articles:

KB0052718: How To Investigate on PL/SQL Red check
KB0013648: How to Troubleshoot PLSQL Access Provider
 

Best regards -- Ben

 


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Partner)
  • Sep 30, 2024 7:18 PM UTC

Checked some old mails - seems the cert plap was deprecated in UPD5

If outbound connect integrations works then ignore the  “RED ” in monitoring console.

if i remember correctly the monitoring entry was not removed even if the connect architecture was changed.

 

But this is not red in other environments which are on higher versions as well