Happy Business Starts Here

Highlighted
Valued Scholar

zoql error

Hi All,

When I try to run the following query using the zoql 

 

Select  sum(Amount) as PaymentAmount,Account.ISNID__c as advertiser_id

from Payment 

where CreatedDate >= 'today- 45 days'

and YEAR(CreatedDate)=2017

group by Account.ISNID__c

limit 20

 

I get an error from the zuora engine saying:

{
"errorCode" : "90007",
"message" : "null, ErrorCode=90007,Message=",
"batches" : [ {
"localizedStatus" : "pending",
"recordCount" : 0,
"batchId" : "2c92c0f95e5e8bf8015e7092eb4d351c",
"apiVersion" : "58.0",
"batchType" : "zoqlexport",
"full" : true,
"status" : "pending",
"query" : "Select sum(Amount) as PaymentAmount,Account.ISNID__c as advertiser_id\r\nfrom Payment \r\nwhere CreatedDate >= 'today- 45 days'\r\nand YEAR(CreatedDate)=2017\r\ngroup by Account.ISNID__c\r\nlimit 20"
} ],
"useLastCompletedJobQueries" : false,
"encrypted" : "none",
"version" : "1.0",
"startTime" : "2017-09-11T06:53:51-0400",
"status" : "aborted",
"format" : "CSV",
"name" : "IConductQuery",
"id" : "2c92c0f95e5e8bf8015e7092eb49351b"
}

 

when I remove the and YEAR(CreatedDate)=2017 condition the query works fine.

 

@Viktor Maybe you can help me also on this one?

 

Thanks for your help,

Mike.

 

5 REPLIES 5
Highlighted
Support SME

Re: zoql error

I'll take a look at this @_mikeSmith - ping me again if you would not hear from me tomorrow!



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

Highlighted
Support SME

Re: zoql error

Hi @_mikeSmith I've done some testing around this, and it seems to me this is actually a bug as I've managed to capture some errors in our internal logs.

 

Could you open a Support Ticket regarding this please, as this will need more in-depth investigation? You can address the ticket to me and I can continue working on this.



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

Highlighted
Valued Scholar

Re: zoql error

Hi @Viktor,

Thanks for your quick response. Can you please reffer me to the page where  I can open the ticket?

Thanks.

 

Highlighted
Support SME

Re: zoql error

@_mikeSmith you can register and log a case at support.zuora.com !



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

Highlighted
Support SME

Re: zoql error

Hi @_mikeSmith I have not seen a ticket from you (might have just avoided my attention), but I wanted to let you know this has been reported to our Developers already, as this seems to be affecting all Date-related functions like quarter() or month(). We expect this to be fixed shortly!



If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √