Problem Statement
| Info |
|---|
User \ gets an Internal Error with a response code 500 while trying to use getSpaceList use CLI Action: getSpaceList |
Error Message
| Code Block | ||
|---|---|---|
| ||
Remote error: Internal server error. Report to support. Response code: 500. |
Log Entries
Here is the sample log for this error:
| Code Block | ||
|---|---|---|
| ||
{"self":"https://wiki.domain.com/rest/api/latest/space?expand=description.plain%2Cmetadata.labels%2Chomepage","next":"/rest/api/latest/space?expand=description.plain%2Cmetadata.labels%2Chomepage&limit=25&start=300","prev":"/rest/api/latest/space?expand=description.plain%2Cmetadata.labels%2Chomepage&limit=25&start=250","base":"https://wiki.domain.com","context":""}}
URL requested: https://wiki.domain.com/rest/api/latest/space?expand=description.plain%2Cmetadata.labels%2Chomepage&limit=25&start=300
Request type: GET
Content type: application/json; charset=utf-8
Request property Cookie, value: [JSESSIONID=D212***]
Request property X-Atlassian-Token, value: [no-check]
Request property Content-Type, value: [application/json; charset=utf-8]
Response code: 500, message: null, url: https://wiki.domain.com/rest/api/latest/space?expand=description.plain%2Cmetadata.labels%2Chomepage&limit=25&start=300
Error data: {"reason":"Internal Server Error","message":"","statusCode":500}
Retry request on 500 error.
Request property Cookie, value: [JSESSIONID=D212***]
Request property X-Atlassian-Token, value: [no-check]
Request property Content-Type, value: [application/json; charset=utf-8]
Response code: 500, message: null, url: https://wiki.domain.com/rest/api/latest/space?expand=description.plain%2Cmetadata.labels%2Chomepage&limit=25&start=300
Error data: {"reason":"Internal Server Error","message":"","statusCode":500}
Retry request on 500 error.
Request property Cookie, value: [JSESSIONID=D212***]
Request property X-Atlassian-Token, value: [no-check]
Request property Content-Type, value: [application/json; charset=utf-8]
Response code: 500, message: null, url: https://wiki.domain.com/rest/api/latest/space?expand=description.plain%2Cmetadata.labels%2Chomepage&limit=25&start=300
Error data: {"reason":"Internal Server Error","message":"","statusCode":500}
Problem determination - response: 500: null
Problem determination - response url: https://wiki.domain.com/rest/api/latest/space?expand=description.plain%2Cmetadata.labels%2Chomepage&limit=25&start=300
Problem determination - request url: https://wiki.domain.com/rest/api/latest/space?expand=description.plain%2Cmetadata.labels%2Chomepage&limit=25&start=300
Problem determination - response data: {"statusCode":500,"message":"","reason":"Internal Server Error"}
reset session
|
...
| Panel | ||
|---|---|---|
| ||
One will get the above error message, if there are Confluence spaces which has no space description and in the database, it shows NULL against the description valueUI, It causes because of no value (NULL) for the field: Description in the database. |
Solution
On receiving the internal server error with response code 500, follow the below steps:
Verify if the description of the spaces is Null, by running the following below database query.:
Code Block theme Midnight SELECT * FROM spaces WHERE spacedescid IS NULL ;
If there are any space(s), which has the description description as NULL in the above results, then make sure to provide space with valid descriptionupdate the description with a value from the UI.
- Once you update the description in the space(s) then , re-run the getSpaceList action. This time you will not get the Response Code: 500 error.