My Products
Help
Robert_ITX
CONTRIBUTOR **

Issue with big associate query

by Robert_ITX

I get an error on a big associate query with several joinups and joindowns of different associates. It seems I have reached some sort of limit, because if I remove a few fields it works. Error message is just the following:

{
	"errors": [
		{
			"message": "Error executing document.",
			"extensions": {
				"code": "INVALID_OPERATION",
				"codes": [
					"INVALID_OPERATION"
				]
			}
		}
	]
}

 

Query that doesn't work:

query VBNxtGetAssociatesQuery($companyId: Int!, $customerId: Int!, $associatesLimit: Int!, $endCursor: String) {
  useCompany(no: $companyId) {
    associate(
      filter: {_and: [{customerNo: {_eq: $customerId}}]}
      after: $endCursor
      unoptimized: true
      first: $associatesLimit
    ) {
      totalCount
      pageInfo {
        hasNextPage
        hasPreviousPage
        startCursor
        endCursor
      }
      items {
        associateNo
        privatePerson
        employeeNo
        customerNo
        supplierNo
        invoiceCustomerNo
        sendToAssociateNo
        sendInToAssociateNo
        contactFor
        seller
        name
        companyNo
        webPage1
        webPage2
        title
        phone
        fax1
        mobilePhone
        memoFileName
        customerPriceGroup1
        customerPriceGroup2
        group1
        group2
        emailAddress
        addressLine1
        addressLine2
        postCode
        postalArea
        addressLine3
        addressLine4
        visitPostCode
        visitPostalArea
        countryNo
        currencyNo
        creditLimit
        creditDenied
        createdDateTime
        changedDateTime
        joinup_Country {
          countryNo
          name
          isoCode
          companyRate
          privateRate
          minInterestPerTransactions
          interestFee
          defaultTaxCode
        }
        joinup_Associate_via_Seller {
          associateNo
          privatePerson
          employeeNo
          customerNo
          supplierNo
          invoiceCustomerNo
          sendToAssociateNo
          sendInToAssociateNo
          contactFor
          seller
          name
          companyNo
          webPage1
          webPage2
          title
          phone
          fax1
          mobilePhone
          memoFileName
          customerPriceGroup1
          customerPriceGroup2
          group1
          group2
          emailAddress
          addressLine1
          addressLine2
          postCode
          postalArea
          addressLine3
          addressLine4
          visitPostCode
          visitPostalArea
          countryNo
          currencyNo
          creditLimit
          creditDenied
          createdDateTime
          changedDateTime
        }
        joinup_Associate_via_ContactFor {
          associateNo
          privatePerson
          employeeNo
          customerNo
          supplierNo
          invoiceCustomerNo
          sendToAssociateNo
          sendInToAssociateNo
          contactFor
          seller
          name
          companyNo
          webPage1
          webPage2
          title
          phone
          fax1
          mobilePhone
          memoFileName
          customerPriceGroup1
          customerPriceGroup2
          group1
          group2
          emailAddress
          addressLine1
          addressLine2
          postCode
          postalArea
          addressLine3
          addressLine4
          visitPostCode
          visitPostalArea
          countryNo
          currencyNo
          creditLimit
          creditDenied
          createdDateTime
          changedDateTime
        }
        joinup_Associate_via_InvoiceCustomer {
          associateNo
          privatePerson
          employeeNo
          customerNo
          supplierNo
          invoiceCustomerNo
          sendToAssociateNo
          sendInToAssociateNo
          contactFor
          seller
          name
          companyNo
          webPage1
          webPage2
          title
          phone
          fax1
          mobilePhone
          memoFileName
          customerPriceGroup1
          customerPriceGroup2
          group1
          group2
          emailAddress
          addressLine1
          addressLine2
          postCode
          postalArea
          addressLine3
          addressLine4
          visitPostCode
          visitPostalArea
          countryNo
          currencyNo
          creditLimit
          creditDenied
          createdDateTime
          changedDateTime
        }
        joindown_Associate_via_SendToAssociate {
          totalCount
          items {
            associateNo
            privatePerson
            employeeNo
            customerNo
            supplierNo
            invoiceCustomerNo
            sendToAssociateNo
            sendInToAssociateNo
            contactFor
            seller
            name
            companyNo
            webPage1
            webPage2
            title
            phone
            fax1
            mobilePhone
            memoFileName
            customerPriceGroup1
            customerPriceGroup2
            group1
            group2
            emailAddress
            addressLine1
            addressLine2
            postCode
            postalArea
            addressLine3
            addressLine4
            visitPostCode
            visitPostalArea
            countryNo
            currencyNo
            creditLimit
            creditDenied
            createdDateTime
            changedDateTime
          }
        }
        joindown_Associate_via_SendInToAssociate {
          totalCount
          items {
            associateNo
            privatePerson
            employeeNo
            customerNo
            supplierNo
            invoiceCustomerNo
            sendToAssociateNo
            sendInToAssociateNo
            contactFor
            seller
            name
            companyNo
            webPage1
            webPage2
            title
            phone
            fax1
            mobilePhone
            memoFileName
            customerPriceGroup1
            customerPriceGroup2
            group1
            group2
            emailAddress
            addressLine1
            addressLine2
            postCode
            postalArea
            addressLine3
            addressLine4
            visitPostCode
            visitPostalArea
            countryNo
            currencyNo
            creditLimit
            creditDenied
            createdDateTime
            changedDateTime
          }
        }
      }
    }
  }
}

Response:
{
	"errors": [
		{
			"message": "Error executing document.",
			"extensions": {
				"code": "INVALID_OPERATION",
				"codes": [
					"INVALID_OPERATION"
				]
			}
		}
	]
}

 

Query that works (removed 4 fields from the query above):

query VBNxtGetAssociatesQuery($companyId: Int!, $customerId: Int!, $associatesLimit: Int!, $endCursor: String) {
  useCompany(no: $companyId) {
    associate(
      filter: {_and: [{customerNo: {_eq: $customerId}}]}
      after: $endCursor
      unoptimized: true
      first: $associatesLimit
    ) {
      totalCount
      pageInfo {
        hasNextPage
        hasPreviousPage
        startCursor
        endCursor
      }
      items {
        associateNo
        privatePerson
        employeeNo
        customerNo
        supplierNo
        invoiceCustomerNo
        sendToAssociateNo
        sendInToAssociateNo
        contactFor
        seller
        name
        companyNo
        webPage1
        webPage2
        title
        phone
        fax1
        mobilePhone
        memoFileName
        customerPriceGroup1
        customerPriceGroup2
        group1
        group2
        emailAddress
        addressLine1
        addressLine2
        postCode
        postalArea
        addressLine3
        addressLine4
        visitPostCode
        visitPostalArea
        countryNo
        currencyNo
        creditLimit
        creditDenied
        createdDateTime
        changedDateTime
        joinup_Country {
          countryNo
          name
          isoCode
          companyRate
          privateRate
          minInterestPerTransactions
          interestFee
          defaultTaxCode
        }
        joinup_Associate_via_Seller {
          associateNo
          privatePerson
          employeeNo
          customerNo
          supplierNo
          invoiceCustomerNo
          sendToAssociateNo
          sendInToAssociateNo
          contactFor
          seller
          name
          companyNo
          webPage1
          webPage2
          title
          phone
          fax1
          mobilePhone
          memoFileName
          customerPriceGroup1
          customerPriceGroup2
          group1
          group2
          emailAddress
          addressLine1
          addressLine2
          postCode
          postalArea
          addressLine3
          addressLine4
          visitPostCode
          visitPostalArea
          countryNo
          currencyNo
          creditLimit
          creditDenied
          createdDateTime
          changedDateTime
        }
        joinup_Associate_via_ContactFor {
          associateNo
          privatePerson
          employeeNo
          customerNo
          supplierNo
          invoiceCustomerNo
          sendToAssociateNo
          sendInToAssociateNo
          contactFor
          seller
          name
          companyNo
          webPage1
          webPage2
          title
          phone
          fax1
          mobilePhone
          memoFileName
          customerPriceGroup1
          customerPriceGroup2
          group1
          group2
          emailAddress
          addressLine1
          addressLine2
          postCode
          postalArea
          addressLine3
          addressLine4
          visitPostCode
          visitPostalArea
          countryNo
          currencyNo
          creditLimit
          creditDenied
          createdDateTime
          changedDateTime
        }
        joinup_Associate_via_InvoiceCustomer {
          associateNo
          privatePerson
          employeeNo
          customerNo
          supplierNo
          invoiceCustomerNo
          sendToAssociateNo
          sendInToAssociateNo
          contactFor
          seller
          name
          companyNo
          webPage1
          webPage2
          title
          phone
          fax1
          mobilePhone
          memoFileName
          customerPriceGroup1
          customerPriceGroup2
          group1
          group2
          emailAddress
          addressLine1
          addressLine2
          postCode
          postalArea
          addressLine3
          addressLine4
          visitPostCode
          visitPostalArea
          countryNo
          currencyNo
          creditLimit
          creditDenied
          createdDateTime
          changedDateTime
        }
        joindown_Associate_via_SendToAssociate {
          totalCount
          items {
            associateNo
            privatePerson
            employeeNo
            customerNo
            supplierNo
            invoiceCustomerNo
            sendToAssociateNo
            sendInToAssociateNo
            contactFor
            seller
            name
            companyNo
            webPage1
            webPage2
            title
            phone
            fax1
            mobilePhone
            memoFileName
            customerPriceGroup1
            customerPriceGroup2
            group1
            group2
            emailAddress
            addressLine1
            addressLine2
            postCode
            postalArea
            addressLine3
            addressLine4
            visitPostCode
            visitPostalArea
            countryNo
            currencyNo
            creditLimit
            creditDenied
            createdDateTime
            changedDateTime
          }
        }
        joindown_Associate_via_SendInToAssociate {
          totalCount
          items {
            associateNo
            privatePerson
            employeeNo
            customerNo
            supplierNo
            invoiceCustomerNo
            sendToAssociateNo
            sendInToAssociateNo
            contactFor
            seller
            name
            companyNo
            webPage1
            webPage2
            title
            phone
            fax1
            mobilePhone
            memoFileName
            customerPriceGroup1
            customerPriceGroup2
            group1
            group2
            emailAddress
            addressLine1
            addressLine2
            postCode
            postalArea
            addressLine3
            addressLine4
            visitPostCode
            visitPostalArea
            createdDateTime
            changedDateTime
          }
        }
      }
    }
  }
}

 

1 REPLY 1
Accepted solution
Robert_ITX
CONTRIBUTOR **

by Robert_ITX

Seems like it was a temporary issue. Working fine now.