[ERROR] object of type 'bool' has no len()

[rnnall]

Hello,

I am struggling with the below error trying to run from cron. I am out of practice with Linux commands and cold use some help. I get the following error when trying to run PW_PVOExport.py from cron. I have tried to ran as local user and root. I am able to run form command line python PW_PVOExport.py and have successful uploaded PW2EG. I am running this form a NetGear ReadyNAS system.

Version
PowerWall 1.17.2
Python 2.7.9 (default, Aug 13 2016, 17:33:18) [GCC 4.9.2]
Linux 4.4.116.armada.1

Changes PW_Helper.py
Disable the HTTPS to HTTP From https://'+PowerwallIP+'/api/meters/aggregates to http://'+PowerwallIP+'/api/meters/aggregates as my Powerwall does not answer to HTTPS

ERROR

2018-08-05 14:04:02,232 - Start PVOutput export
2018-08-05 14:04:03,328 - get_sqlite_data: no such table: View_pw
2018-08-05 14:04:03,455 - [ERROR] object of type 'bool' has no len()
2018-08-05 14:04:03,460 - delete_sqlite_data: no such table: pw
2018-08-05 14:04:03,489 - End PVOutput export

crontab configuraiton

* * * * * /usr/bin/python /home/user/path/PW_PVOExport.py >/home/user/path/err.log 2>&1

Noticed that the directory above /home/user/path/ two additional files get created pvo.log & pw.sqlite the Working Directory has these files and being populated with data as I see the pw.sqlite being populated .

Additional Files

.
├── [4.0K]  Powerwall2PVOutput (Working Directory)
├── [9.4K]  pvo.log
├── [4.0K]  pw.sqlite

Working Directory

.
├── [4.0K]  Powerwall2PVOutput
│   ├── [4.0K]  BAK
│   │   ├── [ 311]  PW_Config.py
│   │   ├── [1.1K]  PW_Datalogger.py
│   │   ├── [5.4K]  PW_Helper.py
│   │   ├── [2.2K]  PW_PVOExport.py
│   │   └── [3.0K]  PW_Simple.py
│   ├── [9.4K]  err.log
│   ├── [ 60K]  ExtendedData7_8.png
│   ├── [ 95K]  ExtendedData9_12.png
│   ├── [ 22K]  pvo.log
│   ├── [ 311]  PW_Config.py
│   ├── [ 432]  PW_Config.pyc
│   ├── [1.1K]  PW_Datalogger.py
│   ├── [5.4K]  PW_Helper.py
│   ├── [6.3K]  PW_Helper.pyc
│   ├── [2.3K]  PW_PVOExport.py
│   ├── [3.0K]  PW_Simple.py
│   ├── [859K]  pw.sqlite
│   ├── [4.0K]  pyc
│   │   ├── [ 439]  PW_Config.pyc
│   │   └── [6.4K]  PW_Helper.pyc
│   └── [1.4K]  README.md

Thanks,

RN

[ekul135]

Do you have the correct path to the sqlite file? Also did you download the sqlite file? Error suggests your sqlite db does not have the appropriate table.

…

On Mon, Aug 6, 2018 at 7:25 AM rnnall ***@***.***> wrote: Hello, I am struggling with the below error trying to run from the cron. I am out of practice with Linux commands and cold use some help. I get the following error when trying to run PW_PVOExport.py from cron. Ran as local user and root. PowerWall version 1.17.2. I had to disable the HTTPS to HTTP *From* https://'+PowerwallIP+'/api/meters/aggregates *to* http:// '+PowerwallIP+'/api/meters/aggregates as my system does not answer to HTTPS I am able to run form command line python PW_PVOExport.py and have successful uploads. *ERROR* 2018-08-05 14:04:02,232 - Start PVOutput export 2018-08-05 14:04:03,328 - get_sqlite_data: no such table: View_pw 2018-08-05 14:04:03,455 - [ERROR] object of type 'bool' has no len() 2018-08-05 14:04:03,460 - delete_sqlite_data: no such table: pw 2018-08-05 14:04:03,489 - End PVOutput export *crontab configuraiton* * * * * * /usr/bin/python /home/user/path/PW_PVOExport.py >/home/user/path/err.log 2>&1 Noticed that the directory above /home/user/path/ two files get crated . ├── Powerwall2PVOutput ├── pvo.log ├── pw.sqlite *Working Directory* . ├── err.log ├── ExtendedData7_8.png ├── ExtendedData9_12.png ├── pvo.log ├── PW_Config.py ├── PW_Config.pyc ├── PW_Datalogger.py ├── PW_Helper.py ├── PW_Helper.pyc ├── PW_PVOExport.py ├── PW_Simple.py ├── pw.sqlite ├── pyc │ ├── PW_Config.pyc │ └── PW_Helper.pyc └── README.md — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#10>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AATId6ZTi0sJ3ihtlVoQWZCGQpak5KuPks5uN2LJgaJpZM4VviqZ> .

[rnnall]

Doh!

Thank you for the quick repose you pointed me into the right direction. Turns out I need to include the absolute path in the PW_Config.py

Changed from:

log_file = "pvo.log"
sqlite_file = "pw.sqlite"

TO:

log_file = "/home/user/path/pvo.log"
sqlite_file = "/home/user/path/pw.sqlite"

[blokl]

Hello Ekul, I will change the config file and see is it stay’s away. Thx, Leo Van: rnnall <notifications@github.com> Verzonden: maandag 6 augustus 2018 06:00 Aan: ekul135/Powerwall2PVOutput <Powerwall2PVOutput@noreply.github.com> CC: Subscribed <subscribed@noreply.github.com> Onderwerp: Re: [ekul135/Powerwall2PVOutput] [ERROR] object of type 'bool' has no len() (#10) Doh! Thank you for the quick repose you pointed me into the right direction. Turns out I need to include the absolute path in the PW_Config.py Changed from: log_file = "pvo.log" sqlite_file = "pw.sqlite" TO: log_file = "/home/user/path/pvo.log" sqlite_file = "/home/user/path/pw.sqlite" — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub<#10 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AkBhT042QNqOfQGfLgZUm-xLoB_c1k0tks5uN78ygaJpZM4VviqZ>.