Activation / Reader fails on Upgrade / New Installation to versions 9.x when replicating Objects with names in Non-ASCII characters that's not UTF8 (4303213)

立即与支持人员聊天

获得即时帮助
完成注册

登录

请求定价

联系销售人员

反馈已提交

本文是否解决了您的问题？

选择评级

标题

Activation / Reader fails on Upgrade / New Installation to versions 9.x when replicating Objects with names in Non-ASCII characters that's not UTF8
说明

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 name
Warning 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)
原因

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.
解决办法

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.

反馈已提交

本文是否解决了您的问题？

选择评级

Request a KB Article

建议的内容

产品：: SharePlex
9.2.4, 9.2.3, 9.2.1, 9.2, 9.1.4, 9.1.3, 9.1.2, 9.1.1, 9.1, 9.0.2

主题：: Best Practices, Configuration, How To, Installation, Troubleshooting

文章历史记录：: 创建时间： 7/9/2019
上次更新时间： 5/7/2023

搜索所有文章

请选择您的产品：

为向您提供更好的服务，请填写'Purpose of your Chat'（联系目的）：

针对您的问题建议的解决方案

Activation / Reader fails on Upgrade / New Installation to versions 9.x when replicating Objects with names in Non-ASCII characters that's not UTF8 (4303213)

标题

说明

原因

解决办法

Leave a Comment