Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
jacj
Frequent Visitor

After upgrade of Enterprise Gateway ODBC DB2 no longer works

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?

1 ACCEPTED SOLUTION
v-yuezhe-msft
Employee
Employee

@jacj,

Based on the above error message, it seems that the Power BI gateway service account( NT SERVICE\PBIEgwService) doesn’t have permission on your data source. Please go to Control Panel >Administrative Tools > Computer Management > System Tools > Local Users and Groups> Groups, then add the NT SERVICE\PBIEgwService account to  DB2USERS or DB2ADMNS group, for more details, please review the following article.

https://www.ibm.com/support/knowledgecenter/SSFPJS_8.5.5/com.ibm.wbpm.admin.doc/topics/rins_trbl_dom...

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-yuezhe-msft
Employee
Employee

@jacj,

Based on the above error message, it seems that the Power BI gateway service account( NT SERVICE\PBIEgwService) doesn’t have permission on your data source. Please go to Control Panel >Administrative Tools > Computer Management > System Tools > Local Users and Groups> Groups, then add the NT SERVICE\PBIEgwService account to  DB2USERS or DB2ADMNS group, for more details, please review the following article.

https://www.ibm.com/support/knowledgecenter/SSFPJS_8.5.5/com.ibm.wbpm.admin.doc/topics/rins_trbl_dom...

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Lydia

 

Thank you for this. We will try this. Any idea as to why this has changed? Why does this behaviour start after the upgrade.

 

/Jacob

@jacj,

Not sure that why the behaviour starts after upgrade unless you have tracked the process of upgrade process.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors