Retour
-
Titre
Activation / Reader fails on Upgrade / New Installation to versions 9.x when replicating Objects with names in Non-ASCII characters that's not UTF8 -
Description
Upgrade:
- Activation fails with "Route array empty" error on SharePlex upgrade when the object names in the config file are in a Non-ASCII Characters that is not UTF8. This occurs only on upgrades to 9.x versions.
Error 2019-06-23 03:26:00.872413 31582 261588432 Compile of "sp2100_CWP395826-10.config" for database o.fimdb05 failed: Route array empty for 14 "IFFOODS"."削除予定_AUCTION"Info 2019-06-23 03:26:00.884298 28863 3321803328 Activation exited with code=1, pid = 31582 (activating datasource o.fimdb05)- Reader fails when the Object names in the config file are Non-ASCII Characters and is not UTF8.Error 2019-06-25 10:28:35.631161 24214 2315321216 Reader: 11043 - Can't get objectid for "SG_IFFOODS"."・ス尞懶ソス\・ス・ス_AUCTION_BID garbled table nameWarning 2019-06-25 10:28:35.632590 24214 2315321216 Reader: 11031 - cca_use(o.fimdb05,20) failed (from o.fimdb05) [module ord]Error 2019-06-25 10:28:35.633812 24214 2315321216 Reader: 11000 - sp_ordr failed: can't use config cache o.fimdb05-20 (from o.fimdb05) [module ord]Error 2019-06-25 10:28:35.633995 24214 2315321216 Reader stopped: Internal error encountered; cannot continue (from o.fimdb05)Info 2019-06-25 10:28:36.652551 32517 3268334144 Reader exited with code=1, pid = 24214 (from o.fimdb05)New Installation:- Reader fails on a new installation when the Object names in the config file are Non-ASCII Characters and is not UTF8.On new a activation, activation succeeds but the reader process fails.Error 2019-06-25 12:08:54.267396 2391 830756704 Reader: 11043 - Can't get objectid for "SG_IFFOODS"."???\??_AUCTION_BID" (from o.orcl2) [module ord]Warning 2019-06-25 12:08:54.267902 2391 830756704 Reader: 11031 - cca_use(o.orcl2,4) failed (from o.orcl2) [module ord]Error 2019-06-25 12:08:54.268572 2391 830756704 Reader: 11000 - sp_ordr failed: can't init config cache (from o.orcl2) [module ord]Error 2019-06-25 12:08:54.268908 2391 830756704 Reader stopped: Internal error encountered; cannot continue (from o.orcl2)Info 2019-06-25 12:08:55.259679 2266 3527759712 Reader exited with code=1, pid = 2391 (from o.orcl2) -
Cause
In versions prior to 9.0, SharePlex used to store the replicated tables information in the SHAREPLEX_ROUTES table.Since the SHAREPLEX_ROUTES table was stored in the Oracle database, Non-ASCII object names that are not UTF8 were always stored in the current database's character set.Starting 9.0, routing information is moved to a YAML file in the <vardir>/db folder. Since this YAML file is UTF8, Object names that were not represented in UTF8 characters were getting stored incorrectly. Typically, this happens when there is a non-ASCII table name in the Source database whose primary character set is not UTF8. -
Résolution
If the Source DB has Object names that are non-ASCII and are not in UTF8 characters,1. Contact support for SPO-18527.2. On existing replication, re-activate the current active configuration file with the NOLOCK option.3. If adding new objects, modify the configuration file and reactivate.This is fixed in the later versions. Refer to the release notes for more details.