Usage Note 34142: Obtaining an ODBC trace when you use SAS® Merchandise Planning
When you use SAS Merchandise Planning, you can obtain an ODBC trace, as follows:
- On the machine where your SAS Merchandise Planning is installed, navigate to the directory . . .SAS/retail/plan_61/config.
-
Open the odbc.ini file in the vi editor. You should see an entry similar to the following near the bottom of the file:
[ODBC]
IANAAppCodePage=4 ]
Trace=0 ]
InstallDir=.../612/SAS/retail/plan_61/lib/AIX/r64/odbc/lib ]
Driver=.../612/SAS/retail/plan_61/lib/AIX/r64/odbc/lib/odbctrac.so
TraceFile=.../612/SAS/retail/plan_61/logs/odbctrace.out
- In that entry, change Trace=0 to Trace=1.
This change sets up an ODBC trace. Do not set this trace until you are ready to do the test because it will output a lot of error, causing the log to increase. In addition, you might experience slow performance. The log path is available in the TraceFile= parameter shown in the example odbc.ini entry. By default, the log name is odbctrace.out. The errors listed in the log are more descriptive and extensive.
Operating System and Release Information
| SAS System | SAS Merchandise Financial Planning and SAS Merchandise In-Season Management | Microsoft® Windows® for x64 | 6.1.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Advanced Server | 6.1.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Datacenter Server | 6.1.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Server | 6.1.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows 2000 Professional | 6.1.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows NT Workstation | 6.1.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Datacenter Edition | 6.1.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Enterprise Edition | 6.1.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows Server 2003 Standard Edition | 6.1.2 | | 9.1 TS1M3 SP4 | |
| Microsoft Windows XP Professional | 6.1.2 | | 9.1 TS1M3 SP4 | |
| Windows Vista | 6.1.2 | | 9.1 TS1M3 SP4 | |
| 64-bit Enabled AIX | 6.1.2 | | 9.1 TS1M3 SP4 | |
| 64-bit Enabled Solaris | 6.1.2 | | 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.
| Date Modified: | 2009-04-02 15:49:08 |
| Date Created: | 2008-12-08 16:59:48 |
