dbTalk Databases Forums  

Sybse no interactive fails

comp.databases.sybase comp.databases.sybase


Discuss Sybse no interactive fails in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
evoradba@yahoo.ca
 
Posts: n/a

Default Sybse no interactive fails - 02-23-2009 , 12:23 PM







Hello

I need to migrate Sybase using no-interactive resource file I cant use
GUI mode, I went through the documentation on line and I keep getting
the same error message

These are the errors, the target ASE is on sybase 15.03 on Solaris
5.8, the target is on the same O/S and is ASE 15.02

sybase@test:/u01/app/sybase/migrate$ sybmigrate -r test -m
migrate
Opened file '/u02/app/sybase/COMBO15/ASE-15_0/init/logs/
sybmigrate0223.021' to be used as the migration log.
Migration Tool invoked with debug level 2.
Processing resource file 'test'...
ERROR|Expect an attribute, but got '"server=test"'.
ERROR|Failed to process resource file 'test'. Abort.


This is the resource file parameters

server=test
source_ase=test:5000
source_ase_login=sa
source_ase_password=test


target_ase=test:11000
source_ase_login=sa
source_ase_password=test


repository_database_size=7
repository_device=data7


migrate_server_data=yes
lock_account=no

source_database_name=PUBS1
target_database_name=PUBS1


migrate_database_data=yes

work_database_size=5
work_database_device=master

data_copy_thread=5

create_index_thread=1

work_thread=10

auto_select_dependent_objects=yes

Reply With Quote
  #2  
Old   
evoradba@yahoo.ca
 
Posts: n/a

Default Re: Sybse no interactive fails - 02-23-2009 , 03:30 PM






On Feb 23, 1:23*pm, evora... (AT) yahoo (DOT) ca wrote:
Quote:
Hello

I need to migrate Sybase using no-interactive resource file I cant use
GUI mode, I went through the documentation on line and I keep getting
the same error message

These are the errors, the target ASE is on sybase 15.03 on Solaris
5.8, the target is on the same O/S and is ASE 15.02

sybase@test:/u01/app/sybase/migrate$ sybmigrate -r test -m
migrate
* Opened file '/u02/app/sybase/COMBO15/ASE-15_0/init/logs/
sybmigrate0223.021' to be used as the migration log.
* Migration Tool invoked with debug level 2.
* Processing resource file 'test'...
* ERROR|Expect an attribute, but got '"server=test"'.
* ERROR|Failed to process resource file 'test'. Abort.

This is the resource file *parameters

server=test
source_ase=test:5000
source_ase_login=sa
source_ase_password=test

target_ase=test:11000
source_ase_login=sa
source_ase_password=test

repository_database_size=7
repository_device=data7

migrate_server_data=yes
lock_account=no

source_database_name=PUBS1
target_database_name=PUBS1

migrate_database_data=yes

work_database_size=5
work_database_device=master

data_copy_thread=5

create_index_thread=1

work_thread=10

auto_select_dependent_objects=yes


Now Im getting a different error i can connect to both source and
tagert and then aborts also I dont have any HA configuration done and
or java enabled




Opened file 'status' to be used as the migration log.
Migration Tool invoked with debug level 2.
Processing resource file 'migrate.rs'...
Processing resource file 'migrate.rs' complete.
Login to servers...
00:00000:00063:2009/02/23 16:30:09.95 Logon Login failed. User: sa,
Client IP address: '10.66.2.45'.
01:00000:00364:2009/02/23 16:30:10.00 Logon Login failed. User: sa,
Client IP address: '10.66.2.45'.
ERROR|Fail to connect to '10.66.2.45:11000'. Please check if server
is running and server name is correct.
Root Cause:Unexpected exception : SqlState: JZ00L
java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings
chained to this exception for the reason(s)., ErrorCode: 0Unexpected
exception : SqlState: 01ZZZ java.sql.SQLWarning: Login failed.
, ErrorCode: 4002Unexpected exception : SqlState: 010HA
java.sql.SQLWarning: 010HA: The server denied your request to use the
high-availability feature. Please reconfigure your database, or do
not request a high-availability session., ErrorCode: 0Unexpected
exception : SqlState: 01ZZZ java.sql.SQLWarning: Login failed.
, ErrorCode: 4002Unexpected exception : SqlState: 010HA
java.sql.SQLWarning: 010HA: The server denied your request to use the
high-availability feature. Please reconfigure your database, or do
not request a high-availability session., ErrorCode: 0



Reply With Quote
  #3  
Old   
mpeppler@peppler.org [Team Sybase]
 
Posts: n/a

Default Re: Sybse no interactive fails - 02-24-2009 , 03:54 AM



On Feb 23, 10:30*pm, evora... (AT) yahoo (DOT) ca wrote:

Quote:
Now Im getting a different error i can connect to both source and
tagert and then aborts also I dont have any HA configuration done and
or java enabled

Opened file 'status' to be used as the migration log.
* Migration Tool invoked with debug level 2.
* Processing resource file 'migrate.rs'...
* Processing resource file 'migrate.rs' complete.
* Login to servers...
00:00000:00063:2009/02/23 16:30:09.95 Logon *Login failed. User: sa,
Client IP address: '10.66.2.45'.
01:00000:00364:2009/02/23 16:30:10.00 Logon *Login failed. User: sa,
Client IP address: '10.66.2.45'.
Actually the login to the servers fails - most likely an incorrect
password, or maybe the 'sa' login is locked.

The HA message is a red-herring, and is completely irrelevant in this
case.

Michael


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.