GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — Error when running for certain schemas - "ONS in FanManager" · Issue #213 · utPLSQL/utPLSQL-cli

Error when running for certain schemas - "ONS in FanManager" #213

New issue
Copy link
New issue
Copy link
Open
Open
Error when running for certain schemas - "ONS in FanManager"#213
Copy link

Description

@clarkec21
clarkec21
opened on Dec 22, 2022
Issue body actions

Hi
I am calling utplsql-cli via GitHub Actions on a runner server on OCI as ADMIN user. I pass in multiple schemas to be processed and am writing the documentation to a file and coverage html to a file. My issue is that when I have only "ADMIN" schema I get no issues however when I use any other schema I get a SEVERE error:

utPLSQL-cli 3.1.9.local     
utPLSQL-java-api 3.1.9.local
Java-Version: 17.0.5     
ORACLE_HOME: null
NLS_LANG: null

2022-12-22 11:[32](https://github.com/nhbcuk/nhbc-database-applications/actions/runs/3757393658/jobs/6384549749#step:2:33):54 [main] DEBUG org.utplsql.cli.RunAction - Java Locale changed to en_US
2022-12-22 11:32:54 [main] INFO  org.utplsql.cli.RunAction - ########### utPLSQL cli ############

2022-12-22 11:32:54 [main] INFO  org.utplsql.cli.RunAction - 
2022-12-22 11:32:54 [main] DEBUG o.u.c.d.TestedDataSourceProvider - Try connecting jdbc:oracle:oci8:****/****@***
2022-12-22 11:32:54 [main] DEBUG o.u.c.d.TestedDataSourceProvider - Try connecting jdbc:oracle:thin:****/****@***
Dec 22, 2022 11:[33](https://github.com/nhbcuk/nhbc-database-applications/actions/runs/3757393658/jobs/6384549749#step:2:34):25 AM oracle.simplefan.impl.FanManager configure
2022-12-22 11:33:25 [main] INFO  o.u.c.d.TestedDataSourceProvider - Use connection string jdbc:oracle:thin:****/****@***
SEVERE: attempt to configure ONS in FanManager failed with oracle.ons.NoServersAvailable: Subscription time out

This is how I call utPLSQL-cli:

utplsql run $DATABASE_USER/"$DATABASE_PWD"@$DATABASE_SERVICE -p="ADMIN,APP_OWNER,COM_OWNER" -f=ut_documentation_reporter -o=${GITHUB_WORKSPACE}/utplsql_$JOBNOS.log -f=ut_coverage_html_reporter -o=${GITHUB_WORKSPACE}/coverage_$JOBNOS.html -exclude="FLOW_APEX_ENV,FLOW_APEX_SESSION,FLOW_API_PKG,FLOW_BOUNDARY_EVENTS,FLOW_BPMN_PARSER_PKG,FLOW_CALL_ACTIVITIES,FLOW_CONSTANTS_PKG,FLOW_DIAGRAM,FLOW_ENGINE,FLOW_ENGINE_APP_API,FLOW_ENGINE_UTIL,FLOW_ERRORS,FLOW_EXPRESSIONS,FLOW_GATEWAYS,FLOW_GLOBALS,FLOW_INSTANCES,FLOW_LOGGING,FLOW_MIGRATE_XML_PKG,FLOW_MODELER,FLOW_PARSER_UTIL,FLOW_PLSQL_RUNNER_PKG,FLOW_PLUGIN_MANAGE_INSTANCE,FLOW_PLUGIN_MANAGE_INSTANCE_STEP,FLOW_PLUGIN_MANAGE_INSTANCE_VARIABLES,FLOW_PROC_VARS_INT,FLOW_PROCESS_VARS,FLOW_RESERVATIONS,FLOW_SERVICES,FLOW_SUBPROCESSES,FLOW_TASKS,FLOW_THEME_API,FLOW_TIMERS_PKG,FLOW_TYPES_PKG,FLOW_USERTASK_PKG,FLOW_VIEWER,AUD_OWNER.AOP_API21_PKG,AUD_OWNER.AOP_CONVERT21_PKG,AUD_OWNER.AOP_PLSQL21_PKG,AUD_OWNER.APE_AUD_OWNER.APEX_DATE_RANGE,AUD_OWNER.APE_CRYPTO,AUD_OWNER.APE_DIAGRAM_DATA,AUD_OWNER.APE_DICTIONARY_VIEWS,AUD_OWNER.APE_DOC,AUD_OWNER.APE_INSTALL,AUD_OWNER.APE_INTERFACE,AUD_OWNER.APE_JDOC,AUD_OWNER.APE_JSON_DOC,AUD_OWNER.APE_QA,AUD_OWNER.APE_QA_API,AUD_OWNER.APE_QA_IMPORT_EXPORT,AUD_OWNER.APE_QA_PRINT,AUD_OWNER.APE_QA_RULE_BUILDER,AUD_OWNER.APE_QA_SOURCE,AUD_OWNER.APE_QA_UTILS,AUD_OWNER.APE_SEARCH_ENGINE,AUD_OWNER.APE_UPGRADE,AUD_OWNER.APE_UTILS,AUD_OWNER.APE_XLATE_PKG"

Activity

  1. jgebal commented on Jan 16, 2023

    @jgebal
    jgebal
    on Jan 16, 2023
    Member
    More actions

    I'm no sure if it is in any way related to the issue I've found on Oracle support
    You could try one of following solutions:

    • Remove ons.jar file entry in CLASSPATH definition
    • To address this issue , set the following parameter on WLS server “-Doracle.jdbc.fanEnabled=false”

    Also mentioned here.
    https://stackoverflow.com/questions/58873384/spring-boot-app-error-log-says-attempt-to-configure-ons-in-fanmanager-failed-wit

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions
      You are visitor 01402503 — GeezerVison does not store the pages you look up.
      Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.