Return
-
Title
Error "Ct library: Msg 0x01010131 Fatal" while running spotlight (107629) -
Description
As per below KB article user tried provided solution (using sa user) but Spotlight still throws error in log file.
https://support.quest.com/spotlight-on-sap-ase/kb/107629
-
Cause
Patch details explanation.1) Sybase 12 have a internal bug when you SUM for a field. For example, you have a field data type is int, you issue this SQL:select sum(intField) from TableABut the sum result maybe more than the range of int data type. For Sybase 12, database raise a error and for Sybase 15 or above, database know how to save the data.This patch version "sosyb.prc" convert field data type from int to number(15,0) before sum it.2) Spotlight needs sum many database counter and the data is different for every server. For example, a database turn on timer counter, for a Server keep running for 1 year, the value in this counter is very large; for a server just turn on 1 minute, data in this counter is very small. That's why some server raise error but others not. -
Resolution
WORKAROUND:
follow below steps to apply patch:1) Close Spotlight on Sybase2) Run these query in iSQL:use sybsystemprocsgodrop procedure sp_sls_F_engines_mgodrop procedure sp_sls_F_resourcelimitgo3) Replace "sosyb.prc" in Spotlight folder with the one I attached in this email. By default Spotlight install folder is:C:\Program Files\Dell\Spotlight\Plug-ins\SoSyb\STATUS:
Waiting for fix to be released in a future version of Spotlight on SAP ASE. -
Defect ID
SOS-173 -
Attachments