Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT09523 Status: Geschlossen

SQL0433N WITH UTL_MAIL.SEND_ATTACH_RAW WHEN ATTACHMENT IS LARGER THAN 1MB

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
UTL_MAIL.SEND_ATTACH_RAW can fail with an SQL0433N error when it 
is invoked with an input "attachment" argument that is greater 
than 1MB. 
 
Example: 
 
>db2 "call 
utl_mail.send_attach_raw('test@ibm.com','test@ibm.com',null,null 
,'my attachment','my message',null,null, (select blobcol from 
mytbl fetch first row only),null,'application/pdf','test.pdf')" 
 
SQL0433N  Value 
"JVBERi0xLjMNJeLjz9MNCjI5MTMgMCBvYmoNPDwgDS9MaW5lYXJpemVkIDEg" 
is too long.  SQLSTATE=22001 
 
 
This is despite the fact that our documentation states that an 
attachment can be at least 10MB in length. 
http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com. 
ibm.db2.luw.apdv.sqlpl.doc/doc/r0055178.html
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5, Fix Pack 7                      * 
****************************************************************
Local-Fix:
n/a
Lösung
First fixed in DB2 Version 10.5, Fix Pack 7
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
17.06.2015
01.02.2016
01.02.2016
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.7 FixList