Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2013
    Posts
    6

    Question Unanswered: Unable to register views as replication source (ASN1562E)

    Hi,

    I am trying to register a view as replication source with the following error: "ASN1562E The replication action ended in error. An unexpected error occurred. Reference Code "REGISTRATION9NP""

    I have already register the source tables as well. The view itself is quite simple (below is the view definition)

    CREATE VIEW CCI1.REPLICATION_VIEW_NEW AS
    SELECT
    FACT."SNIPPET_ID",
    FACT."TYPE_ID",
    FACT."TOPIC_ID",
    SNIPPET."SNIPPET_TEXT"
    FROM
    CCI1."FACT_SNIPPET" AS FACT,
    CCI1."DIM_SNIPPET_TEXT" AS SNIPPET
    WHERE
    FACT."SNIPPET_HASH" = SNIPPET."SNIPPET_HASH"


    Does anybody has any pointer for me? What is the reference code REGISTRATION9NP mean?

    Thanks a lot for your help

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    So, how do you suppose to replicate perceived changes in views if those changes have already been replicated from the source tables? You realize, of course, that views don't store any data, yes?
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Aug 2013
    Posts
    6
    I have not replicated the source table.

    According to the documentation, I have to register the source table and creates the CD tables.

    Kind Regards,

  4. #4
    Join Date
    Aug 2013
    Posts
    6
    I created the view using a 3rd party tool and that seems to be the issue. After re-creating it using the tool from db2, it works.

    Thanks a lot for your help...

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •