Excel Exporter Issue

0
I'm running into an issue with the excel exporter. It seems that it's because a referenced entity is empty, does anyone know a way around this? Or am I reading this wrong? XLSReport.GenerateReport (JavaAction : 'GenerateExcelDoc') 10:21:26 PM APP ERROR Connector: An error has occurred while handling the request. [User 'MxAdmin' with session id 'e9e3aebf-dbe2-44f6-9b8d-c85936867082' and roles 'Administrator'] 10:21:26 PM APP ERROR Connector: com.mendix.core.CoreException: com.mendix.modules.microflowengine.MicroflowException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): 10:21:26 PM APP INFO InternalOqlTextGetRequest (depth = -1): SELECT a2fc642c6.AssetID AS AssetID0, aaa99ee24.IDNbr AS IDNbr0, afe136ccd.IDNbr AS IDNbr1, afe136ccd.ServicerName AS ServicerName0, a73b47be4.ShortName AS ShortName0, a89f48999.BorrowerName AS BorrowerName0, a2fc642c6.StreetAddress AS StreetAddress0, a2fc642c6.StreetAddressTwo AS StreetAddressTwo0, a2fc642c6.City AS City0, a2fc642c6.State AS State0, a2fc642c6.Zip AS Zip0, a2fc642c6.LoanPurpose AS LoanPurpose0, a2fc642c6.Term AS Term0, a2fc642c6.NoteRate AS NoteRate0, a2fc642c6.Rate AS Rate0, a2fc642c6.OriginationDate AS OriginationDate0, a2fc642c6.MaturityDate AS MaturityDate0, a2fc642c6.ExtendedMaturityDate AS ExtendedMaturityDate0, a2fc642c6.TotalLoanAmount AS TotalLoanAmount0, a2fc642c6.InitialDisbursement AS InitialDisbursement0 FROM "LoanAdministration"."Loan" AS a2fc642c6 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_LoanTapeUpload"/"LoanTapeImport"."LoanTapeUpload"" AS aaa99ee24 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Servicer"/"Stakeholders"."Servicer"" AS afe136ccd INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Lender"/"Stakeholders"."Lender"" AS a73b47be4 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Borrower"/"Stakeholders"."Borrower"" AS a89f48999 ; 10:21:26 PM APP INFO at com.mendix.basis.component.InternalCore.execute(InternalCore.java:569) 10:21:26 PM APP INFO Advanced stacktrace: 10:21:26 PM APP INFO at XLSReport.GenerateReport (JavaAction : 'GenerateExcelDoc') 10:21:26 PM APP INFO Caused by: com.mendix.modules.microflowengine.MicroflowException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): 10:21:26 PM APP INFO InternalOqlTextGetRequest (depth = -1): SELECT a2fc642c6.AssetID AS AssetID0, aaa99ee24.IDNbr AS IDNbr0, afe136ccd.IDNbr AS IDNbr1, afe136ccd.ServicerName AS ServicerName0, a73b47be4.ShortName AS ShortName0, a89f48999.BorrowerName AS BorrowerName0, a2fc642c6.StreetAddress AS StreetAddress0, a2fc642c6.StreetAddressTwo AS StreetAddressTwo0, a2fc642c6.City AS City0, a2fc642c6.State AS State0, a2fc642c6.Zip AS Zip0, a2fc642c6.LoanPurpose AS LoanPurpose0, a2fc642c6.Term AS Term0, a2fc642c6.NoteRate AS NoteRate0, a2fc642c6.Rate AS Rate0, a2fc642c6.OriginationDate AS OriginationDate0, a2fc642c6.MaturityDate AS MaturityDate0, a2fc642c6.ExtendedMaturityDate AS ExtendedMaturityDate0, a2fc642c6.TotalLoanAmount AS TotalLoanAmount0, a2fc642c6.InitialDisbursement AS InitialDisbursement0 FROM "LoanAdministration"."Loan" AS a2fc642c6 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_LoanTapeUpload"/"LoanTapeImport"."LoanTapeUpload"" AS aaa99ee24 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Servicer"/"Stakeholders"."Servicer"" AS afe136ccd INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Lender"/"Stakeholders"."Lender"" AS a73b47be4 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Borrower"/"Stakeholders"."Borrower"" AS a89f48999 ; 10:21:26 PM APP INFO Caused by: com.mendix.core.CoreException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): 10:21:26 PM APP INFO Advanced stacktrace: 10:21:26 PM APP INFO at com.mendix.modules.microflowengine.MicroflowUtil.processException(MicroflowUtil.java:146) 10:21:26 PM APP INFO Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): 10:21:26 PM APP INFO InternalOqlTextGetRequest (depth = -1): SELECT a2fc642c6.AssetID AS AssetID0, aaa99ee24.IDNbr AS IDNbr0, afe136ccd.IDNbr AS IDNbr1, afe136ccd.ServicerName AS ServicerName0, a73b47be4.ShortName AS ShortName0, a89f48999.BorrowerName AS BorrowerName0, a2fc642c6.StreetAddress AS StreetAddress0, a2fc642c6.StreetAddressTwo AS StreetAddressTwo0, a2fc642c6.City AS City0, a2fc642c6.State AS State0, a2fc642c6.Zip AS Zip0, a2fc642c6.LoanPurpose AS LoanPurpose0, a2fc642c6.Term AS Term0, a2fc642c6.NoteRate AS NoteRate0, a2fc642c6.Rate AS Rate0, a2fc642c6.OriginationDate AS OriginationDate0, a2fc642c6.MaturityDate AS MaturityDate0, a2fc642c6.ExtendedMaturityDate AS ExtendedMaturityDate0, a2fc642c6.TotalLoanAmount AS TotalLoanAmount0, a2fc642c6.InitialDisbursement AS InitialDisbursement0 FROM "LoanAdministration"."Loan" AS a2fc642c6 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_LoanTapeUpload"/"LoanTapeImport"."LoanTapeUpload"" AS aaa99ee24 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Servicer"/"Stakeholders"."Servicer"" AS afe136ccd INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Lender"/"Stakeholders"."Lender"" AS a73b47be4 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Borrower"/"Stakeholders"."Borrower"" AS a89f48999 ; 10:21:26 PM APP INFO at com.mendix.basis.component.InternalCore.execute(InternalCore.java:598) 10:21:26 PM APP INFO at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:195) 10:21:26 PM APP INFO at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36) 10:21:26 PM APP INFO Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): 10:21:26 PM APP INFO Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): 10:21:26 PM APP INFO InternalOqlTextGetRequest (depth = -1): SELECT a2fc642c6.AssetID AS AssetID0, aaa99ee24.IDNbr AS IDNbr0, afe136ccd.IDNbr AS IDNbr1, afe136ccd.ServicerName AS ServicerName0, a73b47be4.ShortName AS ShortName0, a89f48999.BorrowerName AS BorrowerName0, a2fc642c6.StreetAddress AS StreetAddress0, a2fc642c6.StreetAddressTwo AS StreetAddressTwo0, a2fc642c6.City AS City0, a2fc642c6.State AS State0, a2fc642c6.Zip AS Zip0, a2fc642c6.LoanPurpose AS LoanPurpose0, a2fc642c6.Term AS Term0, a2fc642c6.NoteRate AS NoteRate0, a2fc642c6.Rate AS Rate0, a2fc642c6.OriginationDate AS OriginationDate0, a2fc642c6.MaturityDate AS MaturityDate0, a2fc642c6.ExtendedMaturityDate AS ExtendedMaturityDate0, a2fc642c6.TotalLoanAmount AS TotalLoanAmount0, a2fc642c6.InitialDisbursement AS InitialDisbursement0 FROM "LoanAdministration"."Loan" AS a2fc642c6 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_LoanTapeUpload"/"LoanTapeImport"."LoanTapeUpload"" AS aaa99ee24 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Servicer"/"Stakeholders"."Servicer"" AS afe136ccd INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Lender"/"Stakeholders"."Lender"" AS a73b47be4 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Borrower"/"Stakeholders"."Borrower"" AS a89f48999 ; 10:21:26 PM APP INFO InternalOqlTextGetRequest (depth = -1): SELECT a2fc642c6.AssetID AS AssetID0, aaa99ee24.IDNbr AS IDNbr0, afe136ccd.IDNbr AS IDNbr1, afe136ccd.ServicerName AS ServicerName0, a73b47be4.ShortName AS ShortName0, a89f48999.BorrowerName AS BorrowerName0, a2fc642c6.StreetAddress AS StreetAddress0, a2fc642c6.StreetAddressTwo AS StreetAddressTwo0, a2fc642c6.City AS City0, a2fc642c6.State AS State0, a2fc642c6.Zip AS Zip0, a2fc642c6.LoanPurpose AS LoanPurpose0, a2fc642c6.Term AS Term0, a2fc642c6.NoteRate AS NoteRate0, a2fc642c6.Rate AS Rate0, a2fc642c6.OriginationDate AS OriginationDate0, a2fc642c6.MaturityDate AS MaturityDate0, a2fc642c6.ExtendedMaturityDate AS ExtendedMaturityDate0, a2fc642c6.TotalLoanAmount AS TotalLoanAmount0, a2fc642c6.InitialDisbursement AS InitialDisbursement0 FROM "LoanAdministration"."Loan" AS a2fc642c6 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_LoanTapeUpload"/"LoanTapeImport"."LoanTapeUpload"" AS aaa99ee24 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Servicer"/"Stakeholders"."Servicer"" AS afe136ccd INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Lender"/"Stakeholders"."Lender"" AS a73b47be4 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Borrower"/"Stakeholders"."Borrower"" AS a89f48999 ; 10:21:26 PM APP INFO InternalOqlTextGetRequest (depth = -1): SELECT a2fc642c6.AssetID AS AssetID0, aaa99ee24.IDNbr AS IDNbr0, afe136ccd.IDNbr AS IDNbr1, afe136ccd.ServicerName AS ServicerName0, a73b47be4.ShortName AS ShortName0, a89f48999.BorrowerName AS BorrowerName0, a2fc642c6.StreetAddress AS StreetAddress0, a2fc642c6.StreetAddressTwo AS StreetAddressTwo0, a2fc642c6.City AS City0, a2fc642c6.State AS State0, a2fc642c6.Zip AS Zip0, a2fc642c6.LoanPurpose AS LoanPurpose0, a2fc642c6.Term AS Term0, a2fc642c6.NoteRate AS NoteRate0, a2fc642c6.Rate AS Rate0, a2fc642c6.OriginationDate AS OriginationDate0, a2fc642c6.MaturityDate AS MaturityDate0, a2fc642c6.ExtendedMaturityDate AS ExtendedMaturityDate0, a2fc642c6.TotalLoanAmount AS TotalLoanAmount0, a2fc642c6.InitialDisbursement AS InitialDisbursement0 FROM "LoanAdministration"."Loan" AS a2fc642c6 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_LoanTapeUpload"/"LoanTapeImport"."LoanTapeUpload"" AS aaa99ee24 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Servicer"/"Stakeholders"."Servicer"" AS afe136ccd INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Lender"/"Stakeholders"."Lender"" AS a73b47be4 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Borrower"/"Stakeholders"."Borrower"" AS a89f48999 ; 10:21:26 PM APP INFO at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:36) 10:21:26 PM APP INFO InternalOqlTextGetRequest (depth = -1): SELECT a2fc642c6.AssetID AS AssetID0, aaa99ee24.IDNbr AS IDNbr0, afe136ccd.IDNbr AS IDNbr1, afe136ccd.ServicerName AS ServicerName0, a73b47be4.ShortName AS ShortName0, a89f48999.BorrowerName AS BorrowerName0, a2fc642c6.StreetAddress AS StreetAddress0, a2fc642c6.StreetAddressTwo AS StreetAddressTwo0, a2fc642c6.City AS City0, a2fc642c6.State AS State0, a2fc642c6.Zip AS Zip0, a2fc642c6.LoanPurpose AS LoanPurpose0, a2fc642c6.Term AS Term0, a2fc642c6.NoteRate AS NoteRate0, a2fc642c6.Rate AS Rate0, a2fc642c6.OriginationDate AS OriginationDate0, a2fc642c6.MaturityDate AS MaturityDate0, a2fc642c6.ExtendedMaturityDate AS ExtendedMaturityDate0, a2fc642c6.TotalLoanAmount AS TotalLoanAmount0, a2fc642c6.InitialDisbursement AS InitialDisbursement0 FROM "LoanAdministration"."Loan" AS a2fc642c6 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_LoanTapeUpload"/"LoanTapeImport"."LoanTapeUpload"" AS aaa99ee24 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Servicer"/"Stakeholders"."Servicer"" AS afe136ccd INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Lender"/"Stakeholders"."Lender"" AS a73b47be4 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Borrower"/"Stakeholders"."Borrower"" AS a89f48999 ; 10:21:26 PM APP INFO at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:195) 10:21:26 PM APP INFO Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): 10:21:26 PM APP INFO Error on line 1 character 907: missing EOF at '"' 10:21:26 PM APP INFO at com.mendix.queryparser.oql.OqlTextToOqlConverter$.throwException$1(OqlTextToOqlConverter.scala:31) 10:21:26 PM APP INFO Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s): 10:21:26 PM APP INFO InternalOqlTextGetRequest (depth = -1): SELECT a2fc642c6.AssetID AS AssetID0, aaa99ee24.IDNbr AS IDNbr0, afe136ccd.IDNbr AS IDNbr1, afe136ccd.ServicerName AS ServicerName0, a73b47be4.ShortName AS ShortName0, a89f48999.BorrowerName AS BorrowerName0, a2fc642c6.StreetAddress AS StreetAddress0, a2fc642c6.StreetAddressTwo AS StreetAddressTwo0, a2fc642c6.City AS City0, a2fc642c6.State AS State0, a2fc642c6.Zip AS Zip0, a2fc642c6.LoanPurpose AS LoanPurpose0, a2fc642c6.Term AS Term0, a2fc642c6.NoteRate AS NoteRate0, a2fc642c6.Rate AS Rate0, a2fc642c6.OriginationDate AS OriginationDate0, a2fc642c6.MaturityDate AS MaturityDate0, a2fc642c6.ExtendedMaturityDate AS ExtendedMaturityDate0, a2fc642c6.TotalLoanAmount AS TotalLoanAmount0, a2fc642c6.InitialDisbursement AS InitialDisbursement0 FROM "LoanAdministration"."Loan" AS a2fc642c6 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_LoanTapeUpload"/"LoanTapeImport"."LoanTapeUpload"" AS aaa99ee24 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Servicer"/"Stakeholders"."Servicer"" AS afe136ccd INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Lender"/"Stakeholders"."Lender"" AS a73b47be4 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Borrower"/"Stakeholders"."Borrower"" AS a89f48999 ; 10:21:26 PM APP INFO at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:62) 10:21:26 PM APP INFO Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: OQL query cannot be parsed: SELECT a2fc642c6.AssetID AS AssetID0, aaa99ee24.IDNbr AS IDNbr0, afe136ccd.IDNbr AS IDNbr1, afe136ccd.ServicerName AS ServicerName0, a73b47be4.ShortName AS ShortName0, a89f48999.BorrowerName AS BorrowerName0, a2fc642c6.StreetAddress AS StreetAddress0, a2fc642c6.StreetAddressTwo AS StreetAddressTwo0, a2fc642c6.City AS City0, a2fc642c6.State AS State0, a2fc642c6.Zip AS Zip0, a2fc642c6.LoanPurpose AS LoanPurpose0, a2fc642c6.Term AS Term0, a2fc642c6.NoteRate AS NoteRate0, a2fc642c6.Rate AS Rate0, a2fc642c6.OriginationDate AS OriginationDate0, a2fc642c6.MaturityDate AS MaturityDate0, a2fc642c6.ExtendedMaturityDate AS ExtendedMaturityDate0, a2fc642c6.TotalLoanAmount AS TotalLoanAmount0, a2fc642c6.InitialDisbursement AS InitialDisbursement0 FROM "LoanAdministration"."Loan" AS a2fc642c6 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_LoanTapeUpload"/"LoanTapeImport"."LoanTapeUpload"" AS aaa99ee24 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Servicer"/"Stakeholders"."Servicer"" AS afe136ccd INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Lender"/"Stakeholders"."Lender"" AS a73b47be4 INNER JOIN a2fc642c6/"LoanAdministration"."Loan_Borrower"/"Stakeholders"."Borrower"" AS a89f48999 ; 10:21:26 PM APP INFO at com.mendix.queryparser.oql.OqlTextToOqlConverter$.convert(OqlTextToOqlConverter.scala:38) 10:21:26 PM APP INFO at com.mendix.queryparser.QueryParserImpl.parseOQLQuery(QueryParserImpl.scala:31) 10:21:26 PM APP INFO at com.mendix.connectionbus.retrieve.requests.InternalOqlTextGetRequest.getSuitableRequest(InternalOqlTextGetRequest.java:43) 10:21:26 PM APP INFO at com.mendix.connectionbus.retrieve.GetRequestHandler.doRequest(GetRequestHandler.java:65) 10:21:26 PM APP INFO at com.mendix.connectionbus.ConnectionBusImpl.doRequest(ConnectionBusImpl.java:453) 10:21:26 PM APP INFO at com.mendix.connectionbus.RequestAnalyzer.doRequest(RequestAnalyzer.java:48) 10:21:26 PM APP INFO at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:57) 10:21:26 PM APP INFO at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:55) 10:21:26 PM APP INFO at com.mendix.basis.action.user.RetrieveOQLDataTableAction.executeAction(RetrieveOQLDataTableAction.java:87) 10:21:26 PM APP INFO at com.mendix.basis.action.user.RetrieveOQLDataTableAction.executeAction(RetrieveOQLDataTableAction.java:18) 10:21:26 PM APP INFO at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46) 10:21:26 PM APP INFO at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:79) 10:21:26 PM APP INFO at com.mendix.basis.actionmanagement.ActionManager$1.execute(ActionManager.java:186) 10:21:26 PM APP INFO at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) 10:21:26 PM APP INFO at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:191) 10:21:26 PM APP INFO at com.mendix.basis.component.InternalCore.retrieveOQLDataTable(InternalCore.java:1253) 10:21:26 PM APP INFO at com.mendix.basis.component.InternalCore.retrieveOQLDataTable(InternalCore.java:104) 10:21:26 PM APP INFO at com.mendix.core.Core.retrieveOQLDataTable(Core.java:1091) 10:21:26 PM APP INFO at xlsreport.report.DataOQL.getRowData(DataOQL.java:87) 10:21:26 PM APP INFO at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:133) 10:21:26 PM APP INFO at xlsreport.actions.GenerateExcelDoc.executeAction(GenerateExcelDoc.java:34) 10:21:26 PM APP INFO at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46) 10:21:26 PM APP INFO at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:79) 10:21:26 PM APP INFO at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:57) 10:21:26 PM APP INFO at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:55) 10:21:26 PM APP INFO at com.mendix.basis.actionmanagement.ActionManager$1.execute(ActionManager.java:186) 10:21:26 PM APP INFO at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) 10:21:26 PM APP INFO at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:191) 10:21:26 PM APP INFO at com.mendix.basis.component.InternalCore.execute(InternalCore.java:594) 10:21:26 PM APP INFO at com.mendix.modules.microflowengine.actions.actioncall.JavaAction.execute(JavaAction.scala:64) 10:21:26 PM APP INFO at com.mendix.modules.microflowengine.microflow.impl.MicroflowObject.execute(MicroflowObject.java:47) 10:21:26 PM APP INFO at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.doCall(CoreActionHandlerImpl.scala:79) 10:21:26 PM APP INFO at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAfterBreakingIfNecessary(MicroflowImpl.java:201) 10:21:26 PM APP INFO at com.mendix.modules.microflowengine.microflow.impl.MicroflowImpl.executeAction(MicroflowImpl.java:157) 10:21:26 PM APP INFO at com.mendix.systemwideinterfaces.core.UserAction.execute(UserAction.java:46) 10:21:26 PM APP INFO at com.mendix.core.actionmanagement.CoreAction.call(CoreAction.java:55) 10:21:26 PM APP INFO at com.mendix.basis.actionmanagement.CoreActionHandlerImpl.call(CoreActionHandlerImpl.scala:57) 10:21:26 PM APP INFO at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.java:191) 10:21:26 PM APP INFO at com.mendix.basis.actionmanagement.ActionManager$1.execute(ActionManager.java:186) 10:21:26 PM APP INFO at com.mendix.util.classloading.Runner.doRunUsingClassLoaderOf(Runner.java:32) 10:21:26 PM APP INFO at com.mendix.basis.component.InternalCore.execute(InternalCore.java:578) 10:21:26 PM APP 
asked
3 answers
1

Yes, there were too many “s as Erwin eluded to. Here is the screen shot of the section that needed changing.

Displaying image001.png

Here is the fixed result:

                this.JOIN.append(" " + refMap.getOrDefault(referenceName, "") + " JOIN ").append(fromAlias).append("/"
                        + referenceNameQuoted + "/").append(tableName);
                this.JOIN.append(" AS ").append(toObject.getAlias());
            }

answered
0

Did you already try a LEFT JOIN instead of an INNER JOIN in your associations settings tab within the template?

answered
0

Did you figure out what was wrong here? I’m having a similar issue now and really not sure what to do. 

 

Any help would be great,

 

Cheers!

answered