rocket-bi icon indicating copy to clipboard operation
rocket-bi copied to clipboard

Published 20 hours ago • verified publisher icon datainsider-co

Google Analytics table data are not shown

Open Nandhini-Kumaresan opened this issue 1 year ago • 6 comments

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

Nandhini-Kumaresan avatar Dec 01 '23 05:12 Nandhini-Kumaresan

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?

tvc12 avatar Dec 01 '23 05:12 tvc12

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)

Nandhini-Kumaresan avatar Dec 01 '23 05:12 Nandhini-Kumaresan

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

tvc12 avatar Dec 01 '23 07:12 tvc12

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

Nandhini-Kumaresan avatar Dec 01 '23 08:12 Nandhini-Kumaresan

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

tvc12 avatar Dec 04 '23 06:12 tvc12

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.

Nandhini-Kumaresan avatar Dec 08 '23 06:12 Nandhini-Kumaresan