Clickhouse error

[Rebecca Sansale]

Hi--

I have installed cBP via docker and have successfully loaded the UCSF 2014 test study and viewed the portal via localhost. 

I am following the instructions here to use the Clickhouse option: https://docs.cbioportal.org/deployment/docker/. I am able to load study data into the portal and view the summary page and the clinical data page using clickhouse, however when i select a patient, i get this error. i get the same error when using clickhouse on a pre-loaded study as well, so this is not an issue with my study data: 

• 1: SQL exception. If you are a maintainer of this instance, see logs for details.

{"req":{"method":"GET","url":"////localhost:8080/api/column-store/studies/UCSF_1000patient_CSF/samples/352397699","headers":{"accept":"application/json"}},"xhr":{},"text":"{\"message\":\"SQL exception. If you are a maintainer of this instance, see logs for details.\"}","statusText":"","statusCode":500,"status":500,"statusType":5,"info":false,"ok":false,"redirect":false,"clientError":false,"serverError":true,"error":{"status":500,"method":"GET","url":"////localhost:8080/api/column-store/studies/UCSF_1000patient_CSF/samples/352397699"},"created":false,"accepted":false,"noContent":false,"badRequest":false,"unauthorized":false,"notAcceptable":false,"forbidden":false,"notFound":false,"unprocessableEntity":false,"headers":{"cache-control":"no-cache, no-store, max-age=0, must-revalidate","connection":"close","content-encoding":"gzip","content-type":"application/json","date":"Wed, 29 Oct 2025 20:04:47 GMT","elapsed-time":"13934","expires":"0","pragma":"no-cache","transfer-encoding":"chunked","vary":"origin,access-control-request-method,access-control-request-headers,accept-encoding","x-content-type-options":"nosniff","x-frame-options":"DENY","x-xss-protection":"0"},"header":{"cache-control":"no-cache, no-store, max-age=0, must-revalidate","connection":"close","content-encoding":"gzip","content-type":"application/json","date":"Wed, 29 Oct 2025 20:04:47 GMT","elapsed-time":"13934","expires":"0","pragma":"no-cache","transfer-encoding":"chunked","vary":"origin,access-control-request-method,access-control-request-headers,accept-encoding","x-content-type-options":"nosniff","x-frame-options":"DENY","x-xss-protection":"0"},"type":"application/json","links":{},"body":{"message":"SQL exception. If you are a maintainer of this instance, see logs for details."},"url":"http://localhost:8080/patient?sampleId=352397699&studyId=UCSF_1000patient_CSF"}

[Aaron L]

Hi Rebecca, 

Thanks for trying this out.  Can you look at the web server log?  it should have detail about the SQL error is.   If you send that to me, that should help.

--
You received this message because you are subscribed to the Google Groups "cBioPortal for Cancer Genomics Discussion Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cbioportal+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/cbioportal/408981a0-3f25-4eed-92bf-9b333cb82a3cn%40googlegroups.com.