SAP Knowledge Base Article - Preview

2497343 - Job scheduler template 'jst_default_autoupdtstats' does not retrieve object ownership - SAP ASE

Symptom

  • Objects not owned by dbo are not triggered with automatic update statistics scheduled job, which is created by default template 'jst_default_autoupdtstats'.
  • In JSAGENT.log, below error would occur:

****************************************
00:12876:03920:2017/06/29 09:05:50.26 jamain Server message:
00:12876:03920:2017/06/29 09:05:50.26 jamain Msg 5701, Level 10, State 2:
00:12876:03920:2017/06/29 09:05:50.26 jamain Server 'servername_XX'
00:12876:03920:2017/06/29 09:05:50.26 jamain :
00:12876:03920:2017/06/29 09:05:50.26 jamain Server message: Changed database context to 'master'.

00:12876:03920:2017/06/29 09:05:50.26 jamain Server message:
00:12876:03920:2017/06/29 09:05:50.26 jamain Msg 5701, Level 10, State 1:
00:12876:03920:2017/06/29 09:05:50.26 jamain Server 'servername_XX'
00:12876:03920:2017/06/29 09:05:50.26 jamain Line 100:12876:03920:2017/06/29 09:05:50.26 jamain :
00:12876:03920:2017/06/29 09:05:50.26 jamain Server message: Changed database context to 'sybmgmtdb'.

00:12876:03920:2017/06/29 09:05:50.26 jamain Creating global context.
00:12876:03920:2017/06/29 09:05:50.27 jamain SYB_JSAGENT ready.
00:01316:12876:2017/06/29 09:10:00.16 worker jsj_RunSQLJobcb: Job SQL failed.
00:01316:12876:2017/06/29 09:10:00.16 worker jsd_GetResults: callback to fetch results failed
00:01316:12876:2017/06/29 09:10:00.16 worker jsj__RunSQLJob: jsd_GetResults() failed for xid 35
00:01316:12876:2017/06/29 09:10:00.16 worker jsj__RunSQLJob() failed for xid 35
****************************************

  • If ASE cockpit is configured, below error would occur in EXPLORE--> Task Management--> Job History--> Job log:

****************************************
executing: dbname_XX..sp_jst_update_statistics, table_name_XX,20,0,0,,,,0
sp_jst_update_statistics( table_name = table_name_XX, table_owner = , columns = , index_name = , ptn_name = , index_flag = 0, step_value = , consumers = , sampling_rate = , datachg_threshold = 20, rowcnt_threshold = 0, pagecnt_threshold = 0 )
sp_jst_get_object_quoted_name, object_quoted_name = table_name_XX
sp_jst_get_object_quoted_name, object_quoted_name = sp_jst_version_num, version_num = 16.0
sp_jst_get_datachange( @table_name = table_name_XX, @ndxform_flag = 1, @colndx_flag = 1, @colndx_names = , @ptn_name = )
sp_jst_get_index_names( @table_name = table_name_XX )
update index statistics table_name_XX
Server message:
Msg 2706, Level 11, State 1:
Server 'ASE', Line 1:
Table 'table_name_XX' does not exist.
Server message:
Msg 19126, Level 16, State 1:
Server 'ASE', Procedure 'sp_jst_update_statistics', Line 345:
UPDATE STATISTICS command for table table_name_XX failed.
****************************************


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 all versions
  • SAP Adaptive Server Enterprise (ASE) 16.0 all versions

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

sp_jst_svr_update_statistics, sp_jst_db_update_statistics, sp_jst_update_statistics, defaultServerUpdateStats, automatic update statistics, sybase, Msg 19126, Msg 2706, CR#809345, 809345, CR809345 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.