Search docs.molo17.com

    Gluesync Knowledge Base: errors and fixes

    Search this page for the code or the first words of the message you see, in a notification, in the Control Plane or in the logs. Each row says what the error means and links to the section of a guide that explains the fix step by step.

    If your error is not here, follow Read Gluesync logs and diagnose errors, then Create a support ticket with the logs it asks for.

    IBM i (AS400) sources

    Error or symptom What it means Fix

    [SQL0443] Not authorized to object <journal> in <library>

    The Gluesync user has *USE on the journal but not *OBJEXIST, also with journals managed by MIMIX or secured by an authorization list

    Fix SQL0443 on a journal, authority checklist, authorities of the Gluesync user

    [SQL0443] Not authorized to object <receiver> in <library>

    The user lacks *USE on that journal receiver

    Fix SQL0443 on a journal

    [SQL0443] NOT AUTHORIZED TO JOURNAL

    The user lacks *USE on the journal or *EXECUTE on the library of the journal

    Fix SQL0443 on a journal

    [CPF9822] User not authorized to access file, [SQL0551] on a table

    The Gluesync user lacks *USE on a table of an entity

    Authority checklist

    Missing Journal Table Definition, SQL7905 when a table is created

    The table is not journaled, or is journaled with after images only

    Fix a table that is not journaled

    Journal checkpoint outdated, CPF7023 on DLTJRNRCV

    A journal receiver that Gluesync still needed was deleted

    Recover when a receiver was deleted

    [SQL0206] Column or global variable _RRN not found in a Validator run

    Earlier builds of the Validator selected the relative record number by name, which Db2 for i refuses

    Validator troubleshooting

    _RRN is missing from the field mapping, or a key on _RRN works on some tables only

    The technical field is off for the connection, or the object is a logical file

    Keys for tables without a primary key: FAQ

    [SQL0666] SQL query exceeds specified limit or threshold

    The IBM i query time limit stopped a Validator query

    Validator troubleshooting

    A target column is too short for text from the IBM i

    EBCDIC text takes more bytes in UTF-8 on the target

    Why IBM i text grows in UTF-8

    A snapshot is slow, or stops with Communication link failure or Connection reset

    A network device between Gluesync and the IBM i closes connections that stay idle during long reads

    Speed up snapshots

    [CPF7007] Cannot allocate member of a physical file

    Another job holds a lock on the file, for example during a reorganize. Gluesync retries

    Fix CPF7007

    One entity is hours late, or a pipeline with hundreds of entities drifts after a resync

    The entity polling interval is too high, or the shared journal reader is behind

    Entity polling too high, Shared reader behind

    Oracle

    Error or symptom What it means Fix

    ORA-12899: value too large for column

    The value is longer than the target column. Often a column sized in bytes receives multibyte characters

    Fix ORA-12899

    ORA-01652: unable to extend temp segment

    The source ran out of TEMP space while sorting a snapshot partition, usually because the logical partitioning is unbalanced

    Fix ORA-01652

    ORA-01031: insufficient privileges, ORA-00942: table or view does not exist

    The Gluesync user is missing a grant for LogMiner

    Fix a missing grant

    ORA-01291: missing logfile

    The redo or archive log that holds the saved position is no longer available

    Recover a lost SCN

    ORA-01017, ORA-12505, ORA-12514, ORA-12263, ORA-12528, ORA-01089, ORA-16331

    Connection, listener or database state errors

    Oracle LogMiner troubleshooting

    SQL Server

    Error or symptom What it means Fix

    String or binary data would be truncated (error 8152 or 2628)

    A value is longer than the target column

    Fix SQL Server truncation

    The same truncation error, although the target column is wide enough

    In some releases the staging table of a large batch declared binary and varbinary columns one byte long

    Truncation with a wide enough column

    Other errors writing to a SQL Server target

    Permissions, collation and schema of the target

    Prepare a SQL Server target

    MySQL and MariaDB

    Error or symptom What it means Fix

    The binlog format is not ROW, or the binlog was purged

    CDC needs row-based binlogs that are kept long enough

    Check and set the binlog options, troubleshooting

    The snapshot works but CDC changes never arrive

    CDC reads only the database set as Database name of the connection

    CDC bound to one database

    Validator

    Error or symptom What it means Fix

    Source stream key out of order

    The source returns rows in an order the comparison cannot use

    Validator troubleshooting

    QUERY_TIMEOUT, RUNTIME_LIMIT_REACHED

    A comparison query or the whole run took longer than its limit

    Validator troubleshooting

    A scheduled Validate job shows a red Last run

    One entity of the job failed and the next entities did not run

    Validator troubleshooting

    A data comparison job is already running, Maximum concurrent comparison jobs (5) reached

    Too many comparisons at the same time

    Validator troubleshooting

    What a counter or a status of a run means

    What the results mean

    The Validate page does not load

    The browser keeps an old version of the page

    Validate page stuck

    No comparison key provided for entity, DuplicateComparisonKey

    The table has no usable key for the comparison

    Tables without a key

    A comparison of a big table times out, or a connector is not supported

    Sizing for big tables, Supported connectors

    Thousands of Target only rows and Stopped after 10000 differences

    A WHERE condition on one side only

    Validate data with the Validator

    Snapshots and row counts

    Error or symptom What it means Fix

    The target has fewer rows than the source

    A bulk snapshot has not confirmed its first chunk yet, or the source holds the same key more than once

    Explain a low insert count, Find and fix row differences

    duplicate row(s) skipped

    In CDC with On duplicate key set to Skip, rows of one transaction that changed their keys met on the target, and Skip discarded them

    Duplicate rows skipped

    A snapshot is slow

    Page size, partitioning, bulk load and the source query plan

    Speed up snapshots, Tune replication throughput

    Pipelines, alerts and upgrades

    Error or symptom What it means Fix

    A pipeline stays In maintenance

    A maintenance schedule did not resume it, or it was put in maintenance by hand

    Pipeline left in maintenance

    Entity Configuration Changed: the entity "has been stopped", "a new resync is required"

    The keys or columns of the entity changed, so Gluesync stopped it until a resync

    Entity configuration changed

    Changes arrive, but late

    A very large transaction delays the changes behind it. Changes that wait longer than Source change retention in hours are dropped

    Delivering but late

    Informix Unable to activate session, error -83713

    The logical logs were replaced after the saved position

    Informix session

    High CPU on the Gluesync host or on the source

    Polling intervals, journal readers, connection pools, heap or host size

    Diagnose high CPU usage

    Automator: Impossible to upsert entities before database initialization

    The bulk run started before Core Hub reached the target database

    Create entities in bulk

    Automator: HTTP 500 on Import All, field functions or passwords missing after a restore, UnicodeEncodeError

    Export and restore limits

    Email alerts do not arrive, or arrive too often

    SMTP settings, recipients or the digest settings

    Email alerts troubleshooting

    Something behaves differently after an upgrade from Gluesync 2.2 to 2.3

    What changes after the upgrade to 2.3

    SQL Anywhere

    Error or symptom What it means Fix

    The SQL Anywhere client folder …​ is incomplete: missing …​

    The client folder is incomplete, not mounted or not the one the agent looks for

    Set up SAP SQL Anywhere as a source and a target

    The SQL Anywhere client was loaded from …​ and cannot be loaded from …​ in the same process: restart Core Hub to change it

    A Core Hub process loads one client folder

    Set up SAP SQL Anywhere as a source and a target

    SAP ships the SQL Anywhere client for Linux x86_64 only, and this agent runs on Linux aarch64

    Core Hub runs on another architecture or operating system

    Set up SAP SQL Anywhere as a source and a target

    SQL Anywhere transaction log cannot be read, dbtran was refused

    The user lacks BACKUP DATABASE

    Set up SAP SQL Anywhere as a source and a target

    The notification says the log was renamed or truncated past the position of the agent

    A log rename ran with commits that the agent had not read

    Set up SAP SQL Anywhere as a source and a target

    SQL Anywhere error -193 or -196 on the target

    A row with that key is already on the target

    Set up SAP SQL Anywhere as a source and a target

    Greenplum, Supabase and Elasticsearch targets

    Error or symptom What it means Fix

    ERROR: permission denied for view pg_exttable (Greenplum 7)

    The user cannot read the catalog view of external tables

    Set up a Greenplum target

    permission denied: no privilege to create a readable gpfdist(s) external table

    The user lacks the role attribute for readable gpfdist external tables

    Set up a Greenplum target

    ERROR: hostname cannot be resolved 'gpfdist://<name>:8580/…​'

    gpfdist advertised host does not resolve from a segment host

    Set up a Greenplum target

    append-only tables do not support unique indexes

    On Greenplum 6, a primary key on an append-optimized table that you create yourself

    Set up a Greenplum target

    type "hstore" does not exist

    The extension is not installed in the target database

    Set up a Greenplum target

    Failed to initialize pool: FATAL: password authentication failed for user "…​"

    Wrong password or user name, or the project reference is missing on the session pooler

    Set up a Supabase target

    Failed to initialize pool: The connection attempt failed.

    The host cannot be reached from Core Hub. The direct connection is IPv6 only without the IPv4 add-on

    Set up a Supabase target

    Failed to initialize pool: Could not open SSL root certificate file …​

    Trust server certificate is off and no trust store is set

    Set up a Supabase target

    SQL Error: Code 0, State 42501, Message ERROR: permission denied for table …​

    The role does not own the table and has no privilege on it

    Set up a Supabase target

    None of the nodes http://<host>:9200 could be reached: <host>: Name or service not known

    The host name does not resolve from Core Hub

    Set up an Elasticsearch or OpenSearch target

    None of the nodes https://<host>:9200 could be reached: Unsupported or unrecognized SSL message

    Enable TLS is on, but the cluster answers in plain HTTP

    Set up an Elasticsearch or OpenSearch target

    GET / failed with HTTP 401 (security_exception): unable to authenticate user [<user>] for REST request [/]

    The user name or the password is wrong

    Set up an Elasticsearch or OpenSearch target

    GET /_cat/indices failed with HTTP 403 (security_exception): action [indices:monitor/stats] is unauthorized

    The role has no monitor index privilege

    Set up an Elasticsearch or OpenSearch target

    PUT /shop-orders failed with HTTP 403 (security_exception): action [indices:admin/create] is unauthorized

    The role has no create_index on that index

    Set up an Elasticsearch or OpenSearch target

    Automator

    Error or symptom What it means Fix

    SSLError and WRONG_VERSION_NUMBER at sign in

    Enable TLS is selected, and Core Hub answers on plain HTTP

    Use Gluesync Automator

    Create target table execution error: ERROR: schema "<name>" does not exist

    The target schema is missing, or its name has a typing error

    Use Gluesync Automator

    ERROR: all replication slots are in use during a bulk, YAML, restore or duplicate run on PostgreSQL

    The database reached max_replication_slots

    Use Gluesync Automator

    This backup has masked passwords

    The archive was exported without Include secrets

    Use Gluesync Automator

    PARTIAL: result, for example 3 of 4 entities created (1 failed)

    One entity could not be created

    Use Gluesync Automator

    Installer, Conductor and platform codes

    Error or symptom What it means Fix

    GS-PRE-…, GS-RUN-…, GS-SUP-…

    Codes of the pre-flight checks, the installers and Gluesync Control

    Installer error codes

    DISK_FULL, COMPOSE_FILE_CORRUPT and other codes in Platform updates

    Diagnosis codes returned by Gluesync Conductor

    Conductor error codes

    A CVE or a scanner finding about Gluesync

    Ask whether a CVE affects you