https://github.com/sqlalchemy/sqlalchemy/issues/6658 will be fixed in the next release
though your program should not have to use the IDENTITY INSERT feature and we need to see your schema / Table. On Mon, Jun 21, 2021, at 5:57 PM, Mike Bayer wrote: > OK more specifically you seem to be using the "schema_translate_map" feature > and but for some reason SQLAlchemy is also attempting to manipulate the > IDENTITY INSERT feature, which normally should not be happening, and in this > case it appears there may be a bug in the SQL Server dialect that does not > correctly combine "schema_translate_map" with IDENTITY INSERT. > > however there is no reason IDENTITY INSERT should be changing here, I would > need to see the "CREATE TABLE" for this table as well as what your Table > metadata looks like. > > > > > On Mon, Jun 21, 2021, at 5:50 PM, Mike Bayer wrote: >> you have a Table that defines "schema" as "SCHEMA__none", and this schema >> does not exist. >> >> Schema definition is described at >> https://docs.sqlalchemy.org/en/14/core/metadata.html#specifying-the-schema-name >> . >> >> >> >> On Mon, Jun 21, 2021, at 4:34 PM, Victor Manuel Arévalo Fandiño wrote: >>> Hello >>> >>> I'm trying to insert a row in a table but I have the message: >>> "No se pudo realizar el insert en Tbl_cataloging_meeting:(<class >>> 'sqlalchemy.exc.ProgrammingError'>, >>> ProgrammingError('(pypyodbc.ProgrammingError) (\'42000\', \'[42000] >>> [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot find the >>> object "SCHEMA__none.tbl_cataloging_meeting" because it does not exist or >>> you do not have permissions.\')'), <traceback object at >>> 0x000002393E47B540>)" >>> I don't understand the reason of this message because I can write in other >>> table before, this is a fragment of my code: >>> >>> def make_inserts(self): >>> self.insert_tbl_act_template(self.list_tbl_act_template) >>> self.insert_tbl_cataloging_meeting(self.list_tbl_cataloging_meeting) >>> ----------------------------------------------------------------------------- >>> def insert_tbl_cataloging_meeting(self, cataloging_meeting_register): >>> try: >>> if cataloging_meeting_register is not None: >>> self.__session.add(cataloging_meeting_register) >>> self.__session.commit() >>> return cataloging_meeting_register >>> except: >>> mesagge = "No se pudo realizar el insert en Tbl_cataloging_meeting:" + >>> str(sys.exc_info()) >>> print(mesagge) >>> return None >>> >>> When call self.insert_tbl_act_template the insert is commited but >>> self.insert_tbl_cataloging_meeting doesn't work. Really I don't understand >>> the problemm. >>> the echo of sqlalchemy show me this: >>> >>> >>> 2021-06-21 15:05:31,235 INFO sqlalchemy.engine.Engine INSERT INTO >>> [PRESIDENCY_DATA].tbl_act_template (ate_name, ate_description, ate_resume, >>> ate_type_field, ate_is_valid, ate_created_at, ate_updated_at, >>> ate_deleted_at, ate_creator_id, ate_updater_id, ate_deleter_id, ate_file) >>> OUTPUT inserted.ate_id VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) >>> 2021-06-21 15:05:31,235 INFO sqlalchemy.engine.Engine [generated in >>> 0.00151s] ('City Council meeting minutes', 'City Council meeting minutes', >>> None, None, 0, datetime.datetime(2020, 8, 17, 8, 28, 55, 560000), >>> datetime.datetime(2020, 8, 17, 8, 28, 55, 560000), datetime.datetime(2020, >>> 8, 24, 16, 40, 22, 370000), 1167, 1167, 1167, 'Plantilla Acta.rdlx') >>> 2021-06-21 15:05:31,241 INFO sqlalchemy.engine.Engine COMMIT >>> 2021-06-21 15:05:31,245 INFO sqlalchemy.engine.Engine BEGIN (implicit) >>> 2021-06-21 15:05:31,250 INFO sqlalchemy.engine.Engine SELECT >>> [PRESIDENCY_DATA].tbl_act_template.ate_id AS tbl_act_template_ate_id, >>> [PRESIDENCY_DATA].tbl_act_template.ate_name AS tbl_act_template_ate_name, >>> [PRESIDENCY_DATA].tbl_act_template.ate_description AS >>> tbl_act_template_ate_description, >>> [PRESIDENCY_DATA].tbl_act_template.ate_resume AS >>> tbl_act_template_ate_resume, >>> [PRESIDENCY_DATA].tbl_act_template.ate_type_field AS >>> tbl_act_template_ate_type_field, >>> [PRESIDENCY_DATA].tbl_act_template.ate_is_valid AS >>> tbl_act_template_ate_is_valid, >>> [PRESIDENCY_DATA].tbl_act_template.ate_created_at AS >>> tbl_act_template_ate_created_at, >>> [PRESIDENCY_DATA].tbl_act_template.ate_updated_at AS >>> tbl_act_template_ate_updated_at, >>> [PRESIDENCY_DATA].tbl_act_template.ate_deleted_at AS >>> tbl_act_template_ate_deleted_at, >>> [PRESIDENCY_DATA].tbl_act_template.ate_creator_id AS >>> tbl_act_template_ate_creator_id, >>> [PRESIDENCY_DATA].tbl_act_template.ate_updater_id AS >>> tbl_act_template_ate_updater_id, >>> [PRESIDENCY_DATA].tbl_act_template.ate_deleter_id AS >>> tbl_act_template_ate_deleter_id, >>> [PRESIDENCY_DATA].tbl_act_template.ate_file AS tbl_act_template_ate_file >>> FROM [PRESIDENCY_DATA].tbl_act_template >>> WHERE [PRESIDENCY_DATA].tbl_act_template.ate_id = ? >>> 2021-06-21 15:05:31,250 INFO sqlalchemy.engine.Engine [generated in >>> 0.00039s] (59,) >>> 2021-06-21 15:05:37,829 INFO sqlalchemy.engine.Engine SET IDENTITY_INSERT >>> [SCHEMA__none].tbl_cataloging_meeting ON >>> 2021-06-21 15:05:37,829 INFO sqlalchemy.engine.Engine () >>> 2021-06-21 15:05:37,830 INFO sqlalchemy.engine.Engine ROLLBACK >>> No se pudo realizar el insert en Tbl_cataloging_meeting:(<class >>> 'sqlalchemy.exc.ProgrammingError'>, >>> ProgrammingError('(pypyodbc.ProgrammingError) (\'42000\', \'[42000] >>> [Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot find the >>> object "SCHEMA__none.tbl_cataloging_meeting" because it does not exist or >>> you do not have permissions.\')'), <traceback object at 0x000002393E47B540>) >>> >>> I appreciate some help. >>> >>> best regards >>> Víctor Manuel Arévalo Fandiño >>> >>> >>> -- >>> SQLAlchemy - >>> The Python SQL Toolkit and Object Relational Mapper >>> >>> http://www.sqlalchemy.org/ >>> >>> To post example code, please provide an MCVE: Minimal, Complete, and >>> Verifiable Example. See http://stackoverflow.com/help/mcve for a full >>> description. >>> --- >>> You received this message because you are subscribed to the Google Groups >>> "sqlalchemy" group. >>> To unsubscribe from this group and stop receiving emails from it, send an >>> email to sqlalchemy+unsubscr...@googlegroups.com. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/sqlalchemy/08bbdecf-4468-45f0-8f22-d50188c3747fn%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/sqlalchemy/08bbdecf-4468-45f0-8f22-d50188c3747fn%40googlegroups.com?utm_medium=email&utm_source=footer>. >> >> >> -- >> SQLAlchemy - >> The Python SQL Toolkit and Object Relational Mapper >> >> http://www.sqlalchemy.org/ >> >> To post example code, please provide an MCVE: Minimal, Complete, and >> Verifiable Example. See http://stackoverflow.com/help/mcve for a full >> description. >> --- >> You received this message because you are subscribed to the Google Groups >> "sqlalchemy" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to sqlalchemy+unsubscr...@googlegroups.com. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/sqlalchemy/c50ec032-1bf5-4279-ad28-479ecc19c858%40www.fastmail.com >> >> <https://groups.google.com/d/msgid/sqlalchemy/c50ec032-1bf5-4279-ad28-479ecc19c858%40www.fastmail.com?utm_medium=email&utm_source=footer>. > > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/0cba7d04-40b2-41a0-8fa9-b066de0f48ce%40www.fastmail.com > > <https://groups.google.com/d/msgid/sqlalchemy/0cba7d04-40b2-41a0-8fa9-b066de0f48ce%40www.fastmail.com?utm_medium=email&utm_source=footer>. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/b24e543d-b5d1-4ba2-9141-c046d593c28e%40www.fastmail.com.
