DB2 "Trigger Program" connect error

[Anonymous]

Good Morning,

I'm able to successfully connect via the built-in DB2 connector (using Microsoft driver, not IBM, and doing Import, not direct Query) to several files on our "DB2 server:Port;database" = "SYSB:446;SYSB".  However, some files throw an error:

DataSource.Error: Microsoft Db2 Client: Trigger program or external routine detected an error. SQLSTATE=38501 SQLCODE=-443 SQLSTATE=HY000 SQLCODE=-343
Details:
DataSourceKind=DB2
DataSourcePath=sysb:446;SYSB
Message=Trigger program or external routine detected an error. SQLSTATE=38501 SQLCODE=-443 SQLSTATE=HY000 SQLCODE=-343
ErrorCode=0

Has anyone run across this particular error having to do with "Trigger program or external routine"?  Any help is greatly appreciated!  Thanks so much...

Dave

[v-msft-pazhen]

Hi @Anonymous ,

What's the version of your Power BI Desktop and Microsft Driver? Could you please update them to latest one if they are not the latest version? And please review the following threads and check whether their solution can help you resolve the problem. Thank you.

Power BI Direct query connection to IBM DB2

IBM DB2 Connection

Best Regards
Rena
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.