Query of Queries Suddenly Stopped Working

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Query of Queries Suddenly Stopped Working

    I have pages that have been working for months which use the query of queries
    feature in Coldfusion. They've suddenly just stopped working. All report the
    same error message -

    Error Executing Database Query.

    null

    The error occurred in
    C:\WebSites\IMAP\IMAP\modules\receiving\action\act _Purchase_History.cfm: line 62
    Called from C:\WebSites\IMAP\IMAP\modules\receiving\index.cfm: line 63
    Called from C:\WebSites\IMAP\IMAP\htdocs\receiving.cfm: line 8
    Called from
    C:\WebSites\IMAP\IMAP\modules\receiving\action\act _Purchase_History.cfm: line 62
    Called from C:\WebSites\IMAP\IMAP\modules\receiving\index.cfm: line 63
    Called from C:\WebSites\IMAP\IMAP\htdocs\receiving.cfm: line 8

    60 :
    61 : <!--- Combined History query --->
    62 : <cfquery name="Purchase_History" dbtype="query">
    63 : SELECT Deal_List.T_Deal_Header_ID, Deal_List.Purchase_Date,
    Deal_List.Goods_ETA_Date,
    64 : Vendor_List.strCompanyName, Deal_List.tblPREmployee_ID,
    Deal_List.Total_Deal_Cost,

    Here is the top four lines of the stack trace -

    java.sql.SQLException
    at coldfusion.sql.JdbcImpl.getConnection(Unknown Source)
    at coldfusion.sql.JdbcImpl.getConnection(Unknown Source)
    at coldfusion.sql.SqlImpl.execute(Unknown Source)
    at coldfusion.tagext.sql.QueryTag.doEndTag(Unknown Source)

    Any ideas why the query of queries feature would just stop working? I was
    hoping this was a known problem with a known answer. I'm re-writing pages as
    fast as I can to query the database but the application is used to run our
    company and is HUGE.

    Thanks

    EssexJohn Guest

  2. Similar Questions and Discussions

    1. #38816 [Opn]: PHP code that was working perfectly recently stopped working.
      ID: 38816 User updated by: mtoohee at gmail dot com -Summary: PHP code that was working perfectly recently stopped....
    2. CF Server Suddenly Stopped Serving
      Hi, all, Let me describe the symptoms, as well as I can remember them. In summary, my test server has stopped ... well ... serving. I get "Cannot...
    3. Serial column has suddenly stopped working
      I have been using a serial column in my most important postgres table for a couple of years. But today it has suddenly started assigning zero...
    4. ps 6 g4 os9 suddenly stopped menubar display - help!
      ps was working fine until several things we added to the computer 0sx, iomega cdrw external drive and canon camera software. i've shut off every...
    5. SVM (DiskSuite) suddenly stopped working
      We have just installed Solaris 9 on an Enterprise 450 and created a DiskSuite mirror containing two stripe/concat metadevices. The mirror works...
  3. #2

    Default Re: Query of Queries Suddenly Stopped Working

    By the way, this is Coldufsion 6.0, not 6.1. We never switched to 6.1 because we found out some pages would have to modified to work and just haven't taken the time to do it yet.
    EssexJohn Guest

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139