5 Replies Latest reply on Feb 18, 2020 6:19 AM by ORASCN

    update issue in rep

    user10126973

      HI All

      Please share your thoughts.

      The update is not happening in the target and its getting error no data found

      when I checked in the source the row exist and table has PK

      OGG :- 12.3

      DB :- 11.2.4

      thanks in advance

      Regards,

      DR

        • 1. Re: update issue in rep
          Vikas Panwar

          Please elaborate your question.

          Also share the parameter files + error from GG log

          • 2. Re: update issue in rep
            ORASCN

            Hi DR,

             

            There are various causes for "ORA-1403 No data found".

             

            Is it new configuration?

            If YES, was the initial load done?

            Whether supplemental logging and trandata enabled?

            You had mentioned source table has PK, whether target table has PK?

             

            Please share the below,

             

            parameter file of replicat process

            discard file

            report file of replicat process with error

             

            Regards,

            Veera

            • 3. Re: update issue in rep
              user10126973

              HI Veera,

              In this rep Param file i have so many tables(others tables getting replicated)  and its not a new one

              The table has PK on both sides , still its required supplemental logging and trandata enabled?

              Regards,

              DR

              • 4. Re: update issue in rep
                4073220

                Check if PK is enabled and validated.

                Are your Extract and Replicat using Same Key columns?

                Does the row with same PK exists on target?

                If the ROW does not exist on target, do you know when the insert has happened?

                You can scan the trail file to see if insert is part of the trail.

                 

                Provide earlier suggested details to review on this further.

                • 5. Re: update issue in rep
                  ORASCN

                  Hey,

                   

                  So, the row exists in the Target as well? Do you have Discard file? Can you share the same?

                   

                  If you have only DML replication in place, then for each and every table you add it newly should have trandata enabled manually.

                   

                  Regards,

                  Veera