How to release Replication Log table space on a pure hana system?

[former_member575748]

Hello,

after a recent update for two of our hana only systems to SPS03, they both display the following error: Replication Log has been deactivated due to full log space at <date><time>.

This is confusing since the hana systems were never used/setup for replication and don't have a SLT attached to them.

I would like to resolve this issue but cannot find any handle on how to do it. Are there any sql statements that could determine the tables which I have to look into? Or can you provide me with another way of solving this?

Regards,
Michael

[former_member575748]

Hey,

I got an answer from SAP:
"In HANA2 SP03, a new table replication feature is available. The root issue is replication log feature can be turned off due to unexpected replication log status checker when scriptserver is used. Replication log feature is disabled unless replication log table exists. Note that this feature is can be activated and deactivated at table and system level. It appears that at system level this feature was enabled but there were no tables using replication log feature.

As a workaround one of the following two cases can be used:

(1) Turn off if not using the replication log feature.

ALTER SYSTEM DISABLE REPLICATION LOG

(2) If using the replication feature, then increase interval for checking replication log status after enabling the replication log feature. Alert won't occur during the given time.

- enable the replication log feature
ALTER SYSTEM ENABLE REPLICATION LOG
- change configuration indexserver.ini
[transaction]
replication_log_check_timeout = 8640000 (unit: second, 100 days)

Note that this is the workaround for the mentioned version. The permanent fix is available in HANA 2.00.031 onwards."

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

Sadly the sql commands did not solve the issue for us. So we will wait for 31.

Regards,

Michael

[sputnik136]

Hi Michael,

I have the same error after Upgrade from 1.122.06 to 2.03

Alert Checker - Replication status of Replication Log ( ID 111 ) Check whether the status of replication log is disabled. Proposed Solution - Truncate replication log table and enable replication log.

I will open a Message on SAP Portal and I am interested of your solution ..

Kind regards

Christoph

[Former Member]

Hello,

with setting the indexserver.ini parameter > table_replication > update_log_table_status to value 0 the message doe's not appear anymore.

(Hana 2.0 Rev31)

With best regards

Dirk

[robert_weber_erpsourcing_]

Hi Dirk,

thanks for the hint, I'll give it a try.

i'll let you know about the result.

Best regards,

Robert

[robert_weber_erpsourcing_]

Hello Dirk,

after changing the configuration the alert message didn't come up anymore.

Thanks for your help.

Best regards,

Robert

[robert_weber_erpsourcing_]

Hello,

I just update my SAP HANA 2.0 from SPS03 Revision 30 to Revision 31 and I still have the same issue with this alert message.

My system information:

SAP HANA Version - 2.00.031.00.1528768600 (fa/hana2sp03)Last Build Time - Jun 12, 2018, 3:58:34 AMPlatform - SUSE Linux Enterprise Server 12.1Linux Kernel Version - 3.12.74-60.64.40-default
noxako : Have you also tested with Revision 31? What is your experience? Has SAP given some other hints?
Many thanks in advance for your help.
Best regards,Robert

[former_member575748]

Hello Robert,

sorry for the late answer. After the update to Rev 31 you also need to issue two SQL statements:

alter system alter configuration ('indexserver.ini','SYSTEM') UNSET ('table_replication','update_log_table_status') with reconfigure;

alter system disable REPLICATION LOG;

Best Regards,
Michael

[robert_weber_erpsourcing_]

Hello Michael,

I changed the configuration last week and since that time I do not have the alert anymore.

Thanks for your help.

Best regards,

Robert

[Former Member]

Hi,

I also have the same issue since we installed SAP HANA 2.0 SPS03.

Do you have a anwser from SAP ?

Otherwise, I think I will open a ticket.

Thanks

Fred

[Former Member]

I have the same problem. Have you received a response from SAP?

Thanks,

Rob

[former_member263184]

Dear Michael,

Dear Christoph,

I'm glad to find this topic. We have the same issue, a fresh install of an SAP HANA 2.0 SPS03 (2.00.030.00.1522210459 to be exact) throws the replication log error. System was never configured for system replication and the standard log area has enough space available.

Please post back your answer from the SAP ticket as i'm very curious about the SAP response.

Kind regards,

Bert Braasch