Forum Discussion

MiquelDespuig's avatar
MiquelDespuig
Frequent Visitor
5 years ago
Solved

Error Oracle ORA-12704 character set mismatch when refreshing dataset

Hello Community!   Since I've installed December 2020 updtade of the On-premise data gateway; a previously working dataset, which was connecting to an Oracle Datasource now throws an error related ...
Need Help
  • MiquelDespuig's avatar
    MiquelDespuig
    4 years ago

    After tinkering a lot with this problem. I've figured out how to avoid the problem and it works flawlessly although I don't really understand why.

    The merge step generated by the power query editor is like so:

    Table.CombineColumns(#"Removed Other Columns",{"IMDSC1", "IMDSC2"},Combiner.CombineTextByDelimiter("", QuoteStyle.None),"Merged")

    You get always this error:

    QuoteStyle.None generated

     

    The QuoteStyle.None function inside the Combiner.CombineTextByDelimiter makes the whole thing fail. If you remove this piece of code like so:

    Table.CombineColumns(#"Removed Other Columns",{"IMDSC1", "IMDSC2"},Combiner.CombineTextByDelimiter(""),"Merged")

    Magic happens:

    QuoteStyle Removed

     You get your data back as you would expect.

    The reason why this is the problem escapes my understanding. On top of that the documentation on these functions is less than ideal. If anyone knows why this happens let me know! I'm now curious ğŸ˜‹

v-easonf-msft's avatar
v-easonf-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, MiquelDespuig 

What  mode is used, directquery or import?

This error looks like the result of inconsistent data types in the table during the query, have you changed any data types of the columns in the oracle table or table name?

 

If the issue occurs only for this specific report , it is suggested to republish the  report to another workspace and reconfigure a new Oracle data source in the gateway.

 

Best Regards,
Community Support Team _ Eason

 

 

 

  • MiquelDespuig's avatar
    MiquelDespuig
    Frequent Visitor
    5 years ago

    Hello v-easonf-msft ,

     

    First sorry for the late answer 😔!

     

    The report is running on Import Mode. I haven't modified the query on the data-source, although I'll make a thorough check for mismatching data-types.

     

    I've also tried to publish the report in my workspace and I got the same error. What a didn't try is to replace the gateway connection with a new one. Oracle connections are kind of tricky and chaning them may bite you, but I'll try anyways.

     

    Thank you!! I'll let you know when finished!

    • ggroszek's avatar
      ggroszek
      New Member
      3 years ago

      In Power Query try this:

      - Right click on your data column

      - Scroll down to 'Transform'

      - Click on 'Clean'