Forum Discussion

jeronimo2334's avatar
jeronimo2334
Helper III
5 years ago
Solved

Mashup Error Tables Union

Hello all,

 

I have 3 tables from the same database. I have merged them through the editor, and it was fine for the longest time.

For some reason, I started getting this error and the scheduled refresh always fails now. I do not recall changing anything on my side so this is baffling. The db is provided by a 3rd party, so I am not sure if they changed something in the table, but I can not tell just by this error.

Any help is appreciated.

 

{
"error": {
"code": "DM_GWPipeline_Gateway_MashupDataAccessError",
"pbi.error": {
"code": "DM_GWPipeline_Gateway_MashupDataAccessError",
"parameters": {},
"details": [
{
"code": "DM_ErrorDetailNameCode_UnderlyingErrorCode",
"detail": {
"type": 1,
"value": "-2147467259"
}
},
{
"code": "DM_ErrorDetailNameCode_UnderlyingErrorMessage",
"detail": {
"type": 1,
"value": "MySQL: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\r\n union all select `_`.`accnt_type` as `accnt_type`,\r\n `_`.`descript' at line 323"
}
},
{
"code": "DM_ErrorDetailNameCode_UnderlyingHResult",
"detail": {
"type": 1,
"value": "-2147467259"
}
},
{
"code": "Microsoft.Data.Mashup.ValueError.DataSourceKind",
"detail": {
"type": 1,
"value": "MySql"
}
},
{
"code": "Microsoft.Data.Mashup.ValueError.DataSourcePath",
"detail": {
"type": 1,
"value": "mksdb.com*******.amazonaws.com;views"
}
},
{
"code": "Microsoft.Data.Mashup.ValueError.ErrorCode",
"detail": {
"type": 1,
"value": "-2147467259"
}
},
{
"code": "Microsoft.Data.Mashup.ValueError.Message",
"detail": {
"type": 1,
"value": "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')\r\n union all select `_`.`accnt_type` as `accnt_type`,\r\n `_`.`descript' at line 323"
}
},
{
"code": "Microsoft.Data.Mashup.ValueError.Reason",
"detail": {
"type": 1,
"value": "DataSource.Error"
}
}
],
"exceptionCulprit": 1
}
}
} Table: Balances.
Need Help
  • jeronimo2334's avatar
    jeronimo2334
    5 years ago

    @Greg_Decklerit appears that one of the columns had an underscore in one of the rows so when I used the append tables option, it broke.

    Would be nice if the append tables option ignored symbols when the column is of a string type (ABC).

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    jeronimo2334 - From the error, it is indicating an issue with MySQL syntax, specifically I would check to see if the accnt_type column has been renamed?

  • jeronimo2334's avatar
    jeronimo2334
    Helper III
    5 years ago

    @Greg_Decklerit appears that one of the columns had an underscore in one of the rows so when I used the append tables option, it broke.

    Would be nice if the append tables option ignored symbols when the column is of a string type (ABC).