Problem Statement
...
Problem statement
An internal error occurs with a response code 500 while trying to
...
use CLI Action - getSpaceList.
Error
...
message
| Code Block | ||
|---|---|---|
| ||
RemoteError errordata: {"reason":"Internal server error. Report to support. Response code: 500. |
...
Server Error","message":"","statusCode":500}
Retry request on 500 error. |
Log entries
Here is a sample log for the mentioned error in which, wiki.domain.com is the URL and note that it is for representation purpose only:
| 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
|
...
...
Cause
| Panel | ||
|---|---|---|
| ||
One will get the above error message, if there are Confluence spaces which has no description and in the database, it shows NULL against the description value. |
Solution
On receiving the internal server error with response code 500, follow the below This error occurs when there no space description in the UI for Confluence space(s). It is caused because of NULL value for the Description field in the database.
Solution
To fix the mentioned error, perform these steps:
Verify if the description of the spaces is Null, any space is NULL by running the below query in the following database query.:
Code Block theme Midnight SELECT * FROM spaces WHERE spacedescid IS NULL ;
If there are In case you find any space(s) , which has having 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., you observe no error and the CLI query result displays the list of spaces as expected.
Code Block theme Midnight --action getSpaceList --columns Key,Type,URL