Statistica is now part of TIBCO. Beginning June 5th, Statistica customers will need to use TIBCO Support's customer portal, to receive assistance with Statistica.

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 2504
Error when activating a config file: "Error: 17000 - Error opening file/quest/005/splex/state/o.S (6569)

When trying to activate a new config, it fails with the below errors in the event log: Logging user command: oracle activate config quest_config.file2 Process launched: sp_tconf (for o.SID1) [pid = 14370] Notice: Oracle env - SID1:/u01/app/oracle/product/9.2 [sp_tconf(pdb)/14370 ...

Product(s): SharePlex for OracleNT, SharePlex
Last Updated On: 6/22/2017
(0 Ratings) 3321 views
How to Upgrade SharePlex (115853)

How to upgrade SharePlex to a newer version of SharePlex? Information. Is your SharePlex solution working as efficiently as possible? Learn more about our SharePlex Health Check. Instructions to Upgrade SharePlex; Video ...

Product(s): SharePlex
Last Updated On: 6/21/2017
(0 Ratings) 6185 views
How to set up SharePlex replication to Kafka? (212609)

How to set up SharePlex replication to Kafka? Steps included with examples Prerequisite: source side, turn off auto add and turn off all ddl replication (see step 2) and enable supplemental logging for pk/uk. Only add column ...

Product(s): SharePlex
Last Updated On: 6/20/2017
(1 Ratings) 1105 views
Since compare parameters are live, do they take effect immediatelyr when changed? (116520)

When compare parameters are changed, do they take effect immediately? General information. All compare parameters are live, meaning they will take effect immediately, for any subsequent compare that is run. This is the caveat. ...

Product(s): SharePlex
Last Updated On: 6/20/2017
(0 Ratings) 6 views
What do the value “DEPRECATED” in the “Set At” field of “list param modified” signify? (224956)

When you issue “list param modified”, you come across a value “DEPRECATED” under the field “Set At”: sp_ctrl (alvsupu07:5438)> list param modified. Open Post parameters: Parameter Name Actual Value Units Set At. -----. ...

Product(s): SharePlex
Last Updated On: 6/19/2017
(0 Ratings) 3 views
How to find out the unwanted Post queues from numerous Post queues for the purpose of removing them (225146)

How to identify the unwanted Post queues from numerous Post queues for the purpose of removing them? Unwanted Post queues can exist due to numerous reasons and are quite an annoyance. In an environment where numerous ...

Product(s): SharePlex
Last Updated On: 6/19/2017
(0 Ratings) 2 views
The delete queue command results in error “Cop: delete queue failed: que_NOEXIST: Queue does not exist” (229416)

Following errors are observed when attempting to delete a queue using “delete queue” command: sp_ctrl (alvsupu16:5438)> delete post queue queue1 for o.ORA11GR2 cleartrans. cnc_delete_queue() Queue error - user/queue was not deleted; Check event_log. for details. ...

Product(s): SharePlex
Last Updated On: 6/19/2017
(0 Ratings) 3 views
Why replication is not supported from a Materialized View (MV) on source to a Materialized View on target? (228346)

Why replication is not supported from a Materialized View (MV) on source to a Materialized View on target? General information. A Materialized View is a database object that is derived from other database object(s) also termed ...

Product(s): SharePlex
Last Updated On: 6/19/2017
(0 Ratings) 2 views
Do SharePlex keep record of the redo logs processed by it? (226446)

Do SharePlex keep track of the redo logs processed by it? General information. SharePlex does not store the values of the past redo logs processed by it. Shareplex internal table on source named shareplex_actid has a field ...

Product(s): SharePlex
Last Updated On: 6/19/2017
(0 Ratings) 2 views
How the parameter SP_OPO_SAVE_OOS_TRANSACTION works (225466)

How the parameter SP_OPO_SAVE_OOS_TRANSACTION works. General information. Starting with SharePlex 8.6.6, there is a parameter SP_OPO_SAVE_OOS_TRANSACTION, which, if enabled logs the out of sync transaction ...

Product(s): SharePlex
Last Updated On: 6/19/2017
(0 Ratings) 5 views
How does the commit reduction work in Post Enhanced Performance (PEP) feature (229046)

Starting with SharePlex 8.6, a new feature named Post Enhanced Performance (PEP) has been introduced. The PEP feature helps greatly improve Post performance under certain circumstances. PEP has two levels, commit reduction and increase in concurrency. ...

Product(s): SharePlex
Last Updated On: 6/19/2017
(0 Ratings) 3 views
Do SharePlex processes execute any DML in the source database? (225277)

Do SharePlex processes execute any DML in the source database? General information. SharePlex processes do execute DML on the source database but such activity is only confined to data manipulation of SharePlex internal tables. ...

Product(s): SharePlex
Last Updated On: 6/19/2017
(0 Ratings) 4 views
The number of messages in Export queue are huge and not going down though backlog is 0 (228247)

SharePlex is replicating to one or more target. The replication to one or more of these is working fine but the number of messages in Export queue are huge and keep growing though backlog may be a non-zero number but ...

Product(s): SharePlex
Last Updated On: 6/19/2017
(0 Ratings) 2 views
How SharePlex handles DDL replication in an open target environment? (226366)

Is DDL replication supported in Open Target environment? General information. SharePlex only supports DDL replication for objects in replication for Open Targets and not allow expanded DDL support (which is another term for DDL replication for objects not in replication). ...

Product(s): SharePlex
Last Updated On: 6/19/2017
(0 Ratings) 2 views
How to enable horizontally partitioned replication with named queues for a table already in normal replication with no named queue architecture. (225147)

How to enable horizontally partitioned replication with named queues for a table already in normal replication with no named queue architecture. General information. The steps involved in enabling horizontally partitioned replication ...

Product(s): SharePlex
Last Updated On: 6/19/2017
(0 Ratings) 6 views
Error “Capture: 10722 - can't open capture queue que_ERR: Non specific error” and “Capture: No such file or directory que_open.open_fd” (228246)

The following messages are seen in event_log when Capture stopped due to error: sp_ctrl > show log reverse. Info 2017-04-11 14:47:42.383859 4021 692008800 Capture exited with code=1, pid = 1356 (capturing from source_SID). ...

Product(s): SharePlex
Last Updated On: 6/19/2017
(0 Ratings) 3 views
Will disabling of DDL replication interfere with SP_OCT_AUTOADD_ENABLE and wildcards (228347)

For customers that do not replicate any form of DDL, a very valid question arises as to whether SharePlex will still create the tables on target that conform to wildcards in an auto add environment. General information. The auto ...

Product(s): SharePlex
Last Updated On: 6/19/2017
(0 Ratings) 3 views
What are the implications of leaving the parameters set to their changed values once the errors or problem conditions have been bypassed and no further errors are forthcoming? (229206)

There are numerous parameters in SharePlex which are set to get past a problem or error condition. Usually they are unset by users once the issue is bypassed. At times they are left inadvertently turned on. The article discusses ...

Product(s): SharePlex
Last Updated On: 6/19/2017
(0 Ratings) 1 views
The delete queue command results in error “Cop: delete queue failed: que_INUSE: Que is already open (229419)

The following error are observed when attempting to delete a queue using the command “delete queue <queue_name>: sp_ctrl (alvsupu16:5438)> delete post queue queue1 for o.ORA11GR2. cnc_delete_queue() Queue error ...

Product(s): SharePlex
Last Updated On: 6/19/2017
(0 Ratings) 1 views
Compare client errors out with ORA-01114 (228110)

The following errors are observed in target event log when compare/repair is run on a table: Notice 2017-04-03 04:29:58.523911 32375112 1 Compare client: Opened DataEquator client session log file /shareplex/vardir/log ...

Product(s): SharePlex
Last Updated On: 6/19/2017
(0 Ratings) 3 views
Errors “Poster 12070 - OCITransCommit failed with ORA-12008” and “error in materialized view refresh path.ORA-00942 table or view does not exist” (185820)

The following errors are seen in target event_log when a materialized view exists on target where the underlying table may or may not be a part of replication: Error 2016-01-21 22:27:03.638086 20880 1365956928 s:2 Poster: 12070 - OCITransCommit failed with ORA-12008. ...

Product(s): SharePlex
Last Updated On: 6/19/2017
(0 Ratings) 6 views
Note: Cannot install Compare Varray package because Oracle Spatial datatype is not installed. (228300)

When running ora_setup, the following notice/warning appear as the screen shot below shows: "Loading Compare Package from. "/sw/splexsrc/splex8/ util/sp_deq_pkg.plb"...Done. Note: Cannot install Compare Varray package because Oracle Spatial datatype. is not installed. ...

Product(s): SharePlex
Last Updated On: 6/19/2017
(0 Ratings) 6 views
The row count differs across source and target tables but “show sync” shows that the table is in syn (229580)

Users determine that the row count differs across source and target tables but “show sync” shows that the table is in sync. This appears to be counterintuitive. General information. If the counts do not match across source and ...

Product(s): SharePlex
Last Updated On: 6/19/2017
(0 Ratings) 1 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: 6/19/2017
(0 Ratings) 2810 views
Cancelling a job results in "job is not active" (229540)

When customer issued the command "cancel <jobid>", it resulted in "Job <jobid> is not active". However earlier when the "copy status" was issued, it did show a job with that ID. The following is the screen shot: sp_ctrl (server_name:2200)> copy status. Job ID : 4517. Host : ...

Product(s): SharePlex
Last Updated On: 6/19/2017
(0 Ratings) 2 views