Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error when inserting/updating #1

Open
CarlosHorro opened this issue Aug 4, 2021 · 0 comments
Open

Error when inserting/updating #1

CarlosHorro opened this issue Aug 4, 2021 · 0 comments

Comments

@CarlosHorro
Copy link

CarlosHorro commented Aug 4, 2021

Hi Kim,

I'm Carlos from the CBU, i hope you are fine :-)
When exporting a history in NGA, I'm having some issues (both in local and test) with the db_utils from kbr when trying to insert/update (add and update functions) :


2021-08-04 14:02:27 nels-galaxy-api.ERROR    Error during export registation: This result object does not return rows. It has been closed automatically.
ERROR:nels-galaxy-api:Error during export registation: This result object does not return rows. It has been closed automatically.

Digging into it, I realised it happens because of the call to self.do( q ), as its

return self._db.query( sql, fetchall=self._fetchall )

does not return anything when executing an insert/update command and it throws an exception. Just replacing the calls to self.do( q ) in add/update functions by

self._db.bulk_query( q )

makes everything to work again.
Could you help me with this, please?

Greetings,
Carlos

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant