UCX V0.58.0 Dashboard in Databricks Showing 0 Tables Despite Existing Tables.

[meghana_tulla]

Hi,

I am currently installing UCX version 0.58.0 in Non-Unity enabled Databricks Workspace. It installed successfully and the job completes without errors. However, The Dashboard that goanna generate showing "0 Total Tables" and other metrics as 0.

Has anyone encountered this issue with UCXv0.58.0? Is there any known bug or misconfiguration that causes the dashboard counts to return 0?

Thank You.

[aayrm5]

Hi @meghana_tulla 

Can you check for UCX job logs? Look for table scanning if it skipped or fails silently.
Alternatively, try UCX v0.57.0 which is known to work better with non-Unity environments.

Thanks,

[meghana_tulla]

Hi aaryrm,

I have installed UCX v0.57.0, but I am getting a total count of 0 for both tables and views, even though the installation job ran successfully.

Would you like help troubleshooting why the counts are showing as zero?

[aayrm5]

Hi @meghana_tulla 

Have you had a chance to check the UCX Logs? You can also share the logs here and share the screenshot of the job details along with the dashboard.

Thanks,

[meghana_tulla]

can u help me this for this job 

assess_dashboards run
WARN [d.l.u.assessment.dashboards] Error when parsing Lakeview dashboard: : Traceback (most recent call last): File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/labs/ucx/assessment/dashboards.py", line 304, in _convert_sdk_to_lsql_lakeview_dashboard lsql_dashboard = LsqlLakeviewDashboard.from_dict(json.loads(dashboard.serialized_dashboard)) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/labs/lsql/lakeview/model.py", line 588, in from_dict return cls(datasets=_repeated_dict(d, "datasets", Dataset), pages=_repeated_dict(d, "pages", Page)) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/sdk/service/_internal.py", line 16, in _repeated_dict return [from_dict(v) for v in d[field]] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/sdk/service/_internal.py", line 16, in <listcomp> return [from_dict(v) for v in d[field]] ^^^^^^^^^^^^ File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/labs/lsql/lakeview/model.py", line 1108, in from_dict layout=_repeated_dict(d, "layout", Layout), ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/sdk/service/_internal.py", line 16, in _repeated_dict return [from_dict(v) for v in d[field]] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/sdk/service/_internal.py", line 16, in <listcomp> return [from_dict(v) for v in d[field]] ^^^^^^^^^^^^ File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/labs/lsql/lakeview/model.py", line 874, in from_dict return cls(position=_from_dict(d, "position", Position), widget=_from_dict(d, "widget", Widget)) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/sdk/service/_internal.py", line 9, in _from_dict return getattr(cls, 'from_dict')(d[field]) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/labs/lsql/lakeview/model.py", line 1931, in from_dict spec=_from_dict(d, "spec", WidgetSpec), ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/sdk/service/_internal.py", line 9, in _from_dict return getattr(cls, 'from_dict')(d[field]) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "/local_disk0/.ephemeral_nfs/cluster_libraries/python/lib/python3.11/site-packages/databricks/labs/lsql/lakeview/model.py", line 130, in from_dict raise KeyError(f"unknown: version={d['version']} widgetType={d['widgetType']}") KeyError: 'unknown: version=3 widgetType=histogram' 09:45:37 INFO [d.l.u.s.linters.queries] Linting dashboard: dashboard_01 () 09:45:38 INFO [d.l.u.s.linters.queries] Saving 0 linting problems... 

[meghana_tulla]

Hi,

Still facing the same issue actually, I am trying to automate the UCX installation using bashscript. while running the bashscript the job starts and run successfully with all run jobs. Even all jobs Ran successfully, I am getting 0 tables and 0 values in the dashboard.

The jobs are not showing any error.