cancel
Showing results for 
Search instead for 
Did you mean: 

New Dataset - FreeHand SQL - GUID NotSupported varbinary

Former Member
0 Kudos

Hi,

I tried to add a new dataset by "FreeHand SQL" in Lumira Desktop 1.27 , but i have a problem reading the GUID (Raw16) from SAP PPM tables.

I just installed MS SQL Driver and the connection to MSSQL 2012 DB works fine... i can see all DB and tables.


Example:  I tried to add and import as dataset the /RPM/item_d table from SAP PPM, but the GUID data type ( RAW16) is not supported ( varbinary data ).

So, it's impossible join table using the GUID. This limitation is totally crazy because the GUID is the key for all PPM tables,

Thanks in advance,

Federico

Accepted Solutions (0)

Answers (2)

Answers (2)

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

although it could be a limitation of the middleware driver you've selected for data access..

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

you need to be contacting Product Support via incident ticket to raise bugs / defects

thank you

H