2227570 - Migrating ASE to higher version on Linux using Sybmigrate reported error - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2227570 - Migrating ASE to higher version on Linux using Sybmigrate reported error - SAP ASE

Symptom

When using Sybmigrate to migrate a 15.0.3 Solaris server to 15.7 Linux server, the following errors are reported:

  • Msg 4837, Level 16, State 2
    Server xxxxx, Line 1, Status 2, TranState 0 Bad row data received from
    the client while bulk copying into object 656002337 partition 672002394
    in database 10. Received a row of length 17 whilst maximum or expected
    row length is 33.

  • Errors reported in the 15.0.3 Solaris error log:

13:00000:00180:2015/10/07 11:13:10.98 server Ct-library: Msg
0x01010101 Fatal (Layer=1 Origin=1 Severity=1 Number=1): STATE EVENT:
blk layer: user error: Cannot call API blk_done(CS_BLK_BATCH) from this state: initialized
13:00000:00180:2015/10/07 11:13:10.98 server Ct-library: Msg
0x01010101 Fatal (Layer=1 Origin=1 Severity=1 Number=1): STATE EVENT:
blk layer: user error: Cannot call API blk_done(CS_BLK_BATCH) from this state: initialized
13:00000:00180:2015/10/07 11:13:10.98 server Ct-library: Msg
0x01010101 Fatal (Layer=1 Origin=1 Severity=1 Number=1): STATE EVENT:
blk layer: user error: Cannot call API blk_done(CS_BLK_BATCH) from this state: initialized
13:00000:00180:2015/10/07 11:13:10.98 server Ct-library: Msg
0x01010101 Fatal (Layer=1 Origin=1 Severity=1 Number=1): STATE EVENT:
blk layer: user error: Cannot call API blk_done(CS_BLK_BATCH) from this state: initialized
13:00000:00180:2015/10/07 11:13:10.98 server Ct-library: Msg
0x01010101 Fatal (Layer=1 Origin=1 Severity=1 Number=1): STATE EVENT:
blk layer: user error: Cannot call API blk_done(CS_BLK_BATCH) from this state: initialized
12:00000:00165:2015/10/07 11:13:10.99 server Ct-library: Msg
0x0102010e Fatal (Layer=1 Origin=2 Severity=1 Number=14): blk_init():
blk layer: internal BLK-Library error: Failed when CT_Lib routine
ct_fetch(BLK_IN_GET_FMT) called

 

  • Errors returned from running dbcc traceon (3604, 11201, 11202, 11203, 11204, 11205, 11206, 11208) -- CIS trace output:

08:00000:00542:2015/10/07 20:38:24.11 server PREPBULK, spid 542:
initializing bulk copy for 'xxxxx.dbo."xxxxx"'
08:00000:00542:2015/10/07 20:38:24.11 server BULKARRY, spid 542: id 1,
cs_type CHAR, maxlen 20, prec 0, scale 0, status 0x00000000, length of data 10000 bytes
08:00000:00542:2015/10/07 20:38:24.11 server BULKARRY, spid 542: id 2,
cs_type INT, maxlen 4, prec 0, scale 0, status 0x00000000, length of data 2000 bytes
08:00000:00542:2015/10/07 20:38:24.11 server BULKARRY, spid 542: id 3,
cs_type TINYINT, maxlen 1, prec 0, scale 0, status 0x00000000, length of data 500 bytes
08:00000:00542:2015/10/07 20:38:24.11 server BULKARRY, spid 542: id 4,
cs_type CHAR, maxlen 14, prec 0, scale 0, status 0x00000000, length of data 7000 bytes
08:00000:00542:2015/10/07 20:38:24.11 server BULKARRY, spid 542: id 5,
cs_type NUMERIC, maxlen 35, prec 10, scale 0, status 0x00000000, length of data 17500 bytes
08:00000:00542:2015/10/07 20:38:24.11 server BULKARRY, spid 542: Rows buffered 500, column count: 5, total array memory: 53760 bytes.
08:00000:00542:2015/10/07 20:38:24.11 server XFERBULK, spid 542, server xxxxx: transferring 3 rows
08:00000:00542:2015/10/07 20:38:24.11 server Ct-library: Msg 0x0102010e Fatal (Layer=1 Origin=2 Severity=1 Number=14): blk_init(): blk layer:
internal BLK-Library error: Failed when CT_Lib routine ct_fetch(BLK_IN_GET_FMT) called.
08:00000:00542:2015/10/07 20:38:24.11 server SENDMESG, spid 542: Msg 4837, Severity 16, State 2
Bad row data received from the client while bulk copying into object 1846294606 partition 1862294663 in database 10. Received a row of
length 17 whilst maximum or expected row length is 32.

 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.0.3 (Solaris)
  • SAP Adaptive Server Enterprise (ASE) 15.7 (Linux)

Product

SAP Adaptive Server Enterprise 15.7 ; Sybase Adaptive Server Enterprise 15.0

Keywords

migrate, sybmigrate , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.