none
Database Experimentation Assistant (DEA) 2.6 issues - localization of analysis database? RRS feed

  • Dotaz

  • Hello,

    I was using DEA 2.6 on the step to try generate the Analysis database (that's the server called “SERVER1” below, which is a Windows 2012 R2 ( Spanish ) + SQL 2016 SP2 Standard Edition (also in Spanish), with a server and system databases collation of “Latin1_General_CI_AS”. 

    After brief seconds it errored out  (log file below)  - but it sucessfully created the database and the tables (all of them are empty)

    The collation for that generated analysis database is “SQL_Latin1_General_CP1_CI_AS”.

    Can anyone please advise on how to further proceed?  I've already asked to deafeedback@microsoft.com about this issue but received no response.

    Regards,

    Alvaro

    --

    DEA Information: 0 : MetricEvent, 11/21/2019 09:36:18, Data: {"IsSuccess":false,"Name":"Duration","StartTime":"2019-11-21T09:36:18.1930819Z","Value":7.666,"Operation":"GetSqlServerConnectionMetaData","Timestamp":"2019-11-21T09:36:18.2000795Z"}

    DEA Information: 0 : DiagnosticEvent, 11/21/2019 09:36:18, Data: {"Message":"Exited GetSqlServerConnectionMetaData","Timestamp":"2019-11-21T09:36:18.2010885Z"}

    DEA Information: 0 : DiagnosticEvent, 11/21/2019 09:36:18, Data: {"Message":"Entered VerifyUserServerRoleName","Timestamp":"2019-11-21T09:36:18.2010885Z"}

    DEA Information: 0 : MetricEvent, 11/21/2019 09:36:18, Data: {"IsSuccess":false,"Name":"Duration","StartTime":"2019-11-21T09:36:18.2010885Z","Value":19.1021,"Operation":"VerifyUserServerRoleName","Timestamp":"2019-11-21T09:36:18.2200732Z"}

    DEA Information: 0 : DiagnosticEvent, 11/21/2019 09:36:18, Data: {"Message":"Exited VerifyUserServerRoleName","Timestamp":"2019-11-21T09:36:18.2200732Z"}

    DEA Information: 0 : DiagnosticEvent, 11/21/2019 09:36:18, Data: {"Message":"Entered PublishDacPac","Timestamp":"2019-11-21T09:36:18.2200732Z"}

    DEA Information: 0 : DiagnosticEvent, 11/21/2019 09:36:18, Data: {"Message":"Setting up Analysis database.","Timestamp":"2019-11-21T09:36:18.221078Z"}

    DEA Information: 0 : DiagnosticEvent, 11/21/2019 09:36:18, Data: {"Message":"SqlPackage.exe not found from the path [C:\\Program Files (x86)\\Microsoft SQL Server\\130\\DAC\\bin\\SqlPackage.exe] specified in the configuration, continuing to search in registry..","Timestamp":"2019-11-21T09:36:18.2220618Z"}

    DEA Information: 0 : DiagnosticEvent, 11/21/2019 09:36:18, Data: {"Message":"SqlPackage.exe found from the Data-Tier Application Framework Installation path [C:\\Program Files\\Microsoft SQL Server\\130\\DAC\\bin\\SqlPackage.exe].","Timestamp":"2019-11-21T09:36:18.2230611Z"}

    DEA Information: 0 : DiagnosticEvent, 11/21/2019 09:36:45, Data: {"Message":"Process C:\\Program Files\\Microsoft SQL Server\\130\\DAC\\bin\\SqlPackage.exe /Action:Publish /SourceFile:\"ExperimentationDatabase.dacpac\" /TargetDatabaseName:\"Analysisee637099257781790918\" /TargetServerName:\"SERVER1\" /Variables:\"DatabaseA\"=\"Aee637099257781790918\" /Variables:\"DatabaseB\"=\"Bee637099257781790918\" /Variables:\"ReportName\"=\"ee\" /Variables:\"DEAVersion\"=\"2.6.61459.2\" /Variables:\"SchemaVersion\"=\"1.3\" /p:BlockOnPossibleDataLoss=False  completed with exit code: 1","Timestamp":"2019-11-21T09:36:45.6235871Z"}

    DEA Information: 0 : DiagnosticEvent, 11/21/2019 09:36:45, Data: {"Message":"Process output: ","Timestamp":"2019-11-21T09:36:45.6235871Z"}

    DEA Information: 0 : DiagnosticEvent, 11/21/2019 09:36:45, Data: {"Message":"Error occurred while running process. Command: \"C:\\Program Files\\Microsoft SQL Server\\130\\DAC\\bin\\SqlPackage.exe /Action:Publish /SourceFile:\"ExperimentationDatabase.dacpac\" /TargetDatabaseName:\"Analysisee637099257781790918\" /TargetServerName:\"SERVER1\" /Variables:\"DatabaseA\"=\"Aee637099257781790918\" /Variables:\"DatabaseB\"=\"Bee637099257781790918\" /Variables:\"ReportName\"=\"ee\" /Variables:\"DEAVersion\"=\"2.6.61459.2\" /Variables:\"SchemaVersion\"=\"1.3\" /p:BlockOnPossibleDataLoss=False\", Error:\"*** Could not deploy package.\r\nError SQL72014: .Net SqlClient Data Provider: Msg 241, Level 16, State 1, Line 22 Error al convertir una cadena de caracteres en fecha y/u hora.\r\nError SQL72045: Script execution error.  The executed script:\r\nDECLARE @SQLBuilds TABLE (\r\n    ProductName                      NVARCHAR (100),\r\n    BuildNumber                      NVARCHAR (50) ,\r\n    ReleaseDate                      DATE          ,\r\n    ServicePackRTM                   NVARCHAR (50) ,\r\n    CumulativeUpdateNumberSecurityId NVARCHAR (50) ,\r\n    EngineEdition                    NVARCHAR (50) );\r\n\r\nINSERT  INTO @SQLBuilds (ProductName, BuildNumber, ReleaseDate, ServicePackRTM, CumulativeUpdateNumberSecurityId, EngineEdition)\r\nVALUES                 (N'SQL Server 2005', N'9.00.5324', '9-Oct-2012', N'SP4', N'MS12-070', '0'),\r\n(N'SQL Server 2005', N'9.00.5292', '14-Jun-2011', N'SP4', N'MS11-049', '0'),\r\n(N'SQL Server 2005', N'9.00.5266', '22-Mar-2011', N'SP4', N'CU3', '0'),\r\n(N'SQL Server 2005', N'9.00.5259', '21-Feb-2010', N'SP4', N'CU2', '0'),\r\n(N'SQL Server 2005', N'9.00.5254', '23-Dec-2010', N'SP4', N'CU1', '0'),\r\n(N'SQL Server 2005', N'9.00.5069', '9-Oct-2012', N'SP4', N'MS12-070', '0'),\r\n(N'SQL Server 2005', N'9.00.5057', '14-Jun-2011', N'SP4', N'MS11-\r\n\r\n\r\n\"","Timestamp":"2019-11-21T09:36:45.6235871Z"}

    DEA Information: 0 : DiagnosticEvent, 11/21/2019 09:36:45, Data: {"Message":"DacPac publishing failed.","Timestamp":"2019-11-21T09:36:45.6245865Z"}

    DEA Information: 0 : MetricEvent, 11/21/2019 09:36:45, Data: {"IsSuccess":true,"Name":"Duration","StartTime":"2019-11-21T09:36:18.221078Z","Value":27405.571600000003,"Operation":"PublishDacPac","Timestamp":"2019-11-21T09:36:45.6245865Z"}

    DEA Error: -2146233088 : ExceptionEvent, 11/21/2019 09:36:45, Data: {"Code":-2146233088,"Message":"Failed to generate new analysis report.","Operation":"AnalysisModel","Properties":{"ProductVersion":"13.0.5026.0","Version":"2.6.61459.2","SchemaVersion":"1.3","CreatedDate":"21/11/2019 10:36:18","IsSchemaUpgradeRequired":"False","ProgressPercentage":"6","ErrorCode":"1004","Id":"042109d3-4507-4b28-baa3-9639e42e8bcb"},"Timestamp":"2019-11-21T09:36:45.6295832Z"}, Exception:

    [Exception Info]:Microsoft.DEA.Common.Exceptions.DeaException, Message:Se produjo una excepción de tipo 'Microsoft.DEA.Common.Exceptions.DeaException'.

     StackTrace:   en Microsoft.DEA.BusinessLogic.Actions.PublishDacPac.Run()

       en Microsoft.DEA.BusinessLogic.ActionDecorator.<>c__DisplayClass2_0.<Run>b__0()

       en System.Threading.Tasks.Task.InnerInvoke()

       en System.Threading.Tasks.Task.Execute()

    --- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---

       en System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

       en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

       en Microsoft.DEA.BusinessLogic.ActionDecorator.<Run>d__2.MoveNext()

    --- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---

       en Microsoft.DEA.BusinessLogic.ActionDecorator.<Run>d__2.MoveNext()

    --- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---

       en System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

       en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

      en System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)

       en Microsoft.DEA.BusinessLogic.Bootstrappers.NewAnalysisXEvents.<RunAsync>d__21.MoveNext()

    --- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---

       en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

       en Microsoft.DEA.BusinessLogic.Bootstrappers.NewAnalysisXEvents.<RunAsync>d__21.MoveNext()

    --- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---

       en System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

       en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

       en Microsoft.DEA.BusinessLogic.BootstrapperFactory.<StartWorkflowAsync>d__37.MoveNext()

    --- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---

       en System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

       en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

       en Microsoft.DEA.BusinessLogic.BootstrapperFactory.<CreateNewAnalysisBootstrapperAsync>d__28.MoveNext()

    --- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---

       en System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

       en System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

       en Microsoft.DEA.UI.ViewModels.MainRegion.NewReportViewModel.<StartNewAnalysisAsync>d__113.MoveNext()


    pátek 22. listopadu 2019 8:27

Všechny reakce

  • Hi AlvaroFernandez,

    This is SQL server forums in English, your error information is in Spanish. May be you can create a thread in SQL server Forums in Spanish. You will get better help there.

    Best regards,
    Cathy 

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    pondělí 25. listopadu 2019 9:23