SQL SERVER 2008:

aquahellishSoftware and s/w Development

Dec 13, 2013 (3 years and 7 months ago)

334 views

SQL SERVER 2008
:

Exception while searching the record in MDM WEB GUI


Complex type Entity:



XSD Schema
:

<
xsd:schema

xmlns:xsd
=
"http://www.w3.org/2001/XMLSchema"
>

<
xsd:import

namespace
=
"http://www.w3.org/2001/XMLSchema"
/>

<
xsd:element

name
=
"emp"
>

<
xsd:
annotation
>

<
xsd:appinfo

source
=
"X_Write"
>
System_Admin
</
xsd:appinfo
>

<
xsd:appinfo

source
=
"X_Write"
>
System_Interactive
</
xsd:appinfo
>

</
xsd:annotation
>

<
xsd:complexType
>

<
xsd:all
>

<
xsd:element

maxOccurs
=
"1"

minOccurs
=
"1"

name
=
"Id"

type
=
"xsd:string"
>

<
xsd:
annotation
>

<
xsd:appinfo

source
=
"X_Write"
>
System_Admin
</
xsd:appinfo
>

<
xsd:appinfo

source
=
"X_Write"
>
System_Interactive
</
xsd:appinfo
>

</
xsd:annotation
>

</
xsd:element
>

<
xsd:element

maxOccurs
=
"1"

minOccurs
=
"0"

name
=
"Name"

type
=
"Name_Type"
>

<
xsd:annotation
>

<
xsd:appinfo

source
=
"X_Write"
>
System_Admin
</
xsd:appinfo
>

<
xsd:appinfo

source
=
"X_Write"
>
System_Interactive
</
xsd:appinfo
>

</
xsd:annotation
>

</
xsd:element
>

</
xsd:all
>

</
xsd:complexType
>

<
xsd:unique

name
=
"emp"
>

<
xsd:selector

xpath
=
"."
/>

<
xsd:field

xpath
=
"Id"
/>

</
xsd:unique
>

</
xsd:element
>

<
xsd:simpleType

name
=
"NameType"
>

<
xsd:restriction

base
=
"xsd:string"
/>

</
xsd:simpleType
>

<
xsd:complexType

name
=
"Name_Type"
>

<
xsd:all
>

<
xsd:element

maxOccurs
=
"1"

minOccurs
=
"1"

name
=
"A"

type
=
"AType"
>

<
xsd:annotation
>

<
xsd:appinfo

source
=
"X_Write"
>
System_Admin
</
xsd:appinfo
>

<
xsd:appinfo

source
=
"X_Write"
>
System_Interactive
</
xsd:appinfo
>

</
xsd:annotation
>

</
xsd:element
>

<
xsd:element

maxOccurs
=
"1"

minOccurs
=
"0"

name
=
"B"

type
=
"BType"
>

<
xsd:annotation
>

<
xsd:appinfo

source
=
"X_Write"
>
System_Admin
</
xsd:appinfo
>

<
xsd:appinfo

source
=
"X_Write"
>
System_Interactive
</
xsd:appinfo
>

</
xsd:annotation
>

</
xsd:element
>

</
xsd:all
>

</
xsd:complexType
>

<
xsd:complexType

name
=
"AType"
>

<
xsd:all
>

<
xsd:element

maxOccurs
=
"1"

minOccurs
=
"1"

name
=
"a1"

type
=
"
xsd:string"
>

<
xsd:annotation
>

<
xsd:appinfo

source
=
"X_Write"
>
System_Admin
</
xsd:appinfo
>

<
xsd:appinfo

source
=
"X_Write"
>
System_Interactive
</
xsd:appinfo
>

</
xsd:annotation
>

</
xsd:element
>

<
xsd:element

maxOccurs
=
"1"

minOccurs
=
"0"

name
=
"a2"

type
=
"a2type"
>

<
xsd:
annotation
>

<
xsd:appinfo

source
=
"X_Write"
>
System_Admin
</
xsd:appinfo
>

<
xsd:appinfo

source
=
"X_Write"
>
System_Interactive
</
xsd:appinfo
>

</
xsd:annotation
>

</
xsd:element
>

</
xsd:all
>

</
xsd:complexType
>

<
xsd:complexType

name
=
"BType"
>

<
xsd:all
>

<
xsd:element

maxOccurs
=
"1"

minOccurs
=
"1"

name
=
"b1"

type
=
"xsd:string"
>

<
xsd:annotation
>

<
xsd:appinfo

source
=
"X_Write"
>
System_Admin
</
xsd:appinfo
>

<
xsd:appinfo

source
=
"X_Write"
>
System_Interactive
</
xsd:appinfo
>

</
xsd:annotation
>

</
xsd:element
>

</
xsd:all
>

</
xsd:complexType
>

<
xsd:simpleType

name
=
"a2type"
>

<
xsd:restriction

base
=
"xsd:string"
>

<
xsd:enumeration

value
=
"1"
/>

<
xsd:enumeration

value
=
"2"
/>

<
xsd:enumeration

value
=
"3"
/>

</
xsd:restriction
>

</
xsd:simpleType
>

</
xsd:schema
>



Server Log File:

2013
-
04
-
01 19:00:01,241 INFO [
STDOUT] Hibernate: select top 20 this_.x_Id as y0_, CONCAT('', '') as y1_
from EMP1 this_

2013
-
04
-
01 19:00:01,249 WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 195, SQLState:
S00010

2013
-
04
-
01 19:00:01,250 ERROR [org.hibernate.util.JDBCExcept
ionReporter] 'CONCAT' is not a
recognized built
-
in function name.

2013
-
04
-
01 19:00:01,251 ERROR [com.amalto.core.storage.StorageLogger] ##### Error during fetch
operation #####

2013
-
04
-
01 19:00:01,252 ERROR [com.amalto.core.delegator.impl.DefaultItemCtrlDe
legator] Unable to
single search: : java.lang.RuntimeException: java.lang.RuntimeException: Exception occurred during
fetch operation

java.lang.RuntimeException: java.lang.RuntimeException: Exception occurred during fetch operation


at com.amalto.core.stor
age.StorageLogger.fetch(Unknown Source)


at com.amalto.core.delegator.IItemCtrlDelegator.viewSearch(Unknown Source)


at com.amalto.core.ejb.ItemCtrl2Bean.viewSearch(Unknown Source)


at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)


at sun.ref
lect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)


at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)


at java.lang.reflect.Method.invoke(Method.java:597)


at org.jboss.invocation.Invocation.perfor
mCall(Invocation.java:359)


at
org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:23
7)


at
org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterce
ptor.java:158)


at
org
.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.ja
va:169)


at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)


at org.jboss.ejb.plugins.AbstractTxInterceptor.invoke
Next(AbstractTxInterceptor.java:121)


at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)


at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)


at

org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)


at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)


at
org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)


at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)


at org.jboss.ejb.Container.invoke(Container.java:960)


at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:430)


at org.jboss.ejb.plugins.local
.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)


at $Proxy274.viewSearch(Unknown Source)


at com.amalto.webapp.core.util.IXtentisRMIPort.viewSearch(Unknown Source)


at
org.talend.mdm.webapp.browserecords.server.actions.BrowseRecordsAction.get
ItemBeans(BrowseRec
ordsAction.java:876)


at
org.talend.mdm.webapp.browserecords.server.actions.BrowseRecordsAction.queryItemBeans(BrowseR
ecordsAction.java:848)


at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)


at sun.reflect.NativeMethodAcce
ssorImpl.invoke(NativeMethodAccessorImpl.java:39)


at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)


at java.lang.reflect.Method.invoke(Method.java:597)


at
org.talend.mdm.webapp.general.gwt.GWTRPC.invokeAndEncodeRes
ponse(GWTRPC.java:251)


at
org.talend.mdm.webapp.general.gwt.ProxyGWTServiceImpl.doProcessCall(ProxyGWTServiceImpl.java:1
50)


at org.talend.mdm.webapp.base.server.AbstractService.processCall(AbstractService.java:52)


at
com.google.gwt.user.server.rpc.Remot
eServiceServlet.processPost(RemoteServiceServlet.java:248)


at
com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.ja
va:62)


at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)


at javax.servlet.http.
HttpServlet.service(HttpServlet.java:803)


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


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


at org.jboss.web.
tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)


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


at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.j
ava:206)


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


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


at

org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)


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


at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccConte
xtValve.java:84)


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


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


at
org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedCon
nectionValve.java:157)


at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:420)


at org.apache.catalina.authenticator.MDMSingleSignOn.invoke(MDMSingleSignOn.java:73)


at org.apache.catalina.core.StandardEngineValve.invoke(StandardEn
gineValve.java:109)


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


at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)


at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(H
ttp11Protocol.java:583)


at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)


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

Caused by: java.lang.RuntimeException: Exception occurred during fetch operation


at com.amalto.core.storage.hiber
nate.HibernateStorage.fetch(Unknown Source)


at com.amalto.core.storage.SecuredStorage.fetch(Unknown Source)


... 58 more

Caused by: org.hibernate.exception.SQLGrammarException: could not execute query


at org.hibernate.exception.SQLStateConverter.convert(
SQLStateConverter.java:92)


at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)


at org.hibernate.loader.Loader.doList(Loader.java:2452)


at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2192)


at org.hibernat
e.loader.Loader.list(Loader.java:2187)


at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:119)


at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1706)


at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)


at com.ama
lto.core.storage.hibernate.StandardQueryHandler.visit(Unknown Source)


at com.amalto.core.storage.hibernate.StandardQueryHandler.visit(Unknown Source)


at com.amalto.core.query.user.Select.accept(Unknown Source)


at

com.amalto.core.storage.hibernate.HibernateStorage.internalFetch(Unknown Source)


... 60 more

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 'CONCAT' is not a recognized built
-
in
function name.


at
com.microsoft.sqlserver.jdbc.SQLServerExcept
ion.makeFromDatabaseError(SQLServerException.java:19
6)


at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)


at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPre
paredS
tatement.java:388)


at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPr
eparedStatement.java:338)


at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)


at
com.microsoft.sqlserver.jdbc.SQLServer
Connection.executeCommand(SQLServerConnection.java:1416)


at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)


at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)


at
c
om.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatemen
t.java:281)


at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.j
ava:76)


at org.hibernate.jdbc.AbstractBatcher.getResult
Set(AbstractBatcher.java:208)


at org.hibernate.loader.Loader.getResultSet(Loader.java:1869)


at org.hibernate.loader.Loader.doQuery(Loader.java:718)


at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)


at org.hibernate.
loader.Loader.doList(Loader.java:2449)


... 69 more


at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:19
6)


at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)


at
c
om.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPre
paredStatement.java:388)


at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPr
eparedStatement.java:338)


at com.micros
oft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)


at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)


at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)


at

com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)


at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatemen
t.java:281)


at

com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.j
ava:76)


at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)


at org.hibernate.loader.Loader.getResultSet(Loader.java:1869)


at org.hiberna
te.loader.Loader.doQuery(Loader.java:718)


at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:270)


at org.hibernate.loader.Loader.doList(Loader.java:2449)


... 69 more