Milestone 2 Guide to Demo - TrackingChains/TrackingChain GitHub Wiki

Preface

The aim of this milestone is to demonstrate, within the application, the presentation of statistics and all the data within the Transactions table. Additionally, it encompasses the capability to configure Accounts, SmartContracts, and ProfileGroups directly through the user interface.

In order to run Milestone 2 it is necessary only Api Triage and Web Application. You can follow the COMPLETE GUIDE for instructions on how to install the services.

Seed Database

If you haven't already inserted a Seed following the complete guide and you don't want to configure the accounts manually from the FrontEnd Admin Tool you can use this seed to insert some users, smartcontarct and ready-to-use test profiles. (NB always check that the accounts entered still have a minimum of tpken to pay the transaction gas fees).

Here you will find the GUIDE for the SEED

Insert monitor data

In order to expedite the process of data input, I have exported a subset of transactions that were utilized during the testing phase. Specifically, this set comprises 9 transactions that were successfully completed, 2 transactions in a Pool status, and 1 transaction in a triage status. Please note that both the Pending and Triage transactions are intentionally held in a blocked state and are unable to proceed. This approach enables the display of a graphical representation for transactions in progress. Addressing and managing these error scenarios will be the focal point of Milestone 3.




INSERT [dbo].[TransactionPendings] ([TrackingId], [Completed], [IsInProgress], [Locked], [LockedBy], [LockedDated], [TriageDate], [TxHash], [Priority], [PoolDate], [WatchingFrom], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [Status], [ErrorTimes]) VALUES (N'e452c2e7-8f57-4ad0-8524-091c250c0120', 1, 0, 1, N'5f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:32:38.1264072' AS DateTime2), CAST(N'2023-08-16T12:27:49.0435093' AS DateTime2), N'0x29e6585d6aa97ca7c7dc7f7341ab70b970260a44f7e35fff4c05dcce9d7d23b0', 0, CAST(N'2023-08-16T12:31:02.3878149' AS DateTime2), CAST(N'2023-08-16T12:32:38.0947945' AS DateTime2), N'SHORT-33412', N'{"code":"Pack"}', CAST(N'2023-08-16T12:31:08.0945985' AS DateTime2), 81, 0, N'{"WaitingSecondsForWatcherTx":90}', 1, N'0xa0532A56179Eb1677D33709db82de6b5880f23c6', N'8f8e591b-6a9c-486e-ab2b-2b42abbf5b23', 2, 0);
INSERT [dbo].[TransactionPendings] ([TrackingId], [Completed], [IsInProgress], [Locked], [LockedBy], [LockedDated], [TriageDate], [TxHash], [Priority], [PoolDate], [WatchingFrom], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [Status], [ErrorTimes]) VALUES (N'ee214749-a344-4e4c-be24-0fb3405a146c', 1, 0, 1, N'9f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:25:35.5533235' AS DateTime2), CAST(N'2023-08-16T12:23:08.1971242' AS DateTime2), N'0x80a726eddc0f6f1afd6c49c643e74780399f49e66cf1c9987802a9db228e7a05', 0, CAST(N'2023-08-16T12:24:00.7443200' AS DateTime2), CAST(N'2023-08-16T12:25:35.0048676' AS DateTime2), N'T-SHIRT-524313', N'{"code":"Cut"}', CAST(N'2023-08-16T12:24:05.0044656' AS DateTime2), 1287, 0, N'{"WaitingSecondsForWatcherTx":90}', 2, N'0x55D64aB19C01e135b86429D9367DfCEE3EF615a3', N'db909755-29d0-4aa4-8815-c77232743991', 2, 0);
INSERT [dbo].[TransactionPendings] ([TrackingId], [Completed], [IsInProgress], [Locked], [LockedBy], [LockedDated], [TriageDate], [TxHash], [Priority], [PoolDate], [WatchingFrom], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [Status], [ErrorTimes]) VALUES (N'83c74c46-56e7-4726-8b4d-2b2f2cdc0e3c', 1, 0, 1, N'8f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:32:36.3552741' AS DateTime2), CAST(N'2023-08-16T12:27:38.1711042' AS DateTime2), N'0x4a1d99fe9f738896798e6f391a09df2b1156df3a013cee713a4eb3cbf6b03509', 0, CAST(N'2023-08-16T12:31:02.4500619' AS DateTime2), CAST(N'2023-08-16T12:32:36.0859885' AS DateTime2), N'SHORT-33412', N'{"code":"Pack"}', CAST(N'2023-08-16T12:31:06.0859520' AS DateTime2), 1287, 0, N'{"WaitingSecondsForWatcherTx":90}', 2, N'0x55D64aB19C01e135b86429D9367DfCEE3EF615a3', N'db909755-29d0-4aa4-8815-c77232743991', 2, 0);
INSERT [dbo].[TransactionPendings] ([TrackingId], [Completed], [IsInProgress], [Locked], [LockedBy], [LockedDated], [TriageDate], [TxHash], [Priority], [PoolDate], [WatchingFrom], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [Status], [ErrorTimes]) VALUES (N'e6c6e511-dc27-4699-8634-41d3a6272be1', 1, 0, 1, N'6f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:32:36.8840938' AS DateTime2), CAST(N'2023-08-16T12:26:21.8487977' AS DateTime2), N'0xf9cacee4eb10c68157acca52cabf8704a4a90ac5140a6616386e516dfdfe865a', 0, CAST(N'2023-08-16T12:31:02.4493855' AS DateTime2), CAST(N'2023-08-16T12:32:36.0689956' AS DateTime2), N'T-SHIRT-524313', N'{"code":"Cut"}', CAST(N'2023-08-16T12:31:06.0681263' AS DateTime2), 81, 0, N'{"WaitingSecondsForWatcherTx":90}', 1, N'0xa0532A56179Eb1677D33709db82de6b5880f23c6', N'8f8e591b-6a9c-486e-ab2b-2b42abbf5b23', 2, 0);
INSERT [dbo].[TransactionPendings] ([TrackingId], [Completed], [IsInProgress], [Locked], [LockedBy], [LockedDated], [TriageDate], [TxHash], [Priority], [PoolDate], [WatchingFrom], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [Status], [ErrorTimes]) VALUES (N'fefbf9b1-cbcb-4b27-870b-70424c040877', 1, 0, 1, N'9f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:32:36.7225642' AS DateTime2), CAST(N'2023-08-16T12:26:34.2935846' AS DateTime2), N'0x563d98734475f362496ad9e0982f31589c5691452f87a67fb41957e9bf8d3e87', 0, CAST(N'2023-08-16T12:31:02.4501342' AS DateTime2), CAST(N'2023-08-16T12:32:36.0777491' AS DateTime2), N'T-SHIRT-524313', N'{"code":"Color"}', CAST(N'2023-08-16T12:31:06.0776983' AS DateTime2), 1287, 0, N'{"WaitingSecondsForWatcherTx":90}', 2, N'0x55D64aB19C01e135b86429D9367DfCEE3EF615a3', N'db909755-29d0-4aa4-8815-c77232743991', 2, 0);
INSERT [dbo].[TransactionPendings] ([TrackingId], [Completed], [IsInProgress], [Locked], [LockedBy], [LockedDated], [TriageDate], [TxHash], [Priority], [PoolDate], [WatchingFrom], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [Status], [ErrorTimes]) VALUES (N'a9f2c797-a71c-46c9-81c2-9d0a52f0bcf4', 1, 0, 1, N'4f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:34:09.4230717' AS DateTime2), CAST(N'2023-08-16T12:26:45.2759749' AS DateTime2), N'0x55c3672b81c4079253544a6f2ba234d99f70dbbe31992613898b64312ed6d369', 0, CAST(N'2023-08-16T12:32:38.5124197' AS DateTime2), CAST(N'2023-08-16T12:34:09.1062983' AS DateTime2), N'T-SHIRT-524313', N'{"code":"Color"}', CAST(N'2023-08-16T12:32:39.1062440' AS DateTime2), 81, 0, N'{"WaitingSecondsForWatcherTx":90}', 1, N'0xa0532A56179Eb1677D33709db82de6b5880f23c6', N'8f8e591b-6a9c-486e-ab2b-2b42abbf5b23', 2, 0);
INSERT [dbo].[TransactionPendings] ([TrackingId], [Completed], [IsInProgress], [Locked], [LockedBy], [LockedDated], [TriageDate], [TxHash], [Priority], [PoolDate], [WatchingFrom], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [Status], [ErrorTimes]) VALUES (N'874aae6a-f0ae-4971-baa6-a471055a87a6', 1, 0, 1, N'2f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:32:37.8931238' AS DateTime2), CAST(N'2023-08-16T12:26:17.2901696' AS DateTime2), N'0x490D4A1B170414FA4770101071260D3A469FD0C4058286929632DAA7BDD15716', 0, CAST(N'2023-08-16T12:31:02.4502063' AS DateTime2), CAST(N'2023-08-16T12:32:37.3479371' AS DateTime2), N'T-SHIRT-524313', N'{"code":"Cut"}', CAST(N'2023-08-16T12:31:07.3478581' AS DateTime2), 9420, 1, N'{"InsertTrackSelectorValue":"0x1ba63d86","ProofSize":125952,"RefTime":4793859072,"BasicWeight":6682666644,"ByteWeight":333333,"SupportedClient":1,"WaitingSecondsForWatcherTx":90}', 4, N'5C557tarfZcHfxAeCLd67wNjuQCiuvaJr23Qd56kPjUxn382', N'51d944e7-cc29-4ca2-9b4d-78a07a503a52', 2, 0);
INSERT [dbo].[TransactionPendings] ([TrackingId], [Completed], [IsInProgress], [Locked], [LockedBy], [LockedDated], [TriageDate], [TxHash], [Priority], [PoolDate], [WatchingFrom], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [Status], [ErrorTimes]) VALUES (N'a677a8f2-e919-4130-b622-ce20cd575965', 1, 0, 1, N'2f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:32:39.0649717' AS DateTime2), CAST(N'2023-08-16T12:27:43.1552264' AS DateTime2), N'0x92FD63171CF99C80FB8074144D3D4C7A51CF3477F8BBAE4DD32A4AF0B8E1B637', 0, CAST(N'2023-08-16T12:31:02.4501986' AS DateTime2), CAST(N'2023-08-16T12:32:38.4860643' AS DateTime2), N'SHORT-33412', N'{"code":"Pack"}', CAST(N'2023-08-16T12:31:08.4858928' AS DateTime2), 9420, 1, N'{"InsertTrackSelectorValue":"0x1ba63d86","ProofSize":125952,"RefTime":4793859072,"BasicWeight":6682666644,"ByteWeight":333333,"SupportedClient":1,"WaitingSecondsForWatcherTx":90}', 4, N'5C557tarfZcHfxAeCLd67wNjuQCiuvaJr23Qd56kPjUxn382', N'51d944e7-cc29-4ca2-9b4d-78a07a503a52', 2, 0);
INSERT [dbo].[TransactionPendings] ([TrackingId], [Completed], [IsInProgress], [Locked], [LockedBy], [LockedDated], [TriageDate], [TxHash], [Priority], [PoolDate], [WatchingFrom], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [Status], [ErrorTimes]) VALUES (N'66c1d54e-3837-4db0-ad25-f03ff7bf20ad', 1, 0, 1, N'2f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:34:10.4342072' AS DateTime2), CAST(N'2023-08-16T12:26:41.6702625' AS DateTime2), N'0xCED81183A511A9ED725D7BEF29B9FC5BCF9E97C5F242363FD07DEBFF4BB693D6', 0, CAST(N'2023-08-16T12:32:38.5125389' AS DateTime2), CAST(N'2023-08-16T12:34:09.7464519' AS DateTime2), N'T-SHIRT-524313', N'{"code":"Color"}', CAST(N'2023-08-16T12:32:39.7464003' AS DateTime2), 9420, 1, N'{"InsertTrackSelectorValue":"0x1ba63d86","ProofSize":125952,"RefTime":4793859072,"BasicWeight":6682666644,"ByteWeight":333333,"SupportedClient":1,"WaitingSecondsForWatcherTx":90}', 4, N'5C557tarfZcHfxAeCLd67wNjuQCiuvaJr23Qd56kPjUxn382', N'51d944e7-cc29-4ca2-9b4d-78a07a503a52', 2, 0);

INSERT [dbo].[TransactionPools] ([TrackingId], [Completed], [Locked], [LockedBy], [LockedDated], [TriageDate], [Priority], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [GeneratingFrom], [Status], [ErrorTimes]) VALUES (N'e452c2e7-8f57-4ad0-8524-091c250c0120', 1, 1, N'4f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:31:03.0371961' AS DateTime2), CAST(N'2023-08-16T12:27:49.0435093' AS DateTime2), 0, N'SHORT-33412', N'{"code":"Pack"}', CAST(N'2023-08-16T12:31:02.3878149' AS DateTime2), 81, 0, N'{"WaitingSecondsForWatcherTx":90}', 1, N'0xa0532A56179Eb1677D33709db82de6b5880f23c6', N'8f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:31:02.3878149' AS DateTime2), 2, 0);
INSERT [dbo].[TransactionPools] ([TrackingId], [Completed], [Locked], [LockedBy], [LockedDated], [TriageDate], [Priority], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [GeneratingFrom], [Status], [ErrorTimes]) VALUES (N'ee214749-a344-4e4c-be24-0fb3405a146c', 1, 1, N'9f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:24:01.7546836' AS DateTime2), CAST(N'2023-08-16T12:23:08.1971242' AS DateTime2), 0, N'T-SHIRT-524313', N'{"code":"Cut"}', CAST(N'2023-08-16T12:24:00.7443200' AS DateTime2), 1287, 0, N'{"WaitingSecondsForWatcherTx":90}', 2, N'0x55D64aB19C01e135b86429D9367DfCEE3EF615a3', N'db909755-29d0-4aa4-8815-c77232743991', CAST(N'2023-08-16T12:24:00.7443200' AS DateTime2), 2, 0);
INSERT [dbo].[TransactionPools] ([TrackingId], [Completed], [Locked], [LockedBy], [LockedDated], [TriageDate], [Priority], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [GeneratingFrom], [Status], [ErrorTimes]) VALUES (N'e7053d76-c6ef-4c4a-b851-2781675cb181', 0, 1, N'1f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:31:07.8911044' AS DateTime2), CAST(N'2023-08-16T12:26:26.8119180' AS DateTime2), 0, N'T-SHIRT-524313', N'{"code":"Cut"}', CAST(N'2023-08-16T12:31:02.4501901' AS DateTime2), 101, 1, N'{"InsertTrackSelectorValue":"0x1ba63d86","InsertTrackProofSize":125952,"InsertTrackRefTime":4793859072,"InsertTrackBasicWeight":14000000000000,"ByteWeight":10000000000000,"SupportedClient":0,"WaitingSecondsForWatcherTx":90}', 3, N'XqLt7FSZrn8nffSGkRYWZKn4JCWZBvHNH3sTRnQL4qDr2Dp', N'71d944e7-cc29-4ca2-9b4d-78a07a503a52', CAST(N'2023-08-16T12:31:02.4501901' AS DateTime2), 3, 0);
INSERT [dbo].[TransactionPools] ([TrackingId], [Completed], [Locked], [LockedBy], [LockedDated], [TriageDate], [Priority], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [GeneratingFrom], [Status], [ErrorTimes]) VALUES (N'83c74c46-56e7-4726-8b4d-2b2f2cdc0e3c', 1, 1, N'8f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:31:03.0372491' AS DateTime2), CAST(N'2023-08-16T12:27:38.1711042' AS DateTime2), 0, N'SHORT-33412', N'{"code":"Pack"}', CAST(N'2023-08-16T12:31:02.4500619' AS DateTime2), 1287, 0, N'{"WaitingSecondsForWatcherTx":90}', 2, N'0x55D64aB19C01e135b86429D9367DfCEE3EF615a3', N'db909755-29d0-4aa4-8815-c77232743991', CAST(N'2023-08-16T12:31:02.4500619' AS DateTime2), 2, 0);
INSERT [dbo].[TransactionPools] ([TrackingId], [Completed], [Locked], [LockedBy], [LockedDated], [TriageDate], [Priority], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [GeneratingFrom], [Status], [ErrorTimes]) VALUES (N'e6c6e511-dc27-4699-8634-41d3a6272be1', 1, 1, N'5f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:31:03.0372577' AS DateTime2), CAST(N'2023-08-16T12:26:21.8487977' AS DateTime2), 0, N'T-SHIRT-524313', N'{"code":"Cut"}', CAST(N'2023-08-16T12:31:02.4493855' AS DateTime2), 81, 0, N'{"WaitingSecondsForWatcherTx":90}', 1, N'0xa0532A56179Eb1677D33709db82de6b5880f23c6', N'8f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:31:02.4493855' AS DateTime2), 2, 0);
INSERT [dbo].[TransactionPools] ([TrackingId], [Completed], [Locked], [LockedBy], [LockedDated], [TriageDate], [Priority], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [GeneratingFrom], [Status], [ErrorTimes]) VALUES (N'fefbf9b1-cbcb-4b27-870b-70424c040877', 1, 1, N'9f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:31:03.0371274' AS DateTime2), CAST(N'2023-08-16T12:26:34.2935846' AS DateTime2), 0, N'T-SHIRT-524313', N'{"code":"Color"}', CAST(N'2023-08-16T12:31:02.4501342' AS DateTime2), 1287, 0, N'{"WaitingSecondsForWatcherTx":90}', 2, N'0x55D64aB19C01e135b86429D9367DfCEE3EF615a3', N'db909755-29d0-4aa4-8815-c77232743991', CAST(N'2023-08-16T12:31:02.4501342' AS DateTime2), 2, 0);
INSERT [dbo].[TransactionPools] ([TrackingId], [Completed], [Locked], [LockedBy], [LockedDated], [TriageDate], [Priority], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [GeneratingFrom], [Status], [ErrorTimes]) VALUES (N'4b331661-80e8-421d-8ea2-9b0f1ca0d703', 0, 1, N'1f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:31:03.0372282' AS DateTime2), CAST(N'2023-08-16T12:27:53.6349895' AS DateTime2), 0, N'SHORT-33412', N'{"code":"Pack"}', CAST(N'2023-08-16T12:31:02.4501787' AS DateTime2), 101, 1, N'{"InsertTrackSelectorValue":"0x1ba63d86","InsertTrackProofSize":125952,"InsertTrackRefTime":4793859072,"InsertTrackBasicWeight":14000000000000,"ByteWeight":10000000000000,"SupportedClient":0,"WaitingSecondsForWatcherTx":90}', 3, N'XqLt7FSZrn8nffSGkRYWZKn4JCWZBvHNH3sTRnQL4qDr2Dp', N'71d944e7-cc29-4ca2-9b4d-78a07a503a52', CAST(N'2023-08-16T12:31:02.4501787' AS DateTime2), 1, 0);
INSERT [dbo].[TransactionPools] ([TrackingId], [Completed], [Locked], [LockedBy], [LockedDated], [TriageDate], [Priority], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [GeneratingFrom], [Status], [ErrorTimes]) VALUES (N'a9f2c797-a71c-46c9-81c2-9d0a52f0bcf4', 1, 1, N'6f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:32:38.5602525' AS DateTime2), CAST(N'2023-08-16T12:26:45.2759749' AS DateTime2), 0, N'T-SHIRT-524313', N'{"code":"Color"}', CAST(N'2023-08-16T12:32:38.5124197' AS DateTime2), 81, 0, N'{"WaitingSecondsForWatcherTx":90}', 1, N'0xa0532A56179Eb1677D33709db82de6b5880f23c6', N'8f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:32:38.5124197' AS DateTime2), 2, 0);
INSERT [dbo].[TransactionPools] ([TrackingId], [Completed], [Locked], [LockedBy], [LockedDated], [TriageDate], [Priority], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [GeneratingFrom], [Status], [ErrorTimes]) VALUES (N'874aae6a-f0ae-4971-baa6-a471055a87a6', 1, 1, N'2f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:31:03.0371995' AS DateTime2), CAST(N'2023-08-16T12:26:17.2901696' AS DateTime2), 0, N'T-SHIRT-524313', N'{"code":"Cut"}', CAST(N'2023-08-16T12:31:02.4502063' AS DateTime2), 9420, 1, N'{"InsertTrackSelectorValue":"0x1ba63d86","ProofSize":125952,"RefTime":4793859072,"BasicWeight":6682666644,"ByteWeight":333333,"SupportedClient":1,"WaitingSecondsForWatcherTx":90}', 4, N'5C557tarfZcHfxAeCLd67wNjuQCiuvaJr23Qd56kPjUxn382', N'51d944e7-cc29-4ca2-9b4d-78a07a503a52', CAST(N'2023-08-16T12:31:02.4502063' AS DateTime2), 2, 0);
INSERT [dbo].[TransactionPools] ([TrackingId], [Completed], [Locked], [LockedBy], [LockedDated], [TriageDate], [Priority], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [GeneratingFrom], [Status], [ErrorTimes]) VALUES (N'a677a8f2-e919-4130-b622-ce20cd575965', 1, 1, N'2f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:31:07.8911044' AS DateTime2), CAST(N'2023-08-16T12:27:43.1552264' AS DateTime2), 0, N'SHORT-33412', N'{"code":"Pack"}', CAST(N'2023-08-16T12:31:02.4501986' AS DateTime2), 9420, 1, N'{"InsertTrackSelectorValue":"0x1ba63d86","ProofSize":125952,"RefTime":4793859072,"BasicWeight":6682666644,"ByteWeight":333333,"SupportedClient":1,"WaitingSecondsForWatcherTx":90}', 4, N'5C557tarfZcHfxAeCLd67wNjuQCiuvaJr23Qd56kPjUxn382', N'51d944e7-cc29-4ca2-9b4d-78a07a503a52', CAST(N'2023-08-16T12:31:02.4501986' AS DateTime2), 2, 0);
INSERT [dbo].[TransactionPools] ([TrackingId], [Completed], [Locked], [LockedBy], [LockedDated], [TriageDate], [Priority], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [GeneratingFrom], [Status], [ErrorTimes]) VALUES (N'66c1d54e-3837-4db0-ad25-f03ff7bf20ad', 1, 1, N'2f8e591b-6a9c-486e-ab2b-2b42abbf5b23', CAST(N'2023-08-16T12:32:39.1709874' AS DateTime2), CAST(N'2023-08-16T12:26:41.6702625' AS DateTime2), 0, N'T-SHIRT-524313', N'{"code":"Color"}', CAST(N'2023-08-16T12:32:38.5125389' AS DateTime2), 9420, 1, N'{"InsertTrackSelectorValue":"0x1ba63d86","ProofSize":125952,"RefTime":4793859072,"BasicWeight":6682666644,"ByteWeight":333333,"SupportedClient":1,"WaitingSecondsForWatcherTx":90}', 4, N'5C557tarfZcHfxAeCLd67wNjuQCiuvaJr23Qd56kPjUxn382', N'51d944e7-cc29-4ca2-9b4d-78a07a503a52', CAST(N'2023-08-16T12:32:38.5125389' AS DateTime2), 2, 0);

INSERT [dbo].[TransactionRegistries] ([TrackingId], [LastTransactionHash], [TransactionStep], [TriageDate], [PendingDate], [PoolDate], [ReceiptBlockHash], [ReceiptBlockNumber], [ReceiptCumulativeGasUsed], [ReceiptEffectiveGasPrice], [ReceiptFrom], [ReceiptGasUsed], [ReceiptTransactionHash], [ReceiptTo], [RegistryDate], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [SmartContractEndpoint], [ErrorTime], [ReceiptReceived], [Status], [TransactionErrorReason]) VALUES (N'e452c2e7-8f57-4ad0-8524-091c250c0120', N'0x29e6585d6aa97ca7c7dc7f7341ab70b970260a44f7e35fff4c05dcce9d7d23b0', 3, CAST(N'2023-08-16T12:27:49.0435093' AS DateTime2), CAST(N'2023-08-16T12:31:08.0977686' AS DateTime2), CAST(N'2023-08-16T12:31:02.5496087' AS DateTime2), N'0x73e1b270eb1945b1818a58971ba5f20f194727656bde222a2d7ab3cd59ef1eb2', N'0x43b81f', N'0x36630', N'0x430ba4e1', N'0x9015f08f8c9ef57090a41818cfcde48fbdd8213a', N'0x1cfce', N'0x29e6585d6aa97ca7c7dc7f7341ab70b970260a44f7e35fff4c05dcce9d7d23b0', N'0xa0532a56179eb1677d33709db82de6b5880f23c6', CAST(N'2023-08-16T12:32:38.2680105' AS DateTime2), N'SHORT-33412', N'{"code":"Pack"}', CAST(N'2023-08-16T12:27:49.0436130' AS DateTime2), 81, 0, N'{"WaitingSecondsForWatcherTx":90}', 1, N'0xa0532A56179Eb1677D33709db82de6b5880f23c6', N'8f8e591b-6a9c-486e-ab2b-2b42abbf5b23', N'https://shibuya.blastapi.io/c8707e18-84fe-4b15-9665-a2897c0687df', 0, 1, 1, NULL);
INSERT [dbo].[TransactionRegistries] ([TrackingId], [LastTransactionHash], [TransactionStep], [TriageDate], [PendingDate], [PoolDate], [ReceiptBlockHash], [ReceiptBlockNumber], [ReceiptCumulativeGasUsed], [ReceiptEffectiveGasPrice], [ReceiptFrom], [ReceiptGasUsed], [ReceiptTransactionHash], [ReceiptTo], [RegistryDate], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [SmartContractEndpoint], [ErrorTime], [ReceiptReceived], [Status], [TransactionErrorReason]) VALUES (N'ee214749-a344-4e4c-be24-0fb3405a146c', N'0x80a726eddc0f6f1afd6c49c643e74780399f49e66cf1c9987802a9db228e7a05', 3, CAST(N'2023-08-16T12:23:08.1971242' AS DateTime2), CAST(N'2023-08-16T12:24:05.1042298' AS DateTime2), CAST(N'2023-08-16T12:24:00.9313752' AS DateTime2), N'0x7d6adf65ea513e837b849b562f7f61c58ed78f27c91f2aed5e19cef50ab7bd20', N'0x4b32b3', N'0x19662', N'0xbb31d29c', N'0xc3cc9704d54722b1e3c7f11ee77064aac2206238', N'0x19662', N'0x80a726eddc0f6f1afd6c49c643e74780399f49e66cf1c9987802a9db228e7a05', N'0x55d64ab19c01e135b86429d9367dfcee3ef615a3', CAST(N'2023-08-16T12:25:36.7607877' AS DateTime2), N'T-SHIRT-524313', N'{"code":"Cut"}', CAST(N'2023-08-16T12:23:08.2854693' AS DateTime2), 1287, 0, N'{"WaitingSecondsForWatcherTx":90}', 2, N'0x55D64aB19C01e135b86429D9367DfCEE3EF615a3', N'db909755-29d0-4aa4-8815-c77232743991', N'https://moonbase-alpha.blastapi.io/4e06bea6-56f2-40e0-a400-2e95f07a87e9', 0, 1, 1, NULL);
INSERT [dbo].[TransactionRegistries] ([TrackingId], [LastTransactionHash], [TransactionStep], [TriageDate], [PendingDate], [PoolDate], [ReceiptBlockHash], [ReceiptBlockNumber], [ReceiptCumulativeGasUsed], [ReceiptEffectiveGasPrice], [ReceiptFrom], [ReceiptGasUsed], [ReceiptTransactionHash], [ReceiptTo], [RegistryDate], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [SmartContractEndpoint], [ErrorTime], [ReceiptReceived], [Status], [TransactionErrorReason]) VALUES (N'e7053d76-c6ef-4c4a-b851-2781675cb181', N'0xC1BB5D8A6A67E2DB7A2F4004D35616082C9DAB470A8DDE4F4F274D3B608B6939', 1, CAST(N'2023-08-16T12:26:26.8119180' AS DateTime2), CAST(N'2023-08-16T12:31:16.5568494' AS DateTime2), CAST(N'2023-08-16T12:31:02.5496454' AS DateTime2), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2023-08-16T12:32:37.2252978' AS DateTime2), N'T-SHIRT-524313', N'{"code":"Cut"}', CAST(N'2023-08-16T12:26:26.8120359' AS DateTime2), 101, 1, N'{"InsertTrackSelectorValue":"0x1ba63d86","InsertTrackProofSize":125952,"InsertTrackRefTime":4793859072,"InsertTrackBasicWeight":14000000000000,"ByteWeight":10000000000000,"SupportedClient":0,"WaitingSecondsForWatcherTx":90}', 3, N'XqLt7FSZrn8nffSGkRYWZKn4JCWZBvHNH3sTRnQL4qDr2Dp', N'71d944e7-cc29-4ca2-9b4d-78a07a503a52', N'wss://shibuya.blastapi.io/c8707e18-84fe-4b15-9665-a2897c0687df', 1, 0, 2, 1);
INSERT [dbo].[TransactionRegistries] ([TrackingId], [LastTransactionHash], [TransactionStep], [TriageDate], [PendingDate], [PoolDate], [ReceiptBlockHash], [ReceiptBlockNumber], [ReceiptCumulativeGasUsed], [ReceiptEffectiveGasPrice], [ReceiptFrom], [ReceiptGasUsed], [ReceiptTransactionHash], [ReceiptTo], [RegistryDate], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [SmartContractEndpoint], [ErrorTime], [ReceiptReceived], [Status], [TransactionErrorReason]) VALUES (N'83c74c46-56e7-4726-8b4d-2b2f2cdc0e3c', N'0x4a1d99fe9f738896798e6f391a09df2b1156df3a013cee713a4eb3cbf6b03509', 3, CAST(N'2023-08-16T12:27:38.1711042' AS DateTime2), CAST(N'2023-08-16T12:31:06.5410359' AS DateTime2), CAST(N'2023-08-16T12:31:02.5496455' AS DateTime2), N'0xf8cd0f0c63da6e022c32c97b1a37acc356607a64cd57159eb75f72e5f0cd5a63', N'0x4b32d2', N'0x944ce', N'0xc1b213c', N'0xa2c09c397d2e4bec5edf0700ab4dd5f612ad492a', N'0x1cfce', N'0x4a1d99fe9f738896798e6f391a09df2b1156df3a013cee713a4eb3cbf6b03509', N'0x55d64ab19c01e135b86429d9367dfcee3ef615a3', CAST(N'2023-08-16T12:32:37.1009315' AS DateTime2), N'SHORT-33412', N'{"code":"Pack"}', CAST(N'2023-08-16T12:27:38.1711837' AS DateTime2), 1287, 0, N'{"WaitingSecondsForWatcherTx":90}', 2, N'0x55D64aB19C01e135b86429D9367DfCEE3EF615a3', N'db909755-29d0-4aa4-8815-c77232743991', N'https://moonbase-alpha.blastapi.io/11cd5d86-565d-4b84-9cac-84cd08511215', 0, 1, 1, NULL);
INSERT [dbo].[TransactionRegistries] ([TrackingId], [LastTransactionHash], [TransactionStep], [TriageDate], [PendingDate], [PoolDate], [ReceiptBlockHash], [ReceiptBlockNumber], [ReceiptCumulativeGasUsed], [ReceiptEffectiveGasPrice], [ReceiptFrom], [ReceiptGasUsed], [ReceiptTransactionHash], [ReceiptTo], [RegistryDate], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [SmartContractEndpoint], [ErrorTime], [ReceiptReceived], [Status], [TransactionErrorReason]) VALUES (N'e6c6e511-dc27-4699-8634-41d3a6272be1', N'0xf9cacee4eb10c68157acca52cabf8704a4a90ac5140a6616386e516dfdfe865a', 3, CAST(N'2023-08-16T12:26:21.8487977' AS DateTime2), CAST(N'2023-08-16T12:31:06.5410329' AS DateTime2), CAST(N'2023-08-16T12:31:02.5496456' AS DateTime2), N'0x73e1b270eb1945b1818a58971ba5f20f194727656bde222a2d7ab3cd59ef1eb2', N'0x43b81f', N'0x19662', N'0x430ba4e1', N'0xb2e4aefb46e4d71771aa4da4e359100083f544f0', N'0x19662', N'0xf9cacee4eb10c68157acca52cabf8704a4a90ac5140a6616386e516dfdfe865a', N'0xa0532a56179eb1677d33709db82de6b5880f23c6', CAST(N'2023-08-16T12:32:37.1009241' AS DateTime2), N'T-SHIRT-524313', N'{"code":"Cut"}', CAST(N'2023-08-16T12:26:21.8492700' AS DateTime2), 81, 0, N'{"WaitingSecondsForWatcherTx":90}', 1, N'0xa0532A56179Eb1677D33709db82de6b5880f23c6', N'8f8e591b-6a9c-486e-ab2b-2b42abbf5b23', N'https://shibuya.blastapi.io/7a2921d5-7c0c-411d-b687-4ba57cfbff25', 0, 1, 1, NULL);
INSERT [dbo].[TransactionRegistries] ([TrackingId], [LastTransactionHash], [TransactionStep], [TriageDate], [PendingDate], [PoolDate], [ReceiptBlockHash], [ReceiptBlockNumber], [ReceiptCumulativeGasUsed], [ReceiptEffectiveGasPrice], [ReceiptFrom], [ReceiptGasUsed], [ReceiptTransactionHash], [ReceiptTo], [RegistryDate], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [SmartContractEndpoint], [ErrorTime], [ReceiptReceived], [Status], [TransactionErrorReason]) VALUES (N'69ce0fa9-04a6-47a6-88a5-6c1c3f5ab001', NULL, 0, CAST(N'2023-08-16T12:26:49.1972454' AS DateTime2), CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2023-08-16T12:32:37.1252978' AS DateTime2), N'T-SHIRT-524313', N'{"code":"Color"}', CAST(N'2023-08-16T12:26:49.1974106' AS DateTime2), 101, 1, N'{"InsertTrackSelectorValue":"0x1ba63d86","InsertTrackProofSize":125952,"InsertTrackRefTime":4793859072,"InsertTrackBasicWeight":14000000000000,"ByteWeight":10000000000000,"SupportedClient":0,"WaitingSecondsForWatcherTx":90}', 3, N'XqLt7FSZrn8nffSGkRYWZKn4JCWZBvHNH3sTRnQL4qDr2Dp', N'71d944e7-cc29-4ca2-9b4d-78a07a503a52', NULL, 0, 0, 0, NULL)
INSERT [dbo].[TransactionRegistries] ([TrackingId], [LastTransactionHash], [TransactionStep], [TriageDate], [PendingDate], [PoolDate], [ReceiptBlockHash], [ReceiptBlockNumber], [ReceiptCumulativeGasUsed], [ReceiptEffectiveGasPrice], [ReceiptFrom], [ReceiptGasUsed], [ReceiptTransactionHash], [ReceiptTo], [RegistryDate], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [SmartContractEndpoint], [ErrorTime], [ReceiptReceived], [Status], [TransactionErrorReason]) VALUES (N'fefbf9b1-cbcb-4b27-870b-70424c040877', N'0x563d98734475f362496ad9e0982f31589c5691452f87a67fb41957e9bf8d3e87', 3, CAST(N'2023-08-16T12:26:34.2935846' AS DateTime2), CAST(N'2023-08-16T12:31:06.5410426' AS DateTime2), CAST(N'2023-08-16T12:31:02.5496457' AS DateTime2), N'0xf8cd0f0c63da6e022c32c97b1a37acc356607a64cd57159eb75f72e5f0cd5a63', N'0x4b32d2', N'0x77500', N'0xc1b213c', N'0xc3cc9704d54722b1e3c7f11ee77064aac2206238', N'0x1967a', N'0x563d98734475f362496ad9e0982f31589c5691452f87a67fb41957e9bf8d3e87', N'0x55d64ab19c01e135b86429d9367dfcee3ef615a3', CAST(N'2023-08-16T12:32:37.1009742' AS DateTime2), N'T-SHIRT-524313', N'{"code":"Color"}', CAST(N'2023-08-16T12:26:34.2936577' AS DateTime2), 1287, 0, N'{"WaitingSecondsForWatcherTx":90}', 2, N'0x55D64aB19C01e135b86429D9367DfCEE3EF615a3', N'db909755-29d0-4aa4-8815-c77232743991', N'https://moonbase-alpha.blastapi.io/4e06bea6-56f2-40e0-a400-2e95f07a87e9', 0, 1, 1, NULL);
INSERT [dbo].[TransactionRegistries] ([TrackingId], [LastTransactionHash], [TransactionStep], [TriageDate], [PendingDate], [PoolDate], [ReceiptBlockHash], [ReceiptBlockNumber], [ReceiptCumulativeGasUsed], [ReceiptEffectiveGasPrice], [ReceiptFrom], [ReceiptGasUsed], [ReceiptTransactionHash], [ReceiptTo], [RegistryDate], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [SmartContractEndpoint], [ErrorTime], [ReceiptReceived], [Status], [TransactionErrorReason]) VALUES (N'4b331661-80e8-421d-8ea2-9b0f1ca0d703', N'0x787E002A2D99059DF0B73B10CB6C8874188D6AE370B681E3515BE71DCB1B6E49', 1, CAST(N'2023-08-16T12:27:53.6349895' AS DateTime2), CAST(N'2023-08-16T12:31:07.3438758' AS DateTime2), CAST(N'2023-08-16T12:31:02.5496458' AS DateTime2), NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, CAST(N'2023-08-16T12:32:37.4252978' AS DateTime2), N'SHORT-33412', N'{"code":"Pack"}', CAST(N'2023-08-16T12:27:53.6354196' AS DateTime2), 101, 1, N'{"InsertTrackSelectorValue":"0x1ba63d86","InsertTrackProofSize":125952,"InsertTrackRefTime":4793859072,"InsertTrackBasicWeight":14000000000000,"ByteWeight":10000000000000,"SupportedClient":0,"WaitingSecondsForWatcherTx":90}', 3, N'XqLt7FSZrn8nffSGkRYWZKn4JCWZBvHNH3sTRnQL4qDr2Dp', N'71d944e7-cc29-4ca2-9b4d-78a07a503a52', N'wss://shibuya.blastapi.io/c8707e18-84fe-4b15-9665-a2897c0687df', 0, 0, 0, NULL);
INSERT [dbo].[TransactionRegistries] ([TrackingId], [LastTransactionHash], [TransactionStep], [TriageDate], [PendingDate], [PoolDate], [ReceiptBlockHash], [ReceiptBlockNumber], [ReceiptCumulativeGasUsed], [ReceiptEffectiveGasPrice], [ReceiptFrom], [ReceiptGasUsed], [ReceiptTransactionHash], [ReceiptTo], [RegistryDate], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [SmartContractEndpoint], [ErrorTime], [ReceiptReceived], [Status], [TransactionErrorReason]) VALUES (N'a9f2c797-a71c-46c9-81c2-9d0a52f0bcf4', N'0x55c3672b81c4079253544a6f2ba234d99f70dbbe31992613898b64312ed6d369', 3, CAST(N'2023-08-16T12:26:45.2759749' AS DateTime2), CAST(N'2023-08-16T12:32:39.1106690' AS DateTime2), CAST(N'2023-08-16T12:32:38.5172087' AS DateTime2), N'0x8720e5aed095d3344c2aa72c532440070e784c4bdc8b4d2e152923e732a5c013', N'0x43b826', N'0x1967a', N'0x430ba4e1', N'0xeb056f3289960361c6ccdd5426e5899df10f949d', N'0x1967a', N'0x55c3672b81c4079253544a6f2ba234d99f70dbbe31992613898b64312ed6d369', N'0xa0532a56179eb1677d33709db82de6b5880f23c6', CAST(N'2023-08-16T12:34:09.6295281' AS DateTime2), N'T-SHIRT-524313', N'{"code":"Color"}', CAST(N'2023-08-16T12:26:45.2760460' AS DateTime2), 81, 0, N'{"WaitingSecondsForWatcherTx":90}', 1, N'0xa0532A56179Eb1677D33709db82de6b5880f23c6', N'8f8e591b-6a9c-486e-ab2b-2b42abbf5b23', N'https://shibuya.blastapi.io/c8707e18-84fe-4b15-9665-a2897c0687df', 0, 1, 1, NULL);
INSERT [dbo].[TransactionRegistries] ([TrackingId], [LastTransactionHash], [TransactionStep], [TriageDate], [PendingDate], [PoolDate], [ReceiptBlockHash], [ReceiptBlockNumber], [ReceiptCumulativeGasUsed], [ReceiptEffectiveGasPrice], [ReceiptFrom], [ReceiptGasUsed], [ReceiptTransactionHash], [ReceiptTo], [RegistryDate], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [SmartContractEndpoint], [ErrorTime], [ReceiptReceived], [Status], [TransactionErrorReason]) VALUES (N'874aae6a-f0ae-4971-baa6-a471055a87a6', N'0x490D4A1B170414FA4770101071260D3A469FD0C4058286929632DAA7BDD15716', 3, CAST(N'2023-08-16T12:26:17.2901696' AS DateTime2), CAST(N'2023-08-16T12:31:07.3527928' AS DateTime2), CAST(N'2023-08-16T12:31:02.5496460' AS DateTime2), N'', N'', N'', N'', N'', N'', N'', N'', CAST(N'2023-08-16T12:32:37.9252978' AS DateTime2), N'T-SHIRT-524313', N'{"code":"Cut"}', CAST(N'2023-08-16T12:26:17.3290886' AS DateTime2), 9420, 1, N'{"InsertTrackSelectorValue":"0x1ba63d86","ProofSize":125952,"RefTime":4793859072,"BasicWeight":6682666644,"ByteWeight":333333,"SupportedClient":1,"WaitingSecondsForWatcherTx":90}', 4, N'5C557tarfZcHfxAeCLd67wNjuQCiuvaJr23Qd56kPjUxn382', N'51d944e7-cc29-4ca2-9b4d-78a07a503a52', N'wss://rococo-contracts-rpc.polkadot.io', 0, 0, 1, NULL);
INSERT [dbo].[TransactionRegistries] ([TrackingId], [LastTransactionHash], [TransactionStep], [TriageDate], [PendingDate], [PoolDate], [ReceiptBlockHash], [ReceiptBlockNumber], [ReceiptCumulativeGasUsed], [ReceiptEffectiveGasPrice], [ReceiptFrom], [ReceiptGasUsed], [ReceiptTransactionHash], [ReceiptTo], [RegistryDate], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [SmartContractEndpoint], [ErrorTime], [ReceiptReceived], [Status], [TransactionErrorReason]) VALUES (N'a677a8f2-e919-4130-b622-ce20cd575965', N'0x92FD63171CF99C80FB8074144D3D4C7A51CF3477F8BBAE4DD32A4AF0B8E1B637', 3, CAST(N'2023-08-16T12:27:43.1552264' AS DateTime2), CAST(N'2023-08-16T12:31:08.4894871' AS DateTime2), CAST(N'2023-08-16T12:31:02.5496461' AS DateTime2), N'', N'', N'', N'', N'', N'', N'', N'', CAST(N'2023-08-16T12:32:39.0769662' AS DateTime2), N'SHORT-33412', N'{"code":"Pack"}', CAST(N'2023-08-16T12:27:43.1553452' AS DateTime2), 9420, 1, N'{"InsertTrackSelectorValue":"0x1ba63d86","ProofSize":125952,"RefTime":4793859072,"BasicWeight":6682666644,"ByteWeight":333333,"SupportedClient":1,"WaitingSecondsForWatcherTx":90}', 4, N'5C557tarfZcHfxAeCLd67wNjuQCiuvaJr23Qd56kPjUxn382', N'51d944e7-cc29-4ca2-9b4d-78a07a503a52', N'wss://rococo-contracts-rpc.polkadot.io', 0, 0, 1, NULL);
INSERT [dbo].[TransactionRegistries] ([TrackingId], [LastTransactionHash], [TransactionStep], [TriageDate], [PendingDate], [PoolDate], [ReceiptBlockHash], [ReceiptBlockNumber], [ReceiptCumulativeGasUsed], [ReceiptEffectiveGasPrice], [ReceiptFrom], [ReceiptGasUsed], [ReceiptTransactionHash], [ReceiptTo], [RegistryDate], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId], [SmartContractEndpoint], [ErrorTime], [ReceiptReceived], [Status], [TransactionErrorReason]) VALUES (N'66c1d54e-3837-4db0-ad25-f03ff7bf20ad', N'0xCED81183A511A9ED725D7BEF29B9FC5BCF9E97C5F242363FD07DEBFF4BB693D6', 3, CAST(N'2023-08-16T12:26:41.6702625' AS DateTime2), CAST(N'2023-08-16T12:32:39.7490289' AS DateTime2), CAST(N'2023-08-16T12:32:38.5172088' AS DateTime2), N'', N'', N'', N'', N'', N'', N'', N'', CAST(N'2023-08-16T12:34:10.4603787' AS DateTime2), N'T-SHIRT-524313', N'{"code":"Color"}', CAST(N'2023-08-16T12:26:41.6703900' AS DateTime2), 9420, 1, N'{"InsertTrackSelectorValue":"0x1ba63d86","ProofSize":125952,"RefTime":4793859072,"BasicWeight":6682666644,"ByteWeight":333333,"SupportedClient":1,"WaitingSecondsForWatcherTx":90}', 4, N'5C557tarfZcHfxAeCLd67wNjuQCiuvaJr23Qd56kPjUxn382', N'51d944e7-cc29-4ca2-9b4d-78a07a503a52', N'wss://rococo-contracts-rpc.polkadot.io', 0, 0, 1, NULL);

SET IDENTITY_INSERT [dbo].[TransactionTriages] ON; 

INSERT [dbo].[TransactionTriages] ([Id], [Completed], [IsInPool], [TrackingIdentify], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId]) VALUES (1, 1, 1, N'ee214749-a344-4e4c-be24-0fb3405a146c', N'T-SHIRT-524313', N'{"code":"Cut"}', CAST(N'2023-08-16T12:23:08.1971242' AS DateTime2), 1287, 0, N'{"WaitingSecondsForWatcherTx":90}', 2, N'0x55D64aB19C01e135b86429D9367DfCEE3EF615a3', N'db909755-29d0-4aa4-8815-c77232743991');
INSERT [dbo].[TransactionTriages] ([Id], [Completed], [IsInPool], [TrackingIdentify], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId]) VALUES (2, 1, 1, N'874aae6a-f0ae-4971-baa6-a471055a87a6', N'T-SHIRT-524313', N'{"code":"Cut"}', CAST(N'2023-08-16T12:26:17.2901696' AS DateTime2), 9420, 1, N'{"InsertTrackSelectorValue":"0x1ba63d86","ProofSize":125952,"RefTime":4793859072,"BasicWeight":6682666644,"ByteWeight":333333,"SupportedClient":1,"WaitingSecondsForWatcherTx":90}', 4, N'5C557tarfZcHfxAeCLd67wNjuQCiuvaJr23Qd56kPjUxn382', N'51d944e7-cc29-4ca2-9b4d-78a07a503a52');
INSERT [dbo].[TransactionTriages] ([Id], [Completed], [IsInPool], [TrackingIdentify], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId]) VALUES (3, 1, 1, N'e6c6e511-dc27-4699-8634-41d3a6272be1', N'T-SHIRT-524313', N'{"code":"Cut"}', CAST(N'2023-08-16T12:26:21.8487977' AS DateTime2), 81, 0, N'{"WaitingSecondsForWatcherTx":90}', 1, N'0xa0532A56179Eb1677D33709db82de6b5880f23c6', N'8f8e591b-6a9c-486e-ab2b-2b42abbf5b23');
INSERT [dbo].[TransactionTriages] ([Id], [Completed], [IsInPool], [TrackingIdentify], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId]) VALUES (4, 0, 1, N'e7053d76-c6ef-4c4a-b851-2781675cb181', N'T-SHIRT-524313', N'{"code":"Cut"}', CAST(N'2023-08-16T12:26:26.8119180' AS DateTime2), 101, 1, N'{"InsertTrackSelectorValue":"0x1ba63d86","InsertTrackProofSize":125952,"InsertTrackRefTime":4793859072,"InsertTrackBasicWeight":14000000000000,"ByteWeight":10000000000000,"SupportedClient":0,"WaitingSecondsForWatcherTx":90}', 3, N'XqLt7FSZrn8nffSGkRYWZKn4JCWZBvHNH3sTRnQL4qDr2Dp', N'71d944e7-cc29-4ca2-9b4d-78a07a503a52');
INSERT [dbo].[TransactionTriages] ([Id], [Completed], [IsInPool], [TrackingIdentify], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId]) VALUES (5, 1, 1, N'fefbf9b1-cbcb-4b27-870b-70424c040877', N'T-SHIRT-524313', N'{"code":"Color"}', CAST(N'2023-08-16T12:26:34.2935846' AS DateTime2), 1287, 0, N'{"WaitingSecondsForWatcherTx":90}', 2, N'0x55D64aB19C01e135b86429D9367DfCEE3EF615a3', N'db909755-29d0-4aa4-8815-c77232743991');
INSERT [dbo].[TransactionTriages] ([Id], [Completed], [IsInPool], [TrackingIdentify], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId]) VALUES (6, 1, 1, N'66c1d54e-3837-4db0-ad25-f03ff7bf20ad', N'T-SHIRT-524313', N'{"code":"Color"}', CAST(N'2023-08-16T12:26:41.6702625' AS DateTime2), 9420, 1, N'{"InsertTrackSelectorValue":"0x1ba63d86","ProofSize":125952,"RefTime":4793859072,"BasicWeight":6682666644,"ByteWeight":333333,"SupportedClient":1,"WaitingSecondsForWatcherTx":90}', 4, N'5C557tarfZcHfxAeCLd67wNjuQCiuvaJr23Qd56kPjUxn382', N'51d944e7-cc29-4ca2-9b4d-78a07a503a52');
INSERT [dbo].[TransactionTriages] ([Id], [Completed], [IsInPool], [TrackingIdentify], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId]) VALUES (7, 1, 1, N'a9f2c797-a71c-46c9-81c2-9d0a52f0bcf4', N'T-SHIRT-524313', N'{"code":"Color"}', CAST(N'2023-08-16T12:26:45.2759749' AS DateTime2), 81, 0, N'{"WaitingSecondsForWatcherTx":90}', 1, N'0xa0532A56179Eb1677D33709db82de6b5880f23c6', N'8f8e591b-6a9c-486e-ab2b-2b42abbf5b23');
INSERT [dbo].[TransactionTriages] ([Id], [Completed], [IsInPool], [TrackingIdentify], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId]) VALUES (8, 0, 0, N'69ce0fa9-04a6-47a6-88a5-6c1c3f5ab001', N'T-SHIRT-524313', N'{"code":"Color"}', CAST(N'2023-08-16T12:26:49.1972454' AS DateTime2), 101, 1, N'{"InsertTrackSelectorValue":"0x1ba63d86","InsertTrackProofSize":125952,"InsertTrackRefTime":4793859072,"InsertTrackBasicWeight":14000000000000,"ByteWeight":10000000000000,"SupportedClient":0,"WaitingSecondsForWatcherTx":90}', 3, N'XqLt7FSZrn8nffSGkRYWZKn4JCWZBvHNH3sTRnQL4qDr2Dp', N'71d944e7-cc29-4ca2-9b4d-78a07a503a52');
INSERT [dbo].[TransactionTriages] ([Id], [Completed], [IsInPool], [TrackingIdentify], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId]) VALUES (9, 1, 1, N'83c74c46-56e7-4726-8b4d-2b2f2cdc0e3c', N'SHORT-33412', N'{"code":"Pack"}', CAST(N'2023-08-16T12:27:38.1711042' AS DateTime2), 1287, 0, N'{"WaitingSecondsForWatcherTx":90}', 2, N'0x55D64aB19C01e135b86429D9367DfCEE3EF615a3', N'db909755-29d0-4aa4-8815-c77232743991');
INSERT [dbo].[TransactionTriages] ([Id], [Completed], [IsInPool], [TrackingIdentify], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId]) VALUES (10, 1, 1, N'a677a8f2-e919-4130-b622-ce20cd575965', N'SHORT-33412', N'{"code":"Pack"}', CAST(N'2023-08-16T12:27:43.1552264' AS DateTime2), 9420, 1, N'{"InsertTrackSelectorValue":"0x1ba63d86","ProofSize":125952,"RefTime":4793859072,"BasicWeight":6682666644,"ByteWeight":333333,"SupportedClient":1,"WaitingSecondsForWatcherTx":90}', 4, N'5C557tarfZcHfxAeCLd67wNjuQCiuvaJr23Qd56kPjUxn382', N'51d944e7-cc29-4ca2-9b4d-78a07a503a52');
INSERT [dbo].[TransactionTriages] ([Id], [Completed], [IsInPool], [TrackingIdentify], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId]) VALUES (11, 1, 1, N'e452c2e7-8f57-4ad0-8524-091c250c0120', N'SHORT-33412', N'{"code":"Pack"}', CAST(N'2023-08-16T12:27:49.0435093' AS DateTime2), 81, 0, N'{"WaitingSecondsForWatcherTx":90}', 1, N'0xa0532A56179Eb1677D33709db82de6b5880f23c6', N'8f8e591b-6a9c-486e-ab2b-2b42abbf5b23');
INSERT [dbo].[TransactionTriages] ([Id], [Completed], [IsInPool], [TrackingIdentify], [Code], [DataValue], [ReceivedDate], [ChainNumberId], [ChainType], [SmartContractExtraInfo], [SmartContractId], [SmartContractAddress], [ProfileGroupId]) VALUES (12, 0, 1, N'4b331661-80e8-421d-8ea2-9b0f1ca0d703', N'SHORT-33412', N'{"code":"Pack"}', CAST(N'2023-08-16T12:27:53.6349895' AS DateTime2), 101, 1, N'{"InsertTrackSelectorValue":"0x1ba63d86","InsertTrackProofSize":125952,"InsertTrackRefTime":4793859072,"InsertTrackBasicWeight":14000000000000,"ByteWeight":10000000000000,"SupportedClient":0,"WaitingSecondsForWatcherTx":90}', 3, N'XqLt7FSZrn8nffSGkRYWZKn4JCWZBvHNH3sTRnQL4qDr2Dp', N'71d944e7-cc29-4ca2-9b4d-78a07a503a52');

SET IDENTITY_INSERT [dbo].[TransactionTriages] OFF;

INSERT INTO [dbo].[Reports] ([Id],[Created],[Description],[Priority],[Reported],[Type],[TrackingId],[ReportDataId]) VALUES ('ABFD2495-C340-4D9A-5D7E-08DBAFC9103A','2023-09-07 17:37:09.8499494','Exceed Retry Limit ErrorTimes: 5	ErrorAfterReTry: 5',0,0,7,'E7053D76-C6EF-4C4A-B851-2781675CB181',NULL)

Run Web Application

  1. Download the "Web Application" service from releases page on GitHub. Make sure you download the latest version, but always check if there are any new released versions.
  2. The guide below is based on a Unix operating system, but the same steps can be followed on Windows and Mac.
  3. After downloading the package, the file to get is web-application-v0.4.0-alpha-linuxselfcontained.tar.gz. This package has been chosen as "selfcontained", so you won't need to install the .NET runtime on the machine where the service will run.
mkdir TrackingChain
cd TrackingChain
wget https://github.com/TrackingChains/TrackingChain/releases/download/v0.4.0-alpha/web-application-v0.4.0-alpha-linuxselfcontained.tar.gz
tar xzvf web-application-v0.4.0-alpha-linuxselfcontained.tar.gz
cd web-application-v0.4.0-alpha-linuxselfcontained

Once the package has been extracted, you should end up with a number of files and folders, including the "WebApplication" service executable and the appsettings.json configuration file.

  1. Open and edit the appsettings.json file with the correct configuration for your database:
"Database": {
    "DbType": "system.data.sqlclient",
    "ConnectionString": "Data Source=; Initial Catalog=;Trusted_Connection=True;",
    "UseMigrationScript": false
  }
  1. To create a database called "TrackingChain" and configure your SQL server reachable at address localhost on port 5533, you will need to make the following changes:
"Database": {
    "DbType": "system.data.sqlclient",
    "ConnectionString": "Server=localhost,5533;Database=TrackingChain;User Id=sa;Password=YourStrong@Passw0rd;TrustServerCertificate=True;",
    "UseMigrationScript": false
  }

For more information about ConnectionStrings you can consult https://www.connectionstrings.com/sql-server/

  1. Launch the "TrackingChain WebApp":
./TrackingChain.WebApp --urls http://0.0.0.0:12345

WebApplication_01

FrontEnd Configuration

The purpose of the configuration is to associate the incoming Tracking requests to the Triage to specific SmartContracts. Each Tracking is associated with a profile via the Category field (further developments are expected in the future to also manage the Authority and AggregationCode fields). Each Profile is associated with a Smart Contract on which the Tracking will be saved. The next step is to associate an Account with a Profile. This account will be used to write to the Smart Contract associated with the Profile.

Account

Is the user who will execute the transaction in the smart contract. The AccountId generated by the creation of the account must be used in the appsetting.json configuration of the "TransactionGenerator.Worker" and "TransactionMonitor.Worker" service, in this way the user will be operational and will be able to start making transactions when a Tracking associated with his Profile Group will arrive.

Smart Contract

Contain details of smart contracts to be used for tracking. Such as the address of the smart contract, type (Ink, EVM) and some ExtraInfo parameters inserted as Json (there is an issue to improve the insertion of this parameter in the future).

Profile Group

The group profile is used to associate the Tracking entering the Triage to a SmartContract, at the moment the only discriminating factor is given by the Category field (which is one of the parameters entering the triage in addition to the Code and Value).

Link Account to Profile Groups

In this configuration we relate an Account to a Profile Group. In this way, when an incoming Tracking is associated with a Profile Group, one of the Accounts that are linked to that profile will be able to take the Tracking and carry out the operations on chain.

Example One

In the configuration provided we have a "Rococo Test Ink" account which is associated with the "Substrate Ink Contract Rococo" profile, which points to the smart contract "Contract Rococo Test Net INK". Suppose the workload is too large and a single account is no longer sufficient, we will show how to insert a new account so that it can parallelize requests.

  1. Creating a new Account named "Second Rococo Test Ink". (Suppose the random id created is B23B617A-1CAC-4AD6-8884-338B24D82734)
  2. Link Account to Profile Groups with: Account "Second Rococo Test Ink" and Profile "Substrate Ink Contract Rococo"

We now have two Accounts associated with the same Profile. To activate the new account it must be inserted in the configuration of the "TransactionGenerator.Worker" and "TransactionMonitor.Worker", by editing the appsettings.json file.

  "Dequeuer": {
    "Accounts": [
      "1F8E591B-6A9C-486E-AB2B-2B42ABBF5B23",
      "2F8E591B-6A9C-486E-AB2B-2B42ABBF5B23",
      "4F8E591B-6A9C-486E-AB2B-2B42ABBF5B23",
      "5F8E591B-6A9C-486E-AB2B-2B42ABBF5B23",
      "6F8E591B-6A9C-486E-AB2B-2B42ABBF5B23",
      "8F8E591B-6A9C-486E-AB2B-2B42ABBF5B23",
      "9F8E591B-6A9C-486E-AB2B-2B42ABBF5B23",
      "B23B617A-1CAC-4AD6-8884-338B24D82734"   <------ THIS IS THE NEW ACCOUNT ID
    ]
  }

If the machine running the "TransactionGenerator.Worker" or "TransactionMonitor.Worker" should handle loads that are too large, it is possible to launch multiple instances on different machines, in order to handle smaller loads (very useful when you are under kubernetes ). In this case instead of modifying the appsettings.josn configuration you will have to put it on a new machine and the configuration will be:

First instance:

  "Dequeuer": {
    "Accounts": [
      "1F8E591B-6A9C-486E-AB2B-2B42ABBF5B23",
      "2F8E591B-6A9C-486E-AB2B-2B42ABBF5B23",
      "4F8E591B-6A9C-486E-AB2B-2B42ABBF5B23",
      "5F8E591B-6A9C-486E-AB2B-2B42ABBF5B23",
      "6F8E591B-6A9C-486E-AB2B-2B42ABBF5B23",
      "8F8E591B-6A9C-486E-AB2B-2B42ABBF5B23",
      "9F8E591B-6A9C-486E-AB2B-2B42ABBF5B23"
    ]
  }

Second instance:

  "Dequeuer": {
    "Accounts": [
      "B23B617A-1CAC-4AD6-8884-338B24D82734"   <------ THIS IS THE NEW ACCOUNT ID
    ]
  }

Example Two

Let's suppose that in the currently used smart contract there is too much data and therefore you prefer to divide the load on several smart contracts (both in the usual chain "Rococo" and accessible from the same account "Rococo Test Ink").

  1. Deploy Ink SmartContract (Suppose the address of smart created is XqGt8FSZrn8nffSGkRYWZKn4JCWZBvXMH3sTRnRL4qpr2aD)
  2. Go to "Admin Tools" in "Smartcontract" section and Add new Smartcontract, it will have the sameconfigurations of the one already present "Contract Rococo Test Net INK". Only the address and name will be changed.
    • Address: XqGt8FSZrn8nffSGkRYWZKn4JCWZBvXMH3sTRnRL4qpr2aD
    • SmartContractId: "Second Contract Rococo Test Net INK"
  3. Go to "Admin Tools" in "Profile Groups" create a new with:
    • SmartContractId: "Second Contract Rococo Test Net INK"
    • Category: "Second Rococo Ink"
    • Name: "Second Rococo Profile"
    • Priority: 0
  4. Go to "Admin Tools" in "Link Account To Profile" create a new with:
    • Name: "Another Rococo Link"
    • AccountId: "Rococo Test Ink"
    • ProfileGroupId: "Second Rococo Profile"
    • Priority: 0

Now all the entries entering the triage that contain the "Second Rococo Ink" value in the category will be inserted in the smart contract with address "XqGt8FSZrn8nffSGkRYWZKn4JCWZBvXMH3sTRnRL4qpr2aD" and the inserts will be made from the "Rococo Test Ink" account.
Note that it is not necessary to configure any appsettings.json because the account used is already present.

FrontEnd Demo

By accessing the Web Application through your browser, you'll now be able to view all the pages. Here are a few example screenshots:

View Data

In this interface, you can observe how to retrieve data using either the TrackingId or the combination of Code + SmartContract. The data available varies based on the chosen SmartContract, influencing the outcome. (66C1D54E-3837-4DB0-AD25-F03FF7BF20AD)

SearchTrack_One

Search by TrackingId, the one sought is highlighted and its entire history is shown

SearchTrack_Two

Now let's show that searching for the other TrackingId the result will be the same (only the selection changes) (874AAE6A-F0AE-4971-BAA6-A471055A87A6)

SearchTrack_Three

Search by code (it is not possible to highlight any specific tracking) (T-SHIRT-524313)

SearchTrack_Four

Search by Code and different SmartContract (T-SHIRT-524313)

SearchTrack_Five

Search by Code and different SmartContract

Monitor

Monitor

Admin Page

AdminLink

SmartContract List

SmartContract

Transaction Registry List

Registries