Pre-selecting users in a reference attribute

RLJB

Hello

I have a BO (called Comments) with a reference attribute (called RegularUserLINK) to the RegularUser BO (which has a matching attribute called CommentsLINK)

I have a form in Comments BO that displays the RegularUserLINK reference attribute as a table. When I create a new instance in the Comment BO it defaults to having the reference table blank i.e. no users are chosen. BUT I would like the reference attribute to pre-select certain users based on a query, i.e. so they appear in the table already.

I have tried this rule (both in the Comment BO and as part of a separate process):

FIND RegularUser WHERE (RegularUser.CommentsLINK.RelatedID=Comments.RelatedID)
INSERT RegularUser IN Comments.RegularUserLINK

If I set it to run during initialisation of Comment then I get an Internal Error. If it's not used during initialisation then nothing happens (ie the users don't get pre-selected as we wish).

I have reviewed the logs and the FIND part of the rule appears to be working (ie it finds the correct number of users as I would suspect).

Can anyone provide any hints on using INSERT, and what I'm doing wrong?

Thanks

Rod.

aware_support

What is the output of Tomcat and Aware IM Server when you are getting the internal error?

RLJB

Outputs are as follows:

AwareIM Server Output:

2010-03-24 10:19:43,247 q#admin -15 Executing action Comments.RelatedID='1' from rules of object Comments

2010-03-24 10:19:43,247 q#admin -4 RelatedID=1

2010-03-24 10:19:43,252 q#admin -16 Finished executing action Comments.RelatedID='1' from rules of object Comments

2010-03-24 10:19:43,257 q#admin -15 Executing action FIND RegularUser WHERE RegularUser.CommentsLINK.RelatedID=Comments.RelatedID from rules of object Comments

2010-03-24 10:19:43,263 q#admin -33 Found 2 objects

2010-03-24 10:19:43,264 q#admin -16 Finished executing action FIND RegularUser WHERE RegularUser.CommentsLINK.RelatedID=Comments.RelatedID from rules of object Comments

2010-03-24 10:19:43,264 q#admin -15 Executing action INSERT RegularUser IN Comments.RegularUserLINK from rules of object Comments

com.bas.basserver.executionengine.ExecutionException: Internal error.

at com.bas.basserver.executionengine.ExecutionEngine.a(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.startChildProcess(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.a(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.a(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.addReferences(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.addReferences(Unknown Source)
at com.bas.basserver.executionengine.a.d.try(Unknown Source)
at com.bas.basserver.executionengine.a.d.do(Unknown Source)
at com.bas.basserver.executionengine.a.d.d(Unknown Source)
at com.bas.basserver.executionengine.a.d.else(Unknown Source)
at com.bas.basserver.executionengine.a.d.byte(Unknown Source)
at com.bas.basserver.executionengine.a.f.a(Unknown Source)
at com.bas.basserver.executionengine.a.f.if(Unknown Source)
at com.bas.basserver.executionengine.a.f.d(Unknown Source)
at com.bas.basserver.executionengine.a.f.a(Unknown Source)
at com.bas.basserver.executionengine.a.f.execute(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.a(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.startChildProcess(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.a(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.doRecalculateObject(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.calculateInitialValues(Unknown Source)
at com.bas.basserver.executionengine.a.k.a(Unknown Source)
at com.bas.basserver.executionengine.a.k.if(Unknown Source)
at com.bas.basserver.executionengine.a.k.a(Unknown Source)
at com.bas.basserver.executionengine.a.d.new(Unknown Source)
at com.bas.basserver.executionengine.a.d.else(Unknown Source)
at com.bas.basserver.executionengine.a.d.byte(Unknown Source)
at com.bas.basserver.executionengine.a.f.a(Unknown Source)
at com.bas.basserver.executionengine.a.f.if(Unknown Source)
at com.bas.basserver.executionengine.a.f.d(Unknown Source)
at com.bas.basserver.executionengine.a.f.a(Unknown Source)
at com.bas.basserver.executionengine.a.f.a(Unknown Source)
at com.bas.basserver.executionengine.a.f.execute(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.a(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.a(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.a(Unknown Source)
at com.bas.basserver.executionengine.ExecutionEngine.executeProcess(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.bas.basserver.bsmanager.f.if(Unknown Source)
at com.bas.basserver.bsmanager.f.a(Unknown Source)
at com.bas.basserver.bsmanager.f.a(Unknown Source)
at com.bas.basserver.iopipes.ComponentSink.processMessage(Unknown Source)
at org.openadaptor.adaptor.STPipelineController.processMessage(Unknown Source)
at com.bas.openadaptor.NonTransactionalController.processMessage(Unknown Source)
at org.openadaptor.adaptor.AbstractSimplePipe.processMessage(Unknown Source)
at org.openadaptor.adaptor.STPipelineController.processMessage(Unknown Source)
at com.bas.openadaptor.NonTransactionalController.processMessage(Unknown Source)
at org.openadaptor.adaptor.AbstractSimpleSource.processMessage(Unknown Source)
at org.openadaptor.adaptor.AbstractSimpleSource.sourceProcess(Unknown Source)
at org.openadaptor.adaptor.AbstractSimpleSource.sourceProcess(Unknown Source)
at com.bas.openadaptor.a$a.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

2010-03-24 10:19:43,298 q#admin -16 Finished executing action INSERT RegularUser IN Comments.RegularUserLINK from rules of object Comments

2010-03-24 10:19:43,304 q#admin -25 Started evaluation of rules after data has been changed by the actions

2010-03-24 10:19:43,304 q#admin -6 Checking rule blurgh

2010-03-24 10:19:43,562 q#admin -6 Checking rule Autoincrement CommentID

2010-03-24 10:19:43,562 q#admin -6 Checking rule set he variable

2010-03-24 10:19:43,563 q#admin -6 Checking rule send the mails

2010-03-24 10:19:43,564 q#admin -6 Checking rule Initial value for Comments.RelatedID

2010-03-24 10:19:43,564 q#admin -3 Removing action Comments.RelatedID=1 from the agenda because the rule condition no longer holds

2010-03-24 10:19:43,565 q#admin -6 Evaluating condition Comments.RelatedID IS UNDEFINED

2010-03-24 10:19:43,565 q#admin -7 Condition evaluated to false: 1

2010-03-24 10:19:43,566 q#admin -6 Checking rule Choice list for Comments.Category

2010-03-24 10:19:43,567 q#admin -16 Finished evaluation of rules after data has been changed by the actions

2010-03-24 10:19:43,573 q#admin -16 Finished calculating initial values for business object Comments

2010-03-24 10:19:43,574 q#admin -Exception while executing method ENTER NEW Exception class=com.bas.basserver.executionengine.ExecutionException message Internal error.

2010-03-24 10:19:43,574 q#admin -16 Finished executing action ENTER NEW Comments

2010-03-24 10:19:43,575 ERROR q#admin -Execution Exception after starting process NewSMSComment message Internal error.

2010-03-24 10:19:43,575 q#admin -18 Process NewSMSComment has failed

2010-03-24 10:19:43,577 q#admin -17

Tomcat Output:

Got XML request <root><start_process_action process_name="NewSMSComment" ><object_reference object_name="SMSCampaigns" object_id="38063" />
</start_process_action></root>
Calling BAS server
Exception thrown com.bas.connectionserver.server.d Internal error.
com.bas.connectionserver.server.d: Internal error.
at com.bas.connectionserver.server.ConnectionFactory.sendMessage(Unknown Source)
at com.bas.webapp.common.WebAppUtils.sendMessageToExecutionEngine(Unknown Source)
at com.bas.webapp.thin.misc.f.a(Unknown Source)
at com.bas.webapp.thin.a.d.c.a(Unknown Source)
at com.bas.webapp.thin.a.c.a(Unknown Source)
at com.bas.webapp.thin.a.c.a(Unknown Source)
at com.bas.webapp.thin.servlets.WebInterfaceServlet.doPost(Unknown Source)
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:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188-)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108-)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528-)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.lang.Thread.run(Unknown Source)

aware_support

Seems like your INSERT action used during initialisation causes ENTER NEW action to fire. This is an extremely bad design. Check the LogViewer and see what's happening there. Also please examine LogViewer output carefully before posting messages to the forum - a lot of problems can be identified and fixed by looking at the LogViewer.