How to troubleshoot coldfusion.orm.mapping.CFPropertyBinder$AttributeValidationException (Table xxx defined for cfc yyy does not exist)

[zabimaru]

Hi guys

How to troubleshoot this coldfusion.orm.mapping.CFPropertyBinder$AttributeValidationException exception where error like Table xxx defined for cfc yyy does not exist.       

is thrown?

Nothing was changed code-wise and it just sorta happened

Seriously appreciate some enlightenment

Tried ormreload, restart cf, change datasource, restart server

Thanks

[Joe Rinehart]

I hate to be the level one "is it plugged in" helpdesk guy, but did you check the database to make sure the table exists and there aren't any typos in the name?  Maybe copy the name of the table from the exception and paste it into "select count(*) from foo;"

-Joe

--
You received this message because you are subscribed to the Google Groups "cf-orm-dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cf-orm-dev+...@googlegroups.com.
To post to this group, send email to cf-or...@googlegroups.com.
Visit this group at http://groups.google.com/group/cf-orm-dev.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[zabimaru]

Hi Joe

thanks for your respond, 

i am positive we have that possibility ruled out.

some findings so far

1. it's working when we point back to a control datasource. 

2. it's showing different table not exist when we change the 'this.ormsettings.cfclocation' directory

any thoughts?

Thanks

[Curt Gratz]

Perhaps a permission issues on the database. 

Curt

[zabimaru]

hi curt

thanks for your respond, unfortunately that's not the case either

on seperate note, i could do <cfquery> and dump the recrords.. so cf to db is ok.. but cf to orm to db is not ok

To post to this group, send email to cf-o...@googlegroups.com.

[Curt Gratz]

Is it possible to post a stack trace.  Might be helpful.

Curt

---

From: cf-or...@googlegroups.com [cf-or...@googlegroups.com] on behalf of zabimaru [skyp...@gmail.com]
Sent: Monday, June 24, 2013 7:18 AM
To: cf-or...@googlegroups.com

[zabimaru]

ok curt, but i had to mask the actual table name and cfc path

here's the stack trace

coldfusion.orm.mapping.CFPropertyBinder$AttributeValidationException: Table XXX defined for cfc AAA.BBB.CCC.DDD.XXX does not exist. at coldfusion.orm.mapping.CFPropertyBinder.readCFCData(CFPropertyBinder.java:375)

 at coldfusion.orm.mapping.CFPropertyBinder.buildCFCPersistenceMetadata(CFPropertyBinder.java:224)

 at coldfusion.orm.mapping.CFPropertyBinder.getCFCPersistenceMetadata(CFPropertyBinder.java:204)

 at coldfusion.orm.hibernate.HibernateConfiguration.generateHbmDocFromCFCs(HibernateConfiguration.java:1087)

 at coldfusion.orm.hibernate.HibernateConfiguration.generateAndLoadHBMFilesFromCFCs(HibernateConfiguration.java:705)

 at coldfusion.orm.hibernate.HibernateConfiguration.buildConfiguration(HibernateConfiguration.java:597)

 at coldfusion.orm.hibernate.HibernateConfiguration.initHibernateConfiguration(HibernateConfiguration.java:208)

 at coldfusion.orm.hibernate.HibernateConfiguration.<init>(HibernateConfiguration.java:181)

 at coldfusion.orm.hibernate.ConfigurationManager.initConfiguration(ConfigurationManager.java:67)

 at coldfusion.orm.hibernate.HibernateProvider.InitializeORMForApplication(HibernateProvider.java:185)

 at coldfusion.orm.hibernate.HibernateProvider.beforeApplicationStart(HibernateProvider.java:80)

 at coldfusion.filter.ApplicationFilter.fireBeforeAppStartEvent(ApplicationFilter.java:566)

 at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:300)

 at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)

 at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)

 at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)

 at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)

 at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79)

 at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)

 at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)

 at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)

 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:219)

 at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)

 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

 at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)

 at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)

 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)

 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)

 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)

 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)

 at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928)

 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:414)

 at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:204)

 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539)

 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298)

 at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

 at java.lang.Thread.run(Thread.java:662)

[Sam Farmer]

Sounds like changing the mapping is your problem. What did you a) change it from and to? b) Do you need to use ormsettings.cfclocation directory?

Cheers,

Sam

[zabimaru]

Hi Sam

Changing the mapping means renaming from i.e 'XYZ' to 'xyz' rite? We have not commited this kind of changes and yup we use ormsettings.cfclocation 

Thanks

[Kurt Wiersma]

I had something similar happen to me a while back. It turned out that the DBA who created the table accidentally had put a space at the end of the table name so you might want to double check that.

--Kurt

[md makmur]

hi kurt

thanks for your input, i've checked, no issue with spaces

in the same ormsettings.cfclocation directory, theres also ORMinterceptor.cfc which can be detected, (no exception/error seen for that)

I resorted to just remove every cfc in the ormsettings.cfclocation directory, and then try to run 1 cfc by 1 cfc. 1 in 1 out, and it seems every cfc i tried will fail with this exception. 

I have tried changing the ormsettings.cfclocation directory, move it somewhere else, still not working

--
You received this message because you are subscribed to a topic in the Google Groups "cf-orm-dev" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/cf-orm-dev/r6bvjbDlEIg/unsubscribe.
To unsubscribe from this group and all its topics, send an email to cf-orm-dev+...@googlegroups.com.

[Phill Nacelli]

Just to clarify:

1. So there were no changes at all to the code base (even changes not related to persistent orm objects) and this started happening? 

2. Does anybody have access to the database directly like a DBA?

3. Do you guys have version control in place for both your codebase and any sql scripts that is executed against the db?

[zabimaru]

hi phill and everyone

thanks for your time 

the issue is solved, all is fail until we found out one of the tables were corrupted. I forgot to copy the error out but such corrupted table error can be seen when I try to select the table from workbench

I didn't found this myself, my colleague tried to check using 

SELECT *

FROM information_schema.TABLES

WHERE TABLE_SCHEMA = 'xxxxxx'

and he found unusual output for that one particular table

Thanks all

On Tuesday, June 25, 2013 3:11:56 AM UTC+8, Phill Nacelli wrote:

Just to clarify:

1. So there were no changes at all to the code base (even changes not related to persistent orm objects) and this started happening? -nope

2. Does anybody have access to the database directly like a DBA? -yup

3. Do you guys have version control in place for both your codebase and any sql scripts that is executed against the db? -nope (what would you suggest? If I may ask)