SAP Knowledge Base Article - Preview

2785785 - DAP ends with IQ Error SQL-131 Syntax error near '(end of line)'

Symptom

  • While performing BW DAP (Data Archiving Process) to archive data to SAP IQ database, the job failed with the following errors reported in the SM37 log:   

[IQ Error SQL-131:42000][Sybase IQ]Syntax error near '(end of line)' on line 1

  • The related dev_w* trace file reports the offending SQL statement:

C ERROR: -1 in function ExecuteAndFlush (SQLExecDirect) [line 15453]
C (-131) [42000] [Sybase][ODBC Driver][Sybase IQ]Syntax error near '(end of line)' on line 1
C DbSlExecute - Error 99 (dbcode -131) on DDLExecute
C DbSlExecute - <ALTER TABLE "<table_name>" MOVE PARTITION "PMAX" TO "" >
C dbdssyb: DBSL99 SQL-131
C [IQ Error SQL-131:42000][Sybase IQ]Syntax error near '(end of line)' on line 1
B ***LOG BY2=> sql error -131 performing EXE [dbds 670]
B ***LOG BY0=> [IQ Error SQL-131:42000][Sybase IQ]Syntax error near '(end of line)' on line 1 [dbds 670]
L Begin of BtcSetFinalStepStatus: jobname=BI_ARCH-xxxxxxxx , jobcount=xxxxxxx


Read more...

Environment

  • SAP IQ 16.0
  • SAP NetWeaver 7.5 (Business Warehouse)

Product

SAP IQ 16.0 ; SAP NetWeaver 7.5

Keywords

NLS, IQ, partition, move, DEFAULT_DBSPACE, default_dbspace, dbspace , KBA , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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.