search

datainsider-co / rocket-bi

A free, open-source, web-based self-service BI tailor-made for clickhouse, google bigquery, mysql, postgresql, vertica
https://rocket.bi
GNU General Public License v3.0
102 stars 29 forks source link

Google Analytics table data are not shown #100

Open Nandhini-Kumaresan opened 11 months ago

Nandhini-Kumaresan commented 11 months ago

updated docker-compose.yml with the most recent version. The total number of inserted rows is displayed along with the job's successful sync, but the data is not displayed on the table.

image

For your reference attached the table data screenshot. image

tvc12 commented 11 months ago

Hi @Nandhini-Kumaresan , Can you create a new job, synchronize it with the new database, and check it again?

By the way, can you please check the log in the folder named rocket-bi-server and print it here?

Nandhini-Kumaresan commented 11 months ago

Hi @tvc12 , Created a new job and checked with the new database still same issue continues. Also, below is the error from the log named rocket-bi-server.log.

I/O error Pipe closed for process: [tail, -n, +2, /app/./tmp/clickhouse/0/test_database/__di_tmp_site_content_1701409776609/1701409785863.json]
java.io.IOException: Pipe closed
    at java.io.PipedInputStream.checkStateForReceive(PipedInputStream.java:260)
    at java.io.PipedInputStream.awaitSpace(PipedInputStream.java:268)
    at java.io.PipedInputStream.receive(PipedInputStream.java:231)
    at java.io.PipedOutputStream.write(PipedOutputStream.java:149)
    at scala.sys.process.BasicIO$.loop$1(BasicIO.scala:240)
    at scala.sys.process.BasicIO$.transferFullyImpl(BasicIO.scala:246)
    at scala.sys.process.BasicIO$.transferFully(BasicIO.scala:227)
    at scala.sys.process.ProcessImpl$PipeThread.runloop(ProcessImpl.scala:170)
    at scala.sys.process.ProcessImpl$PipeSource.run(ProcessImpl.scala:188)
I/O error Pipe closed for process: [tail, -n, +2, /app/./tmp/clickhouse/0/test_database/__di_tmp_event_1701409796627/1701409804060.json]
java.io.IOException: Pipe closed
    at java.io.PipedInputStream.checkStateForReceive(PipedInputStream.java:260)
    at java.io.PipedInputStream.awaitSpace(PipedInputStream.java:268)
    at java.io.PipedInputStream.receive(PipedInputStream.java:231)
    at java.io.PipedOutputStream.write(PipedOutputStream.java:149)
    at scala.sys.process.BasicIO$.loop$1(BasicIO.scala:240)
    at scala.sys.process.BasicIO$.transferFullyImpl(BasicIO.scala:246)
    at scala.sys.process.BasicIO$.transferFully(BasicIO.scala:227)
    at scala.sys.process.ProcessImpl$PipeThread.runloop(ProcessImpl.scala:170)
    at scala.sys.process.ProcessImpl$PipeSource.run(ProcessImpl.scala:188)
tvc12 commented 11 months ago

Hi @Nandhini-Kumaresan , Are you use clickhouse for data warehouse?

Nandhini-Kumaresan commented 11 months ago

@tvc12, Yes, I am using clickhouse for data warehouse.

tvc12 commented 11 months ago

Hi @Nandhini-Kumaresan , Can you print full log in here? I cannot known problem from above log.

Nandhini-Kumaresan commented 11 months ago

Hi @tvc12 ,

rocket-bi-server.log

I/O error Pipe closed for process: [tail, -n, +2, /app/./tmp/clickhouse/0/test_database/__di_tmp_site_content_1701409776609/1701409785863.json]
java.io.IOException: Pipe closed
    at java.io.PipedInputStream.checkStateForReceive(PipedInputStream.java:260)
    at java.io.PipedInputStream.awaitSpace(PipedInputStream.java:268)
    at java.io.PipedInputStream.receive(PipedInputStream.java:231)
    at java.io.PipedOutputStream.write(PipedOutputStream.java:149)
    at scala.sys.process.BasicIO$.loop$1(BasicIO.scala:240)
    at scala.sys.process.BasicIO$.transferFullyImpl(BasicIO.scala:246)
    at scala.sys.process.BasicIO$.transferFully(BasicIO.scala:227)
    at scala.sys.process.ProcessImpl$PipeThread.runloop(ProcessImpl.scala:170)
    at scala.sys.process.ProcessImpl$PipeSource.run(ProcessImpl.scala:188)
I/O error Pipe closed for process: [tail, -n, +2, /app/./tmp/clickhouse/0/test_database/__di_tmp_event_1701409796627/1701409804060.json]
java.io.IOException: Pipe closed
    at java.io.PipedInputStream.checkStateForReceive(PipedInputStream.java:260)
    at java.io.PipedInputStream.awaitSpace(PipedInputStream.java:268)
    at java.io.PipedInputStream.receive(PipedInputStream.java:231)
    at java.io.PipedOutputStream.write(PipedOutputStream.java:149)
    at scala.sys.process.BasicIO$.loop$1(BasicIO.scala:240)
    at scala.sys.process.BasicIO$.transferFullyImpl(BasicIO.scala:246)
    at scala.sys.process.BasicIO$.transferFully(BasicIO.scala:227)
    at scala.sys.process.ProcessImpl$PipeThread.runloop(ProcessImpl.scala:170)
    at scala.sys.process.ProcessImpl$PipeSource.run(ProcessImpl.scala:188)

This was the full log in the rocket-bi-server.log. For your reference, attached the log file.