OQL to CSV error

0
Hi, I have recently upgraded my app from 8.18 to 9.12.5 in doing so I have upgraded the CSV module to 1.15 and the OQL module to 2.1. Since then, I have received the below error when the ‘Export OQL to CSV’ java action is called: 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):     InternalOqlTextGetRequest (depth = -1, amount = 10000): select distinct cast(ID as string) as EBSRequestOID,cast(EBS.EBSBatchLine.ID as string) as  EBSBatchLineOID,cast(PremiumCollection.GermanyAutomatedCollectionTransaction.ID as string) as  GermanyAutomatedCollectionTransactionOID,cast(Benefit.AutomatedBenefitPaymentTransaction.ID as string) as  AutomatedBenefitPaymentTransactionOID,cast(Agent.AutoAgentPaymentTransactions.ID as string) as  AutoAgentPaymentTransactionsOID, replace(ReferenceNumber,',','') as ReferenceNumber, Country, replace(Name,',','') as Name,  replace(BankName,',','') as BankName, BankCountry, replace(AccountName,',','') as AccountName, replace(SortCode,',','') as SortCode, replace(AccountNumber,',','') as AccountNumber, replace(IBAN,',','') as IBAN, cast(RequestDate as string) as RequestDate,cast(DueDateLow as string) as DueDateLow, cast(DueDateHigh as string) as DueDateHigh,cast(Amount as string) as Amount,Currency,RequestType, IDDStatus, BICCode, cast(changedDate as string) as changedDate,System.changedBy as ChangedBy from EBS.EBSRequest left outer join EBS.EBSRequest/EBS.EBSRequest_EBSBatchLine/EBS.EBSBatchLine left outer join EBS.EBSRequest/EBS.EBSRequest_GermanyAutomatedCollectionTransaction/PremiumCollection.GermanyAutomatedCollectionTransaction left outer join EBS.EBSRequest/EBS.EBSRequest_AutomatedBenefitPaymentTransaction/Benefit.AutomatedBenefitPaymentTransaction left outer join EBS.EBSRequest/EBS.EBSRequest_AutoAgentPaymentTransactions/Agent.AutoAgentPaymentTransactions where EBS.EBSRequest.changedDate >= '2020-01-01T00:00:00.000+0000';     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:110) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):     InternalOqlTextGetRequest (depth = -1, amount = 10000): select distinct cast(ID as string) as EBSRequestOID,cast(EBS.EBSBatchLine.ID as string) as  EBSBatchLineOID,cast(PremiumCollection.GermanyAutomatedCollectionTransaction.ID as string) as  GermanyAutomatedCollectionTransactionOID,cast(Benefit.AutomatedBenefitPaymentTransaction.ID as string) as  AutomatedBenefitPaymentTransactionOID,cast(Agent.AutoAgentPaymentTransactions.ID as string) as  AutoAgentPaymentTransactionsOID, replace(ReferenceNumber,',','') as ReferenceNumber, Country, replace(Name,',','') as Name,  replace(BankName,',','') as BankName, BankCountry, replace(AccountName,',','') as AccountName, replace(SortCode,',','') as SortCode, replace(AccountNumber,',','') as AccountNumber, replace(IBAN,',','') as IBAN, cast(RequestDate as string) as RequestDate,cast(DueDateLow as string) as DueDateLow, cast(DueDateHigh as string) as DueDateHigh,cast(Amount as string) as Amount,Currency,RequestType, IDDStatus, BICCode, cast(changedDate as string) as changedDate,System.changedBy as ChangedBy from EBS.EBSRequest left outer join EBS.EBSRequest/EBS.EBSRequest_EBSBatchLine/EBS.EBSBatchLine left outer join EBS.EBSRequest/EBS.EBSRequest_GermanyAutomatedCollectionTransaction/PremiumCollection.GermanyAutomatedCollectionTransaction left outer join EBS.EBSRequest/EBS.EBSRequest_AutomatedBenefitPaymentTransaction/Benefit.AutomatedBenefitPaymentTransaction left outer join EBS.EBSRequest/EBS.EBSRequest_AutoAgentPaymentTransactions/Agent.AutoAgentPaymentTransactions where EBS.EBSRequest.changedDate >= '2020-01-01T00:00:00.000+0000';     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:110) Caused by: com.mendix.systemwideinterfaces.MendixRuntimeException: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):     InternalOqlTextGetRequest (depth = -1, amount = 10000): select distinct cast(ID as string) as EBSRequestOID,cast(EBS.EBSBatchLine.ID as string) as  EBSBatchLineOID,cast(PremiumCollection.GermanyAutomatedCollectionTransaction.ID as string) as  GermanyAutomatedCollectionTransactionOID,cast(Benefit.AutomatedBenefitPaymentTransaction.ID as string) as  AutomatedBenefitPaymentTransactionOID,cast(Agent.AutoAgentPaymentTransactions.ID as string) as  AutoAgentPaymentTransactionsOID, replace(ReferenceNumber,',','') as ReferenceNumber, Country, replace(Name,',','') as Name,  replace(BankName,',','') as BankName, BankCountry, replace(AccountName,',','') as AccountName, replace(SortCode,',','') as SortCode, replace(AccountNumber,',','') as AccountNumber, replace(IBAN,',','') as IBAN, cast(RequestDate as string) as RequestDate,cast(DueDateLow as string) as DueDateLow, cast(DueDateHigh as string) as DueDateHigh,cast(Amount as string) as Amount,Currency,RequestType, IDDStatus, BICCode, cast(changedDate as string) as changedDate,System.changedBy as ChangedBy from EBS.EBSRequest left outer join EBS.EBSRequest/EBS.EBSRequest_EBSBatchLine/EBS.EBSBatchLine left outer join EBS.EBSRequest/EBS.EBSRequest_GermanyAutomatedCollectionTransaction/PremiumCollection.GermanyAutomatedCollectionTransaction left outer join EBS.EBSRequest/EBS.EBSRequest_AutomatedBenefitPaymentTransaction/Benefit.AutomatedBenefitPaymentTransaction left outer join EBS.EBSRequest/EBS.EBSRequest_AutoAgentPaymentTransactions/Agent.AutoAgentPaymentTransactions where EBS.EBSRequest.changedDate >= '2020-01-01T00:00:00.000+0000';     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:110) Caused by: com.mendix.connectionbus.ConnectionBusRuntimeException: An exception has occurred for the following request(s):     InternalOqlTextGetRequest (depth = -1, amount = 10000): select distinct cast(ID as string) as EBSRequestOID,cast(EBS.EBSBatchLine.ID as string) as  EBSBatchLineOID,cast(PremiumCollection.GermanyAutomatedCollectionTransaction.ID as string) as  GermanyAutomatedCollectionTransactionOID,cast(Benefit.AutomatedBenefitPaymentTransaction.ID as string) as  AutomatedBenefitPaymentTransactionOID,cast(Agent.AutoAgentPaymentTransactions.ID as string) as  AutoAgentPaymentTransactionsOID, replace(ReferenceNumber,',','') as ReferenceNumber, Country, replace(Name,',','') as Name,  replace(BankName,',','') as BankName, BankCountry, replace(AccountName,',','') as AccountName, replace(SortCode,',','') as SortCode, replace(AccountNumber,',','') as AccountNumber, replace(IBAN,',','') as IBAN, cast(RequestDate as string) as RequestDate,cast(DueDateLow as string) as DueDateLow, cast(DueDateHigh as string) as DueDateHigh,cast(Amount as string) as Amount,Currency,RequestType, IDDStatus, BICCode, cast(changedDate as string) as changedDate,System.changedBy as ChangedBy from EBS.EBSRequest left outer join EBS.EBSRequest/EBS.EBSRequest_EBSBatchLine/EBS.EBSBatchLine left outer join EBS.EBSRequest/EBS.EBSRequest_GermanyAutomatedCollectionTransaction/PremiumCollection.GermanyAutomatedCollectionTransaction left outer join EBS.EBSRequest/EBS.EBSRequest_AutomatedBenefitPaymentTransaction/Benefit.AutomatedBenefitPaymentTransaction left outer join EBS.EBSRequest/EBS.EBSRequest_AutoAgentPaymentTransactions/Agent.AutoAgentPaymentTransactions where EBS.EBSRequest.changedDate >= '2020-01-01T00:00:00.000+0000';     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:110) Caused by: An exception has occurred for the following request(s):     InternalOqlTextGetRequest (depth = -1, amount = 10000): select distinct cast(ID as string) as EBSRequestOID,cast(EBS.EBSBatchLine.ID as string) as  EBSBatchLineOID,cast(PremiumCollection.GermanyAutomatedCollectionTransaction.ID as string) as  GermanyAutomatedCollectionTransactionOID,cast(Benefit.AutomatedBenefitPaymentTransaction.ID as string) as  AutomatedBenefitPaymentTransactionOID,cast(Agent.AutoAgentPaymentTransactions.ID as string) as  AutoAgentPaymentTransactionsOID, replace(ReferenceNumber,',','') as ReferenceNumber, Country, replace(Name,',','') as Name,  replace(BankName,',','') as BankName, BankCountry, replace(AccountName,',','') as AccountName, replace(SortCode,',','') as SortCode, replace(AccountNumber,',','') as AccountNumber, replace(IBAN,',','') as IBAN, cast(RequestDate as string) as RequestDate,cast(DueDateLow as string) as DueDateLow, cast(DueDateHigh as string) as DueDateHigh,cast(Amount as string) as Amount,Currency,RequestType, IDDStatus, BICCode, cast(changedDate as string) as changedDate,System.changedBy as ChangedBy from EBS.EBSRequest left outer join EBS.EBSRequest/EBS.EBSRequest_EBSBatchLine/EBS.EBSBatchLine left outer join EBS.EBSRequest/EBS.EBSRequest_GermanyAutomatedCollectionTransaction/PremiumCollection.GermanyAutomatedCollectionTransaction left outer join EBS.EBSRequest/EBS.EBSRequest_AutomatedBenefitPaymentTransaction/Benefit.AutomatedBenefitPaymentTransaction left outer join EBS.EBSRequest/EBS.EBSRequest_AutoAgentPaymentTransactions/Agent.AutoAgentPaymentTransactions where EBS.EBSRequest.changedDate >= '2020-01-01T00:00:00.000+0000';     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:110) Caused by: Input 'select distinct cast(ID as string) as EBSRequestOID,cast(EBS.EBSBatchLine.ID as string) as  EBSBatchLineOID,cast(PremiumCollection.GermanyAutomatedCollectionTransaction.ID as string) as  GermanyAutomatedCollectionTransactionOID,cast(Benefit.AutomatedBenefitPaymentTransaction.ID as string) as  AutomatedBenefitPaymentTransactionOID,cast(Agent.AutoAgentPaymentTransactions.ID as string) as  AutoAgentPaymentTransactionsOID, replace(ReferenceNumber,',','') as ReferenceNumber, Country, replace(Name,',','') as Name,  replace(BankName,',','') as BankName, BankCountry, replace(AccountName,',','') as AccountName, replace(SortCode,',','') as SortCode, replace(AccountNumber,',','') as AccountNumber, replace(IBAN,',','') as IBAN, cast(RequestDate as string) as RequestDate,cast(DueDateLow as string) as DueDateLow, cast(DueDateHigh as string) as DueDateHigh,cast(Amount as string) as Amount,Currency,RequestType, IDDStatus, BICCode, cast(changedDate as string) as changedDate,System.changedBy as ChangedBy from EBS.EBSRequest left outer join EBS.EBSRequest/EBS.EBSRequest_EBSBatchLine/EBS.EBSBatchLine left outer join EBS.EBSRequest/EBS.EBSRequest_GermanyAutomatedCollectionTransaction/PremiumCollection.GermanyAutomatedCollectionTransaction left outer join EBS.EBSRequest/EBS.EBSRequest_AutomatedBenefitPaymentTransaction/Benefit.AutomatedBenefitPaymentTransaction left outer join EBS.EBSRequest/EBS.EBSRequest_AutoAgentPaymentTransactions/Agent.AutoAgentPaymentTransactions where EBS.EBSRequest.changedDate >= '2020-01-01T00:00:00.000+0000';' could not be parsed Error on line 1 character 430: missing FROM at '(' Error on line 1 character 431: mismatched input 'ReferenceNumber' expecting {SELECT, FROM} Error on line 1 character 447: mismatched input '','' expecting {'(', AT_SIGN, OPEN_QUOTE, IDENTIFIER} Error on line 1 character 451: mismatched input '''' expecting {'(', AT_SIGN, OPEN_QUOTE, IDENTIFIER} Error on line 1 character 491: mismatched input '(' expecting {<EOF>, ';'}     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:110) Caused by: List() (of class scala.collection.immutable.Nil$)     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:110)   Has anyone seen this before and know how to rectify?    Thanks,
asked
0 answers