5.1 Frequently Asked Questions in Compliance Studio
This section describes the Frequently Asked Questions (FAQs) in Compliance Studio.
You can refer to the Frequently Asked Questions, which are developed with interest to help you resolve some of the Compliance Studio Installation and Configuration issues. This intends to share problem resolution knowledge to a few of the known issues. This is not an official support document and just attempts to share problem resolution knowledge to a few known issues.
- Why does my console show an unsuccessful message during wallet creation?
You can check if you have run the following commands correctly.
For more information on wallet creation, see Setup Password Stores with Oracle Wallet.
mkstore -wrl <wallet_location> -create
//creates a wallet in the specified location.mkstore -wrl <wallet_location> -createCredential <alias-name> <database-user-name>
//creates an alias in the studio schema.mkstore -wrl <wallet_location> -createCredential <alias-name> <database-user-name>
//creates an alias in the atomic schema.mkstore -wrl <wallet_location> -createCredential <alias-name> <database-user-name>
//creates an alias in the config schema.
If your issue is still not resolved, contact My Oracle Support (MOS).
- Where can I find my created wallet?
Your wallet will be in the directory you have set as your wallet location.
If your issue is still not resolved, contact My Oracle Support (MOS).
- When should I create a Database link, and if yes, how do I do it?
Create a Database link to connect the Atomic and Config database schemas to the Studio database schema if the databases are different. You must create the link in the Studio database.
In the following example, a link has been created from the config schema to the atomic schema by running the following script:create public database link <studio database link> connect to <Config Schema> identified by password using ' (DESCRIPTION = ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST =<host name> (PORT = <port number>)) (CONNECT_DATA = (SERVICE_NAME = <service name>))) '; Config schema : <Config Schema>/password ' (DESCRIPTION = ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST =<host name> (PORT = <port number>)) (CONNECT_DATA = (SERVICE_NAME = <service name>))) ';
After running the script, run the FCDM connector and ICIJ connector jobs.
- Why does my installed studio setup not have any notebooks?
Some default notebooks are ready to use when you install Compliance Studio. If you do not see any notebooks when you log in to the application, you may not be assigned any roles.
Check the
<COMPLIANCE_STUDIO_INSTALLATION_PATH>/deployed/logs
directory to see if you have been assigned any roles, and if not, contact your administrator.If your issue is still not resolved, contact My Oracle Support (MOS).
- What can I do if the schema creation fails?
If the Atomic schema creation fails, login to the BD and ECM Atomic schemas and run the following query:
select * from fcc_orahive_datatypemapping;
The
fcc_orahive_datatypemapping
table must not have duplicate data types.If the Compliance Studio schema creation fails, login as a Studio user and run the following query:
select * from fcc_datastudio_schemaobjects
Run the following query to replace all Y values with '':
update fcc_datastudio_schemaobjects set SCHEMA_OBJ_GENERATED=''
After the schema creation is successful, the value of the
SCHEMA_OBJ_GENERATED
attribute changes to Y.You can also check for errors in the application log file in the
<COMPLIANCE_STUDIO_INSTALLATION_PATH>/deployed/logs
directory.If your issue is still not resolved, contact My Oracle Support (MOS).
- What can I do if the Import_training_model batch execution fails?
Batch execution status always displays success in case of success or failure.
You can also check for errors in the application log file in the
<COMPLIANCE_STUDIO_INSTALLATION_PATH>/deployed/logs
directory.According to the log details, you can fix the failure and rerun the same batch.
- Why is the PGX Server not starting?
The PGX server starts only after the FCDM tables are created after the FCDM connector job is run. Check if all FCDM tables are created, and start the PGX server.
You can also check for any errors in the application log file in the
<COMPLIANCE_STUDIO_INSTALLATION_PATH>/deployed/logs
directory.If your issue is still not resolved, contact My Oracle Support (MOS).
- What should I do if there is a below Error while selecting edges in manual
DecisionUI?
java.lang.IllegalStateException: Unable to create PgxSessionWrapperjava.lang.IllegalStateException: Unable to create PgxSessionWrapper at oracle.datastudio.interpreter.pgx.CombinedPgxDriver.getOrCreateSession(C ombinedPgxDriver.java:147) at oracle.pgx.graphviz.driver.PgxDriver.getGraph(PgxDriver.java:334) at oracle.pgx.graphviz.library.QueryEnhancer.createEnhancer(QueryEnhancer.j ava:223) at oracle.pgx.graphviz.library.QueryEnhancer.createEnhancer(QueryEnhancer.j ava:209) at oracle.pgx.graphviz.library.QueryEnhancer.query(QueryEnhancer.java:150) at oracle.pgx.graphviz.library.QueryEnhancer.execute(QueryEnhancer.java:136 ) at oracle.pgx.graphviz.interpreter.PgqlInterpreter.interpret(PgqlInterprete r.java:131) at oracle.datastudio.interpreter.pgx.PgxInterpreter.interpret(PgxInterprete r.java:120) at org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenIn terpreter.java:103) at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$Interpret Job.jobRun(RemoteInterpreterServer.java:632) at org.apache.zeppelin.scheduler.Job.run(Job.java:188) at org.apache.zeppelin.scheduler.FIFOScheduler$1.run(FIFOScheduler.java:140 ) at java.base/ java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) at java.base/ java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run (ScheduledThreadPoolExecutor.java:304) at java.base/ java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.jav a:1128) at java.base/ java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.ja va:628) at java.base/java.lang.Thread.run(Thread.java:834)Caused by: java.util.concurrent.ExecutionException: oracle.pgx.common.auth.AuthorizationException: PgxUser(FCCMDSADMIN) does not own session 6007f00a-8305-4576-9a56-9fa0f061586f or the session does not exist code: PGX-ERROR-CQAZPV67UM4H at java.base/ java.util.concurrent.CompletableFuture.reportGet(CompletableFuture.java: 395) at java.base/ java.util.concurrent.CompletableFuture.get(CompletableFuture.java:1999) at oracle.pgx.api.PgxFuture.get(PgxFuture.java:99) at oracle.pgx.api.ServerInstance.getSession(ServerInstance.java:670) at oracle.datastudio.interpreter.pgx.CombinedPgxDriver.getOrCreateSession(C ombinedPgxDriver.java:145) ... 17 moreCaused by: oracle.pgx.common.auth.AuthorizationException: PgxUser(FCCMDSADMIN) does not own session 6007f00a-8305-4576-9a56-9fa0f061586f or the session does not exist code: PGX-ERROR-CQAZPV67UM4H at oracle.pgx.common.marshalers.ExceptionMarshaler.toUnserializedException( ExceptionMarshaler.java:107) at oracle.pgx.common.marshalers.ExceptionMarshaler.unmarshal(ExceptionMarsh aler.java:123) at oracle.pgx.client.RemoteUtils.parseExceptionalResponse(RemoteUtils.java: 130) at oracle.pgx.client.HttpRequestExecutor.executeRequest(HttpRequestExecutor .java:198) at oracle.pgx.client.HttpRequestExecutor.get(HttpRequestExecutor.java:165) at oracle.pgx.client.RemoteControlImpl$10.request(RemoteControlImpl.java:313) at oracle.pgx.client.RemoteControlImpl$ControlRequest.request(RemoteControl Impl.java:119) at oracle.pgx.client.RemoteControlImpl$ControlRequest.request(RemoteControl Impl.java:110) at oracle.pgx.client.AbstractAsyncRequest.execute(AbstractAsyncRequest.java :47) at oracle.pgx.client.RemoteControlImpl.request(RemoteControlImpl.java:107) at oracle.pgx.client.RemoteControlImpl.getSessionInfo(RemoteControlImpl.jav a:296) at oracle.pgx.api.ServerInstance.lambda$getSessionInfoAsync$14(ServerInstan ce.java:490) at java.base/ java.util.concurrent.CompletableFuture.uniComposeStage(CompletableFuture .java:1106) at java.base/ java.util.concurrent.CompletableFuture.thenCompose(CompletableFuture.jav a:2235) at oracle.pgx.api.PgxFuture.thenCompose(PgxFuture.java:158)
You can perform the following steps as a workaround:
Export the "Manual Decision" Notebook.
Add the link parameter just below Description.
For example: "link": "manual Decision",
Truncate the table “fcc_er_paragraph_manual" in Studio Schema.
Import the modified notebook again.
- What should I do when the result set is truncated if the size goes above
'102400' bytes?
Perform the following steps:
Login to Compliance Studio.
Navigate to
interpreter zeppelin.interpreter.output.limit
.Set the value to the required size.
Restart the Studio Application.
- What should I do when the spark interpreter is not working?
- Log in to the server where Compliance Studio is installed.
- Navigate to
$SPARK_HOME
directory. If the path is not set, then navigate to the<COMPLIANCE_ STUDIO_INSTALLATION_PATH>/deployed/mmg-home/mmg-studio/interpreter- server/spark-interpreter-<version>/extralibs
directory. - Export the following environment variables:
export HADOOP_CONF_DIR=<HADOOP Configuration Directory path> export SPARK_HOME=<SPARK CLIENT DIRECTORY path> export SPARK_CONF_DIR=<spark-defaults.conf directory path> export SPARK_SUBMIT_OPTS="-Djava.security.krb5.conf=<kerberos directory path>/krb5.conf"
- Run the following commands for specific cases:
The result of the following command should be Pie value. (It ensures that the client is configured successfully.
./bin/run-example --master yarn SparkPi 10
The result of the following command is displayed as a Pie value. (It ensures that the client can successfully connect to the remote cluster.
./bin/spark-submit --class org.apache.spark.examples.SparkPi -- master yarn <SPARK_HOME/examples/jars/>/spark-examples_<Version>.jar 10
For example, in case of spark 2.11-2.4.0, the command is as follows:
./bin/spark-submit --class org.apache.spark.examples.SparkPi -- master yarn <SPARK_HOME/examples/jars/>/spark-examples_2.11- 2.4.0.jar 10
The result of the following command displays the list of databases that exist in HIVE.
./bin/spark-submit --class org.apache.spark.sql.hive.thriftserver. SparkSQLCLIDriver --master yarn -e "Show databases"
The result of the following command ensures that the client can query from the HIVE schema.
./bin/spark-submit --class org.apache.spark.sql.hive.thriftserver. SparkSQLCLIDriver --master yarn -e "select * from <hiveSchema>.<tableName> limit 10"
- How can I increase the memory of entity resolution and matching services?For more information on increasing memory of entity resolution and matching services, see Appendix - Setting Memory of Entity Resolution and Matching Services in the OFS Compliance Studio Administration and Configuration Guide.
- What should I do when a runtime error occurs while executing a paragraph in
Compliance Studio?
When Compliance Studio is just started (restart/upgrade/fresh installation), every interpreter gives a runtime error for the first time. Re-run the paragraph to get a result.
In addition, a user with admin privileges has to run a dummy notebook with a simple paragraph of all the used interpreters once.
- What should I do if I encounter an error on the login?If you log in to Compliance Studio for the first time, log out and log back in to resolve the error.
- How can I retain the logs after restarting the Compliance Studio?
- Log in to the Compliance Studio.
- Navigate to the
<COMPLIANCE_STUDIO_INSTALLATION_PATH>/bin
directory. - Open the
compliance-studio.sh
file and modify the following for service(s) as per your requirement:Search with "$LOGS_FOLDER" text for each service and add > (Greater than) special character and space before the text as specified below:
"$DEPLOY_APP_HOME"/<service name>/bin/<service name> >> "$LOGS_FOLDER"/<service name>.log
For example: batchservice, entity-resolution
function start_services() { service=$1 case $service in batchservice) export JAVA_OPTS="-Djavax.net.ssl.trustStore=$DEPLOY_APP_HOME/ mmg-home/mmg-studio/conf/<studio server> -Djavax.net.ssl.trustStorePassword=$STUDIO_SERVER_SSL_PASSWORD" sh "$DEPLOY_APP_HOME"/batchservice/bin/batchservice >> "$LOGS_FOLDER"/batchservice.log 2>&1 & unset JAVA_OPTS ;; entity-resolution) export JAVA_OPTS=<JAVA Options> export ER_LOG_PATH="$COMPLIANCE_STUDIO_INSTALLATION_PATH/ deployed" export ER_LOG_LEVEL=INFO export LD_LIBRARY_PATH="$COMPLIANCE_STUDIO_INSTALLATION_PATH/ deployed/python-packages/saneVirtualEnv/lib/python<version>/sitepackages/ jep:$COMPLIANCE_STUDIO_INSTALLATION_PATH/deployed/pythonpackages/ saneVirtualEnv/lib/":$LD_LIBRARY_PATH export PATH_ORG=$PATH export PATH=$DEPLOY_APP_HOME/python-packages/saneVirtualEnv/ bin:$PATH export TNS_ADMIN=$TNS_ADMIN_PATH export PYTHONPATH_ORG=$PYTHONPATH export PYTHONPATH="$DEPLOY_APP_HOME"/python-packages/ saneVirtualEnv/lib/python<version>/site-packages:$PYTHONPATH_ORG sh "$DEPLOY_APP_HOME"/entity-resolution/bin/entity-resolution >> "$LOGS_FOLDER"/entity-resolution.log & unset JAVA_OPTS export PATH=$PATH_ORG ;;
- For load to OpenSearch, you need to add one more > (Greater than)
special character as specified below:
sh "$DEPLOY_APP_HOME"/load-to-open-search/bin/load-to-open-search >>"$DEPLOY_APP_HOME"/logs/load-to-open-search.log &
- Restart Compliance Studio. To do this, run the following command:
./compliance-studio.sh –restart
Or
./compliance-studio.sh –r script
- What should I do if the following error message is displayed while starting
Compliance Studio services?
Java Memory error: unable to create new native thread
- Login to the Linux server as a root user where Compliance Studio is installed.
- Open the
/etc/security/limits.conf
file. - Add the following parameters in the file:
soft nofile 65536
hard nofile 65536
<linux username> soft nproc 10240
@svrtech soft memlock 500000
@svrtech hard memlock 500000
- Save the file.
- Restart the Compliance Studio.
- What should I do when unable to refresh Graph and fail due to the following
error?
Failed to load graph '<Graph name>' in PGX server: http:// <hostname>:7007 08:22:54.878 [se-nio-7059-exec-1] ERROR s.fccm.graphService.service.GraphExecutorService - Failed to refresh PGX Graph, <Graph name>, in all PGX servers
- Stop the PGX server.
- Log in to Studio schema.
- Delete the entries that are related to the graph in the tables - fcc_graph_m_config_json and fcc_pgx_m_config.
- Start the PGX server.
- Re-execute the Batch for the Graph pipeline or Refresh the Graph task. See the Managing Graph Pipeline section in the OFS Compliance Studio User Guide.
- What should I do if there is a below error in the umm-service logs?
[29-06-22 07:30:48,095 GMT AM] [INFO ] [WEB] [UMM] [NA] [GETUSERSESSION] Exception occurred while getting x-auth-token in initSession method of GetUserSession classjavax.net.ssl.SSLKeyException: Hostname verification failed: HostnameVerifier=weblogic.security.utils.SSLWLSHostnameVerifier, hostname=129.80.90.202.
Perform the steps described here.
- What should I do when upgrading the version JDK 11.0.13 to 11.0.15 using
shellscript?
To upgrade bundled JDK:
- Use the
wget
command to download jdk 11.0.15 from here. - Change the directory where mmg-studio is installed and navigate to
<COMPLIANCE_STU- DIO_INSTALLATION_PATH>/deployed/mmg-home/mmg-studio/interpreter- server/pgx-interpreter-bundledJRE-<version>
. - Run the
./update-jdk.sh [-j JDK11_HOME ] [-o OUTPUT_DIR]
script.<JDK11_HOME>
specifies the downloaded JDK11 path, and<OUTPUT_DIR>
specifies where the updated interpreter is saved. - Replace the
<COMPLIANCE_STUDIO_INSTALLATION_PATH>/deployed/mmg-home/mmg-studio/interpreter-server/pgx-interpreter-bundledJRE-<version>
directory with<OUTPUT_DIR>/pgxjava
.
- Use the
- What should I do when unable to update the SSO token to the latest value while
reinstalling the Compliance Studio?
- Log in to Studio schema.
- Edit the table NEXTGENEMF_CONFIG and change the SSO token to the proper value.
- Commit the changes.
- Restart the Compliance Studio.
- What should I do If it is a time-out issue observed in the Graph
Pipeline?
- Navigate to the
<COMPLIANCE_STUDIO_INSTALLATION_PATH>/deployed/mmg-home/mmgpipeline/pipeline/data-pipeline-service-<version>/conf/ application.properties
directory. - Change the value from 1200000 to 120000000 in the
server.jetty.connectionidle-timeout=property
file. - Navigate to the
<COMPLIANCE_STUDIO_INSTALLATION_PATH>/deployed/mmg-home/mmgpipeline/ pipeline/pipeline-service-<version>/conf/application.properties
directory. - Change the value from 1200000 to 120000000 in the
server.jetty.connectionidle-timeout= property
file.
- Navigate to the
- What should I do if there is a below error in the Graph Pipeline?
08/Aug/2022 10:21:26,761- [LoggerConnection] LoggerConnection: Trying to fetch connection for log. 08/Aug/2022 10:21:26,761- [LoggerConnection] LoggerConnection: isJNDI value retrieved is true 08/Aug/2022 10:21:26,769- [LoggerConnection] LoggerConnection: Trying to fetch connection for log. 08/Aug/2022 10:21:26,769- [LoggerConnection] LoggerConnection: isJNDI value retrieved is true 08/Aug/2022 10:21:26,760- [DatabaseLogger] ExecutionLogger: Exception while executing queries java.lang.Exception: at com.oracle.fccm.amlxe.dataPipelineService.sequencer.impl.SequencerDAOImp l.getQueries(SequencerDAOImpl.java:152) ~[classes!/:?] at com.oracle.fccm.amlxe.dataPipelineService.sequencer.impl.SequencerDAOImp l$$FastClassBySpringCGLIB$$7e36e608.invoke(<generated>) ~[classes!/:?] at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.2.5.RELEASE.jar!/:5.2.5.RELEASE] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.in vokeJoinpoint(CglibAopProxy.java:771) ~[spring-aop-5.2.5.RELEASE.jar!/ :5.2.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref lectiveMethodInvocation.java:163) ~[spring-aop-5.2.5.RELEASE.jar!/ :5.2.5.RELEASE] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.pr oceed(CglibAopProxy.java:749) ~[spring-aop-5.2.5.RELEASE.jar!/ :5.2.5.RELEASE] at org.springframework.dao.support.PersistenceExceptionTranslationIntercept or.invoke(PersistenceExceptionTranslationInterceptor.java:139) ~[springtx- 5.2.5.RELEASE.jar!/:5.2.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref lectiveMethodInvocation.java:186) ~[spring-aop-5.2.5.RELEASE.jar!/ :5.2.5.RELEASE] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.pr oceed(CglibAopProxy.java:749) ~[spring-aop-5.2.5.RELEASE.jar!/ :5.2.5.RELEASE] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedIntercepto r.intercept(CglibAopProxy.java:691) ~[spring-aop-5.2.5.RELEASE.jar!/ :5.2.5.RELEASE] at com.oracle.fccm.amlxe.dataPipelineService.sequencer.impl.SequencerDAOImp l$$EnhancerBySpringCGLIB$$c38b7c42.getQueries(<generated>) ~[classes!/ :?] at com.oracle.fccm.amlxe.dataPipelineService.impl.ExecutorDAOImpl.executePi peline(ExecutorDAOImpl.java:247) ~[classes!/:?] at com.oracle.fccm.amlxe.dataPipelineService.impl.ExecutorDAOImpl$$FastClas sBySpringCGLIB$$14f27fdb.invoke(<generated>) ~[classes!/:?] at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.2.5.RELEASE.jar!/:5.2.5.RELEASE] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.in vokeJoinpoint(CglibAopProxy.java:771) ~[spring-aop-5.2.5.RELEASE.jar!/ :5.2.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref lectiveMethodInvocation.java:163) ~[spring-aop-5.2.5.RELEASE.jar!/ :5.2.5.RELEASE] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.pr oceed(CglibAopProxy.java:749) ~[spring-aop-5.2.5.RELEASE.jar!/ :5.2.5.RELEASE] at org.springframework.dao.support.PersistenceExceptionTranslationIntercept or.invoke(PersistenceExceptionTranslationInterceptor.java:139) ~[springtx- 5.2.5.RELEASE.jar!/:5.2.5.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(Ref lectiveMethodInvocation.java:186) ~[spring-aop-5.2.5.RELEASE.jar!/ :5.2.5.RELEASE] at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.pr oceed(CglibAopProxy.java:749) ~[spring-aop-5.2.5.RELEASE.jar!/ :5.2.5.RELEASE] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedIntercepto r.intercept(CglibAopProxy.java:691) ~[spring-aop-5.2.5.RELEASE.jar!/ :5.2.5.RELEASE] at com.oracle.fccm.amlxe.dataPipelineService.impl.ExecutorDAOImpl$$Enhancer BySpringCGLIB$$3277859b.executePipeline(<generated>) ~[classes!/:?] at com.oracle.fccm.amlxe.dataPipelineService.services.ExecutorService.execu tePipeline(ExecutorService.java:154) ~[classes!/:?] at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source) ~[?:?] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:43) ~[?:1.8.0_321] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_321] at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(I nvocableHandlerMethod.java:190) ~[spring-web-5.2.5.RELEASE.jar!/ :5.2.5.RELEASE] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForR equest(InvocableHandlerMethod.java:138) ~[spring-web-5.2.5.RELEASE.jar!/ :5.2.5.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHa ndlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) ~[spring-webmvc-5.2.5.RELEASE.jar!/:5.2.5.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHand lerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:879) ~[spring-webmvc-5.2.5.RELEASE.jar!/:5.2.5.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHand lerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793) ~[spring-webmvc-5.2.5.RELEASE.jar!/:5.2.5.RELEASE] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter. handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc- 5.2.5.RELEASE.jar!/:5.2.5.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherS ervlet.java:1040) ~[spring-webmvc-5.2.5.RELEASE.jar!/:5.2.5.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherSe rvlet.java:943) ~[spring-webmvc-5.2.5.RELEASE.jar!/:5.2.5.RELEASE] at org.springframework.web.servlet.FrameworkServlet.processRequest(Framewor kServlet.java:1006) ~[spring-webmvc-5.2.5.RELEASE.jar!/:5.2.5.RELEASE] at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet .java:909) ~[spring-webmvc-5.2.5.RELEASE.jar!/:5.2.5.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:652) ~[tomcat-embed-core-9.0.37.jar!/:4.0.FR] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServle t.java:883) ~[spring-webmvc-5.2.5.RELEASE.jar!/:5.2.5.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) ~[tomcat-embed-core-9.0.37.jar!/:4.0.FR] at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:755) ~[jetty-servlet-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHan dler.java:1617) ~[jetty-servlet-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.springframework.web.filter.RequestContextFilter.doFilterInternal(Req uestContextFilter.java:100) ~[spring-web-5.2.5.RELEASE.jar!/ :5.2.5.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequ estFilter.java:119) ~[spring-web-5.2.5.RELEASE.jar!/:5.2.5.RELEASE] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHan dler.java:1604) ~[jetty-servlet-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormCo ntentFilter.java:93) ~[spring-web-5.2.5.RELEASE.jar!/:5.2.5.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequ estFilter.java:119) ~[spring-web-5.2.5.RELEASE.jar!/:5.2.5.RELEASE] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHan dler.java:1604) ~[jetty-servlet-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter .doFilterInternal(WebMvcMetricsFilter.java:109) ~[spring-boot-actuator- 2.2.6.RELEASE.jar!/:2.2.6.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequ estFilter.java:119) ~[spring-web-5.2.5.RELEASE.jar!/:5.2.5.RELEASE] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHan dler.java:1604) ~[jetty-servlet-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal( CharacterEncodingFilter.java:201) ~[spring-web-5.2.5.RELEASE.jar!/ :5.2.5.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequ estFilter.java:119) ~[spring-web-5.2.5.RELEASE.jar!/:5.2.5.RELEASE] at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHan dler.java:1604) ~[jetty-servlet-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:54 5) ~[jetty-servlet-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java :143) ~[jetty-server-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:5 90) ~[jetty-security-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.ja va:127) ~[jetty-server-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler. java:235) ~[jetty-server-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler. java:1607) ~[jetty-server-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler. java:233) ~[jetty-server-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler. java:1297) ~[jetty-server-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.j ava:188) ~[jetty-server-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:485 ) ~[jetty-servlet-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.j ava:1577) ~[jetty-server-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.j ava:186) ~[jetty-server-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.j ava:1212) ~[jetty-server-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java :141) ~[jetty-server-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.ja va:127) ~[jetty-server-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.server.Server.handle(Server.java:500) ~[jettyserver- 9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:38 3) ~[jetty-server-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:547) [jetty-server-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375) [jetty-server-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:2 70) [jetty-server-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractC onnection.java:311) [jetty-io-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103) [jetty-io-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.io.ssl.SslConnection$DecryptedEndPoint.onFillable(SslC onnection.java:543) [jetty-io-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:398 ) [jetty-io-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.io.ssl.SslConnection$2.succeeded(SslConnection.java:16 1) [jetty-io-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103) [jetty-io-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117) [jetty-io-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYou Kill.java:336) [jetty-util-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatY ouKill.java:313) [jetty-util-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhat YouKill.java:171) [jetty-util-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill .java:129) [jetty-util-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run( ReservedThreadExecutor.java:388) [jetty-util-9.4.26.v20200117.jar!/ :9.4.26.v20200117] at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.j ava:806) [jetty-util-9.4.26.v20200117.jar!/:9.4.26.v20200117] at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPo ol.java:938) [jetty-util-9.4.26.v20200117.jar!/:9.4.26.v20200117] at java.lang.Thread.run(Thread.java:750) [?:1.8.0_321] 08/Aug/2022 10:21:26,786- [LoggerConnection] LoggerConnection: Trying to fetch connection for log. 08/Aug/2022 10:21:26,786- [LoggerConnection] LoggerConnection: isJNDI value retrieved is true
Re-execute the failed graph pipeline from the scheduler service.
To execute the Graph pipeline, see the Using Scheduler Service section in the OFS Compliance Studio User Guide.
- What should I do if there is a below error while executing the ER job 2 -
./ ER_Run_Bulk_Similarity_Job.sh
inmatching-service.log
?ERROR ss.fccm.matchingservice.service.BulkQueryService - Exception occurred in bulk processingERROR ss.fccm.matchingservice.service.BulkQueryService - Exception occurred in bulk processingjava.lang.IndexOutOfBoundsException: Index 1 out of bounds for length 1 at jdk.internal.util.Preconditions.outOfBounds(Preconditions.java:64) ~[?:?] at jdk.internal.util.Preconditions.outOfBoundsCheckIndex(Preconditions.java :70) ~[?:?] at jdk.internal.util.Preconditions.checkIndex(Preconditions.java:248) ~[?:?] at java.util.Objects.checkIndex(Objects.java:372) ~[?:?] at java.util.ArrayList.get(ArrayList.java:459) ~[?:?] at com.oracle.ofss.fccm.matchingservice.service.BulkQueryService.preProcess (BulkQueryService.java:159) [classes!/:?] at com.oracle.ofss.fccm.matchingservice.controller.BulkUsingApiController2. executeAsyncBulkQueryMatch(BulkUsingApiController2.java:76) [classes!/ :?] at jdk.internal.reflect.GeneratedMethodAccessor164.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMetho dAccessorImpl.java:43) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(I nvocableHandlerMethod.java:205) [spring-w
This error is displayed only when the OpenSearch index does not have the proper data.
- Fix the data in the pre tables and cleanup the ER schema.
- Re-run the job again. To run the job, see the Perform Matching section in the OFS Compliance Studio Administration and Configuration Guide.
- What should I do if interpreter settings are changed after restarting the
Compliance Studio?To retain the interpreter settings:
- Navigate to the
<COMPLIANCE_STUDIO_INSTALLATION_PATH>/deployed/mmg-home/mmgstudio/conf
directory. - Open the
application.yml
file and change the value of overwrite-builtin to false in the interpreter parameter.Note:
While upgrading Compliance Studio, you should change the value to true. - Restart Compliance Studio.
- Navigate to the
- What should I do if ER Bulk similarity job fails due to metadata indices?To load the indices:
- Execute the following cleanup scripts:
ER_Run_Bulk_Similarity_Job.sh
ER_Create_And_Load_Data_Into_Index.sh
- Delete the indices.
- Verify that the indices are deleted completely.
- Set the F_IS_RECENTLY_CHANGED flag to Y in the fcc_idx_m_lookup, and fcc_idx_m_-matching_lookup tables.
- Execute
ER_Create_And_Load_Data_Into_Index.sh
. - Ensure all the indices are created (Generally, it should create 19).
- If all the indices are available, then execute
ER_Run_Bulk_Similarity_Job.sh
.
- Execute the following cleanup scripts:
- Unable to open UI (Ruleset details, Manual Decisioning and Merge and Split
Global Entities) in the Firefox browser?Possible reason: Compliance Studio UI does not open in the Firefox browser if self-signed certificates are used while installation.
- The UI (Ruleset details, Manual Decisioning and Merge and Split Global
Entities) takes more time to load in other browsers?Possible reason: The Compliance Studio UI screens are not cached if self-signed certificates are used and it takes time to load screen every time.
- What should I do if the workspaces are not displayed and below error is
encountered in the server.log?
12:02:16.272 [se-nio-7008-exec-2] ERROR er.network.base.exception.ExceptionHandlerAdvice - Internal server error. io.jsonwebtoken.security.SignatureException: JWT signature does not match locally computed signature. JWT validity cannot be asserted and should not be trusted.
To resolve the error:
- Generate the public and private keys. For more information, see the Generate Public and Private Keyssection.
- Replace the keys in the paths as mentioned in the see the Generate Public and Private Keyssection.
- Generate the SSO (API) token. For more information, see the Generate API Token for CS API Usersection.
- Replace token in the
config.sh
file. For more information, see the parameter “SSO_TOKEN” in Table 14 in Configure config.sh File. - Stop Compliance Studio.
- Reinstall Compliance Studio.
- Replace the value of SSO_TOKEN in the nextgenemf_config table in the studio schema.
- Start Compliance Studio.
- What should I do if a particular patch version is not applied to the CS
build?To apply the patch:
- You must manually delete the entry for that particular patch version from the FCC_COMPLIANCE_STUDIO_PATCHES table in the Studio Schema.
- How to configure a new/cloned interpreter?To configure a new/cloned interpreter:
- Create a new/clone an existing interpreter in the UI.
- Navigate to the
<COMPLIANCE_STUDIO_INSTALLATION_PATH>/deployed/mmg-home/mmgstudio/bin
directory. - Open the
startup.sh
file and add the following line before the line containing “counter=1”;nohup <path_to_interpreter_binary_file> &>> <path_to_save_the_logs>/ <log_file_name>.log &
- Save and close the file.
- Open the
shutdown.sh
file and add following line before the line containing “SL=”.I8004=`ps -eaf | grep java | grep RemoteInterpreterServer | grep 8004 | awk '{print $2}'` if [[ "" != "$I8004" ]]; then kill -9 $I8004; fi
Note:
In the above steps, the port number for the new/cloned interpreter is assumed to be 8004, the default port that comes with the installer. If a different port is used, then change the configuration accordingly. - Save and close the file.
- Navigate to the
<COMPLIANCE_STUDIO_INSTALLATION_PATH>/bin
directory. - Restart Compliance Studio using the command:
./compliance-studio.sh –restart
. - Verify if the spark-interpreter has started using the command:
netstat –nltp | grep 8004
.
- What should I do if import failed in the Graph Pipeline?
After installation, query the table FCC_M_PIPELINE_IMPORT_LOG to check the imported pipeline status. The _V_IMPORT_STATUS_ column denotes the status and should be 'SUCCESS' for all the imported pipelines.
If any pipelines have the status of 'FAILED,' perform the following steps to reimport:
- Find the entry for the failed pipeline in the FCC_M_EXTERNALSERVICE_RUN table of the _C_TABLELIST_ column.
- Remove that entry from the table. If the entry is not there, skip this step.
- Navigate to the
<COMPLIANCE_STUDIO_INSTALLATION_PATH>/deployed/mmg-home/mmgpipeline/ pipeline/data-metadata-job-<version>/bin
directory. - Run the import_metadata.sh shell script using the command:
./import_metadata.sh
. - Once the script is executed, verify the status in the FCC_M_PIPELINE_IMPORT_LOG to ensure that the status is a success.
- How do I update the BE_PORT value after reinstalling the Compliance
Studio?To update the BE_PORT value:
- Login to Compliance Studio schema.
- Open the NEXTGENEMF_CONFIG table.
- Verify the V_NAME columns (EMFSTUDIO_SERVICE_URL and
BASE_URL).If “BE_PORT” is not replaced, change V_VALUE to the required port number or set it to the default port value. i.e., 7002.
- Restart the Compliance Studio.
- What should I do if delta matches are not reflected in the sub graph
(OOB)?To reflect delta matches in the sub graph:
- Re-run the Refresh Graph task.
- Restart the PGX and then load the sub graph.