SELECT Max(Amount) AS MaxAmount FROM qChartData
Survey Results
[allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => Stressed_Simon [ip] => webforumsuser@m [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 4 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) -->? [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => BKBK [ip] => webforumsuser@m [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 15 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) --> Charting Not working at all - Coldfusion - Advanced Techniques

Charting Not working at all - Coldfusion - Advanced Techniques

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 ...

  1. #1

    Default Charting Not working at all

    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)

    Stressed_Simon Guest

  2. #2

    Default Re: Charting Not working at all

    Any code?
    BKBK Guest

  3. #3

    Default Re: Charting Not working at all

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

  4. #4

    Default Re: Charting Not working at all

    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>

    Stressed_Simon Guest

  5. #5

    Default Re: Charting Not working at all

    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.
    BKBK Guest

  6. #6

    Default Re: Charting Not working at all

    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!

    Stressed_Simon Guest

  7. #7

    Default Re: Charting Not working at all

    >>... 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 Guest

  8. #8

    Default Re: Charting Not working at all

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

    looks more like it
    BKBK Guest

  9. #9

    Default Re: Charting Not working at all

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

  10. #10

    Default Re: Charting Not working at all

    >...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.

    BKBK Guest

  11. #11

    Default Re: Charting Not working at all

    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!
    Stressed_Simon Guest

  12. #12

    Default Re: Charting Not working at all

    >... 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 Guest

  13. #13

    Default Re: Charting Not working at all

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

  14. #14

    Default Re: Charting Not working at all

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

  15. #15

    Default Re: Charting Not working at all

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

    BKBK Guest

  16. #16

    Default Re: Charting Not working at all

    If you have just migrated from windows to linux, you may have some
    case-sensitivity issues too. We migrated from a 2000 server to linux and had
    to go back through our code to check references to things that worked for
    months before.

    Of course we also migrated our Oracle DB from a win server to linux as well,
    so your mileage may vary.

    Have you made sure your Application.cfm and OnRequestEnd.cfm are still being
    processed?

    sbarbe Guest

Similar Threads

  1. flex 2 charting
    By konlin77 in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: May 2nd, 08:47 PM
  2. XML data in charting
    By theNOCer in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: April 18th, 06:13 PM
  3. Charting help
    By deepsteve in forum Macromedia Flex General Discussion
    Replies: 0
    Last Post: April 3rd, 02:19 PM
  4. charting data
    By Mark Henry in forum PERL Beginners
    Replies: 1
    Last Post: December 30th, 03:53 AM
  5. Charting Xtras
    By Andy Petroski in forum Macromedia Director Basics
    Replies: 1
    Last Post: October 13th, 06:28 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •