report.multiple_package_part

Add record

No data

Error in query number 7

We are sorry, but an error occurred while generating this page. You should contact the site's administrator.

In "dwui/table/report.multiple_package_part.sql": Failed to set variable records_count: In "dwui/table/report.multiple_package_part.sql": The following error occurred while executing an SQL statement:
error returned from database: ODBC emitted an error calling 'SQLExecDirect':
State: 42501, Native error: 1, Message: ERROR: permission denied for view location_overview_package;
Error while executing the query

The SQL statement sent by SQLPage was:
SELECT COUNT(*) FROM report.multiple_package_part WHERE (CAST(? AS TEXT) IS NULL OR (((CAST(? AS TEXT)::JSONB) ->> 'spot_barcode' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'spot_barcode')::"varchar" = spot_barcode) AND ((CAST(? AS TEXT)::JSONB) ->> 'barcode' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'barcode')::"varchar" = barcode) AND ((CAST(? AS TEXT)::JSONB) ->> 'productioncrate_title' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'productioncrate_title')::"varchar" = productioncrate_title) AND ((CAST(? AS TEXT)::JSONB) ->> 'grab' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'grab')::INT8 = grab) AND ((CAST(? AS TEXT)::JSONB) ->> 'part_title' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'part_title')::"varchar" = part_title) AND ((CAST(? AS TEXT)::JSONB) ->> 'partcode' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'partcode')::INT8 = partcode) AND ((CAST(? AS TEXT)::JSONB) ->> 'item_count' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'item_count')::"numeric" = item_count) AND ((CAST(? AS TEXT)::JSONB) ->> 'estimated_item_count' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'estimated_item_count')::INT8 = estimated_item_count) AND ((CAST(? AS TEXT)::JSONB) ->> 'storage_title' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'storage_title')::"varchar" = storage_title) AND ((CAST(? AS TEXT)::JSONB) ->> 'storage_description' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'storage_description')::"varchar" = storage_description) AND ((CAST(? AS TEXT)::JSONB) ->> 'part_uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'part_uuid')::UUID = part_uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'package_count' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'package_count')::INT8 = package_count)))
dwui/table/report.multiple_package_part.sql: line 48
dwui/table/report.multiple_package_part.sql: line 48

Backtrace

Failed to set variable records_count

In "dwui/table/report.multiple_package_part.sql": The following error occurred while executing an SQL statement:
error returned from database: ODBC emitted an error calling 'SQLExecDirect':
State: 42501, Native error: 1, Message: ERROR: permission denied for view location_overview_package;
Error while executing the query

The SQL statement sent by SQLPage was:
SELECT COUNT(*) FROM report.multiple_package_part WHERE (CAST(? AS TEXT) IS NULL OR (((CAST(? AS TEXT)::JSONB) ->> 'spot_barcode' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'spot_barcode')::"varchar" = spot_barcode) AND ((CAST(? AS TEXT)::JSONB) ->> 'barcode' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'barcode')::"varchar" = barcode) AND ((CAST(? AS TEXT)::JSONB) ->> 'productioncrate_title' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'productioncrate_title')::"varchar" = productioncrate_title) AND ((CAST(? AS TEXT)::JSONB) ->> 'grab' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'grab')::INT8 = grab) AND ((CAST(? AS TEXT)::JSONB) ->> 'part_title' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'part_title')::"varchar" = part_title) AND ((CAST(? AS TEXT)::JSONB) ->> 'partcode' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'partcode')::INT8 = partcode) AND ((CAST(? AS TEXT)::JSONB) ->> 'item_count' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'item_count')::"numeric" = item_count) AND ((CAST(? AS TEXT)::JSONB) ->> 'estimated_item_count' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'estimated_item_count')::INT8 = estimated_item_count) AND ((CAST(? AS TEXT)::JSONB) ->> 'storage_title' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'storage_title')::"varchar" = storage_title) AND ((CAST(? AS TEXT)::JSONB) ->> 'storage_description' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'storage_description')::"varchar" = storage_description) AND ((CAST(? AS TEXT)::JSONB) ->> 'part_uuid' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'part_uuid')::UUID = part_uuid) AND ((CAST(? AS TEXT)::JSONB) ->> 'package_count' IS NULL OR ((CAST(? AS TEXT)::JSONB) ->> 'package_count')::INT8 = package_count)))
dwui/table/report.multiple_package_part.sql: line 48

Note: You can hide error messages like this one from your users by setting the 'environment' configuration option to 'production'.