Google Analytics table data are not shown

[Nandhini-Kumaresan]

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.

For your reference attached the table data screenshot.

[tvc12]

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]

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]

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

[Nandhini-Kumaresan]

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

[tvc12]

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

[Nandhini-Kumaresan]

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.