Charting Not working at all

[Stressed_Simon]

I am in the process of setting up my new server and I am testing my site, but I
can't get the charting to work.

I am on CFMX 6.1, and when I try and show any charts I get the following
error:-

The chart could not be generated due to an error in the graphing engine.

The spart of the stack trace where it falls down is as follows:-

java.lang.NoClassDefFoundError
at com.gp.image.ExServerComponent.init(ExServerCompon ent.java)
at
coldfusion.graph.GraphingServiceImpl.initializeEng ine(GraphingServiceImpl.java:4
43)
at
coldfusion.graph.GraphingServiceImpl.access$000(Gr aphingServiceImpl.java:19)
at coldfusion.graph.GraphingServiceImpl$1.run(Graphin gServiceImpl.java:286)
at java.security.AccessController.doPrivileged(Native Method)
at
coldfusion.graph.GraphingServiceImpl.generateGraph (GraphingServiceImpl.java:281)
at coldfusion.tagext.io.ChartTag.doEndTag(ChartTag.ja va:428)
at
cfSurveyBottom2ecfm1319405092.runPage(/home/httpd/vhosts/silentindustry.com/http
docs/SurveyBottom.cfm:108)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java :147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Inclu deTag.java:357)
at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.j ava:1871)

[BKBK]

Any code?

[BKBK]

java.lang.NoClassDefFoundError usually occurs when the engine
cannot find a name, either because it is missing, mispelt, etc

[Stressed_Simon]

Here you go:-

<cfsilent>
<!--- get chart data --->
<cfinvoke component="#surveyObj#" method="MediaConvertResults"
returnvariable="qChartData" />

<!--- get grid lines --->
<cfquery dbtype="query" name="qGridLines">
SELECT Max(Amount) AS MaxAmount
FROM qChartData
</cfquery>
</cfsilent>

<div class="ManagerHeadings">
Survey Results
</div>

<div align="center">
<cfchart
format="flash"
chartheight="400"
chartwidth="510"
foregroundcolor="##FFFFFF"
backgroundcolor="##6600FF"
databackgroundcolor="##6600FF"
fontbold="yes"
tipbgcolor="##6600FF"
gridlines="#(qGridLines.MaxAmount+ 1)#">

<!--- include data --->
<cfchartseries
type="bar"
query="qChartData"
itemcolumn="Option"
valuecolumn="Amount"
seriescolor="FF0000">
</cfchartseries>
</cfchart>
</div>

[BKBK]

Have you tested, just before the query, with
<cfdump var="#qChartData#"> to see whether there
is any data at all? I also miss the "Group By" clause
in your query.

[Stressed_Simon]

Yes, I have checked the query. The results returned are fine. I don't know what
you mean by group by, but a) the results are from a object method (see the
cfinvoke statement) the cfquery is to get the maximum value to sort that
annoying gridlines problem on charts.

It appears that the chart service is failing and I am at a loss as to how to
fix it!

[BKBK]

>>... I also miss the "Group By" clause in your query.

>... I don't know what you mean by group by

With the following data, you will need to "group by dept"
before constructing a chart.

dept maxAmount
d1 3
d2 5
d2 5
d2 5
d3 8
d3 8

[BKBK]

dept.... maxAmount
d1....... 3
d2....... 5
d2....... 5
d2....... 5
d3....... 8
d3....... 8

looks more like it

[Stressed_Simon]

I know that, the data is fine. The CFCHART service is not working.

[BKBK]

>...I know that, the data is fine. The CFCHART service is not working.
The problem may arise from somewhere else, away from cfchart.
For example, check what SurveyBottom.cfm is doing and watch
the first include you make just after the cfchart.

[Stressed_Simon]

But this has been working fine for 4 months on a Windows box, but not under Linux. It is not a coding issue. I just wanted to know if anyone knew how to fix it!

[BKBK]

>... I just wanted to know if anyone knew how to fix it!
Which only makes sense if there is indeed a cfcharting problem.
If we fall on our sword every time we mistakenly blame the CF
engine, there'd be no Coldfusion developers left. The following
excerpt leads me to believe that your chart was in fact done, but
that the processing collapsed soon afterwards.

at coldfusion.tagext.io.ChartTag.doEndTag(ChartTag.ja va:428)
at
cfSurveyBottom2ecfm1319405092.runPage(/home/httpd/vhosts/silentindustry.com/http
docs/SurveyBottom.cfm:108)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java :147)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Inclu deTag.java:357)

The engine reached the end tag </cfchart>, which should tell you something.
I would give the chart a name="myChart" attribute and, right after </cfchart>,
perform <cfdump var"#myChart#"><cfabort>. Then we're talking engine
errors.

[BKBK]

Read, of course: var="#myChart#"

[Stressed_Simon]

OK followed you advice, it highlights the closing cfchartseries tag as the culprit as before and never reaches the cfdump.

[BKBK]

I begin to see your problem.
What happens when you remove <!--- include data --->?