Can not upload to Oracle Database

Support, advice and resources for the Raspberry Pi Oracle Weather Station for schools

2 posts
by palassi123 » Thu May 18, 2017 8:01 pm
Hello to all,
We finally made it to get Raspberry Pi working. We got measurements locally but we can not upload it to Oracle database.
THe message we get when running sudo ./upload_to_oracle.py is

pi@raspberrypi:~/weather-station $ sudo ./upload_to_oracle.py
#No other uploads in progress, proceeding...
9165 rows to send...
Traceback (most recent call last):
File "./upload_to_oracle.py", line 12, in <module> db.upload()
File "/home/pi/weather-station/database.py", line 132, in upload odb = oracle_apex_database(path = "/pls/apex/raspberrypi/weatherstation/submitmeasurement")
File "/home/pi/weather-station/database.py", line 42, in __init__ self.credentials = json.load(f)
File "/usr/lib/python2.7/json/__init__.py", line 290, in load **kw)
File "/usr/lib/python2.7/json/__init__.py", line 338, in loads return _default_decoder.decode(s)
File "/usr/lib/python2.7/json/decoder.py", line 366, in decode obj, end = self.raw_decode(s, idx=_w(s, 0).end())
File "/usr/lib/python2.7/json/decoder.py", line 384, in raw_decode raise ValueError("No JSON object could be decoded")
ValueError: No JSON object could be decoded

Any ideas???
Posts: 4
Joined: Mon Oct 03, 2016 1:13 pm
by DougieLawson » Sat May 20, 2017 7:11 am
Have you got the right station id and key in your Oracle credentials file?
Microprocessor, Raspberry Pi & Arduino Hacker
Mainframe database troubleshooter
MQTT Evangelist
Twitter: @DougieLawson

Since 2012: 1B*5, 2B*2, B+, A+, Zero*2, 3B*3

Please post ALL technical questions on the forum. Do not send private messages.
User avatar
Posts: 28160
Joined: Sun Jun 16, 2013 11:19 pm
Location: Basingstoke, UK