It is problem in query generator for sequence for table, it's broken. Just
add '(' and ')' in code
*gluon/packages/dal/pydal/adapters/oracle.py in
create_sequence_and_triggers at line 70*
*before:*
'CREATE SEQUENCE %s START WITH 1 INCREMENT BY 1 NOMAXVALUE ' +
'MINVALUE -1;' % sequence_name)
*after:*
*(*'CREATE SEQUENCE %s START WITH 1 INCREMENT BY 1 NOMAXVALUE ' +
'MINVALUE -1;'*)* % sequence_name)
and drop created table and restart web2py
четверг, 24 августа 2017 г., 2:57:14 UTC+3 пользователь Zbigniew
Pomianowski написал:
>
> After i upgraded to 2.15.3 I got serious problems with Oracle. First of
> all: new lowercase tables were created. Then I read that this is due to the
> new "entity_quoting" option. Nevertheles I decided to degrade my project to
> basic auth tables (nothing more!).
> I dropped everything on Oracle side via sqlplus. After first request I got
> this error. Migration is active to create tables, "app_auth_user" is
> created and then error. No *.table files in databases folder. Fighting
> several hours with this (so basic!) issue.
> I am getting crazy because of that :(
>
> Note: I changed oracle.py at line 70, because "all parameters were not
> converted" error
>
> Can anyone help?
>
> Environment: python 2.7.12, oracle 12.2, cx_Oracle 6.0.1, web2py 2.15.3,
> Ubuntu 16.04 LTS
>
>
> Traceback (most recent call last):
> File "/home/zpomianowski/web2py/gluon/restricted.py", line 219, in
> restricted
> exec(ccode, environment)
> File "/home/zpomianowski/web2py/applications/eparagon/models/db.py"
> <http://127.0.0.1:8000/admin/default/edit/eparagon/models/db.py>, line 59, in
> <module>
> auth.define_tables(username=False, signature=False)
> File "/home/zpomianowski/web2py/gluon/tools.py", line 2216, in define_tables
> super(Auth, self).define_tables(username, signature, migrate,
> fake_migrate)._table_signature_list
> File "/home/zpomianowski/web2py/gluon/authapi.py", line 350, in
> define_tables
> format='%(first_name)s %(last_name)s (%(id)s)'))
> File "/home/zpomianowski/web2py/gluon/packages/dal/pydal/base.py", line
> 587, in define_table
> table = self.lazy_define_table(tablename, *fields, **args)
> File "/home/zpomianowski/web2py/gluon/packages/dal/pydal/base.py", line
> 621, in lazy_define_table
> polymodel=polymodel)
> File "/home/zpomianowski/web2py/gluon/packages/dal/pydal/adapters/base.py",
> line 797, in create_table
> return self.migrator.create_table(*args, **kwargs)
> File "/home/zpomianowski/web2py/gluon/packages/dal/pydal/migrator.py", line
> 277, in create_table
> self.adapter.create_sequence_and_triggers(query, table)
> File
> "/home/zpomianowski/web2py/gluon/packages/dal/pydal/adapters/oracle.py", line
> 68, in create_sequence_and_triggers
> self.execute(query)
> File
> "/home/zpomianowski/web2py/gluon/packages/dal/pydal/adapters/__init__.py",
> line 67, in wrap
> return f(*args, **kwargs)
> File
> "/home/zpomianowski/web2py/gluon/packages/dal/pydal/adapters/oracle.py", line
> 52, in execute
> rv = self.cursor.execute(command, *args[1:], **kwargs)
> DatabaseError: ORA-00955: name is already used by an existing object
>
>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
