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?
Accepted Solution
Coforge DPA
GB
Hi
The error code mentioned is because of size:
SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null. This error is the DB2 cryptic way of informing you that a value which an insert query tries to insert in a table is too large
Sometime the size may differ when pega converts the attachment and try to save.
There must a setting in the code which checks the max size before saving the attachment. Can you check the value ? Ideally you should be able to save upto 25MB of attachment.
Regards
Bhavya
Anthem
US
Bhavya,
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?
Please see Error Code Description Below:
https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/codes/src/tpc/n302.html
SQLSTATE:
22003 if number too large for target; 22001 otherwise.