SAP Knowledge Base Article - Preview

2287018 - DBACockpit shows error "SAPNLS [IQ Error SQL-1090:08004][Sybase IQ]Function 'substr' has invalid parameter '3' ('-1')"

Symptom

  • IQ Backup Solution in place. Connection Parameter String consists of BACKUP_REQUEST_EVENT=BACKUP_REQUEST
    Backups are getting triggered correctly.

  • Backup and Recovery under DBACockpit gives error "SAPNLS [IQ Error SQL-1090:08004][Sybase IQ]Function 'substr' has invalid parameter '3' ('-1') "
    Clicking on error details show

--------------
Details

Message Details

Exception CX_DBA_ADBC in program SAPMHTTP line 0
Kernel Error ID:
WP ID: 8
WP PID: 11000
Application Server: bwbd3
SYSID: SAPNLS
SY-SUBRC: 1208
Message: ADBC error
SQL statement: select backup_id, backup_time, '19570710112345', 'displaydate', backup_type, selective_type, virtual_type, depends_on_id, creator, backup_size, user_comment, backup_command, ' ' from sp_iqbackupsummary('2016-02-24 00:00:00') where backup_time between '2016-02-24 00:00:00' and '2016-03-01 23:59:59' ORDER BY backup_time ASC
Database: SAPIQDB
caused by
Exception CX_SQL_EXCEPTION in class CL_SQL_RESULT_SET
Kernel Error ID:
DB Error: Yes
SQL Code: 1090-
SQL Message: [IQ Error SQL-1090:08004][Sybase IQ]Function 'substr' has invalid parameter '3' ('-1')
DB Object Exists: No
Duplicated Key: No
Internal Error: 1
Invalid Cursor: No
Unknown Connection: No
Connection Closed: No
--------------


Read more...

Environment

SAP IQ 16.x 

Product

SAP IQ 16.0

Keywords

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.