The easy way to spring clean duplicate records in your database
Share this:

Spring clean duplicate records in your Bullhorn database with ease

As records are input, migrated, and manipulated, duplicate records in your CRM become inevitable—but agencies often don’t realise the extent of how many duplicates are in their system. It’s estimated that between 10 – 15% of records fall into this category, which is enough to cause problems.

But how harmful are duplicate records really to your business? Very, is the answer! Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Attribute validation error for tag cfloop.

The value of the attribute query, which is currently getCats, is invalid.
 
The error occurred in C:/home/kyloepartners.com/wwwroot2022h/website/priv/views/inner.cfm: line 58
Called from C:/home/kyloepartners.com/wwwroot2022h/website/pub/index.cfm: line 228
Called from C:/home/kyloepartners.com/wwwroot2022h/website/pub/index.cfm: line 185
Called from C:/home/kyloepartners.com/wwwroot2022h/website/pub/index.cfm: line 18
 
56 :                                     <select id="catDrop" class="marginTop20 teamSelect select-css select-cats dropShadow hoverMe">
57 :                                         <option value="#application.fullpath#/#topNav#" <cfif not isdefined("url.subNav1")>selected</cfif>>All Categories</option>
58 :                                         <cfloop query="getCats">
59 :                                             <option value="#application.fullpath#/#topNav#/#navLink#" <cfif isdefined("url.subNav1")><cfif url.subNav1 EQ navTitle>selected</cfif></cfif>>#navTitle#</option>
60 :                                         </cfloop>
Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   172.69.6.229
Referrer  
Date/Time   09-May-25 08:32 AM
Stack Trace
at cfinner2ecfm424285679.runPage(C:/home/kyloepartners.com/wwwroot2022h/website/priv/views/inner.cfm:58) at cfindex2ecfm799943988._factor4(C:/home/kyloepartners.com/wwwroot2022h/website/pub/index.cfm:228) at cfindex2ecfm799943988._factor5(C:/home/kyloepartners.com/wwwroot2022h/website/pub/index.cfm:185) at cfindex2ecfm799943988.runPage(C:/home/kyloepartners.com/wwwroot2022h/website/pub/index.cfm:18) 

coldfusion.tagext.InvalidTagAttributeException: Attribute validation error for tag cfloop.
	at coldfusion.tagext.QueryLoop.setQuery(QueryLoop.java:103)
	at cfinner2ecfm424285679.runPage(C:\home\kyloepartners.com\wwwroot2022h\website\priv\views\inner.cfm:58)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329)
	at cfindex2ecfm799943988._factor4(C:\home\kyloepartners.com\wwwroot2022h\website\pub\index.cfm:228)
	at cfindex2ecfm799943988._factor5(C:\home\kyloepartners.com\wwwroot2022h\website\pub\index.cfm:185)
	at cfindex2ecfm799943988.runPage(C:\home\kyloepartners.com\wwwroot2022h\website\pub\index.cfm:18)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:555)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:226)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)