Intermittently getting oracle ORA-03113 error

[wilson_smyth]

Im populating my data from an oracle database. Intermittently i am getting an "ORA-03113 end-of-file on communication channel process ID:12345 Session ID:12 Serial number:12345" error adn the refresh fails.

if i run it again, it generally works.

As it works some of the time, it indicates the quries are syntactically valid. Im unsure why this issue only happens intermittenly.

Appreciate any advice or theories

[v-yulgu-msft]

Hi @wilson_smyth,

Based on my research, this error could be caused by several reasons, such as a server machine crashing, network issues, internal errors on the server, your server process being ended at the operating-system level, or a client having issues handling multiple connections. Reference: ORA-03113: End-of-file On Communication Channel

Best regards,

Yuliana Gu