{tocify} $title={Table of Contents}
Issue
The issue is related to deployment, where I am deploying azure services using yaml files.
After getting prepared with the individual services deploy and paramenters Json file, I tried to run the pipeline , it gave me the below error
"Cannot retrieve the dynamic parameters for the cmdlet. Unexpected end when deserializing object. Path 'parameters', line 98, position 0."
Why it happened
As the error says there are two things to look at
1. dynamic Parameters were not resolved
2. Issue while deserializing object
At runtime the parameters referred in yaml file are actually looked up in the parameters (json file) file and value of it is used .
So to make sure if I haven't missed any of the parameters used , I crosschecked the parameter json file, all the parameters were there.
Still parameter resolution was not happening, why? - because of second point i.e. there was some issue with deserializing object.
First let's understand Serialization and deserialization
Serialization is the process of bringing an object into a form that it can be written on stream. It's the process of converting the object into a form so that it can be stored on a file, database, or memory; or, it can be transferred across the network.
Thus the state of the object is saved so that it can be recreated when needed.
Deserialization is the process of getting back the serialized object so that it can be loaded into memory. It resurrects the state of the object by setting properties, fields etc.
Coming back to error , so the issue was that the parameters.json ( has parameters and it's value) which is stored as JSON file is not getting deserialized.
And the line number mentioned in the error, helped to find the issue -- and it was missing closing braces.
So the file was not a valid JSON, thus the error.
What to do
To fix the issue, added the missing closing brace .
After the correction, services were happily deployed.
To avoid such trivial issue - Always make sure to validate the JSON file (free online validator are available).
Learn More about some more Azure Data Factory errors
- Cannot find the object "xxx" because it does not exist or you do not have permissions.
- The function 'length' expects its parameter to be an array or a string. The provided value is of type 'Object'.
- ErrorCode=UserErrorInvalidColumnMappingColumnCountMismatch,Message=The column count in column mappings is more than the count in source/sink table.
- ErrorCode=UserErrorInvalidColumnMappingColumnNotFound,Column 'xxx' specified in column mapping cannot be found in source data.
- The path 'xxx' specified in the add operation already exists. Please specify a new path
- Cannot create Sql Source. Error: The value of the property 'Value' is invalid for the stored procedure parameter 'XXX'
- Cannot connect to SQL Database:'XXX' . Verify that the instance name is correct
- Cannot open server 'xxx' requested by the login. Client with IP address 'x.x.x.x' is not allowed to access the server
- Operation on target Copy data failed: Failure happened on 'Source' side
