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
Notifications & Alerts
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 Us
Technical Support
View All Contacts

Search Knowledge Base by keyword

(Choose different product)



Sort By Last Updated
Displaying 1-25 of 2570
Messages “Source table is not in database“ when running “repair using” on a config file with wildcards and sequences conforming to wildcards. (233292)

When “repair using” is issued on a file with wildcards where the source database has sequences conforming to those wildcard entries, the following messages are observed in sp_ctrl session that issued the command: sp_ctrl>repair using <file_name>. ...

Product(s): SharePlex
Last Updated On: 10/13/2017
(0 Ratings) 3 views
[SP-SYS01003] Connected to an unsupported Postgres Database (232623)

SharePlex connected to an unsupported Postgres Database, see event_log error below: Error: [SP-SYS01003] Connected to an unsupported Postgres Database. <CAUSE> SharePlex does not support Postgres Database that provided. ...

Product(s): SharePlex
Last Updated On: 10/13/2017
(0 Ratings) 3 views
Post stopped due to ORA-02091: transaction rolled back.ORA-02292: integrity constraint violated (228932)

Post is stopped due to error with following messages appearing in event_log: Error 2017-04-28 22:55:25.625014 3815 1246333248 s:2 Poster: failed to commit transaction session 2 in CommitFunc(): ORA-02091: transaction ...

Product(s): SharePlex
Last Updated On: 10/13/2017
(0 Ratings) 3 views
Error "Reader: 11000 - sp_ordr failed: Can't read capture queue (que_SHMERR: Shared memory error)" (183183)

The following errors are observed when Read stops due to error: Info 2015-11-24 13:35:18.755221 18666 1 Reader exited with code=1, pid = 18716 (from server_name). Error 2015-11-24 13:35:16.360060 18716 1 Reader ...

Product(s): SharePlex
Last Updated On: 10/13/2017
(0 Ratings) 10 views
Copy fails with "ERROR: ORA-2266: ORA-02266: unique/primary keys in table referenced by enabled f (50062)

The "copy tablename" command is launched to sync the target table named table2. On target the foreign key constraint is enabled whereby the primary key of this table is referenced as foreign key by a column in another table named table1. The copy fails as follows: ...

Product(s): SharePlex for OracleNT, SharePlex
Last Updated On: 10/13/2017
(0 Ratings) 4442 views
Will Post Enhancement Performance (PEP) work in a Change History or Change Data (CDC) environment? (233070)

SharePlex offers an array of configuration choices to suit one's replication needs. At the same time numerous features are added in SharePlex from time to time. Some of these features may not work in all replication topology. ...

Product(s): SharePlex
Last Updated On: 10/12/2017
(0 Ratings) 5 views
The “repair” errors out with “Table OWNER.TABLE_NAME is not in replication, use force option to repair” (230809)

The following error messages are observed when attempting to repair a table that is not in replication: sp_ctrl repair OWNER.TABLE_NAME. Table OWNER.TABLE_NAME is not in replication, use force option to repair. The table ...

Product(s): SharePlex
Last Updated On: 10/12/2017
(0 Ratings) 4 views
What happens if you cancel out a long running activation (232339)

When you activate a config, it takes some time for the sp_ctrl to return the control back to the issuer. This time typically depends on the # of tables activated and can also depend on whether some tables are currently locked in exclusive mode by users, among others. ...

Product(s): SharePlex
Last Updated On: 10/12/2017
(0 Ratings) 6 views
Ora_setup failed with invalid username/password (18270)

Ora_setup fails due to invalid username/password. Error in the event_log: 2909681504 OID E+ora_setup: 12026 - OCIEnvInit failed with ORA-90002. [ora_setup] [module osp]. Error 2015-08-13 12:05:23.137094 24235 2086258528 ...

Product(s): SharePlex
Last Updated On: 10/11/2017
(0 Ratings) 3127 views
What is “key” option in compare repair? (231231)

This article delves on subtleties of the “key” option of compare/repair. General information. This option compares key values of the source and target to compare/repair a table. No other column values are compared. Once compare ...

Product(s): SharePlex
Last Updated On: 10/11/2017
(0 Ratings) 23 views
Error: "Can't set ORACLE_SID and ORACLE_HOME" during Activation. (16049)

Error received during Activation: "Can't set ORACLE_SID and ORACLE_HOME for database o.xxxxx" This could be caused 1. A typo in ORACLE_SID section in the configuration file. 2. Because ORACLE_SID that is specified in the config file does not exist in the oratab file. ...

Product(s): SharePlex
Last Updated On: 10/10/2017
(0 Ratings) 3540 views
What needs to be specified in the “filename” argument in the command “compare using” or “repair using” (232699)

The file used as argument in "compare using" or "repair using" used to be called config file when these command first come out. Subsequently they were also called synchronization routing file. Nowadays they are called just "files". ...

Product(s): SharePlex
Last Updated On: 10/10/2017
(0 Ratings) 5 views
The command “repair using” with a “where’ clause results in error “Unknown option: 'where'” (231650)

The following errors are observed when running a “repair using” and using “where” clause in it: sp_ctrl (alvsupu15:5438)> repair using config2 where "NUM_COL > 10". Unknown option: 'where'. Usage: repair {source_owner}.{ source_table}[.{partition}]. [not ({list of exceptions})]. ...

Product(s): SharePlex
Last Updated On: 10/10/2017
(0 Ratings) 5 views
The ora_cleansp or ora_setup prompts auto populate with "\c". (232298)

When running ora_cleansp or ora_setup, the prompts auto populate with "\c" without any action on the part of the user. Here is a sample screen shot: [oracle@sp1 bin]$ ./ora_cleansp. Enter shareplex owner: \c. splex. Enter password for splex : \c. ...

Product(s): SharePlex
Last Updated On: 10/2/2017
(0 Ratings) 8 views
Post stopped with error ORA-32795: cannot insert into a generated always identity column (214854)

Post stopped with ORA-32795: cannot insert into a generated always identity column. With Oracle 12c, there is a new feature of defining a column as identity column so that Oracle will auto fill in unique incremental number for key column without using Oracle sequence. ...

Product(s): SharePlex
Last Updated On: 9/28/2017
(0 Ratings) 579 views
The compare results in “No objects to compare; no job started” (232984)

The following error messages show up when running compare on a table: sp_ctrl (seq2:2150)> compare "OWNER"."TABLE_NAME". Cannot compare "OWNER"."TABLE_NAME". Invalid specification "OWNER"."TABLE_NAME". comparing 0 of 1 objects. 1 object(s) contain errors. ...

Product(s): SharePlex
Last Updated On: 9/22/2017
(0 Ratings) 6 views
[SP-SYS01004] No DSN name in the connection string (232624)

Connection to open target db fails when running db setup with below error: Error: [SP-SYS01004] No DSN name in the connection string. <CAUSE>: The connection string must include a Data Source Name (DSN). <ADVICE ...

Product(s): SharePlex
Last Updated On: 9/22/2017
(0 Ratings) 5 views
Messages “Parameter SP_OPO_TRACK_CHANGES not found” seen in event_log (232884)

The following messages are observed in the event_log though the replication is working fine: The example below is for compare client: Info 2017-09-07 12:18:15.170000 11352 11036 Compare client exited normally, pid = 34412 [sp_declt]. ...

Product(s): SharePlex
Last Updated On: 9/22/2017
(0 Ratings) 6 views
Ora_setup failed with error "User already exists" (233105)

Ora_setup failed with complaining that SharePex user that entered already exists. Checked dba_users view, did not find any such user. There was a Role name with same as SharePlex user name entered. Resolution: Drop the role from database. ...

Product(s): SharePlex
Last Updated On: 9/22/2017
(0 Ratings) 6 views
[SP-SYS01001] Connection to failed (231475)

Connection to open target db fails when running db setup with below error: Error: [<database vender name >] [ODBC Driver] No Name entries were found in DSN/connection-string. [SP-SYS01001] Connection <database vender name > to failed. ...

Product(s): SharePlex
Last Updated On: 9/22/2017
(0 Ratings) 4 views
Post fails on Target for the Horizontally partitioned table setup to replicate to Open Target (232284)

Post fails when trying to replicate a horizontally partitioned table to an Open Target target server. It throws garbage data in the event_log. Error from event_log: Error 2017-08-16 07:23: 15.901660 29670 3817867008 Poster: [SP ...

Product(s): SharePlex
Last Updated On: 9/22/2017
(0 Ratings) 5 views
The ALTER TABLE to ADD PRIMARY KEY does not update the object cache on target (232414)

When a Primary key is added to the source table, the target table does not get updated with this DDL, despite the DDL replication turned on. The symptoms are, UPDATEs or DELETEs using all columns to locate the correct row on target. This results in slowness in posting. ...

Product(s): SharePlex
Last Updated On: 9/22/2017
(0 Ratings) 5 views
Do compare log out of sync entry in status database if the table is found to be out of sync? (229204)

In the process of identifying hidden out of sync on tables and keeping a log of the findings, one may want to know if compare can be used to update the out of sync entries in the statusdb (status database) for tables discovered by compare to be out of sync. General information. ...

Product(s): SharePlex
Last Updated On: 9/17/2017
(0 Ratings) 175 views
Error “Poster: Oracle error: ORA-00942: table or view does not exist” in CDC environment even though the table does exist on target (232489)

The Post is stopped due to error and the following messages appear in the event_log in a CDC (Change Data Capture or Change History) environment: Info 2017-08-28 19:47:45.275078 15859 1911934688 Poster launched ...

Product(s): SharePlex
Last Updated On: 9/13/2017
(0 Ratings) 3 views
Shareplex fails to start after installation because mfc100.dll is missing (232337)

After installing shareplex, SpUtils.exe fails to start with the error "The program can't start because mfc100.dll is missing from your computer.Try reinstalling the program to fix this problem" Microsoft Visual C ++ 2010 redistributable package is not installed in the windows server ...

Product(s): SharePlex
Last Updated On: 9/9/2017
(0 Ratings) 15 views