oTree Forum >

Error when trying to run a study via Heroku

#1 by Shawn


I've been trying to launch my study on Heroku, but I keep running into this issue (attached below). I have tried resetting the database several times, but does not appear to do anything. Could someone please point out what I might be doing wrong here? Please let me know if any additional information I can provide that may be helpful!

Thank you,

Failed to create session: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (decimal.InvalidOperation) [<class 'decimal.ConversionSyntax'>] [SQL: INSERT INTO pgg_group (id_in_subsession, round_number, n_players, has_dropout, bp_contribution, p1_nationrace, p2_nationrace, p1_age, p2_age, dyadicntl, dyadictype, total_contribution, individual_share, subsession_id, session_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] [parameters: [{'round_number': 1, 'session_id': 2, 'id_in_subsession': 1, 'subsession_id': 2, 'p1_age': None, 'p2_nationrace': None, 'total_contribution': None, 'individual_share': None, 'p2_age': None, 'dyadicntl': None, 'dyadictype': None, 'p1_nationrace': None, 'n_players': None}]]
Traceback (most recent call last):
  File "/app/.heroku/python/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1204, in _execute_context
    context = constructor(dialect, self, conn, *args)
  File "/app/.heroku/python/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 855, in _init_compiled
  File "/app/.heroku/python/lib/python3.10/site-packages/sqlalchemy/sql/type_api.py", line 1232, in process
    return process_param(value, dialect)
  File "/app/.heroku/python/lib/python3.10/site-packages/otree/database.py", line 426, in process_bind_param
    return str(Decimal(value))
decimal.InvalidOperation: []

The above exception was the direct cause of the following exception:

#2 by Shawn

Issue resolved. It was actually a blunder (typo)!

#3 by Trontatuma

Where was the blunder?

Write a reply

Set forum username