Forum Discussion
Message=Exception while reading from stream, ErrorCode=-2147467 when connecting to a PostgreSQL view
Hi Wenbin,
I did try adding a timeout but that didn't help unfortunately. However changing the view to a materialised view and getting the data as a query has worked!
Thanks,
B
Hi dharmendars007 I have tried to achieve this by clearing global data source settings and that has not resolved the issue. Do you have any other suggestions?
Thank you!
Hi dharmendars007, thanks for the quick reply, I'll add more.
Hi bcampos ,
Regarding your question, you mentioned that the CPU usage is very high. Is it because of a timeout during reading? Set the timeout here to see if it helps.
According to this post, you can also check whether it is a firewall problem.
Solved: Postgresql: Exception while reading from stream - Microsoft Fabric Community
Best Regards,
Wenbin ZhouHi Wenbin,
I did try adding a timeout but that didn't help unfortunately. However changing the view to a materialised view and getting the data as a query has worked!
Thanks,
B
FYI for anyone who comes across this issue in the future, changing the postgreSQL view to a materialised view has worked as a solution