IBM Support

当Oracle为目标端时QApply抛错ASN0552E和SQL1822N

Troubleshooting


Problem

当Oracle为目标数据库时如何解决QApply抛出的ASN0552E和SQL1822N错误？

Cause

Q Apply日志中会包含类似的错误信息：
<appAgnt::handleRowError> ASN0552E "Q Apply": QApply server name: "BR00000AG002" : The program encountered an SQL error. The server name is server name. The SQL request is "UPDATE". The table name is .table name. The SQLCODE is "-1822". The SQLSTATE is "560BD". The SQLERRMC is "". The SQLERRP is " ".

SQL1822N "Q Apply" : QApply server name : "BR00000AG002" : Unexpected error code "932" received from data source data source name. Associated text and tokens are "ORA-00932: inconsistent datatypes: expected - got - ". SQLSTATE=560BD

<appAgnt::handleRowError> ASN7522E "Q Apply": QApply server name : "BR00000AG002" : The Q Apply program stopped because it encountered an error for Q subscription Qsubscription name (receive queue, recvq name, replication queue map queue map name).,

Resolving The Problem

ASN0552E的用户响应是：
============================================
请查看您操作系统中DB2关于该信息和SQLCODE代码的解释文档以及推荐的用户响应。如果复制在该信息之后又抛出另一个信息，请查看关于此信息的解释和用户响应。
============================================
SQL1822N是由Oracle抛出的通用信息，所以首先应该查看该错误代码及解释。在db2diag.log和IBMQREP_EXCEPTIONS表中可能也包含其他的有用信息。在我们的示例中，错误代码代表“ORA-00932不一致的数据类型”。它的解法是安装Oracle补丁7309458。

[{"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Q Apply","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.1;9.5;9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSDP5R","label":"InfoSphere Replication Server"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Q Apply","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"","label":"Linux xSeries"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"9.1;9.5;9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21627521

Page Feedback