ContentBox with Oracle11g setup error

[Ed Andrade]

Hi,

I am trying to get ContentBox setup and running with our Oracle 11g database and running into issues.  The software stack is Tomcat 7.0.41 fresh clean install, with Coldfusion 10 Patch 10 clean install.  I setup my Oracle DSN in CFAdmin and got it validated so I know CF is can talk to the DB.  I then hit the CB root to go through the setup, and tell it to use the DSN I setup in CFAdmin (called it contentbox btw), which is accepts and moves on to trying to create the DB objects.  I originally had the issue of Oracle complaining about not allowing two fields of type "long" in the same table, and I found the other post about that and changed the Author.cfc fields from text/8000 to clob's.

Now I am getting "ORA-01408: such column list already indexed".  The stack trace I am getting is not very helpful and is below.  Any thoughts or suggestions?

06/21 13:09:49 [http-bio-80-exec-7] HIBERNATE ERROR - could not complete schema update

org.hibernate.JDBCException: Error during DDL export

at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:209)

at coldfusion.orm.hibernate.HibernateConfiguration.exportSchema(HibernateConfiguration.java:453)

at coldfusion.orm.hibernate.HibernateConfiguration.exportSchema(HibernateConfiguration.java:411)

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

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

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

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.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:222)

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

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

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

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

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

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

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

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)

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

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

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

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

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

Caused by: java.sql.SQLException: ORA-01408: such column list already indexed

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)

at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)

at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:561)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1086)

at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1487)

at coldfusion.server.j2ee.sql.JRunStatement.executeUpdate(JRunStatement.java:193)

at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:204)

... 41 more

Thanks

-Ed Andrade

[br...@bradwood.com]

> Caused by: java.sql.SQLException: ORA-01408: such column list already indexed

Can you drop all the tables and start over again.  Perhaps some of the DB is still there from the first attempt.

Also, can you create tickets for any Oracle issues you find?

https://ortussolutions.atlassian.net/browse/CONTENTBOX

Thanks!

~Brad

ColdBox Platform Evangelist
Ortus Solutions, Corp

E-mail: br...@coldbox.org
ColdBox Platform: http://www.coldbox.org
Blog: http://www.codersrevolution.com 

 

 

--------- Original Message ---------

--
--
You received this message because you are subscribed to the Google Groups "ColdBox Platform" group.
For News, visit http://www.gocontentbox.org/blog
For Bug Reports, visit https://ortussolutions.atlassian.net/browse/CONTENTBOX
---
You received this message because you are subscribed to the Google Groups "ContentBox Modular CMS" group.
To unsubscribe from this group and stop receiving emails from it, send an email to contentbox+...@googlegroups.com.
To post to this group, send email to conte...@googlegroups.com.
Visit this group at http://groups.google.com/group/contentbox.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

[George Murphy]

If you could setup Hibernate logging we could see the SQL that is being created and perhaps find the missing pieces.

Thanks,

George Murphy

--
George Murphy
President
DeSign By George, Inc.
http://www.websbygeorge.com
703-867-1934

[George Murphy]

Ed, it is my understanding that ContentBox does not work with Oracle yet. Brad, is there a ticket for this yet?

Thanks,

George Murphy

[Ed Andrade]

I think I am getting closer to figuring this out.  Attached is the hibernate log....

[br...@bradwood.com]

George, I don't know of any tickets in JIRA for ContentBox and Oracle we we'll need help getting them created for whatever needs fixing.

[George Murphy]

Hi Ed, as a work around you can try creating the DB in mySQL of mssql server and using a tool like Navicat to create the tables and structure in Oracle. I tried that once with some success but I never had time to finish it. I remember running into some errors. I do not have the latest version of that table creation script or I would send it to you. Not sure if you have ever worked with Navicat but it is good for stuff like that. Download the trial version of Navicat Premium.

Thanks,

George Murphy

[George Murphy]

Here's some insite on that ORA-01408 error you are getting in the Hibernate file.

https://forums.oracle.com/thread/631936

[Ed Andrade]

Thanks for the tip.  I am actually making progress in Oracle though.  I am finding two specific types of issues:

• Table properties that have both unique="true" and an index specified.  I think what is happening in Oracle is that Oracle automatically creates a unique index with a system generated name with unique="true" and then tries to create another index with the index name specified.  I don't know about other DB's but Oracle does not like having 2 indexes for the same field.
• More then one table is using the same index name.  Again, I am guessing other DB's don't mind having duplicate index names as long as they are for different tables, but Oracle does not like it.

What I am working my way through is for the first one, I am removing the index specification and just allowing the system generated name.  For the second issue, I am finding all the instances of that index name and making it unique.

I'm thinking that at least the second change may be useful to get into the code base?  What would be a good way to submit the changes (if that is even appropriate) for review when I am done?

-Ed

On Friday, June 21, 2013 3:25:26 PM UTC-4, George Murphy wrote:

Hi Ed, as a work around you can try creating the DB in mySQL of mssql server and using a tool like Navicat to create the tables and structure in Oracle. I tried that once with some success but I never had time to finish it. I remember running into some errors. I do not have the latest version of that table creation script or I would send it to you. Not sure if you have ever worked with Navicat but it is good for stuff like that. Download the trial version of Navicat Premium.

Thanks,

George Murphy

[clockwo...@gmail.com]

hello it is now December 2018 and I am still running into this issue with Oracle 12c is there a version for Oracle that has been made if not I will for the contentbox code base and make one working through these errors and even finding this group has been a challenge. Is there a community website other than this that has solutions for common problems with this framework and CMS? 

[Luis Majano]

Hi

The website and documentation all have links to the google help forum and slack for real-time assistance.

I would suggest you join the box team slack for real-time assistance: boxteam.herokuapp.com.

George Murphy was leading the oracle charge so I will point him to this post and also he is slack as well.

Luis Majano

CEO

Ortus Solutions, Corp

www.ortussolutions.com

P/F: 1-888-557-8057

 

---

From: conte...@googlegroups.com on behalf of clockwo...@gmail.com
Sent: Monday, December 3, 2018 3:53 PM
To: ContentBox Modular CMS
Subject: Re: Re: [contentbox-version] ContentBox with Oracle11g setup error

 

--
--
For News, visit https://www.ortussolutions.com/blog/category/contentbox-cms

For Bug Reports, visit https://ortussolutions.atlassian.net/browse/CONTENTBOX
---
You received this message because you are subscribed to the Google Groups "ContentBox Modular CMS" group.
To unsubscribe from this group and stop receiving emails from it, send an email to contentbox+...@googlegroups.com.
To post to this group, send email to conte...@googlegroups.com.

Visit this group at https://groups.google.com/group/contentbox.
To view this discussion on the web visit https://groups.google.com/d/msgid/contentbox/a1eb66d4-3b70-4ebe-ad70-85d00a15fe41%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[clockwo...@gmail.com]

hello after fixing all the models for Oracle 12c I have run into the following error I found this document https://coldbox.ortusbooks.com/hmvc/modules/module-service/loading-new-modules its unclear where to register the module though 

Cannot activate module: contentbox

The module has not been registered, register the module first and then activate it.

The error occurred in D:/cf2016/ColdFusion2016.ear/cfusion.war/contentbox/coldbox/system/web/services/ModuleService.cfc: line 447 Called from D:/cf2016/ColdFusion2016.ear/cfusion.war/contentbox/coldbox/system/web/services/ModuleService.cfc: line 480 Called from D:/cf2016/ColdFusion2016.ear/cfusion.war/contentbox/coldbox/system/web/services/ModuleService.cfc: line 475 Called from D:/cf2016/ColdFusion2016.ear/cfusion.war/contentbox/coldbox/system/web/services/ModuleService.cfc: line 422 Called from D:/cf2016/ColdFusion2016.ear/cfusion.war/contentbox/coldbox/system/web/services/LoaderService.cfc: line 57 Called from D:/cf2016/ColdFusion2016.ear/cfusion.war/contentbox/coldbox/system/Bootstrap.cfc: line 98 Called from D:/cf2016/ColdFusion2016.ear/cfusion.war/contentbox/Application.cfc: line 85

445 : if( NOT structKeyExists( modules, arguments.moduleName ) ){ 446 : throw( 447 : message = "Cannot activate module: #arguments.moduleName#", 448 : detail = "The module has not been registered, register the module first and then activate it.", 449 : type = "ModuleService.IllegalModuleState"

Resources: Check the ColdFusion documentation to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem.

Browser   Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; NISSC; rv:11.0) like Gecko Remote Address   56.72.36.89 Referrer   http://spmeswdev.eng.usps.gov/contentbox/modules/contentbox-dsncreator/ Date/Time   04-Dec-18 10:52 AM

Stack Trace

at cfModuleService2ecfc1528452265$funcACTIVATEMODULE.runFunction(D:/cf2016/ColdFusion2016.ear/cfusion.war/contentbox/coldbox/system/web/services/ModuleService.cfc:447) at cfModuleService2ecfc1528452265$func_CF_ANONYMOUSCLOSURE_630.runFunction(D:/cf2016/ColdFusion2016.ear/cfusion.war/contentbox/coldbox/system/web/services/ModuleService.cfc:480) at cfModuleService2ecfc1528452265$funcACTIVATEMODULE.runFunction(D:/cf2016/ColdFusion2016.ear/cfusion.war/contentbox/coldbox/system/web/services/ModuleService.cfc:475) at cfModuleService2ecfc1528452265$funcACTIVATEALLMODULES.runFunction(D:/cf2016/ColdFusion2016.ear/cfusion.war/contentbox/coldbox/system/web/services/ModuleService.cfc:422) at cfLoaderService2ecfc627303249$funcLOADAPPLICATION.runFunction(D:/cf2016/ColdFusion2016.ear/cfusion.war/contentbox/coldbox/system/web/services/LoaderService.cfc:57) at cfBootstrap2ecfc1514318479$funcLOADCOLDBOX.runFunction(D:/cf2016/ColdFusion2016.ear/cfusion.war/contentbox/coldbox/system/Bootstrap.cfc:98) at cfApplication2ecfc1287499709$funcONAPPLICATIONSTART.runFunction(D:/cf2016/ColdFusion2016.ear/cfusion.war/contentbox/Application.cfc:85) coldfusion.runtime.CustomException: Cannot activate module: contentbox at coldfusion.tagext.lang.ThrowTag.doStartTag(ThrowTag.java:142) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3696) at cfModuleService2ecfc1528452265$funcACTIVATEMODULE.runFunction(D:\cf2016\ColdFusion2016.ear\cfusion.war\contentbox\coldbox\system\web\services\ModuleService.cfc:447) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3542) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3522) at cfModuleService2ecfc1528452265$func_CF_ANONYMOUSCLOSURE_630.runFunction(D:\cf2016\ColdFusion2016.ear\cfusion.war\contentbox\coldbox\system\web\services\ModuleService.cfc:480) at coldfusion.runtime.Closure.invoke(Closure.java:109) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3542) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3522) at coldfusion.runtime.ArrayUtil.ArrayEach(ArrayUtil.java:736) at coldfusion.runtime.CFPage.ArrayEach(CFPage.java:916) at java.lang.invoke.DirectHandle.invokeExact_thunkArchetype_V(DirectHandle.java:149) at java.lang.invoke.FilterReturnHandle.invokeExact_thunkArchetype_X(FilterReturnHandle.java:42) at java.lang.invoke.AsTypeHandle.invokeExact_thunkArchetype_X(AsTypeHandle.java:34) at coldfusion.runtime.CfJspPage.invokeMethodHandle(CfJspPage.java:3198) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3154) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3074) at cfModuleService2ecfc1528452265$funcACTIVATEMODULE.runFunction(D:\cf2016\ColdFusion2016.ear\cfusion.war\contentbox\coldbox\system\web\services\ModuleService.cfc:475) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3542) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3522) at cfModuleService2ecfc1528452265$funcACTIVATEALLMODULES.runFunction(D:\cf2016\ColdFusion2016.ear\cfusion.war\contentbox\coldbox\system\web\services\ModuleService.cfc:422) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3097) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3074) at cfLoaderService2ecfc627303249$funcLOADAPPLICATION.runFunction(D:\cf2016\ColdFusion2016.ear\cfusion.war\contentbox\coldbox\system\web\services\LoaderService.cfc:57) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3097) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3074) at cfBootstrap2ecfc1514318479$funcLOADCOLDBOX.runFunction(D:\cf2016\ColdFusion2016.ear\cfusion.war\contentbox\coldbox\system\Bootstrap.cfc:98) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3097) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3074) at cfApplication2ecfc1287499709$funcONAPPLICATIONSTART.runFunction(D:\cf2016\ColdFusion2016.ear\cfusion.war\contentbox\Application.cfc:85) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114) at coldfusion.runtime.AppEventInvoker.onApplicationStart(AppEventInvoker.java:237) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:345) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:153) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) 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:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1234) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:778) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:477) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:143) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:96) at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42) at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:197) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:90) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:969) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1109) at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:82) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:961) at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1817) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:294) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:465) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:532) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:318) at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:88) at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175) at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204) at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775) at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892)

To post to this group, send email to cont...@googlegroups.com.

[Brad Wood]

That sounds like a secondary error.  Meaning the first request to the site likely errored out while trying to register the contentbox module and left the framework in a corrupted stated.  Then the second (and so on) request to the site tried to use the module. 

What is the first error you get if hitting the with ?fwreinit=1 in the URL?

Thanks!

~Brad

Developer Advocate

Ortus Solutions, Corp 

E-mail: br...@coldbox.org

ColdBox Platform: http://www.coldbox.org 

Blog: http://www.codersrevolution.com

To view this discussion on the web visit https://groups.google.com/d/msgid/contentbox/09ddb165-ad03-48ae-97e1-37c95eef1e92%40googlegroups.com.

[clockwo...@gmail.com]

[clockwo...@gmail.com]

just posted some screen shots its the same error after changing the url to re init

On Tuesday, December 4, 2018 at 12:13:18 PM UTC-5, Brad Wood wrote:

[Brad Wood]

Nope, that's the same error.  Did you not notice that?  Try doing a server restart and grab the very first fresh hit to the site.  Also, check your logs, which may need configured. 

Thanks!

~Brad

Developer Advocate

Ortus Solutions, Corp 

E-mail: br...@coldbox.org

ColdBox Platform: http://www.coldbox.org 

Blog: http://www.codersrevolution.com

To view this discussion on the web visit https://groups.google.com/d/msgid/contentbox/2ef9d22b-d77a-4cd8-830e-3c443585b5cd%40googlegroups.com.

[clockwo...@gmail.com]

I cleared my logs and restarted the server there was only two errors the first is 

"Error","WebContainer : 0","12/04/18","13:14:08","","Skipping file D:\cf2016\ColdFusion2016.ear\cfusion.war\contentbox\modules\contentbox-dsncreator\models\LuceeHelper.cfc as it has errors"

the second is 

"Error","WebContainer : 0","12/04/18","13:17:14","ContentBox8A49A13FFF678888E2ACCE3A10C1D412","Cannot activate module: contentboxThe module has not been registered, register the module first and then activate it. The specific sequence of files included or processed is: D:\cf2016\ColdFusion2016.ear\cfusion.war\contentbox\index.cfm, line: 447 "

coldfusion.runtime.CustomException: Cannot activate module: contentbox

at coldfusion.tagext.lang.ThrowTag.doStartTag(ThrowTag.java:142)

[Brad Wood]

Ok, we've covered this 3 times now.  The second error is nothing.  It means nothing to us.  All it means is that something in the past happened that was bad.  All we care about is the first error.  

Your issue is your ORM CFC locations are misconfigured and ColdFusion is scanning the entire webroot looking for ORM entities.  You need to correctly limit that down to only be the modules and module_app folder.  (And the coldbox models folder if you plan on having ORM entities there). 

Thanks!

~Brad

Developer Advocate

Ortus Solutions, Corp 

E-mail: br...@coldbox.org

ColdBox Platform: http://www.coldbox.org 

Blog: http://www.codersrevolution.com

To view this discussion on the web visit https://groups.google.com/d/msgid/contentbox/b8aea31e-e991-456b-b110-4bd5d15380cb%40googlegroups.com.

[clockwo...@gmail.com]

Thanks Brad ill enter it into the procedures for installing contentBox on Cf 2016 Oracle 12c. ill post my source changes and documentation when I get it all working. 

[clockwo...@gmail.com]

it seems these setting are configured in the application.cfc 

cfclocation=[ "models", "modules", "modules_app" ],

does it matter that i am in s sub folder from the root?

[Brad Wood]

Yes, most likely.  If your CFC location paths are not found, ColdFusion will just scan the entire web root by default.  There is no error message so it's difficult for you to detect when this happens.  You should consult the docs on CF ORM confirm how to specify your CFC paths.

Thanks!

~Brad

Developer Advocate

Ortus Solutions, Corp 

E-mail: br...@coldbox.org

ColdBox Platform: http://www.coldbox.org 

Blog: http://www.codersrevolution.com

To view this discussion on the web visit https://groups.google.com/d/msgid/contentbox/1d1dee03-15db-4a16-89ad-a12da1920063%40googlegroups.com.

[clockwo...@gmail.com]

I am now using apache web sever with coldfusion 2016 and Oracle 12c DB. I got rid of the websphere web server because of the fact that you had to rebuild the .ear file for every change. 

the current challenge we are facing is the fact that the framework keeps adding the keyword "as" to table alias's in the hibernate queries the workaround to get past the install was to remove all createalias function calls from the code base however the folowing query is still being generated on the home page and is using key word "as" in table alias so I am looking for a more permanent solution. Would you happen to know where the keyword as is being added to the query? should I modify the create alias query to have it strip out the "as"? Is that even possible? I also change my dialect variable in my application.cfc to Oracle11g and its still happening. I search all the hard coded queries and change those to not use the as keyword as well.

select

        this_.CONTENTID as CONTENTID1_6_2_,

        this_.CREATEDDATE as CREATEDDATE3_6_2_,

        this_.MODIFIEDDATE as MODIFIEDDATE4_6_2_,

        this_.ISDELETED as ISDELETED5_6_2_,

        this_.CONTENTTYPE as CONTENTTYPE2_6_2_,

        this_.TITLE as TITLE6_6_2_,

        this_.SLUG as SLUG7_6_2_,

        this_.PUBLISHEDDATE as PUBLISHEDDATE8_6_2_,

        this_.EXPIREDATE as EXPIREDATE9_6_2_,

        this_.ISPUBLISHED as ISPUBLISHED10_6_2_,

        this_.ALLOWCOMMENTS as ALLOWCOMMENTS11_6_2_,

        this_.PASSWORDPROTECTION as PASSWORDPROTECTIO12_6_2_,

        this_.HTMLKEYWORDS as HTMLKEYWORDS13_6_2_,

        this_.HTMLDESCRIPTION as HTMLDESCRIPTION14_6_2_,

        this_.HTMLTITLE as HTMLTITLE15_6_2_,

        this_.CACHE as CACHE16_6_2_,

        this_.CACHELAYOUT as CACHELAYOUT17_6_2_,

        this_.CACHETIMEOUT as CACHETIMEOUT18_6_2_,

        this_.CACHELASTACCESSTIMEOUT as CACHELASTACCESSTI19_6_2_,

        this_.MARKUP as MARKUP20_6_2_,

        this_.SHOWINSEARCH as SHOWINSEARCH21_6_2_,

        this_.FEATUREDIMAGE as FEATUREDIMAGE22_6_2_,

        this_.FEATUREDIMAGEURL as FEATUREDIMAGEURL23_6_2_,

        this_.FK_authorID as FK_authorID24_6_2_,

        this_.FK_parentID as FK_parentID25_6_2_,

        this_1_.LAYOUT as LAYOUT2_17_2_,

        this_1_.MOBILELAYOUT as MOBILELAYOUT3_17_2_,

        this_1_."order" as order4_17_2_,

        this_1_.SHOWINMENU as SHOWINMENU5_17_2_,

        this_1_.EXCERPT as EXCERPT6_17_2_,

        this_1_.SSLONLY as SSLONLY7_17_2_,

        (select

            cs.hits

        from

            cb_stats cs

        where

            cs.FK_contentID=this_.contentID) as formula22_2_,

        (select

            count(*)

        from

            cb_contentVersion cv

        where

            cv.FK_contentID=this_.contentID) as formula23_2_,

        (select

            count(*)

        from

            cb_contentVersion cv

        where

            cv.FK_contentID=this_.contentID

            AND cv.isActive = 1) as formula24_2_,

        (select

            count(*)

        from

            cb_comment comment

        where

            comment.FK_contentID=this_.contentID) as formula25_2_,

        (select

            count(*)

        from

            cb_comment comment

        where

            comment.FK_contentID=this_.contentID

            and comment.isApproved = 1) as formula26_2_,

        (select

            count(*)

        from

            cb_content content

        where

            content.FK_parentID=this_.contentID) as formula27_2_,

        cbauthor2_.AUTHORID as AUTHORID1_0_0_,

        cbauthor2_.CREATEDDATE as CREATEDDATE2_0_0_,

        cbauthor2_.MODIFIEDDATE as MODIFIEDDATE3_0_0_,

        cbauthor2_.ISDELETED as ISDELETED4_0_0_,

        cbauthor2_.FIRSTNAME as FIRSTNAME5_0_0_,

        cbauthor2_.LASTNAME as LASTNAME6_0_0_,

        cbauthor2_.EMAIL as EMAIL7_0_0_,

        cbauthor2_.USERNAME as USERNAME8_0_0_,

        cbauthor2_.PASSWORD as PASSWORD9_0_0_,

        cbauthor2_.ISACTIVE as ISACTIVE10_0_0_,

        cbauthor2_.LASTLOGIN as LASTLOGIN11_0_0_,

        cbauthor2_.BIOGRAPHY as BIOGRAPHY12_0_0_,

        cbauthor2_.PREFERENCES as PREFERENCES13_0_0_,

        cbauthor2_.ISPASSWORDRESET as ISPASSWORDRESET14_0_0_,

        cbauthor2_.IS2FACTORAUTH as IS15_0_0_,

        cbauthor2_.APITOKEN as APITOKEN16_0_0_,

        cbauthor2_.FK_roleID as FK_roleID17_0_0_,

        (select

            count(*)

        from

            cb_content content      

        where

            content.FK_authorID=cbauthor2_.authorID

            and content.contentType = 'Entry') as formula30_0_,

        (select

            count(*)

        from

            cb_content content      

        where

            content.FK_authorID=cbauthor2_.authorID

            and content.contentType = 'Page') as formula31_0_,

        (select

            count(*)

        from

            cb_content  content      

        where

            content.FK_authorID=cbauthor2_.authorID

            and content.contentType = 'ContentStore') as formula32_0_,

        cbstats3_.STATSID as STATSID1_25_1_,

        cbstats3_.CREATEDDATE as CREATEDDATE2_25_1_,

        cbstats3_.MODIFIEDDATE as MODIFIEDDATE3_25_1_,

        cbstats3_.ISDELETED as ISDELETED4_25_1_,

        cbstats3_.HITS as HITS5_25_1_,

        cbstats3_.FK_contentID as FK_contentID6_25_1_

    from

        cb_content this_

    inner join

        cb_page this_1_

            on this_.CONTENTID=this_1_.contentID

    inner join

        cb_author cbauthor2_

            on this_.FK_authorID=cbauthor2_.AUTHORID

    left outer join

        cb_stats cbstats3_

            on this_.CONTENTID=cbstats3_.FK_contentID

    where

        this_.contentType='Page'

        and this_.ISPUBLISHED=?

        and this_.PUBLISHEDDATE<?

        and (

            this_.EXPIREDATE is null

            or this_.EXPIREDATE>?

        )

        and this_.PASSWORDPROTECTION=?

        and this_1_.SHOWINMENU=?

        and this_.FK_parentID is null

    order by

        this_1_."order" asc

...

[clockwo...@gmail.com]

discovered that this line was the problem 

cb_comment comment 

its trying to alias cb_comment as comment but in Oracle its a reserved word 

...