Error when using CLEAN Action to delete a business object

himanshu

Hi Support,

I am getting problem while using CLEAN or DELETE action to delete the business object record from database.
Here below are the details with steps, log and screenshot.

There are two business objects
Customer
OrderDetails

(OrderDetails has multiple relationship with Customer)

Test 1 -> Using CLEAN object

Process -> DeleteCustomer
RULE1 -> CLEAN OrderDetails WHERE OrderDetails IN Customer.OrderDetails
RULE2 -> DELETE Customer

Failed on Rule 1 with following error.

Exception thrown com.bas.connectionserver.server.D Internal error. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN BASTESTDOMAINDUMPXID_CUSTOMER_REF AS Customer_OrderDetails_RO ON Custo' at line 1
com.bas.connectionserver.server.D: Internal error. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEFT JOIN BASTESTDOMAINDUMPXID_CUSTOMER_REF AS Customer_OrderDetails_RO ON Custo' at line 1
at com.bas.connectionserver.server.ConnectionFactory.A(Unknown Source)
at com.bas.connectionserver.server.ConnectionFactory.sendMessage(Unknown Source)
at com.bas.webapp.common.WebAppUtils.sendMessageToExecutionEngine(Unknown Source)
at com.bas.webapp.thin.misc.M.A(Unknown Source)
at com.bas.webapp.thin.handlers.B.C.A(Unknown Source)
at com.bas.webapp.thin.handlers.XMLRequestHandler.A(Unknown Source)
at com.bas.webapp.thin.handlers.XMLRequestHandler.handleRequest(Unknown Source)
at com.bas.webapp.thin.servlets.WebInterfaceServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:644)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88-)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:537)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1081)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658-)
at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1566)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1523)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:744)

screenshot name -> CLEAN_action_err.png

Test 2 -> Using CLEAN object

I read user guide and found this note
NOTE: The CLEAN action is not supported for business object groups. You cannot use references in the condition of this action either.

so i try to use condition in following way.

Process -> DeleteCustomer
RULE1 -> CLEAN OrderDetails WHERE OrderDetails.Customer.ID = Customer.ID
RULE2 -> DELETE Customer

Failed on Rule 1 with following error.

Calling BAS server
Exception thrown com.bas.connectionserver.server.D Internal error. This query is not supported for delete operations
com.bas.connectionserver.server.D: Internal error. This query is not supported for delete operations
at com.bas.connectionserver.server.ConnectionFactory.A(Unknown Source)
at com.bas.connectionserver.server.ConnectionFactory.sendMessage(Unknown Source)
at com.bas.webapp.common.WebAppUtils.sendMessageToExecutionEngine(Unknown Source)
at com.bas.webapp.thin.misc.M.A(Unknown Source)
at com.bas.webapp.thin.handlers.B.C.A(Unknown Source)
at com.bas.webapp.thin.handlers.XMLRequestHandler.A(Unknown Source)
at com.bas.webapp.thin.handlers.XMLRequestHandler.handleRequest(Unknown Source)
at com.bas.webapp.thin.servlets.WebInterfaceServlet.doPost(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:644)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:610)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88-)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:537)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1081)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:658-)
at org.apache.coyote.http11.Http11NioProtocol$Http11ConnectionHandler.process(Http11NioProtocol.java:222)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1566)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1523)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:744)

TEST 3 -> Using DELETE option I found it does not allow me to write WHERE clause as in UserGuide it is showing.

screenshot ->

Please let me know if I am doing something wrong or help me with your suggestion.

kklosson

I think you need to state it as:

FIND OrderDetails WHERE...
CLEAN OrderDetails

just like delete.

himanshu

I am using a process and as input parameter customer is already there in context.

Will try your suggestion too.

customaware

Your screenshot of the section in the User Guide correctly states that References are not supported ii the condition of the action.
I am pretty sure that also means as part of the WHERE as that is conditionally including or excluding records.

I could be totally wrong but I seem to recollect running into the same issue some time ago.

Why do you need to use CLEAN rather than DELETE? Is it to stop Deletion Rules being executed?

himanshu

Hi Mark,

Yes, I agree it states that references are not supported but you see in RED block there is a illustration which is showing DELETE with WHERE clause and that is my point. And yes, I want to use CLEAN instead of DELETE just to avoid any rules get executed behind on Business Object.

What Kklosson has suggested I tried but CLEAN action does not support without WHERE clause, so that would not work also.

FIND OrderDetails WHERE...
CLEAN OrderDetails

But I tried another solution is just replace CLEAN with DELETE under FIND Action and it works. 🙂

FIND OrderDetails WHERE...
DELETE OrderDetails

tford

Himanshu,

Yes, I agree it states that references are not supported but you see in RED block there is a illustration which is showing DELETE with WHERE clause and that is my point.

As the example in the User Guide shows, WHERE works well beyond just reference attributes.

himanshu

I have just tested again and confirm that below syntax would not work.

DELETE Account WHERE Account.Name=''

weblike

Hi,

Have you ever solved this? I'm having the same thing now...

thx

himanshu

Hi, Sorry....delayed in replying .... will check it and let you know shortly.