SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 41092: An error occurs when you install a Sybase stored procedure on a target Sybase server

DetailsHotfixAboutRate It

Installation of a Sybase stored procedure on a target Sybase server fails with an error similar to the following:

ERROR: Error Code: -2812  Stored procedure 'sp_sasrowcnt' not found.
Specify owner.objectname or use sp_help to check whether the object 
exists (sp_help may produce lots of output)
This error occurs when you perform the instructions in the SAS/ACCESS Interface to Sybase section of the Configuration Guide for SAS® 9.2 Foundation for your platform.

The sas-spcp.txt file, which is discussed in the configuration guide, contains instructions on how to install the stored procedure. This file mentions a second script file called sassp2df.txt. However, saspf2df.txt, which contains the sp_sasrowcnt stored procedure, does not exist. This stored procedure supports SAS application metadata requests from SAS/ACCESS Interface to Sybase.

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS/ACCESS Interface to SybaseMicrosoft Windows Server 2003 Datacenter Edition9.21_M29.2 TS2M3
Microsoft Windows Server 2003 Enterprise Edition9.21_M29.2 TS2M3
Microsoft Windows Server 2003 Standard Edition9.21_M29.2 TS2M3
Microsoft Windows Server 2003 for x649.21_M29.2 TS2M3
Microsoft Windows Server 20089.21_M29.2 TS2M3
Microsoft Windows Server 2008 for x649.21_M29.2 TS2M3
Microsoft Windows XP Professional9.21_M29.2 TS2M3
Windows 7 Enterprise 32 bit9.21_M29.2 TS2M3
Windows 7 Enterprise x649.21_M29.2 TS2M3
Windows 7 Home Premium 32 bit9.21_M29.2 TS2M3
Windows 7 Home Premium x649.21_M29.2 TS2M3
Windows 7 Professional 32 bit9.21_M29.2 TS2M3
Windows 7 Professional x649.21_M29.2 TS2M3
Windows 7 Ultimate 32 bit9.21_M29.2 TS2M3
Windows 7 Ultimate x649.21_M29.2 TS2M3
Windows Vista9.21_M29.2 TS2M3
Windows Vista for x649.21_M29.2 TS2M3
64-bit Enabled AIX9.21_M29.2 TS2M3
64-bit Enabled HP-UX9.21_M29.2 TS2M3
64-bit Enabled Solaris9.21_M29.2 TS2M3
HP-UX IPF9.21_M29.2 TS2M3
Linux9.21_M29.2 TS2M3
Linux for x649.21_M29.2 TS2M3
Solaris for x649.21_M29.2 TS2M3
* 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.