Caused by: java.lang.NullPointerException: Could not find result attribute StoreCode in target object.

0
I have used the java action "Execute OQL Statement" for executing OQL query. Attaching the query as well. Select distincttctpmaster.StoreCode,tctpmaster.Message, tctpmaster.AckDate, tctpmaster.StatusFrom TitanTechPortal.TCTP_ConfigMaster tctpmaster LEFT JOIN StoreMaster.StoreMaster SM ON(tctpmaster/StoreCode=SM/StoreCode)where(SM/StoreCode IN ('HSRS')) and((tctpmaster/AckDate>= '10-09-2024' )and(tctpmaster/AckDate< '18-09-2024')) Let me know if any issue in above query. But got the following error: Error Type: java.lang.NullPointerException Message: Could not find result attribute StoreCode in target object. Stack Trace:  com.mendix.systemwideinterfaces.MendixRuntimeException: java.lang.NullPointerException: Could not find result attribute StoreCode in target object.    at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:110) Caused by:java.lang.NullPointerException: Could not find result attribute StoreCode in target object.    at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:110) Caused by:Could not find result attribute StoreCode in target object.    at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:110)   Please help me out of this error.   Below the attached screenshot of java action:
asked
1 answers
0

Hi Kajal Kumari,

 

IN OQL - Attributes are accessed using a '.' 

Try to update the ON Query with tctpmaster.StoreCode and others as well and in your Where condition as well.

 

I hope it works!!

answered