Try the schema update, then if you still have issues I assume its because there is a view involved. Views are read-only, so you wont be able to write information. Theoretically, you may be able to write updates to the MV table as the employee number in the single value table will already exist. Can you confirm you aren’t writing to the single value table (either updating any single value attributes, creating or deleting a record)
It might be worth, for a test, selecting everything from the view into a table as a one off and see if you can write to the table.
If you cant get it working with a view, you could potentially write all single value records to a table before each sync, or maybe re-assess the business requirement😊
Cheers
Danny
-----Original Message-----
From: Discussion for MS IDM tools liks ILM and FIM <[log in to unmask]> On Behalf Of Matthew Slowe
Sent: 29 August 2018 11:38
To: [log in to unmask]
Subject: Re: Export error to SQL Server
On Wed, 2018-08-29 at 10:30 +0000, Daniel Grogan wrote:
> Hi Matthew
>
> * (sorry I have to ask the question)...is this a table, and
> definitely not a view?
Ask all the "stupid questions" you like, this one is confusing me!
The base table is a VIEW to which I don't have write access.
The MV table is a TABLE which I do.
> * Are there any triggers on it?
No.
> * Can you update a record in the single value table, so we just
> get the error on MV updates?
No (will FIM try anyway?! Imports work fine from it)
> * is the Anchor column exactly the same name and schema in both
> tables? (I've seen it before where it was varchar(50) in one and
> varchar(30) in the other)
From what I can see, the base table's anchor (EMPLOYEE_NUMBER) is
varchar(10)
The definition for the table lists the anchor as nvarchar(10) NOT NULL
I've asked the DBA on the other end to modify the table's EMPLOYEE_NUMBER attribute to varchar (from nvarchar) and we'll see if that fixes it. Will let you know!
Thanks,
foo
########################################################################
To unsubscribe from the MICROSOFT-IDENTITY list, click the following link:
https://www.jiscmail.ac.uk/cgi-bin/webadmin?SUBED1=MICROSOFT-IDENTITY&A=1
Given that changes in your requirements may occur, and that final performance will depend on a variety of factors, not all of which are known in detail at this stage, none of the statements in this email constitutes a representation for which Identity Experts (IE) can accept any liability. Any guidance or advice provided should only be binding on IE once further diligence and design are undertaken and a final contract setting out expressly agreed terms and conditions is signed between authorised representatives of our companies
Identity Experts Limited | Registered Office: The Media Centre, 7 Northumberland Street, Huddersfield, HD1 1RL, England | Registered Number: 9002786 | VAT number: GB189003893
This e-mail may contain confidential and/or legally privileged material for the sole use of the intended recipient. If you are not the intended recipient (or authorized to receive for the recipient) please contact the sender by reply e-mail and delete all copies of this message. If you are receiving this message internally within the group of Identity Expert companies, you should consider the contents “CONFIDENTIAL”
########################################################################
To unsubscribe from the MICROSOFT-IDENTITY list, click the following link:
https://www.jiscmail.ac.uk/cgi-bin/webadmin?SUBED1=MICROSOFT-IDENTITY&A=1
|