Rep server with ase 12.5

With ASE 11.9.2 under Linux repserver was working fine.
I'm trying to install it on 12.5 ASE.
When rs_init install it on a RSSD database on a RSSD server (12.5)
I have the following error :

2001/11/18 08:36:42 SQL Server message: msg 156, level 15, state 1
2001/11/18 08:36:42 INTERNAL ERROR: "Incorrect syntax near the keyword
                    'function'.
                    "
2001/11/18 08:36:42 Check the log
(/home/replic/REP-12_0/init/logs/log1118.021)
                    for more information.  Please make a note of this
error and
                    contact your Sybase representative.
2001/11/18 08:36:42 Unable to load the Replication Server System
Database in
                    'RSSD_SRV'.
2001/11/18 08:36:42 Task failed: configure the Replication Server System
                    Database. Terminating configuration.
2001/11/18 08:36:42 Configuration failed.
2001/11/18 08:36:42 Exiting.

I'm using rs_init with a dump file wich worked under 11.9.2 ASE.
Its content is the following :

sybinit.charset: iso_1
sybinit.language: us_english
sybinit.component_directory: /home/replic/REP-12_0
sybinit.release_directory: /home/replic
sybinit.boot_directory: /home/replic
sybinit.product: rs
sqlsrv.sa_password: USE_DEFAULT
sqlsrv.sa_login: USE_DEFAULT
sqlsrv.master_device_size: USE_DEFAULT
sqlsrv.master_device_physical_name: USE_DEFAULT
sqlsrv.server_name: USE_DEFAULT
sqlsrv.new_config: USE_DEFAULT
rs.rs_operation: rs_install
rs.rs_diskp_size: 100
rs.rs_diskp_lname: partition1
rs.rs_diskp_name: /bases/stable1/stable1.device
rs.rs_rssd_log_device_name: RSSD_LOG
rs.rs_rssd_db_device_name: RSSD_DATA
rs.rs_rssd_log_size: 40
rs.rs_rsdddb_size: 50
rs.rs_create_rssd: yes
rs.rs_rssd_sqlsrvr: RSSD_SRV
rs.rs_sortorder: nocase
rs.rs_idserver_name: R_HADES
rs.rs_id_server_is_rs_server: yes
rs.rs_rs_errorlog: /home/replic/REP-12_0/install/R_HADES.log
rs.rs_name: R_HADES
# -END_ATTRIBUTES-

I have no mean to see the code causing the error.

Any idea ?

regards
0
Debian
11/18/2001 8:52:26 AM
sybase.rep-server 2969 articles. 1 followers. Follow

1 Replies
541 Views

Similar Articles

[PageSpeed] 39

Hello Debian,
    This is fixed in 12.1. Workaround to edit rs_init scripts and put
'function' in single quotes.
    Change the Replication Server installation script
'rs_install_systables.sql' such that the string literal 'function' is
properly quoted when used as an argument to a call to the stored procedure
'sp_setreptable'.
Regards,
Peter


Debian User wrote:

> With ASE 11.9.2 under Linux repserver was working fine.
> I'm trying to install it on 12.5 ASE.
> When rs_init install it on a RSSD database on a RSSD server (12.5)
> I have the following error :
>
> 2001/11/18 08:36:42 SQL Server message: msg 156, level 15, state 1
> 2001/11/18 08:36:42 INTERNAL ERROR: "Incorrect syntax near the keyword
>                     'function'.
>                     "
> 2001/11/18 08:36:42 Check the log
> (/home/replic/REP-12_0/init/logs/log1118.021)
>                     for more information.  Please make a note of this
> error and
>                     contact your Sybase representative.
> 2001/11/18 08:36:42 Unable to load the Replication Server System
> Database in
>                     'RSSD_SRV'.
> 2001/11/18 08:36:42 Task failed: configure the Replication Server System
>                     Database. Terminating configuration.
> 2001/11/18 08:36:42 Configuration failed.
> 2001/11/18 08:36:42 Exiting.
>
> I'm using rs_init with a dump file wich worked under 11.9.2 ASE.
> Its content is the following :
>
> sybinit.charset: iso_1
> sybinit.language: us_english
> sybinit.component_directory: /home/replic/REP-12_0
> sybinit.release_directory: /home/replic
> sybinit.boot_directory: /home/replic
> sybinit.product: rs
> sqlsrv.sa_password: USE_DEFAULT
> sqlsrv.sa_login: USE_DEFAULT
> sqlsrv.master_device_size: USE_DEFAULT
> sqlsrv.master_device_physical_name: USE_DEFAULT
> sqlsrv.server_name: USE_DEFAULT
> sqlsrv.new_config: USE_DEFAULT
> rs.rs_operation: rs_install
> rs.rs_diskp_size: 100
> rs.rs_diskp_lname: partition1
> rs.rs_diskp_name: /bases/stable1/stable1.device
> rs.rs_rssd_log_device_name: RSSD_LOG
> rs.rs_rssd_db_device_name: RSSD_DATA
> rs.rs_rssd_log_size: 40
> rs.rs_rsdddb_size: 50
> rs.rs_create_rssd: yes
> rs.rs_rssd_sqlsrvr: RSSD_SRV
> rs.rs_sortorder: nocase
> rs.rs_idserver_name: R_HADES
> rs.rs_id_server_is_rs_server: yes
> rs.rs_rs_errorlog: /home/replic/REP-12_0/install/R_HADES.log
> rs.rs_name: R_HADES
> # -END_ATTRIBUTES-
>
> I have no mean to see the code causing the error.
>
> Any idea ?
>
> regards

0
Peter
11/22/2001 10:44:36 PM
Reply:

Similar Artilces:

rep server 12.1 and ase 12.5.3 rep agent not starting
Dear all, Here is the scenario.. Machine 1. -Rep server ver 12.1 -ASE 12.5.3 having ---A. RSSD db ---B. Replicate dbs Primary databases are on different machines each with ASE 12.5.3. The primary sql server names are the same but the interface file entry in Machine 1 has different names for each. eg. Machine1 ASE server name test1 Rep server name rep1 Interface file entries: [test1] master=TCP,10.1.1.160,2048 query=TCP,10.1.1.160,2048 [rep1] master=TCP,10.1.1.160,4500 query=TCP,10.1.1.160,4500 [primary1] master=TCP,10.1.1.161,2048 query=TCP,10.1.1.161,2048 ...

ASE to Rep Server to Rep Server to ASE Configuration
Hello I am hoping someone can help me. I am relatively new to Rep server and definately new to this configuration. I am trying to set up replication from ASE to Rep server to remote Rep Server to ASE. I am doing this type of configuration because the one ASE server is in North America and one is in England. This was recommended to me by Sybase becuase the transformation/language of Rep Server to Rep Server is quicker over the wan. Anyway. I have a ASE to rep server to ASE configuration and had no problem setting that up. Now I am trying to set up a new replication environme...

ASE 12.0.0.6 to ASE 12.5 and Rep Server 12.1
We are planning the upgrade of our ASE 12.0.0.6 64bit on AIX 4.3.3 to ASE 12.5 64bit on AIX 4.3.3. We are also using Rep Server 12.1 with these two servers. My question is do I need to upgrade Rep Server as well, or will 12.1 Rep Server Work with ASE 12.5. Also, we will be upgrading AIX to 5.1 as well. Any advice is appreciated. Thanks, Troy It will work, however you wont be able to use any of the 12.5 new datatypes, and the rep_agents will spit out annoying error/warning messages everytime they are restarted. Our production system has been running that way for about ye...

ASE 12.5 and Rep Server 11.5
Does anybody know if there are any problems using ASE 12.5 and Rep Server 11.5?? We are about to upgrade from ASE 11.5.1 but want to make sure that there are no problems. We plan to upgrade Rep server also but one thing at a time. thanks William Lowers First off you'll get better performance with RS 12.1 with ASE 12.5. Does Sybase even still support RS 11.5? If you are going to take advantage of any of the new ASE 12.5 features then you will have to use RS 12.1 in order to replicate things like Java Objects, etc. There are also improvements with RS Manager and new AL...

Any ASE 12.5 Rep Server 12.0 Linux users out there?
Has anyone successfully implemented ASE 12.5 and Rep Server 12.0 on Linux RH kernel 2.2.18? If so, have you had any problems? Did you use raw devices or files for your stable queue devices and what size are they? We are evaluating these products for a critical 24x7 web based order entry system. Any feedback would be welcomed. Thanks. -- Carl P. Moritz (203)925-7292 Database/EDI Administrator Iroquois Gas Transmission System Hi, We already implemented ASE 12.5 and Rep Server 12.0 on Linux, and we are using operating system files for stable queue and it is workin...

Using Rep Server 12.5 between 11.9.2 and 12.5.1
How I can replicate data between ASE 11.9.2 and ASE 12.5.1 using Replication Server 12.5 on UNIX 2.8 <JC> wrote in message news:4193beb8.2e2d.1681692777@sybase.com... > How I can replicate data between ASE 11.9.2 and ASE 12.5.1 > using Replication Server 12.5 on UNIX 2.8 This should be no problem at all -- the different versions I mean. If your questions aims at explaining how replication actually works and how to set it up (i.e. not version-specific stuff), then I recommend you read the docs at sybooks.sybase.com/rs.html. HTH, Rob ------------------------------...

Problem with ASE 12.5.3 and Rep Server RSSD
We've recently upgraded to ASE 12.5.3 and since then we've had a few occasions where dump tran processes have hung . This then stops any subsequent dumps not to work and the tran log fills up. This has only happended on the the server that holds the RSSD for our replication server running on the same box. Thanks Adam ...

ASE 15.0.2 Connect to REP Server 12.5
Hi Can ASE 15.0.2's rep agent connect to Rep Server 12.5? I am using sp_config_rep_agent to configure a database connection but I keep getting the error 'Check username and password' but I am sure that I am using the right username and password. Please post the complete error message(s) that you're getting, as well as any associated entries from the ASE and RS errorlogs. In the meantime, have you tried the following: 1 - log into machine where ASE is running 2 - source the same resource file (SYBASE.[c]sh) used to startup your ASE 3 - use isql to log into...

Is Rep Server 11.0.3 compatible with ASE 12.5
Couple of questions: Is Rep Server 11.0.3 compatible with ASE 12.5 and can I continue to use the LTM with ASE 12.5? Is ASE 12.5 backward compatible with Open client 10.0.4? Can I upgrade SQL server 11.0.3 directly to ASE 12.5? Can I upgrade Rep Server 11.0.3 directly to Rep Server 12? Any help appreciated. Thanks Hi Paul, Don't know all the Rep Server answers ... but ... > > Is Rep Server 11.0.3 compatible with ASE 12.5 and can I continue to use the > LTM with ASE 12.5? Please see http://www.sybase.com/detail/1,6904,1017401,00.html a recently published...

5.5.5 and rep server?
Does SA 5.5.5 on OS/2 work with Replication Server? Breck bcarter@risingroad.com Mobile and Distributed Enterprise Database Applications http://www.risingroad.com You may need to run the dbltm.exe on a different platform, I'm not sure that we ever had an LTM for ASA on OS/2. I have set up 5.5.x to work with Rep Server on other platforms. I can't comment on compatibility of a 5.5.x LTM with current versions of Rep Server since I haven't tried it. Rep Server 11.5 would have been current back when I was working with SQL Any 5.5.x and Rep Server. -- -----------------...

Rep Server 12.5 -> 12.6 Upgrade
Hi, I am scheduled, as part of a big upgrade, to upgrade Rep Server from 12.5 -> 12.6. From what I know I need to do this: 1) Shutdown Rep Server 12.5. 2) Point to the new Rep Server 12.6 directories/environment variables. 3) Run rs_init and choose to upgrade an existing Rep Server. Is that about it? Shahryar -- Shahryar G. Hashemi | Sr. DBA Consultant InfoSpace, Inc. 601 108th Ave NE | Suite 1200 | Bellevue, WA 98004 USA Mobile +1 206.459.6203 | Office +1 425.201.8853 | Fax +1 425.201.6150 shashem@infospace.com | www.infospaceinc.com This e-ma...

ASE 11.5 on same server as ASE 12.5?
Anyone have 11.5 running on same server as 12.5 on NT? Would not be concerned to do this in Solaris as I am on an NT 4.0 Box sp6. Any known gotchas or issues? Going to take toni's advise in earlier posting on doing the 11.5 install as a seperate user on the server already running 12.5 just fine. Hope this wilkl take care of env vars??? We have one app that the company who developed it will no longer support us on newer versions of Sybase as a result this one crucial app must stay up and running on 11.5 while we allow the rest of our company to progress forward to 12.5 an...

rep server 12.5 and cp1250
Hi! I use replication server 12.5. The server works fine with cp1250-binary settings, but if I specify cp1250-hunnocs in the config file, the server cannot be started. I need help to solve this problem Thanks very much :-) The following log messages are written: I. 2002/09/11 04:32:30. Logging messages in file 'c:\sybase\REP-12_5\install\LACI1_REP.log '. I. 2002/09/11 04:32:30. Using interfaces file 'c:\sybase\ini\sql.ini '. I. 2002/09/11 04:32:30. Server name is 'LACI1_REP'. W. 2002/09/11 04:32:35. WARNING #18065 GLOBAL RS(GLOBAL RS) - (131) SYS...

Does the secondary truncation point in the Adaptive Server need to be disabled when upgrading ASE 12.5.03 to ASE 12.5.3
Does the secondary truncation point in the Adaptive Server need to be disabled when upgrading ASE 12.5.03 to ASE 12.5.3? Thanks Hi, No. just stop replication before the upgrade and restart it after the upgrade. Nothing special :) Jason L. Froebe Team Sybase http://jfroebe.livejournal.com liy wrote: > Does the secondary truncation point in the Adaptive Server need to be > disabled when upgrading ASE 12.5.03 to ASE 12.5.3? > > Thanks > > > ...

Web resources about - Rep server with ase 12.5 - sybase.rep-server

Server farm - Wikipedia, the free encyclopedia
A server farm or server cluster is a collection of computer servers usually maintained by an enterprise to accomplish server needs far beyond ...

Turkey internet servers under sustained cyber attack: internet body
Turkish internet servers have suffered one of the most intense cyberattacks ever seen in the country over the past week, raising fears Ankara ...

Attack floods Internet root servers with 5 million queries a second
Enlarge (credit: rootservers.org ) Early last week, one of the most vital organs of the Internet anatomy came under an unusual attack. On two ...

Amazon deal: Save $85 on this Sony portable wireless server
Smartphones' memory storage gets filled so quickly these days thanks to photos, videos and more, so get yourself a handy portable wireless server ...

Facebook releases design for its souped-up A.I. server, 'Big Sur'
Facebook is releasing the hardware design for a server it uses to train artificial intelligence (A.I.) software, allowing other companies exploring ...

Applebee’s Server Returns $32,000 In Cash Family Accidentally Left On The Table
... and scored a huge tip from some abnormally generous person, and you figure the money is yours to keep. Or, if you’re like one Applebee’s server ...

FBI Director: Obama ‘Certainly’ Would Not Have Received A Briefing On Hillary’s Server Investigation
FBI Director: Obama ‘Certainly’ Would Not Have Received A Briefing On Hillary’s Server Investigation

Facebook, Google server outsourcing strategy change expected to impact profitability for ODMs
Facebook is planning to add Wiwynn, a server subsidiary of Wistron, as a new datacenter server supplier, joining its primary supplier Quanta ...

Hillary Clinton's private server had two 'top secret' emails
Those concerns that Hillary Clinton's private email server had classified intel? They're apparently well-founded. Sources for Fox News and Politico ...

CTERA Unveils Server Data Protection for Enterprise CloudOps
The data protection solution evolves the backup capabilities developed as part of the company’s Enterprise File Services Platform.

Resources last updated: 12/24/2015 2:02:08 PM