MobiLink Synchronization Reference
Stored Procedures
Client event-hook procedures
Use this stored procedure to add custom actions after dbmlsync has verified receipt of the upload stream by the MobiLink synchronization server.
Name | Values | Description |
---|---|---|
failure cause (in) | See range of values in Description, below | The cause of failure of an upload. For more information, see Description. |
upload status (in) | retry | committed | failed |
Specifies the status returned by the MobiLink synchronization server when dbmlsync attempted to verify receipt of the upload stream.
retry The MobiLink synchronization server and dbmlsync had different values for the log offset from which the upload stream should start. The upload stream was not committed by the MobiLink synchronization server. The dbmlsync utility will attempt to send another upload stream starting from a new log offset. committed The upload stream was received by the MobiLink synchronization server, and committed. failed The MobiLink synchronization server did not commit the upload stream. |
publication_n (in) | publication name | The publications being synchronized, where n is an integer. There is one publication_n entry for each publication being uploaded. |
MobiLink user (in) | MobiLink user name | The MobiLink user for which you are synchronizing. |
script version (in) | script version name | The MobiLink script version to be used for the synchronization. |
If a procedure of this name exists, it is called immediately after dbmlsync has sent the upload stream and received confirmation of it from the MobiLink synchronization server.
Actions of this procedure are committed immediately after execution.
The range of possible parameter values for the failure cause row in the #hook_dict table includes:
UPLD_ERR_COMMUNICATIONS_FAILURE A communication error occurred.
UPLD_ERR_LOG_OFFSET_MISMATCH The upload failed because of conflict between log offset stored on the remote and consolidated databases.
UPLD_ERR_GENERAL_FAILURE The upload failed for an unknown reason.
UPLD_ERR_INVALID_USERID_OR_PASSWORD The user ID or password was incorrect.
UPLD_ERR_USERID_OR_PASSWORD_EXPIRED The user ID or password expired.
UPLD_ERR_USERID_ALREADY_IN_USE The user ID was already in use.
UPLD_ERR_DOWNLOAD_NOT_AVAILABLE The upload was committed on the consolidated but an error occurred that prevented MobiLink from generating a download stream.
UPLD_ERR_PROTOCOL_MISMATCH Dbmlsync received unexpected data from the MobiLink synchronization server.
UPLD_ERR_SQLCODE_n Here, n is an integer. A SQL error occurred in the consolidated database. The integer specified is the SQLCODE for the error encountered.
Synchronization event hook sequence