Bulk Upload Process

sunbird.bulk_upload_process (PRIMARY KEY: id)

Table used for storing bulk upload process information.

Column Name	Data Type	Description	Sample Data
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	DfCr74W+cCyXsW0KiI9+0fE/qnW1SYZLJeyMEoWC7pV9wu2rSCdgiQ2JBt2B/0nQswU6sFZZ8+dX\noxDWPWJ5FXSKc2v9cXPWEGnscNhsEFrqOIUemwlJe5mcIjhM2Opel2940M1Vslf/cZMCI3xwpSUq\nUCYFRMDmK6lNotysYPISemcCMnZEk+qhOT8vhvpeKo1Xv/0/jBfbKI03JhZruX703HqiOZOcR072\nkYFoPRDaxoOFc+rXLm+hHg6LOXypFVTNhs9/3Sa80SViXQCn4bnc5FlOjy26iVIxqdYi6bCEfQqd\n6EAFIFGwzFRTS/giFGHVEadH0V0aMXTQbYUJ3Q==
successresult	text	Records that were processed successfully	[{"firstName":"Partner Content Creator","phone":null,"roles":["CONTENT_CREATOR"],"userType":"TEACHER","userId":"fd3cbea8-8608-43ce-ba7f-4fb587a10b45","email":"T+CY41939vm5qKAAcTLaxxK+trKhBNYnDDP/VRRvhac0gVteBTNegJgigEyqBs0qGcAkB/m3MS5f\n7RPeVRTnKnT88bYbiAGo78uwUmwN4GcDevB7iVni9p2Sbmsd5V9h/tJR3ZPAAFSTyJ9yFc8WHcvy\nG0t0HiJjD+xEIZgJ6RQ=","orgId":"0128925770740285447","organisationId":"0128925770740285447","emailVerified":true,"createdBy":"30f05f74-2ee8-4ed0-b20a-d1f880268a74","rootOrgId":"0128925770740285447","channel":"2.5.0","phoneVerified":false,"profileVisibility":{},"isDeleted":false,"createdDate":"2020-05-04 07:28:34:162+0000","status":1,"userName":"5Q14OzLBlLI7HHuph8OqS1N9fKpmXHYm+y4p8QljjhRY1J0CQtV30E8Ym7r8KzpXw5EzAHe3Vj+Z\nzy4i+VpmXXlF/Duv7I/HjdoA+q/U2hTPImOINHWbZp0d3J4XvFK2x7BDdjyMwJA4M25P8OEXyfJn\npkKp6ASi2X8EnVJq+wE=","loginId":"5Q14OzLBlLI7HHuph8OqS1N9fKpmXHYm+y4p8QljjhRY1J0CQtV30E8Ym7r8KzpXw5EzAHe3Vj+Z\nzy4i+VpmXcJii4KPr2fcgMs2OGMaLfKN0JRcaxV4Dhk2DKbBCAprp/fgHO9L04/v2xepR3Lj95ZX\nR3WFhFjJrrpMKskBxnM=","externalIds":null,"id":"fd3cbea8-8608-43ce-ba7f-4fb587a10b45","orgName":"Preprod2.5.0","operation":"create"},{"firstName":"Partner Book Creator","phone":null,"roles":["BOOK_CREATOR"],"userType":"TEACHER","userId":"cf37aa84-c441-4222-8158-3dbca16f3837","email":"T+CY41939vm5qKAAcTLaxxK+trKhBNYnDDP/VRRvhac0gVteBTNegJgigEyqBs0qGcAkB/m3MS5f\n7RPeVRTnKnT88bYbiAGo78uwUmwN4GcDevB7iVni9p2Sbmsd5V9h/tJR3ZPAAFSTyJ9yFc8WHcvy\nG0t0HiJjD+xEIZgJ6RQ=","orgId":"0128925770740285447","organisationId":"0128925770740285447","emailVerified":true,"createdBy":"30f05f74-2ee8-4ed0-b20a-d1f880268a74","rootOrgId":"0128925770740285447","channel":"2.5.0","phoneVerified":false,"profileVisibility":{},"isDeleted":false,"createdDate":"2020-05-04 07:28:34:237+0000","status":1,"userName":"TvHDg/MI2JpJFXgjp3YIG4LMGVGHK+jOhtjZhSRlLdN0QYfVVdKS0fH1182ZYFR3wH0ApdRZW2Uu\ncmm1xMNH7hR1NfeTnnYNoC5Lx7PvqjoLgACzaXPkpdqojfIVFRCFT6a+wzaAmCWueMEdPmZuRg==","loginId":"TvHDg/MI2JpJFXgjp3YIGxHeQiq+pucBuZCTotHSROCYKG6HLWzgt45LtXLalf8VOa8Jkm7i4ZoB\nDHKKfmpitKHKqYPck44ON4KMwv0OHXcC0RETYKK/WhokPxDLwYjBXXEKEarPqozxAXE+a5dMmjUl\n1FlHleh2UkyWuT7bVWQ=","externalIds":null,"id":"cf37aa84-c441-4222-8158-3dbca16f3837","orgName":"Preprod2.5.0","operation":"create"}]
taskcount	int		8
telemetrycontext	map<text, text>	Used to store request context information in case of MigrationUser/SELF_DECLARED_USER type bulk uploads	{'actorId': '013164536804098048102', 'actorType': 'System', 'channel': '0126796199493140480', 'env': 'SelfDeclaredUserUpload', 'method': 'POST', 'requestType': 'API_CALL', 'telemetry_pdata_id': 'staging.sunbird.learning.service', 'telemetry_pdata_pid': 'learner-service', 'telemetry_pdata_ver': '3.5.0', 'url': '/v2/bulk/user/upload', 'x-request-id': '12b90c4428da29db327c8b17f3258c1c'}
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)

Column Name	Data Type	Description	Sample Data
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 NEW(0), IN_PROGRESS(1), INTERRUPT(2), COMPLETED(3), FAILED(9)	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"}