Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Sybmigrate ase 12.5.3 to ASE 15.0.3 fails

94 views
Skip to first unread message

Jari

unread,
May 25, 2010, 6:12:06 AM5/25/10
to
Hi I have done on migration from ase 12.5.3 to ASE 15.0.3
succesufully.
But we also needed to change the character set from cp850 to utf8


I started the migration like this
C:\sybase15\ASE-15_0\bin>sybmigrate.bat -J utf8 -D 4

Any suggestions?

Now the migration fails on:

BCP insert operation is disabled when data size is changing between
client and server character sets. Please use BCP's -Y option to invoke
client-side conversion.
Msg 3651, Level 16, State 1


Part of the log here:
2010/05/25 12:53:44.314|EXECUTE_MIG_TASK|DEBUG|task list is still
not empty
2010/05/25 12:53:44.345|TASK (1:3)|DEBUG|create proxy and do data
migration
2010/05/25 12:53:44.345|TASK (1:1)|DEBUG|create proxy and do data
migration
2010/05/25 12:53:44.548|TASK (1:3)|DEBUG|Conn.close Thread TASK
(1:3)
2010/05/25 12:53:44.548|TASK (1:3)|DEBUG|Conn.close jdbc:sybase:Tds:
10.110.30.38:5000 spid 86
2010/05/25 12:53:44.548|TASK (1:3)|DEBUG|DW.dbo.DW_CODES_TRAN_Ddata
copy cmd: select * into existing table mtpdb$1$1.dbo.ptbl153 from
DW.dbo.DW_CODES_TRAN_D (parallel 1):
2010/05/25 12:53:44.564|TASK (1:2)|DEBUG|Conn.close Thread TASK
(1:2)
2010/05/25 12:53:44.564|TASK (1:2)|DEBUG|Conn.close jdbc:sybase:Tds:
10.110.30.38:5000 spid 83
2010/05/25 12:53:44.564|TASK (1:2)|DEBUG|
DW.dbo.DW_CODES_CREDIT_Ddata copy cmd: select * into existing table
mtpdb$1$1.dbo.ptbl152 from DW.dbo.DW_CODES_CREDIT_D (parallel 1):
2010/05/25 12:53:44.564|TASK (1:1)|DEBUG|Conn.close Thread TASK
(1:1)
2010/05/25 12:53:44.564|TASK (1:1)|DEBUG|Conn.close jdbc:sybase:Tds:
10.110.30.38:5000 spid 54
2010/05/25 12:53:44.564|TASK (1:1)|DEBUG|DW.dbo.DW_CODES_CUST_Ddata
copy cmd: select * into existing table mtpdb$1$1.dbo.ptbl151 from
DW.dbo.DW_CODES_CUST_D (parallel 1):
2010/05/25 12:53:44.627|TASK (1:1)|ERROR|Error during data migration
of 'DW.dbo.DW_CODES_CUST_D'.
2010/05/25 12:53:44.627|TASK (1:1)|ERROR|
Msg 11216, Level 16, State 13
Server test, Line 1, Status 0, TranState 0
Internal Ct-Lib/Cs-Lib error 0: 'blk_init(): blk layer: CT library
error: Failed when CT_Lib routine ct_results() called.'.
Msg 4847, Level 16, State 1
Server mtrs$1, Line 1, Status 0, TranState 0
BCP insert operation is disabled when data size is changing between
client and server character sets. Please use BCP's -Y option to invoke
client-side conversion.
Msg 3651, Level 16, State 1
Server test, Line 1, Status 0, TranState 0
This transaction has been rolled back, rather than only the current
statement.


2010/05/25 12:53:44.627|TASK (1:1)|ERROR|
com.sybase.jdbc3.jdbc.SybSQLException: Internal Ct-Lib/Cs-Lib error 0:
'blk_init(): blk layer: CT library error: Failed when CT_Lib routine
ct_results() called.'.

0 new messages