---
title: "ERROR: Error in postgresqlExecStatement(conn, statement, ...): RS-DBI driver: (could not Retrieve the result"
url: "https://openforis.support/questions/2240/error-error-in-postgresqlexecstatementconn-statement-rs-dbi-driver-could-not-retrieve-the-result"
tags: ["calc"]
status: "answered"
score: 0
answer_count: 1
asked: "2019-04-03T18:45:15"
last_activity: "2019-04-16T07:07:01"
source: "Open Foris Support - Q&A Forum"
license: "Copyright Open Foris, 2021. Some rights reserved under creative commons license."
---

# ERROR: Error in postgresqlExecStatement(conn, statement, ...): RS-DBI driver: (could not Retrieve the result

Asked by wexxo on 2019-04-03

Hi Mino et al.,

when trying to load my calculations from R Studio into the database via Calc, I get the following error (see below). In R, all the scripts run smoothly. Where do I have to look?

Error in 'R Scripts - Processing chain' 
 2019-04-03 18:15:12     step : 1-init.R
INFO: Processing chain started 
Lade nötiges Paket: DBI
Lade nötiges Paket: gsubfn
Lade nötiges Paket: proto
Lade nötiges Paket: RSQLite
2019-04-03 18:15:14     step : -
ERROR: Error in postgresqlExecStatement(conn, statement, ...): RS-DBI driver: (could not Retrieve the result : FEHLER:  Spalte »plot_id_« mehrmals angegeben
)
 
Thank you so much for your help!


## Answer (score 0, by wexxo on 2019-04-16)

Link: https://openforis.support/questions/2240/error-error-in-postgresqlexecstatementconn-statement-rs-dbi-driver-could-not-retrieve-the-result/2261

Hi all,

in the meantime, I identified the cause of the above error as an incompatible sampling design. The sampling design set-up in Calc did not fit the uploaded survey structure. With an adequate sampling strategy defined, the R-script base calculations are loaded into the database without any problem.

Maybe this is of help to others.

Cheers,

Alex