ERROR WebServiceEngine: Project has not been found for uuid

SonarQube Server / Community Build
1

Hi all
Well I removed a project in administration page ( in the previous version 10.4 )

I keep seeing the removed project in some analisis result so I decided to remove everything related manually
I identified these tables

select * from sonarqube.alm_settings where kee = 'AY1gF1-_tUMoDI7kgJb0';
select * from sonarqube.analysis_properties where kee = 'AY1gF1-_tUMoDI7kgJb0';
select * from sonarqube.ce_task_characteristics where kee = 'AY1gF1-_tUMoDI7kgJb0';
select * from sonarqube.components where kee = 'AY1gF1-_tUMoDI7kgJb0';
select * from sonarqube.internal_component_props where kee = 'AY1gF1-_tUMoDI7kgJb0';
select * from sonarqube.internal_properties where kee = 'AY1gF1-_tUMoDI7kgJb0';
select * from sonarqube.issue_changes where kee = 'AY1gF1-_tUMoDI7kgJb0';
select * from sonarqube.issues where kee = 'AY1gF1-_tUMoDI7kgJb0';
select * from sonarqube.plugins where kee = 'AY1gF1-_tUMoDI7kgJb0';
select * from sonarqube.portfolios where kee = 'AY1gF1-_tUMoDI7kgJb0';
select * from sonarqube.project_branches where kee = 'AY1gF1-_tUMoDI7kgJb0';
select * from sonarqube.projects where kee = 'AY1gF1-_tUMoDI7kgJb0';
select * from sonarqube.qprofile_changes where kee = 'AY1gF1-_tUMoDI7kgJb0';
select * from sonarqube.rule_desc_sections where kee = 'AY1gF1-_tUMoDI7kgJb0';
select * from sonarqube.rule_repositories where kee = 'AY1gF1-_tUMoDI7kgJb0';

select * from sonarqube.ce_activity where entity_uuid = 'AY1gF1-_tUMoDI7kgJb0';
select * from sonarqube.group_roles where entity_uuid = 'AY1gF1-_tUMoDI7kgJb0';
select * from sonarqube.project_badge_token where project_uuid = 'AY1gF1-_tUMoDI7kgJb0';
select * from sonarqube.project_branches where kee = 'AY1gF1-_tUMoDI7kgJb0' or project_uuid = 'AY1gF1-_tUMoDI7kgJb0';

after running all analysis I have this particular problem accessing rule typescript:S1128

[stacktrace.txt|attachment](upload://9Kd0kei0RqL6qncNEAEEp24lHKT.txt) (15.6 KB)

ERROR web[84b020b7-91f7-45f2-9b90-90eae4b5561a][o.s.s.w.WebServiceEngine] Fail to process request http://localhost:9000/api/issues/search?issueStatuses=OPEN%2CCONFIRMED&rules=typescript%3AS1128&facets=projects&ps=1&additionalFields=_all
java.lang.NullPointerException: Project has not been found for uuid 'AY1gF1-_tUMoDI7kgJb0'

there is still one missing relation to remove, but I cannot find it with a plain query

by now I’m using Community Edition v10.6 (92116)

2

Hey there.

Please, please don’t manually delete stuff from your SonarQube database. That can put your SonarQube instance in a corrupt, unsupportable state.

Probably the UUID is hanging around your Elasticsearch index. Delete your /data/es8 folder and restart.

3

it worked!

thanks.

if it happens again, what shoud I do with the “deleted project that still appears” ?

4

Report the symptoms here so that we can investigate. It’s not clear to me where the missing project as showing up.

5

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.