View Revisions: Issue #6332

Back to Issue
Summary 0006332: Allow specification of initial load select for initial load of filesync channel
Revision 2024-04-05 17:32 by pmarzullo
Description When executing an initial load of files, all files are sent to every node instead of allowing an initial load select to be run against the sym_file_snapshot table.
Allow the specification of an initial load select that will be applied to the sym_file_snapshot table.

1. Create an actual trigger definition for the sym_file_snapshot instead of relying on a virtual trigger definition.
        Trigger ID: sym_file_snapshot
    Table name: sym_file_snapshot
    Channel ID: dynamic (user interface does not allow it, you will have to modify after creating it)
    Reload Channel ID: filesync_reload (user interface does not allow it, you will have to modify after creating it)
    Channel Expression: $(curTriggerValue).$(curColumnPrefix)channel_id
2. Define a filesync router
        Router ID: sym_file_snapshot_<sourcegroup>_2_<targetgroup>
    Router Type: filesync
3. Define a sym_trigger_router for the filesync trigger and router
        Trigger ID: sym_file_snapshot
        Router ID: sym_file_snapshot_<sourcegroup>_2_<targetgroup>
    Initial Load Select: some where clause using the relative_dir for filtering
Revision 2024-04-08 12:28 by pmarzullo
Description When executing an initial load of files, all files are sent to every node instead of allowing an initial load select to be run against the sym_file_snapshot table.
Allow the specification of an initial load select that will be applied to the sym_file_snapshot table.

1. Create an actual trigger definition for the sym_file_snapshot instead of relying on a virtual trigger definition.
        Trigger ID: sym_file_snapshot
    Table name: sym_file_snapshot
    Channel ID: dynamic (user interface does not allow it, you will have to modify after creating it)
    Reload Channel ID: filesync_reload (user interface does not allow it, you will have to modify after creating it)
    Channel Expression: $(curTriggerValue).$(curColumnPrefix)channel_id
2. Define a filesync router
        Router ID: sym_file_snapshot_<sourcegroup>_2_<targetgroup>
    Router Type: filesync (user interface does not allow it, you will have to modify after creating it)
3. Define a sym_trigger_router for the filesync trigger and router
        Trigger ID: sym_file_snapshot
        Router ID: sym_file_snapshot_<sourcegroup>_2_<targetgroup>
    Initial Load Select: some where clause using the relative_dir for filtering
Revision 2024-04-10 13:05 by pmarzullo
Description When executing an initial load of files, all files are sent to every node instead of allowing an initial load select to be run against the sym_file_snapshot table.
Allow the specification of an initial load select that will be applied to the sym_file_snapshot table.

1. Create an actual trigger definition for the sym_file_snapshot instead of relying on a virtual trigger definition.
        Trigger ID: sym_file_snapshot
    Table name: sym_file_snapshot
    Channel ID: dynamic (user interface does not allow it, you will have to modify after creating it)
    Reload Channel ID: filesync_reload (user interface does not allow it, you will have to modify after creating it)
    Channel Expression: $(curTriggerValue).$(curColumnPrefix)channel_id
        We actually need to set it to $(specialSqlServerSybaseChannelExpression) for SQL Server and Sybase ASE
2. Define a filesync router
        Router ID: sym_file_snapshot_<sourcegroup>_2_<targetgroup>
    Router Type: filesync (user interface does not allow it, you will have to modify after creating it)
3. Define a sym_trigger_router for the filesync trigger and router
        Trigger ID: sym_file_snapshot
        Router ID: sym_file_snapshot_<sourcegroup>_2_<targetgroup>
    Initial Load Select: some where clause using the relative_dir for filtering
Revision 2024-04-10 13:11 by pmarzullo
Description When executing an initial load of files, all files are sent to every node instead of allowing an initial load select to be run against the sym_file_snapshot table.
Allow the specification of an initial load select that will be applied to the sym_file_snapshot table.

1. Create an actual trigger definition for the sym_file_snapshot instead of relying on a virtual trigger definition.
        Trigger ID: sym_file_snapshot
    Table name: sym_file_snapshot
    Channel ID: dynamic (user interface does not allow it, you will have to modify after creating it)
    Reload Channel ID: filesync_reload (user interface does not allow it, you will have to modify after creating it)
    Channel Expression: $(curTriggerValue).$(curColumnPrefix)channel_id
2. Define a filesync router
        Router ID: sym_file_snapshot_<sourcegroup>_2_<targetgroup>
    Router Type: filesync (user interface does not allow it, you will have to modify after creating it)
3. Define a sym_trigger_router for the filesync trigger and router
        Trigger ID: sym_file_snapshot
        Router ID: sym_file_snapshot_<sourcegroup>_2_<targetgroup>
    Initial Load Select: some where clause using the relative_dir for filtering