Installing insights…
Updating DocTypes for insights : [== ] 6%An error occurred while installing insights: Module import failed for Insights Table v3, the DocType you’re trying to open might be deleted.
Error: No module named ‘_sqlite3’
Traceback with variables (most recent call last):
File “apps/frappe/frappe/commands/site.py”, line 478, in install_app
_install_app(app, verbose=context.verbose, force=force)
context = {‘sites’: [‘cars2.iban-erp.com’], ‘force’: False, ‘verbose’: False, ‘profile’: False}
apps = (‘insights’,)
force = False
_install_app = <function install_app at 0x7faff8348900>
filelock = <function filelock at 0x7faff832e700>
exit_code = 0
site = ‘cars2.iban-erp.com’
app = ‘insights’
err = ImportError(“Module import failed for Insights Table v3, the DocType you’re trying to open might be deleted.\nError: No module named ‘_sqlite3’”)
File “apps/frappe/frappe/installer.py”, line 316, in install_app
sync_for(name, force=force, reset_permissions=True)
name = ‘insights’
verbose = False
set_as_patched = True
force = False
sync_jobs = <function sync_jobs at 0x7faff784cf40>
sync_for = <function sync_for at 0x7faff784dd00>
sync_customizations = <function sync_customizations at 0x7faff910a7a0>
sync_fixtures = <function sync_fixtures at 0x7faff784e020>
app_hooks = {‘add_to_apps_screen’: [{‘name’: ‘insights’, ‘logo’: ‘/assets/insights/frontend/insights-logo.png’, ‘title’: ‘Insights’, ‘route’: ‘/insights’, ‘has_permission’: ‘insights.permissions.check_app_permission’}], ‘after_migrate’: [‘insights.migrate.after_migrate’], ‘after_request’: [‘insights.insights.doctype.insights_data_source_v3.insights_data_source_v3.after_request’], ‘app_color’: [‘grey’], ‘app_description’: [‘Powerful Reporting Tool for Frappe Apps’], ‘app_email’: [‘hello@frappe.io’], ‘app_icon’: [‘octicon octicon-file-directory’], ‘app_license’: [‘GNU GPLv3’], ‘app_name’: [‘insights’], ‘app_publisher’: [‘Frappe Technologies Pvt. Ltd.’], ‘app_title’: [‘Frappe Insights’], ‘before_request’: [‘insights.insights.doctype.insights_data_source_v3.insights_data_source_v3.before_request’], ‘before_tests’: [‘insights.tests.utils.before_tests’], ‘doc_events’: {‘User’: {‘on_change’: [‘insights.insights.doctype.insights_team.insights_team.update_admin_team’]}}, ‘export_python_type_annotations’: […
installed_apps = [‘frappe’, ‘erpnext’, ‘netmanthan_themes’, ‘erpnext_ksa’, ‘hrms’, ‘iban_line2’, ‘car_repair’, ‘contracta’]
File “apps/frappe/frappe/model/sync.py”, line 111, in sync_for
import_file_by_path(
app_name = ‘insights’
force = False
reset_permissions = True
files = [‘apps/insights/insights/insights/doctype/insights_dashboard_item/insights_dashboard_item.json’, ‘apps/insights/insights/insights/doctype/insights_query_transform/insights_query_transform.json’, ‘apps/insights/insights/insights/doctype/insights_table_v3/insights_table_v3.json’, ‘apps/insights/insights/insights/doctype/insights_resource_permission/insights_resource_permission.json’, ‘apps/insights/insights/insights/doctype/insights_alert/insights_alert.json’, ‘apps/insights/insights/insights/doctype/insights_query_result/insights_query_result.json’, ‘apps/insights/insights/insights/doctype/insights_team/insights_team.json’, ‘apps/insights/insights/insights/doctype/insights_table_link/insights_table_link.json’, 'apps/insights/insights/insights/doctype/insights_settings/insights_settin…
module_name = ‘insights’
folder = ‘apps/insights/insights/insights’
l = 30
i = 2
doc_path = ‘apps/insights/insights/insights/doctype/insights_table_v3/insights_table_v3.json’
File “apps/frappe/frappe/modules/import_file.py”, line 146, in import_file_by_path
import_doc(
path = ‘apps/insights/insights/insights/doctype/insights_table_v3/insights_table_v3.json’
force = False
data_import = False
pre_process = None
ignore_version = True
reset_permissions = True
docs = [{‘actions’: , ‘creation’: ‘2024-06-09 19:42:19.655930’, ‘doctype’: ‘DocType’, ‘editable_grid’: 1, ‘engine’: ‘InnoDB’, ‘fields’: [{‘fieldname’: ‘table’, ‘fieldtype’: ‘Data’, ‘in_list_view’: 1, ‘in_standard_filter’: 1, ‘label’: ‘Table’, ‘reqd’: 1, ‘doctype’: ‘DocField’}, {‘fieldname’: ‘label’, ‘fieldtype’: ‘Data’, ‘label’: ‘Label’, ‘reqd’: 1, ‘doctype’: ‘DocField’}, {‘fieldname’: ‘column_break_3’, ‘fieldtype’: ‘Column Break’, ‘doctype’: ‘DocField’}, {‘fieldname’: ‘data_source’, ‘fieldtype’: ‘Link’, ‘in_list_view’: 1, ‘in_standard_filter’: 1, ‘label’: ‘Data Source’, ‘options’: ‘Insights Data Source v3’, ‘reqd’: 1, ‘search_index’: 1, ‘doctype’: ‘DocField’}, {‘fieldname’: ‘last_synced_on’, ‘fieldtype’: ‘Datetime’, ‘label’: ‘Last Synced On’, ‘read_only’: 1, ‘doctype’: ‘DocField’}, {‘default’: ‘0’, ‘fieldname’: ‘stored’, ‘fieldtype’: ‘Check’, ‘label’: ‘Stored’, ‘read_only’: 1, ‘doctype’: ‘DocField’}], ‘index_web_pages_for_search’: 1, ‘links’: , ‘modified’: ‘2024-10-27 15:25:38.258981’, '…
calculated_hash = ‘f6d84c9ecb7e329a4f94908ddaa6a2fd’
doc = {‘actions’: , ‘creation’: ‘2024-06-09 19:42:19.655930’, ‘doctype’: ‘DocType’, ‘editable_grid’: 1, ‘engine’: ‘InnoDB’, ‘fields’: [{‘fieldname’: ‘table’, ‘fieldtype’: ‘Data’, ‘in_list_view’: 1, ‘in_standard_filter’: 1, ‘label’: ‘Table’, ‘reqd’: 1, ‘doctype’: ‘DocField’}, {‘fieldname’: ‘label’, ‘fieldtype’: ‘Data’, ‘label’: ‘Label’, ‘reqd’: 1, ‘doctype’: ‘DocField’}, {‘fieldname’: ‘column_break_3’, ‘fieldtype’: ‘Column Break’, ‘doctype’: ‘DocField’}, {‘fieldname’: ‘data_source’, ‘fieldtype’: ‘Link’, ‘in_list_view’: 1, ‘in_standard_filter’: 1, ‘label’: ‘Data Source’, ‘options’: ‘Insights Data Source v3’, ‘reqd’: 1, ‘search_index’: 1, ‘doctype’: ‘DocField’}, {‘fieldname’: ‘last_synced_on’, ‘fieldtype’: ‘Datetime’, ‘label’: ‘Last Synced On’, ‘read_only’: 1, ‘doctype’: ‘DocField’}, {‘default’: ‘0’, ‘fieldname’: ‘stored’, ‘fieldtype’: ‘Check’, ‘label’: ‘Stored’, ‘read_only’: 1, ‘doctype’: ‘DocField’}], ‘index_web_pages_for_search’: 1, ‘links’: , ‘modified’: ‘2024-10-27 15:25:38.258981’, 'm…
db_modified_timestamp = None
is_db_timestamp_latest = None
File “apps/frappe/frappe/modules/import_file.py”, line 239, in import_doc
doc.insert()
docdict = {‘actions’: , ‘creation’: ‘2024-06-09 19:42:19.655930’, ‘doctype’: ‘DocType’, ‘editable_grid’: 1, ‘engine’: ‘InnoDB’, ‘fields’: [{‘fieldname’: ‘table’, ‘fieldtype’: ‘Data’, ‘in_list_view’: 1, ‘in_standard_filter’: 1, ‘label’: ‘Table’, ‘reqd’: 1, ‘doctype’: ‘DocField’}, {‘fieldname’: ‘label’, ‘fieldtype’: ‘Data’, ‘label’: ‘Label’, ‘reqd’: 1, ‘doctype’: ‘DocField’}, {‘fieldname’: ‘column_break_3’, ‘fieldtype’: ‘Column Break’, ‘doctype’: ‘DocField’}, {‘fieldname’: ‘data_source’, ‘fieldtype’: ‘Link’, ‘in_list_view’: 1, ‘in_standard_filter’: 1, ‘label’: ‘Data Source’, ‘options’: ‘Insights Data Source v3’, ‘reqd’: 1, ‘search_index’: 1, ‘doctype’: ‘DocField’}, {‘fieldname’: ‘last_synced_on’, ‘fieldtype’: ‘Datetime’, ‘label’: ‘Last Synced On’, ‘read_only’: 1, ‘doctype’: ‘DocField’}, {‘default’: ‘0’, ‘fieldname’: ‘stored’, ‘fieldtype’: ‘Check’, ‘label’: ‘Stored’, ‘read_only’: 1, ‘doctype’: ‘DocField’}], ‘index_web_pages_for_search’: 1, ‘links’: , ‘modified’: ‘2024-10-27 15:25:38.258981’, ‘m…
data_import = False
pre_process = None
ignore_version = True
reset_permissions = True
path = ‘apps/insights/insights/insights/doctype/insights_table_v3/insights_table_v3.json’
controller = <class ‘frappe.core.doctype.doctype.doctype.DocType’>
doc = <DocType: Insights Table v3>
File “apps/frappe/frappe/model/document.py”, line 315, in insert
self.run_post_save_methods()
self = <DocType: Insights Table v3>
ignore_permissions = None
ignore_links = None
ignore_if_duplicate = False
ignore_mandatory = None
set_name = None
set_child_names = True
d = <DocPerm: d7nlnh2dpp parent=Insights Table v3>
File “apps/frappe/frappe/model/document.py”, line 1128, in run_post_save_methods
self.run_method(“on_update”)
self = <DocType: Insights Table v3>
File “apps/frappe/frappe/model/document.py”, line 962, in run_method
out = Document.hook(fn)(self, *args, **kwargs)
self = <DocType: Insights Table v3>
method = ‘on_update’
args = ()
kwargs = {}
fn = <function Document.run_method..fn at 0x7fafd82ca7a0>
File “apps/frappe/frappe/model/document.py”, line 1322, in composer
return composed(self, method, args, **kwargs)
self = <DocType: Insights Table v3>
args = ()
kwargs = {}
hooks = [<function build_domain_restriced_doctype_cache at 0x7faff8ca9580>, <function clear_doctype_notifications at 0x7fafd83e6f20>, <function process_workflow_actions at 0x7fafd821f420>, <function attach_files_to_document at 0x7faff9758720>, <function apply at 0x7fafd82322a0>, <function update_due_date at 0x7fafd8232340>, <function apply_permissions_for_non_standard_user_type at 0x7fafd8233b00>]
method = ‘on_update’
doc_events = {'’: {‘on_update’: [‘frappe.desk.notifications.clear_doctype_notifications’, ‘frappe.workflow.doctype.workflow_action.workflow_action.process_workflow_actions’, ‘frappe.core.doctype.file.utils.attach_files_to_document’, ‘frappe.automation.doctype.assignment_rule.assignment_rule.apply’, ‘frappe.automation.doctype.assignment_rule.assignment_rule.update_due_date’, ‘frappe.core.doctype.user_type.user_type.apply_permissions_for_non_standard_user_type’], ‘after_rename’: [‘frappe.desk.notifications.clear_doctype_notifications’], ‘on_cancel’: [‘frappe.desk.notifications.clear_doctype_notifications’, ‘frappe.workflow.doctype.workflow_action.workflow_action.process_workflow_actions’, ‘frappe.automation.doctype.assignment_rule.assignment_rule.apply’], ‘on_trash’: [‘frappe.desk.notifications.clear_doctype_notifications’, ‘frappe.workflow.doctype.workflow_action.workflow_action.process_workflow_actions’], ‘on_update_after_submit’: ['frappe.workflow.doctype.workflow_action.workflow_action.process_w…
handler = ‘frappe.core.doctype.user_type.user_type.apply_permissions_for_non_standard_user_type’
composed = <function Document.hook..compose..runner at 0x7fafd82ca700>
compose = <function Document.hook..compose at 0x7fafd82ca840>
f = <function Document.run_method..fn at 0x7fafd82ca7a0>
File “apps/frappe/frappe/model/document.py”, line 1304, in runner
add_to_return_value(self, fn(self, *args, **kwargs))
self = <DocType: Insights Table v3>
method = ‘on_update’
args = ()
kwargs = {}
add_to_return_value = <function Document.hook..add_to_return_value at 0x7fafd82ca520>
fn = <function Document.run_method..fn at 0x7fafd82ca7a0>
hooks = (<function build_domain_restriced_doctype_cache at 0x7faff8ca9580>, <function clear_doctype_notifications at 0x7fafd83e6f20>, <function process_workflow_actions at 0x7fafd821f420>, <function attach_files_to_document at 0x7faff9758720>, <function apply at 0x7fafd82322a0>, <function update_due_date at 0x7fafd8232340>, <function apply_permissions_for_non_standard_user_type at 0x7fafd8233b00>)
File “apps/frappe/frappe/model/document.py”, line 959, in fn
return method_object(*args, **kwargs)
self = <DocType: Insights Table v3>
args = ()
kwargs = {}
method_object = <bound method DocType.on_update of <DocType: Insights Table v3>>
method = ‘on_update’
File “apps/frappe/frappe/core/doctype/doctype/doctype.py”, line 531, in on_update
self.run_module_method(“on_doctype_update”)
self = <DocType: Insights Table v3>
allow_doctype_export = False
File “apps/frappe/frappe/core/doctype/doctype/doctype.py”, line 629, in run_module_method
module = load_doctype_module(self.name, self.module)
self = <DocType: Insights Table v3>
method = ‘on_doctype_update’
load_doctype_module = <function load_doctype_module at 0x7faff910ade0>
File “apps/frappe/frappe/modules/utils.py”, line 258, in load_doctype_module
raise ImportError(msg) from e
doctype = ‘Insights Table v3’
module = ‘Insights’
prefix = ‘’
suffix = ‘’
app = ‘insights’
key = ********
module_name = ‘insights.insights.doctype.insights_table_v3.insights_table_v3’
msg = “Module import failed for Insights Table v3, the DocType you’re trying to open might be deleted.\nError: No module named ‘_sqlite3’”
builtins.ImportError: Module import failed for Insights Table v3, the DocType you’re trying to open might be deleted.
Error: No module named ‘_sqlite3’