Sybmigrate 12.5.4 vers 15.5 [Résolu]

[lsone]

Bonjour,

Dans le cadre d'une migration Sybase ASE 12.5.4 (page size 4k, nommé FS_SV_CRIPS1) vers 15.5 (page size 8k, nommé FSSTB001), lorsque je lance le processus de migration en setup, j'obtiens le message suivant :

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 
fskiev:/fsscripscbkdb/sgbd/FSSTB001/scripts/migration>$SYBASE/$SYBASE_ASE/bin/sybmigrate -r migration.src -m setup
  Opened file '/fsscripscbkdb/product/sybase/tb/ASE-15_0/init/logs/sybmigrate1123.002' TO be used AS the migration log.
  Migration Tool invoked WITH debug level 2.
  Processing resource file 'migration.src'...
  Processing resource file 'migration.src' complete.
00:00:00000:00020:2010/11/23 17:44:00.46 server  DBCC TRACEON 698, SPID 20
00:00:00000:00020:2010/11/23 17:44:00.47 server  DBCC TRACEON 10748, SPID 20
  WARNING|Repository DATABASE size IS 1 MB less than the required size FOR the currently configured paths.
  Validated source AND target FOR migration
Source ASE 'FS_SV_CRIPS1' WITH network name 'FS_SV_CRIPS1' (URL: 126.248.244.24:8510) version:
Adaptive Server Enterprise/12.5.4/EBF 14341 ESD#5/P/RS6000/AIX 4.3.3/ase1254/2061/32-bit/FBO/Sun Apr 15 23:18:29 2007
Target ASE 'FSSTB001' WITH network name 'FSSTB001' (URL: 126.251.244.78:4210) version:
Adaptive Server Enterprise/15.5/EBF 17792 SMP ESD#1/P/RS6000/AIX 5.3/asear155/2495/64-bit/FBO/Thu May 27 02:31:54 2010
  Save session info TO the repository DATABASE.
  Completed setup.
  ERROR|Target server 'FSSTB001' cannot be reached FROM source server 'FS_SV_CRIPS1'.
fskiev:/fsscripscbkdb/sgbd/FSSTB001/scripts/migration>

Le serveur Sybase ASE 12.5.4 (page size 4k) est sur un IBM AIX 5.3 nommé fsdubbo.

Le fichier interfaces :

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 
fsdubbo:/sgbd/sybase/dev/12.5.4-crips/ASE-12_5/install$
# cat $SYBASE/interfaces
FS_SV_CRIPS1
        master tcp ether fsdubbo.dgm.caisse-epargne.fr 8510
        query tcp ether fsdubbo.dgm.caisse-epargne.fr 8510
 
FS_BK_CRIPS1
        master tcp ether fsdubbo.dgm.caisse-epargne.fr 8515
        query tcp ether fsdubbo.dgm.caisse-epargne.fr 8515
 
FSSTB001
        master tcp ether fskiev.dgm.caisse-epargne.fr 4210
        query tcp ether fskiev.dgm.caisse-epargne.fr 4210
 
FSSTB001_BK
        master tcp ether fskiev.dgm.caisse-epargne.fr 4211
        query tcp ether fskiev.dgm.caisse-epargne.fr 4211

Le serveur Sybase ASE 15.5 (page size 8k) est sur un IBM AIX 6.1 nommé fskiev.

Le fichier interfaces le hote Unix :

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 
fskiev:/fsscripscbkdb/sgbd/FSSTB001/scripts/migration>cat $SYBASE/interfaces
FS_SV_CRIPS1
        master tcp ether fsdubbo.dgm.caisse-epargne.fr 8510
        query tcp ether fsdubbo.dgm.caisse-epargne.fr 8510
 
FS_BK_CRIPS1
        master tcp ether fsdubbo.dgm.caisse-epargne.fr 8515
        query tcp ether fsdubbo.dgm.caisse-epargne.fr 8515
 
FSSTB001
        master tcp ether fskiev.dgm.caisse-epargne.fr 4210
        query tcp ether fskiev.dgm.caisse-epargne.fr 4210
 
FSSTB001_BK
        master tcp ether fskiev.dgm.caisse-epargne.fr 4211
        query tcp ether fskiev.dgm.caisse-epargne.fr 4211
 
 
fskiev:/fsscripscbkdb/sgbd/FSSTB001/scripts/migration>

Test de connection à partir du 12.5.4 sur le 15.5 :

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
 
# $SYBASE/$SYBASE_OCS/bin/isql -Usa -SFS_SV_CRIPS1 -w1000
Password:
1> sp_helpserver
2> go
 name                           network_name                     class           STATUS                                                                                                                                                                                                                                                          id    cost
 ------------------------------ -------------------------------- --------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----- -----
 FS_SV_CRIPS1                   FS_SV_CRIPS1                     LOCAL                                                                                                                                                                                                                                                                           0     0
 SYB_BACKUP                     FS_BK_CRIPS1                     NULL            timeouts, no net password encryption, writable , rpc security model A                                                                                                                                                                                           1     NULL
 mtrs$1                         FSSTB001                         ASEnterprise    timeouts, no net password encryption, writable , rpc security model A                                                                                                                                                                                           2     1000
(RETURN STATUS = 0)
1> connect TO mtrs$1
2> go
Entered passthru mode TO server 'mtrs$1'.
1> SELECT @@servername
2> go
 
 ------------------------------
 FSSTB001
 
(1 row affected)
1> disconnect
2> go
Exited passthru mode FROM server 'mtrs$1'.
1> quit
fsdubbo:/sgbd/sybase/dev/12.5.4-crips/ASE-12_5/install$

La présence du server mtrs$1 indique qu'il a tenté quelque chose.

Par contre aucun login externe n'est associé à mtrs$1

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
 
$SYBASE/$SYBASE_OCS/bin/isql -Usa -SFS_SV_CRIPS1 -w1000
Password:
1> sp_helpexternlogin
2> go
 Server                         Login                          Externlogin
 ------------------------------ ------------------------------ ------------------------------
 
(0 rows affected)
 Server                         Role                           Externlogin
 ------------------------------ ------------------------------ ------------------------------
 
(0 rows affected)
(RETURN STATUS = 0)
1> quit
fsdubbo:/sgbd/sybase/dev/12.5.4-crips/ASE-12_5/install$

Test de connection à partir du 15.5 sur le 12.5.4 :

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
 
fskiev:/fsscripscbkdb/sgbd/FSSTB001/scripts/migration>echo $DSQUERY
FSSTB001
fskiev:/fsscripscbkdb/sgbd/FSSTB001/scripts/migration>isql -Usa -S$DSQUERY -w1000
Password:
1> sp_helpserver
2> go
 name         network_name   class        STATUS                                                                                             id cost
 ------------ -------------- ------------ -------------------------------------------------------------------------------------------------- -- ----
 FSSTB001     FSSTB001       LOCAL                                                                                                            0    0
 FS_SV_CRIPS1 FS_SV_CRIPS1   ASEnterprise no timeouts, no net password encryption, writable , rpc security model A, enable login redirection  2 1000
 SYB_BACKUP   FSSTB001_BK    NULL         timeouts, no net password encryption, writable , rpc security model A, enable login redirection     1 NULL
(RETURN STATUS = 0)
1> connect TO FS_SV_CRIPS1
2> go
Entered passthru mode TO server 'FS_SV_CRIPS1'.
1> SELECT @@servername
2> go
 
 ------------------------------
 FS_SV_CRIPS1
 
(1 row affected)
1> disconect
2> go
Exited passthru mode FROM server 'FS_SV_CRIPS1'.
1> quit
fskiev:/fsscripscbkdb/sgbd/FSSTB001/scripts/migration>

Dans la log du serveur 12.5.4, j'ai :

Code :

1
2
3
 
00:00000:00023:2010/11/23 17:44:00.95 server  GET_COLS: typename usmallint; ss_data_type 65; SET TO ODBC_VARCHAR
00:00000:00023:2010/11/23 17:44:00.95 server  GET_COLS: typename usmallint; ss_data_type 65; SET TO ODBC_VARCHAR

Si l'un de vous a une solution ou une piste je suis preneur.

Cdt,

[kagemaru]

Salut

Est-ce que tu as quelquechose de plus dans $SYBASE/$SYBASE_ASE/init/logs du serveur source ?

[lsone]

Bonsoir,

Pour information j'ai relancé plusieurs le sybmigrate en purgeant les fichiers type sybmigrate1123*, le work serveur etc ...et à chaque fois j'obtiens le même message d'erreur.

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
 
fskiev:/fsscripscbkdb/product/sybase/tb/ASE-15_0/init/logs>ls -ltr
 
total 168
 
-rw-r--r--    1 sybase   sybase          462 May 05 2010  README
 
-rw-------    1 sybase   sybase          498 Nov 18 16:49 srvbuild1118.001
 
-rw-------    1 sybase   sybase         1604 Nov 18 16:50 srvbuild1118.002-FSSTB001.rs
 
-rw-------    1 sybase   sybase        58463 Nov 18 16:51 srvbuild1118.002
 
-rw-------    1 sybase   sybase          520 Nov 18 16:56 srvbuild1118.003-FSSTB001_BK.rs
 
-rw-------    1 sybase   sybase          874 Nov 18 16:56 srvbuild1118.003
 
-rw-r--r--    1 sybase   sybase         2233 Nov 23 22:53 sybmigrate1123.001
 
fskiev:/fsscripscbkdb/product/sybase/tb/ASE-15_0/init/logs>cat sybmigrate1123.001
 
SybMigrate/15.5/EBF/P/asear155/ENG/32-bit/OPT/Wed May 26 23:43:03 PDT 2010
 
Confidential property of Sybase, Inc.
 
Copyright 2002 - 2006
 
Sybase, Inc. ALL rights reserved.
 
This software contains confidential AND trade secret information of Sybase,
 
Inc.   USE,  duplication OR disclosure of the software AND documentation BY
 
the  U.S.  Government  IS  subject  TO  restrictions SET forth IN a license
 
agreement  BETWEEN  the  Government  AND  Sybase,  Inc.  OR  other  written
 
agreement  specifying  the  Government's rights to use the software and any
 
applicable FAR provisions, for example, FAR 52.227-19.
 
Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
 
 
 
 
 
Sybase Adaptive Server Enterprise DDL Generator Utility/15.5/EBF 17785 ESD#1/S/1.6.0/asear155/Wed May 5 07:58:32 PDT 2010
 
 
 
 
 
  2010/11/23 22:53:35.379|main||Migration Tool invoked with debug level 2.
 
  2010/11/23 22:53:35.537|main||Processing resource file 'migration.src'...
 
  2010/11/23 22:53:35.682|main||Processing resource file 'migration.src' complete.
 
  2010/11/23 22:53:36.267|main|DEBUG|getMigrationSession: Auto_Model
 
  2010/11/23 22:53:36.273|main|DEBUG|isDevEdition 0
 
  2010/11/23 22:53:36.307|main|DEBUG|using PUSH: Source Version 12.5.4
 
  2010/11/23 22:53:36.462|main|DEBUG|setupRemoteServer(mtrs$0, FSSTB001)
 
  2010/11/23 22:53:36.770|main|DEBUG|3: Status == INITIAL
 
  2010/11/23 22:53:36.810|main||Validated source and target for migration
 
Source ASE 'FS_SV_CRIPS1' with network name 'FS_SV_CRIPS1' (URL: 126.248.244.24:8510) version:
 
Adaptive Server Enterprise/12.5.4/EBF 14341 ESD#5/P/RS6000/AIX 4.3.3/ase1254/2061/32-bit/FBO/Sun Apr 15 23:18:29 2007
 
Target ASE 'FSSTB001' with network name 'FSSTB001' (URL: 126.251.244.78:4210) version:
 
Adaptive Server Enterprise/15.5/EBF 17792 SMP ESD#1/P/RS6000/AIX 5.3/asear155/2495/64-bit/FBO/Thu May 27 02:31:54 2010
 
  2010/11/23 22:53:36.967|main||Create repository database 'sybmigratedb'.
 
  2010/11/23 22:53:39.116|main||Save session info to the repository database.
 
  2010/11/23 22:53:39.170|main|DEBUG|sAse.setupRemoteServer to FSSTB001
 
  2010/11/23 22:53:39.230|main||Completed setup.
 
  2010/11/23 22:53:39.241|main|ERROR|Target server 'FSSTB001' cannot be reached from source server 'FS_SV_CRIPS1'.
 
fskiev:/fsscripscbkdb/product/sybase/tb/ASE-15_0/init/logs>

Cdt,

[lsone]

OS : IBM AIX
ASE : 12.5.4 et 15.5
Objectif : Migration via sybmigrate de 12.5.4 vers 15.5
Erreur : ERROR | Target server cannot be reached from source server

Les log/pass sont identiques sur la cible et la source.

La solution trouvée : création d'un remote login sur la cible.

J'ai contacté le support France Sybase, ils vont créer un CR sur cette problématique.

Sur la source :

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
 
# $SYBASE/$SYBASE_OCS/bin/isql -Usa -SFS_SV_CRIPS1 -w1000
 
Password:
 
1> USE master
 
2> go
 
1> sp_helpserver
 
2> go
 
 name                           network_name                     class           STATUS                                                                                                                                                                                                                                                          id    cost
 
 ------------------------------ -------------------------------- --------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----- -----
 
 FS_SV_CRIPS1                   FS_SV_CRIPS1                     LOCAL                                                                                                                                                                                                                                                                           0     0
 
 SYB_BACKUP                     FS_BK_CRIPS1                     NULL            timeouts, no net password encryption, writable , rpc security model A                                                                                                                                                                                           1     NULL
 
(RETURN STATUS = 0)
 
1> quit
 
fsdubbo:/sgbd/sybase/dev/12.5.4-crips$

Fichier interfaces de la distribution du serveur source :

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 
fsdubbo:/sgbd/sybase/dev/12.5.4-crips$
# cat interfaces
FS_SV_CRIPS1
        master tcp ether fsdubbo 8510
        query tcp ether fsdubbo 8510
 
FS_BK_CRIPS1
        master tcp ether fsdubbo 8515
        query tcp ether fsdubbo 8515
 
FSSTB001
        master tcp ether fskiev 4210
        query tcp ether fskiev 4210
 
FSSTB001_BK
        master tcp ether fskiev 4211
        query tcp ether fskiev 4211
fsdubbo:/sgbd/sybase/dev/12.5.4-crips$
#

Sur la cible :

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
 
fskiev:/fsscripscbkdb/sgbd/FSSTB001/scripts/migration>isql -Usa -SFSSTB001 -w1000
Password:
1> sp_helpserver
2> go
 
 name         network_name   class        STATUS                                                                                             id cost
 
 ------------ -------------- ------------ -------------------------------------------------------------------------------------------------- -- ----
 
 FSSTB001     FSSTB001       LOCAL                                                                                                            0    0
 
 FS_SV_CRIPS1 FS_SV_CRIPS1   ASEnterprise no timeouts, no net password encryption, writable , rpc security model A, enable login redirection  2 1000
 
 SYB_BACKUP   FSSTB001_BK    NULL         timeouts, no net password encryption, writable , rpc security model A, enable login redirection     1 NULL
 
(RETURN STATUS = 0)
 
1> sp_helpremotelogin FS_SV_CRIPS1
2> go
 
 server       remote_user_name local_user_name options
 
 ------------ ---------------- --------------- ----------
 
 FS_SV_CRIPS1 sa               sa              -- none --
 
(RETURN STATUS = 0)
 
1> sp_dropremotelogin FS_SV_CRIPS1,sa,sa
2> go
 
Remote login dropped.
 
(RETURN STATUS = 0)
 
1> quit
fskiev:/fsscripscbkdb/sgbd/FSSTB001/scripts/migration>

Fichier interfaces de la distribution du serveur cible :

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 
fskiev:/fsscripscbkdb/sgbd/FSSTB001/scripts/migration>cat $SYBASE/interfaces
FSSTB001
        master tcp ether fskiev 4210
        query tcp ether fskiev 4210
 
FSSTB001_BK
        master tcp ether fskiev 4211
        query tcp ether fskiev 4211
 
FS_SV_CRIPS1
        master tcp ether fsdubbo 8510
        query tcp ether fsdubbo 8510
 
FS_BK_CRIPS1
        master tcp ether fsdubbo 8515
        query tcp ether fsdubbo 8515
 
fskiev:/fsscripscbkdb/sgbd/FSSTB001/scripts/migration>

Lancement de la migration

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
 
fskiev:/fsscripscbkdb/sgbd/FSSTB001/scripts/migration>$SYBASE/$SYBASE_ASE/bin/sybmigrate -r migration.src -m setup
 
  Opened file '/fsscripscbkdb/product/sybase/tb/ASE-15_0/init/logs/sybmigrate1126.016' TO be used AS the migration log.
 
  Migration Tool invoked WITH debug level 2.
 
  Processing resource file 'migration.src'...
 
  Processing resource file 'migration.src' complete.
 
  Validated source AND target FOR migration
 
Source ASE 'FS_SV_CRIPS1' WITH network name 'FS_SV_CRIPS1' (URL: 126.248.244.24:8510) version:
 
Adaptive Server Enterprise/12.5.4/EBF 14341 ESD#5/P/RS6000/AIX 4.3.3/ase1254/2061/32-bit/FBO/Sun Apr 15 23:18:29 2007
 
Target ASE 'FSSTB001' WITH network name 'FSSTB001' (URL: 126.251.244.78:4210) version:
 
Adaptive Server Enterprise/15.5/EBF 17792 SMP ESD#1/P/RS6000/AIX 5.3/asear155/2495/64-bit/FBO/Thu May 27 02:31:54 2010
 
  WARNING|Setting attribute 'migrate_server_data' IS NOT allowed. Ignoring it.
 
  WARNING|Can't set to unlock login accounts because Server Info is not set to migrate.
 
  Create repository database 'sybmigratedb'.
 
  Save session info to the repository database.
 
  Completed setup.
 
  ERROR|Target server 'FSSTB001' cannot be reached from source server 'FS_SV_CRIPS1'.
 
fskiev:/fsscripscbkdb/sgbd/FSSTB001/scripts/migration>

Ajout du remote login sur la cible

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
fskiev:/fsscripscbkdb/sgbd/FSSTB001/scripts/migration>isql -Usa -SFSSTB001 -w1000
 
Password:
 
1> sp_addremotelogin FS_SV_CRIPS1,sa,sa
 
2> go
 
New remote login created.
 
(RETURN STATUS = 0)
 
1> quit

Relance la migration

Code :

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
 
fskiev:/fsscripscbkdb/sgbd/FSSTB001/scripts/migration>$SYBASE/$SYBASE_ASE/bin/sybmigrate -r migration.src -m setup
 
  Opened file '/fsscripscbkdb/product/sybase/tb/ASE-15_0/init/logs/sybmigrate1126.017' TO be used AS the migration log.
 
  Migration Tool invoked WITH debug level 2.
 
  Processing resource file 'migration.src'...
 
  Processing resource file 'migration.src' complete.
 
  Validated source AND target FOR migration
 
Source ASE 'FS_SV_CRIPS1' WITH network name 'FS_SV_CRIPS1' (URL: 126.248.244.24:8510) version:
 
Adaptive Server Enterprise/12.5.4/EBF 14341 ESD#5/P/RS6000/AIX 4.3.3/ase1254/2061/32-bit/FBO/Sun Apr 15 23:18:29 2007
 
Target ASE 'FSSTB001' WITH network name 'FSSTB001' (URL: 126.251.244.78:4210) version:
 
Adaptive Server Enterprise/15.5/EBF 17792 SMP ESD#1/P/RS6000/AIX 5.3/asear155/2495/64-bit/FBO/Thu May 27 02:31:54 2010
 
  WARNING|Setting attribute 'migrate_server_data' IS NOT allowed. Ignoring it.
 
  WARNING|Can't set to unlock login accounts because Server Info is not set to migrate.
 
  Create repository database 'sybmigratedb'.
 
  Save session info to the repository database.
 
  WARNING|Attention: The target server does not have all the user defined caches configured as on the source server. If there are user objects bound to these caches on the source then the bindings will not be migrated unless these caches are configured on the target server. Missing caches: 'dbccdb_cache'.
 
  Perform setup for path 'ftbdb_crips --> ftbdb_crips'.
 
  Attention: SET 'select into, trunc log' db options FOR the DATABASE 'ftbdb_crips'. IF required, this can be manually cleared after migration IS complete.
 
  Attention: Cleared 'auto identity, identity in nonunique index, unique auto_identity index' db options FOR the DATABASE 'ftbdb_crips'. IF required, this can be manually SET after migration IS complete.
 
  Expand repository DATABASE BY 245 MB.
 
  Completed setup.
 
fskiev:/fsscripscbkdb/sgbd/FSSTB001/scripts/migration>

Cdt,

[kagemaru]

merci pour l'info !