Composite Index Exception

[rfphill]

I get a constant exception: exception thrown: Exception: Microsoft.Azure.Documents.BadRequestException: Message: {"Errors":["The order by query does not have a corresponding composite index that it can be served from."]}

But there doesn't seem to be any way of telling what that composite index needs to be. I added "type" to the partition key because the app would blow up unless it was defined in the container but that doesn't seem to indicated anywhere either.

[imranmomin]

can you confirm if the composite indexes are created

Hangfire.AzureCosmosDb/src/CosmosDbStorage.cs

Lines 259 to 263 in 6e6b040

	Collection<CompositePath> compositeIndexes = new ()
	{
	new CompositePath { Path = "/name", Order = CompositePathSortOrder.Ascending },
	new CompositePath { Path = "/created_on", Order = CompositePathSortOrder.Ascending }
	};

[siazon]

I had the same problem, after adding the following index, it now works

  "compositeIndexes": [
        [
            {
                "path": "/name",
                "order": "ascending"
            },
            {
                "path": "/created_on",
                "order": "ascending"
            }
        ]
    ]