Forum Discussion
Error Message Trying to Hit iSeries DB2
Has anyone encountered the following error? PBI was working then on reboot of machine, this message appeared. Both import and directquery cannot access the live server. Server is up and running and I can access it from all other applications without issue.
DataSource.Error: An error happened while reading data from the provider: 'HISMPCB0002 In BasePrimitiveConverter the SetCodePage method has been called with a invalid codepage: 937.'
Details:
DataSourceKind=DB2
DataSourcePath=x.x.x.x:446;Database
ChuckS After much investigation, I believe there is an issue with the latest version of PBI. I went to the archive Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn and pulled the September version https://download.microsoft.com/download/8/8/0/880BCA75-79DD-466A-927D-1ABF1F5454B0/PBIDesktopSetup-2022-09_x64.exe I was able to connect to the DB2 without issue.
49 Replies
Hi , MA_guy_VER
1. You may try to update the power bi desktop to latest version and try it again,
https://www.microsoft.com/en-us/download/details.aspx?id=58494
2. Please try starting Power BI as Administrator.
For more information, you can refer to :
Power Query IBM Db2 database connector - Power Query | Microsoft Learn
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Just to highlight - it is an issue with the latest version of Power BI Desktop (as of October 24th) - for now you need to roll back to September 2022 to avoid the issue.
I can confirm it is a bug in the Oct 2022 version. I had previosly uninstalled/reinstalled the latest version and ran as administrator, neither worked.
Rolled back to Sept 2022 version and everything worked as normal.
Run as Administrator worked for me. (Did not work, had to install the Sept 2022 version.)
Running as Admin made no difference in my case. Rolling back to Sept 2022 version was the only thing that got me up and running again.
Even is running as Admin worked, this is not a solution. While I am a domain adminstrator so my loging can do pretty much anything, I have many users that do not so this kind of work around would not help then even if it has worked.
Hi, thank you for your solution. The DB2 connection issue is prevented within the Sep 2022 version of PowerBI Desktop. But when I published it, try to set auto refresh schedul, it raises the same error code "HISMPCB0002 In BasePrimitiveConverter the SetCodePage method has been called with a invalid codepage: 937". Would you have any advice on this?
I am a developer who works on the Mashup (aka PowerQuery) engine.
If you contact support for this issue, please tell them it has been opened in ICM#348059006, and in Power Query Bug #945088.
I have attached workaround instructions in both of those places.
I have also placed the workaround steps here: https://1drv.ms/u/s!AoVHHqNdBM4VgQfWbxvB-rZOCWfr?e=amInQA
Has this been fixed yet in the December Update?
There is no December update. The latest version is of November and the issue remains.
Please go to the issue report here Issue with IBM DB2 connector October 2022 release ... - Microsoft Power BI Community
and click on upvote to help us make this vital for Microsoft to include in the next update, thanks.
The currently targeted date for the SU2 release - for both Power BI Desktop, and for the On-Premises Data Gateway - is February 13 2023 according to Microsoft. We shall see. I will give it a spin and report back findings once it is released.
Power BI February 2023 released yesterday has fixed this issue. Hooray!
Where did you find the download? All the links I've used still have the old (Dec) version...
I am getting the exact same error message in PBi Desktop.
working with a dataset that has been in use to a while now. This just started happening.
Edit: Wanted to add that I get the same error message on any dataset that tries to connect to our DB2 datasource.ChuckS v-yueyunzh-msft - I have done the recommended steps and it continues. I have taken my PBI file and migrated it internally to another machine and it works as expected. So, it is related to the machine itself. I do recall a java update and an MS update hitting just before the issue. I have rolled back the java. No change. I am thinking of attacking the OBDC next.
I am using the Microsoft driver instaed of IBM. I will check my MS updates and see it one slipped in resently that I did not notice and report back any findings.
I have the exact same issue as well. Rolling back to Desktop edition September 2022 solved the issue for now.
Hi i updated PBI desktop to october version and now i haveing the same issue "HISMPCB0002 In BasePrimitiveConverter the SetCodePage method has been called with a invalid codepage: 937" with my reports based in the server of JDedwards (DB2).. i can't use Administrator due my laptop is controlled by my company.. I am going to enter a ticket to uninstall the version of Oct. 2022 and install the version of september 2022.. i am not sure how Microsoft release a new version without it...
You would think with the number of financial institution and insurance companies that are DB2 based there would be more consideration and testing when it comes to this database platform.
For now we can only hope the issue is resolved on the Nov 2022 release.
I am having the same issue with excel power query.. any advice??
Looks like the last release 1/10/2023 did not fix the DB2 issue. I still see the same behavior.
I have this problem also (using 32bit version). Rolling back to September is not a solution for me because I don't have the September version!
Hi CathyT - You can click the link on the page for the September version 32bit: Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn
I went to that page already. The link there for the Download Center takes you to the same place where the most recent version is. The digital signature date on the file is 11/11/2022. Which is the October update.
Has this been fixed in a newer version? And which version?
February 2023 version (remember to update the data gateway as well)
