Problem Note 44795: Tests of a decision diagram or campaign fail when the diagram uses a data process for data in DB2
 |  |  |  |  |
SAS® Real-Time Decision Manager enables you to create decision diagrams and campaigns that use JDBC connections to your database. If that database is DB2, then any process node that attempts to get access to the database fails. The following error is written in the SASMarketingAutomationCoreyour-release.log when the problem occurs:
<ExceptionMessage>com.ibm.db2.jcc.am.io: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=CUSTOMER1.CLIENTID, DRIVER=3.57.82</ExceptionMessage><ExceptionMessage>DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=CUSTOMER1.CLIENTID, DRIVER=3.57.82</ExceptionMessage>
The following error is written in the SASDecisionServicesDesignServeryour-release.log:
2011-10-11 13:45:23,586 WARN c0a6e7c96af32862:-7dd1b7b2:132ef991df7:73d5 c0a6e7c96af32862:-7dd1b7b2:132ef991df7:73d5 com.sas.rtdm.implementation.TestExecutor - Execution faulted: Activity Node name: PGCL1BPH5WBKYAAD_2, Activity name: GeneralIO, Activity Method name: SCReadTable, Input parameters: G_IO_libraryName = ... com.sas.analytics.ph.RTDMException: com.ibm.db2.jcc.am.io: DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703, SQLERRMC=CUSTOMER1.CLIENTID, DRIVER=3.57.82 at com.sas.rtdm.implementation.TableCacheJDBCLoader.select(TableCacheJDBCLoader.java:60) ... com.sas.rtdm.implementation.TableCacheJDBCLoader.select(TableCacheJDBCLoader.java:51)
A workaround is not available for this issue.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Real-Time Decision Manager | Microsoft® Windows® for x64 | 5.4_M1 | 6.1 | 9.2 TS2M0 | |
| 64-bit Enabled AIX | 5.4_M1 | 6.1 | 9.2 TS2M0 | |||
| 64-bit Enabled Solaris | 5.4_M1 | 6.1 | 9.2 TS2M0 | |||
| Linux for x64 | 5.4_M1 | 6.1 | 9.2 TS2M0 | |||
| Solaris for x64 | 5.4_M1 | 6.1 | 9.2 TS2M0 | |||
A fix for this issue for SAS Marketing Automation 5.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/E88.html#44795| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2011-11-14 13:02:30 |
| Date Created: | 2011-11-03 15:24:55 |