Failed when producing report: Failed to work out fields required by report (Cannot interpret fields required to output report) (4383948)

After upgrading NetVault from 14.0.x to 14.1.x, several reports are failing with "Failed when producing report: Failed to work out fields required by report (Cannot interpret fields required to output report)".

Media Management reporting views are missing. Examples include:

• media_view
• rasdevices_view
• segments_view

As a result, report generation fails.

This issue occurs due to a PostgreSQL limitation:

• CREATE OR REPLACE FUNCTION cannot change the return type of an existing function

During the upgrade process:

1. The script create_views.sql begins execution.
2. Existing views are successfully dropped.
3. The script attempts to replace a function whose return type has changed.
4. PostgreSQL raises a type-mapping error.
5. The script terminates prematurely, preventing the execution of the CREATE VIEW statements.

This results in multiple required reporting views not being recreated.

A permanent fix for this issue is included in:

NetVault Core 14.2