Bulk Upload Process
sunbird.bulk_upload_process (PRIMARY KEY: id)
Table used for storing bulk upload process information.
id
text
Process Identifier
013164532565106688101
createdby
text
Bulk upload triggered by
ec8deeb2-4ded-4fa2-ac48-023ad8298d92
createdon
timestamp
Bulk upload triggered on
2020-12-03 12:24:00.303000+0000
data
text
Bulk uploaded file data
9C9dOj89ssd0Rae5fSjSVmXmNdMSm7OpbtcYhFsc9WMwI92NvcdeNvC+IEgmUg0rdejQd642yHeV\na6E=
failureresult
text
Records that could not be processed
[]
lastupdatedon
timestamp
record last updated on
2020-12-03 12:24:00.303000+0000
objecttype
text
records' object type: location/user/organisation/MigrationUser/SELF_DECLARED_USER
SELF_DECLARED_USER
organisationid
text
organisation Identifier to which bulk upload has been triggered for
01269878797503692810
processendtime
text
processstarttime
text
Start time at which record processing got triggered
2020-12-03 12:24:00.303000+0000
retrycount
int
Number of times record processing was tried
2
status
int
Status of the bulk upload process
3
storagedetails
text
Cloud Storage location of the downloadable CSV with process result information
successresult
text
Records that were processed successfully
taskcount
int
8
telemetrycontext
map<text, text>
Used to store request context information in case of MigrationUser/SELF_DECLARED_USER type bulk uploads
uploadedby
text
same as createdby
ec8deeb2-4ded-4fa2-ac48-023ad8298d92
uploadeddate
text
same as createdon
2020-12-03 12:24:00.303000+0000
sunbird.bulk_upload_process_task (PRIMARY KEY: processid, sequenceid)
processid
text
Process Identifier
0134312772714250242
sequenceid
int
Record sequence
2
createdon
timestamp
Record created on
2021-12-15 09:11:59.078000+0000
data
text
Record details
{"code":"998","parentCode":"ak0015","name":"d02","parentId":"1efe2f58-b1a3-432f-820e-9a8b9d843237","id":"259278c4-7c69-428e-85cb-0f2df8d167c4","type":"district"}
failureresult
text
Reason for record processing failure
{"code":"999","parentCode":"ak0015","name":"d01","parentId":"65359881-ace2-44e9-8212-c74c637fea9b","id":"ff47b704-9856-4712-ad88-0625853f0e26","type":"state","operation":"update","err_msg":"Update of type is not allowed."}
iterationid
int
Number of iterations
1
lastupdatedon
timestamp
Record last updated on
2021-12-15 09:11:59.322000+0000
status
int
Status of record processing
0/1/2/3/9
successresult
text
record details when processed successfully
{"code":"998","parentCode":"ak0015","name":"d02","parentId":"1efe2f58-b1a3-432f-820e-9a8b9d843237","id":"259278c4-7c69-428e-85cb-0f2df8d167c4","type":"district","operation":"update"}
Last updated