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

  • Asked
  • Active
  • Viewed 12654 times
0

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!

asked

wexxo 97●2●31●46 accept rate: 4%

0

Accepted answer

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

permanent link

answered

wexxo 97●2●31●46 accept rate: 4%

Your answer

Insert an image

Say what the image shows, for people who can't see it.
At least 50 characters

Powered by the Open Foris edition of OSQA Content licensed under CC BY-SA 3.0

This Q&A software is free and open source (GPL). Any organisation can run it for its own community: get the code and instructions at github.com/openforis/osqa.

Keyboard shortcuts

Anywhere

?
Show this list
/
Search
g h
Go to the home page
g q
Go to the questions
g t
Go to the tags
g u
Go to the users
a
Ask a question

Lists of questions

j k
Next or previous question
Enter
Open the question

Question pages

j k
Next or previous post

Shortcuts never apply while you type in a text field. Members can turn them off in their preferences.