OQL Query failure in higher instance-Hint: There is an entry for table reporting$reportsearch, but it cannot be referenced from this part of the query.

0
I have one Dataset using OQL ,wrote query and able to test successfully in LOcal run while trying to run same in Test instance it is giving below error. Exception occurred in action '{"request":"InternalOqlTextGetRequest (depth = 0): select MDM_Customer.CustomerAccount.CustomerId InviteCode, MDM_Customer.CustomerAccount.CompanyName CompanyName, MDM_Customer.Invite.CustomerEmail CustomerEmail, MDM_Customer.Invite.CustomerName+' '+ MDM_Customer.Invite.CustomerLastName CustomerName, MDM_Customer.CustomerAccount.SubmissionDate SubmissionDate, MDM_Customer.CustomerAccount.IsWalkIn IsWalkIn, MDM_Customer.CustomerAccount.SubmissionDate SubmissionDate, MDM_Customer.Invite.DateSent DateSent, BrandManagement.BrandsMaster.BrandName BrandName, MDM_Customer.Invite.InviterFullName InvitedBY, Administration.Account.FullName AsssignedTo FROM MDM_Customer.CustomerAccount,Reporting.ReportSearch, MDM_Customer.Invite,BrandManagement.BrandsMaster,Administration.Account where 1=1 and (MDM_Customer.CustomerAccount.CompanyName = Reporting.ReportSearch.CompanyName or Reporting.ReportSearch.CompanyName = NULL) and ( MDM_Customer.CustomerAccount.CustomerId =Reporting.ReportSearch.InviteCode or Reporting.ReportSearch.InviteCode = NULL) and (MDM_Customer.Invite.DateSent>=Reporting.ReportSearch.InviteCreationStartDate or Reporting.ReportSearch.InviteCreationStartDate = null) and (MDM_Customer.Invite.DateSent<=Reporting.ReportSearch.InviteCreationEndDate or Reporting.ReportSearch.InviteCreationEndDate = null) and MDM_Customer.CustomerAccount/MDM_Customer.Invite_CustomerAccount/MDM_Customer.Invite/InviteCode=MDM_Customer.Invite.InviteCode and MDM_Customer.Invite/MDM_Customer.Invite_BrandsMaster/BrandManagement.BrandsMaster/BrandName= BrandManagement.BrandsMaster.BrandName and MDM_Customer.CustomerAccount/MDM_Customer.CustomerAccount_Account/Administration.Account/FullName=Administration.Account/FullName and Reporting.ReportSearch/Reporting.ReportSearch_User= '[%CurrentUser%]'","type":"RetrieveOQLDataTableAction"}'
asked
1 answers
0

That is either because the Domainmodel in test is not (yet) the same as your local database, or because the data is different. The first is easily checked (if you haven’t already done so): deploy to Test

The second is a bit more complex, but trial and error helps out here. For instance try running the OQL without the last “and Reporting.ReportSearch/Reporting.ReportSearch_User= '[%CurrentUser%]'" and see what happens.

answered