Skip to Content
Former Member
May 29, 2016 at 05:11 AM

Analyze Capture fails in Workload Analyzer



I am using free 64-bit SAP ASE-16_0 SP02 Developer Edition (with SAP COCKPIT-4 option installed) on x86_64 Fedora-23 (kernel-4.4.9, glibc-2.22). The exact ASE version string is

Adaptive Server Enterprise/16.0 SP02 PL02/EBF 25320 SMP/P/x86_64/Enterprise Linux/ase160sp02plx/2492/64-bit/FBO/Sat Nov 21 04:05:39 2015

Everything works fine and extremely fast and SAP COCKPIT-4 is a great interface. Unfortunately there is a problem with Workload Analyzer. It works fine and captures workloads correctly, but when it comes to analyzing a capture – the analyze fails, although all the prerequisites are satisfied (16 KB server, utf-8 server charset, 16 GB sybcatdb database on two separate devices [8 GB data + 8 GB log], as well as all ASE configuration options according to the WA Users Guide). You can see the error message in attached screenshot and here:


Capture analysis failed.

Analyzing analysis failed for capture SYBASE_20160527_092344(5).

com.sybase.workload.exception.ASECatRepoServerException: Call stored procedure p_setupanalysisenv error.

com.sybase.jdbc4.jdbc.SybSQLException: 'procedurep_addcapreqtds_cap5s' is not a recognized CREATE option.

( Line 770)( Line 4639).


I think this is a bug in stored procedures installed by 'installsybcatdb' script into 'sybcatdb' database. The keyword 'procedure' and the name of procedure 'p_addcapreqtds_cap5s' in CREATE statement are mistakenly concatenated. Instead of having been written as

create procedure p_addcapreqtds_cap5s

it was written as

create procedurep_addcapreqtds_cap5s

Is there anybody who knows how to fix this? Without being able to analyze captured workloads there is no sense to install and use Workload Analyzer option in developer edition.

Thanks in advance.


ErrorScreen.png (124.6 kB)