Business IntelligenceTopic number: 1728582250482

KeySummary

IEI-336459

PRB0762363

Scheduled emails containing a Look as PNG visualization are failing

Description:

Information in Enterprise Imaging Business Intelligence Powered by Looker can be presented as:
  • A Look, which is a saved snapshot of the data that results from a query; or
  • A dashboard, which is a collection of tiles showing visualized query results.

Dashboards, Look visualization, or Look data can be delivered in a variety of formats and can be scheduled for periodic delivery as required.

After the upgrade from Business Intelligence Powered by Looker 8.2.0 to Business Intelligence Powered by Looker 8.2.2 scheduled emails of Looks using the PNG visualization format are failing. The following message is received:

Error occurred while generating this look - contact administrator (error: Render job 4505fb8a785a240577356fb181ef943b[2673] failed [Java::JavaSql::SQLDataException: data exception: invalid character value for cast])

Workaround:

Use one of the following workarounds:
  1. When sending daily scheduled emails, use the PDF format for Looks; or
  2. Save the Looks within a dashboard and send the daily scheduled emails as dashboards with inline visualizations.