Forum Discussion

Henrik's avatar
Henrik
New Member
10 years ago

odbc error "Restricted data type attribute violation"

Hello, in Power BI Desktop (Version: 2.36.4434.381 32-bit) I want to connect to an Oracle data base via odbc. I do have an ODBC data source set up, which so far worked fine in any application (Acce...
arify's avatar
arify
Microsoft Employee
10 years ago

Hi Henrik,

 

Can you send us a frown with the traces with this error? (Options > Diagnostics > Enable tracing)

 

Also, does this happen only one of the tables, or all of the tables? What are the column types?

 

Thanks

  • Henrik's avatar
    Henrik
    New Member
    10 years ago

    Hi,

     

    the error occurs with all tables, and as it seems independently of the data type (I tried a very simple table with just 2 character fields).

     

    The log-files are pretty long, here are 3 of the error lines:

     

    DataMashup.Trace Error: 24579 : {"Start":"2016-08-01T06:54:36.0505799Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","InfoType":"SQL_AGGREGATE_FUNCTIONS","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Library.Odbc.Interop.OdbcException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: ERROR [HYC00] [Oracle][ODBC]Optional feature not implemented.\r\nStackTrace:\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcCachingService.OdbcCachingConnection.OdbcFunctionCaching.GetResult[Output](UInt16 input, Func`3 function)\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcCachingService.OdbcCachingConnection.OdbcCachingSqlGetInfo.GetInfoInt32(SQL_INFO infoType)\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcCachingService.OdbcCachingConnection.GetInfoInt32(SQL_INFO infoType)\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcTracingService.OdbcTracingConnection.<>c__DisplayClass7.<GetInfoInt32>b__6(IHostTrace trace)\r\n   at Microsoft.Mashup.Engine1.Library.Common.Tracer.Trace[T](String method, Func`2 func)\r\n\r\n\r\n","ProductVersion":"2.36.4434.381 (PBIDesktop)","ActivityId":"d334675a-9956-42dd-a4ae-b3d2c2c078a3","Process":"Microsoft.Mashup.Container.NetFX40","Pid":4468,"Tid":1,"Duration":"00:00:00.0019135"}

     

    DataMashup.Trace Error: 24579 : {"Start":"2016-08-01T06:54:36.0532620Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","InfoType":"SQL_CONVERT_GUID","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Library.Odbc.Interop.OdbcException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: ERROR [HYC00] [Oracle][ODBC]Optional feature not implemented.\r\nStackTrace:\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcCachingService.OdbcCachingConnection.OdbcFunctionCaching.GetResult[Output](UInt16 input, Func`3 function)\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcCachingService.OdbcCachingConnection.OdbcCachingSqlGetInfo.GetInfoInt32(SQL_INFO infoType)\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcCachingService.OdbcCachingConnection.GetInfoInt32(SQL_INFO infoType)\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcTracingService.OdbcTracingConnection.<>c__DisplayClass7.<GetInfoInt32>b__6(IHostTrace trace)\r\n   at Microsoft.Mashup.Engine1.Library.Common.Tracer.Trace[T](String method, Func`2 func)\r\n\r\n\r\n","ProductVersion":"2.36.4434.381 (PBIDesktop)","ActivityId":"d334675a-9956-42dd-a4ae-b3d2c2c078a3","Process":"Microsoft.Mashup.Container.NetFX40","Pid":4468,"Tid":1,"Duration":"00:00:00.0001716"}

     

    DataMashup.Trace Error: 24579 : {"Start":"2016-08-01T06:54:34.7610881Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","InfoType":"SQL_AGGREGATE_FUNCTIONS","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Library.Odbc.Interop.OdbcException, Microsoft.MashupEngine, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: ERROR [HYC00] [Oracle][ODBC]Optional feature not implemented.\r\nStackTrace:\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcCachingService.OdbcCachingConnection.OdbcFunctionCaching.GetResult[Output](UInt16 input, Func`3 function)\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcCachingService.OdbcCachingConnection.OdbcCachingSqlGetInfo.GetInfoInt32(SQL_INFO infoType)\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcCachingService.OdbcCachingConnection.GetInfoInt32(SQL_INFO infoType)\r\n   at Microsoft.Mashup.Engine1.Library.Odbc.OdbcTracingService.OdbcTracingConnection.<>c__DisplayClass7.<GetInfoInt32>b__6(IHostTrace trace)\r\n   at Microsoft.Mashup

    • arify's avatar
      arify
      Microsoft Employee
      10 years ago

      Hi Henrik,

       

      These are "Optional feature not implemented" errors, it's just the steps we figure out the capabilities of the driver, these exceptions don't matter. Are you sure there wasn't a line with "Restricte​d data type attribute violation" error?

       

      There might be a timing issue with the logs, can you make sure the first thing you do is enabling the traces, and then reproduce the issue, and then close PBI Desktop? There must be a line that says "Restricte​d data type attribute violation".

       

      Also, instead of scanning the trace files, you can just send a frown email to us (click the little down-arrow next to the Smiley on top-left corner, there's a Send A Frown button there), we'll do the scanning for you :)

       

      Thank you very much for helping us!

      Oguz