General Error <class 'sqlalchemy.exc.StatementError'>

[attahkhan016]

I did a test connection with my database , it showed it seems ok , i was able to see the tables too , but i clicked on save it is showing :
General Error <class 'sqlalchemy.exc.StatementError'>
error , please let me know what should i do to rectify this error

[xrmx]

Without a stackstrace this is unhelpful

[attahkhan016]

Hello Sir ,
what is stacktrace ? can you tell me more about it so that I can provide
you with it to rectify my error

On Wed, Oct 5, 2016 at 1:53 AM, Riccardo Magliocchetti <
notifications@github.com> wrote:

Without a stackstrace this is unhelpful

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
#1248 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/ATFd9-y1KfDtyzqCNaDF9-F5noleYJpsks5qwrXFgaJpZM4KNpax
.

Thanks & Regards,

Name: Mohammed Attaullah Khan
email id: attahkhan016@gmail.com
contact number:+91-8123030179

[attahkhan016]

hello , now i am getting this error :

Traceback (most recent call last):
File "/home/bitla-hs/venv/local/lib/python2.7/site-packages/flask/app.py", line 1988, in wsgi_app
response = self.full_dispatch_request()
File "/home/bitla-hs/venv/local/lib/python2.7/site-packages/flask/app.py", line 1641, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/home/bitla-hs/venv/local/lib/python2.7/site-packages/flask/app.py", line 1544, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/home/bitla-hs/venv/local/lib/python2.7/site-packages/flask/app.py", line 1639, in full_dispatch_request
rv = self.dispatch_request()
File "/home/bitla-hs/venv/local/lib/python2.7/site-packages/flask/app.py", line 1625, in dispatch_request
return self.view_functionsrule.endpoint
File "/home/bitla-hs/venv/local/lib/python2.7/site-packages/flask_appbuilder/security/decorators.py", line 25, in wraps
if self.appbuilder.sm.has_access(permission_str, self.class.name):
File "/home/bitla-hs/venv/local/lib/python2.7/site-packages/flask_appbuilder/security/manager.py", line 730, in has_access
return self._has_view_access(g.user, permission_name, view_name)
File "/home/bitla-hs/venv/local/lib/python2.7/site-packages/flask_appbuilder/security/manager.py", line 721, in _has_view_access
if (view_name == permission.view_menu.name) and (permission_name == permission.permission.name):
AttributeError: 'NoneType' object has no attribute 'name'

[attahkhan016]

will this be helpfull . please let me know asap

[ghost]

@xrmx I am getting the exact same issue. I setup my database connection with this URI

redshift+psycopg2://XXXXXXXXX:XXXXXXXXXX@XXXXXXXX:5439/XXXXXXX
(blanked out all the connection information - security reasons)

I did a [TEST CONNECTION] ... it returned "Seems OK!"

Then when I hit Save I get this error:

General Error <class 'sqlalchemy.exc.StatementError'>

Now this is what I can gather from the server console:

StatementError: (exceptions.AttributeError) 'module' object has no attribute 'DeprecatedIn12' [SQL: u'INSERT INTO dbs (created_on, changed_on, database_name, sqlalchemy_uri, password, cache_timeout, select_as_create_table_as, expose_in_sqllab, allow_run_sync, allow_run_async, allow_ctas, allow_dml, force_ctas_schema, extra, changed_by_fk, created_by_fk) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'] [parameters: [{'expose_in_sqllab': False, 'allow_run_sync': True, 'allow_ctas': False, 'extra': u'{\r\n "metadata_params": {},\r\n "engine_params": {}\r\n}\r\n', 'allow_dml': False, 'database_name': u'Test', 'sqlalchemy_uri': 'redshift+psycopg2://[removed URI]', 'cache_timeout': None, 'allow_run_async': False, 'force_ctas_schema': u'', 'password': u'Password123'}]] /usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/compiler.py:575: SAWarning: Can't resolve label reference u'changed_on desc'; converting to text() (this warning may be suppressed after 10 occurrences) util.ellipses_string(element.element)) /usr/local/lib/python2.7/dist-packages/flask_appbuilder/forms.py:245: FlaskWTFDeprecationWarning: "flask_wtf.Form" has been renamed to "FlaskForm" and will be removed in 1.0. form = self(obj=obj) /usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/sqltypes.py:562: SAWarning: Dialect sqlite+pysqlite does *not* support Decimal objects natively, and SQLAlchemy must convert from floating point - rounding errors and other issues may occur. Please consider storing Decimal numbers as strings or integers on this platform for lossless storage. 'storage.' % (dialect.name, dialect.driver))

I saw other posts about this issue and instead of resolving they kept getting closed. Let's not close this please. Thank you!

[ghost]

@xrmx @attahkhan016 I ran a

sudo pip install cryptography --upgrade

And this seemed to resolve my issue.

[xrmx]

@jayjain89 please don't hijack other issues with unrelated comments, thanks.

[attahkhan016]

@xrmx this caravel is too sensitive ? as I install in one computer it works okay , next moment it crashes . May I know the reason behind it . As we are planning for a stable BI ?

[ghost]

@xrmx how am I hijacking? I had the exact same issue as @attahkhan016.

Did you not read what I posted?

[attahkhan016]

@xrmx I am facing new errors every time I install it, in a desktop , laptop or VPS. Sometimes it gets killed on its own or sometimes it states that the dependent packages are old , can you guide me step by step to deploy in a Ubuntu VPS a stable caravel with all the updated packages and lib to have a successful installation .
p.s: Ihave gone through all the installation setup document but it isnt helping .

[xrmx]

@jayjain89 you really have a completely diferent issue issue and i'd appreciate a bit more respect please.

Anyway closing in favour of #1411 as it has more info than this issue.