This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I am trying to run a mongodb script from within my ARM Template and I keep getting this error.
Here is my resource from my template.
"type": "Microsoft.Resources/deployments",
"apiVersion": "2021-04-01",
"name": "createMongoDBSchema",
"dependsOn": [
"[resourceId('Microsoft.DocumentDB/databaseAccounts/mongodbDatabases', parameters('document_db_name'), parameters('environment_type'))]"
],
"properties": {
"mode": "Incremental",
"templateLink": {
"uri": "[parameters('documentdb_schema_script')]",
"contentVersion": "1.0.0.0"
},
"parameters": {
"cosmosDbAccountName": {
"value": "[parameters('document_db_name')]"
},
"mongoDbDatabaseName": {
"value": "[parameters('document_db_name')]"
}
}
}
},
The documentdb_schema_script is a .mongodb file that we have in an azure storage account.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 27%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
It appears that you're encountering a JSON syntax error in your ARM template. The error message "Unexpected character encountered while parsing value" typically indicates that there is an issue with the JSON formatting.
Based on the code snippet you provided, it seems that the issue lies with the trailing comma after the "cosmosDbAccountName" parameter value. In JSON syntax, you should not have a comma after the last item in an object.
To resolve the issue, remove the trailing comma after the "cosmosDbAccountName" parameter value, like this:
json
Copy code
"parameters": {
"cosmosDbAccountName": {
"value": "[parameters('document_db_name')]"
},
"mongoDbDatabaseName": {
"value": "[parameters('document_db_name')]"
}
}
Make sure to validate the rest of your JSON ARM template for any other potential syntax errors. Once you've made the necessary changes, try deploying your template again.
I did not know that the .mongodb file hand to be converted to JSON. I will do that to see if I continue to have the issue. Do you happen to know of a tool that will do the conversion?
I am sorry about the confusion. I only posted the one resource out of my template that is associated with the issue. The comma should be there in my template.
@Anonymous Did you had the chance to check the above reply, Please let us know if you are still facing the same issue?
Regards
Geetha
Hi, @Anonymous Welcome to the Microsoft Q&A forum, Thanks for posting your question.
Looks like this is a JSON syntax issue, I hope you have converted the .mongodb file to a JSON file without any syntax issues, for the above resource can you try removing the trailing comma and give it a try?
Regards
Geetha
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 3%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Hi,
Have you declared the parameters correctly ? I can see both cosmosDbAccountName & mongoDbDatabaseName are assigned to document_db_name. Can you please pin point the exact error message you are getting ?
@Anonymous To convert your .mongodb file to a JSON file, you can refer to this document https://www.mongodb.com/docs/database-tools/mongoexport/
Regards
Geetha
I have changed directions. Instead of doing the above, I am now going to use deployment scripts to run PS scripts to make the connection and create the schema and add seed data. Thanks for your help with this.
@Anonymous Thanks for the quick response, please do let us know if you need any further information.
Happy to help you.
Regards
Geetha