Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
clarkec21 opened this issue Dec 22, 2022 · 1 comment
Open

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

clarkec21 opened this issue Dec 22, 2022 · 1 comment

Comments

@clarkec21
Copy link

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"
@jgebal
Copy link
Member

jgebal commented Jan 16, 2023

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
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants