I have not seen this error message before and since it is not referencing any specifc line of code I am assuming it is a restriciton or type mismatch with the SQL update?
However, I don't know where to look for which field may be incorrect?
The error message is:
"org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [UPDATE WS_ENGINEERING_DRAWINGS SET DRAWING_ID = ? WHERE dmsid = ?]; ERROR: value too long for type character varying(20); nested exception is org.postgresql.util.PSQLException: ERROR: value too long for type character varying(20)"
Thanks for anyone who can point to where to look?
Thanks
Bob D.
Solved! Go to Solution.
Solved by gasevsm. Go to Solution.
Bob - I created a case (Case 09416722 if you want to follow up in Subscription Center) so that someone can help you troubleshoot this in more detail.
Thanks!
Michelle
BiggePLM,
Please check the character length for the value you're trying to set on the field 'Drawing Id" in the "Engineering Drawings" workspaces. It seems you are exceeding max length for a Number field type.
Hope this helps,
--
mg
Thank you Autodesk Support (Joe Piggee & gasevsm)
Turns out that I had changed one of the fields that I was using to build the string for the Drawing_ID field to a linked picklist and it was returning the descriptor which made the string longer than the 25 Character limit.
Thanks for the help
Bob D