Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

CFGrid error when input too long

Guest
Mar 01, 2012 Mar 01, 2012

Hello,

We have a grid that is bound to fields in search criteria form to filter the grid results.  The actual screen has 10 search fields, but the basic code looks like this:

<cfgrid name="gridReports" format="html" bindOnLoad="false" selectOnLoad="true"

       bind="cfc:getReports({cfgridpage}, {cfgridpagesize}, {cfgridsortcolumn}, {cfgridsortdirection}, {form:field1@none}, {form:field2@none}, {form:field3@none} )">

               <cfgridcolumn name="column1" header="Column Name" >

               <cfgridcolumn name="column2" header="Column Name" >

               <cfgridcolumn name="column3" header="Column Name" >

We have this running in 2 matching environments.  In one environment, this runs without any problems.  However in the other, when you fill in many serach fields or enter some long text into a few, it will return " Error invoking CFC [cfc filename]: Not Acceptable."  If you limit the search values entered, then the search runs just fine.  Any ideas on what may be causing the error and/or why it is only happening in one environment?

Thanks for your help.

904
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Advocate ,
Mar 01, 2012 Mar 01, 2012

Have you verified that the CF admin settings are the same in both servers?  I think particularly of whitespace handling and debugging output.  Also, make sure your CF & IIS mappings are identical on both servers.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Guest
Mar 05, 2012 Mar 05, 2012
LATEST

We did check the CF and IIS mappings and they were identical.  Ultimately, we reinstalled IIS in the problem environment and it seems to have corrected the problem.

Thanks

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 03, 2012 Mar 03, 2012

cfc:getReports(

That doesn't look right to me. I miss the CFC's name. A dotted path to the CFC may also be relevant. Path is certainly one factor that may differ between servers.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources