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
--------------

  • SAP IQ Cockpit against the same database does not show any backup records. List is empty.

    cockpit screenshot.png


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

Search for additional results

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