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

April release broke certain DB2 connections: SQLSTATE HY000 SQLCODE =-379

Yesterday I updated my PBI Desktop to the April release. Then I started getting errors with my IBM DB2 connections. These erros only appear to occur in desktop. and have not affected the version in Service.

Here is the error message from Edit Queries:

 

DataSource.Error: Microsoft Db2 Client: An internal network library error has occurred. A network level syntax error has occurred. SQLSTATE=HY000 SQLCODE=-379
Details:
    DataSourceKind=DB2
    DataSourcePath=[Server];[DB]
    Message=An internal network library error has occurred. A network level syntax error has occurred. SQLSTATE=HY000 SQLCODE=-379
    ErrorCode=0

1 ACCEPTED SOLUTION

Accepted Solutions
jengwt Member
Member

Re: April release broke certain DB2 connections: SQLSTATE HY000 SQLCODE =-379

You go to "Edit Queries" and select the "Data source settings" button on the toolbard. From there, select your data source type, and edit its credentials.

scrnsht.PNG

View solution in original post

5 REPLIES 5
v-jiascu-msft Super Contributor
Super Contributor

Re: April release broke certain DB2 connections: SQLSTATE HY000 SQLCODE =-379

Hi @jengwt,

 

I would suggest you file a support ticket here.

create ATicket

 

Best Regards,

Dale

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

Re: April release broke certain DB2 connections: SQLSTATE HY000 SQLCODE =-379

Turns out that what PBI remembered as my creds for the DB2 connection got scrambled, and I was just having a very hard time trying to get it to use the right set.

@v-jiascu-msft How can I force the "login" window for a query to appear? It only seems like it will show up in certain situations, which I can't seem to define. I'm sure there's just some button I'm missing.

 

There were other things that happened, like certain slicers ceasing to work. I had to finagle them a little bit to get them to start working again, but ultimately, I didn't actually changed anything to get them working again. It could have been the appearance of what we have taken to calling "ghost slicers".

 

I am very confident that these issues were caused by the new release; updates in the software that made the existing content of my reports freak out.

jengwt Member
Member

Re: April release broke certain DB2 connections: SQLSTATE HY000 SQLCODE =-379

You go to "Edit Queries" and select the "Data source settings" button on the toolbard. From there, select your data source type, and edit its credentials.

scrnsht.PNG

View solution in original post

HASSASA New Member
New Member

Re: April release broke certain DB2 connections: SQLSTATE HY000 SQLCODE =-379

Hi,

 

I have been experincng the same error after the jan 2019 update and the solution doesnt seem to work.

 

Did you try another solution?

 

thanks

jengwt Member
Member

Re: April release broke certain DB2 connections: SQLSTATE HY000 SQLCODE =-379

@HASSASA In my case, it was simply a creds issue. Sometimes, PBI changes the way certain types of connections work. For instance, one release broke how PBI interacted with our data gateway, causing all of our reports to go down for about a week until IT found a way around it (which in our case I think involved working with IBM directly).

The point being that this may not be the issue you are having. What are your symptoms? When does the error occur?

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 289 members 2,969 guests