Bilan migration journalière : écriture dans bd_contmig

[bricesauvaget]

Pour les aloses, j’avais un précédent bilan journalier que j’avais lancé en juin.
En lançant l’écriture du nouveau bilan journalier dans la base (précédent bilan avec dépouillement au 22/05 seulement), l’ancien bilan a disparu :

require(stacomiR)

Le chargement a nécessité le package : stacomiR
Le chargement a nécessité le package : stacomirtools
Le chargement a nécessité le package : RODBC
Warning message:
replacing previous import ‘dplyr::id’ by ‘gWidgets::id’ when loading ‘stacomiR’

stacomi()

Loading required package: gWidgetsRGtk2
Loading required package: RGtk2
Loading required package: gWidgets
Loading required package: cairoDevice
Warning in str.default(val) : 'str.default': 'le' is NA, so taken as 0
Warning in str.default(obj, ...) :

'str.default': 'le' is NA, so taken as 0

Warning in str.default(val) : 'str.default': 'le' is NA, so taken as 0
Warning in str.default(obj, ...) :

'str.default': 'le' is NA, so taken as 0

Warning in str.default(val) : 'str.default': 'le' is NA, so taken as 0
Warning in str.default(obj, ...) :

'str.default': 'le' is NA, so taken as 0

[1] Bilan migration (pour une espece et un stade)\n
[1] Chargement des listes taxons et stades et dc\n
[1] Les pas de temps ont ete charges\n
[1] Le DC a ete selectionne \n
[1] selection des taxons du DC (pour l'instant sur toutes les periodes) \n
[1] Le taxon a ete selectionne \n
[1] Le stade a ete selectionne \n
data collected from the database nrow=233
[1] Chargement des donnees des operations:
[1] La requete est effectuee pour charger les pas de temps du DC \n
[1] La requete est effectuee pour charger les pas de temps du DF \n
[1] Debut du bilan migration... patientez \n
Loading required package: DBI
Loading required package: tcltk
[1] L'objet Bilan est stocke dans l'environnement envir_stacomi, ecrire ecrire bilanMigration=get('bilanMigration',envir_stacomi)\n
[1] Pour acceder aux donnees calculees, tappez bilanMigration@calcdata\n
[1] "plot type standard"
[1] Statistiques concernant la migration : \n
[1] dc= 5 Alosa Geniteur \n
[1] ---------------------\n
[1] nombre d'operations= 7201 \n
[1] duree moyenne du piegeage= 0.01 Jours\n
[1] duree max= 0.01 Jours\n
[1] duree min= 0 Jours\n
Warning in str.default(val) : 'str.default': 'le' is NA, so taken as 0
Warning in str.default(obj, ...) :

'str.default': 'le' is NA, so taken as 0

Warning in str.default(val) : 'str.default': 'le' is NA, so taken as 0
Warning in str.default(obj, ...) :

'str.default': 'le' is NA, so taken as 0

Warning in str.default(val) : 'str.default': 'le' is NA, so taken as 0
Warning in str.default(obj, ...) :

'str.default': 'le' is NA, so taken as 0

Warning in str.default(val) : 'str.default': 'le' is NA, so taken as 0
Warning in str.default(obj, ...) :

'str.default': 'le' is NA, so taken as 0

Warning in str.default(val) : 'str.default': 'le' is NA, so taken as 0
Warning in str.default(obj, ...) :

'str.default': 'le' is NA, so taken as 0

Warning in str.default(val) : 'str.default': 'le' is NA, so taken as 0
Warning in str.default(obj, ...) :

'str.default': 'le' is NA, so taken as 0

Warning in str.default(val) : 'str.default': 'le' is NA, so taken as 0
Warning in str.default(obj, ...) :

'str.default': 'le' is NA, so taken as 0

Warning in str.default(val) : 'str.default': 'le' is NA, so taken as 0
Warning in str.default(obj, ...) :

'str.default': 'le' is NA, so taken as 0

Warning in str.default(val) : 'str.default': 'le' is NA, so taken as 0
Warning in str.default(obj, ...) :

'str.default': 'le' is NA, so taken as 0

Warning in str.default(val) : 'str.default': 'le' is NA, so taken as 0
Warning in str.default(obj, ...) :

'str.default': 'le' is NA, so taken as 0

Error in postgresqlNewConnection(drv, ...) :

RS-DBI driver: (could not connect iav@localhost on dbname "bd_contmig_nat"

)
Error in !dbPreExists : invalid argument type
[1] Bilan migration inter-annuel\n
[1] Chargement des bilanJournaliers existants\n
[1] L'annee de debut a ete choisie\n
[1] L'annee de fin a ete choisie\n
[1] Le DC a ete selectionne \n
[1] selection des taxons du DC (pour l'instant sur toutes les periodes) \n
[1] Le taxon a ete selectionne \n
[1] Le stade a ete selectionne \n
[1] Ecriture du bilanMigrationInterannuelle dans l'environnement envir_stacomi : ecrire bmi=get('bilanMigrationInterannuelle',envir_stacomi)
[1] La requete est effectuee pour charger les migrations sur les annees 1996,1997,1998,1999,2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016 \n
choice annee

1: 1996 2: 1997 3: 1998 4: 1999 5: 2000 6: 2001 7: 2002 8: 2003 9: 2004 10: 2005 11: 2006

12: 2007 13: 2008 14: 2009 15: 2010 16: 2011 17: 2012 18: 2013 19: 2014 20: 2015

Warning in str.default(val) : 'str.default': 'le' is NA, so taken as 0
Warning in str.default(obj, ...) :

'str.default': 'le' is NA, so taken as 0

Warning in str.default(val) : 'str.default': 'le' is NA, so taken as 0
Warning in str.default(obj, ...) :

'str.default': 'le' is NA, so taken as 0

Warning in str.default(val) : 'str.default': 'le' is NA, so taken as 0
Warning in str.default(obj, ...) :

'str.default': 'le' is NA, so taken as 0

Warning in str.default(val) : 'str.default': 'le' is NA, so taken as 0
Warning in str.default(obj, ...) :

'str.default': 'le' is NA, so taken as 0

Warning in str.default(val) : 'str.default': 'le' is NA, so taken as 0
Warning in str.default(obj, ...) :

'str.default': 'le' is NA, so taken as 0