Azure function return 500 internal server error when using CosmosDB as the input binding

Question

Azure function return 500 internal server error when using CosmosDB as the input binding

Edward An 0

I am following this exercise for every step and I am getting 500 errors in the response.

The request hasn't even reached the code.

Function.json

{
  "bindings": [
    {
      "authLevel": "function",
      "type": "httpTrigger",
      "direction": "in",
      "name": "req",
      "methods": [
        "get",
        "post"
      ]
    },
    {
      "type": "http",
      "direction": "out",
      "name": "res"
    },
    {
      "name": "inputDocument",
      "direction": "in",
      "type": "cosmosDB",
      "partitionKey": "/id",
      "methods": [],
      "databaseName": "edward",
      "collectionName": "Bookmarks",
      "connectionStringSetting": "wetwertwret_DOCUMENTDB",
      "id": "id"
    }
  ]
}

code User's image

This question is related to the following Learning Module

0 comments

1 answer

Your answer

Answer 1

AmaranS 7,290 Microsoft External Staff

Hi Edward An,

It seems like the error consistently occurs in your HttpStart function due to an undefined extraInputs property. To troubleshoot:

Review the index.js file of HttpStart for extraInputs references.
Verify correct function parameters passed to getClient.
Check the durable functions library docs for usage changes.
Ensure function bindings handle extraInputs properly.
Add logging to track variable values.
Investigate recent code changes.
Monitor Azure Function logs for additional clues.

This approach should help pinpoint and resolve the issue. Let me know if you need further assistance!
If you need more help, feel free to share additional details or code snippets, and I'll do my best to assist you further. I hope the information we provided was helpful to you! If it was, please consider accepting the answer by clicking the Accept Answer/Upvote button. Your feedback is valuable and can assist others with similar questions. Thank you for contributing to improving Microsoft Q&A!

Thank you.

AmaranS 7,290 Reputation points Microsoft External Staff

2024-10-15T03:11:58.1833333+00:00

Hi Edward An,

It seems like there's an issue with the Azure Cosmos DB input binding causing a 500 Internal Server Error when you call the function's URL. Let's troubleshoot this together.

Firstly, let's carefully review the code and configuration of the Azure Cosmos DB input binding you've added.

Here are some steps to help diagnose and fix the problem:

1.Review Function Code: Double-check the JavaScript code in your Azure Function to ensure it correctly handles input from the Cosmos DB binding.

2.Check Binding Configuration: Verify the configuration of the Azure Cosmos DB input binding, including the connection string, database name, container name, document ID, and partition key.

3.Verify Access: Make sure your Azure Function has the necessary permissions to access the Cosmos DB account. Check the access rights and connection string used in the binding.

4.Inspect Function Logs: Look at the logs of your Azure Function for any error messages that might explain the issue more clearly.

5.Test Binding Independently: If possible, test the Azure Cosmos DB input binding separately to confirm it's configured correctly and can retrieve data from the database.

6.Error Handling: Ensure your function code includes proper error handling to deal with potential issues like connection errors or missing documents.

Once you've gone through these steps and identified any problems, you can adjust your setup accordingly to fix the issue.

If you need more help, feel free to share additional details or code snippets, and I'll do my best to assist you further. I hope the information we provided was helpful to you! If it was, please consider accepting the answer by clicking the Accept Answer/Upvote button. Your feedback is valuable and can assist others with similar questions. Thank you for contributing to improving Microsoft Q&A!

Thank you.
AmaranS 7,290 Reputation points Microsoft External Staff

2024-10-16T02:53:31.2333333+00:00

Hi Edward An,

Just checking in to see if you had a chance to see the responses of your question. Please don't hesitate to reach out to us if you have any further queries. I hope the information provided has been helpful to you! If so, please accept the answer by clicking the Accept Answer / Upvote on the post. We value your feedback, and it will help to assist others who might have a similar query. Thank you for your contribution in enhancing Microsoft Q&A!
AmaranS 7,290 Reputation points Microsoft External Staff

2024-10-16T04:45:22.4466667+00:00
Hi Edward An,

Related your trainings the azure functions don't behave as expected: https://learn.microsoft.com/en-us/training/modules/chain-azure-functions-data-using-bindings/5-read-data-with-input-bindings-portal-lab?pivots=javascript

I have Runtime Version ~4 and can not select another value. There are two issues here: 1. When using an inputBinding with AzureCosmosDB NOSQL and the value is not present into the database the function will give an abort and put in the log and error 404 not found but for the HTTP response will raise a 500 Internal Server Error 2. connecting to AzureCosmos using input/output Binding is not correct using the portal way of configuring the bindings (connection and containerName should be present)

For the point 1: "2023-10-03T08:14:18.646 [Error] Executed 'Functions.myHttpTrigger2' (Failed, Id=75ef38cf-d474-41fa-bfab-24f407afbb08, Duration=105ms)Response status code does not indicate success: NotFound (404); Substatus: 0; ActivityId: 0d09d743-fd0d-40a0-bebf-dcfbbae0402e; Reason: (code : NotFoundmessage : Entity with the specified id does not exist in the system. More info: https://aka.ms/cosmosdb-tsg-not-found,RequestStartTime: 2023-10-03T08:14:18.5698536Z," This is the message error when using in the input Json an "in" value that is not present into the AzureCosmosDB

For the point 2: Instead of

{ "name": "inputDocument", "direction": "in", "type": "cosmosDB", "connectionStringSetting": "myfirstazurecosmos_DOCUMENTDB", "databaseName": "inDatabase", "collectionName": "MyCollection", "partitionKey": "{id}" }

You need to have

{ "name": "inputDocument", "direction": "in", "type": "cosmosDB", "connection": "myfirstazurecosmos_DOCUMENTDB", "databaseName": "inDatabase", "containerName": "MyCollection", "partitionKey": "{id}" }

This approach should help pinpoint and resolve the issue. Let me know if you need further assistance! If you need more help, feel free to share additional details or code snippets, and I'll do my best to assist you further. I hope the information we provided was helpful to you! If it was, please consider accepting the answer by clicking the Accept Answer/Upvote button. Your feedback is valuable and can assist others with similar questions. Thank you for contributing to improving Microsoft Q&A!
AmaranS 7,290 Reputation points Microsoft External Staff

2024-10-17T06:27:55.6366667+00:00

Hi Edward An,

Just checking in to see if you had a chance to see the responses of your question. Please don't hesitate to reach out to us if you have any further queries. I hope the information provided has been helpful to you! If so, please accept the answer by clicking the Accept Answer / Upvote on the post. We value your feedback, and it will help to assist others who might have a similar query. Thank you for your contribution in enhancing Microsoft Q&A!

Share via

Azure function return 500 internal server error when using CosmosDB as the input binding

1 answer

Your answer