Replication error

[d***@njit.edu]

Hi all,

I am getting the following error when I am doing replication:-

SAT: APPERRM is ASN1029E APPLY "F01" : "WorkerThread". The SQL statement of the
subscription set named "F01_SUB" with a whos_on_first value of "S" did not execute successfully. The statement failed with SQLCODE "100" and SQLSTATE "02000". The apply program internal error code is "362901".

Can anyone explain why I am getting this error and how to fix this?

Thanks a lot,
Dev

[c***@us.ibm.com]

The code you are receiving from the SQL statement is being returned as there are no rows that meet the criteria. This will cause the replication of your set to fail, unless you tell Apply that an 02000 SQLSTATE should be considered okay and to skip it.

You can specify this when editing the SQL statement in DB2 Replication Center. It is then stored in ASN.IBMSNAP_SUBS_STMTS(ACCEPT_SQLSTATES).

- Bill -

[d***@njit.edu]

Hi Bill,

Actually I do have 02000 as my ACCEPT_SQLSTATES in the ASN.IBMSNAP_SUBS_STMTS. Still getting this error. What I am trying to do is, I am creating the target from DDLs generated by the db2look utility. I am not changing the source. If I restore the target from an older backup the replication works fine. Its only when I recreate the target from the DDLs I get this error. I have 6 subsets, of which only one is having this error.

Still in a fix. Thanks for your reply though.

Thanks
Dev