[opencms-dev] OpenCms 7.0.5 Explorer has no LeftClick Manus and no types in new window

Sun Oct 5 12:20:11 CEST 2008

Probably you should include

C_READ_RESOURCE_OUS=\
SELECT DISTINCT \
	${C_RELATIONS_SELECT_ATTRIBS} \
FROM \
	CMS_${PROJECT}_RESOURCE_RELATIONS \
WHERE \
    CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_TYPE = ? \
    AND ? LIKE
CONCAT(CMS_${PROJECT}_RESOURCE_RELATIONS.RELATION_TARGET_PATH, '%')

query in the opencms_7.0.5_src/src/org/opencms/db/mssql/query.properties
with the right syntax for MS SQL - it seems MS SQL do not like CONCAT
function.

In case you try JPA driver jus increase the <property
name="openjpa.DataCache" value="true(CacheSize=2000, SoftReferenceSize=0)"/>

from 2000 to 2000 or 100000, depends on your site and available server's
 RAM.

WEB-INF/classes/META-INF/persistence.xml file of binary distribution.

Vahe Momjian wrote:
> Here is what I found in logs
> 
> 05 Oct 2008 14:49:43,308 ERROR [explorer.CmsExplorerTypeAccess: 235] Error reading groups of user Admin
> org.opencms.db.CmsDbSqlException: Error reading all roles for user "Admin" over resource "/".
>     at org.opencms.db.CmsDbSqlException.createException(CmsDbSqlException.java:116)
>     at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:238)
>     at org.opencms.db.CmsDbContext.report(CmsDbContext.java:212)
>     at org.opencms.db.CmsSecurityManager.getRolesForResource(CmsSecurityManager.java:2257)
>     at org.opencms.security.CmsRoleManager.getRolesForResource(CmsRoleManager.java:260)
>     at org.opencms.workplace.explorer.CmsExplorerTypeAccess.getPermissions(CmsExplorerTypeAccess.java:232)
>     at org.opencms.workplace.explorer.CmsExplorerTypeSettings.isEditable(CmsExplorerTypeSettings.java:458)
>     at org.opencms.workplace.explorer.CmsNewResource.getListItems(CmsNewResource.java:973)
>     at org.opencms.workplace.list.A_CmsListDialog.fillList(A_CmsListDialog.java:883)
>     at org.opencms.workplace.list.A_CmsListDialog.refreshList(A_CmsListDialog.java:628)
>     at org.opencms.workplace.list.A_CmsListDialog.actionDialog(A_CmsListDialog.java:364)
>     at org.opencms.workplace.list.A_CmsListResourceTypeDialog.actionDialog(A_CmsListResourceTypeDialog.java:216)
>     at org.opencms.workplace.explorer.CmsNewResource.actionDialog(CmsNewResource.java:414)
>     at org.opencms.workplace.list.A_CmsListDialog.displayDialog(A_CmsListDialog.java:411)
>     at org.opencms.workplace.list.A_CmsListDialog.displayDialog(A_CmsListDialog.java:396)
>     at org.apache.jsp.WEB_002dINF.jsp.offline.system.workplace.commons.newresource_jsp._jspService(newresource_jsp.java:167)
>     at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
>     at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
>     at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
>     at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
>     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
>     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:679)
>     at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:584)
>     at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:497)
>     at org.opencms.flex.CmsFlexRequestDispatcher.includeExternal(CmsFlexRequestDispatcher.java:194)
>     at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:169)
>     at org.opencms.loader.CmsJspLoader.service(CmsJspLoader.java:1193)
>     at org.opencms.flex.CmsFlexRequestDispatcher.includeInternalWithCache(CmsFlexRequestDispatcher.java:423)
>     at org.opencms.flex.CmsFlexRequestDispatcher.include(CmsFlexRequestDispatcher.java:173)
>     at org.opencms.loader.CmsJspLoader.dispatchJsp(CmsJspLoader.java:1227)
>     at org.opencms.loader.CmsJspLoader.load(CmsJspLoader.java:1171)
>     at org.opencms.loader.CmsResourceManager.loadResource(CmsResourceManager.java:964)
>     at org.opencms.main.OpenCmsCore.showResource(OpenCmsCore.java:1498)
>     at org.opencms.main.OpenCmsServlet.doGet(OpenCmsServlet.java:152)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
>     at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
>     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
>     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
>     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
>     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
>     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
>     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
>     at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:835)
>     at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:640)
>     at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1286)
>     at java.lang.Thread.run(Unknown Source)
> Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: net.sourceforge.jtds.jdbc.JtdsPreparedStatement at 2153fe. 
>     at org.opencms.db.generic.CmsVfsDriver.getResourceOus(CmsVfsDriver.java:1892)
>     at org.opencms.db.generic.CmsVfsDriver.readRelations(CmsVfsDriver.java:1775)
>     at org.opencms.db.CmsDriverManager.getResourceOrgUnits(CmsDriverManager.java:4100)
>     at org.opencms.db.CmsDriverManager.getRolesForResource(CmsDriverManager.java:4200)
>     at org.opencms.db.CmsSecurityManager.getRolesForResource(CmsSecurityManager.java:2255)
>     ... 47 more
> Caused by: java.sql.SQLException: 'CONCAT' is not a recognized function name.
>     at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
>     at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
>     at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
>     at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
>     at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:418)
>     at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:693)
>     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
>     at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
>     at org.opencms.db.generic.CmsVfsDriver.getResourceOus(CmsVfsDriver.java:1877)
>     ... 51 more
> 
> Will try also with JPA.
> Will try to correct...
> Regards
> Vahe Momjyan
> 
> 
> 
> ----- Original Message ----
> From: Georgi Naplatanov <gosho at oles.biz>
> To: The OpenCms mailing list <opencms-dev at opencms.org>
> Sent: Sunday, October 5, 2008 2:56:21 PM
> Subject: Re: [opencms-dev] OpenCms 7.0.5 Explorer has no LeftClick Manus and no types in new window
> 
> Hello, Vahe.
> 
> I'm not sure, but one of possible reasons is error of some SQL queries
> for MS SQL server.
> 
> Just check log files and fix queries if applicable.
> 
> Best regards
> Georgi
> 
> Vahe Momjian wrote:
>> I have installed OpenCms 7.0.5 on Tomcat 5.5.27 + MSSQL Server 2000 SP4 + Windows Server 2003 SP1 + JDK 6
>> OpenCms 7.0.5 Explorer has no LeftClick Manus and no types in new window, (all modules installed by default). But the same OpenCms Tomcat 5.5.27 + Oracle 10g + Windows Server 2000 SP4+ JDK 6 works fine. 
>>
>> How can I fix this?
>>
>>
>>
>>      
>>
>>
>> ------------------------------------------------------------------------
>>
>>
>> _______________________________________________
>> This mail is sent to you from the opencms-dev mailing list
>> To change your list options, or to unsubscribe from the list, please visit
>> http://lists.opencms.org/mailman/listinfo/opencms-dev
> 
> 
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
> 
> 
> 
>       
> 
> 
> ------------------------------------------------------------------------
> 
> 
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev