SAP Knowledge Base Article - Preview

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

Symptom

Objects not with owner dbo will not be triggerred 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 'PI3', Line 1:
Table 'table_name_XX' does not exist.
Server message:
Msg 19126, Level 16, State 1:
Server 'PI3', 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 , SAP Business Suite on Sybase ASE Database Platform , Bug Filed

About this page

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

Search for additional results

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