Group not created

SonarQube Server / Community Build
1

Sonarqube Developer Edition * Version 8.9 (build 43852) - Running on Windows 10, database is MSSQL Server 16
When I click Group from security to create Group, I get the error message
The request cannot be processed. Try again later

image

-Group can be created from Administration\Security\Group

2

Hello @jumaniblango
thanks for this report.
Can you check the logs from your SonarQube instance at the time this error is occurring?

  • the access log will show you the request reaching to your SonarQube server (you should see a GET /api/user_groups/search?q= request there). If the request does not reach SonarQube, you’ll need to investigate what is happening at network level.
  • the web.log will show you if there is some error for this request on the WEB component of SonarQube.
  • If the request is received and no error is shown, setting your SonarQube logs at TRACE level (temporarily) will allow you to see both the request and the SQL requests that SonarQube is using to get the information from its DB, in the web.log file. You can set TRACE level from SonarQube UI: Administration → System page.

Let me know of your findings.
Best regards
Sylvain

3

The access.log does not show (GET /api/user_groups/search?/q=…) . Below are the content of the logs
Web.log
2021.06.21 10:33:29 TRACE web[AXou7r4LIMeJQQ/2AABJ][sql] time=0ms | sql=select st.uuid as uuid, st.user_uuid as “userUuid”, st.expiration_date as “expirationDate”, st.created_at as “createdAt”, st.updated_at as “updatedAt” from session_tokens st where st.uuid=? | params=AXou7yFX4w-iXPGe18C5
2021.06.21 10:33:29 TRACE web[AXou7r4LIMeJQQ/2AABJ][sql] time=4ms | sql=SELECT u.uuid as uuid, u.login as login, u.name as name, u.email as email, u.active as “active”, u.scm_accounts as “scmAccounts”, u.salt as “salt”, u.crypted_password as “cryptedPassword”, u.hash_method as “hashMethod”, u.external_id as “externalId”, u.external_login as “externalLogin”, u.external_identity_provider as “externalIdentityProvider”, u.user_local as “local”, u.is_root as “root”, u.onboarded as “onboarded”, u.reset_password as “resetPassword”, u.homepage_type as “homepageType”, u.homepage_parameter as “homepageParameter”, u.last_connection_date as “lastConnectionDate”, u.last_sonarlint_connection as “lastSonarlintConnectionDate”, u.created_at as “createdAt”, u.updated_at as “updatedAt” FROM users u WHERE u.uuid=? | params=AXofkt14A8wYTnXmJEyP
2021.06.21 10:33:29 TRACE web[AXou7r4LIMeJQQ/2AABJ][sql] time=5ms | sql=select p.prop_key as “key”, p.is_empty as empty, p.text_value as textValue, p.clob_value as clobValue, p.component_uuid as componentUuid, p.user_uuid as userUuid from properties p where p.prop_key in ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) and p.component_uuid is null and p.user_uuid is null order by p.created_at | params=email.from, email.fromName, email.prefix, email.smtp_host.secured, email.smtp_password.secured, email.smtp_port.secured, email.smtp_secure_connection.secured, email.smtp_username.secured, sonar.builtInQualityProfiles.disableNotificationOnUpdate, sonar.core.serverBaseURL, sonar.cpd.cross_project, sonar.developerAggregatedInfo.disabled, sonar.issues.defaultAssigneeLogin, sonar.lf.aboutText, sonar.lf.enableGravatar, sonar.lf.gravatarServerUrl, sonar.lf.logoUrl, sonar.lf.logoWidthPx, sonar.qualitygate.ignoreSmallChanges
2021.06.21 10:33:29 TRACE web[AXou7r4LIMeJQQ/2AABJ][sql] time=1ms | sql=select gr.role from group_roles gr inner join groups_users gu on gr.group_uuid=gu.group_uuid where gr.component_uuid is null and gu.user_uuid=? union select gr.role from group_roles gr where gr.group_uuid is null and gr.component_uuid is null union select ur.role from user_roles ur where ur.user_uuid=? and ur.component_uuid is null | params=AXofkt14A8wYTnXmJEyP, AXofkt14A8wYTnXmJEyP
2021.06.21 10:33:56 TRACE web[sql] time=2ms | sql=select top (?) uuid, data, created_at from notifications order by created_at asc | params=1

access.log
192.168.85.1 - - [21/Jun/2021:10:33:27 -0400] “GET /api/users/identity_providers HTTP/1.1” 200 24 “http://192.168.85.1:9000/admin/users” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Safari/537.36 Edg/91.0.864.48” “AXou7r4LIMeJQQ/2AABG”
192.168.85.1 - - [21/Jun/2021:10:33:27 -0400] “GET /api/users/search? HTTP/1.1” 200 773 “http://192.168.85.1:9000/admin/users” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Safari/537.36 Edg/91.0.864.48” “AXou7r4LIMeJQQ/2AABH”
192.168.85.1 - - [21/Jun/2021:10:33:29 -0400] “GET /api/settings/list_definitions? HTTP/1.1” 200 - “http://192.168.85.1:9000/admin/settings” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Safari/537.36 Edg/91.0.864.48” “AXou7r4LIMeJQQ/2AABI”
192.168.85.1 - - [21/Jun/2021:10:33:29 -0400] “GET /api/settings/values?keys=sonar.lf.aboutText%2Csonar.builtInQualityProfiles.disableNotificationOnUpdate%2Csonar.cpd.cross_project%2Csonar.issues.defaultAssigneeLogin%2Csonar.developerAggregatedInfo.disabled%2Cemail.prefix%2Csonar.lf.enableGravatar%2Cemail.from%2Cemail.fromName%2Csonar.lf.gravatarServerUrl%2Csonar.qualitygate.ignoreSmallChanges%2Csonar.lf.logoUrl%2Cemail.smtp_secure_connection.secured%2Csonar.core.serverBaseURL%2Cemail.smtp_host.secured%2Cemail.smtp_password.secured%2Cemail.smtp_port.secured%2Cemail.smtp_username.secured%2Csonar.lf.logoWidthPx HTTP/1.1” 200 812 “http://192.168.85.1:9000/admin/settings” “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.101 Safari/537.36 Edg/91.0.864.48” “AXou7r4LIMeJQQ/2AABJ”

4

Hi @jumaniblango
sorry for this late reply, I missed the notification on this thread.
Did you resolve your problem?

If not the case, I can see in your logs that some requests are probably not reaching SonarQube server from some reason. So let’s take it from the other end and look into what is happening from your browser side, using your browser inspect mode.
On my side, in firefox, when I select the Security → Groups menu, I see these 4 requests:

image
image1897×706 86.9 KB

The 3 initial requests are there because I cleared my browser cache before accessing the page. If I get back to it a second time, the JS content is chached and I only see the search request.
So what I suggest is the following:

  1. clear your browser cache for your SonarQube address
  2. Go to the SonarQube Administration page
  3. Open your browser inspect mode, network tab
  4. Check what is happening for the requests to SonarQube server there
  5. Verify that all requests indeed reached your SonarQube server (access.log)

If you can’t see requests reaching your SonarQube server in your access.log file (which seems to be the case), then you should investigate what is happening at network level (firewall, reverse proxy…).

Let me know of your findings… and don’t hesitate to ping me in this thread if I’m late answering :slight_smile:
Best regards
Sylvain