cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

DB2 "Trigger Program" connect error

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

 

1 REPLY 1
Frequent Visitor

Hi @titandave ,

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.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors