Skip to Content
author's profile photo
Former Member

SAP sybase replication materialize phase error

Hi Experts,

We have a below error during materialize phase. I have already check this commands and it seems fine

select suid , srid from master..sysloginroles

select suid, srid from master..sysloginroles where srid = 0 or srid = 1

sp_configure 'allow updates',1

1> sap_status path

Path Name Value Info

--------------------- ------------------------------ ------------------------------ ---------------------------------------------------------------------------------------------------

Start Time 2014-05-08 10:14:46.807 Time command started executing.

Elapsed Time 00:00:03 Command execution time.

sappr1 Hostname drsys01 Logical host name.

sappr1 HADR Status Primary : Active Identify the primary and standby sites.

sapdr2 Hostname drsys02 Logical host name.

sapdr2 HADR Status Standby : Inactive Identify the primary and standby sites.

sapdr2.sappr1.TSD State Suspended Path is suspended. Transactions are not being replicated.

sapdr2.sappr1.TSD Latency Unknown No latency information for database 'TSD'.

sapdr2.sappr1.TSD Commit Time Unknown No last commit time for the database 'TSD'.

sapdr2.sappr1.master State Suspended Path is suspended. Transactions are not being replicated.

sapdr2.sappr1.master Latency Unknown No latency information for database 'master'.

sapdr2.sappr1.master Commit Time Unknown No last commit time for the database 'master'.

sappr1.sapdr2.TSD State Suspended Path is suspended. Transactions are not being replicated.

sappr1.sapdr2.TSD Failing Command Error Message Failing Command Error Message The connection in the Replication Server on the sapdr2 host to 'TSD_sapdr2.TSD' is not configured.

sappr1.sapdr2.TSD Latency Unknown No latency information for database 'TSD'.

sappr1.sapdr2.TSD Commit Time Unknown No last commit time for the database 'TSD'.

sappr1.sapdr2.master State Active Path is active and replication can occur.

sappr1.sapdr2.master Latency Unknown No latency information for database 'master'.

sappr1.sapdr2.master Commit Time 2014-05-07 15:53:22.692 Time last commit replicated

*********************

suid srid suid
srid ----------- ----------- ----------- ----------- 1 0 1 0 1 1 1 1 1 2 1 2 1 3 1 3 1 10 1 10 1 32 1 32 3 11 3 11 3 14 3 14 4 34 4 34 4 3 4 3 5 1 5 1 6 33 6 33 1000 1 1000 1 1000 5 1000 5 1000 3 1000 3 1000 0 1000 0 1001 5 1001 5 1001 35 1001 35 1001 0 1001 0 (19 rows affected) (19 rows affected)

********

Regards

Mohammad

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Posted on May 08, 2014 at 04:30 PM

    Hi Mohammed,

    The error "The connection in the Replication Server on the sapdr2 host to 'TSD_sapdr2.TSD' is not configured." indicates a problem with the Rpelication Server connection named 'TSD_sapdr2.TSD'.

    Either this connection does not exist, or it is in an error state.

    Since you have succesfully setup replication, the more likley answer is an error state.

    Please log into the Replication Server on sapdr2 and verify the DSI thread (the apply thread) for the connection named 'TSD_sapdr2.TSD' is up and operational.

    If that thread is down, you can 'resume' it using the following Replication Server command:

    >resume connection to TSD_sapdr2.TSD

    >go

    The recheck the state of the thread. If the state returns to a 'down' or error condition, you will need to review the Replication Server log to determine the detail of the error.

    Regards,
    Stephen

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Stephen,

      I have maintained basic entries at all level hosts , manul entries in DNS in case of resolutin problem ...etc

      I too agree not to interfere in SAP experts but as you know it is pending since long almost 45 days.

      appreacite your inputs as always.

      incident number 477665/2014

      Regards

      MOhammad