SAP Knowledge Base Article - Preview

2731256 - sp_iqcheckfpconsistency incorrectly returned an error - SAP IQ

Symptom

Checking procedure "sp_iqcheckfpconsistency" could have returned an error 'Error Detected' on a column with a special  character as part of column name.
Whereas sp_iqcheckdb with check mode on same object(s) returned  clean status, 'No error Detected'.

 sp_iqcheckfpconsistency (' cust_user.???_SLS_MO_M')  ;
  
   =>
      ...
      cust_user            ???_SLS_MO_M      C350330001           Errors Detected     
      cust_user            ???_SLS_MO_M      C350330002           Errors Detected     
      cust_user            ???_SLS_MO_M      C350330003           Errors Detected    
      ...


Read more...

Environment

SAP IQ 16.0

Product

SAP IQ 16.0

Keywords

sp_iqcheckfpconsistency , "Error Detected", DBCC , , 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.