IBM DB : Microsoft DB2 client method not found. SQLSTATE=HY000 SQLCODE=-343

[Anonymous]

Hello,

I'm using Power BI x86 and Microsoft Driver for connecting to IBM DB2 server.

For using connection, I unmarked 2 boxes :

 

I can use a lot of table without problem.

But with one of them, i have the error above :

DataSource.Error : Microsoft Db2 Client : Method not found: 'System.String System.String.Format(System.IFormatProvider, System.String, System.Object)'. SQLSTATE=HY000 SQLCODE=-343
Détails :
    DataSourceKind=DB2
    DataSourcePath=MyServer.prod.MyDomain.fr:50000;MyDB
    Message=Method not found: 'System.String System.String.Format(System.IFormatProvider, System.String, System.Object)'. SQLSTATE=HY000 SQLCODE=-343
   ErrorCode=0

The table structure is this one :

"DATE_KEY" INTEGER NOT NULL ,
"FSC_DIM_WEEK_NUM" INTEGER ,
"CAL_DIM_MONTH_NUM" INTEGER ,
"CAL_DIM_QTR_NUM" INTEGER ,
"CAL_DIM_YEAR_NUM" INTEGER ,
"FSC_DIM_QTR_NUM" INTEGER ,
"FSC_DIM_YEAR_NUM" INTEGER ,
"CAL_MONTH_DAY_NUM" SMALLINT ,
"CAL_YEAR_DAY_NUM" SMALLINT ,
"CAL_DAY_STR" VARCHAR(30) ,
"CAL_DAY_FLAG" VARCHAR(30) ,
"CAL_DAY_DT" DATE ,
"CAL_YEAR_MONTH_NUM" SMALLINT ,
"CAL_MONTH_STR" VARCHAR(30) ,
"CAL_MONTH_START_DT" DATE ,
"CAL_MONTH_END_DT" DATE ,
"CAL_MONTH_FLAG" VARCHAR(30) ,
"CAL_MONTH_END_FLAG" CHAR(1) ,
"CAL_YEAR_QTR_NUM" SMALLINT ,
"CAL_QTR_STR" VARCHAR(30) ,
"CAL_QTR_START_DT" DATE ,
"CAL_QTR_END_DT" DATE ,
"CAL_QTR_FLAG" VARCHAR(30) ,
"CAL_QTR_BEGIN_FLAG" CHAR(1) ,
"CAL_QTR_END_FLAG" CHAR(1) ,
"CAL_MONTH_WEEK_NUM" SMALLINT ,
"CAL_YEAR_WEEK_NUM" SMALLINT ,
"CAL_DIM_WEEK_NUM" INTEGER ,
"CAL_WEEK_STR" VARCHAR(30) ,
"CAL_WEEK_START_DT" DATE ,
"CAL_WEEK_END_DT" DATE ,
"CAL_WEEK_FLAG" VARCHAR(30) ,
"CAL_YEAR_STR" VARCHAR(30) ,
"CAL_YEAR_START_DT" DATE ,
"CAL_YEAR_END_DT" DATE ,
"CAL_YEAR_FLAG" VARCHAR(30) ,
"CAL_DAY_OF_WEEK" VARCHAR(30) ,
"FSC_MONTH_DAY_NUM" DECIMAL(2,0) ,
"FSC_YEAR_DAY_NUM" DECIMAL(3,0) ,
"FSC_DAY_STR" VARCHAR(30) ,
"FSC_MONTH_NUM" SMALLINT ,
"FSC_DIM_MONTH_NUM" INTEGER ,
"FSC_MONTH_STR" VARCHAR(30) ,
"FSC_MONTH_START_DT" DATE ,
"FSC_MONTH_END_DT" DATE ,
"FSC_MONTH_FLAG" VARCHAR(30) ,
"FSC_MONTH_END_FLAG" CHAR(1) ,
"FSC_QTR_NUM" SMALLINT ,
"FSC_QTR_STR" VARCHAR(30) ,
"FSC_QTR_START_DT" DATE ,
"FSC_QTR_END_DT" DATE ,
"FSC_QTR_FLAG" VARCHAR(30) ,
"FSC_QTR_BEGIN_FLAG" CHAR(1) ,
"FSC_QTR_END_FLAG" CHAR(1) ,
"FSC_MONTH_WEEK_NUM" SMALLINT ,
"FSC_YEAR_WEEK_NUM" SMALLINT ,
"FSC_WEEK_STR" VARCHAR(30) ,
"FSC_WEEK_START_DT" DATE ,
"FSC_WEEK_END_DT" DATE ,
"FSC_WEEK_FLAG" VARCHAR(30) ,
"FSC_YEAR_STR" VARCHAR(30) ,
"FSC_YEAR_START_DT" DATE ,
"FSC_YEAR_END_DT" DATE ,
"FSC_YEAR_FLAG" VARCHAR(30) ,
"PAST_FLAG" CHAR(1) ,
"HOLIDAY_FLAG" CHAR(1) ,
"WEEKDAY_FLAG" CHAR(1) ,
"CAL_WORK_DAY_NUM" INTEGER ,
"FSC_WORK_DAY_NUM" INTEGER ,
"ALL_WORK_DAY_NUM" INTEGER ,
"SEASON_TEXT" VARCHAR(254) ,
"EVENT_1_TEXT" VARCHAR(254) ,
"EVENT_2_TEXT" VARCHAR(254) ,
"EVENT_3_TEXT" VARCHAR(254) ,
"EVENT_4_TEXT" VARCHAR(254) ,
"DATE_ATTR1_CODE" VARCHAR(30) ,
"DATE_ATTR1_NAME" VARCHAR(254) ,
"DATE_ATTR2_CODE" VARCHAR(30) ,
"DATE_ATTR2_NAME" VARCHAR(254) ,
"DATE_ATTR3_CODE" VARCHAR(30) ,
"DATE_ATTR3_NAME" VARCHAR(254) ,
"DATE_ATTR4_NAME" VARCHAR(254) ,
"DATE_ATTR5_NAME" VARCHAR(254) ,
"DATE_ATTR6_NAME" VARCHAR(254) ,
"CDC" INTEGER ,
"INVOICE_NUMBER" INTEGER ,
"INVOICE_START_DT" DATE ,
"INVOICE_END_DT" DATE 

Is there something wrong with this one ?

Or maybe into data and not structure ?

Thanks for help,

Alexandre.

[Anonymous]

I have more precision : I have this error only with column in DATE format.

Maybe an error with language connection ?

[Anonymous]

Hi @Anonymous,

Maybe you can take a look at below link which about link to IBM datasoure.

Cannot connect to AS400 via IBM DB2 database

In addition, if you use additional t-sql query to remove date type columns and try again, does this issue appears again?

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

Thanks for the link but i suppose it's about connection problem and not specific data access.

When I add a CAST VARCHAR on DATE columns, I have no more problem.
So problem with data or problem with dirver ?

Thanks,
Alexander.

[Anonymous]

Hi @Anonymous,

>>When I add a CAST VARCHAR on DATE columns, I have no more problem.

If it only appears when you use date type, I think the issue may related to it. Which date format you used to stored these time value? Can you share some sample?

Notice: Current power bi not support to analysis specify timestamp format. If this is a case, I'd like to suggest you convert them to normal date format before import.

Regards,

Xiaoxin Sheng

[Anonymous]

Yes, it's only with DATE type.
You can find above field list of the table, so i think it's DATE format. Field are like '26/11/2017'.

With a view making the cast all is good, but it's odd.