Qlik Replicate and Oracle source endpoint: Cannot execute statement 'select value from v$parameter

[john_wang]

A Qlik Replicate full load ONLY task reports the following error/warning messages when loading data from an Oracle source database:

[METADATA_MANAGE ]E: ORA-00942: table or view does not exist [1020416]
[METADATA_MANAGE ]W: Cannot execute statement 'select value from v$parameter where name='enable_goldengate_replication''

Cause:

This issue typically arises because the Oracle account used by Qlik Replicate lacks the necessary permissions to access the v$parameter view.

Required Permission:
To resolve this, the following permission needs to be granted to the Oracle account. In below sample the account name is "FLONLYUSER":

GRANT SELECT ON V_$PARAMETER TO FLONLYUSER;

Alternative Resolution:

In some environments, DBAs may be unwilling to grant this permission. While the full load task completes successfully, the error/warning messages persist without the permission.

To resolve these messages, you can create a table under the Oracle account as follows. This example uses the "FLONLYUSER" account to connect to the Oracle source database:

CREATE TABLE FLONLYUSER.V$PARAMETER AS SELECT * FROM V$PARAMETER;

Here:

• FLONLYUSER.V$PARAMETER: The new table created under the FLONLYUSER schema.
• V$PARAMETER: The original system view.

Explanation: When a table and a system view share the same name within the same account, the table takes precedence. Thus, Qlik Replicate will query the FLONLYUSER.v$parameter table instead of the v$parameter system view, eliminating the error/warning messages.

Internal Investigation ID(s):

#00154133

Environment:

• Qlik Replicate All versions
• Oracle All versions