[midPoint] Data truncation: Data too long for column 'stringValue'

[Martin Lízner - AMI Praha a.s.]

Hi, I had similar issue and I remember I simply extended column
m_object_ext_string.stringvalue length. In my notes I also found script to
drop and recreate indexes, but Im not sure why I needed this (maybe its
unrelated :-). M.

*MS SQL DB:*
stringValue NVARCHAR(4000) COLLATE database_default NOT NULL,

*Indexes:*
use midpoint
ALTER TABLE dbo.m_object_ext_string
DROP CONSTRAINT PK__m_object__16E81205A52B072E

drop index iExtensionString on m_object_ext_string;
drop index iExtensionStringDef on m_object_ext_string;

GO

create index OBJ_EXT_STRING_eName on m_object_ext_string(eName);
create index OBJ_EXT_STRING_owner_oid on m_object_ext_string(owner_oid);
create index OBJ_EXT_STRING_ownerType on m_object_ext_string(ownerType);

Martin Lízner
solution architect

gsm: [+420] 737 745 571
e-mail: martin.lizner at ami.cz <jmeno.prijmeni at ami.cz>


AMI Praha a.s.
Pláničkova 11
162 00 Praha 6
tel.: [+420] 274 783 239
web: www.ami.cz



[image: AMI Praha a.s.] <http://www.skyidentity.com/>

Textem tohoto e-mailu podepisující neslibuje uzavřít ani neuzavírá za
společnost AMI Praha a.s.
jakoukoliv smlouvu. Každá smlouva, pokud bude uzavřena, musí mít výhradně
písemnou formu.


2017-01-03 16:22 GMT+01:00 Wojciech Staszewski <
wojciech.staszewski at diagnostyka.pl>:

> Another day, another problem...
>
> How to extend StringValue for more than 255 characters, or what schema
> attribute type can I use for text longer than StringValue can support?
>
> The Story (reading not required):
> I want to put every new user (and those, who don't have one) a mail footer
> in our webmail system, it's a field consisting of fullName,
> telephoneNumber, emailAddress + some company data and a line for
> ecologists...
> I configured Scripted SQL connector already, everything works fine except
> this...
> This is something I need to do because we have a company regulations but
> users completely don't care about it... nothing helps: requests, threats...
> ;)
>
> Regards, Wojciech Staszewski
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> http://lists.evolveum.com/mailman/listinfo/midpoint
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20170103/b3812954/attachment.htm>