Happy Business Starts Here

Re: [AQuA] errorCode: 90005: "There is a syntax error in one of the queries in the AQuA input.

Zuora Support
Zuora Support

[AQuA] errorCode: 90005: "There is a syntax error in one of the queries in the AQuA input."

Problem:

 

Error while querying AmountHomeCurrency and HomeCurrency from JournalEntryItem using AQuA:

 

Request example:

{ 
"format" : "csv",
"version" : "1.1",
"name" : "JournalEntryItem",
"encrypted" : "none",
"useQueryLabels" : "true",
"dateTimeUtc" : "true",
"queries"  : [ { 
"name":"JournalEntryItem",
"query":"select AmountHomeCurrency and HomeCurrency from JournalEntryItem", 
"type":"zoqlexport"
} 
] 
}


Response:

{
    "errorCode": "90005",
    "message": "There is a syntax error in one of the queries in the AQuA input",
    "useLastCompletedJobQueries": false,
    "batches": [
        {
            "localizedStatus": "pending",
            "recordCount": 0,
            "full": true,
            "apiVersion": "97.0",
            "batchType": "zoqlexport",
            "status": "pending",
            "name": "JournalEntryItem",
            "query": "select AmountHomeCurrency and HomeCurrency from JournalEntryItem"
        }
    ],
    "encrypted": "none",
    "status": "error",
    "name": "JournalEntryItem",
    "offset": 0,
    "version": "1.0",
    "format": "CSV"
}

 



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

1 REPLY 1
Highlighted
Zuora Support
Zuora Support

Re: [AQuA] errorCode: 90005: "There is a syntax error in one of the queries in the AQuA input.

Cause:

 

"Currency Conversion" feature is not enabled in the tenant, therefore HomeCurrency and AmountHomeCurrency fields are not available in journal  Entry Item object. 

https://knowledgecenter.zuora.com/CC_Finance/D_Finance_Settings/F_Foreign_Currency_Conversion

 

As checking from data source export against Journal Entry Item object.

  • Feature disabled:

Screen Shot 2019-07-08 at 09.43.46.png

  • Feature enabled:

Screen Shot 2019-07-08 at 09.42.22.png

 

Solution:

 

  • Remove HomeCurrency and AmountHomeCurrency fields from the query 
  • Or, if you wish to have access to this Currency Conversion feature, submit a request at Zuora Global Support.

 



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