[opencms-dev] OpenCms and MS SQL Server 2005 / 'CONCAT' is not a recognized built-in function name.

[patric dosch]

Hey Georgi,

OpenCms 8.0.2 ... local, staging, live...

I've connected my local development environment (win7, 64bit) with the staging database and get the same error when opening the context menu.
But works on Staging (Win2003 Server, 64bit).

Regards, Patric

-----Ursprüngliche Nachricht-----
Von: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] Im Auftrag von Georgi Naplatanov
Gesendet: Mittwoch, 9. November 2011 13:09
An: opencms-dev at opencms.org
Betreff: Re: [opencms-dev] OpenCms and MS SQL Server 2005 / 'CONCAT' is not a recognized built-in function name.

Hi Patric.

What are versions  of OpenCms on both servers ?

Best regards
Georgi

On 11/09/2011 01:34 PM, patric dosch wrote:
> Hey List, Hey Alkacon,
>
> I have a problem I do not understand.
> We use the MS SQL Server 2005 and this is also installed on the 
> staging system (Win 2003 Server).
>
> Staging everything works. Yes!
>
> The problem comes when the context menu opens. On the live system, I 
> get the following error:
>
> 09 Nov 2011 11:01:46,618 ERROR [CmsExplorerTypeAccess.java: 227] Error 
> reading groups of user Admin
> org.opencms.db.CmsDbSqlException: Error reading all roles for user 
> "Admin" over resource "/de/bewerben-bei-smc/".
> 	[...]
> Caused by: java.sql.SQLException: 'CONCAT' is not a recognized 
> built-in function name.
> 	at
> net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.ja
> va
> :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.
> ja
> va:418)
> 	at
> net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPrepa
> re
> dStatement.java:693)
> 	at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Deleg
> at
> ingPreparedStatement.java:96)
> 	at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Deleg
> at
> ingPreparedStatement.java:96)
> 	at
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(Deleg
> at
> ingPreparedStatement.java:96)
> 	at
> org.opencms.db.generic.CmsVfsDriver.getResourceOus(CmsVfsDriver.java:1
> 18
> 5)
> 	... 54 more
>
>
> The SQL that is executed:
>
> SELECT DISTINCT
> CMS_OFFLINE_RESOURCE_RELATIONS.RELATION_SOURCE_ID,CMS_OFFLINE_RESOURCE
> _R 
> ELATIONS.RELATION_SOURCE_PATH,CMS_OFFLINE_RESOURCE_RELATIONS.RELATION_
> TA 
> RGET_ID,CMS_OFFLINE_RESOURCE_RELATIONS.RELATION_TARGET_PATH,CMS_OFFLIN
> E_ RESOURCE_RELATIONS.RELATION_TYPE FROM 
> CMS_OFFLINE_RESOURCE_RELATIONS WHERE 
> CMS_OFFLINE_RESOURCE_RELATIONS.RELATION_TYPE = 8 AND 
> '/sites/default/de/' LIKE 
> CONCAT(CMS_OFFLINE_RESOURCE_RELATIONS.RELATION_TARGET_PATH, '%')
>
> When I run this statement in MS SQL manager, I actually get the 
> described error! But how can it be that this does not happen on the 
> Staging-System? No trace in the log files.
>
>
> For some help I would be very grateful!
> Regards, Patric
>
>
>
> _____________________________________________________________________
> Virtual Identity AG
> Gruenwaelderstrasse 10-14
> 79098 Freiburg
> Amtsgericht Freiburg, HRB 6218
> Vorstand: Ralf Heller, Udo Mobes
> Vorsitzende des Aufsichtsrates: Kirsten Heller
> Umsatzsteuer-ID: DE208002218
>
> Versand am 09.11.2011 12:34 von dosch patric
> Validation-Code: 1246713507202
>
>
>
>
> _______________________________________________
> 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/cgi-bin/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/cgi-bin/mailman/listinfo/opencms-dev