`Search collections, actions...
COLLECTIONS
Show all (12)
SQL COLLECTIONS
SQL Collection
Blend multiple collections across different data sources into a single table with custom SQL
Create with SQL query
Search data…
ID
BATCH/LOT ID
BOOKING ID
PROCUREMENT (FROM BOOKING ID)
LOT ID
COUNT
QUANTITY
QUALITY
PRICE/KG
TOTAL PURCHASE COST
ONFLOOR
CREATED TIME
ARRIVAL DATE
NEW COLUMN
recvm2TU7rB4dVxTS
SF-132
B-005
recdqPmSucL7hFFZT
SF-132
164
11,902.10
L/S
INR 153
INR1.82m
07/05/2023 13:24
recso2BPeZcVJo82g
SF-135
B-008
recLQAkRXQzOOlIdH
SF-135
125
1,432
L/S
INR 190
INR272.08k
07/05/2023 13:24
recsLXZ1Z0eDnzY3e
SF-129
B-002
recngJgxLnefQyjly
SF-129
70.4
52
Necrosis
INR 124.50
INR6.47k
07/05/2023 13:24
recsGdXWdNytgbzTI
SF-137
B-0010
SF-137
94.5
876.80
L/S
INR 228
INR199.91k
07/05/2023 13:24
recq1GPaGcx3nb3Ic
SF-136
B-009
recwnEwzMRzPqDW5N
SF-136
102
1,194
L/S
INR 213
INR254.32k
07/05/2023 13:24
recovB0XbDsnakPvD
SF-130
B-003
SF-130
165
2,475
Normal
INR 165
INR408.38k
07/05/2023 13:24
recktscigHka2WV5W
SG-03
B-0012
SG-03
70
2,945
L/S
INR 243
INR715.64k
07/05/2023 13:24
reck96f1W6jFkIoWq
SF-129
B-002
recngJgxLnefQyjly
SF-129
70.4
1,673.60
Normal
INR 245.50
INR410.87k
07/05/2023 13:24
recisxSupEABd2qU4
SF-129
B-002
recngJgxLnefQyjly
SF-129
87.5
4,386
Normal
INR 228
INR1m
07/05/2023 13:24
rech6tz1bxUESbDu1
SF-128
B-001
reckoJ1CY8b6dR0If
SF-128
31
2,438.80
Normal
INR 415
INR1.01m
06/27/2023 15:12
recfTeseATiVIiW6A
SG-01
B-0011
SG-01
70
9.20
L/S
INR 232
INR2.13k
07/05/2023 13:24
recdNm5VdITvCNcUl
SG-01
B-0011
SG-01
50
30.70
L/S
INR 262
INR8.04k
07/05/2023 13:24
recN7D6p6NAtn6HBI
SF-128
B-001
reckoJ1CY8b6dR0If
SF-128
64
1,171.20
Normal
INR 245
INR286.94k
06/27/2023 15:12
recKZYCxgsoErAwfn
SF-128
B-001
reckoJ1CY8b6dR0If
SF-128
30
1,216.90
Normal
INR 425
INR517.18k
06/27/2023 15:12
recK8jIWrFufDj4nl
SF-129
B-002
recngJgxLnefQyjly
SF-129
70.4
25
L/S
INR 73
INR1.83k
07/05/2023 13:24
recHimwnUctx9jCC7
SF-134
B-007
recwdCuf4BN0hQQUB
SF-134
39
3,465
L/S
INR 323
INR1.12m
07/05/2023 13:24
recE75W6smSCX9TaL
SF-129
B-002
recngJgxLnefQyjly
SF-129
87.5
824
Normal
INR 228
INR187.87k
07/05/2023 13:24
recCR6WKeUvHxYfdV
SF-134
B-007
recwdCuf4BN0hQQUB
SF-134
40
1,588
L/S
INR 323
INR512.92k
07/05/2023 13:24
rec9n3xQdhPr59jnR
SF-133
B-006
recSlsk16aUL2PDmZ
SF-133
65.5
1,355.60
L/S
INR 247
INR334.83k
07/05/2023 13:24
rec9WX4fFQ1DaT8fP
SF-137
B-0010
SF-137
70
1,865.10
L/S
INR 257
INR479.33k
07/05/2023 13:24
NEW RECORD
25 Arrivals
My Apps
Environments
Production
Add new Environment
SigmaSF
Pending
3 minutes ago
aadinarayana
varma2friend@gmail.com
Users & Teams
Billing & Plans
API keys
Activity Log
Dark Mode
Logout
Exit Preview
1 change
Publish
Read Documentation
Watch Video Tutorials
Request a Feature
See What’s New
Hire an Expert
Ask Community
Talk to Support
Congratulations!
OKOther tasks
Sync events
DATE EVENT STATUS TIME
[WORKER] 11.07.2023, 04:38:05 [LOG] Opening database connection…
[WORKER] 11.07.2023, 04:38:05 [LOG] Database connection is opened
[WORKER] 11.07.2023, 04:38:05 [LOG] Started adding records to database [OverwriteDelete mode]…
[WORKER] 11.07.2023, 04:38:05 [LOG] Fetching collections…
[WORKER] 11.07.2023, 04:38:08 [LOG] Collections are fetched
[WORKER] 11.07.2023, 04:38:08 [LOG] Checking collections on duplicates…
[WORKER] 11.07.2023, 04:38:08 [LOG] Collections are checked
[WORKER] 11.07.2023, 04:38:08 [LOG] Selected all collections
[WORKER] 11.07.2023, 04:38:08 [LOG] Detecting structure changes…
[WORKER] 11.07.2023, 04:38:08 [LOG] Started finding new collections…
[WORKER] 11.07.2023, 04:38:08 [LOG] Not found new collections
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding new fields in collections…
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding new fields for appYwg1IPEaGsfvMC_tbl79Y9d5w65EdEXB collections
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found new columns
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding new fields for appYwg1IPEaGsfvMC_tblI8ju4vkKv0iCZF collections
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found new columns
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding new fields for appYwg1IPEaGsfvMC_tblOA0B77DS2G6cSf collections
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found new columns
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding new fields for appYwg1IPEaGsfvMC_tbltFeY75Q8WmvmSU collections
[WORKER] 11.07.2023, 04:38:09 [LOG] Found new columns: No. Of Blocks,Sellable Price,Production Cost,Cost to Company,P&L
[WORKER] 11.07.2023, 04:38:09 [LOG] Columns are added
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding new fields for appYwg1IPEaGsfvMC_tblKvG4r3vIZ80JkU collections
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found new columns
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding new fields for appYwg1IPEaGsfvMC_tblaURrxaiAZG7vVV collections
[WORKER] 11.07.2023, 04:38:09 [LOG] Found new columns: Price in INR (from Link to Product),Sellable Price,Production Cost
[WORKER] 11.07.2023, 04:38:09 [LOG] Columns are added
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding new fields for appYwg1IPEaGsfvMC_tblsiLcLAB7qrWqOg collections
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found new columns
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding new fields for appYwg1IPEaGsfvMC_tblfk1FUAZiGb7j5m collections
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found new columns
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding new fields for appYwg1IPEaGsfvMC_tblEvQv6LU7Q1PxDl collections
[WORKER] 11.07.2023, 04:38:09 [LOG] Found new columns: Price in $$,Price in INR
[WORKER] 11.07.2023, 04:38:09 [LOG] Columns are added
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding new fields for appYwg1IPEaGsfvMC_tbljJALMtXVuEmHZ6 collections
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found new columns
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding new fields for appYwg1IPEaGsfvMC_tbliidQUdOTqTNxYa collections
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found new columns
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding fields not includes in collections…
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding fields not includes in appYwg1IPEaGsfvMC_tbl79Y9d5w65EdEXB
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found columns to delete
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding fields not includes in appYwg1IPEaGsfvMC_tblI8ju4vkKv0iCZF
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found columns to delete
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding fields not includes in appYwg1IPEaGsfvMC_tblOA0B77DS2G6cSf
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found columns to delete
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding fields not includes in appYwg1IPEaGsfvMC_tbltFeY75Q8WmvmSU
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found columns to delete
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding fields not includes in appYwg1IPEaGsfvMC_tblKvG4r3vIZ80JkU
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found columns to delete
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding fields not includes in appYwg1IPEaGsfvMC_tblaURrxaiAZG7vVV
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found columns to delete
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding fields not includes in appYwg1IPEaGsfvMC_tblsiLcLAB7qrWqOg
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found columns to delete
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding fields not includes in appYwg1IPEaGsfvMC_tblfk1FUAZiGb7j5m
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found columns to delete
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding fields not includes in appYwg1IPEaGsfvMC_tblEvQv6LU7Q1PxDl
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found columns to delete
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding fields not includes in appYwg1IPEaGsfvMC_tbljJALMtXVuEmHZ6
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found columns to delete
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding fields not includes in appYwg1IPEaGsfvMC_tbliidQUdOTqTNxYa
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found columns to delete
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding changed columns…
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding changed columns in appYwg1IPEaGsfvMC_tbl79Y9d5w65EdEXB
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found columns types for changing
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding changed columns in appYwg1IPEaGsfvMC_tblI8ju4vkKv0iCZF
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found columns types for changing
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding changed columns in appYwg1IPEaGsfvMC_tblOA0B77DS2G6cSf
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found columns types for changing
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding changed columns in appYwg1IPEaGsfvMC_tbltFeY75Q8WmvmSU
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found columns types for changing
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding changed columns in appYwg1IPEaGsfvMC_tblKvG4r3vIZ80JkU
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found columns types for changing
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding changed columns in appYwg1IPEaGsfvMC_tblaURrxaiAZG7vVV
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found columns types for changing
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding changed columns in appYwg1IPEaGsfvMC_tblsiLcLAB7qrWqOg
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found columns types for changing
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding changed columns in appYwg1IPEaGsfvMC_tblfk1FUAZiGb7j5m
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found columns types for changing
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding changed columns in appYwg1IPEaGsfvMC_tblEvQv6LU7Q1PxDl
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found columns types for changing
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding changed columns in appYwg1IPEaGsfvMC_tbljJALMtXVuEmHZ6
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found columns types for changing
[WORKER] 11.07.2023, 04:38:09 [LOG] Started finding changed columns in appYwg1IPEaGsfvMC_tbliidQUdOTqTNxYa
[WORKER] 11.07.2023, 04:38:09 [LOG] Not found columns types for changing
[WORKER] 11.07.2023, 04:38:09 [LOG] Structure changes detection finished
[WORKER] 11.07.2023, 04:38:10 [LOG] appYwg1IPEaGsfvMC_tbl79Y9d5w65EdEXB collection
[WORKER] 11.07.2023, 04:38:10 [LOG] Getting records. 100 records per page…
[WORKER] 11.07.2023, 04:38:10 [LOG] Fetching records from appYwg1IPEaGsfvMC_tbl79Y9d5w65EdEXB collection…
[WORKER] 11.07.2023, 04:38:10 [LOG] Records are fetched
[WORKER] 11.07.2023, 04:38:10 [LOG] Adding records to database…
[WORKER] 11.07.2023, 04:38:10 [LOG] Records to database are added
[WORKER] 11.07.2023, 04:38:10 [LOG] Collection read is finished
[WORKER] 11.07.2023, 04:38:10 [LOG] appYwg1IPEaGsfvMC_tblI8ju4vkKv0iCZF collection
[WORKER] 11.07.2023, 04:38:10 [LOG] Getting records. 100 records per page…
[WORKER] 11.07.2023, 04:38:10 [LOG] Fetching records from appYwg1IPEaGsfvMC_tblI8ju4vkKv0iCZF collection…
[WORKER] 11.07.2023, 04:38:10 [LOG] Records are fetched
[WORKER] 11.07.2023, 04:38:10 [LOG] Adding records to database…
[WORKER] 11.07.2023, 04:38:11 [LOG] Records to database are added
[WORKER] 11.07.2023, 04:38:11 [LOG] Collection read is finished
[WORKER] 11.07.2023, 04:38:11 [LOG] appYwg1IPEaGsfvMC_tblOA0B77DS2G6cSf collection
[WORKER] 11.07.2023, 04:38:11 [LOG] Getting records. 100 records per page…
[WORKER] 11.07.2023, 04:38:11 [LOG] Fetching records from appYwg1IPEaGsfvMC_tblOA0B77DS2G6cSf collection…
[WORKER] 11.07.2023, 04:38:11 [LOG] Records are fetched
[WORKER] 11.07.2023, 04:38:11 [LOG] Adding records to database…
[WORKER] 11.07.2023, 04:38:11 [ERROR] invalid input syntax for type double precision: “26/6/2023”
[WORKER] 11.07.2023, 04:38:11 [ERROR] QueryFailedError: invalid input syntax for type double precision: “26/6/2023”
at QueryFailedError.TypeORMError [as constructor] (/app/node_modules/typeorm/error/TypeORMError.js:9:28)
at new QueryFailedError (/app/node_modules/typeorm/error/QueryFailedError.js:13:28)
at PostgresQueryRunner. (/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:250:31)
at step (/app/node_modules/typeorm/node_modules/tslib/tslib.js:193:27)
at Object.throw (/app/node_modules/typeorm/node_modules/tslib/tslib.js:174:57)
at rejected (/app/node_modules/typeorm/node_modules/tslib/tslib.js:165:69)
at runMicrotasks ()
at processTicksAndRejections (node:internal/process/task_queues:96:5)
[WORKER] 11.07.2023, 04:38:11 [LOG] Database connection is closed
` This is the log. can some one help troubleshoot the issue.