Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
Community showcase
Published in Apps & Integrations

Send an Email or Publish to Confluence - What should you do with your release notes?

Background When you hear the words ‘Release notes’, almost always you think of an unsolicited email from a software vendor. But I am here to tell you that from our data, sending release notes via E...

37 views 0 1
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you