Exception calling "ExecuteReader" with "0" argument(s): "ERROR [57014]

Question

Need help with my Powershell. I am getting error

Exception calling "ExecuteReader" with "0" argument(s): "ERROR [57014] ERROR: canceling statement due to statement timeout; Error while executing the query" At line:1 char:1

My PowerShell as below:

$datetime = (Get-Date).ToString(); 
$sw = [Diagnostics.Stopwatch]::StartNew() 
$DBConnectionString ="Dsn=PostgreSQL;database=test;server=10.x.x.xx;port=5432;uid=xxx;pwd=xxx" 
$DBConn = New-Object System.Data.Odbc.OdbcConnection; $DBConn.ConnectionString = $DBConnectionString; 
$DBConn.Open(); 
$DBCmd = $DBConn.CreateCommand(); 
$DBCmd.CommandText= get-content "C:\data1.sql" 
$rdr=$DBCmd.ExecuteReader(); 
$instance = "DB\DBTEST" 
$userId = "sa" 
$password = "xxxx" 
$sqlconn = "Data Source=$instance;Integrated Security=SSPI;Initial Catalog=Conversion; User Id=$userId; Password=$password"; 
$sqlbc = new-object system.data.sqlclient.Sqlbulkcopy($sqlconn); 
$sqlbc.BulkCopyTimeout = 0; 
$sqlbc.DestinationTableName="Table"; 
$sqlbc.WriteToServer($rdr); 
$sw.Stop(); 
Write-Host "[$($datetime)] [data1] Elapsed time $($sw.Elapsed.TotalMilliseconds) miliseconds"

Really appreciate your help

As per the error you received, how long is this running for before it errors? Have you looked into the CommandTimeout property of the connection? — Otter
– Otter, Commented Aug 8, 2021 at 9:44

Juozas Kaunas · Accepted Answer · 2021-08-08 10:27:35Z

1

Database timeouts means database network accessibility (e.q. firewalls) or DB down issues most of the time. First of all try to check TCP connectivity to DB:

New-Object System.Net.Sockets.TcpClient('10.x.x.xx', 5432)

If it throws errors you or your admins have to open access to DB port to your workstation first.

answered Aug 8, 2021 at 10:27

Juozas Kaunas

365 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

maverick Over a year ago

I have ping and telnet, its successful. but still getting that error

Juozas Kaunas Over a year ago

Can you access DB from other Postgres clients like pgAdmin from your workstation?

Michael Fayad · Accepted Answer · 2022-08-08 16:00:17Z

0

For me, I was getting this timeout error because my client was sending too much data and the execution would timeout.

answered Aug 8, 2022 at 16:00

Michael Fayad

1,3661 gold badge19 silver badges39 bronze badges

Collectives™ on Stack Overflow

Exception calling "ExecuteReader" with "0" argument(s): "ERROR [57014]

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related