Good morning,
Working on creating an External MFA Extension. I'm following the steps provided in the External MFA tutorial in the SDK docs. While trying to install the extension, I get the following error:
q2_sdk.core.exceptions.HqResponseError: HQ Request returned with error message: "Invalid object name 'dbo.Q2_MFAGroupProfile'."
I'm on SDK version 2.277.1 and I have ran q2 setup_db. However, when I run that command, I get the following output:
(.env) bbell@L16PC01:~/TOTP/avadian$ q2 setup_db
2025-07-14T11:15:42.940 q2_sdk.general INFO WebSocketUrl: wss://local-dev-api.q2developer.com/ws/avadian
2025-07-14T11:15:43.438 q2_sdk.general INFO Dev socket established to wss://local-dev-api.q2developer.com/ws/avadian
2025-07-14T11:15:43.439 q2_sdk.general INFO Service URL: https://local-dev-api.q2developer.com/proxy/bbell@avadiancu.com-avadian
Request update of the DB through the websocket. This can take up to a minute
Error applying "sql_scripts/10-add_edv_profile.sql"
(207, b"Invalid column name 'IsRealtime'.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")
Error applying "sql_scripts/10-create_host_account_data_element_with_references.sql"
(207, b"Invalid column name 'ExcludeInUserAccountResponse'.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")
Error applying "sql_scripts/10-get_edv_profile.sql"
(207, b"Invalid column name 'IsRealtime'.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")
Error applying "sql_scripts/10-get_host_account_data_element_with_references.sql"
(207, b"Invalid column name 'ExcludeInUserAccountResponse'.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")
Error applying "sql_scripts/10-get_system_property_data_with_references.sql"
(207, b"Invalid column name 'ExcludeInUserAccountResponse'.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")
Error applying "sql_scripts/10-get_zone_system_property_data_with_references.sql"
(207, b"Invalid column name 'ExcludeInUserAccountResponse'.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")
Error applying "sql_scripts/10-update_edv_profile.sql"
(207, b"Invalid column name 'IsRealtime'.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")
Error applying "sql_scripts/10-update_host_account_data_element_with_references.sql"
(207, b"Invalid column name 'ExcludeInUserAccountResponse'.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")
Error applying "dev_only/10-delete_host_account_click_type.sql"
(2714, b"There is already an object named 'sdk_DeleteHostAccountClickType' in the database.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")
2025-07-14T11:15:52.867 q2_sdk.general INFO Calling invalidate on 1 HQs: ['https://stack.q2developer.com/sdk/avadian/hq']
Complete
This should be taken care of. The sdk_DeleteHostAccountClickType is something still for us to work through, but the rest of them have been fixed. Thanks for the bug report!
Thanks Brian! Got it all setup. However, after completing all the steps in the tutorial, it's not calling out to my MFA extension but to the built in Q2 MFA process and it listing all SAC targets for a code to be sent to. Not sure what I'm missing here.
