|
Home > Archive > SQL Anywhere database replication > April 2005 > synchronize
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| I have to synchronize the database on the two servers in
which one I will make Consolidated and other Remote. I
don=92t want to use Dbextract feature so I have to locally
made publisher/remote database and define Message Type on
both Machine?
one more thing I want to clear is that User which is defined
as Remote User in Consolidated will be Publisher in Remote
Database or server and I have to Grant consolidated
Permission on Remote?
And If I am using File Message System, where should I put
Message Directory,
and how to provide path to that directory.
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-03-31, 8:02 pm |
| If you're not using dbxtract, then you need to manually define all the SQL
Remote definition on the remote yourself. As far as where the files should
be located, I'd suggest that on the machine where dbremote runs against the
consolidated (I'll call this machine "cons-pc"), create a directory in the
root of the C: drive called "msgs", and set this directory up as a shared
directory by right clicking on it and choosing "Sharing...". In this
directory create two directories, one called "cons" and one called "rem1"
which are the directories where incoming messages for each database will
reside. Here's some sample SQL that will create two database that use the
above message directories and should replicate database back and forth once
created. I didn't check the syntax on each command, but you should get the
general idea.
Consolidated Database:
GRANT CONNECT TO cons IDENTIFIED BY sql;
GRANT PUBLISH TO cons;
CREATE REMOTE MESSAGE TYPE file ADDRESS 'cons';
SET REMOTE file OPTION "PUBLIC"."directory" = 'c:\\msgs';
SET OPTION "PUBLIC".GLOBAL_DATABASE_ID = 0;
CREATE TABLE t1 ( pkey bigint default global autoincrement, c1 integer );
CREATE PUBLICATION p1 ( table t1 );
GRANT CONNECT TO rem1 IDENTIFIED BY sql;
GRANT REMOTE TO rem1 TYPE file ADDRESS 'rem1';
CREATE SUBSCRIPTION TO p1 FOR rem1;
START SUBSCRIPTION TO p1 FOR rem1;
Remote Database :
GRANT CONNECT TO rem1 IDENTIFIED BY sql;
GRANT PUBLISH TO rem1;
CREATE REMOTE MESSAGE TYPE file ADDRESS 'rem1';
SET REMOTE file OPTION "PUBLIC"."directory" = '\\\\cons-pc\\msgs';
SET OPTION PUBLIC.GLOBAL_DATABASE_ID = 1;
CREATE TABLE t1 ( pkey bigint default global autoincrement, c1 integer );
CREATE PUBLICATION p1 ( table t1 );
GRANT CONNECT TO cons IDENTIFIED BY sql;
GRANT CONSOLIDATE TO cons TYPE file ADDRESS 'cons';
CREATE SUBSCRIPTION TO p1 FOR cons;
START SUBSCRIPTION TO p1 FOR cons;
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
<Sumy> wrote in message news:424be95c.3a0.1681692777@sybase.com...
> I have to synchronize the database on the two servers in
> which one I will make Consolidated and other Remote. I
> don't want to use Dbextract feature so I have to locally
> made publisher/remote database and define Message Type on
> both Machine?
> one more thing I want to clear is that User which is defined
> as Remote User in Consolidated will be Publisher in Remote
> Database or server and I have to Grant consolidated
> Permission on Remote?
>
> And If I am using File Message System, where should I put
> Message Directory,
> and how to provide path to that directory.
>
| |
| Breck Carter [TeamSybase] 2005-03-31, 8:02 pm |
| In addition to what Reg said, one way to find out what you need to do
is to run dbxtract once and examine the output SQL.
Breck
On 31 Mar 2005 04:13:20 -0800, Sumy wrote:
>I have to synchronize the database on the two servers in
>which one I will make Consolidated and other Remote. I
>don’t want to use Dbextract feature so I have to locally
>made publisher/remote database and define Message Type on
>both Machine?
>one more thing I want to clear is that User which is defined
>as Remote User in Consolidated will be Publisher in Remote
>Database or server and I have to Grant consolidated
>Permission on Remote?
>
>And If I am using File Message System, where should I put
>Message Directory,
>and how to provide path to that directory.
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
| |
|
| Thank you very much for this guidance.
I have certain more confusion in this command. As I have
done through SQL Central.
1. Dbremote will be running on both machines (because of two
way replication.)
2. Can you tell me how to run db-remote if data has to sent
from consolidated to remote site and vice versa.
And every time data to be replicated we have to give this
command.
3.> GRANT CONNECT TO cons IDENTIFIED BY sql;
Here you are connecting the Directory 'cons' or connecting
New User Name =91cons=92
And why this =93IDENTIFIED BY =93sql=94?
4.> GRANT PUBLISH TO cons,
Is here you are making user publisher?
5. >SET REMOTE file OPTION "PUBLIC"."directory" =3d
'c:\\msgs';
Here you are creating remote user? Or what it means?
6. SET OPTION "PUBLIC".GLOBAL_DATABASE_ID =3d 0;
What does it mean?
Is =91rem1=92 is remote user and =91cons=92 is publisher?
Please Clear my confusion
regards,
> If you're not using dbxtract, then you need to manually
> define all the SQL Remote definition on the remote
> yourself. As far as where the files should be located,
> I'd suggest that on the machine where dbremote runs
> against the consolidated (I'll call this machine
> "cons-pc"), create a directory in the root of the C: drive
> called "msgs", and set this directory up as a shared
> directory by right clicking on it and choosing
> "Sharing...". In this directory create two directories,
> one called "cons" and one called "rem1" which are the
> directories where incoming messages for each database will
> reside. Here's some sample SQL that will create two
> database that use the above message directories and should
> replicate database back and forth once created. I didn't
> check the syntax on each command, but you should get the
> general idea.
>
> Consolidated Database:
>
> GRANT CONNECT TO cons IDENTIFIED BY sql;
> GRANT PUBLISH TO cons;
> CREATE REMOTE MESSAGE TYPE file ADDRESS 'cons';
> SET REMOTE file OPTION "PUBLIC"."directory" =3d
'c:\\msgs';
> SET OPTION "PUBLIC".GLOBAL_DATABASE_ID =3d 0;
> CREATE TABLE t1 ( pkey bigint default global autoincrement
> , c1 integer ); CREATE PUBLICATION p1 ( table t1 );
> GRANT CONNECT TO rem1 IDENTIFIED BY sql;
> GRANT REMOTE TO rem1 TYPE file ADDRESS 'rem1';
> CREATE SUBSCRIPTION TO p1 FOR rem1;
> START SUBSCRIPTION TO p1 FOR rem1;
>
> Remote Database :
>
> GRANT CONNECT TO rem1 IDENTIFIED BY sql;
> GRANT PUBLISH TO rem1;
> CREATE REMOTE MESSAGE TYPE file ADDRESS 'rem1';
> SET REMOTE file OPTION "PUBLIC"."directory" =3d
> '\\\\cons-pc\\msgs'; SET OPTION PUBLIC.GLOBAL_DATABASE_ID
> =3d 1; CREATE TABLE t1 ( pkey bigint default global
> autoincrement, c1 integer ); CREATE PUBLICATION p1 ( table
> t1 ); GRANT CONNECT TO cons IDENTIFIED BY sql;
> GRANT CONSOLIDATE TO cons TYPE file ADDRESS 'cons';
> CREATE SUBSCRIPTION TO p1 FOR cons;
> START SUBSCRIPTION TO p1 FOR cons;
>
>
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer
> Version 8 Please reply only to the newsgroup
>
> iAnywhere Developer Community :
> http://www.ianywhere.com/developer iAnywhere Documentation
> : http://www.ianywhere.com/developer/product_manuals ASA
> Patches and EBFs :
> http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> <Sumy> wrote in message
>
>
| |
|
| Thanku you breck I did that.
And concept related to that is cleared like creating
publisher,consolidat
ed,remote user is cleared.
> In addition to what Reg said, one way to find out what you
> need to do is to run dbxtract once and examine the output
> SQL.
>
> Breck
>
> On 31 Mar 2005 04:13:20 -0800, Sumy wrote:
>
locally[color=darkre
d]
> defined >as Remote User in Consolidated will be Publisher
> in Remote >Database or server and I have to Grant
> consolidated >Permission on Remote?
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
>
http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-03-31, 8:02 pm |
| Answer in-line, with sections of the ASA documentation (v902) for more
information about each command. A link to iAnywhere documentation can be
found in my footer. I would also suggest that you have a read through the
following tutorial, so you understand the basic concepts involved with
setting up a SQL Remote system :
SQL Remote User's Guide
Tutorials for Adaptive Server Anywhere Users
Tutorial: Adaptive Server Anywhere replication using Interactive SQL and
dbxtract
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
<sumy> wrote in message news:424c4a84.6e3e.1681692777@sybase.com...
> Thank you very much for this guidance.
>
> I have certain more confusion in this command. As I have
> done through SQL Central.
> 1. Dbremote will be running on both machines (because of two
> way replication.)
Correct. A dbremote process will run on the machine where the consolidated
database resides and connect to the consolidated database and another
process will run on the remote machine and connect to the remote database.
Both of these dbremote processes will be written message files in the same
directory.
> 2. Can you tell me how to run db-remote if data has to sent
> from consolidated to remote site and vice versa.
> And every time data to be replicated we have to give this
> command.
You run dbremote and connect to the database you want to send and receive
messages.
SQL Remote User's Guide
Utilities and Options Reference
The Message Agent
> 3.> GRANT CONNECT TO cons IDENTIFIED BY sql;
> Here you are connecting the Directory 'cons' or connecting
> New User Name 'cons'
> And why this "IDENTIFIED BY "sql"?
I am creating a new database user.
ASA SQL Reference
SQL Statements
GRANT statement
> 4.> GRANT PUBLISH TO cons,
> Is here you are making user publisher?
ASA SQL Reference
SQL Statements
GRANT PUBLISH statement [SQL Remote]
> 5. >SET REMOTE file OPTION "PUBLIC"."directory" =
> 'c:\\msgs';
> Here you are creating remote user? Or what it means?
ASA SQL Reference
SQL Statements
SET REMOTE OPTION statement [SQL Remote]
> 6. SET OPTION "PUBLIC".GLOBAL_DATABASE_ID = 0;
> What does it mean?
I'm using GLOBAL AUTOINCREMENT as the primary key of the table in my sample
to ensure primary key uniquenesss on all the databases in the replicating
system.
ASA Database Administration Guide
Database Options
Alphabetical list of options
GLOBAL_DATABASE_ID option [database]
> Is 'rem1' is remote user and 'cons' is publisher?
On the consolidated database, yes.
> Please Clear my confusion
> regards,
> If you're not using dbxtract, then you need to manually
> define all the SQL Remote definition on the remote
> yourself. As far as where the files should be located,
> I'd suggest that on the machine where dbremote runs
> against the consolidated (I'll call this machine
> "cons-pc"), create a directory in the root of the C: drive
> called "msgs", and set this directory up as a shared
> directory by right clicking on it and choosing
> "Sharing...". In this directory create two directories,
> one called "cons" and one called "rem1" which are the
> directories where incoming messages for each database will
> reside. Here's some sample SQL that will create two
> database that use the above message directories and should
> replicate database back and forth once created. I didn't
> check the syntax on each command, but you should get the
> general idea.
>
> Consolidated Database:
>
> GRANT CONNECT TO cons IDENTIFIED BY sql;
> GRANT PUBLISH TO cons;
> CREATE REMOTE MESSAGE TYPE file ADDRESS 'cons';
> SET REMOTE file OPTION "PUBLIC"."directory" =
'c:\\msgs';
> SET OPTION "PUBLIC".GLOBAL_DATABASE_ID = 0;
> CREATE TABLE t1 ( pkey bigint default global autoincrement
> , c1 integer ); CREATE PUBLICATION p1 ( table t1 );
> GRANT CONNECT TO rem1 IDENTIFIED BY sql;
> GRANT REMOTE TO rem1 TYPE file ADDRESS 'rem1';
> CREATE SUBSCRIPTION TO p1 FOR rem1;
> START SUBSCRIPTION TO p1 FOR rem1;
>
> Remote Database :
>
> GRANT CONNECT TO rem1 IDENTIFIED BY sql;
> GRANT PUBLISH TO rem1;
> CREATE REMOTE MESSAGE TYPE file ADDRESS 'rem1';
> SET REMOTE file OPTION "PUBLIC"."directory" =
> '\\\\cons-pc\\msgs'; SET OPTION PUBLIC.GLOBAL_DATABASE_ID
> = 1; CREATE TABLE t1 ( pkey bigint default global
> autoincrement, c1 integer ); CREATE PUBLICATION p1 ( table
> t1 ); GRANT CONNECT TO cons IDENTIFIED BY sql;
> GRANT CONSOLIDATE TO cons TYPE file ADDRESS 'cons';
> CREATE SUBSCRIPTION TO p1 FOR cons;
> START SUBSCRIPTION TO p1 FOR cons;
>
>
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer
> Version 8 Please reply only to the newsgroup
>
> iAnywhere Developer Community :
> http://www.ianywhere.com/developer iAnywhere Documentation
> : http://www.ianywhere.com/developer/product_manuals ASA
> Patches and EBFs :
> http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> <Sumy> wrote in message
>
>
| |
|
| Thank you very much for this guidance.
I have certain more confusion in this command. As I have
done through SQL Central.
1. Dbremote will be running on both machines (because of two
way replication.)
2. Can you tell me how to run db-remote if data has to sent
from consolidated to remote site and vice versa.
And every time data to be replicated we have to give this
command.
3.> GRANT CONNECT TO cons IDENTIFIED BY sql;
Here you are connecting the Directory 'cons' or connecting
New User Name =91cons=92
And why this =93IDENTIFIED BY =93sql=94?
4.> GRANT PUBLISH TO cons,
Is here you are making user publisher?
5. >SET REMOTE file OPTION "PUBLIC"."directory" 'c:\\msgs';
Here you are creating remote user? Or what it means?
6. SET OPTION "PUBLIC".GLOBAL_DATABASE_ID =3d 0;
What does it mean?
Is =91rem1=92 is remote user and =91cons=92 is publisher?
Please Clear my confusion
regards,
> Thanku you breck I did that.
> And concept related to that is cleared like creating
> publisher,consolidat
ed,remote user is cleared.
> locally
>
http://www.amazon.com/exec/obidos/A...7/risingroad-20[color=darkred]
| |
|
| First of all Thank you for the way you have described me
everything.
I have done everything as you described me and now all
commands are clear to me
Only this one is not clear I tried to read it there.
SET OPTION "PUBLIC".GLOBAL_DATABASE_ID =3d 0
But it does not work, and is giving error in Replication.
For Replication I have given the command
(dbremote -c =93uid=3ddba;pwd=3ds
ql;dbf=3dpath where db
is=94)
Did not work?
Here is what error it is giving on both Consolidate
Database and Remote Database.
From Consolidate Database
I. 04/01 16:12:39. Scanning logs starting at offset
0655048165
I. 04/01 16:12:39. Processing transaction logs from
directory "C:\TRS\"
I. 04/01 16:12:39. Processing transactions from active
transaction log
I. 04/01 16:12:39. Sending message to "rem1"
(0-0000000000-0655053435-0)
I. 04/01 16:12:39. sopen "\c:\msgs\rem1\cons.0" failure 123:
Invalid argument
I. 04/01 16:12:39. sopen "\c:\msgs\rem1\cons.1" failure 123:
Invalid argument
I. 04/01 16:12:39. sopen "\c:\msgs\rem1\cons.2" failure 123:
Invalid argument
I. 04/01 16:12:39. sopen "\c:\msgs\rem1\cons.3" failure 123:
Invalid argument
I. 04/01 16:12:39. sopen "\c:\msgs\rem1\cons.4" failure 123:
Invalid argument
I. 04/01 16:12:39. Resend requests are being queued
I. 04/01 16:12:40. Execution completed
From Remote Database
I. 04/01 15:51:25. Scanning logs starting at offset
0655046355
I. 04/01 15:51:25. Processing transaction logs from
directory "D:\TRS\"
I. 04/01 15:51:25. Processing transactions from active
transaction log
I. 04/01 15:51:25. Sending message to "cons"
(0-0000000000-0655051073-0)
I. 04/01 15:51:25. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.0"
failure 53: No such file or directory
I. 04/01 15:51:26. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.1"
failure 53: No such file or directory
I. 04/01 15:51:26. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.2"
failure 53: No such file or directory
I. 04/01 15:51:26. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.3"
failure 53: No such file or directory
I. 04/01 15:51:27. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.4"
failure 53: No such file or directory
I. 04/01 15:51:27. Resend requests are being queued
I. 04/01 15:51:27. Execution completed
One more question I am using File Message Type to do
Replication locally on two machines.
Is it possible to use FILE Message Type on two different
Serves in two different countries, if yes then in the same
way if it works and if no then what other Message Type.
In our office we can use FTP files Message type, if I have
to use that then I have to configure it in the same way with
extra parameters.
Can you guide from where to read more about FTP.
What are requirement of FTP?
Thank again
Regards,
sumy
> Answer in-line, with sections of the ASA documentation
> (v902) for more information about each command. A link to
> iAnywhere documentation can be found in my footer. I
> would also suggest that you have a read through the
> following tutorial, so you understand the basic concepts
> involved with setting up a SQL Remote system :
>
> SQL Remote User's Guide
> Tutorials for Adaptive Server Anywhere Users
> Tutorial: Adaptive Server Anywhere replication using
> Interactive SQL and dbxtract
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer
> Version 8 Please reply only to the newsgroup
>
> iAnywhere Developer Community :
> http://www.ianywhere.com/developer iAnywhere Documentation
> : http://www.ianywhere.com/developer/product_manuals ASA
> Patches and EBFs :
> http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> <sumy> wrote in message
> very much for this guidance. >
>
> Correct. A dbremote process will run on the machine where
> the consolidated database resides and connect to the
> consolidated database and another process will run on the
> remote machine and connect to the remote database. Both of
> these dbremote processes will be written message files in
> the same directory.
>
>
> You run dbremote and connect to the database you want to
> send and receive messages.
>
> SQL Remote User's Guide
> Utilities and Options Reference
> The Message Agent
>
>
> I am creating a new database user.
>
> ASA SQL Reference
> SQL Statements
> GRANT statement
>
>
> ASA SQL Reference
> SQL Statements
> GRANT PUBLISH statement [SQL Remote]
>
>
> ASA SQL Reference
> SQL Statements
> SET REMOTE OPTION statement [SQL Remote]
>
>
> I'm using GLOBAL AUTOINCREMENT as the primary key of the
> table in my sample to ensure primary key uniquenesss on
> all the databases in the replicating system.
>
> ASA Database Administration Guide
> Database Options
> Alphabetical list of options
> GLOBAL_DATABASE_ID option [database]
>
>
> On the consolidated database, yes.
>
>
>
> 'c:\\msgs';
> "Time Frame" to ALL >
>
>
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-04-01, 8:02 pm |
| What version of ASA are you using?
Can you post the entire SQL Remote log?
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
<sumy> wrote in message news:424d5a40.141a.1681692777@sybase.com...
First of all Thank you for the way you have described me
everything.
I have done everything as you described me and now all
commands are clear to me
Only this one is not clear I tried to read it there.
SET OPTION "PUBLIC".GLOBAL_DATABASE_ID = 0
But it does not work, and is giving error in Replication.
For Replication I have given the command
(dbremote -c " uid=dba;pwd=sql;dbf=
path where db
is")
Did not work?
Here is what error it is giving on both Consolidate
Database and Remote Database.
From Consolidate Database
I. 04/01 16:12:39. Scanning logs starting at offset
0655048165
I. 04/01 16:12:39. Processing transaction logs from
directory "C:\TRS\"
I. 04/01 16:12:39. Processing transactions from active
transaction log
I. 04/01 16:12:39. Sending message to "rem1"
(0-0000000000-0655053435-0)
I. 04/01 16:12:39. sopen "\c:\msgs\rem1\cons.0" failure 123:
Invalid argument
I. 04/01 16:12:39. sopen "\c:\msgs\rem1\cons.1" failure 123:
Invalid argument
I. 04/01 16:12:39. sopen "\c:\msgs\rem1\cons.2" failure 123:
Invalid argument
I. 04/01 16:12:39. sopen "\c:\msgs\rem1\cons.3" failure 123:
Invalid argument
I. 04/01 16:12:39. sopen "\c:\msgs\rem1\cons.4" failure 123:
Invalid argument
I. 04/01 16:12:39. Resend requests are being queued
I. 04/01 16:12:40. Execution completed
From Remote Database
I. 04/01 15:51:25. Scanning logs starting at offset
0655046355
I. 04/01 15:51:25. Processing transaction logs from
directory "D:\TRS\"
I. 04/01 15:51:25. Processing transactions from active
transaction log
I. 04/01 15:51:25. Sending message to "cons"
(0-0000000000-0655051073-0)
I. 04/01 15:51:25. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.0"
failure 53: No such file or directory
I. 04/01 15:51:26. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.1"
failure 53: No such file or directory
I. 04/01 15:51:26. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.2"
failure 53: No such file or directory
I. 04/01 15:51:26. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.3"
failure 53: No such file or directory
I. 04/01 15:51:27. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.4"
failure 53: No such file or directory
I. 04/01 15:51:27. Resend requests are being queued
I. 04/01 15:51:27. Execution completed
One more question I am using File Message Type to do
Replication locally on two machines.
Is it possible to use FILE Message Type on two different
Serves in two different countries, if yes then in the same
way if it works and if no then what other Message Type.
In our office we can use FTP files Message type, if I have
to use that then I have to configure it in the same way with
extra parameters.
Can you guide from where to read more about FTP.
What are requirement of FTP?
Thank again
Regards,
sumy
> Answer in-line, with sections of the ASA documentation
> (v902) for more information about each command. A link to
> iAnywhere documentation can be found in my footer. I
> would also suggest that you have a read through the
> following tutorial, so you understand the basic concepts
> involved with setting up a SQL Remote system :
>
> SQL Remote User's Guide
> Tutorials for Adaptive Server Anywhere Users
> Tutorial: Adaptive Server Anywhere replication using
> Interactive SQL and dbxtract
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer
> Version 8 Please reply only to the newsgroup
>
> iAnywhere Developer Community :
> http://www.ianywhere.com/developer iAnywhere Documentation
> : http://www.ianywhere.com/developer/product_manuals ASA
> Patches and EBFs :
> http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> <sumy> wrote in message
> very much for this guidance. >
>
> Correct. A dbremote process will run on the machine where
> the consolidated database resides and connect to the
> consolidated database and another process will run on the
> remote machine and connect to the remote database. Both of
> these dbremote processes will be written message files in
> the same directory.
>
>
> You run dbremote and connect to the database you want to
> send and receive messages.
>
> SQL Remote User's Guide
> Utilities and Options Reference
> The Message Agent
>
>
> I am creating a new database user.
>
> ASA SQL Reference
> SQL Statements
> GRANT statement
>
>
> ASA SQL Reference
> SQL Statements
> GRANT PUBLISH statement [SQL Remote]
>
>
> ASA SQL Reference
> SQL Statements
> SET REMOTE OPTION statement [SQL Remote]
>
>
> I'm using GLOBAL AUTOINCREMENT as the primary key of the
> table in my sample to ensure primary key uniquenesss on
> all the databases in the replicating system.
>
> ASA Database Administration Guide
> Database Options
> Alphabetical list of options
> GLOBAL_DATABASE_ID option [database]
>
>
> On the consolidated database, yes.
>
>
>
> 'c:\\msgs';
> "Time Frame" to ALL >
>
>
| |
|
| I am using 8.0 VERSION.
REMOTE LOG IS HERE
130940K of memory used for caching
Minimum cache size: 130940K, maximum cache size: 262144K
Using a maximum page size of 2048 bytes
Starting database "trs_be" (C:\TRS\trs_be.db) at Fri Apr 01
2005 16:56
Transaction log: TRS_BE.log
Starting checkpoint of "trs_be" (trs_be.db) at Fri Apr 01
2005 16:56
Finished checkpoint of "trs_be" (trs_be.db) at Fri Apr 01
2005 16:56
Database "trs_be" (trs_be.db) started at Fri Apr 01 2005
16:56
Page size too small for this database
Database server started at Fri Apr 01 2005 16:56
Trying to start SharedMemory link ...
SharedMemory link started successfully
Trying to start NamedPipes link ...
NamedPipes link started successfully
Trying to start TDS (TCPIP) link ...
Starting on port 2638
TDS (TCPIP) link started successfully
Now accepting requests
> What version of ASA are you using?
> Can you post the entire SQL Remote log?
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer
> Version 8 Please reply only to the newsgroup
>
> iAnywhere Developer Community :
> http://www.ianywhere.com/developer iAnywhere Documentation
> : http://www.ianywhere.com/developer/product_manuals ASA
> Patches and EBFs :
> http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> <sumy> wrote in message
> news:424d5a40.141a.1681692777@sybase.com... First of all
> Thank you for the way you have described me everything.
> I have done everything as you described me and now all
> commands are clear to me
> Only this one is not clear I tried to read it there.
>
> SET OPTION "PUBLIC".GLOBAL_DATABASE_ID = 0
>
> But it does not work, and is giving error in Replication.
> For Replication I have given the command
>
> (dbremote -c " uid=dba;pwd=sql;dbf=
path where db
> is")
>
> Did not work?
>
> Here is what error it is giving on both Consolidate
> Database and Remote Database.
>
> From Consolidate Database
>
> I. 04/01 16:12:39. Scanning logs starting at offset
> 0655048165
> I. 04/01 16:12:39. Processing transaction logs from
> directory "C:\TRS\"
> I. 04/01 16:12:39. Processing transactions from active
> transaction log
> I. 04/01 16:12:39. Sending message to "rem1"
> (0-0000000000-0655053435-0)
> I. 04/01 16:12:39. sopen "\c:\msgs\rem1\cons.0" failure
> 123: Invalid argument
> I. 04/01 16:12:39. sopen "\c:\msgs\rem1\cons.1" failure
> 123: Invalid argument
> I. 04/01 16:12:39. sopen "\c:\msgs\rem1\cons.2" failure
> 123: Invalid argument
> I. 04/01 16:12:39. sopen "\c:\msgs\rem1\cons.3" failure
> 123: Invalid argument
> I. 04/01 16:12:39. sopen "\c:\msgs\rem1\cons.4" failure
> 123: Invalid argument
> I. 04/01 16:12:39. Resend requests are being queued
> I. 04/01 16:12:40. Execution completed
>
> From Remote Database
> I. 04/01 15:51:25. Scanning logs starting at offset
> 0655046355
> I. 04/01 15:51:25. Processing transaction logs from
> directory "D:\TRS\"
> I. 04/01 15:51:25. Processing transactions from active
> transaction log
> I. 04/01 15:51:25. Sending message to "cons"
> (0-0000000000-0655051073-0)
> I. 04/01 15:51:25. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.0" failure 53: No such
> file or directory I. 04/01 15:51:26. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.1" failure 53: No such
> file or directory I. 04/01 15:51:26. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.2" failure 53: No such
> file or directory I. 04/01 15:51:26. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.3" failure 53: No such
> file or directory I. 04/01 15:51:27. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.4" failure 53: No such
> file or directory I. 04/01 15:51:27. Resend requests are
> being queued I. 04/01 15:51:27. Execution completed
>
>
>
> One more question I am using File Message Type to do
> Replication locally on two machines.
> Is it possible to use FILE Message Type on two different
> Serves in two different countries, if yes then in the same
> way if it works and if no then what other Message Type.
>
> In our office we can use FTP files Message type, if I have
> to use that then I have to configure it in the same way
> with extra parameters.
>
> Can you guide from where to read more about FTP.
> What are requirement of FTP?
>
> Thank again
> Regards,
> sumy
>
>
>
>
> "Time Frame" to ALL >
>
>
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-04-01, 8:02 pm |
| This is the log from the database engine. Please post the contents of the
SQL Remote log that was generated.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
<SUMY> wrote in message news:424d613f.151d.1681692777@sybase.com...[color=darkred]
> I am using 8.0 VERSION.
>
> REMOTE LOG IS HERE
>
>
> 130940K of memory used for caching
> Minimum cache size: 130940K, maximum cache size: 262144K
> Using a maximum page size of 2048 bytes
> Starting database "trs_be" (C:\TRS\trs_be.db) at Fri Apr 01
> 2005 16:56
> Transaction log: TRS_BE.log
> Starting checkpoint of "trs_be" (trs_be.db) at Fri Apr 01
> 2005 16:56
> Finished checkpoint of "trs_be" (trs_be.db) at Fri Apr 01
> 2005 16:56
> Database "trs_be" (trs_be.db) started at Fri Apr 01 2005
> 16:56
> Page size too small for this database
> Database server started at Fri Apr 01 2005 16:56
> Trying to start SharedMemory link ...
>
> SharedMemory link started successfully
>
> Trying to start NamedPipes link ...
>
> NamedPipes link started successfully
>
> Trying to start TDS (TCPIP) link ...
>
> Starting on port 2638
> TDS (TCPIP) link started successfully
>
> Now accepting requests
>
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-04-01, 8:02 pm |
| Please also post the exact version and build number that you are using. For
example : v8.0.2.4408. Running dbeng8 -v will provided you with this
information.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
<SUMY> wrote in message news:424d613f.151d.1681692777@sybase.com...[color=darkred]
> I am using 8.0 VERSION.
>
> REMOTE LOG IS HERE
>
>
> 130940K of memory used for caching
> Minimum cache size: 130940K, maximum cache size: 262144K
> Using a maximum page size of 2048 bytes
> Starting database "trs_be" (C:\TRS\trs_be.db) at Fri Apr 01
> 2005 16:56
> Transaction log: TRS_BE.log
> Starting checkpoint of "trs_be" (trs_be.db) at Fri Apr 01
> 2005 16:56
> Finished checkpoint of "trs_be" (trs_be.db) at Fri Apr 01
> 2005 16:56
> Database "trs_be" (trs_be.db) started at Fri Apr 01 2005
> 16:56
> Page size too small for this database
> Database server started at Fri Apr 01 2005 16:56
> Trying to start SharedMemory link ...
>
> SharedMemory link started successfully
>
> Trying to start NamedPipes link ...
>
> NamedPipes link started successfully
>
> Trying to start TDS (TCPIP) link ...
>
> Starting on port 2638
> TDS (TCPIP) link started successfully
>
> Now accepting requests
>
| |
|
| SQL Remote log that was generated what is this?
The one I send earlier is the one I am using dbremote on
command window, and it is generated and another you are
saying from database enginge.
How will I get that?
regards,
> This is the log from the database engine. Please post the
> contents of the SQL Remote log that was generated.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer
> Version 8 Please reply only to the newsgroup
>
> iAnywhere Developer Community :
> http://www.ianywhere.com/developer iAnywhere Documentation
> : http://www.ianywhere.com/developer/product_manuals ASA
> Patches and EBFs :
> http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> <SUMY> wrote in message
> 8.0 VERSION. >
> syntax on each command, but you should get the general
>
>
| |
|
| The one genertated On Consolidated database:
I. 04/04 10:54:05. SQL Remote Message Agent Version
8.0.2.3601
I. 04/04 10:54:05.
I. 04/04 10:54:05. Copyright =a9 1989-2002 Sybase, Inc.
Portions Copyright =a9 2002, iAnywhere
Solutions, Inc.
I. 04/04 10:54:05. All rights reserved. All unpublished
rights reserved.
I. 04/04 10:54:05.
I. 04/04 10:54:05. This software contains confidential and
trade secret information of
I. 04/04 10:54:05. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the
software and documentation
I. 04/04 10:54:05. by the U.S. Government is subject to
restrictions set forth in a license
I. 04/04 10:54:05. agreement between the Government and
iAnywhere Solutions, Inc. or
I. 04/04 10:54:05. other written agreement specifying the
Government's rights to use the
I. 04/04 10:54:05. software and any applicable FAR
provisions, for example, FAR 52.227-19.
I. 04/04 10:54:05.
I. 04/04 10:54:05. Sybase, Inc., One Sybase Drive, Dublin,
CA 94568, USA
I. 04/04 10:54:05.
I. 04/04 10:54:05. Scanning logs starting at offset
0655048165
I. 04/04 10:54:05. Processing transaction logs from
directory "C:\TRS\"
I. 04/04 10:54:05. Processing transactions from active
transaction log
I. 04/04 10:54:05. Sending message to "rem1"
(0-0000000000-0655053725-0)
I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.0" failure 123:
Invalid argument
I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.1" failure 123:
Invalid argument
I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.2" failure 123:
Invalid argument
I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.3" failure 123:
Invalid argument
I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.4" failure 123:
Invalid argument
I. 04/04 10:54:05. Resend requests are being queued
I. 04/04 10:54:06. Execution completed
One generated at remote database:
I. 04/04 10:55:09. SQL Remote Message Agent Version
8.0.2.4299
I. 04/04 10:55:09.
I. 04/04 10:55:09. Copyright =a9 1989-2002 Sybase, Inc.
Portions Copyright =a9 2002, iAnywhere
Solutions, Inc.
I. 04/04 10:55:09. All rights reserved. All unpublished
rights reserved.
I. 04/04 10:55:09.
I. 04/04 10:55:09. This software contains confidential and
trade secret information of
I. 04/04 10:55:09. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the
software and documentation
I. 04/04 10:55:09. by the U.S. Government is subject to
restrictions set forth in a license
I. 04/04 10:55:09. agreement between the Government and
iAnywhere Solutions, Inc. or
I. 04/04 10:55:09. other written agreement specifying the
Government's rights to use the
I. 04/04 10:55:09. software and any applicable FAR
provisions, for example, FAR 52.227-19.
I. 04/04 10:55:09.
I. 04/04 10:55:09. Sybase, Inc., One Sybase Drive, Dublin,
CA 94568, USA
I. 04/04 10:55:09.
I. 04/04 10:55:35. Scanning logs starting at offset
0655046355
I. 04/04 10:55:35. Processing transaction logs from
directory "D:\TRS\"
I. 04/04 10:55:35. Processing transactions from active
transaction log
I. 04/04 10:55:35. Sending message to "cons"
(0-0000000000-0655051301-0)
I. 04/04 10:55:35. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.0"
failure 53: No such file or directory
I. 04/04 10:55:35. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.1"
failure 53: No such file or directory
I. 04/04 10:55:35. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.2"
failure 53: No such file or directory
I. 04/04 10:55:35. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.3"
failure 53: No such file or directory
I. 04/04 10:55:35. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.4"
failure 53: No such file or directory
I. 04/04 10:55:35. Resend requests are being queued
I. 04/04 10:55:35. Execution completed
[color=darkred]
> SQL Remote log that was generated what is this?
>
> The one I send earlier is the one I am using dbremote on
> command window, and it is generated and another you are
> saying from database enginge.
>
> How will I get that?
>
> regards,
>
> "Time Frame" to ALL >
db[color=darkred]
([color=darkred]
> http://www.ianywhere.com/developer/product_manuals ASA
| |
|
| I want to clear one thing that the Directory 'msgs' should
be created on consolidated database or remote database's
place.
Please clear my all these confusion.
Regards,
[color=darkred]
> The one genertated On Consolidated database:
>
> I. 04/04 10:54:05. SQL Remote Message Agent Version
> 8.0.2.3601
> I. 04/04 10:54:05.
> I. 04/04 10:54:05. Copyright =a9 1989-2002 Sybase, Inc.
> Portions Copyright =a9 2002, iAnywhere
> Solutions, Inc.
> I. 04/04 10:54:05. All rights reserved. All unpublished
> rights reserved.
> I. 04/04 10:54:05.
> I. 04/04 10:54:05. This software contains confidential and
> trade secret information of
> I. 04/04 10:54:05. iAnywhere Solutions, Inc.
> Use, duplication or disclosure of the
> software and documentation
> I. 04/04 10:54:05. by the U.S. Government is subject to
> restrictions set forth in a license
> I. 04/04 10:54:05. agreement between the Government and
> iAnywhere Solutions, Inc. or
> I. 04/04 10:54:05. other written agreement specifying the
> Government's rights to use the
> I. 04/04 10:54:05. software and any applicable FAR
> provisions, for example, FAR 52.227-19.
> I. 04/04 10:54:05.
> I. 04/04 10:54:05. Sybase, Inc., One Sybase Drive, Dublin,
> CA 94568, USA
> I. 04/04 10:54:05.
> I. 04/04 10:54:05. Scanning logs starting at offset
> 0655048165
> I. 04/04 10:54:05. Processing transaction logs from
> directory "C:\TRS\"
> I. 04/04 10:54:05. Processing transactions from active
> transaction log
> I. 04/04 10:54:05. Sending message to "rem1"
> (0-0000000000-0655053725-0)
> I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.0" failure
> 123: Invalid argument
> I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.1" failure
> 123: Invalid argument
> I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.2" failure
> 123: Invalid argument
> I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.3" failure
> 123: Invalid argument
> I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.4" failure
> 123: Invalid argument
> I. 04/04 10:54:05. Resend requests are being queued
> I. 04/04 10:54:06. Execution completed
>
> One generated at remote database:
>
> I. 04/04 10:55:09. SQL Remote Message Agent Version
> 8.0.2.4299
> I. 04/04 10:55:09.
> I. 04/04 10:55:09. Copyright =a9 1989-2002 Sybase, Inc.
> Portions Copyright =a9 2002, iAnywhere
> Solutions, Inc.
> I. 04/04 10:55:09. All rights reserved. All unpublished
> rights reserved.
> I. 04/04 10:55:09.
> I. 04/04 10:55:09. This software contains confidential and
> trade secret information of
> I. 04/04 10:55:09. iAnywhere Solutions, Inc.
> Use, duplication or disclosure of the
> software and documentation
> I. 04/04 10:55:09. by the U.S. Government is subject to
> restrictions set forth in a license
> I. 04/04 10:55:09. agreement between the Government and
> iAnywhere Solutions, Inc. or
> I. 04/04 10:55:09. other written agreement specifying the
> Government's rights to use the
> I. 04/04 10:55:09. software and any applicable FAR
> provisions, for example, FAR 52.227-19.
> I. 04/04 10:55:09.
> I. 04/04 10:55:09. Sybase, Inc., One Sybase Drive, Dublin,
> CA 94568, USA
> I. 04/04 10:55:09.
> I. 04/04 10:55:35. Scanning logs starting at offset
> 0655046355
> I. 04/04 10:55:35. Processing transaction logs from
> directory "D:\TRS\"
> I. 04/04 10:55:35. Processing transactions from active
> transaction log
> I. 04/04 10:55:35. Sending message to "cons"
> (0-0000000000-0655051301-0)
> I. 04/04 10:55:35. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.0" failure 53: No such
> file or directory I. 04/04 10:55:35. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.1" failure 53: No such
> file or directory I. 04/04 10:55:35. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.2" failure 53: No such
> file or directory I. 04/04 10:55:35. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.3" failure 53: No such
> file or directory I. 04/04 10:55:35. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.4" failure 53: No such
> file or directory I. 04/04 10:55:35. Resend requests are
> being queued I. 04/04 10:55:35. Execution completed
>
>
>
>
>
>
>
where[color=darkred]
> db
> http://www.ianywhere.com/developer/product_manuals ASA
0;[color=darkred]
TABLE[color=darkred]
> PUBLIC.GLOBAL_DATABASE_ID =3d 1; CREATE TABLE t1 (
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-04-04, 8:03 pm |
| It appears that you have an extra backslash in your path
> I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.0" failure 123:
> Invalid argument
I suspect that you mis-typed the SET REMOTE option command on the
consolidated, which should have looked similar to :
SET REMOTE file OPTION "PUBLIC"."directory" = 'c:\\msgs';
Yes, the msgs directory exists on the machine where the consolidated
database runs.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
<sumy> wrote in message news:4251044f.48bc.1681692777@sybase.com...
The one genertated On Consolidated database:
I. 04/04 10:54:05. SQL Remote Message Agent Version
8.0.2.3601
I. 04/04 10:54:05.
I. 04/04 10:54:05. Copyright © 1989-2002 Sybase, Inc.
Portions Copyright © 2002, iAnywhere
Solutions, Inc.
I. 04/04 10:54:05. All rights reserved. All unpublished
rights reserved.
I. 04/04 10:54:05.
I. 04/04 10:54:05. This software contains confidential and
trade secret information of
I. 04/04 10:54:05. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the
software and documentation
I. 04/04 10:54:05. by the U.S. Government is subject to
restrictions set forth in a license
I. 04/04 10:54:05. agreement between the Government and
iAnywhere Solutions, Inc. or
I. 04/04 10:54:05. other written agreement specifying the
Government's rights to use the
I. 04/04 10:54:05. software and any applicable FAR
provisions, for example, FAR 52.227-19.
I. 04/04 10:54:05.
I. 04/04 10:54:05. Sybase, Inc., One Sybase Drive, Dublin,
CA 94568, USA
I. 04/04 10:54:05.
I. 04/04 10:54:05. Scanning logs starting at offset
0655048165
I. 04/04 10:54:05. Processing transaction logs from
directory "C:\TRS\"
I. 04/04 10:54:05. Processing transactions from active
transaction log
I. 04/04 10:54:05. Sending message to "rem1"
(0-0000000000-0655053725-0)
I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.0" failure 123:
Invalid argument
I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.1" failure 123:
Invalid argument
I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.2" failure 123:
Invalid argument
I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.3" failure 123:
Invalid argument
I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.4" failure 123:
Invalid argument
I. 04/04 10:54:05. Resend requests are being queued
I. 04/04 10:54:06. Execution completed
One generated at remote database:
I. 04/04 10:55:09. SQL Remote Message Agent Version
8.0.2.4299
I. 04/04 10:55:09.
I. 04/04 10:55:09. Copyright © 1989-2002 Sybase, Inc.
Portions Copyright © 2002, iAnywhere
Solutions, Inc.
I. 04/04 10:55:09. All rights reserved. All unpublished
rights reserved.
I. 04/04 10:55:09.
I. 04/04 10:55:09. This software contains confidential and
trade secret information of
I. 04/04 10:55:09. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the
software and documentation
I. 04/04 10:55:09. by the U.S. Government is subject to
restrictions set forth in a license
I. 04/04 10:55:09. agreement between the Government and
iAnywhere Solutions, Inc. or
I. 04/04 10:55:09. other written agreement specifying the
Government's rights to use the
I. 04/04 10:55:09. software and any applicable FAR
provisions, for example, FAR 52.227-19.
I. 04/04 10:55:09.
I. 04/04 10:55:09. Sybase, Inc., One Sybase Drive, Dublin,
CA 94568, USA
I. 04/04 10:55:09.
I. 04/04 10:55:35. Scanning logs starting at offset
0655046355
I. 04/04 10:55:35. Processing transaction logs from
directory "D:\TRS\"
I. 04/04 10:55:35. Processing transactions from active
transaction log
I. 04/04 10:55:35. Sending message to "cons"
(0-0000000000-0655051301-0)
I. 04/04 10:55:35. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.0"
failure 53: No such file or directory
I. 04/04 10:55:35. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.1"
failure 53: No such file or directory
I. 04/04 10:55:35. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.2"
failure 53: No such file or directory
I. 04/04 10:55:35. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.3"
failure 53: No such file or directory
I. 04/04 10:55:35. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.4"
failure 53: No such file or directory
I. 04/04 10:55:35. Resend requests are being queued
I. 04/04 10:55:35. Execution completed
[color=darkred]
> SQL Remote log that was generated what is this?
>
> The one I send earlier is the one I am using dbremote on
> command window, and it is generated and another you are
> saying from database enginge.
>
> How will I get that?
>
> regards,
>
> "Time Frame" to ALL >
db[color=darkred]
([color=darkred]
> http://www.ianywhere.com/developer/product_manuals ASA
| |
|
| Yes that was the problem, now it is running on consolidated
but giving problem on remote database.
AT Remote Database--
SET REMOTE file OPTION "PUBLIC"."directory" =3d
'\\\\HAYXPPRIYANKA\\
msgs'
Where "HAYXPPRIYANKA" is Machine name of Consolidate
database.
Is there error in it.
Here I am sending SQL Remote Log for Both
Remote database
I. 04/04 16:53:20. SQL Remote Message Agent Version
8.0.2.4299
I. 04/04 16:53:20.
I. 04/04 16:53:20. Copyright =a9 1989-2002 Sybase, Inc.
Portions Copyright =a9 2002, iAnywhere
Solutions, Inc.
I. 04/04 16:53:20. All rights reserved. All unpublished
rights reserved.
I. 04/04 16:53:20.
I. 04/04 16:53:20. This software contains confidential and
trade secret information of
I. 04/04 16:53:20. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the
software and documentation
I. 04/04 16:53:20. by the U.S. Government is subject to
restrictions set forth in a license
I. 04/04 16:53:20. agreement between the Government and
iAnywhere Solutions, Inc. or
I. 04/04 16:53:20. other written agreement specifying the
Government's rights to use the
I. 04/04 16:53:20. software and any applicable FAR
provisions, for example, FAR 52.227-19.
I. 04/04 16:53:20.
I. 04/04 16:53:20. Sybase, Inc., One Sybase Drive, Dublin,
CA 94568, USA
I. 04/04 16:53:20.
I. 04/04 16:53:42. Scanning logs starting at offset
0655046355
I. 04/04 16:53:42. Processing transaction logs from
directory "D:\TRS\"
I. 04/04 16:53:42. Processing transactions from active
transaction log
I. 04/04 16:53:42. Sending message to "cons"
(0-0000000000-0655051463-0)
I. 04/04 16:53:42. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.0"
failure 53: No such file or directory
I. 04/04 16:53:42. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.1"
failure 53: No such file or directory
I. 04/04 16:53:42. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.2"
failure 53: No such file or directory
I. 04/04 16:53:42. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.3"
failure 1231: Invalid argument
I. 04/04 16:53:42. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.4"
failure 53: No such file or directory
I. 04/04 16:53:42. Resend requests are being queued
I. 04/04 16:53:43. Execution completed
for Consolidated Database---
I. 04/04 16:53:00. SQL Remote Message Agent Version
8.0.2.3601
I. 04/04 16:53:00.
I. 04/04 16:53:00. Copyright =a9 1989-2002 Sybase, Inc.
Portions Copyright =a9 2002, iAnywhere
Solutions, Inc.
I. 04/04 16:53:00. All rights reserved. All unpublished
rights reserved.
I. 04/04 16:53:00.
I. 04/04 16:53:00. This software contains confidential and
trade secret information of
I. 04/04 16:53:00. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the
software and documentation
I. 04/04 16:53:00. by the U.S. Government is subject to
restrictions set forth in a license
I. 04/04 16:53:00. agreement between the Government and
iAnywhere Solutions, Inc. or
I. 04/04 16:53:00. other written agreement specifying the
Government's rights to use the
I. 04/04 16:53:00. software and any applicable FAR
provisions, for example, FAR 52.227-19.
I. 04/04 16:53:00.
I. 04/04 16:53:00. Sybase, Inc., One Sybase Drive, Dublin,
CA 94568, USA
I. 04/04 16:53:00.
I. 04/04 16:53:00. Scanning logs starting at offset
0655054152
I. 04/04 16:53:00. Processing transaction logs from
directory "C:\TRS\"
I. 04/04 16:53:00. Processing transactions from active
transaction log
I. 04/04 16:53:00. Sending message to "rem1"
(0-0655054152-0655054152-0)
I. 04/04 16:53:01. Execution completed
Regards,
> It appears that you have an extra backslash in your path
>
>
> I suspect that you mis-typed the SET REMOTE option command
> on the consolidated, which should have looked similar to :
>
> SET REMOTE file OPTION "PUBLIC"."directory" =3d
'c:\\msgs';
>
> Yes, the msgs directory exists on the machine where the
> consolidated database runs.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer
> Version 8 Please reply only to the newsgroup
>
> iAnywhere Developer Community :
> http://www.ianywhere.com/developer iAnywhere Documentation
> : http://www.ianywhere.com/developer/product_manuals ASA
> Patches and EBFs :
> http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> <sumy> wrote in message
> news:4251044f.48bc.1681692777@sybase.com... The one
> genertated On Consolidated database:
>
> I. 04/04 10:54:05. SQL Remote Message Agent Version
> 8.0.2.3601
> I. 04/04 10:54:05.
> I. 04/04 10:54:05. Copyright =a9 1989-2002 Sybase, Inc.
> Portions Copyright =a9 2002, iAnywhere
> Solutions, Inc.
> I. 04/04 10:54:05. All rights reserved. All unpublished
> rights reserved.
> I. 04/04 10:54:05.
> I. 04/04 10:54:05. This software contains confidential and
> trade secret information of
> I. 04/04 10:54:05. iAnywhere Solutions, Inc.
> Use, duplication or disclosure of the
> software and documentation
> I. 04/04 10:54:05. by the U.S. Government is subject to
> restrictions set forth in a license
> I. 04/04 10:54:05. agreement between the Government and
> iAnywhere Solutions, Inc. or
> I. 04/04 10:54:05. other written agreement specifying the
> Government's rights to use the
> I. 04/04 10:54:05. software and any applicable FAR
> provisions, for example, FAR 52.227-19.
> I. 04/04 10:54:05.
> I. 04/04 10:54:05. Sybase, Inc., One Sybase Drive, Dublin,
> CA 94568, USA
> I. 04/04 10:54:05.
> I. 04/04 10:54:05. Scanning logs starting at offset
> 0655048165
> I. 04/04 10:54:05. Processing transaction logs from
> directory "C:\TRS\"
> I. 04/04 10:54:05. Processing transactions from active
> transaction log
> I. 04/04 10:54:05. Sending message to "rem1"
> (0-0000000000-0655053725-0)
> I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.0" failure
> 123: Invalid argument
> I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.1" failure
> 123: Invalid argument
> I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.2" failure
> 123: Invalid argument
> I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.3" failure
> 123: Invalid argument
> I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.4" failure
> 123: Invalid argument
> I. 04/04 10:54:05. Resend requests are being queued
> I. 04/04 10:54:06. Execution completed
>
> One generated at remote database:
>
> I. 04/04 10:55:09. SQL Remote Message Agent Version
> 8.0.2.4299
> I. 04/04 10:55:09.
> I. 04/04 10:55:09. Copyright =a9 1989-2002 Sybase, Inc.
> Portions Copyright =a9 2002, iAnywhere
> Solutions, Inc.
> I. 04/04 10:55:09. All rights reserved. All unpublished
> rights reserved.
> I. 04/04 10:55:09.
> I. 04/04 10:55:09. This software contains confidential and
> trade secret information of
> I. 04/04 10:55:09. iAnywhere Solutions, Inc.
> Use, duplication or disclosure of the
> software and documentation
> I. 04/04 10:55:09. by the U.S. Government is subject to
> restrictions set forth in a license
> I. 04/04 10:55:09. agreement between the Government and
> iAnywhere Solutions, Inc. or
> I. 04/04 10:55:09. other written agreement specifying the
> Government's rights to use the
> I. 04/04 10:55:09. software and any applicable FAR
> provisions, for example, FAR 52.227-19.
> I. 04/04 10:55:09.
> I. 04/04 10:55:09. Sybase, Inc., One Sybase Drive, Dublin,
> CA 94568, USA
> I. 04/04 10:55:09.
> I. 04/04 10:55:35. Scanning logs starting at offset
> 0655046355
> I. 04/04 10:55:35. Processing transaction logs from
> directory "D:\TRS\"
> I. 04/04 10:55:35. Processing transactions from active
> transaction log
> I. 04/04 10:55:35. Sending message to "cons"
> (0-0000000000-0655051301-0)
> I. 04/04 10:55:35. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.0" failure 53: No such
> file or directory I. 04/04 10:55:35. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.1" failure 53: No such
> file or directory I. 04/04 10:55:35. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.2" failure 53: No such
> file or directory I. 04/04 10:55:35. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.3" failure 53: No such
> file or directory I. 04/04 10:55:35. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.4" failure 53: No such
> file or directory I. 04/04 10:55:35. Resend requests are
> being queued I. 04/04 10:55:35. Execution completed
>
>
>
>
>
>
>
where[color=darkred]
> db
> http://www.ianywhere.com/developer/product_manuals ASA
0;[color=darkred]
t1[color=darkred]
> (
>
>
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-04-04, 8:03 pm |
| From a DOS prompt on the remote machine, what happens when you type the
following :
net use * \\HAYXPPRIYANKA\msgs
Do you get a response similar to "System error 67 has occurred. The network
name cannot be found." or was the response similar to "Drive G: is now
connected to \\HAYXPPRIYANKA\msgs
. The command completed successfully."
If the response was system error 67, you have not set up your share properly
on the consolidated machine. The first hit on Google I found to help you
set up network shares was :
http://web.balliol.ox.ac.uk/comp/shares/index.asp.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
<sumy> wrote in message news:425156b1.40c8.1681692777@sybase.com...
Yes that was the problem, now it is running on consolidated
but giving problem on remote database.
AT Remote Database--
SET REMOTE file OPTION "PUBLIC"."directory" =
'\\\\HAYXPPRIYANKA\\
msgs'
Where "HAYXPPRIYANKA" is Machine name of Consolidate
database.
Is there error in it.
Here I am sending SQL Remote Log for Both
Remote database
I. 04/04 16:53:20. SQL Remote Message Agent Version
8.0.2.4299
I. 04/04 16:53:20.
I. 04/04 16:53:20. Copyright © 1989-2002 Sybase, Inc.
Portions Copyright © 2002, iAnywhere
Solutions, Inc.
I. 04/04 16:53:20. All rights reserved. All unpublished
rights reserved.
I. 04/04 16:53:20.
I. 04/04 16:53:20. This software contains confidential and
trade secret information of
I. 04/04 16:53:20. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the
software and documentation
I. 04/04 16:53:20. by the U.S. Government is subject to
restrictions set forth in a license
I. 04/04 16:53:20. agreement between the Government and
iAnywhere Solutions, Inc. or
I. 04/04 16:53:20. other written agreement specifying the
Government's rights to use the
I. 04/04 16:53:20. software and any applicable FAR
provisions, for example, FAR 52.227-19.
I. 04/04 16:53:20.
I. 04/04 16:53:20. Sybase, Inc., One Sybase Drive, Dublin,
CA 94568, USA
I. 04/04 16:53:20.
I. 04/04 16:53:42. Scanning logs starting at offset
0655046355
I. 04/04 16:53:42. Processing transaction logs from
directory "D:\TRS\"
I. 04/04 16:53:42. Processing transactions from active
transaction log
I. 04/04 16:53:42. Sending message to "cons"
(0-0000000000-0655051463-0)
I. 04/04 16:53:42. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.0"
failure 53: No such file or directory
I. 04/04 16:53:42. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.1"
failure 53: No such file or directory
I. 04/04 16:53:42. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.2"
failure 53: No such file or directory
I. 04/04 16:53:42. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.3"
failure 1231: Invalid argument
I. 04/04 16:53:42. sopen " \\HAYXPPRIYANKA\msgs
\cons\rem1.4"
failure 53: No such file or directory
I. 04/04 16:53:42. Resend requests are being queued
I. 04/04 16:53:43. Execution completed
for Consolidated Database---
I. 04/04 16:53:00. SQL Remote Message Agent Version
8.0.2.3601
I. 04/04 16:53:00.
I. 04/04 16:53:00. Copyright © 1989-2002 Sybase, Inc.
Portions Copyright © 2002, iAnywhere
Solutions, Inc.
I. 04/04 16:53:00. All rights reserved. All unpublished
rights reserved.
I. 04/04 16:53:00.
I. 04/04 16:53:00. This software contains confidential and
trade secret information of
I. 04/04 16:53:00. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the
software and documentation
I. 04/04 16:53:00. by the U.S. Government is subject to
restrictions set forth in a license
I. 04/04 16:53:00. agreement between the Government and
iAnywhere Solutions, Inc. or
I. 04/04 16:53:00. other written agreement specifying the
Government's rights to use the
I. 04/04 16:53:00. software and any applicable FAR
provisions, for example, FAR 52.227-19.
I. 04/04 16:53:00.
I. 04/04 16:53:00. Sybase, Inc., One Sybase Drive, Dublin,
CA 94568, USA
I. 04/04 16:53:00.
I. 04/04 16:53:00. Scanning logs starting at offset
0655054152
I. 04/04 16:53:00. Processing transaction logs from
directory "C:\TRS\"
I. 04/04 16:53:00. Processing transactions from active
transaction log
I. 04/04 16:53:00. Sending message to "rem1"
(0-0655054152-0655054152-0)
I. 04/04 16:53:01. Execution completed
Regards,
> It appears that you have an extra backslash in your path
>
>
> I suspect that you mis-typed the SET REMOTE option command
> on the consolidated, which should have looked similar to :
>
> SET REMOTE file OPTION "PUBLIC"."directory" =
'c:\\msgs';
>
> Yes, the msgs directory exists on the machine where the
> consolidated database runs.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer
> Version 8 Please reply only to the newsgroup
>
> iAnywhere Developer Community :
> http://www.ianywhere.com/developer iAnywhere Documentation
> : http://www.ianywhere.com/developer/product_manuals ASA
> Patches and EBFs :
> http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> <sumy> wrote in message
> news:4251044f.48bc.1681692777@sybase.com... The one
> genertated On Consolidated database:
>
> I. 04/04 10:54:05. SQL Remote Message Agent Version
> 8.0.2.3601
> I. 04/04 10:54:05.
> I. 04/04 10:54:05. Copyright © 1989-2002 Sybase, Inc.
> Portions Copyright © 2002, iAnywhere
> Solutions, Inc.
> I. 04/04 10:54:05. All rights reserved. All unpublished
> rights reserved.
> I. 04/04 10:54:05.
> I. 04/04 10:54:05. This software contains confidential and
> trade secret information of
> I. 04/04 10:54:05. iAnywhere Solutions, Inc.
> Use, duplication or disclosure of the
> software and documentation
> I. 04/04 10:54:05. by the U.S. Government is subject to
> restrictions set forth in a license
> I. 04/04 10:54:05. agreement between the Government and
> iAnywhere Solutions, Inc. or
> I. 04/04 10:54:05. other written agreement specifying the
> Government's rights to use the
> I. 04/04 10:54:05. software and any applicable FAR
> provisions, for example, FAR 52.227-19.
> I. 04/04 10:54:05.
> I. 04/04 10:54:05. Sybase, Inc., One Sybase Drive, Dublin,
> CA 94568, USA
> I. 04/04 10:54:05.
> I. 04/04 10:54:05. Scanning logs starting at offset
> 0655048165
> I. 04/04 10:54:05. Processing transaction logs from
> directory "C:\TRS\"
> I. 04/04 10:54:05. Processing transactions from active
> transaction log
> I. 04/04 10:54:05. Sending message to "rem1"
> (0-0000000000-0655053725-0)
> I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.0" failure
> 123: Invalid argument
> I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.1" failure
> 123: Invalid argument
> I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.2" failure
> 123: Invalid argument
> I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.3" failure
> 123: Invalid argument
> I. 04/04 10:54:05. sopen "\c:\msgs\rem1\cons.4" failure
> 123: Invalid argument
> I. 04/04 10:54:05. Resend requests are being queued
> I. 04/04 10:54:06. Execution completed
>
> One generated at remote database:
>
> I. 04/04 10:55:09. SQL Remote Message Agent Version
> 8.0.2.4299
> I. 04/04 10:55:09.
> I. 04/04 10:55:09. Copyright © 1989-2002 Sybase, Inc.
> Portions Copyright © 2002, iAnywhere
> Solutions, Inc.
> I. 04/04 10:55:09. All rights reserved. All unpublished
> rights reserved.
> I. 04/04 10:55:09.
> I. 04/04 10:55:09. This software contains confidential and
> trade secret information of
> I. 04/04 10:55:09. iAnywhere Solutions, Inc.
> Use, duplication or disclosure of the
> software and documentation
> I. 04/04 10:55:09. by the U.S. Government is subject to
> restrictions set forth in a license
> I. 04/04 10:55:09. agreement between the Government and
> iAnywhere Solutions, Inc. or
> I. 04/04 10:55:09. other written agreement specifying the
> Government's rights to use the
> I. 04/04 10:55:09. software and any applicable FAR
> provisions, for example, FAR 52.227-19.
> I. 04/04 10:55:09.
> I. 04/04 10:55:09. Sybase, Inc., One Sybase Drive, Dublin,
> CA 94568, USA
> I. 04/04 10:55:09.
> I. 04/04 10:55:35. Scanning logs starting at offset
> 0655046355
> I. 04/04 10:55:35. Processing transaction logs from
> directory "D:\TRS\"
> I. 04/04 10:55:35. Processing transactions from active
> transaction log
> I. 04/04 10:55:35. Sending message to "cons"
> (0-0000000000-0655051301-0)
> I. 04/04 10:55:35. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.0" failure 53: No such
> file or directory I. 04/04 10:55:35. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.1" failure 53: No such
> file or directory I. 04/04 10:55:35. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.2" failure 53: No such
> file or directory I. 04/04 10:55:35. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.3" failure 53: No such
> file or directory I. 04/04 10:55:35. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.4" failure 53: No such
> file or directory I. 04/04 10:55:35. Resend requests are
> being queued I. 04/04 10:55:35. Execution completed
>
>
>
>
>
>
>
where[color=darkred]
> db
> http://www.ianywhere.com/developer/product_manuals ASA
0;[color=darkred]
t1[color=darkred]
> (
>
>
| |
|
| I don't write \\HAYXPPRIYANKA\msgs
on MS DOS, this one I
write in ISQL in 'SQL REMOTE'.
In Dos Window when I use the command
(dbremote -c " uid=3ddba;pwd=3dsql;
dbf=3dc:/TRV/trv.db")
Then on remote machine it give error invalid arguments,
and this error which I send you earlier the SQL Remote For
Remote Machine, and for Consolidated machine I have also
send SQL REmote LOG.
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.0" failure 53: No such
> file or directory I. 04/04 16:53:42. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.1" failure 53: No such
> file or directory I. 04/04 16:53:42. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.2" failure 53: No such
> file or directory I. 04/04 16:53:42. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.3" failure 1231: Invalid
> argument I. 04/04 16:53:42. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.4" failure 53: No such
> file or directory I. 04/04 16:53:42. Resend requests are
> being queued I. 04/04 16:53:43. Execution completed
regards,
> From a DOS prompt on the remote machine, what happens when
> you type the following :
>
> net use * \\HAYXPPRIYANKA\msgs
>
> Do you get a response similar to "System error 67 has
> occurred. The network name cannot be found." or was the
> response similar to "Drive G: is now connected to
> \\HAYXPPRIYANKA\msgs
. The command completed successfully."
>
> If the response was system error 67, you have not set up
> your share properly on the consolidated machine. The
> first hit on Google I found to help you set up network
> shares was :
> http://web.balliol.ox.ac.uk/comp/shares/index.asp.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer
> Version 8 Please reply only to the newsgroup
>
> iAnywhere Developer Community :
> http://www.ianywhere.com/developer iAnywhere Documentation
> : http://www.ianywhere.com/developer/product_manuals ASA
> Patches and EBFs :
> http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> <sumy> wrote in message
> news:425156b1.40c8.1681692777@sybase.com... Yes that was
> the problem, now it is running on consolidated but giving
> problem on remote database.
>
> AT Remote Database--
>
> SET REMOTE file OPTION "PUBLIC"."directory" =3d
> '\\\\HAYXPPRIYANKA\\
msgs'
>
> Where "HAYXPPRIYANKA" is Machine name of Consolidate
> database.
>
> Is there error in it.
>
> Here I am sending SQL Remote Log for Both
>
> Remote database
>
>
> I. 04/04 16:53:20. SQL Remote Message Agent Version
> 8.0.2.4299
> I. 04/04 16:53:20.
> I. 04/04 16:53:20. Copyright =a9 1989-2002 Sybase, Inc.
> Portions Copyright =a9 2002, iAnywhere
> Solutions, Inc.
> I. 04/04 16:53:20. All rights reserved. All unpublished
> rights reserved.
> I. 04/04 16:53:20.
> I. 04/04 16:53:20. This software contains confidential and
> trade secret information of
> I. 04/04 16:53:20. iAnywhere Solutions, Inc.
> Use, duplication or disclosure of the
> software and documentation
> I. 04/04 16:53:20. by the U.S. Government is subject to
> restrictions set forth in a license
> I. 04/04 16:53:20. agreement between the Government and
> iAnywhere Solutions, Inc. or
> I. 04/04 16:53:20. other written agreement specifying the
> Government's rights to use the
> I. 04/04 16:53:20. software and any applicable FAR
> provisions, for example, FAR 52.227-19.
> I. 04/04 16:53:20.
> I. 04/04 16:53:20. Sybase, Inc., One Sybase Drive, Dublin,
> CA 94568, USA
> I. 04/04 16:53:20.
> I. 04/04 16:53:42. Scanning logs starting at offset
> 0655046355
> I. 04/04 16:53:42. Processing transaction logs from
> directory "D:\TRS\"
> I. 04/04 16:53:42. Processing transactions from active
> transaction log
> I. 04/04 16:53:42. Sending message to "cons"
> (0-0000000000-0655051463-0)
> I. 04/04 16:53:42. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.0" failure 53: No such
> file or directory I. 04/04 16:53:42. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.1" failure 53: No such
> file or directory I. 04/04 16:53:42. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.2" failure 53: No such
> file or directory I. 04/04 16:53:42. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.3" failure 1231: Invalid
> argument I. 04/04 16:53:42. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.4" failure 53: No such
> file or directory I. 04/04 16:53:42. Resend requests are
> being queued I. 04/04 16:53:43. Execution completed
>
> for Consolidated Database---
>
> I. 04/04 16:53:00. SQL Remote Message Agent Version
> 8.0.2.3601
> I. 04/04 16:53:00.
> I. 04/04 16:53:00. Copyright =a9 1989-2002 Sybase, Inc.
> Portions Copyright =a9 2002, iAnywhere
> Solutions, Inc.
> I. 04/04 16:53:00. All rights reserved. All unpublished
> rights reserved.
> I. 04/04 16:53:00.
> I. 04/04 16:53:00. This software contains confidential and
> trade secret information of
> I. 04/04 16:53:00. iAnywhere Solutions, Inc.
> Use, duplication or disclosure of the
> software and documentation
> I. 04/04 16:53:00. by the U.S. Government is subject to
> restrictions set forth in a license
> I. 04/04 16:53:00. agreement between the Government and
> iAnywhere Solutions, Inc. or
> I. 04/04 16:53:00. other written agreement specifying the
> Government's rights to use the
> I. 04/04 16:53:00. software and any applicable FAR
> provisions, for example, FAR 52.227-19.
> I. 04/04 16:53:00.
> I. 04/04 16:53:00. Sybase, Inc., One Sybase Drive, Dublin,
> CA 94568, USA
> I. 04/04 16:53:00.
> I. 04/04 16:53:00. Scanning logs starting at offset
> 0655054152
> I. 04/04 16:53:00. Processing transaction logs from
> directory "C:\TRS\"
> I. 04/04 16:53:00. Processing transactions from active
> transaction log
> I. 04/04 16:53:00. Sending message to "rem1"
> (0-0655054152-0655054152-0)
> I. 04/04 16:53:01. Execution completed
>
> Regards,
>
> similar to : >
> 'c:\\msgs';
> "Time Frame" to ALL >
iAnywhere[color=dark
red]
iAnywhere[color=dark
red]
> http://www.ianywhere.com/developer/product_manuals ASA
> where
=3d[color=darkred]
> 0;
0;[color=darkred]
'\\\\cons- pc\\msgs';[color=dar
kred]
> CREATE TABLE t1
>
>
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-04-04, 8:03 pm |
| I'm trying to figure out whether the machine where you run dbremote against
the remote has the ability to access the network share called "msgs" on the
"HAYXPPRIYANKA" machine. If you execute the command I asked you to execute
in my last post, the result of that command will tell me whether the share
is setup correctly. Please execute the command I asked you to execute and
post the result.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
<sumy> wrote in message news:4251976d.4740.1681692777@sybase.com...
I don't write \\HAYXPPRIYANKA\msgs
on MS DOS, this one I
write in ISQL in 'SQL REMOTE'.
In Dos Window when I use the command
(dbremote -c " uid=dba;pwd=sql;dbf=
c:/TRV/trv.db")
Then on remote machine it give error invalid arguments,
and this error which I send you earlier the SQL Remote For
Remote Machine, and for Consolidated machine I have also
send SQL REmote LOG.
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.0" failure 53: No such
> file or directory I. 04/04 16:53:42. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.1" failure 53: No such
> file or directory I. 04/04 16:53:42. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.2" failure 53: No such
> file or directory I. 04/04 16:53:42. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.3" failure 1231: Invalid
> argument I. 04/04 16:53:42. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.4" failure 53: No such
> file or directory I. 04/04 16:53:42. Resend requests are
> being queued I. 04/04 16:53:43. Execution completed
regards,
> From a DOS prompt on the remote machine, what happens when
> you type the following :
>
> net use * \\HAYXPPRIYANKA\msgs
>
> Do you get a response similar to "System error 67 has
> occurred. The network name cannot be found." or was the
> response similar to "Drive G: is now connected to
> \\HAYXPPRIYANKA\msgs
. The command completed successfully."
>
> If the response was system error 67, you have not set up
> your share properly on the consolidated machine. The
> first hit on Google I found to help you set up network
> shares was :
> http://web.balliol.ox.ac.uk/comp/shares/index.asp.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer
> Version 8 Please reply only to the newsgroup
>
> iAnywhere Developer Community :
> http://www.ianywhere.com/developer iAnywhere Documentation
> : http://www.ianywhere.com/developer/product_manuals ASA
> Patches and EBFs :
> http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> <sumy> wrote in message
> news:425156b1.40c8.1681692777@sybase.com... Yes that was
> the problem, now it is running on consolidated but giving
> problem on remote database.
>
> AT Remote Database--
>
> SET REMOTE file OPTION "PUBLIC"."directory" =
> '\\\\HAYXPPRIYANKA\\
msgs'
>
> Where "HAYXPPRIYANKA" is Machine name of Consolidate
> database.
>
> Is there error in it.
>
> Here I am sending SQL Remote Log for Both
>
> Remote database
>
>
> I. 04/04 16:53:20. SQL Remote Message Agent Version
> 8.0.2.4299
> I. 04/04 16:53:20.
> I. 04/04 16:53:20. Copyright © 1989-2002 Sybase, Inc.
> Portions Copyright © 2002, iAnywhere
> Solutions, Inc.
> I. 04/04 16:53:20. All rights reserved. All unpublished
> rights reserved.
> I. 04/04 16:53:20.
> I. 04/04 16:53:20. This software contains confidential and
> trade secret information of
> I. 04/04 16:53:20. iAnywhere Solutions, Inc.
> Use, duplication or disclosure of the
> software and documentation
> I. 04/04 16:53:20. by the U.S. Government is subject to
> restrictions set forth in a license
> I. 04/04 16:53:20. agreement between the Government and
> iAnywhere Solutions, Inc. or
> I. 04/04 16:53:20. other written agreement specifying the
> Government's rights to use the
> I. 04/04 16:53:20. software and any applicable FAR
> provisions, for example, FAR 52.227-19.
> I. 04/04 16:53:20.
> I. 04/04 16:53:20. Sybase, Inc., One Sybase Drive, Dublin,
> CA 94568, USA
> I. 04/04 16:53:20.
> I. 04/04 16:53:42. Scanning logs starting at offset
> 0655046355
> I. 04/04 16:53:42. Processing transaction logs from
> directory "D:\TRS\"
> I. 04/04 16:53:42. Processing transactions from active
> transaction log
> I. 04/04 16:53:42. Sending message to "cons"
> (0-0000000000-0655051463-0)
> I. 04/04 16:53:42. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.0" failure 53: No such
> file or directory I. 04/04 16:53:42. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.1" failure 53: No such
> file or directory I. 04/04 16:53:42. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.2" failure 53: No such
> file or directory I. 04/04 16:53:42. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.3" failure 1231: Invalid
> argument I. 04/04 16:53:42. sopen
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.4" failure 53: No such
> file or directory I. 04/04 16:53:42. Resend requests are
> being queued I. 04/04 16:53:43. Execution completed
>
> for Consolidated Database---
>
> I. 04/04 16:53:00. SQL Remote Message Agent Version
> 8.0.2.3601
> I. 04/04 16:53:00.
> I. 04/04 16:53:00. Copyright © 1989-2002 Sybase, Inc.
> Portions Copyright © 2002, iAnywhere
> Solutions, Inc.
> I. 04/04 16:53:00. All rights reserved. All unpublished
> rights reserved.
> I. 04/04 16:53:00.
> I. 04/04 16:53:00. This software contains confidential and
> trade secret information of
> I. 04/04 16:53:00. iAnywhere Solutions, Inc.
> Use, duplication or disclosure of the
> software and documentation
> I. 04/04 16:53:00. by the U.S. Government is subject to
> restrictions set forth in a license
> I. 04/04 16:53:00. agreement between the Government and
> iAnywhere Solutions, Inc. or
> I. 04/04 16:53:00. other written agreement specifying the
> Government's rights to use the
> I. 04/04 16:53:00. software and any applicable FAR
> provisions, for example, FAR 52.227-19.
> I. 04/04 16:53:00.
> I. 04/04 16:53:00. Sybase, Inc., One Sybase Drive, Dublin,
> CA 94568, USA
> I. 04/04 16:53:00.
> I. 04/04 16:53:00. Scanning logs starting at offset
> 0655054152
> I. 04/04 16:53:00. Processing transaction logs from
> directory "C:\TRS\"
> I. 04/04 16:53:00. Processing transactions from active
> transaction log
> I. 04/04 16:53:00. Sending message to "rem1"
> (0-0655054152-0655054152-0)
> I. 04/04 16:53:01. Execution completed
>
> Regards,
>
> similar to : >
> 'c:\\msgs';
> "Time Frame" to ALL >
iAnywhere[color=dark
red]
iAnywhere[color=dark
red]
> http://www.ianywhere.com/developer/product_manuals ASA
> where
=[color=darkred]
> 0;
0;[color=darkred]
'\\\\cons- pc\\msgs';[color=dar
kred]
> CREATE TABLE t1
>
>
| |
|
| Hi
From a DOS prompt on the remote machine, when
I type the following on remote machine
> net use * \\HAYXPPRIYANKA\msgs
I get response similar to "Drive G: is now connected to
\\HAYXPPRIYANKA\msgs
. The command completed
Successfully."
"""IF THESE TWO COMPUTERS ARE IN THE LAN THEN I GET THIS
RESPONSE"""
Data is synchronizing, two way replication is working.
After it has been mapped on remote machine the Shared folder
'msgs'.
But if they are not in network then is it possible to
communicate (Synchronize) them like this.
I have one more question in FILE Message Type it is not
possible to choose time, like
send at or Every; every time to receive or send data for
replication we have to use"dbremote".
And can we published whole database, is it ok performance
wise?
Regards,
Sumit
> I'm trying to figure out whether the machine where you run
> dbremote against the remote has the ability to access the
> network share called "msgs" on the "HAYXPPRIYANKA"
> machine. If you execute the command I asked you to
> execute in my last post, the result of that command will
> tell me whether the share is setup correctly. Please
> execute the command I asked you to execute and post the
> result.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer
> Version 8 Please reply only to the newsgroup
>
> iAnywhere Developer Community :
> http://www.ianywhere.com/developer iAnywhere Documentation
> : http://www.ianywhere.com/developer/product_manuals ASA
> Patches and EBFs :
> http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL
>
> <sumy> wrote in message
> news:4251976d.4740.1681692777@sybase.com... I don't write
> \\HAYXPPRIYANKA\msgs
on MS DOS, this one I write in ISQL
> in 'SQL REMOTE'.
>
> In Dos Window when I use the command
>
> (dbremote -c " uid=3ddba;pwd=3dsql;
dbf=3dc:/TRV/trv.db")
>
> Then on remote machine it give error invalid arguments,
> and this error which I send you earlier the SQL Remote For
> Remote Machine, and for Consolidated machine I have also
> send SQL REmote LOG.
>
>
> regards,
> successfully." >
> "Time Frame" to ALL >
iAnywhere[color=dark
red]
iAnywhere[color=dark
red]
Inc.[color=darkred]
> iAnywhere
Inc.[color=darkred]
> iAnywhere
> " \\HAYXPPRIYANKA\msgs
\cons\rem1.4" failure 53: No such
> news:424c4a84.6e3e.1681692777@sybase.com... Thank you very
> =3d
> OPTION "PUBLIC".GLOBAL_DATABASE_ID =3d 0;
> '\\\\cons-pc\\msgs';
1;[color=darkred]
> news:424be95c.3a0.1681692777@sybase.com... I have to
> where should I put Message Directory, and how to provide
>
>
|
|
|
|
|