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