Bug 52460 - Apple school manager is slow in larger school environments which makes admin tasks lengthy
Apple school manager is slow in larger school environments which makes admin ...
Status: NEW
Product: UCS@school
Classification: Unclassified
Component: Apple School Manager
UCS@school 4.4
Other Linux
: P5 normal (vote)
: ---
Assigned To: UCS@school maintainers
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2020-12-04 16:57 CET by Sönke Schwardt-Krummrich
Modified: 2023-08-14 10:14 CEST (History)
2 users (show)

See Also:
What kind of report is it?: Bug Report
What type of bug is this?: 2: Improvement: Would be a product improvement
Who will be affected by this bug?: 3: Will affect average number of installed domains
How will those affected feel about the bug?: 2: A Pain – users won’t like this once they notice it
User Pain: 0.069
Enterprise Customer affected?:
School Customer affected?: Yes
ISV affected?:
Waiting Support:
Flags outvoted (downgraded) after PO Review:
Ticket number:
Bug group (optional):
Max CVSS v3 score:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Sönke Schwardt-Krummrich univentionstaff 2020-12-04 16:57:47 CET
In school environments, the Apple School Manager is relatively slow. To generate the CSV files the ASM needs about 37min in an environment with about 68k student users and 11k staff users.
This is relatively long for manual administration tasks:
- Make change
- Start ASM → wait 37min
- Check change in Apple School Manager
- Make changes in the Mobile Device Management system

In case of faulty/incomplete changes, a further 37min is added, which makes the actual task very lengthy.

The expectation would be that the generation of the CSV files takes considerably less time.

The attached example shows the processing time of an automatic synchronization. However, they do not differ from a manual sync.

2020-11-28 03:00:02,264 INFO  zip_file.write_zip:100 - Creating ZIP file in /var/lib/asm/asm_2020-11-28T03:00:02.263361.zip...
2020-11-28 03:00:02,266 DEBUG zip_file.create_csv_files:79 - Creating CSV files in /tmp/tmps3B0Yd...
2020-11-28 03:00:02,267 INFO  csv_file.create_csv_files:396 - Creating CSV files for OUs schule0, schule1, schule2, schule3, schule4, schule5, schule6, schule7, schule8, schule9, schule10, schule11, schule12, schule13, schule14, schule15, schule16, schule17, schule18, schule19, schule20, schule21, schule22, schule23, schule24, schule25, schule26, schule27, schule28, schule29, schule30, schule31, schule32, schule33, schule34, schule35, schule36, schule37, schule38, schule39, schule40, schule41, schule42, schule43, schule44, schule45, schule46, schule47, schule48, schule49, schule50, schule51, schule52, schule53, schule54, schule55, schule56, schule57, schule58, schule59, schule60, schule61, schule62, schule63, schule64, schule65, schule66, schule67, schule68, schule69, schule70, schule71, schule72, schule73, schule74, schule75, schule76, schule77, schule78, schule79, schule80, schule81, schule82, schule83, schule84, schule85, schule86, schule87, schule88, schule89, schule90, schule91, schule92, schule93, schule94, schule95, schule96, schule97, schule98, schule99, schule100, schule101, schule102, schule103, schule104, schule105, schule106, schule107, schule108, schule109, schule110, schule111, schule112, schule113, schule114, schule115, schule116, schule117, schule118, schule119, schule120, schule121, schule122, schule123, schule124, schule125, schule126, schule127, schule128, schule129, schule130, schule131, schule132, schule133, schule134, schule135, schule136, schule137, schule138, schule139, schule140, schule141, schule142, schule143, schule144, schule145, schule146, schule147, schule148, schule149, schule150, schule151, schule152, schule153...
2020-11-28 03:13:34,233 INFO  csv_file.write_csv:189 - Writing 68155 objects to students.csv...
2020-11-28 03:13:36,370 INFO  csv_file.write_csv:189 - Writing 154 objects to locations.csv...
2020-11-28 03:15:48,949 INFO  csv_file.write_csv:189 - Writing 11294 objects to staff.csv...
2020-11-28 03:30:13,920 INFO  csv_file.write_csv:189 - Writing 72094 objects to rosters.csv...
2020-11-28 03:36:34,770 INFO  csv_file.write_csv:189 - Writing 7223 objects to classes.csv...
2020-11-28 03:37:00,929 INFO  csv_file.write_csv:189 - Writing 7223 objects to courses.csv...
2020-11-28 03:37:00,984 INFO  csv_file.create_csv_files:402 - Finished creating CSV files.
2020-11-28 03:37:00,985 DEBUG zip_file.create_csv_files:82 - Created CSV files: /tmp/tmps3B0Yd/classes.csv, /tmp/tmps3B0Yd/courses.csv, /tmp/tmps3B0Yd/locations.csv, /tmp/tmps3B0Yd/rosters.csv, /tmp/tmps3B0Yd/staff.csv, /tmp/tmps3B0Yd/students.csv.
2020-11-28 03:37:00,985 DEBUG zip_file.write_zip:110 - Writing xZIP file to /var/lib/asm/asm_2020-11-28T03:00:02.263361.zip...
2020-11-28 03:37:01,553 DEBUG zip_file.write_zip:115 - Done writing ZIP file.
2020-11-28 03:37:01,553 DEBUG zip_file.write_zip:117 - Deleting temporary CSV files and directory...
2020-11-28 03:37:01,557 INFO  zip_file.write_zip:119 - Finished creating ZIP file.
2020-11-28 03:37:01,557 INFO  asm_upload.upload:61 - Uploading ZIP file to upload.appleschoolcontent.com...
2020-11-28 03:37:04,296 DEBUG asm_upload.upload:63 - Connected to upload.appleschoolcontent.com.
2020-11-28 03:37:07,062 INFO  asm_upload.upload:65 - Finished uploading ZIP file.
2020-11-28 03:37:07,176 DEBUG asm_upload.upload:67 - Disconnected.
2020-11-28 03:37:07,312 INFO  asm-upload.main:94 - The uploaded zip is stored in: /var/lib/asm/asm_2020-11-28T03:00:02.263361.zip
Comment 1 Sönke Schwardt-Krummrich univentionstaff 2020-12-04 16:59:24 CET
univention-apple-school-manager-connector 2.0.0-5A~4.4.0.202010160830