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

Search for additional results

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