Hi!
I´m stuck in manipulating interfaces (create, import, duplicate) because any of these actions results in an sql exception:
"com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated."
My work repository is new but contains imported procedures, interfaces, packages, and variables from another one. I´ve also created an modified packages, procedures and variables (not interfaces) within these new work rep, and it worked fine. I ve created it about 3 months ago, but now i have this problem that does not let me even import an interface (as i have already done)
There is also a post (
4372520 where someone has the same problem, and John Goodwin suggest to check the sql code generated and execute it manually in sql management studio. The problem here is that i dont know what is the code to duplicate an interface in odi, and since this is not an execution of an interface or package there is nothing to check in the operator.
Does anyone has an idea of what to do, or where to search in this case?
Thanks in advance.
Nacho.-
Edited by: nacho on Jan 5, 2011 2:43 PM