Problem Note 39051: Generating metadata for a Netezza database in SAS® Customer Intelligence returns errors
When you use an SQL procedure (PROC SQL) to generate metadata for a Netezza database in SAS Customer Intelligence, the following errors might occur:
java.lang.Exception: wrap[com.sas.iquery.intelligentquery.
IntelligentQueryException]: Multiple data items used in a business query have the same resultset ID.
All data items used as result items within a business DataSelection.isValid() returned false for the DataSelection
(reasons printed above).
at com.sas.iquery.strategies.sas.oma.AbstractStrategy.getPhysicalQuery(AbstractStrategy.java:127)
at com.sas.iquery.strategies.sas.oma.relational.RelationalStrategy.get AbstractStrategyPhysicalQuery(RelationalStrategy.java:107)
at com.sas.iquery.strategies.sas.oma.relational.RelationalStrategy.access$100(RelationalStrategy.java:37)
at com.sas.iquery.strategies.sas.oma.relational.RelationalStrategy$SQLStrategy.getPhysicalQuery(RelationalStrategy.java:192)
at com.sas.iquery.strategies.sas.oma.relational.RelationalStrategy.getPhysicalQuery(RelationalStrategy.java:102)
at com.sas.iquery.dataretrieval.SimpleQueryConnector.getPhysicalQuery(SimpleQueryConnector.java:277)
at com.sas.analytics.crm.custdata.datapattern.DiscreteSqlMetadataTable.addVariableMetadata(DiscreteSqlMetadataTable.java:184)
To avoid this problem, use the PROC SUMMARY method to generate metadata in SAS Customer Intelligence. Alternatively, you can use the extended attribute OutputColumnName in the MAInformationMap and use the PROC SQL method to generate SAS Customer Intelligence metadata.
Operating System and Release Information
| SAS System | SAS Marketing Automation | Windows 7 Ultimate 32 bit | 5.3 | 6.1 | | 9.3 TS1M0 |
| Windows 7 Professional x64 | 5.3 | 6.1 | | 9.3 TS1M0 |
| Windows 7 Professional 32 bit | 5.3 | 6.1 | | 9.3 TS1M0 |
| Windows 7 Home Premium x64 | 5.3 | 6.1 | | 9.3 TS1M0 |
| Windows 7 Home Premium 32 bit | 5.3 | 6.1 | | 9.3 TS1M0 |
| Windows 7 Enterprise x64 | 5.3 | 6.1 | | 9.3 TS1M0 |
| Windows 7 Enterprise 32 bit | 5.3 | 6.1 | | 9.3 TS1M0 |
| Microsoft Windows XP Professional | 5.3 | 6.1 | | 9.3 TS1M0 |
| Microsoft Windows Server 2008 | 5.3 | 6.1 | | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 5.3 | 6.1 | | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 5.3 | 6.1 | | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 5.3 | 6.1 | | 9.3 TS1M0 |
| Microsoft Windows XP 64-bit Edition | 5.3 | 6.1 | | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 5.3 | 6.1 | | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 5.3 | 6.1 | | 9.3 TS1M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 5.3 | 6.1 | | 9.3 TS1M0 |
| Windows 7 Ultimate x64 | 5.3 | 6.1 | | 9.3 TS1M0 |
| Windows Vista | 5.3 | 6.1 | | 9.3 TS1M0 |
| 64-bit Enabled AIX | 5.3 | 6.1 | | 9.3 TS1M0 |
| 64-bit Enabled HP-UX | 5.3 | 6.1 | | 9.3 TS1M0 |
| 64-bit Enabled Solaris | 5.3 | 6.1 | | 9.3 TS1M0 |
| HP-UX IPF | 5.3 | 6.1 | | 9.3 TS1M0 |
| Linux | 5.3 | 6.1 | | 9.3 TS1M0 |
*
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.
Using the PROC SQL method to generate SAS Customer Intelligence metadata for a Netezza database returns a Java error.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2011-04-26 16:00:48 |
| Date Created: | 2010-03-16 14:38:50 |
