Column 1 Required to be of Type String

Trying to create a bar chart / pie chart Live Report (have tried both) from the sample SQL in the Live Report documentation supplied for version 9.0 / 9.1. However, we are running version 9.7.0.This is a very simple aggregate using:select mimetype, count(*) from dversdata group by mimetypeI am getting an error message to the effect that ["Reports of 'Bar / Pie Chart' require column 1 to be of type 'String']. I've tried explicitly telling the report that mimetype is column 1 in the configuration of the report, but it still throws the same error.Any help will be appreciated. Seems like it must be a silly option or configuration issue that I am overlooking.Thanks in advance!Mark

Find more posts tagged with

Comments

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

I recall this being registered under bug # LPAD-7184. Unfortunately, I don't have access to the bugs database at the moment. I would recommend contacting support@opentext.com for assistance and an update on the bug.

- Bhupinder ----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Friday, May 29, 2009 3:10 PM
To: eLink Recipient
Subject: Column 1 Required to be of Type String

Column 1 Required to be of Type String

Posted by eastch022 (Teague, Mark) on 2009/05/29 15:09

Trying to create a bar chart / pie chart Live Report (have tried both) from the sample SQL in the Live Report documentation supplied for version 9.0 / 9.1. However, we are running version 9.7.0.

This is a very simple aggregate using:

select mimetype, count(*) from dversdata group by mimetype

I am getting an error message to the effect that ["Reports of 'Bar / Pie Chart' require column 1 to be of type 'String']. I've tried explicitly telling the report that mimetype is column 1 in the configuration of the report, but it still throws the same error.

Any help will be appreciated. Seems like it must be a silly option or configuration issue that I am overlooking.

Thanks in advance!
Mark

Mark_Teague

Well ... this probably should have occurred to me but it didn't. Thanks to Mario of OpenText Support for revealing the following detail.When the extensional data returned by the query contains a null, the nulls are not of string data type proper.This problem did not occur on our production system which happens to be on a later monthly patch.In any event, the issue can be eliminated by adding a "having" clause to the query that will strip out the null row from the result set.i.e.having (not (mimetype is null))Thanks to Mario and OpenText Support for their prompt attention to this issue.Mark