Gaurav Mishra

@krishna9304 some changes are required in open api docs ```diff diff --git a/src/www/ui/api/documentation/openapi.yaml b/src/www/ui/api/documentation/openapi.yaml index 82e1a7e5d..7d3598c43 100644 --- a/src/www/ui/api/documentation/openapi.yaml +++ b/src/www/ui/api/documentation/openapi.yaml @@ -677,7 +677,7 @@ paths: Set permissions for a...

Did you run the [utils/fo-installdeps](https://github.com/fossology/fossology/blob/master/utils/fo-installdeps) to install the dependencies?

Please check the network tab in the developer tool for your browser and check if there is a 500 error when you perform this operation. Please share the Apache error...

Oh, looks like issue with some non-UTF8 characters in license text. It should've been fixed by #1994 and #1996

:grimacing: Can you please provide the text phrase for testing?

Thank you for your interest @prsmahajan . I will assign the ticket to you. And for pointers, when PR #1955 gets merged, the following functions needs to be updated: https://github.com/fossology/fossology/blob/9053f619aaab5e59ed37bdbf86f2a2969f8c76de/src/www/ui/api/Controllers/JobController.php#L223...

Please consider using the `fo_unicode_clean` utility to migrate if error persists. It requires some basic knowledge on [`pg_dump`](https://www.postgresql.org/docs/11/app-pgdump.html) and `psql`. Steps to recode are documented here: https://github.com/fossology/fossology/wiki/Migration-to-UTF-8-DB#fixing-pg_dump-fast

Alternatively, try reducing the number of rows at https://github.com/fossology/fossology/blob/dbd4115294fe6a50a1f621c3095267cdb3912af4/install/db/dbmigrate_3.7-3.8.php#L31

The only section I see consuming that much memory is https://github.com/fossology/fossology/blob/dbd4115294fe6a50a1f621c3095267cdb3912af4/install/db/dbmigrate_3.7-3.8.php#L78-L82 It concatenate all rows into a single, huge string. So it might grow as per the records in DB....

True. So we can use functions other than `queryOnce()` (as it logs for each call the execution time) like `getSingleRow()` at https://github.com/fossology/fossology/blob/5573665ca246009453e947b8fd3efd0e40e4b34c/install/db/dbmigrate_3.7-3.8.php#L87-L89 Also, the function call should not be in...