SAP Knowledge Base Article - Preview

2947687 - WLA compare failed. Attempt to insert NULL value into column 'tpcq_querytext', table 'sybcatdb.dbo.t_topperfchgqrys_cap

Symptom

  • Workload Analyser is failing: Comparison of workload was terminated with exception: Replay comparison failed.
  • Customer is getting in WLA logs  

Attempt to insert NULL value into column 'tpcq_querytext', table 'sybcatdb.dbo.t_topperfchgqrys_cap

Failed to read queries for session 2 for capture NYTIBH6T009_20200706_0341(5,000,000,000,000,035). com.sybase.workload.exception.ASECatRepoServerException: Call stored procedure p_gentopperfdecrpt error. com.sybase.jdbc4.jdbc.SybSQLException: Attempt to insert NULL value into column 'tpcq_querytext', table 'sybcatdb.dbo.t_topperfchgqrys_cap5000000000000035'; column does not allow nulls. Update fails. 2020-07-06 04:37:00,351 - 



Read more...

Environment

SAP Adaptive Server Entreprise (ASE) 16 SP03 PL08

Product

SAP Adaptive Server Enterprise 16.0

Keywords

822247,CR822247,CR 822247,tpcq_querytext,WLA,Wokload Analyser , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.