Entitätenwizard erzeugt Fehler

Dieses Thema hat 8 Antworten und 6 Teilnehmer, und wurde zuletzt aktualisiert vor 10 Jahre, 12 Monaten von Nuclosian.

Ansicht von 9 Beiträgen - 1 bis 9 (von insgesamt 9)

Autor

Beiträge
Dezember 9, 2011 um 6:01 pm #4657

Jbrennig
Teilnehmer

Hallo,

beim Ändern von bestehenden Entitäten wird folgende Fehlermeldung erzeugt:

org.nuclos.common2.exception.CommonFatalException: executeQuery(SELECT dbo.INTID FROM T_MD_DBOBJECT dbo WHERE (dbo.STRDBOBJECT = ? AND dbo.STRDBOBJECTTYPE = ?)) failed
at org.nuclos.client.masterdata.MetaDataDelegate.createOrModifyEntity(MetaDataDelegate.java:173)
at org.nuclos.client.wizard.steps.NuclosEntitySQLLayoutStep.createOrModifyEntity(NuclosEntitySQLLayoutStep.java:724)
at org.nuclos.client.wizard.steps.NuclosEntitySQLLayoutStep.applyState(NuclosEntitySQLLayoutStep.java:454)
at org.nuclos.client.wizard.NuclosWizardButtonBar$1$1.run(NuclosWizardButtonBar.java:90)
at java.lang.Thread.run(Thread.java:680)
Caused by: org.nuclos.server.dblayer.DbException: executeQuery(SELECT dbo.INTID FROM T_MD_DBOBJECT dbo WHERE (dbo.STRDBOBJECT = ? AND dbo.STRDBOBJECTTYPE = ?)) failed
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.wrapSQLException(StandardSqlDBAccess.java:566)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.executeQuery(StandardSqlDBAccess.java:232)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.executeQuery(StandardSqlDBAccess.java:193)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.executeQuery(StandardSqlDBAccess.java:144)
at org.nuclos.server.dblayer.DbObjectHelper.getUserdefinedEntityView(DbObjectHelper.java:158)
at org.nuclos.server.dblayer.DbObjectHelper.hasUserdefinedEntityView(DbObjectHelper.java:175)
at org.nuclos.server.dblayer.EntityObjectMetaDbHelper.getDbTable(EntityObjectMetaDbHelper.java:246)
at org.nuclos.server.masterdata.ejb3.MetaDataFacadeBean.rollBackDBChanges(MetaDataFacadeBean.java:966)
at org.nuclos.server.masterdata.ejb3.MetaDataFacadeBean.createOrModifyEntity(MetaDataFacadeBean.java:712)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:67)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy17.createOrModifyEntity(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.nuclos.server.common.NuclosRemoteRollbackInterceptor.invoke(NuclosRemoteRollbackInterceptor.java:56)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy65.createOrModifyEntity(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.remoting.support.RemoteInvocation.invoke(RemoteInvocation.java:205)
at org.nuclos.server.common.NuclosRemoteInvocationExecutor.invoke(NuclosRemoteInvocationExecutor.java:57)
at org.springframework.remoting.support.RemoteInvocationBasedExporter.invoke(RemoteInvocationBasedExporter.java:78)
at org.springframework.remoting.support.RemoteInvocationBasedExporter.invokeAndCreateResult(RemoteInvocationBasedExporter.java:114)
at org.springframework.remoting.httpinvoker.HttpInvokerServiceExporter.handleRequest(HttpInvokerServiceExporter.java:73)
at org.springframework.web.servlet.mvc.HttpRequestHandlerAdapter.handle(HttpRequestHandlerAdapter.java:49)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:641)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:304)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:366)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:97)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:100)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:78)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:35)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:177)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:79)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
at org.nuclos.server.security.SessionInvalidationFilter.doFilter(SessionInvalidationFilter.java:76)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:167)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
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:240)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:164)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:462)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:563)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:399)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:317)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:204)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:311)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:680)
at org.springframework.remoting.support.RemoteInvocationUtils.fillInClientStackTraceIfPossible(RemoteInvocationUtils.java:47)
at org.springframework.remoting.support.RemoteInvocationResult.recreate(RemoteInvocationResult.java:115)
at org.springframework.remoting.support.RemoteInvocationBasedAccessor.recreateRemoteInvocationResult(RemoteInvocationBasedAccessor.java:85)
at org.springframework.remoting.httpinvoker.HttpInvokerClientInterceptor.invoke(HttpInvokerClientInterceptor.java:148)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy8.createOrModifyEntity(Unknown Source)
at org.nuclos.client.masterdata.MetaDataDelegate.createOrModifyEntity(MetaDataDelegate.java:170)
… 4 more
Caused by: java.sql.SQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess$2.perform(StandardSqlDBAccess.java:219)
at org.nuclos.server.dblayer.impl.DataSourceExecutor.execute(DataSourceExecutor.java:63)
at org.nuclos.server.dblayer.impl.standard.StandardSqlDBAccess.executeQuery(StandardSqlDBAccess.java:210)
… 100 more

Dezember 9, 2011 um 8:48 pm #4658

Hdengel
Teilnehmer

Hallo,

bei welcher Version von Nuclos paasiert das ? Mit dem aktuellen 3.2.0 Gamma Snapshot habe ich das gleiche Problem. Angelegte Entitäten ( ob mit oder ohne Daten) lassen sich nict mehr ändern.

mfg

Hans

Dezember 10, 2011 um 4:26 pm #4659

Jbrennig
Teilnehmer

Hallo,

ja mit der aktuellen Version 3.2.0.

Gruß Jbrennig

Dezember 10, 2011 um 11:19 pm #4660

Hdengel
Teilnehmer

Hallo,

hab das nochmal reproduziert. der Fehler scheint nicht ganz der gleiche zu sein den ich sehe, hat aber vielleicht den gleichen Grund:
Bei mir gibt es irgendwe ein Problem mit dem Löschen bzw. ändern der View, wenn die Äanderunge abgespeichert weden sollen:

2011-12-10 20:47:19,099 WARN [org.nuclos.server.dblayer.impl.postgresql.PostgreSQLDBAccess] – Restore to savepoint because SQL failed with org.postgresql.util.PSQLException: FEHLER: kann Namen der Sichtspalte »datchanged« nicht in »strchanged« ändern:
CREATE OR REPLACE VIEW knetoss.V_EO_APPLICABLEFEATURETYPE(
INTID,
STRCHANGED,
STRCREATED,
DATCREATED,
INTAFTYPEID,
STRAFTYPENAME,
DATCHANGED,
INTVERSION
) AS SELECT
t.INTID,
t.STRCHANGED,
t.STRCREATED,
t.DATCREATED,
t.INTAFTYPEID,
t.STRAFTYPENAME,
t.DATCHANGED,
t.INTVERSION
FROM
T_EO_APPLICABLEFEATURETYPE t
[]
2011-12-10 20:47:19,148 INFO [org.nuclos.server.masterdata.ejb3.MetaDataFacadeBean] – rollBackDBChanges: org.nuclos.server.dblayer.DbException: execute DbBuildableStatement org.nuclos.server.dblayer.statements.DbStructureChange[type=MODIFY, 1=org.nuclos.server.dblayer.structure.DbSimpleView[table=T_EO_APPLICABLEFEATURETYPE, columns=[org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTID, ref=null, column=INTID], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTAFTYPEID, ref=null, column=INTAFTYPEID], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRAFTYPENAME, ref=null, column=STRAFTYPENAME], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRDESCRIPTION, ref=null, column=STRDESCRIPTION], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=DATCHANGED, ref=null, column=DATCHANGED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRCHANGED, ref=null, column=STRCHANGED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=DATCREATED, ref=null, column=DATCREATED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRCREATED, ref=null, column=STRCREATED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTVERSION, ref=null, column=INTVERSION]]], 2=org.nuclos.server.dblayer.structure.DbSimpleView[table=T_EO_APPLICABLEFEATURETYPE, columns=[org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTID, ref=null, column=INTID], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRCHANGED, ref=null, column=STRCHANGED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRCREATED, ref=null, column=STRCREATED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=DATCREATED, ref=null, column=DATCREATED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTAFTYPEID, ref=null, column=INTAFTYPEID], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRAFTYPENAME, ref=null, column=STRAFTYPENAME], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=DATCHANGED, ref=null, column=DATCHANGED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTVERSION, ref=null, column=INTVERSION]]]] failed: org.postgresql.util.PSQLException: FEHLER: kann Namen der Sichtspalte »datchanged« nicht in »strchanged« ändern

<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

Seltsam, daß da probiert wird »datchanged« in »strchanged« zu ändern.
Bei anderen Entitäten, wurde z.B. auch versucht »datchanged« in »intid_nuclosstate«
zu ändern oder »datchanged« in »strproductname«

<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

2011-12-10 20:20:04,753 WARN [org.nuclos.server.dblayer.impl.postgresql.PostgreSQLDBAccess] – Restore to savepoint because SQL failed with org.postgresql.util.PSQLException: FEHLER: kann Namen der Sichtspalte »datchanged« nicht in »strproductname« ändern:
CREATE OR REPLACE VIEW knetoss.V_EO_PRODUCT(
INTID,
STRPRODUCTNAME,
STRPRODUCTID,
STRDESCRIPTION,
DATVALIDFROM,
DATVALIDTO,
INTID_STRLEVEL,
DATCHANGED,
STRCHANGED,
DATCREATED,
STRCREATED,
STRNUCLOSSYSTEMID,
INTID_NUCLOSPROCESS,
STRNUCLOSORIGIN,
BLNNUCLOSDELETED,
INTID_NUCLOSSTATE,
INTVERSION,
STRVALUE_STRLEVEL,
STRVALUE_NUCLOSPROCESS,
STRVALUE_NUCLOSSTATE,
INTVALUE_NUCLOSSTATE,
OBJVALUE_NUCLOSSTATE
) AS SELECT
t.INTID,
t.STRPRODUCTNAME,
t.STRPRODUCTID,
t.STRDESCRIPTION,
t.DATVALIDFROM,
t.DATVALIDTO,
t.INTID_STRLEVEL,
t.DATCHANGED,
t.STRCHANGED,
t.DATCREATED,
t.STRCREATED,
t.STRNUCLOSSYSTEMID,
t.INTID_NUCLOSPROCESS,
t.STRNUCLOSORIGIN,
t.BLNNUCLOSDELETED,
t.INTID_NUCLOSSTATE,
t.INTVERSION,
CASE WHEN t.INTID_STRLEVEL IS NOT NULL THEN CAST(fk1.STRlevel AS VARCHAR(255)) END,
CASE WHEN t.INTID_NUCLOSPROCESS IS NOT NULL THEN CAST(fk2.STRPROCESS AS VARCHAR(255)) END,
CASE WHEN t.INTID_NUCLOSSTATE IS NOT NULL THEN CAST(fk3.STRSTATE AS VARCHAR(255)) END,
CASE WHEN t.INTID_NUCLOSSTATE IS NOT NULL THEN CAST(fk4.INTNUMERAL AS NUMERIC(3,0)) END,
CASE WHEN t.INTID_NUCLOSSTATE IS NOT NULL THEN CAST(fk5.OBJICON AS BYTEA) END
FROM
T_EO_PRODUCT t
LEFT OUTER JOIN T_EO_PRODUCTLEVEL fk1 ON (t.INTID_STRLEVEL=fk1.INTID)
LEFT OUTER JOIN T_MD_PROCESS fk2 ON (t.INTID_NUCLOSPROCESS=fk2.INTID)
LEFT OUTER JOIN T_MD_STATE fk3 ON (t.INTID_NUCLOSSTATE=fk3.INTID)
LEFT OUTER JOIN T_MD_STATE fk4 ON (t.INTID_NUCLOSSTATE=fk4.INTID)
LEFT OUTER JOIN T_MD_STATE fk5 ON (t.INTID_NUCLOSSTATE=fk5.INTID)
[]
2011-12-10 20:20:04,764 INFO [org.nuclos.server.masterdata.ejb3.MetaDataFacadeBean] – createOrModifyEntity failed: org.nuclos.server.dblayer.DbException: execute DbBuildableStatement org.nuclos.server.dblayer.statements.DbStructureChange[type=MODIFY, 1=org.nuclos.server.dblayer.structure.DbSimpleView[table=T_EO_PRODUCT, columns=[org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTID, ref=null, column=INTID], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTID_NUCLOSSTATE, ref=null, column=INTID_NUCLOSSTATE], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=BLNNUCLOSDELETED, ref=null, column=BLNNUCLOSDELETED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTID_NUCLOSPROCESS, ref=null, column=INTID_NUCLOSPROCESS], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRCHANGED, ref=null, column=STRCHANGED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRCREATED, ref=null, column=STRCREATED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRPRODUCTID, ref=null, column=STRPRODUCTID], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRNUCLOSORIGIN, ref=null, column=STRNUCLOSORIGIN], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRDESCRIPTION, ref=null, column=STRDESCRIPTION], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=DATCREATED, ref=null, column=DATCREATED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=DATVALIDTO, ref=null, column=DATVALIDTO], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRNUCLOSSYSTEMID, ref=null, column=STRNUCLOSSYSTEMID], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=DATVALIDFROM, ref=null, column=DATVALIDFROM], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=DATCHANGED, ref=null, column=DATCHANGED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRPRODUCTNAME, ref=null, column=STRPRODUCTNAME], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTVERSION, ref=null, column=INTVERSION], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=FOREIGN_REFERENCE, column=OBJVALUE_NUCLOSSTATE, ref=org.nuclos.server.dblayer.structure.DbConstraint$DbForeignKeyConstraint[columns=[INTID_NUCLOSSTATE], name=XR_T_EO_PRODUCT_SVQ3LV, refTable=T_MD_STATE, refColumns=[INTID], refConstr=null, onDeleteCascade=false], column=OBJVALUE_NUCLOSSTATE, pattern=[OBJICON]], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=FOREIGN_REFERENCE, column=STRVALUE_NUCLOSSTATE, ref=org.nuclos.server.dblayer.structure.DbConstraint$DbForeignKeyConstraint[columns=[INTID_NUCLOSSTATE], name=XR_T_EO_PRODUCT_SVQ3LV, refTable=T_MD_STATE, refColumns=[INTID], refConstr=null, onDeleteCascade=false], column=STRVALUE_NUCLOSSTATE, pattern=[STRSTATE]], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=FOREIGN_REFERENCE, column=STRVALUE_NUCLOSPROCESS, ref=org.nuclos.server.dblayer.structure.DbConstraint$DbForeignKeyConstraint[columns=[INTID_NUCLOSPROCESS], name=XR_T_EO_PRODUCT_A6QHDL, refTable=T_MD_PROCESS, refColumns=[INTID], refConstr=null, onDeleteCascade=false], column=STRVALUE_NUCLOSPROCESS, pattern=[STRPROCESS]], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=FOREIGN_REFERENCE, column=INTVALUE_NUCLOSSTATE, ref=org.nuclos.server.dblayer.structure.DbConstraint$DbForeignKeyConstraint[columns=[INTID_NUCLOSSTATE], name=XR_T_EO_PRODUCT_SVQ3LV, refTable=T_MD_STATE, refColumns=[INTID], refConstr=null, onDeleteCascade=false], column=INTVALUE_NUCLOSSTATE, pattern=[INTNUMERAL]]]], 2=org.nuclos.server.dblayer.structure.DbSimpleView[table=T_EO_PRODUCT, columns=[org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTID, ref=null, column=INTID], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRPRODUCTNAME, ref=null, column=STRPRODUCTNAME], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRPRODUCTID, ref=null, column=STRPRODUCTID], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRDESCRIPTION, ref=null, column=STRDESCRIPTION], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=DATVALIDFROM, ref=null, column=DATVALIDFROM], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=DATVALIDTO, ref=null, column=DATVALIDTO], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTID_STRLEVEL, ref=null, column=INTID_STRLEVEL], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=DATCHANGED, ref=null, column=DATCHANGED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRCHANGED, ref=null, column=STRCHANGED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=DATCREATED, ref=null, column=DATCREATED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRCREATED, ref=null, column=STRCREATED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRNUCLOSSYSTEMID, ref=null, column=STRNUCLOSSYSTEMID], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTID_NUCLOSPROCESS, ref=null, column=INTID_NUCLOSPROCESS], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRNUCLOSORIGIN, ref=null, column=STRNUCLOSORIGIN], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=BLNNUCLOSDELETED, ref=null, column=BLNNUCLOSDELETED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTID_NUCLOSSTATE, ref=null, column=INTID_NUCLOSSTATE], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTVERSION, ref=null, column=INTVERSION], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=FOREIGN_REFERENCE, column=STRVALUE_STRLEVEL, ref=org.nuclos.server.dblayer.structure.DbConstraint$DbForeignKeyConstraint[columns=[INTID_STRLEVEL], name=XR_T_EO_PRODUCT_FHQFT6, refTable=T_EO_PRODUCTLEVEL, refColumns=[INTID], refConstr=null, onDeleteCascade=false], column=STRVALUE_STRLEVEL, pattern=[STRlevel]], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=FOREIGN_REFERENCE, column=STRVALUE_NUCLOSPROCESS, ref=org.nuclos.server.dblayer.structure.DbConstraint$DbForeignKeyConstraint[columns=[INTID_NUCLOSPROCESS], name=XR_T_EO_PRODUCT_A6QHDL, refTable=T_MD_PROCESS, refColumns=[INTID], refConstr=null, onDeleteCascade=false], column=STRVALUE_NUCLOSPROCESS, pattern=[STRPROCESS]], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=FOREIGN_REFERENCE, column=STRVALUE_NUCLOSSTATE, ref=org.nuclos.server.dblayer.structure.DbConstraint$DbForeignKeyConstraint[columns=[INTID_NUCLOSSTATE], name=XR_T_EO_PRODUCT_SVQ3LV, refTable=T_MD_STATE, refColumns=[INTID], refConstr=null, onDeleteCascade=false], column=STRVALUE_NUCLOSSTATE, pattern=[STRSTATE]], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=FOREIGN_REFERENCE, column=INTVALUE_NUCLOSSTATE, ref=org.nuclos.server.dblayer.structure.DbConstraint$DbForeignKeyConstraint[columns=[INTID_NUCLOSSTATE], name=XR_T_EO_PRODUCT_SVQ3LV, refTable=T_MD_STATE, refColumns=[INTID], refConstr=null, onDeleteCascade=false], column=INTVALUE_NUCLOSSTATE, pattern=[INTNUMERAL]], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=FOREIGN_REFERENCE, column=OBJVALUE_NUCLOSSTATE, ref=org.nuclos.server.dblayer.structure.DbConstraint$DbForeignKeyConstraint[columns=[INTID_NUCLOSSTATE], name=XR_T_EO_PRODUCT_SVQ3LV, refTable=T_MD_STATE, refColumns=[INTID], refConstr=null, onDeleteCascade=false], column=OBJVALUE_NUCLOSSTATE, pattern=[OBJICON]]]]] failed: org.postgresql.util.PSQLException: FEHLER: kann Namen der Sichtspalte »datchanged« nicht in »strproductname« ändern

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

2011-12-10 20:20:05,005 WARN [org.nuclos.server.dblayer.impl.postgresql.PostgreSQLDBAccess] – Restore to savepoint because SQL failed with org.postgresql.util.PSQLException: FEHLER: kann Namen der Sichtspalte »datchanged« nicht in »intid_nuclosstate« ändern:
CREATE OR REPLACE VIEW knetoss.V_EO_PRODUCT(
INTID,
INTID_NUCLOSSTATE,
BLNNUCLOSDELETED,
INTID_NUCLOSPROCESS,
STRCHANGED,
STRCREATED,
STRPRODUCTID,
STRNUCLOSORIGIN,
STRDESCRIPTION,
DATCREATED,
DATVALIDTO,
STRNUCLOSSYSTEMID,
DATVALIDFROM,
DATCHANGED,
STRPRODUCTNAME,
INTVERSION,
OBJVALUE_NUCLOSSTATE,
STRVALUE_NUCLOSSTATE,
STRVALUE_NUCLOSPROCESS,
INTVALUE_NUCLOSSTATE
) AS SELECT
t.INTID,
t.INTID_NUCLOSSTATE,
t.BLNNUCLOSDELETED,
t.INTID_NUCLOSPROCESS,
t.STRCHANGED,
t.STRCREATED,
t.STRPRODUCTID,
t.STRNUCLOSORIGIN,
t.STRDESCRIPTION,
t.DATCREATED,
t.DATVALIDTO,
t.STRNUCLOSSYSTEMID,
t.DATVALIDFROM,
t.DATCHANGED,
t.STRPRODUCTNAME,
t.INTVERSION,
CASE WHEN t.INTID_NUCLOSSTATE IS NOT NULL THEN CAST(fk1.OBJICON AS BYTEA) END,
CASE WHEN t.INTID_NUCLOSSTATE IS NOT NULL THEN CAST(fk2.STRSTATE AS VARCHAR(255)) END,
CASE WHEN t.INTID_NUCLOSPROCESS IS NOT NULL THEN CAST(fk3.STRPROCESS AS VARCHAR(255)) END,
CASE WHEN t.INTID_NUCLOSSTATE IS NOT NULL THEN CAST(fk4.INTNUMERAL AS NUMERIC(3,0)) END
FROM
T_EO_PRODUCT t
LEFT OUTER JOIN T_MD_STATE fk1 ON (t.INTID_NUCLOSSTATE=fk1.INTID)
LEFT OUTER JOIN T_MD_STATE fk2 ON (t.INTID_NUCLOSSTATE=fk2.INTID)
LEFT OUTER JOIN T_MD_PROCESS fk3 ON (t.INTID_NUCLOSPROCESS=fk3.INTID)
LEFT OUTER JOIN T_MD_STATE fk4 ON (t.INTID_NUCLOSSTATE=fk4.INTID)
[]
2011-12-10 20:20:05,012 INFO [org.nuclos.server.masterdata.ejb3.MetaDataFacadeBean] – rollBackDBChanges: org.nuclos.server.dblayer.DbException: execute DbBuildableStatement org.nuclos.server.dblayer.statements.DbStructureChange[type=MODIFY, 1=org.nuclos.server.dblayer.structure.DbSimpleView[table=T_EO_PRODUCT, columns=[org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTID, ref=null, column=INTID], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRPRODUCTNAME, ref=null, column=STRPRODUCTNAME], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRPRODUCTID, ref=null, column=STRPRODUCTID], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRDESCRIPTION, ref=null, column=STRDESCRIPTION], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=DATVALIDFROM, ref=null, column=DATVALIDFROM], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=DATVALIDTO, ref=null, column=DATVALIDTO], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTID_STRLEVEL, ref=null, column=INTID_STRLEVEL], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=DATCHANGED, ref=null, column=DATCHANGED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRCHANGED, ref=null, column=STRCHANGED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=DATCREATED, ref=null, column=DATCREATED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRCREATED, ref=null, column=STRCREATED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRNUCLOSSYSTEMID, ref=null, column=STRNUCLOSSYSTEMID], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTID_NUCLOSPROCESS, ref=null, column=INTID_NUCLOSPROCESS], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRNUCLOSORIGIN, ref=null, column=STRNUCLOSORIGIN], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=BLNNUCLOSDELETED, ref=null, column=BLNNUCLOSDELETED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTID_NUCLOSSTATE, ref=null, column=INTID_NUCLOSSTATE], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTVERSION, ref=null, column=INTVERSION], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=FOREIGN_REFERENCE, column=STRVALUE_STRLEVEL, ref=org.nuclos.server.dblayer.structure.DbConstraint$DbForeignKeyConstraint[columns=[INTID_STRLEVEL], name=XR_T_EO_PRODUCT_FHQFT6, refTable=T_EO_PRODUCTLEVEL, refColumns=[INTID], refConstr=null, onDeleteCascade=false], column=STRVALUE_STRLEVEL, pattern=[STRlevel]], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=FOREIGN_REFERENCE, column=STRVALUE_NUCLOSPROCESS, ref=org.nuclos.server.dblayer.structure.DbConstraint$DbForeignKeyConstraint[columns=[INTID_NUCLOSPROCESS], name=XR_T_EO_PRODUCT_A6QHDL, refTable=T_MD_PROCESS, refColumns=[INTID], refConstr=null, onDeleteCascade=false], column=STRVALUE_NUCLOSPROCESS, pattern=[STRPROCESS]], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=FOREIGN_REFERENCE, column=STRVALUE_NUCLOSSTATE, ref=org.nuclos.server.dblayer.structure.DbConstraint$DbForeignKeyConstraint[columns=[INTID_NUCLOSSTATE], name=XR_T_EO_PRODUCT_SVQ3LV, refTable=T_MD_STATE, refColumns=[INTID], refConstr=null, onDeleteCascade=false], column=STRVALUE_NUCLOSSTATE, pattern=[STRSTATE]], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=FOREIGN_REFERENCE, column=INTVALUE_NUCLOSSTATE, ref=org.nuclos.server.dblayer.structure.DbConstraint$DbForeignKeyConstraint[columns=[INTID_NUCLOSSTATE], name=XR_T_EO_PRODUCT_SVQ3LV, refTable=T_MD_STATE, refColumns=[INTID], refConstr=null, onDeleteCascade=false], column=INTVALUE_NUCLOSSTATE, pattern=[INTNUMERAL]], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=FOREIGN_REFERENCE, column=OBJVALUE_NUCLOSSTATE, ref=org.nuclos.server.dblayer.structure.DbConstraint$DbForeignKeyConstraint[columns=[INTID_NUCLOSSTATE], name=XR_T_EO_PRODUCT_SVQ3LV, refTable=T_MD_STATE, refColumns=[INTID], refConstr=null, onDeleteCascade=false], column=OBJVALUE_NUCLOSSTATE, pattern=[OBJICON]]]], 2=org.nuclos.server.dblayer.structure.DbSimpleView[table=T_EO_PRODUCT, columns=[org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTID, ref=null, column=INTID], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTID_NUCLOSSTATE, ref=null, column=INTID_NUCLOSSTATE], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=BLNNUCLOSDELETED, ref=null, column=BLNNUCLOSDELETED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTID_NUCLOSPROCESS, ref=null, column=INTID_NUCLOSPROCESS], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRCHANGED, ref=null, column=STRCHANGED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRCREATED, ref=null, column=STRCREATED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRPRODUCTID, ref=null, column=STRPRODUCTID], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRNUCLOSORIGIN, ref=null, column=STRNUCLOSORIGIN], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRDESCRIPTION, ref=null, column=STRDESCRIPTION], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=DATCREATED, ref=null, column=DATCREATED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=DATVALIDTO, ref=null, column=DATVALIDTO], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRNUCLOSSYSTEMID, ref=null, column=STRNUCLOSSYSTEMID], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=DATVALIDFROM, ref=null, column=DATVALIDFROM], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=DATCHANGED, ref=null, column=DATCHANGED], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=STRPRODUCTNAME, ref=null, column=STRPRODUCTNAME], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=TABLE, column=INTVERSION, ref=null, column=INTVERSION], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=FOREIGN_REFERENCE, column=OBJVALUE_NUCLOSSTATE, ref=org.nuclos.server.dblayer.structure.DbConstraint$DbForeignKeyConstraint[columns=[INTID_NUCLOSSTATE], name=XR_T_EO_PRODUCT_SVQ3LV, refTable=T_MD_STATE, refColumns=[INTID], refConstr=null, onDeleteCascade=false], column=OBJVALUE_NUCLOSSTATE, pattern=[OBJICON]], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=FOREIGN_REFERENCE, column=STRVALUE_NUCLOSSTATE, ref=org.nuclos.server.dblayer.structure.DbConstraint$DbForeignKeyConstraint[columns=[INTID_NUCLOSSTATE], name=XR_T_EO_PRODUCT_SVQ3LV, refTable=T_MD_STATE, refColumns=[INTID], refConstr=null, onDeleteCascade=false], column=STRVALUE_NUCLOSSTATE, pattern=[STRSTATE]], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=FOREIGN_REFERENCE, column=STRVALUE_NUCLOSPROCESS, ref=org.nuclos.server.dblayer.structure.DbConstraint$DbForeignKeyConstraint[columns=[INTID_NUCLOSPROCESS], name=XR_T_EO_PRODUCT_A6QHDL, refTable=T_MD_PROCESS, refColumns=[INTID], refConstr=null, onDeleteCascade=false], column=STRVALUE_NUCLOSPROCESS, pattern=[STRPROCESS]], org.nuclos.server.dblayer.structure.DbSimpleView$DbSimpleViewColumn[type=FOREIGN_REFERENCE, column=INTVALUE_NUCLOSSTATE, ref=org.nuclos.server.dblayer.structure.DbConstraint$DbForeignKeyConstraint[columns=[INTID_NUCLOSSTATE], name=XR_T_EO_PRODUCT_SVQ3LV, refTable=T_MD_STATE, refColumns=[INTID], refConstr=null, onDeleteCascade=false], column=INTVALUE_NUCLOSSTATE, pattern=[INTNUMERAL]]]]] failed: org.postgresql.util.PSQLException: FEHLER: kann Namen der Sichtspalte »datchanged« nicht in »intid_nuclosstate« ändern

Gruss Hans

Dezember 13, 2011 um 1:57 pm #4672

Aanno
Teilnehmer

Hallo Hans/hdengel und jbrennig,

bei deinem Problem kann ich sicher sagen, dass dies auf dem 3.2 Branch aufgetreten ist. Wahrscheinlich freut es dich zu hören, dass ich die Schwierigkeit mittlerweile behoben habe.

Der Fehler von jbrennig ist dagegen schwieriger einzuschätzen, da der Grund, warum

SELECT dbo.INTID FROM T_MD_DBOBJECT dbo WHERE (dbo.STRDBOBJECT = ? AND dbo.STRDBOBJECTTYPE = ?)

nicht ausgeführt werden kann, leider nicht mitprotokolliert ist.

Vielleicht kannst du das Select mal direkt auf der DB ausführen? Was sagt die dann?

Mit besten Grüßen

aanno

Dezember 13, 2011 um 3:20 pm #4674

Jbrennig
Teilnehmer

Hallo aanno,

hier das SQL-Statement im Anhang.
Das geht.

Dezember 15, 2011 um 10:15 pm #4686

Th-connect
Teilnehmer

Hallo,

selbes Problem bei mir. Zuerst dachte ich es liegt an den übernommenen Entitäten, jedoch tritt das Problem auch mit einer neuen DB + neuen Entitäten auf.

Gruß
Thomas

Dezember 16, 2011 um 4:16 pm #4688

Martin69
Teilnehmer

Ich habe 2 Systeme und beim Verhalten sowohl als auch.
Ein geupdatetes Projekt aus 3.1.3 auf 3.2 Beta funktioniert,
ein neues Projekt meldet beim Bearbeiten der Entitäte die gleichen Fehler.
Vielleicht nützt es etwas beim Fehlersuchen

Gruss Martin

Dezember 16, 2011 um 4:25 pm #4689

Nuclosian
Teilnehmer

Hallo,

ist bereits behoben und mit nächstem Update des Downloadbereiches (Montag) verfügbar

Grüsse,
nuclosian
Autor

Beiträge

Ansicht von 9 Beiträgen - 1 bis 9 (von insgesamt 9)

Du musst angemeldet sein, um auf dieses Thema antworten zu können.