I am trying to create a read only table by following the instructions on [1]. OI constantly is throwing an error windows stating that "The first column is being used as primary key. It has to be a uid column".
in My Query there is a first column that is suited ti be a primary key, but the error window is thrown nevertheless.
How do i have to form the query to satisfy the wizard?
[1]
Welcome to the age of AI well copilot helped me in this issue and it could get a hack for this issue using below finding
It is not enough that:
UID_OneIM requires that:
**The UID column must be of type nvarchar(38) or char(38)AND must be explicitly cast to that format.**
By default, NEWID() returns a uniqueidentifier type, which OneIM does not accept as a UID field in a view.
sample query
SELECT
CAST(NEWID() AS CHAR(38)) AS UID_CCCCostCenter,
CCC_CostCenter
FROM (
SELECT CCC_CostCenter
FROM CCCSFEmployment
WHERE ISNULL(CCC_CostCenter, '') <> ''
UNION
SELECT CCC_CostCenter
FROM CCCSFPosition
WHERE ISNULL(CCC_CostCenter, '') <> ''
) AS CC;