SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 14725: SAS Email Server unable to use JDBC to access DB2, MYSQL or Oracle

DetailsHotfixAboutRate It
The SAS Email Server is unable to use JDBC to connect to Oracle, MYSql
or DB2 when creating audit records. The system will produce an error
similar to:

[NOTE@2005-02-09 20:53:40.323] Starting execution of "Static Test
Broadcast" broadcast (Moniker="Broadcast_1107974957751").
[NOTE@2005-02-09 20:53:40.433] Reading [NL19467.CONTACT_DETAILS].
com.ibm.db2.jcc.b.SqlException: Invalid operation: result set closed
        at com.ibm.db2.jcc.b.rc.mb(rc.java:3413)
        at com.ibm.db2.jcc.b.rc.q(rc.java:1339)
        at com.ibm.db2.jcc.b.rc.getMetaData(rc.java:1331)
        at com.sas.email.render.RenderUtils.convertDataToXML(Unknown
Source)
        at com.sas.email.render.RenderData.getObservations(Unknown
Source)
        at com.sas.email.server.BulkEmailStaticExecution.run(Unknown
Source)
[NOTE@2005-02-09 20:53:40.523] Done executing "Static Test Broadcast"

A fix for this issue is available at:

http://www.sas.com/techsup/download/hotfix/bes112.html#014725


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Digital MarketingMicrosoft Windows XP Professional1.1.22.19.1 TS1M39.1 TS1M3 SP2
Microsoft Windows 2000 Professional1.1.22.19.1 TS1M39.1 TS1M3 SP2
Microsoft Windows 2000 Server1.1.22.19.1 TS1M39.1 TS1M3 SP2
Microsoft Windows NT Workstation1.1.22.19.1 TS1M39.1 TS1M3 SP2
Microsoft Windows 2000 Datacenter Server1.1.22.19.1 TS1M39.1 TS1M3 SP2
Linux1.1.22.19.1 TS1M39.1 TS1M3 SP2
Microsoft Windows 2000 Advanced Server1.1.22.19.1 TS1M39.1 TS1M3 SP2
HP-UX1.1.22.19.1 TS1M39.1 TS1M3 SP2
64-bit Enabled HP-UX1.1.22.19.1 TS1M39.1 TS1M3 SP2
64-bit Enabled AIX1.1.22.19.1 TS1M39.1 TS1M3 SP2
AIX1.1.22.19.1 TS1M39.1 TS1M3 SP2
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.