SAP Knowledge Base Article - Preview

2431994 - Failed to recompile a view(SQLCODE=-1037).

Symptom

When trying to recompile a view, an error below happened.

[IQ message log]
I. 02/20 23:19:19. 0000007175 Txn 1530934 0 1530934
I. 02/20 23:19:19. 0000007175 Cmt 1530935
I. 02/20 23:19:19. 0000007175 PostCmt 0
I. 02/20 23:19:19. 0000007175 Txn 1530936 0 1530936
I. 02/20 23:19:19. 0000007175 Rbck
I. 02/20 23:19:19. 0000007175 PostRbck

[Trace log - srvlog]
I. 02/20 23:19:19. <,9,PREPARE,alter view "DBA"."VW_JERRY" recompile
I. 02/20 23:19:19. >,9,PREPARE,262168
I. 02/20 23:19:19. <,9,EXEC,262168
I. 02/20 23:19:19. E,9,-1037,Cannot drop or modify object 'VW_JERRY' because at least one other object ( VIEW 'VW_DEPENDENT') depends upon it


Read more...

Environment

  • SAP Sybase IQ 15.x
  • SAP IQ 16.0 

Product

SAP Sybase IQ 15.2

Keywords

SAP IQ, IQ, alter view, recompile, 42000, -1037, Cannot drop or modify object , KBA , BC-SYB-IQ , Sybase IQ , Problem

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.