Posted: 3 Dec 2018 0:51 EST Last activity: 19 Dec 2018 1:48 EST
Trying to Attach a File using OOTB Rules. File is not getting saved and an exception and alert is thrown.
We are trying to upload and save a File(Excel/Word) Document to Work Object. But the it is not getting saved and OBJ-SAVE is failing and this is the error message. There is also a PEGA0040 Alert as well?
Problem writing an instance to the database: code: -302 SQLState: 22001 Message: The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.. SQLCODE=-302, SQLSTATE=22001
Case1: Excel with Size 6MB is getting saved. No Errors
Case2: Word with Size 5MB or 7 MB throwing the above errors.
Please let me know a resolution for this where lies the issue/problem?
We didn't change any of the default file size limits. Due you think this might be because we are trying to update a doc file which has several other doc files inserted into it? (Doc File with 2-3 Doc Files inserted into it). Will pega do any conversion or compression to the attachments? How can we check the Colmn size?