The error which we are facing is database error as observed in the image below.

After further examination we found that this error occurs only to a limited number of courses whose size is more than 1GB.

To check whether this was a concern for all the courses, we have created a sample test course and imported it to another test course and it was successful.

So after debugging at server level we found that as per the current configurations we are unable to import a course which was more than 1GB.

Current PHP.ini Configuration settings

post_max_size = 1024M

upload_max_filesize = 1024M

max_execution_time = 300

max_input_time = 60

The size of the course that needs to be imported is 1.4GB.

So to resolve the raised concern, we need to modify the settings in the PHP.ini configuration file.

Desired PHP.ini Configuration settings

post_max_size = must be greater than 1GB

upload_max_filesize = must be greater than 1GB

max_execution_time = 600

max_input_time = 180

Once after configuring the above settings, the course import functionality would be done normally without any errors.