Hi All,
I'm getting an error when I'm trying to write multiple rows to the database at the same time. When I only give one item to the process variable it works just fine, but when is multiple it throws this error. Details: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement: org.hibernate.exception.SQLGrammarException: could not execute statement: com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated in table .
I have everything correctly set up to accept multiple already, such as the process variable and the write to database smart service.
any ideas of what could it be?
Discussion posts and replies are publicly visible
Hi Maria,
I guess You're trying to write more data than a specific column can store. Check the sizes of the data you're trying to insert against the sizes of each of the fields in the database you declared.
Hi! yes it was, thanks !