View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0003657SymmetricDSBugpublic2018-08-02 21:362019-04-24 18:38
Reporterirfaan22 Assigned Toelong  
Priorityurgent 
Status closedResolutionno change required 
Product Version3.8.39 
Summary0003657: System block when replicating
Description.......
[corp-000] - DataExtractorService - Done extracting 1 batches for request 6
[corp-000] - DataExtractorService - Extracting batches for request 7. Starting at batch 28. Ending at batch 28
[corp-000] - DataExtractorService - Done extracting 1 batches for request 7
[corp-000] - DataExtractorService - Extracting batches for request 8. Starting at batch 29. Ending at batch 29
[corp-000] - DataExtractorService - Done extracting 1 batches for request 8
[corp-000] - DataExtractorService - Extracting batches for request 9. Starting at batch 30. Ending at batch 30
[corp-000] - DataExtractorService - Done extracting 1 batches for request 9
[corp-000] - ConfigurationChangedDataRouter - About to refresh the cache of nodes because new configuration came through the data router
[corp-000] - RouterService - Routed 2 data events in 93 ms
[corp-000] - PullUriHandler - 11 data and 11 batches sent during pull request from store:002:002
[store-002] - ConfigurationChangedDatabaseWriterFilter - About to refresh the cache of node security because new configuration came through the data loader
[store-002] - ConfigurationChangedDatabaseWriterFilter - About to refresh the cache of nodes because new configuration came through the data loader
[store-002] - DefaultDatabaseWriter - About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
    <table name="ITEM">
        <column name="ITEM_ID" primaryKey="true" required="true" type="INTEGER" size="10">
            <platform-column name="h2" type="INTEGER" size="10"/>
        </column>
        <column name="NAME" type="VARCHAR" size="100">
            <platform-column name="h2" type="VARCHAR" size="100"/>
        </column>
    </table>
</database>
[store-002] - H2DatabasePlatform - Running alter sql:
CREATE TABLE "ITEM"(
    "ITEM_ID" INTEGER NOT NULL,
    "NAME" VARCHAR(100) NULL,
    PRIMARY KEY ("ITEM_ID")
);

[store-002] - DefaultDatabaseWriter - About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
    <table name="ITEM_SELLING_PRICE">
        <column name="ITEM_ID" primaryKey="true" required="true" type="INTEGER" size="10">
            <platform-column name="h2" type="INTEGER" size="10"/>
        </column>
        <column name="STORE_ID" primaryKey="true" required="true" type="VARCHAR" size="5">
            <platform-column name="h2" type="VARCHAR" size="5"/>
        </column>
        <column name="PRICE" required="true" type="DECIMAL" size="10,2">
            <platform-column name="h2" type="DECIMAL" size="10" decimalDigits="2"/>
        </column>
        <column name="COST" type="DECIMAL" size="10,2">
            <platform-column name="h2" type="DECIMAL" size="10" decimalDigits="2"/>
        </column>
        <foreign-key name="FK_PRICE_ITEM_ID" foreignTable="ITEM" foreignTableCatalog="" foreignTableSchema="">
            <reference local="ITEM_ID" foreign="ITEM_ID"/>
        </foreign-key>
    </table>
</database>
[store-002] - H2DatabasePlatform - Running alter sql:
CREATE TABLE "ITEM_SELLING_PRICE"(
    "ITEM_ID" INTEGER NOT NULL,
    "STORE_ID" VARCHAR(5) NOT NULL,
    "PRICE" DECIMAL(10,2) NOT NULL,
    "COST" DECIMAL(10,2),
    PRIMARY KEY ("ITEM_ID", "STORE_ID")
);
ALTER TABLE "ITEM_SELLING_PRICE"
    ADD CONSTRAINT "FK_PRICE_ITEM_ID" FOREIGN KEY ("ITEM_ID") REFERENCES "ITEM" ("ITEM_ID");

[store-002] - DefaultDatabaseWriter - About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
    <table name="SALE_TRANSACTION">
        <column name="TRAN_ID" primaryKey="true" required="true" type="INTEGER" size="10">
            <platform-column name="h2" type="INTEGER" size="10"/>
        </column>
        <column name="STORE_ID" required="true" type="VARCHAR" size="5">
            <platform-column name="h2" type="VARCHAR" size="5"/>
        </column>
        <column name="WORKSTATION" required="true" type="VARCHAR" size="3">
            <platform-column name="h2" type="VARCHAR" size="3"/>
        </column>
        <column name="DAY" required="true" type="VARCHAR" size="10">
            <platform-column name="h2" type="VARCHAR" size="10"/>
        </column>
        <column name="SEQ" required="true" type="INTEGER" size="10">
            <platform-column name="h2" type="INTEGER" size="10"/>
        </column>
    </table>
</database>
[store-002] - H2DatabasePlatform - Running alter sql:
CREATE TABLE "SALE_TRANSACTION"(
    "TRAN_ID" INTEGER NOT NULL,
    "STORE_ID" VARCHAR(5) NOT NULL,
    "WORKSTATION" VARCHAR(3) NOT NULL,
    "DAY" VARCHAR(10) NOT NULL,
    "SEQ" INTEGER NOT NULL,
    PRIMARY KEY ("TRAN_ID")
);

[store-002] - DefaultDatabaseWriter - About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
    <table name="SALE_RETURN_LINE_ITEM">
        <column name="TRAN_ID" primaryKey="true" required="true" type="INTEGER" size="10">
            <platform-column name="h2" type="INTEGER" size="10"/>
        </column>
        <column name="ITEM_ID" required="true" type="INTEGER" size="10">
            <platform-column name="h2" type="INTEGER" size="10"/>
        </column>
        <column name="PRICE" required="true" type="DECIMAL" size="10,2">
            <platform-column name="h2" type="DECIMAL" size="10" decimalDigits="2"/>
        </column>
        <column name="QUANTITY" required="true" type="INTEGER" size="10">
            <platform-column name="h2" type="INTEGER" size="10"/>
        </column>
        <column name="RETURNED_QUANTITY" type="INTEGER" size="10">
            <platform-column name="h2" type="INTEGER" size="10"/>
        </column>
        <foreign-key name="FK_SRLI_ITEM_ID" foreignTable="ITEM" foreignTableCatalog="" foreignTableSchema="">
            <reference local="ITEM_ID" foreign="ITEM_ID"/>
        </foreign-key>
        <foreign-key name="FK_SRLI_TRAN_ID" foreignTable="SALE_TRANSACTION" foreignTableCatalog="" foreignTableSchema="">
            <reference local="TRAN_ID" foreign="TRAN_ID"/>
        </foreign-key>
    </table>
</database>
[store-002] - H2DatabasePlatform - Running alter sql:
CREATE TABLE "SALE_RETURN_LINE_ITEM"(
    "TRAN_ID" INTEGER NOT NULL,
    "ITEM_ID" INTEGER NOT NULL,
    "PRICE" DECIMAL(10,2) NOT NULL,
    "QUANTITY" INTEGER NOT NULL,
    "RETURNED_QUANTITY" INTEGER,
    PRIMARY KEY ("TRAN_ID")
);
ALTER TABLE "SALE_RETURN_LINE_ITEM"
    ADD CONSTRAINT "FK_SRLI_ITEM_ID" FOREIGN KEY ("ITEM_ID") REFERENCES "ITEM" ("ITEM_ID");
ALTER TABLE "SALE_RETURN_LINE_ITEM"
    ADD CONSTRAINT "FK_SRLI_TRAN_ID" FOREIGN KEY ("TRAN_ID") REFERENCES "SALE_TRANSACTION" ("TRAN_ID");

[store-002] - ConfigurationChangedDatabaseWriterFilter - About to refresh the cache of node security because new configuration came through the data loader
[store-002] - TriggerRouterService - Synchronizing triggers for STORE002.PUBLIC.SALE_RETURN_LINE_ITEM
[store-002] - H2SymmetricDialect - Creating SYM_ON_I_FOR_SL_RTRN_LN_TM_STR trigger for STORE002.PUBLIC.SALE_RETURN_LINE_ITEM
[store-002] - H2SymmetricDialect - Creating SYM_ON_U_FOR_SL_RTRN_LN_TM_STR trigger for STORE002.PUBLIC.SALE_RETURN_LINE_ITEM
[store-002] - H2SymmetricDialect - Creating SYM_ON_D_FOR_SL_RTRN_LN_TM_STR trigger for STORE002.PUBLIC.SALE_RETURN_LINE_ITEM
[store-002] - TriggerRouterService - Done synchronizing triggers for STORE002.PUBLIC.SALE_RETURN_LINE_ITEM
[store-002] - TriggerRouterService - Synchronizing triggers for STORE002.PUBLIC.SALE_TRANSACTION
[store-002] - H2SymmetricDialect - Creating SYM_ON_I_FOR_SL_TRNSCTN_STR trigger for STORE002.PUBLIC.SALE_TRANSACTION
[store-002] - H2SymmetricDialect - Creating SYM_ON_U_FOR_SL_TRNSCTN_STR trigger for STORE002.PUBLIC.SALE_TRANSACTION
[store-002] - H2SymmetricDialect - Creating SYM_ON_D_FOR_SL_TRNSCTN_STR trigger for STORE002.PUBLIC.SALE_TRANSACTION
[store-002] - TriggerRouterService - Done synchronizing triggers for STORE002.PUBLIC.SALE_TRANSACTION
[store-002] - PullService - Pull data received from corp:000:000 on queue default. 11 rows and 11 batches were processed. (sym_node_security, sym_node, item, item_selling_price, sale_transaction, sale_return_line_item)
[store-002] - ConfigurationChangedDataRouter - About to refresh the cache of node security because new configuration came through the data router
[store-002] - RouterService - Routed 2 data events in 84 ms #<block here
.......
TagsNo tags attached.

Activities

hanes

2018-10-17 20:22

developer   ~0001291

Can you be more specific about what your error is? I'm not seeing the issue when looking at your description you have provided.

Issue History

Date Modified Username Field Change
2018-08-02 21:36 irfaan22 New Issue
2018-10-17 20:22 hanes Status new => feedback
2018-10-17 20:22 hanes Note Added: 0001291
2019-04-24 18:38 elong Assigned To => elong
2019-04-24 18:38 elong Status feedback => closed
2019-04-24 18:38 elong Resolution open => no change required