Please Help How to fix problem in this pipeline: E_COSMOS_USER_PARSER: [STREAMEXPIRY] is a reserved word,

Question

SageL2Prod - Azure Data Factory E_COSMOS_USER_PARSER: [STREAMEXPIRY] is a reserved word, and cannot be used for a parameter name.  (Perhaps you used the commandline and quoted a parameter value, but didn't escape the quotes, eg -params x="..." instead of -params x="..." ?)... at token [STREAMEXPIRY], line 1 near the ###: ************** ### STREAMEXPIRY **************

Hi, My pipeline has encounter a problem with STREAMEXSPIRY, but I did not find STREAMEXSPIRY definition in anywhere, would you please help to told my how to fix this problem? thanks

Answer 1

Hi @Hualin He,

Thank you for your question on Microsoft Q&A. I understand your problem with the Azure Data Factory pipeline error: "E_COSMOS_USER_PARSER: [STREAMEXPIRY] is a reserved word and cannot be used for a parameter name."

This issue typically arises in Cosmos DB-related activities when a field name like "STREAMEXPIRY" conflicts with the query parser, often due to unescaped property names in SQL queries or parameter passing.

Microsoft Edge does not support Azure Data Factory, but I tried to find some solutions to help you. Here's a brief explanation: Escape the field in your Cosmos DB query using square brackets, e.g., SELECT c["STREAMEXPIRY"] FROM c. If it's a parameter, rename it to avoid conflicts and ensure proper quoting when triggering the pipeline.

For official Microsoft references:

• Azure Cosmos DB query keywords – Lists reserved words and escaping guidance.
• Working with JSON in Cosmos DB queries – Explains escaping properties that might be reserved or special.

If this issue persists, I recommend creating a new question in the Azure forum at here Azure Q&A their team will help you better. If you think this answer can help you resolve the problem, please interact with the answer in the system.