Quest has been named as an ASP "Ten Best Web Support Sites" award winner. Learn more.

SharePlex - Knowledge Base

Filter Your Results
Search All Products

Self Service Tools
Knowledge Base
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Featured Content
SharePlex Support Services
SharePlex Training Course
Troubleshoot slow post
SharePlex Starter
SharePlex Product Page
Contact Support
Contact Support

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 2532
SQL Server login failed (231505)

SQL Server login failed The SQL Error code indicates the general error and the SQLState may provide additional details about the error This error is usually accompanied by a detailed ODBC error message. The ODBC error ...

Product(s): SharePlex
Last Updated On: 8/16/2017
(0 Ratings) 2 views
Poster exit due to trn_cleanup_by_que() failure on Oracle error : ORA-02396 (226085)

Error 2017-01-23 16:28:12.575154 14876732 1 Poster: 15014 - Poster exit due to trn_cleanup_by_que() failure on Oracle error : ORA-02396: exceeded maximum idle time, please connect again (posting from source_db, queue queuename, to target_db) [module opo] Error ...

Product(s): SharePlex
Last Updated On: 8/16/2017
(0 Ratings) 283 views
[SP-COM01009] Cannot connect to the database (231514)

Cannot connect to the database Could not form a connection to the database - Check the connections.yaml file located under $vardir/data and check the information of the DB SharePlex is trying to connect. - Establish the connection ...

Product(s): SharePlex
Last Updated On: 8/15/2017
(0 Ratings) 3 views
Warning “ABORT CONFIG for this configuration will cause data loss for other active configurations on this system if you have not implemented named queues” when there are multiple active config files for the same port number. (231315)

The following warnings appear when attempting to abort/purge a config file that is a part of SharePlex instance containing multiple active config file: sp_ctrl >abort config <config_file_name>. WARNING! Issuing ABORT/PURGE ...

Product(s): SharePlex
Last Updated On: 8/15/2017
(0 Ratings) 18 views
Copy error “Error/Warning Detected: EXP-00111: Table TABLE_NAME resides in an Encrypted Tablespace TABLESPACE_NAME and will not be exported” (231474)

The following errors are observed when running copy for a source table that resides in an encrypted tablespace: sp_ctrl>copy status. ID Tablename Status Time Total Rows %Comp Total Time. -----. ...

Product(s): SharePlex
Last Updated On: 8/15/2017
(0 Ratings) 3 views
Using deprecated parameter SP_OPX_CHECKPOINT_FREQ for commit frequency. (231504)

Using deprecated parameter SP_OPX_CHECKPOINT_FREQ for commit frequency. SP_OPX_CHECKPOINT_FREQ is set to {0} and will be used for commit frequency until the parameter is reset. Reset SP_OPX_CHECKPOINT_FREQ ...

Product(s): SharePlex
Last Updated On: 8/15/2017
(0 Ratings) 2 views
How much bandwidth is needed between source and target servers involved in Shareplex replication (205255)

At times there is a need to estimate the bandwidth requirement between source and target servers involved in Shareplex replication prior to setting up the replication. This article delves on the issue. General information. There ...

Product(s): SharePlex
Last Updated On: 8/15/2017
(0 Ratings) 19 views
The "compare using" errors out with "Object name not of the form OWNER.TABLE" (181714)

The "compare using" errors out with "Object name not of the form OWNER.TABLE" as shown below: sp_ctrl > compare using config_file_name. Cannot compare "OWNER"."TABLE_NAME". Invalid specification OWNER.TABLE_NAME target_servername@o.targetSID. ...

Product(s): SharePlex
Last Updated On: 8/15/2017
(0 Ratings) 1143 views
The "show sync" shows table as out of sync after successfully running compare with repair option on an out of sync table. (33236)

You sync up a table that was earlier out of sync by running compareor using other means. However, when you issue "show sync" from sp_ctrl, it still lists that table as out of sync. Any "out of syncs" that are repaired out side of ...

Product(s): SharePlex
Last Updated On: 8/8/2017
(0 Ratings) 1978 views
What is the use of “nolock” option in the command “activate config”? (75676)

What is the use of “nolock” option in the command “activate config”? General information. The activation in Shareplex 7.6 and up uses “live” option, meaning that the activation process will attempt to lock a table and if the table ...

Product(s): SharePlex
Last Updated On: 8/7/2017
(0 Ratings) 3042 views
How to use the right Oracle index to resolve post performance issue (50197)

Many times post performance issue happens because tables do not have a good index to use. Oracle utilizes indexes to update or delete a record from a table. If table does not have index or not have up to date statistic information, Oracle will spend more time to locate the row. ...

Product(s): SharePlex for OracleNT, SharePlex
Last Updated On: 8/7/2017
(0 Ratings) 72 views
repair with exclude or include results in “error : repair does not support table without key after applying include/exclude option” (231233)

When running a repair with “exclude” or “include” option when the table has no key, the repair errors out: sp_ctrl (alvsupu15:5438)> repair sha90.table2 exclude "char_col". repairing 1 of 1 objects. repair started; job id 1. sp_ctrl (alvsupu15:5438)> job status. Job ID : 1. PID : 12988 ...

Product(s): SharePlex
Last Updated On: 8/7/2017
(0 Ratings) 5 views
[SP-COM01012] The ORACLE_HOME environment variable does not point to a valid directory. (231517)

The ORACLE_HOME environment variable does not point to a valid directory The ORACLE_HOME environment variable does not point to a valid directory - Verify the ORACLE_HOME environment variable, check that is a valid directory. ...

Product(s): SharePlex
Last Updated On: 8/4/2017
(0 Ratings) 5 views
Verify command generates 100s of SQLServer Connections (231647)

On SQL Server source, after setting up a config file and issuing the verify command noticed slowness with hundreds of SQLServer connections. There is an issue on SQL Server capture source with verify command connections ...

Product(s): SharePlex
Last Updated On: 8/4/2017
(0 Ratings) 4 views
How to quickly sync a very large table using Repair when the table has a DATE type of field that keeps track of when a row is created or subsequently updated. (213946)

At times the out of sync are known to occur after a certain time. Most common cause is removal of queue data due to some system, database or replication issues. But there can be other issues resulting in out of sync after a particular time such as user error, etc. ...

Product(s): SharePlex
Last Updated On: 7/28/2017
(0 Ratings) 10 views
Error “Edit config file is not allowed for an active config file” (231232)

When activating a config file, the following errors is observed: sp_ctrl (alvsupu15:5438)> edit config config1. Edit config file is not allowed for an active config file. Editing of an active config file is not permitted. In current versions ...

Product(s): SharePlex
Last Updated On: 7/26/2017
(0 Ratings) 4 views
What needs to be done when planning to upgrade SharePlex and have customized SharePlex monitoring scripts (112032)

Planned SharePlex upgrade and have customized SharePlex monitoring scripts. Is there anything that needs to be done to the SharePlex monitoring scripts when upgrading SharePlex? As specified in the SharePlex Admin ...

Product(s): SharePlex
Last Updated On: 7/26/2017
(0 Ratings) 11 views
Export queue backlogged and not sending to target. (109533)

Export queue backlogged when vardir on NFS mount point. Software issue when frequent writecommit disk space check. Issue fixed in SharePlex version 8.0.2 and above versions through ST 103417.

Product(s): SharePlex
Last Updated On: 7/26/2017
(0 Ratings) 18 views
How do the parameters SP_IMP_WCMT_MSGCNT and SP_IMP_WCMT_TIMEOUT work in conjunction to induce checkpoint of Import? (136233)

How do the parameters SP_IMP_WCMT_MSGCNT and SP_IMP_WCMT_TIMEOUT work in conjunction to induce checkpoint of Import? General information. Import will checkpoint when one of the following happens first: The ...

Product(s): SharePlex
Last Updated On: 7/26/2017
(0 Ratings) 10 views
Steps that need to be taken prior to doing a planned failover of Shareplex in a High Availability (49012)

Shareplex replication is used to keep a high availability secondary server ready for planned or unplanned failover, should the need arise. While an unplanned failover can occur without any prior notice, the planned failover is ...

Product(s): SharePlex for OracleNT, SharePlex
Last Updated On: 7/26/2017
(0 Ratings) 1809 views
When upgrading Oracle and/or the Operating System only, is there anything required to be done on the part of SharePlex? (41093)

When upgrading Oracle and/or the Operating System only, is there anything required to be done on the part of SharePlex. General information. If upgrading Oracle and/or the Operating System only while retaining the current ...

Product(s): SharePlex
Last Updated On: 7/26/2017
(0 Ratings) 4112 views
Is it possible to selectively replicate tables on the basis of criteria like object type, datatype, etc? (230892)

Customers want to know if they can direct SharePlex to only replicate tables that qualify under some criteria like object type, datatype, date created, or for that matter any other criteria. General information. The only way to selectively ...

Product(s): SharePlex
Last Updated On: 7/19/2017
(0 Ratings) 5 views
Post is stopped with cannot add or drop index even when no form of DDL replication is configur (70443)

The following DDL errors are observed when Post stopped due to error. However, no form of DDL replication is configured, meaning both SP_OCT_REPLICATE_ALL_DDL and SP_OCT_REPLICATE_DDL are set to 0. Notice ...

Product(s): SharePlex
Last Updated On: 7/19/2017
(0 Ratings) 1876 views
Post restarts automatically after command issued "stop post at sourcetime MM/DD/YY HH:MM:SS" with multiple post queues (184086)

Post restarts automatically after command issued "stop post at sourcetime MM/DD/YY HH:MM:SS" with multiple post queues. The following errors are shown in the event_log: Notice Poster: Poster will stop when redotime > MM ...

Product(s): SharePlex
Last Updated On: 7/18/2017
(0 Ratings) 328 views
Post fails with ORA-90002 after SharePlex upgrade on Windows (231175)

Post fails with ORA-90002 after SharePlex upgrade from 8.0 to 8.6 on Windows environment. Error 2017-07-10 23:42:10.436000 16344 13772 Poster: 12026 - OCIEnvInit failed with ORA-90002 (posting from orcl, queue post_queue_bmf_arc, to xxxx) [module osp]. ...

Product(s): SharePlex
Last Updated On: 7/14/2017
(0 Ratings) 6 views