Frequently Asked Questions (FAQs)

You can refer to the Frequently Asked Questions, which are developed with interest to help you resolve some of the Compliance Studio configuration issues. This intends to share problem resolution knowledge to a few of the known issues.

What should I do if I get an invalid entry for the dataset name 'CS' after importing the notebook?
To resolve this issue, you need to execute the following command in both the Sandbox and Production workspaces.
```
EXECUTE IMMEDIATE 'DELETE FROM AIF_DATASET WHERE DATASET_NAME = ''CS'' AND DATASET_ID IN (7,2061,205417);
```
Why does my console show an unsuccessful message during wallet creation?
Please check if you have run the following commands correctly. For more information on wallet creation, see Setup Password Stores with Oracle Wallet.
1. mkstore -wrl <wallet_location> -create //creates a wallet in the specified location.
2. mkstore -wrl <wallet_location> -createCredential <alias-name> <database-user-name> //creates an alias in the Studio Schema.
3. mkstore -wrl <wallet_location> -createCredential <alias-name> <database-user-name> //creates an alias in the Atomic Schema.
4. mkstore -wrl <wallet_location> -createCredential <alias-name> <database-user-name> //creates an alias in the configuration 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 Configuration 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 Configuration 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 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. You can fix the failure according to the log details and run the same batch again.
Why is the sqoop job not successful?
The Sqoop job may fail if some of the applicable values are null or if the service name or SID value is not provided. Do one of the following:
- Check if there are any null values for the applicable configurations in the config.sh and FCC_DATASTUDIO_CONFIG tables. If there are any null values, add the required value.
- 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).
Why am I getting the following error when I run the sqoop job:
Error: Could not find or load main class com.oracle.ofss.fccm.studio.batchclient.client.BatchExecute

Set the FIC_DB_HOME path in the <COMPLIANCE_STUDIO_INSTALLATION_PATH>/deployed/ficdb directory.

You can also check for any errors in the application log file in the <COMPLIANCE_STUDIO_INSTALLATION_PATH>/deployed/logs directory.
11. Why is the PGX server is not starting even though the graph service is up and running?
Grant execution rights to the PGX folder to start the PGX server.
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 then 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).
Why is the ICIJ Connector job failing?
This can happen because of a missing csv file path in the FCC_STUDIO_ETL_FILES table. Add the CSV file path. 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 Decision UI?
java.lang.IllegalStateException: Unable to create PgxSessionWrapperjava.lang.IllegalStateException: Unable to create PgxSessionWrapper at oracle.datastudio.interpreter.pgx.CombinedPgxDriver.getOrCreateSession(CombinedPgxDriver.java:147) at oracle.pgx.graphviz.driver.PgxDriver.getGraph(PgxDriver.java:334) at oracle.pgx.graphviz.library.QueryEnhancer.createEnhancer(QueryEnhancer.java:223) at oracle.pgx.graphviz.library.QueryEnhancer.createEnhancer(QueryEnhancer.java: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(PgqlInterpreter.java:131) at oracle.datastudio.interpreter.pgx.PgxInterpreter.interpret(PgxInterpreter.java:120) at org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:103) at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.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.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java: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) oracle.datastudio.interpreter.pgx.CombinedPgxDriver.getOrCreateSession(CombinedPgxDriver.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(ExceptionMarshaler.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(RemoteControlImpl.java:119) at oracle.pgx.client.RemoteControlImpl$ControlRequest.request(RemoteControlImpl.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.java:296) at oracle.pgx.api.ServerInstance.lambda$getSessionInfoAsync$14(ServerInstance.java:490) at java.base/java.util.concurrent.CompletableFuture.uniComposeStage(CompletableFuture.java:1106) at java.base/java.util.concurrent.CompletableFuture.thenCompose(CompletableFuture.java:2235) at oracle.pgx.api.PgxFuture.thenCompose(PgxFuture.java:158)

Then, perform the below steps as a workaround -

Export the "Manual Decision" Notebook

Add the link parameter just below Description

for Ex - "link": "manualDecision",

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:
1. Login to Compliance Studio.
2. Navigate to interpreter zeppelin.interpreter.output.limit.
3. Set the value to the required size.
4. Restart the Studio Application.
What should I do if there is a below KubernetesClientException in load-to-elastic-search.log, matching-service.log files after Compliance Studio installation?
configServicePropertySourceLocator - Could not locate PropertySource: I/O error on GET request for "http://localhost:8888/<Service Name>/default": Connection refused (Connection refused); nested exception is java.net.ConnectException: Connection refused (Connection refused)onfigServicePropertySourceLocator - Could not locate PropertySource: I/O error on GET request for "http://localhost:8888/<Service Name>/default": Connection refused (Connection refused); nested exception is java.net.ConnectException: Connection refused (Connection refused)20:04:55.686 [ main] WARN .cloud.kubernetes.config.ConfigMapPropertySource - Can't read configMap with name: [<Service Name>] in namespace:[null]. Ignoring.io.fabric8.kubernetes.client.KubernetesClientException: Operation: [get] for kind: [ConfigMap] with name: [<Service Name>] in namespace: [null] failed. at io.fabric8.kubernetes.client.KubernetesClientException.launderThrowable(KubernetesClientException.java:64) ~[kubernetes-client-4.4.1.jar!/:?] at io.fabric8.kubernetes.client.KubernetesClientException.launderThrowable(KubernetesClientException.java:72) ~[kubernetes-client-4.4.1.jar!/:?] at io.fabric8.kubernetes.client.dsl.base.BaseOperation.getMandatory(BaseOperation.java:229) ~[kubernetes-client-4.4.1.jar!/:?] at io.fabric8.kubernetes.client.dsl.base.BaseOperation.get(BaseOperation.java:162) ~[kubernetes-client-4.4.1.jar!/:?] at org.springframework.cloud.kubernetes.config.ConfigMapPropertySource.getData(ConfigMapPropertySource.java:96) ~[spring-cloud-kubernetes-config-1.1.3.RELEASE.jar!/:1.1.3.

You can ignore the error when the following message is displayed at the end of the log; if you do not see this message, contact My Oracle Support (MOS) and provide the applicable error code and log:

13:52:57.698 [main] INFO org.apache.catalina.core.StandardService - Starting service [Tomcat] 13:52:57.699 [ main] INFO org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.43]
What happens if a new sandbox workspace is created?
When a new sandbox workspace is created, the folders of the older workspace are by default being copied into the new workspace. Here, folder means the Model Objectives. The Model Objectives are global objects and will be visible across the workspaces. However, the models created within those objectives will be private. This has been done purposely as you expect multiple modelers working on the common objective in their private workspaces.
Not able to access any models in the copied folders in the new workspace – the folders are being copied as empty folders?
Yes, you should not be able to access other workspace’s private models. Also, as long as other users are working on the objective and have their models in there, you will not be able to delete the objectives.
What should you do when UI pages does not load due to less network speed?
The default time to load all the modules of OJET/REDWOOD page is 1 minute. Reload the page to view the UI pages.
What are the Workspace parameters used in the application Python Scripts?
The following parameters are used:
- workspace.list_workspaces(): Used to fetch a list of all workspaces. This list is populated in the dropdown menu of datastudio.
- workspace.check_aif(): A method used to check if AIF is enabled or not
- workspace.attach_workspace(“SANDBOX123”): A method used to set workspace
- workspace.get_workspace(): Used to fetch the selected workspace (for example, SB1)
- get_mmg_studio_service_url(): Used to fetch the base URL (for example, http://whf999yyy:0000/<application name>)
- get_user(): Used to fetch current user (for example, user)
What are parameters to establish the Connection for data access?
The following section lists the connection details such as the Data Sources and so on: workspace.get_connection(): fetches connection object for the Primary Data Source of the workspace. This is equivalent to executing workspace.get_connection(1). workspace.get_connection('id'): fetches connection for the Data Source by name. For example, workspace.getconnection ('ws_data_1') – here 'ws_data_1' is one of the underlying Data Source for the workspace. workspace.get_connection(n): fetches connection for the Data Source by order. For example, workspace.getconnection(2) – this will fetch connection for the Secondary Data Source. The following section lists the workspace details: After a workspace is attached, we can list Data Sources related to that using: workspace.list_datasources(): will list Data Sources related to attached workspace with default order 1 For example, {'Data Source': [{'name': 'newdatasource1', 'order': '1'}]} workspace.list_datasources(“SB1”): will list Data Sources related to SB1 workspace with default order 1 For example, {'Data Source': [{'name': 'ds1', 'order': '1'}]} workspace.list_datasources(“SB1”, 1): will list Data Sources related to SB1 workspace with order 1 as passed in second argument For example, {'Data Source': [{'name': 'ds1', 'order': '1'}]} Note: This is applicable for Python and Python variants interpreters, and not on any other interpreters.
What should I do if the Python installation displays the following error message, " If ModuleNotFoundError: No module named '_lzma'"?
You must install xz-devel library before installing the Python. For more details, see Install MMG Python Library section.

To install, perform the following step:

$yum install -y xz-devel.
Dataset issue with the latest version of pydantic package (2.18.7)
Pydantic package (2.18.7) is incompatibile with the application functionality. So, when you reinstall the package the uninstall and reinstall pydantic package version 1.10.13.
- python3 -m pip uninstall pydantic
- python3 -m pip install pydantic==1.10.13 --user
Configuration steps for Interpreters
For JDBC

Update the below proeprty in jdbc.json under<application path>/<application path>/server/builtin/interpreters

"propertyName": "default.url"

"defaultValue": "<JDBC_URL>"

For example: jdbc:oracle:thin:@ofss-mum-1033.snbomprshared1.gbucdsint02bom.oraclevcn.com:15 21/<>application name>19PDB

"propertyName": "default.user",

"defaultValue": "<schameusername>"

For example: The schema user to which you want to connect, for example: datastudio schema name,

"propertyName": "default.password",

"defaultValue": "<schemapassword>"

For example: Password of the provided schema user.

Start the jdbc interpreter by executing below command under //<application path>/<application path>/interpreter-server/jdbc-interpreter-22.4.3/bin ./

jdbc-interpreter

If the jdbc interpreter needs to be included in the datastudio startup script remove the below entry from /<application path>/<application path>/bin/startup.sh --jdbc -1.

For Spark
Configuration with Kerberos enabled remote spark cluster:
1. Copy the configured Spark directory from hadoop cluster to <application path>/interpreter-server/spark-interpreter/extralibs. For example: spark-2.4.8-bin-hadoop2.7
2. Copy the below files to the <application path>/interpreter-server/spark-interpreter/extralibs krb5.conf <keytabfile>.keytab
3. To run Spark in yarn-client mode, configure the following parameters in this file <application path>/<application path>/server/builtin/interpreters/spark.json
  spark.master = yarn-client
  
  spark.driver.bindAddress = 0.0.0.0
  
  spark.driver.host = <host> -> Apache Spark host
  
  Note:
  When using the Kubernetes interpreter lifecycle, <host> can be the IP address or hostname of any node in your Kubernetes cluster. When using the Host interpreter lifecycle, <host> should be the IP address or hostname of the node that runs the Spark interpreter.
  
  Note:
  When connecting to a YARN cluster, the Spark driver authenticates as the UNIX user that runs the Spark interpreter. You can set the HADOOP_USER_NAME environment variable to make the Spark driver authenticate as a different user. If you use the Host interpreter lifecycle, then you can do this by exporting the HADOOP_USER_NAME environment variable before starting the Spark interpreter process. If you us the Kubernetes interpreter lifecycle, then you can do this by setting the HADOOP_USER_NAME environment variable in the resource manifest (spark.yml).
4. Update file spark-defaults.conf keytab location to the location where <keytabfile>.keytab file is copied
5. Update file spark-env.sh with the krb5.conf location to the location where krb5.conf file is copied.
  For example: Djava.security.krb5.conf=/<application path>/<application path>/interpreter-server/spark-inte rpreter-22.4.2/extralibs/krb5.conf".