liprec / vsts-release-aas

Repository for my Analysis Service Azure pipelines tasks related to Azure Analysis Service or Power BI Premium
Other
27 stars 28 forks source link

AAS deployment [error]Invalid JSON primitive: xYef5BbaPG. #75

Closed svboca closed 2 years ago

svboca commented 2 years ago

Since the last update (version 1.5.3) AAS deployment fails with the error: [error]Invalid JSON primitive: xYef5BbaPG

liprec commented 2 years ago

Can you share the debug log (variable: System.Debug set to true) to provide me some more details?

svboca commented 2 years ago

tasklog_8.log

liprec commented 2 years ago

Looking at your options, it looks like the password is not enclosed with quotes (") and probably causing this issue. Can you try adding double quotes around your password? And make sure your password doesn't contain any quotes (', ")

svboca commented 2 years ago

Thank you for the prompt reply. This morning I tested the advanced Data Source Type. Now I understand that the security setting should be a 'valid' statement, despite using the None Data Source Type.

So I replaced it with the original value:

[ { "name": "", "authenticationKind": "UsernamePassword", "connectionDetails": { "address": { "server": "", "database": "" } }, "credential": { "Username": "", "Password": "" } } ]

It now runs all fine!

liprec commented 2 years ago

Indeed the task is not looking at the connectionType option anymore. Probably it is better to add this check again to minimize this kind of issues.