Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,364,976
Community Members
 
Community Events
168
Community Groups

Power BI Connector Pro for Jira - ERROR in refreshing data

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

Atlassian Community Events