Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

CreateAzureDW.sql not working #14

Closed
skalingclouds opened this issue Feb 27, 2018 · 1 comment
Closed

CreateAzureDW.sql not working #14

skalingclouds opened this issue Feb 27, 2018 · 1 comment

Comments

@skalingclouds
Copy link

skalingclouds commented Feb 27, 2018

When executing the build script in powershell, it errors at the SQL DW Schema build. Error from Powershell below

"
Invoke-Sqlcmd : Parse error at line: 9, column: 1: Incorrect syntax near 'DimDate'.
At C:\Users\chris\azure\adflab\Deployment\LabDeploy.ps1:100 char:1
Invoke-Sqlcmd -inputFile "CreateAzureDW.sql" -ServerInstance "$sqlSer ...

CategoryInfo          : InvalidOperation: (:) [Invoke-Sqlcmd], SqlPowerShellSqlExecutionException
FullyQualifiedErrorId : SqlError,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand

Invoke-Sqlcmd : Parse error at line: 110, column: 1: Incorrect syntax near 'END'.
At C:\Users\chris\azure\adflab\Deployment\LabDeploy.ps1:100 char:1
Invoke-Sqlcmd -inputFile "CreateAzureDW.sql" -ServerInstance "$sqlSer ...

CategoryInfo : InvalidOperation: (:) [Invoke-Sqlcmd], SqlPowerShellSqlExecutionException
FullyQualifiedErrorId : SqlError,Microsoft.SqlServer.Management.PowerShell.GetScriptCommand"
"

Tried executing in SQL, first few lines of error are here:

"Msg 15151, Level 16, State 1, Line 4
Cannot alter the role 'largerc', because it does not exist or you do not have permission.
Msg 102, Level 15, State 1, Line 32
Incorrect syntax near 'DISTRIBUTION'.
Msg 102, Level 15, State 1, Line 52
Incorrect syntax near 'DISTRIBUTION'. "

@kromerm
Copy link
Owner

kromerm commented Feb 28, 2018

Checking to see if the previously reported fixes address this

@kromerm kromerm closed this as completed Feb 28, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants