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

Search for additional results

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