Problem Note 31925: Location Load fails with error "ORA-20001: P_GET_TIME_ID: ORA-01403: no
data found"
When using SAS® Merchandise Data Integration with Oracle, the Location Load fails with the following error:
error ORA-20001: P_GET_TIME_ID: ORA-01403: no data found
This problem occurs when you are using to_date functions while comparing in_time parameters. This problem only occurs when using Oracle; UDB uses the date function while comparing parameters.
Operating System and Release Information
| SAS System | SAS Merchandise Financial Planning and SAS Merchandise In-Season Management | Microsoft® Windows® for x64 | 6.1.2 | 6.1.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Advanced Server | 6.1.2 | 6.1.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Datacenter Server | 6.1.2 | 6.1.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Server | 6.1.2 | 6.1.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Professional | 6.1.2 | 6.1.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows NT Workstation | 6.1.2 | 6.1.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows Server 2003 Datacenter Edition | 6.1.2 | 6.1.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows Server 2003 Enterprise Edition | 6.1.2 | 6.1.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows Server 2003 Standard Edition | 6.1.2 | 6.1.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows XP Professional | 6.1.2 | 6.1.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Windows Vista | 6.1.2 | 6.1.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| 64-bit Enabled AIX | 6.1.2 | 6.1.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| 64-bit Enabled Solaris | 6.1.2 | 6.1.3 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
*
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.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2008-06-30 14:16:05 |
| Date Created: | 2008-04-30 11:18:54 |
