HRSIgnoreError (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / HFSQL / Managing replications / WLanguage functions

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

HRSIgnoreError (Function)

In french: HRSIgnoreErreur

Ignores errors so that replication between HFSQL servers can continue to run.

Warning This function ignores corrupted log files. This means the replication will ignore certain data.

Example

SubscriberHFConnection is Connection
SubscriberHFConnection.Provider = hAccessHFClientServer
SubscriberHFConnection.Server = "localhost:4902"
SubscriberHFConnection.User = "Admin"
SubscriberHFConnection.Database = "DefineTrigger"
SubscriberHFConnection.Password = "xxx"

HOpenConnection(SubscriberHFConnection)
listRS is array of hRSConfig
listRS = HRSListConfig(SubscriberHFConnection, hrsSubscriber)

FOR EACH ConfigReplication OF listRS
	Trace(ConfigReplication.Server)
	IF NOT HRSIgnoreError(SubscriberHFConnection, ConfigReplication) THEN
		Trace(HErrorInfo())
	ELSE
		Trace("OK")
	END
END

Syntax

<Result> = HRSIgnoreError(<Connection> , <Replication>)

<Result>: Boolean

True if the corrupted log file was ignored,
False otherwise.

<Connection>: Character string or Connection variable

Subscriber connection to HFSQL server. This connection corresponds to:
the name of the connection defined in the data model editor or with HDescribeConnection or HOpenConnection.
the name of a variable of type Connection.

<Replication>: hRSConfig variable

Name of the hRSConfig variable that describes the replication.

Remarks

In the event of a failure caused by corruption of one of the replication log files (.hyl), it is impossible to:

ignore the current log file.
continue with the replication, ignoring the contents of this log file.

None of the operations in this log will be replicated, which will result in data loss.

You can detect corrupted log files (.hyl) by viewing notifications:

on the master server: "Replica preparation error" / "The log file is corrupt"..
on publisher server: "Error during replica application on subscriber" / "Log file corrupted"..

In this case, HRSIgnoreError can be used on the subscriber server to ignore the corrupted log file and move on to the next.

Note HSQL Control Center also offers the option of ignoring the corrupted log file using the "Troubleshoot" button in the list of replications of subscribed HFSQL servers.

Business / UI classification: Business Logic

Component: wd300hf.dll