Skip to Content

HANA Replication - Alert "Connection between systems in system replication setup" (id 78)

Hi

I'm getting this email alert from the HANA tenant database:

snapshot   : 2015-08-18 16:42:52.0000000

Alert Name : Connection between systems in system replication setup

Rating     : Error

Details    : At 2015-08-18 18:35:45.0000000 on hostp01:30103; Site 2: Communication channel closed

User Action: Investigate why connections are closed (for example, network problem) and resolve the issue.

I see more alerts in the trace files, don't know if they are related:

Tenant's database trace files:

[178728]{419183}[119/-1] 2015-08-18 20:56:11.225670 e cePlanExec cePlanExecutor.cpp(07183) : Error during Plan execution of model _SYS_STATISTICS:_SYS_SS_CE_1402084_140190768844608_4_INS (-1), reason: executor: plan operation failed;CalculationNode ($$_SYS_SS2_RESULT$$) -> operation (CustomLOp):Compilation failed; OpenChannelException at network layer:

  message: an error occured while opening the channel

  info:    connection refused

  param:   127.0.0.1:30110


Replication database trace files:

nameserver_alert_hostp01.trc

[42096]{-1}[-1/-1] 2015-08-18 18:45:18.355758 e TrexNet          EndPoint.cpp(00260) : ERROR: failed to open channel 127.0.0.1:30107! reason: (connection refused)

Please assist.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 19, 2015 at 06:27 AM

    This seems to be communication problem between your primary and secondary. Check if your secondary system is up and running.

    Mostly the above error will cause due to un avaibality of secondary system.

    Manually start the secondary system if it is down and see if the error ocurs again. 

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Willem Lourens

      See if you have maintained correctly in the tenant DB/instance and SYSTEMDB. I don't have much idea on multi tenant DB. And not sure, I am not able to open the files. Paste the output in reply

  • avatar image
    Former Member
    Aug 18, 2015 at 11:17 PM

    Hi Willem,

    Do you see the communication channel closed errors on the SYSTEM Replication TAB of the SYSTEMDB?

    Do you get this error after SYSTEM Replication has completed the Full Sync of data or at the very first stage of System replication?

    The common cause of the communication channel closed errors is a loss of connectivity or the unavailability of the secondary tier of system replication, please provide more details to understand your errors

    Sunil

    Add comment
    10|10000 characters needed characters exceeded