Detached missing atttribute on new entity?

eraskin · October 30, 2020, 9:31pm

I know I’m missing something dumb, but here goes:

I have a StandardLookup screen with a Create button. It opens the StandardEditor screen. In that screen, I have an onBeforeShow subscription. It executes the following lines:

thisCustomer = getEditedEntity();

if (thisCustomer.getRtype() != null) {
    .
    .
    .
}

It gives me the following error on the if statement:

IllegalStateException: Cannot get unfetched attribute [rtype] from detached object com.paslists.rade.entity.Customer-177 [detached].

with this stacktrace:

java.lang.IllegalStateException: Cannot get unfetched attribute [rtype] from detached object com.paslists.rade.entity.Customer-177 [detached].
	at org.eclipse.persistence.internal.queries.EntityFetchGroup.onUnfetchedAttribute(EntityFetchGroup.java:100)
	at com.haulmont.cuba.core.sys.persistence.CubaEntityFetchGroup.onUnfetchedAttribute(CubaEntityFetchGroup.java:74)
	at org.eclipse.persistence.internal.jpa.EntityManagerImpl.processUnfetchedAttribute(EntityManagerImpl.java:2998)
	at com.haulmont.chile.core.model.impl.AbstractInstance._persistence_checkFetched(AbstractInstance.java)
	at com.paslists.rade.entity.Customer._persistence_get_rtype(Customer.java)
	at com.paslists.rade.entity.Customer.getRtype(Customer.java:185)
	at com.paslists.rade.web.customer.CustomerEdit.onBeforeShow(CustomerEdit.java:167)
	at com.haulmont.bali.events.EventHub.publish(EventHub.java:170)
	at com.haulmont.cuba.gui.screen.Screen.fireEvent(Screen.java:128)
	at com.haulmont.cuba.gui.screen.UiControllerUtils.fireEvent(UiControllerUtils.java:60)
	at com.haulmont.cuba.web.sys.WebScreens.show(WebScreens.java:444)
	at com.haulmont.cuba.gui.screen.Screen.show(Screen.java:309)
	at com.haulmont.cuba.gui.actions.list.CreateAction.execute(CreateAction.java:345)
	at com.haulmont.cuba.gui.actions.list.CreateAction.actionPerform(CreateAction.java:287)
	at com.haulmont.cuba.web.gui.components.WebButton.buttonClicked(WebButton.java:67)
	at com.haulmont.cuba.web.widgets.CubaButton.fireClick(CubaButton.java:76)
	at com.vaadin.ui.Button$1.click(Button.java:57)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:153)
	at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:115)
	at com.vaadin.server.communication.ServerRpcHandler.handleInvocation(ServerRpcHandler.java:431)
	at com.vaadin.server.communication.ServerRpcHandler.handleInvocations(ServerRpcHandler.java:396)
	at com.vaadin.server.communication.ServerRpcHandler.handleRpc(ServerRpcHandler.java:260)
	at com.vaadin.server.communication.UidlRequestHandler.synchronizedHandleRequest(UidlRequestHandler.java:82)
	at com.vaadin.server.SynchronizedRequestHandler.handleRequest(SynchronizedRequestHandler.java:40)
	at com.vaadin.server.VaadinService.handleRequest(VaadinService.java:1578)
	at com.vaadin.server.VaadinServlet.service(VaadinServlet.java:425)
	at com.haulmont.cuba.web.sys.CubaApplicationServlet.serviceAppRequest(CubaApplicationServlet.java:329)
	at com.haulmont.cuba.web.sys.CubaApplicationServlet.service(CubaApplicationServlet.java:215)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CompositeFilter$VirtualFilterChain.doFilter(CompositeFilter.java:108)
	at org.springframework.web.filter.CompositeFilter.doFilter(CompositeFilter.java:74)
	at com.haulmont.cuba.web.sys.CubaHttpFilter.doFilter(CubaHttpFilter.java:93)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:526)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:678)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1579)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)

My StandardEditor contains this:

  <data>
    <instance id="customerDc" class="com.paslists.rade.entity.Customer" view="customer-edit-view">
      <loader id="customerDl">
        <query>
          <![CDATA[select e from rade$Customer e]]>
          <condition>
            <c:jpql>
              <c:where>e.id = :customer</c:where>
            </c:jpql>
          </condition>
        </query>
      </loader>
    </instance>

customer-edit-view does is based on “_base”, so it contains the rtype field, which is an Enum.

I notice that the entity I get goes from “New” to “Detached” state when I execute the getEditedEntity() call, if that matters.

What am I doing wrong? Why can’t I access the rtype field?

belyaev · November 2, 2020, 7:40am

You always deal with detached entities in screens.
Cannot get unfetched attribute exception happens only if you don’t have the attribute in the view. Please double-check customer-edit-view and ensure that this attribute is included in this view. The screenshot that you have provided doesn’t show the view’s definition. Could you show the view definition, please?

It would be nice if you could provide a minimal example that shows the issue, so we could reproduce it here. It is quite hard to diagnose the problem without seeing a full picture.

eraskin · November 2, 2020, 11:49am

Sure, here is the view. I did see I extended the “_base” view, but just for completeness:

    <view class="com.paslists.rade.entity.Customer" extends="_base" name="customer-edit-view">
        <property name="countrycode" view="_minimal"/>
        <property name="items" view="_minimal">
            <property name="updatedate"/>
            <property name="traynumber"/>
            <property name="pin"/>
            <property name="source"/>
            <property name="sourceId" view="_minimal">
                <property name="mlg" view="_minimal">
                    <property name="maildate"/>
                    <property name="maildesc"/>
                    <property name="offer" view="_minimal">
                        <property name="offerdesc"/>
                    </property>
                </property>
                <property name="lst" view="_minimal"/>
                <property name="seg" view="_minimal">
                    <property name="segcode"/>
                </property>
            </property>
            <property name="purchdate"/>
            <property name="amount"/>
            <property name="currencycode" view="_minimal">
                <property name="currency"/>
            </property>
            <property name="paymentcode"/>
            <property name="refundamt"/>
            <property name="refunddate"/>
            <property name="nsfflag"/>
            <property name="fulfilldate"/>
            <property name="achDate"/>
            <property name="bankRoute"/>
            <property name="bankAccount"/>
            <property name="entrynumber"/>
            <property name="correct1"/>
            <property name="stepid" view="_minimal">
                <property name="gameid">
                    <property name="gamecode"/>
                    <property name="gamedesc"/>
                    <property name="schematicid" view="_minimal">
                        <property name="company" view="_minimal"/>
                    </property>
                </property>
            </property>
            <property name="correct2"/>
            <property name="correct3"/>
            <property name="correct4"/>
            <property name="product"/>
            <property name="whitemail"/>
            <property name="checkNo"/>
            <property name="finalScore"/>
            <property name="altordnum"/>
            <property name="ordersource"/>
            <property name="ordertype"/>
            <property name="shipping"/>
            <property name="continuity"/>
            <property name="lines" view="_minimal">
                <property name="product" view="_minimal">
                    <property name="proddesc"/>
                </property>
                <property name="quantity"/>
                <property name="price"/>
                <property name="linetotal"/>
                <property name="refundamt"/>
                <property name="refunddate"/>
                <property name="sku"/>
                <property name="assemblysku"/>
                <property name="entryDate"/>
            </property>
        </property>
        <property name="suppItems" view="_minimal">
            <property name="customer" view="_minimal"/>
            <property name="offer" view="_minimal"/>
            <property name="offertype"/>
        </property>
        <property name="netplstats" view="_minimal">
            <property name="mlgcount"/>
            <property name="mlgcost"/>
            <property name="ordcost"/>
            <property name="totsales"/>
            <property name="totcost"/>
            <property name="netpl"/>
        </property>
    </view>

belyaev · November 5, 2020, 12:39pm

I don’t see the rtype attribute in the view definition. Is in in the _base view?

Still, is there a possibility to provide a small example?

eraskin · November 5, 2020, 1:59pm

As I understand it, “_base” = “_local” + “_minimal” on all related Entities. In my original post, I showed you a screen shot of the rtype field in the Customer entity.

So, _base should include rtype, shouldn’t it?

As for an example, I am not able to duplicate the problem. It has something to do with my application as it stands, so creating a test case would not help.

That’s what I need help finding. What is wrong in my app? Let me know what else I can post to help figure it out.

modemmisuser · November 5, 2020, 2:20pm

I’ve often found that building a sample app to reproduce a problem to be helpful. Most of the helpers here need it, so they can see the problem “live” and work out a solution.

It’s usually not too hard to build one up. 5-10-15 minutes tops.

eraskin · November 5, 2020, 2:21pm

Here’s a question: When I set up standard default Browse and Editor screens, what view is attached to the entity created by the Create button in the standard action? It seems like it is “_minimal” on my object. Shouldn’t it be the view I defined in my Browse descriptor?

I am seeing the FetchGroup for the created object to be just the items in the Instance Name. That seems to indicate to the system that the other fields are not there. But the object is New (before it is Detached in the screen).

How does the system identify a missing attribute and put up that error message?

eraskin · November 5, 2020, 2:53pm

Here’s a wrinkle that might be affecting things. This is from my Editor XML:

    <instance id="customerDc" class="com.paslists.rade.entity.Customer" view="customer-edit-view">
      <loader id="customerDl">
        <query>
          <![CDATA[select e from rade$Customer e]]>
          <condition>
            <c:jpql>
              <c:where>e.id = :customer</c:where>
            </c:jpql>
          </condition>
        </query>
      </loader>
    </instance>

  public void setCustomerToLoad(Customer customer) {
    customerToLoad = customer;
  }

and

  @Subscribe
  public void onBeforeShow(BeforeShowEvent event) {

    if (customerToLoad != null) {
      customerDl.setParameter("id", customerToLoad.getId());
      customerDl.load();
      thisCustomer = customerDc.getItem();
      setEntityToEdit(thisCustomer);
    } else {
      customerDl.removeParameter("id");
      thisCustomer = getEditedEntity();
    }
    .
    .
    .

There are times when I execute this screen with a requested customer in mind. I call setCustomerToLoad with the entity. In the BeforeShow event, if the requested customer has been provided, I set the parameter in the condition and do a load. If no entity has been provided, I remove the parameter and use the entity provided to the screen by the framework.

Could this be throwing things off? What is the correct way to handle this?

albudarov · November 6, 2020, 8:55am

Which branch of the IF statement is selected when the “Create” action is invoked?

You shouldn’t reload new entity just created by Create action.

eraskin · November 6, 2020, 2:18pm

It does not reload on a Create. We do the “else” part.

eraskin · November 6, 2020, 7:32pm

Well, I finally found it in a very unlikely place. We have a sequence assigning the next ID.

 NamePattern("%s|name")
@Table(name = "CUSTOMERS")
@Entity(name = "rade$Customer")
@IdSequence(name = "CUSTOMERS_SEQ")
@CustomerValidation(groups = {Default.class, UiCrossFieldChecks.class})
public class Customer extends BaseLongIdEntity {

The sequence in the database was wrong, so it was returning IDs of customers that already existed. This completely confused the framework.

Resetting the sequence to the correct value fixed my issue.