Data Insert Failed - SQL Server - ProcessMaker Forum

Data Insert Failed - SQL Server

Forum rules: Please search to see if a question has already asked before creating a new topic. Please don't post the same question in multiple forums.

2 posts
First unread post

2 posts

Data Insert Failed - SQL Server#829513

By ptmi1047 - Fri Sep 17, 2021 5:04 am

- Fri Sep 17, 2021 5:04 am #829513

Hi,

I have an issue to insert data (SQL Server) with more than 200 characters using trigger from PM, it's failed to insert to db, there is no data. I'm using PM 3.2.1-community.

Any suggestions to solve this issue?

Thanks.

Re: Data Insert Failed - SQL Server#829831

By marceloayllon - Sat Apr 02, 2022 3:10 am

- Sat Apr 02, 2022 3:10 am #829831

Hello ptmi1047,

You could verify that in the database, the field where you want to insert the content has more than 200 characters.
You can try: ALTER TABLE t1 ALTER COLUMN c VARCHAR (300); OR TEXT depending on your needs