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 ONE Support launchpad (Login required).

Search for additional results

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