Hi
As the title suggests i upgraded our Enterprise gateway yesterday (21-11-2017) and everything was running smooth. Now after the upgrade I get this error on our ODBC connection to our DB2 tables.
The key probably lies here:
ODBC: ERROR [08004] [IBM][CLI Driver] SQL1092N "PBIEGWSERVICE" does not have the authority to perform the requested command or operation.
But why does it suddenly needs this? Nothing has changed on the DB2 side.
Hope for some ideas and pointers.
DM.EnterpriseGateway Warning: 0 : 2017-11-21T07:04:12.6869630Z DM.EnterpriseGateway 3e7fc6f3-b5da-43bf-a850-4a5501dfb443 b1cb0629-e351-4412-88fd-fbf16664b71a MGCC b1cb0629-e351-4412-88fd-fbf16664b71a 5BB6016C [DataMovement.PipeLine.MashupCommon] Failed to find referenced data sources. Exception: [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.DataMovementExtensionNotLoadedException: Mashup extension kind is not loaded
TemplateMessage: Mashup extension Odbc does not load into Mashup Engine
GatewayPipelineErrorCode=DM_GWPipeline_UnknownError
ExtensionKind=Odbc
([0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.DataMovementExtensionNotLoadedException.StackTrace:)
at Microsoft.PowerBI.DataMovement.MashupExtensionsDiscovery.MashupExtensionsManager.IsExtensionDQSupported(String extensionKind, String version)
at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()
at System.Linq.Enumerable.Any[TSource](IEnumerable`1 source)
at Microsoft.PowerBI.DataMovement.Pipeline.MashupCommon.MashupUtils.IsDataSourceDQSupported(DbConnection dbConnection)
DM.EnterpriseGateway Information: 0 : 2017-11-21T07:04:12.7025892Z DM.EnterpriseGateway 9470174d-69fc-48b1-af85-7f9b1276f62e e1935ba1-7727-4ffd-80fd-3ecad578536c MGPP e1935ba1-7727-4ffd-80fd-3ecad578536c 3BD77132 [DM.GatewayCore] Deserialized AcknowledgeAsyncPacketRequest, executing
DM.EnterpriseGateway Information: 0 : 2017-11-21T07:04:12.7025892Z DM.EnterpriseGateway 5fd12abd-7b83-415b-87b4-5856769abfd7 e1935ba1-7727-4ffd-80fd-3ecad578536c MGAA e1935ba1-7727-4ffd-80fd-3ecad578536c 2ADBB32F [DM.GatewayCore] Packet index 4 acknowledged for async operation 2835ac36-ac68-438d-b74b-b23951cc3551
DM.EnterpriseGateway Information: 0 : 2017-11-21T07:04:12.7025892Z DM.EnterpriseGateway 5fd12abd-7b83-415b-87b4-5856769abfd7 e1935ba1-7727-4ffd-80fd-3ecad578536c MGAA e1935ba1-7727-4ffd-80fd-3ecad578536c B7071218 [DM.GatewayCore] Deleting spooled packet index 4
DM.EnterpriseGateway Information: 0 : 2017-11-21T07:04:12.7025892Z DM.EnterpriseGateway 5fd12abd-7b83-415b-87b4-5856769abfd7 e1935ba1-7727-4ffd-80fd-3ecad578536c MGAA e1935ba1-7727-4ffd-80fd-3ecad578536c 72544E41 [DM.GatewayCore] Async operation 2835ac36-ac68-438d-b74b-b23951cc3551 transitioned into Closed state
DM.EnterpriseGateway Information: 0 : 2017-11-21T07:04:12.7025892Z DM.EnterpriseGateway 5fd12abd-7b83-415b-87b4-5856769abfd7 e1935ba1-7727-4ffd-80fd-3ecad578536c MGAA e1935ba1-7727-4ffd-80fd-3ecad578536c 4569EF91 [DM.GatewayCore] CleanupPackets - Cancelling in-progress streaming. Current job ID: 2835ac36-ac68-438d-b74b-b23951cc3551
DM.EnterpriseGateway Information: 0 : 2017-11-21T07:04:12.7025892Z DM.EnterpriseGateway 5fd12abd-7b83-415b-87b4-5856769abfd7 e1935ba1-7727-4ffd-80fd-3ecad578536c MGAA e1935ba1-7727-4ffd-80fd-3ecad578536c 0B530450 [DM.GatewayCore] Cleaning up 0 outstanding packets for spooled job 2835ac36-ac68-438d-b74b-b23951cc3551 for state transition to Closed
DM.EnterpriseGateway Error: 0 : 2017-11-21T07:04:12.7025892Z DM.EnterpriseGateway e352accb-98d7-4c1f-8af0-361304961a94 b1cb0629-e351-4412-88fd-fbf16664b71a MGEA b1cb0629-e351-4412-88fd-fbf16664b71a 968596A6 [DM.Pipeline.Common] Non-gateway exception encountered in activity scope: Microsoft.Data.Mashup.MashupValueException (0x80004005): ODBC: ERROR [08004] [IBM][CLI Driver] SQL1092N "PBIEGWSERVICE" does not have the authority to perform the requested command or operation.
at Microsoft.Data.Mashup.ProviderCommon.MashupResource.StartEvaluationAndGetResultSource[T](Int32 timeout)
at Microsoft.Data.Mashup.MashupCommand.EvaluateAndGetSource[T](String commandText, CommandType commandType, Int32 commandTimeout, MashupParameterCollection parameters, String resultTransform, Boolean forColumnInfo, Boolean executeAction)
at Microsoft.Data.Mashup.MashupCommand.ExecuteReader(CommandBehavior commandBehavior, MashupCommandBehavior mashupCommandBehavior)
at Microsoft.PowerBI.DataMovement.Pipeline.MashupCommon.MashupUtils.ExecuteReaderAsync(DbCommand command, ExecuteQueryRequest queryRequest)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass3_1.<<ExecuteAdoQuery>b__1>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__7`1.MoveNext()
DM.EnterpriseGateway Error: 0 : 2017-11-21T07:04:12.7025892Z DM.EnterpriseGateway e352accb-98d7-4c1f-8af0-361304961a94 b1cb0629-e351-4412-88fd-fbf16664b71a MGEA b1cb0629-e351-4412-88fd-fbf16664b71a 19A549F7 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=19, err=MashupValueException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2017-11-21T07:04:12.7025892Z DM.EnterpriseGateway 66a61eac-258d-43d9-b04f-0b6efd48380e b1cb0629-e351-4412-88fd-fbf16664b71a MGEQ b1cb0629-e351-4412-88fd-fbf16664b71a 727CA6CB [DM.Pipeline.Diagnostics] Exception object created [IsBenign=True]: Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessValueException: Mashup expression evaluation error. Reason: .; ErrorShortName: MashupDataAccessValueException[ErrorCode=-2147467259,HResult=-2147467259]/Wrapped(MashupValueException)[ErrorCode=-2147467259,HResult=-2147467259]
DM.EnterpriseGateway Error: 0 : 2017-11-21T07:04:12.7025892Z DM.EnterpriseGateway 66a61eac-258d-43d9-b04f-0b6efd48380e b1cb0629-e351-4412-88fd-fbf16664b71a MGEQ b1cb0629-e351-4412-88fd-fbf16664b71a 8AA61592 [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorCode = <pi>-2147467259</pi>
DM.EnterpriseGateway Error: 0 : 2017-11-21T07:04:12.7025892Z DM.EnterpriseGateway 66a61eac-258d-43d9-b04f-0b6efd48380e b1cb0629-e351-4412-88fd-fbf16664b71a MGEQ b1cb0629-e351-4412-88fd-fbf16664b71a 61FFB6C7 [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingErrorMessage = <pi><pi>ODBC: ERROR [08004] [IBM][CLI Driver] SQL1092N "PBIEGWSERVICE" does not have the authority to perform the requested command or operation.
</pi></pi>
DM.EnterpriseGateway Error: 0 : 2017-11-21T07:04:12.7025892Z DM.EnterpriseGateway 66a61eac-258d-43d9-b04f-0b6efd48380e b1cb0629-e351-4412-88fd-fbf16664b71a MGEQ b1cb0629-e351-4412-88fd-fbf16664b71a 6A5E25DC [DM.Pipeline.Diagnostics] Exception data: DM_ErrorDetailNameCode_UnderlyingHResult = <pi>-2147467259</pi>
DM.EnterpriseGateway Error: 0 : 2017-11-21T07:04:12.7025892Z DM.EnterpriseGateway 66a61eac-258d-43d9-b04f-0b6efd48380e b1cb0629-e351-4412-88fd-fbf16664b71a MGEQ b1cb0629-e351-4412-88fd-fbf16664b71a 93CE041C [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.ValueError.DataSourceKind = <pi>Odbc</pi>
DM.EnterpriseGateway Error: 0 : 2017-11-21T07:04:12.7025892Z DM.EnterpriseGateway 66a61eac-258d-43d9-b04f-0b6efd48380e b1cb0629-e351-4412-88fd-fbf16664b71a MGEQ b1cb0629-e351-4412-88fd-fbf16664b71a 5F2AC8CB [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.ValueError.DataSourcePath = <pi>dsn=DB2P</pi>
DM.EnterpriseGateway Error: 0 : 2017-11-21T07:04:12.7025892Z DM.EnterpriseGateway 66a61eac-258d-43d9-b04f-0b6efd48380e b1cb0629-e351-4412-88fd-fbf16664b71a MGEQ b1cb0629-e351-4412-88fd-fbf16664b71a 7BA84428 [DM.Pipeline.Diagnostics] Exception data: Microsoft.Data.Mashup.ValueError.Reason = <pi>DataSource.Error</pi>
DM.EnterpriseGateway Error: 0 : 2017-11-21T07:04:12.7025892Z DM.EnterpriseGateway 66a61eac-258d-43d9-b04f-0b6efd48380e b1cb0629-e351-4412-88fd-fbf16664b71a MGEQ b1cb0629-e351-4412-88fd-fbf16664b71a B1146229 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=64, err=MashupDataAccessValueException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Error: 0 : 2017-11-21T07:04:12.7025892Z DM.EnterpriseGateway 17f38990-88fa-4070-91bb-647ce37f10ca b1cb0629-e351-4412-88fd-fbf16664b71a MGPE b1cb0629-e351-4412-88fd-fbf16664b71a B1146229 [DM.Pipeline.Common.TracingTelemetryService] Event: FireActivityCompletedWithFailureEvent (duration=64, err=MashupDataAccessValueException, rootcauseErrorEventId=0)
DM.EnterpriseGateway Information: 0 : 2017-11-21T07:04:12.7025892Z DM.EnterpriseGateway 9852ce50-2093-43c0-a003-74eb51bb4f3a b1cb0629-e351-4412-88fd-fbf16664b71a MGPP b1cb0629-e351-4412-88fd-fbf16664b71a 98B1A333 [DM.GatewayCore] Async operation ddcdcfaa-6fc7-4f5f-94cc-fd19147afc05 completed with an error: [0]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.MashupDataAccessValueException: Mashup expression evaluation error. Reason: .
GatewayPipelineErrorCode=DM_GWPipeline_Gateway_MashupDataAccessError
Reason= --->
[1]Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.GatewayPipelineWrapperException: Substituted: MashupValueException:<pi>Microsoft.Data.Mashup.MashupValueException (0x80004005): ODBC: ERROR [08004] [IBM][CLI Driver] SQL1092N "PBIEGWSERVICE" does not have the authority to perform the requested command or operation.
at Microsoft.Data.Mashup.ProviderCommon.MashupResource.StartEvaluationAndGetResultSource[T](Int32 timeout)
at Microsoft.Data.Mashup.MashupCommand.EvaluateAndGetSource[T](String commandText, CommandType commandType, Int32 commandTimeout, MashupParameterCollection parameters, String resultTransform, Boolean forColumnInfo, Boolean executeAction)
at Microsoft.Data.Mashup.MashupCommand.ExecuteReader(CommandBehavior commandBehavior, MashupCommandBehavior mashupCommandBehavior)
at Microsoft.PowerBI.DataMovement.Pipeline.MashupCommon.MashupUtils.ExecuteReaderAsync(DbCommand command, ExecuteQueryRequest queryRequest)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass3_1.<<ExecuteAdoQuery>b__1>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.<ExecuteInActivity>d__7`1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.GatewayProcessor.<>c__DisplayClass3_0.<<ExecuteAdoQuery>b__0>d.MoveNext()</pi>
Any ideas as to what has changed?
