You are right, "target" is nullable. With respect to DB schema changes, just to say that there is now an IsisAddons integration with flyway [1] which means that ISIS-1471 [2] is closed off.
Thx Dan [1] https://github.com/isisaddons/isis-module-flywaydb [2] https://issues.apache.org/jira/browse/ISIS-1471 On Wed, 30 Nov 2016 at 15:30 Erik de Hair <[email protected]> wrote: > Ahah, column 'target' can be null in the mean time (I believe this > wasn't the case a while ago?). I just have to change the nullable > property in the database... It is explicitly set to null for view models. > > > On 11/30/2016 04:23 PM, Erik de Hair wrote: > > Hi, > > > > I'm getting following error when our application is trying to persist > > a command (finish() action on view model > > nl.pocos.dom.access.kpn.wba.order.WbaFiberOrderForm).It is not > > neccessary to persist the command so I tried so suppress that by adding: > > > > @Action(commandPersistence = CommandPersistence.NOT_PERSISTED, > > publishing = Publishing.DISABLED, command = CommandReification.DISABLED) > > public AbstractEndUserAccessSubscription finish(){ .. } > > > > The application is still trying to persist the command. Is there any > > way to suppress persisting the command or fix the target-exception? > > > > 16:13:20,587 [Native qtp1430439149-19 DEBUG] INSERT > > INTO Command > > > (arguments,completedAt,`exception`,executeIn,memberIdentifier,memento,parentTransactionId,`result`,startedAt,targetAction,targetClass,target,`timestamp`,`user`,transactionId) > > VALUES (<''>,<2016-11-30 > > > 16:13:19.926>,<null>,<'FOREGROUND'>,<'nl.pocos.dom.access.kpn.wba.order.WbaFiberOrderForm#finish()'>,<'<?xml > > version="1.0" encoding="UTF-8" standalone="yes"?> > > <cmd:commandDto xmlns:com="http://isis.apache.org/schema/common"; > > xmlns:cmd="http://isis.apache.org/schema/cmd";> > > <cmd:majorVersion>1</cmd:majorVersion> > > <cmd:minorVersion>0</cmd:minorVersion> > > > <cmd:transactionId>95d7f2e0-566a-4c3c-a800-856a7f3d9bcb</cmd:transactionId> > > > > <cmd:targets> > > <com:oid objectState="viewModel" > > type="nl.pocos.dom.access.kpn.wba.order.WbaFiberOrderForm" > > > id="PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPG1lbWVudG8-PGN1c3RvbWVyLmJvb2ttYXJrPm5sLnBvY29zLmRvbS5jb21wYW55LlBvcnRhbENvbXBhbnk6aV8xMDM8L2N1c3RvbWVyLmJvb2ttYXJrPjxjb25uZWN0aW9uQXJ0aWNsZS5ib29rbWFyaz5ubC5wb2Nvcy5kb20uYXJ0aWNsZS5BYnN0cmFjdEFydGljbGU6aV8xMzgxPC9jb25uZWN0aW9uQXJ0aWNsZS5ib29rbWFyaz48Y3VzdG9tZXJSZWZlcmVuY2U-bDtrbDtrbDs8L2N1c3RvbWVyUmVmZXJlbmNlPjx0ZWNobm9sb2d5SW1wbD5GdHRIPC90ZWNobm9sb2d5SW1wbD48cG9ydGZvbGlvPkRMTTwvcG9ydGZvbGlvPjxzdGF0ZT5TVU1NQVJZX1BBR0U8L3N0YXRlPjxuYXQ-ZmFsc2U8L25hdD48YXJ0aWWeWMybHZiajBpTVM0d0lpQmxibU52WkdsdVp6MGlWVlJHTFRnaVB6NEtQRzFsYldWdWRHOC1QR2h2ZFhObFRuVnRZbVZ5UGpFMU1qd3ZhRzkxYzJWT2RXMWlaWEktUEhKbGMybGtaVzVqWlQ1RlNVNUVTRTlXUlU0OEwzSmxjMmxrWlc1alpUNDhjM1J5WldWMFBrZEZURVJTVDFCVFJWZEhQQzl6ZEhKbFpYUS1QSHBwY0VOdlpHVS1OVFl4TkVGRlBDOTZhWEJEYjJSbFBqd3ZiV1Z0Wlc1MGJ6ND08L2Nvbm5lY3Rpb25BZGRyZXNzLmJvb2ttYXJrPjxjbGFzc09mU2VydmljZVBDPlN0YW5kYXJkPC9jbGFzc09mU2VydmljZVBDPjx0ZWNobm9sb2d5PkZ0dEg8L3RlY2hub2xvZ3k-PGNvbm5lY3Rpb25Qb2ludERldGFpbHM-W3siY3VycmVudE9kZkFjY2Vzc1NlcnZpY2VJZCI6IlJFRjAwMDE5NzkxMjQiLCJmdXR1cmVPZGZBY2Nlc3NTZXJ2aWNlSWQiOiIiLCJjb25uZWN0aW9uVHlwZXMiOnsiMCI6Ik5vdCBpbiB1c2UiLCIxIjoiRml4ZWQgbGluZSBzZXJ2aWNlIiwiMiI6IlRlbGVwaG9ueSBzZXJ2aWNlIiwiMyI6Ik1ERiBicm9hZGJhbmQgc2VydmljZSIsIjQiOiJTREYgYnJvYWRiYW5kIHNlcnZpY2UiLCI1IjoiT0RGIGJyb2FkYmFuZCBzZXJ2aWNlIiwiNiI6Ik9ERiBicm9hZGJhbmQgc2VydmljZSBibG9ja2VkIiwiNyI6Ik9ERiBicm9hZGJhbmQgc2VydmljZSBkZWZlY3QiLCI4IjoiVW5rbm93biBzZXJ2aWNlIiwiOSI6Ik5vIGNoYW5nZSIsIjEwIjoiTURGIEJ1bmRsZSIsIjExIjoiU0RGIEJ1bmRsZSJ9LCJjdXJyZW50VHlwZU9mQ29ubmVjdGlvbiI6IjUiLCJmdXR1cmVUeXBlT2ZDb25uZWN0aW9uIjoiOSJ9XTwvY29ubmVjdGlvblBvaW50RGV0YWlscz48bWF4TmxzVHlwZT44PC9tYXhObHNUeXBlPjx3aXNoRGF0ZT4yMDE2LTEyLTE0PC93aXNoRGF0ZT48b3JkZXJTY2VuYXJpbz5OZXdfTGluZTwvb3JkZXJTY2VuYXJpbz48c2VydmljZUxldmVsPkJFU1RfRUZGT1JUPC9zZXJ2aWNlTGV2ZWw-PGNvbm5lY3Rpb25BZGRyZXNzQ29udGFjdE5hbWU-bDtrbDtrPC9jb25uZWN0aW9uQWRkcmVzc0NvbnRhY3ROYW1lPjxjb25uZWN0aW9uQWRkcmVzc0NvbnRhY3RQaG9uZT4rMzE0MjEyMzQ4NzU8L2Nvbm5lY3Rpb25BZGRyZXNzQ29udGFjdFBob25lPjx1bnRhZ2dlZD50cnVlPC91bnRhZ2dlZD48dm9pY2VQcmlvcml0eVBDPmZhbHNlPC92b2ljZVByaW9yaXR5UEM-PHZvaWNlUHJpb3JpdHlBQz5mYWxzZTwvdm9pY2VQcmlvcml0eUFDPjxpbnN0YWxsU2VydmljZT5mYWxzZTwvaW5zdGFsbFNlcnZpY2U-PGJpdHJhdGVEb3duPjUyNDAwMC4wPC9iaXRyYXRlRG93bj48Yml0cmF0ZVVwPjUyNDAwMC4wPC9iaXRyYXRlVXA-PGZ0dUF0Q29ubmVjdGlvbkFkZHJlc3M-RlRVX1RZMDE8L2Z0dUF0Q29ubmVjdGlvbkFkZHJlc3M-PC9tZW1lbnRvPg=="/> > > </cmd:targets> > > <cmd:member xsi:type="cmd:actionDto" > > interactionType="action_invocation" > > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";> > > > <cmd:memberIdentifier>nl.pocos.dom.access.kpn.wba.order.WbaFiberOrderForm#finish()</cmd:memberIdentifier> > > > > </cmd:member> > > </cmd:commandDto> > > > '>,<null>,<'nl.pocos.dom.subscription.access.kpn.wba.WbaEndUserAccessSubscription:i_20448'>,<2016-11-30 > > 16:13:19.575>,<'Afronden'>,<'Wba Fiber Order Form'>,<null>,<2016-11-30 > > 16:13:19.556>,<'erikdehair'>,<'63ec2bd9-2284-4a74-ad76-16e5aae8b90e'>) > > 16:13:20,603 [Persist qtp1430439149-19 WARN ] Insert of > > object "org.isisaddons.module.command.dom.CommandJdo@2d1a178f" using > > statement "INSERT INTO Command > > > (arguments,completedAt,`exception`,executeIn,memberIdentifier,memento,parentTransactionId,`result`,startedAt,targetAction,targetClass,target,`timestamp`,`user`,transactionId) > > VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" failed : Column 'target' > > cannot be null > > 16:13:20,603 [Persist qtp1430439149-19 WARN ] Insert of > > object "org.isisaddons.module.command.dom.CommandJdo@2d1a178f" using > > statement "INSERT INTO Command > > > (arguments,completedAt,`exception`,executeIn,memberIdentifier,memento,parentTransactionId,`result`,startedAt,targetAction,targetClass,target,`timestamp`,`user`,transactionId) > > VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" failed : Column 'target' > > cannot be null > > 16:13:20,603 [Persist qtp1430439149-19 WARN ] Insert of > > object "org.isisaddons.module.command.dom.CommandJdo@2d1a178f" using > > statement "INSERT INTO Command > > > (arguments,completedAt,`exception`,executeIn,memberIdentifier,memento,parentTransactionId,`result`,startedAt,targetAction,targetClass,target,`timestamp`,`user`,transactionId) > > VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" failed : Column 'target' > > cannot be null > > 16:13:20,605 [IsisTransaction qtp1430439149-19 INFO ] abort > > transaction IsisTransaction@3ac9a331[state=MUST_ABORT,commands=0] > > 16:13:20,606 [IsisTransaction qtp1430439149-19 INFO ] abort > > transaction IsisTransaction@3ac9a331[state=ABORTED,commands=0] > > 16:13:20,606 [RequestCycle qtp1430439149-19 ERROR] Exception > > occurred during onEndRequest > > javax.jdo.JDODataStoreException: Insert of object > > "org.isisaddons.module.command.dom.CommandJdo@2d1a178f" using > > statement "INSERT INTO Command > > > (arguments,completedAt,`exception`,executeIn,memberIdentifier,memento,parentTransactionId,`result`,startedAt,targetAction,targetClass,target,`timestamp`,`user`,transactionId) > > VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)" failed : Column 'target' > > cannot be null > > at > > > org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:543) > > at > > > org.datanucleus.api.jdo.JDOPersistenceManager.jdoMakePersistent(JDOPersistenceManager.java:725) > > at > > > org.datanucleus.api.jdo.JDOPersistenceManager.makePersistent(JDOPersistenceManager.java:745) > > at > > > org.apache.isis.objectstore.jdo.datanucleus.persistence.commands.DataNucleusCreateObjectCommand.execute(DataNucleusCreateObjectCommand.java:54) > > at > > > org.apache.isis.core.runtime.system.persistence.PersistenceSession.executeCommands(PersistenceSession.java:1253) > > at > > > org.apache.isis.core.runtime.system.persistence.PersistenceSession.execute(PersistenceSession.java:1247) > > at > > > org.apache.isis.core.runtime.system.transaction.IsisTransaction.doFlush(IsisTransaction.java:378) > > at > > > org.apache.isis.core.runtime.system.transaction.IsisTransaction.preCommit(IsisTransaction.java:419) > > at > > > org.apache.isis.core.runtime.system.transaction.IsisTransactionManager.endTransactionInternal(IsisTransactionManager.java:379) > > at > > > org.apache.isis.core.runtime.system.transaction.IsisTransactionManager.endTransaction(IsisTransactionManager.java:316) > > at > > > org.apache.isis.core.runtime.system.transaction.IsisTransactionManager.executeWithinTransaction(IsisTransactionManager.java:146) > > at > > > org.apache.isis.core.runtime.system.transaction.IsisTransactionManager.executeWithinTransaction(IsisTransactionManager.java:134) > > at > > > org.apache.isis.core.runtime.system.persistence.PersistenceSession.makePersistentInTransaction(PersistenceSession.java:1102) > > at > > > org.apache.isis.core.runtime.services.persistsession.PersistenceSessionServiceInternalDefault.makePersistent(PersistenceSessionServiceInternalDefault.java:83) > > at > > > org.apache.isis.core.metamodel.services.repository.RepositoryServiceInternalDefault.persist(RepositoryServiceInternalDefault.java:96) > > at > > > org.isisaddons.module.command.dom.CommandServiceJdo.complete(CommandServiceJdo.java:97) > > at > > > org.apache.isis.core.runtime.system.persistence.PersistenceSession.completeCommandFromInteractionAndClearDomainEvents(PersistenceSession.java:516) > > at > > > org.apache.isis.core.runtime.system.persistence.PersistenceSession.close(PersistenceSession.java:414) > > at > > > org.apache.isis.core.runtime.system.session.IsisSession.close(IsisSession.java:69) > > at > > > org.apache.isis.core.runtime.system.session.IsisSessionFactory.closeSession(IsisSessionFactory.java:269) > > at > > > org.apache.isis.viewer.wicket.viewer.integration.wicket.WebRequestCycleForIsis.onEndRequest(WebRequestCycleFo > > > > Thanks, > > Erik > > > > >
