ORM errors in cbadmin

10 views
Skip to first unread message

Vijay K

unread,
Apr 17, 2020, 8:19:33 AM4/17/20
to ContentBox Modular CMS
I am trying to create a new user and got the following error.

{"data":"","errorcode":0,"messages":["General application error: Not an entity [class coldfusion.orm.PersistentTemplateProxy]"],"error":true}

It is happening while creating a role also.

I am using ContentBox 4.x and SQL server.

Luis Majano

unread,
Apr 17, 2020, 9:24:34 AM4/17/20
to conte...@googlegroups.com, ContentBox Modular CMS
Which CFML engine? What ORM Dialect did you choose in Application.cfc

--
--
---
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.
Sent from Mailspring

Vijay K

unread,
Apr 17, 2020, 10:05:04 AM4/17/20
to conte...@googlegroups.com
 CF2018 and MSSQLSERVER I have added in dialect.

To view this discussion on the web visit https://groups.google.com/d/msgid/contentbox/7AA6D34F-03EC-47C5-A638-B3643764B9A6%40getmailspring.com.

Luis Majano

unread,
Apr 17, 2020, 10:18:42 AM4/17/20
to conte...@googlegroups.com, conte...@googlegroups.com
I think this is a bug with ACF 2018 if I remember correctly.  Can you do me a favor, I need the steps you took in order for me to replicate.

--
--
---
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.
--
--
---
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.

Vijay K

unread,
Apr 17, 2020, 11:32:48 AM4/17/20
to conte...@googlegroups.com
Nothing much Luis. 
1. Open CB admin
2. Users -> Create user ->fill the form ->click on submit button.

Got the error.

To view this discussion on the web visit https://groups.google.com/d/msgid/contentbox/ACC1EBFA-A1DA-4019-B8A2-DE6A310395E1%40getmailspring.com.

Andreas

unread,
Apr 19, 2020, 5:47:18 PM4/19/20
to ContentBox Modular CMS
Hi Vijay K,

this is just an idea, because I had similar issues with MariaDB:

Can you add this code for a moment, right into the beginning of the onRequestStart function of coldbox Application.cfc (this should be in line 91) and load a page to show a dump of the dialect set to your datasource? That should work on CF2018.

ObjORM=ORMGetSession( "put_name_of_your_datasource_here" );
WriteDump( ObjORM.getSessionFactory().getJdbcServices().getDialect());
abort;

it will dump the selected dialect, just to make sure the one that has been defined by you in the Application.cfc is correct. When hibernate can't find a dialect you have set, it may decide to guess one. 

What I've read is, that in CF you can specify dialects with the fully qualified class name. Don't know the hibernate version CF2018 use, but here is a list of 5.0:
https://github.com/hibernate/hibernate-orm/tree/5.0/hibernate-core/src/main/java/org/hibernate/dialect
.  
That means, you could try setting:
org.hibernate.dialect.SQLServerDialect
org.hibernate.dialect.SQLServer2005Dialect
org.hibernate.dialect.SQLServer2008Dialect
org.hibernate.dialect.SQLServer2012Dialect

NOTE: Somehow CF2018 stores the orm datasource dialect. When changing the dialect, you'll need to restart the engine.

Just a try and idea, don't know it this is really a help.

Good luck!
Reply all
Reply to author
Forward
0 new messages