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