1986248 - LOAD TABLE cannot recognize the row delimiter - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1986248 - LOAD TABLE cannot recognize the row delimiter - SAP IQ

Symptom

  • LOAD TABLE statement may get a wrong position of row delimiter on Windows environment.
  • This problem may occur when a fixed width file has many rows.
  • This problem is not reproduced in SAP IQ 16.0 or later.
  • From IQMSG log you can see the following messages:

--------------------------
I... 0000000320 [20748]: Offset 0, Length 10, 0 nulls, A->varchar col1
I... 0000000320 [20748]: Offset 0, Length 10, 0 nulls, A->varchar col2
I... 0000000320 [20585]: Row Delimiter: \x0d\x0a
I... 0000000320 [20571]: *** Record size: variable, Block size: 500000
I... 0000000320 Insert Started:
I... 0000000320 TESTTAB
I... 0000000320 Exception Thrown from db_sqlins.cxx:11995, Err# 139, tid 155 origtid 155
I... 0000000320 O/S Err#: 0, ErrID: 4098 (db_sqlexception); SQLCode: -1013061, SQLState: 'QCA61', Severity: 14
I... 0000000320 [20631]: Missing row delimiter detected during a row delimited insert.
-- (db_sqlins.cxx 11995)
I... 0000000320 Exception Thrown from db_sqlins.cxx:11995, Err# 139, tid 2 origtid 155
I... 0000000320 O/S Err#: 0, ErrID: 4098 (db_sqlexception); SQLCode: -1013061, SQLState: 'QCA61', Severity: 14
I... 0000000320 [20631]: Missing row delimiter detected during a row delimited insert.
-- (db_sqlins.cxx 11995)


Read more...

Environment

SAP IQ 15.x

Product

SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

row_delimiter, CR667051, -101306, 667051 , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.