0
Fixed

Query String sent by Data Tables surpasses httpRuntime maxQueryStringLength

Tony Sheehy 9 years ago updated by anonymous 6 years ago 3

The following url is used to request the entity data of an Aderant Expert connector configured with all of its available schema fields (174). Of note, is that this url is >17k characters long.

http://localhost:50015/Connector/EntityData?partitionId=05d5fa81-3739-45c4-85de-cb9e5cf4c0bc&searchContext=all&sEcaho=1&iColumns=175&sColumns=Entity+Id%2CEmplUno%2CEmployeeCode%2CFirstName%2CMiddleName%2CLastName%2CInternetAddr%2CTitle%2CCellularPhone%2CAddress1%2CCity%2CStateCode%2CCountryCode%2CPostCode%2CHAPhoneNumber%2CWorkGroupCode%2CNameUno%2CSecurityId%2CHPInactive%2CEmployeeName%2CInternalNum%2CInitials%2COffc%2CDept%2CProf%2CPersnlTypCode%2CPosition%2CEditDate%2CSortPos%2CHPPhoneNumber%2CLocation%2CLogin%2CAppGroupUno%2CWorkTypeCode%2CSupervEmplUno%2CHireDate%2CTerminateDate%2CPrevHireDate%2CPrevTermDate%2CHldyGroupCode%2CDeEdlistReqd%2CGradYear%2CCompYear%2CPrivilegeLevel%2CTbEmplUno%2CMkEmplUno%2CCurrencyCode%2CModEffDate%2CWebPass%2CAuthContextUno%2CMenuUno%2CBook%2CFax%2CEmail%2CTimeOk%2CNeedAuth%2CRsclassCode%2CTextId%2CBillHrMin%2CNbillHrMin%2CPartimePcnt%2CWeeklyHrs%2CSpecRateOk%2CRankCode%2CRankCodeDate%2CPrevRankCode%2CLocationCode%2CAssistEmplUno%2CPbFormatUno%2CBlFormatUno%2CRsFormatUno%2CPbPrinterUno%2CBlPrinterUno%2CMinDailyHrs%2CReleaseAtMin%2COvertimeElig%2CReimburseCurr%2CFunctionalPcnt%2CWkstatusCode%2CAssignPeriod%2CShiftId%2CStActiveEmpl%2CSatelliteDbUno%2CSatelliteOnly%2CSeparateCheck%2CPartTimeMon%2CPartTimeTue%2CPartTimeWed%2CPartTimeThur%2CPartTimeFri%2CHNAddressUno%2CHNInactive%2CNameType%2CName%2CNameSort%2CNameClassCode%2CLanguageCode%2CDbNum%2CCommentTextId%2CPeopleNameUno%2CIsClient%2CIsEmployee%2CIsVendor%2CIsPayee%2CIsPayor%2CIsBank%2CIsJudge%2CIsAcctFirm%2CIsInsurance%2CIsLawFirm%2CIsMailing%2CIsParty%2CIsRolodex%2CIsAffiliation%2CIsCompetition%2CIsAcquisition%2CIsClientCont%2CIsClntRefer%2CIsMattRefer%2CIsWitness%2CIsExpert%2CIsPolicy%2CIsNameLink%2CIsVendorCont%2CAvailEm%2CAuthEmuser%2CGender%2CSalutation%2CSuffix%2CResident%2CCountry1Code%2CCountry2Code%2CCountry3Code%2COccupation%2CDomicile%2CSsn%2CBirthDate%2CSpouseNameUno%2CMaritalStatus%2CNumChild%2CFamilyTextId%2CMiscTextId%2CCarPhone%2CHAAddressUno%2CHAInactive%2CAddressCode%2COverrideName%2CAddress2%2CAddress3%2CAddress4%2CRegionCode%2CFaxNumber%2CModemNumber%2CPhoneExtNum%2CDirectNumber%2CEffectiveDate%2CDupAddressUno%2CReserved1%2CMailingType%2CMktgSpecNotes%2CMktgAddressUno%2COrgFoUno%2CPhoneDirctyUno%2CEmailDirctyUno%2CWebUrlDirctyUno%2CFaxDirctyUno%2CLastModifiedBy%2COtherDirctyUno%2CImDirctyUno%2CCreated%2CCreatedBy%2CStockCode%2CAnnualRevenue%2CEmployeesCount%2CPrimeEmplRelUno&iDisplayStart=0&iDisplayLength=20&mDataProp_0=0&mDataProp_1=1&mDataProp_2=2&mDataProp_3=3&mDataProp_4=4&mDataProp_5=5&mDataProp_6=6&mDataProp_7=7&mDataProp_8=8&mDataProp_9=9&mDataProp_10=10&mDataProp_11=11&mDataProp_12=12&mDataProp_13=13&mDataProp_14=14&mDataProp_15=15&mDataProp_16=16&mDataProp_17=17&mDataProp_18=18&mDataProp_19=19&mDataProp_20=20&mDataProp_21=21&mDataProp_22=22&mDataProp_23=23&mDataProp_24=24&mDataProp_25=25&mDataProp_26=26&mDataProp_27=27&mDataProp_28=28&mDataProp_29=29&mDataProp_30=30&mDataProp_31=31&mDataProp_32=32&mDataProp_33=33&mDataProp_34=34&mDataProp_35=35&mDataProp_36=36&mDataProp_37=37&mDataProp_38=38&mDataProp_39=39&mDataProp_40=40&mDataProp_41=41&mDataProp_42=42&mDataProp_43=43&mDataProp_44=44&mDataProp_45=45&mDataProp_46=46&mDataProp_47=47&mDataProp_48=48&mDataProp_49=49&mDataProp_50=50&mDataProp_51=51&mDataProp_52=52&mDataProp_53=53&mDataProp_54=54&mDataProp_55=55&mDataProp_56=56&mDataProp_57=57&mDataProp_58=58&mDataProp_59=59&mDataProp_60=60&mDataProp_61=61&mDataProp_62=62&mDataProp_63=63&mDataProp_64=64&mDataProp_65=65&mDataProp_66=66&mDataProp_67=67&mDataProp_68=68&mDataProp_69=69&mDataProp_70=70&mDataProp_71=71&mDataProp_72=72&mDataProp_73=73&mDataProp_74=74&mDataProp_75=75&mDataProp_76=76&mDataProp_77=77&mDataProp_78=78&mDataProp_79=79&mDataProp_80=80&mDataProp_81=81&mDataProp_82=82&mDataProp_83=83&mDataProp_84=84&mDataProp_85=85&mDataProp_86=86&mDataProp_87=87&mDataProp_88=88&mDataProp_89=89&mDataProp_90=90&mDataProp_91=91&mDataProp_92=92&mDataProp_93=93&mDataProp_94=94&mDataProp_95=95&mDataProp_96=96&mDataProp_97=97&mDataProp_98=98&mDataProp_99=99&mDataProp_100=100&mDataProp_101=101&mDataProp_102=102&mDataProp_103=103&mDataProp_104=104&mDataProp_105=105&mDataProp_106=106&mDataProp_107=107&mDataProp_108=108&mDataProp_109=109&mDataProp_110=110&mDataProp_111=111&mDataProp_112=112&mDataProp_113=113&mDataProp_114=114&mDataProp_115=115&mDataProp_116=116&mDataProp_117=117&mDataProp_118=118&mDataProp_119=119&mDataProp_120=120&mDataProp_121=121&mDataProp_122=122&mDataProp_123=123&mDataProp_124=124&mDataProp_125=125&mDataProp_126=126&mDataProp_127=127&mDataProp_128=128&mDataProp_129=129&mDataProp_130=130&mDataProp_131=131&mDataProp_132=132&mDataProp_133=133&mDataProp_134=134&mDataProp_135=135&mDataProp_136=136&mDataProp_137=137&mDataProp_138=138&mDataProp_139=139&mDataProp_140=140&mDataProp_141=141&mDataProp_142=142&mDataProp_143=143&mDataProp_144=144&mDataProp_145=145&mDataProp_146=146&mDataProp_147=147&mDataProp_148=148&mDataProp_149=149&mDataProp_150=150&mDataProp_151=151&mDataProp_152=152&mDataProp_153=153&mDataProp_154=154&mDataProp_155=155&mDataProp_156=156&mDataProp_157=157&mDataProp_158=158&mDataProp_159=159&mDataProp_160=160&mDataProp_161=161&mDataProp_162=162&mDataProp_163=163&mDataProp_164=164&mDataProp_165=165&mDataProp_166=166&mDataProp_167=167&mDataProp_168=168&mDataProp_169=169&mDataProp_170=170&mDataProp_171=171&mDataProp_172=172&mDataProp_173=173&mDataProp_174=174&sSearch=&bRegex=false&sSearch_0=&bRegex_0=false&bSearchable_0=true&sSearch_1=&bRegex_1=false&bSearchable_1=true&sSearch_2=&bRegex_2=false&bSearchable_2=true&sSearch_3=&bRegex_3=false&bSearchable_3=true&sSearch_4=&bRegex_4=false&bSearchable_4=true&sSearch_5=&bRegex_5=false&bSearchable_5=true&sSearch_6=&bRegex_6=false&bSearchable_6=true&sSearch_7=&bRegex_7=false&bSearchable_7=true&sSearch_8=&bRegex_8=false&bSearchable_8=true&sSearch_9=&bRegex_9=false&bSearchable_9=true&sSearch_10=&bRegex_10=false&bSearchable_10=true&sSearch_11=&bRegex_11=false&bSearchable_11=true&sSearch_12=&bRegex_12=false&bSearchable_12=true&sSearch_13=&bRegex_13=false&bSearchable_13=true&sSearch_14=&bRegex_14=false&bSearchable_14=true&sSearch_15=&bRegex_15=false&bSearchable_15=true&sSearch_16=&bRegex_16=false&bSearchable_16=true&sSearch_17=&bRegex_17=false&bSearchable_17=true&sSearch_18=&bRegex_18=false&bSearchable_18=true&sSearch_19=&bRegex_19=false&bSearchable_19=true&sSearch_20=&bRegex_20=false&bSearchable_20=true&sSearch_21=&bRegex_21=false&bSearchable_21=true&sSearch_22=&bRegex_22=false&bSearchable_22=true&sSearch_23=&bRegex_23=false&bSearchable_23=true&sSearch_24=&bRegex_24=false&bSearchable_24=true&sSearch_25=&bRegex_25=false&bSearchable_25=true&sSearch_26=&bRegex_26=false&bSearchable_26=true&sSearch_27=&bRegex_27=false&bSearchable_27=true&sSearch_28=&bRegex_28=false&bSearchable_28=true&sSearch_29=&bRegex_29=false&bSearchable_29=true&sSearch_30=&bRegex_30=false&bSearchable_30=true&sSearch_31=&bRegex_31=false&bSearchable_31=true&sSearch_32=&bRegex_32=false&bSearchable_32=true&sSearch_33=&bRegex_33=false&bSearchable_33=true&sSearch_34=&bRegex_34=false&bSearchable_34=true&sSearch_35=&bRegex_35=false&bSearchable_35=true&sSearch_36=&bRegex_36=false&bSearchable_36=true&sSearch_37=&bRegex_37=false&bSearchable_37=true&sSearch_38=&bRegex_38=false&bSearchable_38=true&sSearch_39=&bRegex_39=false&bSearchable_39=true&sSearch_40=&bRegex_40=false&bSearchable_40=true&sSearch_41=&bRegex_41=false&bSearchable_41=true&sSearch_42=&bRegex_42=false&bSearchable_42=true&sSearch_43=&bRegex_43=false&bSearchable_43=true&sSearch_44=&bRegex_44=false&bSearchable_44=true&sSearch_45=&bRegex_45=false&bSearchable_45=true&sSearch_46=&bRegex_46=false&bSearchable_46=true&sSearch_47=&bRegex_47=false&bSearchable_47=true&sSearch_48=&bRegex_48=false&bSearchable_48=true&sSearch_49=&bRegex_49=false&bSearchable_49=true&sSearch_50=&bRegex_50=false&bSearchable_50=true&sSearch_51=&bRegex_51=false&bSearchable_51=true&sSearch_52=&bRegex_52=false&bSearchable_52=true&sSearch_53=&bRegex_53=false&bSearchable_53=true&sSearch_54=&bRegex_54=false&bSearchable_54=true&sSearch_55=&bRegex_55=false&bSearchable_55=true&sSearch_56=&bRegex_56=false&bSearchable_56=true&sSearch_57=&bRegex_57=false&bSearchable_57=true&sSearch_58=&bRegex_58=false&bSearchable_58=true&sSearch_59=&bRegex_59=false&bSearchable_59=true&sSearch_60=&bRegex_60=false&bSearchable_60=true&sSearch_61=&bRegex_61=false&bSearchable_61=true&sSearch_62=&bRegex_62=false&bSearchable_62=true&sSearch_63=&bRegex_63=false&bSearchable_63=true&sSearch_64=&bRegex_64=false&bSearchable_64=true&sSearch_65=&bRegex_65=false&bSearchable_65=true&sSearch_66=&bRegex_66=false&bSearchable_66=true&sSearch_67=&bRegex_67=false&bSearchable_67=true&sSearch_68=&bRegex_68=false&bSearchable_68=true&sSearch_69=&bRegex_69=false&bSearchable_69=true&sSearch_70=&bRegex_70=false&bSearchable_70=true&sSearch_71=&bRegex_71=false&bSearchable_71=true&sSearch_72=&bRegex_72=false&bSearchable_72=true&sSearch_73=&bRegex_73=false&bSearchable_73=true&sSearch_74=&bRegex_74=false&bSearchable_74=true&sSearch_75=&bRegex_75=false&bSearchable_75=true&sSearch_76=&bRegex_76=false&bSearchable_76=true&sSearch_77=&bRegex_77=false&bSearchable_77=true&sSearch_78=&bRegex_78=false&bSearchable_78=true&sSearch_79=&bRegex_79=false&bSearchable_79=true&sSearch_80=&bRegex_80=false&bSearchable_80=true&sSearch_81=&bRegex_81=false&bSearchable_81=true&sSearch_82=&bRegex_82=false&bSearchable_82=true&sSearch_83=&bRegex_83=false&bSearchable_83=true&sSearch_84=&bRegex_84=false&bSearchable_84=true&sSearch_85=&bRegex_85=false&bSearchable_85=true&sSearch_86=&bRegex_86=false&bSearchable_86=true&sSearch_87=&bRegex_87=false&bSearchable_87=true&sSearch_88=&bRegex_88=false&bSearchable_88=true&sSearch_89=&bRegex_89=false&bSearchable_89=true&sSearch_90=&bRegex_90=false&bSearchable_90=true&sSearch_91=&bRegex_91=false&bSearchable_91=true&sSearch_92=&bRegex_92=false&bSearchable_92=true&sSearch_93=&bRegex_93=false&bSearchable_93=true&sSearch_94=&bRegex_94=false&bSearchable_94=true&sSearch_95=&bRegex_95=false&bSearchable_95=true&sSearch_96=&bRegex_96=false&bSearchable_96=true&sSearch_97=&bRegex_97=false&bSearchable_97=true&sSearch_98=&bRegex_98=false&bSearchable_98=true&sSearch_99=&bRegex_99=false&bSearchable_99=true&sSearch_100=&bRegex_100=false&bSearchable_100=true&sSearch_101=&bRegex_101=false&bSearchable_101=true&sSearch_102=&bRegex_102=false&bSearchable_102=true&sSearch_103=&bRegex_103=false&bSearchable_103=true&sSearch_104=&bRegex_104=false&bSearchable_104=true&sSearch_105=&bRegex_105=false&bSearchable_105=true&sSearch_106=&bRegex_106=false&bSearchable_106=true&sSearch_107=&bRegex_107=false&bSearchable_107=true&sSearch_108=&bRegex_108=false&bSearchable_108=true&sSearch_109=&bRegex_109=false&bSearchable_109=true&sSearch_110=&bRegex_110=false&bSearchable_110=true&sSearch_111=&bRegex_111=false&bSearchable_111=true&sSearch_112=&bRegex_112=false&bSearchable_112=true&sSearch_113=&bRegex_113=false&bSearchable_113=true&sSearch_114=&bRegex_114=false&bSearchable_114=true&sSearch_115=&bRegex_115=false&bSearchable_115=true&sSearch_116=&bRegex_116=false&bSearchable_116=true&sSearch_117=&bRegex_117=false&bSearchable_117=true&sSearch_118=&bRegex_118=false&bSearchable_118=true&sSearch_119=&bRegex_119=false&bSearchable_119=true&sSearch_120=&bRegex_120=false&bSearchable_120=true&sSearch_121=&bRegex_121=false&bSearchable_121=true&sSearch_122=&bRegex_122=false&bSearchable_122=true&sSearch_123=&bRegex_123=false&bSearchable_123=true&sSearch_124=&bRegex_124=false&bSearchable_124=true&sSearch_125=&bRegex_125=false&bSearchable_125=true&sSearch_126=&bRegex_126=false&bSearchable_126=true&sSearch_127=&bRegex_127=false&bSearchable_127=true&sSearch_128=&bRegex_128=false&bSearchable_128=true&sSearch_129=&bRegex_129=false&bSearchable_129=true&sSearch_130=&bRegex_130=false&bSearchable_130=true&sSearch_131=&bRegex_131=false&bSearchable_131=true&sSearch_132=&bRegex_132=false&bSearchable_132=true&sSearch_133=&bRegex_133=false&bSearchable_133=true&sSearch_134=&bRegex_134=false&bSearchable_134=true&sSearch_135=&bRegex_135=false&bSearchable_135=true&sSearch_136=&bRegex_136=false&bSearchable_136=true&sSearch_137=&bRegex_137=false&bSearchable_137=true&sSearch_138=&bRegex_138=false&bSearchable_138=true&sSearch_139=&bRegex_139=false&bSearchable_139=true&sSearch_140=&bRegex_140=false&bSearchable_140=true&sSearch_141=&bRegex_141=false&bSearchable_141=true&sSearch_142=&bRegex_142=false&bSearchable_142=true&sSearch_143=&bRegex_143=false&bSearchable_143=true&sSearch_144=&bRegex_144=false&bSearchable_144=true&sSearch_145=&bRegex_145=false&bSearchable_145=true&sSearch_146=&bRegex_146=false&bSearchable_146=true&sSearch_147=&bRegex_147=false&bSearchable_147=true&sSearch_148=&bRegex_148=false&bSearchable_148=true&sSearch_149=&bRegex_149=false&bSearchable_149=true&sSearch_150=&bRegex_150=false&bSearchable_150=true&sSearch_151=&bRegex_151=false&bSearchable_151=true&sSearch_152=&bRegex_152=false&bSearchable_152=true&sSearch_153=&bRegex_153=false&bSearchable_153=true&sSearch_154=&bRegex_154=false&bSearchable_154=true&sSearch_155=&bRegex_155=false&bSearchable_155=true&sSearch_156=&bRegex_156=false&bSearchable_156=true&sSearch_157=&bRegex_157=false&bSearchable_157=true&sSearch_158=&bRegex_158=false&bSearchable_158=true&sSearch_159=&bRegex_159=false&bSearchable_159=true&sSearch_160=&bRegex_160=false&bSearchable_160=true&sSearch_161=&bRegex_161=false&bSearchable_161=true&sSearch_162=&bRegex_162=false&bSearchable_162=true&sSearch_163=&bRegex_163=false&bSearchable_163=true&sSearch_164=&bRegex_164=false&bSearchable_164=true&sSearch_165=&bRegex_165=false&bSearchable_165=true&sSearch_166=&bRegex_166=false&bSearchable_166=true&sSearch_167=&bRegex_167=false&bSearchable_167=true&sSearch_168=&bRegex_168=false&bSearchable_168=true&sSearch_169=&bRegex_169=false&bSearchable_169=true&sSearch_170=&bRegex_170=false&bSearchable_170=true&sSearch_171=&bRegex_171=false&bSearchable_171=true&sSearch_172=&bRegex_172=false&bSearchable_172=true&sSearch_173=&bRegex_173=false&bSearchable_173=true&sSearch_174=&bRegex_174=false&bSearchable_174=true&iSortingCols=0&bSortable_0=false&bSortable_1=true&bSortable_2=true&bSortable_3=true&bSortable_4=true&bSortable_5=true&bSortable_6=true&bSortable_7=true&bSortable_8=true&bSortable_9=true&bSortable_10=true&bSortable_11=true&bSortable_12=true&bSortable_13=true&bSortable_14=true&bSortable_15=false&bSortable_16=true&bSortable_17=true&bSortable_18=true&bSortable_19=true&bSortable_20=true&bSortable_21=true&bSortable_22=true&bSortable_23=true&bSortable_24=true&bSortable_25=true&bSortable_26=true&bSortable_27=true&bSortable_28=true&bSortable_29=true&bSortable_30=true&bSortable_31=true&bSortable_32=true&bSortable_33=true&bSortable_34=true&bSortable_35=true&bSortable_36=true&bSortable_37=true&bSortable_38=true&bSortable_39=true&bSortable_40=true&bSortable_41=true&bSortable_42=true&bSortable_43=true&bSortable_44=true&bSortable_45=true&bSortable_46=true&bSortable_47=true&bSortable_48=true&bSortable_49=true&bSortable_50=true&bSortable_51=true&bSortable_52=true&bSortable_53=true&bSortable_54=true&bSortable_55=true&bSortable_56=true&bSortable_57=true&bSortable_58=true&bSortable_59=true&bSortable_60=true&bSortable_61=true&bSortable_62=true&bSortable_63=true&bSortable_64=true&bSortable_65=true&bSortable_66=true&bSortable_67=true&bSortable_68=true&bSortable_69=true&bSortable_70=true&bSortable_71=true&bSortable_72=true&bSortable_73=true&bSortable_74=true&bSortable_75=true&bSortable_76=true&bSortable_77=true&bSortable_78=true&bSortable_79=true&bSortable_80=true&bSortable_81=true&bSortable_82=true&bSortable_83=true&bSortable_84=true&bSortable_85=true&bSortable_86=true&bSortable_87=true&bSortable_88=true&bSortable_89=true&bSortable_90=true&bSortable_91=true&bSortable_92=true&bSortable_93=true&bSortable_94=true&bSortable_95=true&bSortable_96=true&bSortable_97=true&bSortable_98=true&bSortable_99=true&bSortable_100=true&bSortable_101=true&bSortable_102=true&bSortable_103=true&bSortable_104=true&bSortable_105=true&bSortable_106=true&bSortable_107=true&bSortable_108=true&bSortable_109=true&bSortable_110=true&bSortable_111=true&bSortable_112=true&bSortable_113=true&bSortable_114=true&bSortable_115=true&bSortable_116=true&bSortable_117=true&bSortable_118=true&bSortable_119=true&bSortable_120=true&bSortable_121=true&bSortable_122=true&bSortable_123=true&bSortable_124=true&bSortable_125=true&bSortable_126=true&bSortable_127=true&bSortable_128=true&bSortable_129=true&bSortable_130=true&bSortable_131=true&bSortable_132=true&bSortable_133=true&bSortable_134=true&bSortable_135=true&bSortable_136=true&bSortable_137=true&bSortable_138=true&bSortable_139=true&bSortable_140=true&bSortable_141=true&bSortable_142=true&bSortable_143=true&bSortable_144=true&bSortable_145=true&bSortable_146=true&bSortable_147=true&bSortable_148=true&bSortable_149=true&bSortable_150=true&bSortable_151=true&bSortable_152=true&bSortable_153=true&bSortable_154=true&bSortable_155=true&bSortable_156=true&bSortable_157=true&bSortable_158=true&bSortable_159=true&bSortable_160=true&bSortable_161=true&bSortable_162=true&bSortable_163=true&bSortable_164=true&bSortable_165=true&bSortable_166=true&bSortable_167=true&bSortable_168=true&bSortable_169=true&bSortable_170=true&bSortable_171=true&bSortable_172=true&bSortable_173=true&bSortable_174=true&_=1353388006786

The limit on the maxQueryStringLength in the Web.config was set to ~16k for release, however there needs to be a more concrete solution that scales. Namely, the main problem is tackling the substantial amount of meta-data sent by datatables.

If this isn't possible, we might need to limit the number of fields that can be viewed at any one time on the entity search page.

Affected Versions:
Fixed by Version:

Tony, as discussed, please determine what the options are for this one.

Attempt using the DataTables option of using a POST, it may be quite easy to switch over. If it's easy then it could be done in a patch version. If it's not possible or not so easy please simply document this as a troubleshooting article and change the fix version to v4.1.

Thanks.

Updating datatables to use POST had no effect; a trouble shooting page has been added here. Reassigned for confirmation of completion.

Documentation provided.