Power BI Connector Pro for Jira - ERROR in refreshing data

Dumisani Mphasane
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 4, 2021

Anyone getting a similar issue when trying to refresh the data from the connector into POWER BI. It doesnt seem to be an issue on Power BI but rather from the integration. 

 

OMI_DATA_OFFICE_JIRA

OLE DB or ODBC error: [DataSource.Error] OData: Request failed: The remote server returned an error: (500) Internal Server Error. ({"ERROR_MESSAGE":"java.util.concurrent.CompletionException: org.h2.jdbc.JdbcBatchUpdateException: Data conversion error converting \"'' (DM_3068192_0: B357 NUMBER(32, 10))\"; SQL statement:\nINSERT INTO DM_3068192_0 (B6,B152,B153,B154,B155,B156,B157,B159,B158,B160,B161,B162,B163,B164,B165,B166,B167,B168,B169,B170,B171,B172,B173,B174,B175,B176,B177,B178,B179,B213,B214,B215,B216,B217,B218,B225,B227,B228,B229,B231,B232,B233,B235,B245,B237,B247,B248,B249,B250,B251,B252,B253,B377,B378,B379,B352,B353,B354,B355,B356,B357,B358,B359,B360,B4,B5,B8,B24,B111,B92,B32,B103,B99,B51,B67,B69,B107,B81,B57,B46,B110,B144,B85,B86,B115,B441,B442,B435,B11,B254,B255,B256,B257,B258,B259,B260,B261,B262,B263,B127,B108,B61,B138,B132,B0,B12 ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) -- (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, ?14, ?15, ?16, ?17, ?18, ?19, ?20, ?21, ?22, ?23, ?24, ?25, ?26, ?27, ?28, ?29, ?30, ?31, ?32, ?33, ?34, ?35, ?36, ?37, ?38, ?39, ?40, ?41, ?42, ?43, ?44, ?45, ?46, ?47, ?48, ?49, ?50, ?51, ?52, ?53, ?54, ?55, ?56, ?57, ?58, ?59, ?60, ?61, ?62, ?63, ?64, ?65, ?66, ?67, ?68, ?69, ?70, ?71, ?72, ?73, ?74, ?75, ?76, ?77, ?78, ?79, ?80, ?81, ?82, ?83, ?84, ?85, ?86, ?87, ?88, ?89, ?90, ?91, ?92, ?93, ?94, ?95, ?96, ?97, ?98, ?99, ?100, ?101, ?102, ?103, ?104, ?105, ?106) [22018-197]\n\tat aio.jira.connector.service.business.IssuesSearchService.handlePageFailure(IssuesSearchService.java:477)\n\tat aio.jira.connector.service.business.IssuesSearchService.lambda$fetchPage$2(IssuesSearchService.java:154)\n\tat java.base/java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1736)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)\n\tat java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)\n\tat java.base/java.lang.Thread.run(Thread.java:829)\nCaused by: org.h2.jdbc.JdbcBatchUpdateException: Data conversion error converting \"'' (DM_3068192_0: B357 NUMBER(32, 10))\"; SQL statement:\nINSERT INTO DM_3068192_0

\

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events