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)

Converse agora com nosso suporte

Obtenha ajuda em tempo real
Concluir registro

Entrar

Solicitar preços

Entre em contato com o setor de vendas

Voltar

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Título

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

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)
Causa

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.
Resolução

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.

Feedback enviado

Este artigo resolveu um problema para você?

Selecione a classificação

Solicitar um artigo da base de conhecimento

Conteúdo recomendado

Produto(s):: 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

Tópico(s):: Best Practices, Configuration, How To, Installation, Troubleshooting

Histórico do artigo:: Criado em: 7/9/2019
Última atualização em: 5/7/2023

Search All Articles

Selecione seu produto:

Para podermos atendê-lo melhor, informe o Propósito de seu chat:

Soluções recomendadas para seu problema

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)

Título

Descrição

Causa

Resolução

Leave a Comment