I am experiencing issues after installing Frappe Insights, wherein I cannot see Queries tab, and other tools in my insights, am I missing something?
click the insights logo and switch to v2
I think they have removed that option as I cannot see such option, I see Documentation, Switch to Desk, Join Telegram group and Log Out
This is the new version of Insights, which was released in November. You can learn more about how it works in the documentation.
The “Switch to v2” button is only visible if you have any older queries on the site. Any reason you’re looking for the older version?
I am looking for the features offered by previous v2. Also ibis is not what I am used to as v3 uses it.
I also found some features which are roadblocking me.
When I make charts with sql editor, which I basically use for complex querying, and then combine them to make a dashboard, when I filter, they are filtered for only specific charts for which I selected the filters. It could be better if we had a generalized filter.
I also cannot write filters in form of expressions correctly, It would be really helpful if there is a separate detailed documentation on using this feature especially after a shift to ibis.
Any suggestion/correction would be really helpful.
Thank You.
I also tried to install older version of insights using tags from github, but after successful installation, I cannot access /insights. I used version 2.2.8.
l
Bench migrate runs perfectly, but bench build gives this error-
Running build command for insights
$ cd frontend && yarn build
$ vite build -l warn --base=/assets/insights/frontend/ && yarn copy-html-entry
/bin/sh: 1: vite: not found
error Command failed with exit code 127.
info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.
error Command failed with exit code 127.
info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.
Error: Command failed: yarn build
at checkExecSyncError (node:child_process:890:11)
at execSync (node:child_process:962:15)
at run_build_command_for_apps (/home/ts/frappe-bench/apps/frappe/esbuild/esbuild.js:448:5)
at execute (/home/ts/frappe-bench/apps/frappe/esbuild/esbuild.js:125:23)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5) {
status: 127,
signal: null,
output: [ null, null, null ],
pid: 49133,
stdout: null,
stderr: null
}
error Command failed with exit code 1.
info Visit https://yarnpkg.com/en/docs/cli/run for documentation about this command.
Traceback (most recent call last):
File "<frozen runpy>", line 198, in _run_module_as_main
File "<frozen runpy>", line 88, in _run_code
File "/home/ts/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 114, in <module>
main()
File "/home/ts/frappe-bench/apps/frappe/frappe/utils/bench_helper.py", line 20, in main
click.Group(commands=commands)(prog_name="bench")
File "/home/ts/frappe-bench/env/lib/python3.12/site-packages/click/core.py", line 1157, in __call__
return self.main(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ts/frappe-bench/env/lib/python3.12/site-packages/click/core.py", line 1078, in main
rv = self.invoke(ctx)
^^^^^^^^^^^^^^^^
File "/home/ts/frappe-bench/env/lib/python3.12/site-packages/click/core.py", line 1688, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ts/frappe-bench/env/lib/python3.12/site-packages/click/core.py", line 1688, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ts/frappe-bench/env/lib/python3.12/site-packages/click/core.py", line 1434, in invoke
return ctx.invoke(self.callback, **ctx.params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ts/frappe-bench/env/lib/python3.12/site-packages/click/core.py", line 783, in invoke
return __callback(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/ts/frappe-bench/apps/frappe/frappe/commands/utils.py", line 77, in build
bundle(
File "/home/ts/frappe-bench/apps/frappe/frappe/build.py", line 257, in bundle
frappe.commands.popen(command, cwd=frappe_app_path, env=get_node_env(), raise_err=True)
File "/home/ts/frappe-bench/apps/frappe/frappe/commands/__init__.py", line 97, in popen
raise subprocess.CalledProcessError(return_, command)
subprocess.CalledProcessError: Command 'yarn run build --run-build-command && cd billing && yarn build' returned non-zero exit status 1.
I was able to resolve the 404 issue, after -
bench setup requirements
bench build --app insights --force
bench migrate
Hi,
Can anyone please guide me which version of insights is fully compatible with Frappe/Erpnext version 14x.
As I tried to install the latest version of Insights in my existing frappe/erpnext server but it’s giving me incompatibility and dependency mismatch errors.
My current versions:
root@TPT-Demo:/home/frappe/frappe-bench# bench version
erpnext 14.74.8
frappe 14.84.0
hrms 14.35.0
I even tried the required versions by upgrade/downgrade but the issues are still same.
Error Details:
root@TPT-Demo:/home/frappe/frappe-bench# bench get-app insights
Getting insights
$ git clone GitHub - frappe/insights: Open Source Business Intelligence Tool --depth 1 --origin upstream
Cloning into ‘insights’…
remote: Enumerating objects: 1000, done.
remote: Counting objects: 100% (1000/1000), done.
remote: Compressing objects: 100% (926/926), done.
remote: Total 1000 (delta 154), reused 493 (delta 64), pack-reused 0 (from 0)
Receiving objects: 100% (1000/1000), 24.14 MiB | 32.52 MiB/s, done.
Resolving deltas: 100% (154/154), done.
Ignoring dependencies of insights. To install dependencies use --resolve-deps
Installing insights
$ /home/frappe/frappe-bench/env/bin/python -m pip install --quiet --upgrade -e / home/frappe/frappe-bench/apps/insights
ERROR: pip’s dependency resolver does not currently take into account all the packages that are installed. This behaviour pendency conflicts.
frappe 14.67.0 requires pytz==2022.1, but you have pytz 2025.2 which is incompatible.
[notice] A new release of pip is available: 24.0 → 25.1
[notice] To update, run: /home/frappe/frappe-bench/env/bin/python -m pip install --upgrade pip
$ yarn install
yarn install v1.22.19
[1/4] Resolving packages…
[2/4] Fetching packages…
warning Pattern [“string-width@^4.1.0”] is trying to unpack in the same destination “/home/frappe/.cache/yarn/v6/npm-strind2e536830a8ec895ef9c6d010-integrity/node_modules/string-width-cjs” as pattern [“string-width-cjs@npm:string-width@^4.2.0”]inistic behavior, skipping.
error insights-frontend@0.0.0: The engine “node” is incompatible with this module. Expected version “>=18.17.0”. Got "18.1
error Found incompatible module.
info Visit yarn install | Yarn for documentation about this command.
ERROR:
subprocess.CalledProcessError: Command ‘yarn install’ returned non-zero exit status 1.
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File “/usr/local/bin/bench”, line 8, in
sys.exit(cli())
File “/usr/local/lib/python3.10/dist-packages/bench/cli.py”, line 127, in cli
bench_command()
File “/usr/lib/python3/dist-packages/click/core.py”, line 1128, in call
return self.main(*args, **kwargs)
File “/usr/lib/python3/dist-packages/click/core.py”, line 1053, in main
rv = self.invoke(ctx)
File “/usr/lib/python3/dist-packages/click/core.py”, line 1659, in invoke
return _process_result(sub_ctx.command.invoke(sub_ctx))
File “/usr/lib/python3/dist-packages/click/core.py”, line 1395, in invoke
return ctx.invoke(self.callback, **ctx.params)
File “/usr/lib/python3/dist-packages/click/core.py”, line 754, in invoke
return __callback(*args, **kwargs)
File “/usr/local/lib/python3.10/dist-packages/bench/commands/make.py”, line 159, in get_app
get_app(
File “/usr/local/lib/python3.10/dist-packages/bench/app.py”, line 444, in get_app
app.install(verbose=verbose, skip_assets=skip_assets, restart_bench=restart_bench)
File “/usr/local/lib/python3.10/dist-packages/bench/utils/render.py”, line 126, in wrapper_fn
return fn(*args, **kwargs)
File “/usr/local/lib/python3.10/dist-packages/bench/app.py”, line 242, in install
install_app(
File “/usr/local/lib/python3.10/dist-packages/bench/app.py”, line 581, in install_app
bench.run(“yarn install”, cwd=app_path)
File “/usr/local/lib/python3.10/dist-packages/bench/bench.py”, line 48, in run
return exec_cmd(cmd, cwd=cwd or self.cwd, _raise=_raise)
File “/usr/local/lib/python3.10/dist-packages/bench/utils/init.py”, line 158, in exec_cmd
raise CommandFailedError from subprocess.CalledProcessError(return_code, cmd)
bench.exceptions.CommandFailedError
INFO: A newer version of bench is available: 5.16.2 → 5.24.1
root@TPT-Demo:/home/frappe/frappe-bench#