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.
SAP Knowledge Base Article - Preview