SQL Central fails repeatedly ASE 11.5
Anyone else having difficulty preventing SQL Central from crashing? I've
just installed ASE 11.4 on NT 4.0 sp3, and can do very little before SQL
Central wakes up Dr Watson and complains about access protection faults
(GPF by another name)
I am using ASE 11.5 and Sybase Central 2.3.01 Build #1832 and it happens at
least 5 times a day it crashes...and when I am using the NetImpact Dynamo
1.2 plug-in it crashes every hour.
Kevin Campbell wrote in message <3471ECD4.AB14A897@gte.net>...
>Anyone else having difficulty preventing SQL Central from crashin...ASE to ASE
Is anyone out there doing ASE to ASE replication using SQL remote? If
you are have created your own version of the SSEXTRACT utility to set up
a replicant database in ASE rather than ASA? Or does anyone know if
SYBASE has created a version SSEXTRACT for use with ASE to ASE
Thanks in advance
I thought the SQL Remote Replication support in ASE11.5 was meant for a
consolidate-database only (by design)! At least that was what Sybase
said when they announced support for SQL Remote technology support in
I will be happy to...ASE and ASE
Could it be possible to take scripts from ASA and load them in an ASE
Any information is welcome
ASA supports a fairly large sub-set of Transact-SQL, so if you write your
stored procedures and triggers in ASA using T-SQL, you should be able to
create scripts that will run against both ASE and ASA. If you're planning
to do this though, I would suggest developing your database schema against
ASA, since everything you write in T-SQL in ASA will be supported on ASE,
but the reverse is not true.
Check out the section in the ASA documentation entitled "Tra...long sql failed in ASE 11.5.1 failed
I tried to send a query with a long where list to an oracle database
through ASE CIS, but the server hang. If I took the same statement send
to DCOracle and bypass ASE it works. Can someone shed some light for me
on this? Thanks
Long where clauses may be a problem if it ur user stack is full.
Try to increase the ASE "default stack size" parameter on server and try it
...What generals generally do
Reading a McChrystal thread elsewhere, I came across someone quoting a
> I spent 33 years and four months in active military service and
> during that period I spent most of my time as a high class thug for
> Big Business, for Wall Street and the bankers. In short, I was a
> racketeer, a gangster for capitalism. I helped make Mexico and
> especially Tampico safe for American oil interests in 1914. I helped
> make Haiti and Cuba a decent place for the National City Bank boys to
> collect revenues in. I ...Loading ASE 15 beta2 --> ASE 15 fails
Having issues loading a dump from ASE 15 beta2 into ASE 15.
Beta license expired so installed new copy of ASE 15 and the
dumps from beta2 do not load.
Have tried doing remote load into ASE 15 using beta2 backup
server. Issues here because dumps done with level 4
1> load database dbadmin from
Backup Server: 126.96.36.199: Remote DUMP/LOAD is not allowed
when interfacing to a stripe for device
30 10:5...Fail to online database(ASE 12.5->ASE 15.0 developer)
Could you please help me to take a look at the error? It
happened when I want to online databse, I can load database
successfully:-), but failed to online......
I backup up the database from ASE 12.5, and restore it to
ASE 15.0 developer...
1> online database AdventureWorksDW
Started estimating recovery log boundaries for database
Database 'AdventureWorksDW', checkpoint=(15436, 11),
Completed estimating recovery log boundaries for database
Started ANA...Why does the following query fail on ASE 15.0.2 but work on ASE 12.5.4?
Connection conn = getConnection();
PreparedStatement stmt = conn.prepareStatement("select 'test' from
syscolumns where ? = ?");
The error is "Implicit conversion from datatype 'VARCHAR' to 'INT' is not
allowed. Use the CONVERT function to run this query."
I think I found the solution, which is that the database needs to know what
type to expect for the parameter marker. Therefore using an explicit
conversion (as mentioned in the error me...ASA To ASE - VS
What are the differents in terms of configuring SQL Remote Between ASA to
ASE and ASE To ASE ?
You should start with the Help file and then ask specific questions:
Data Replication with SQL Remote
PART 5. Appendix
APPENDIX A. Enterprise and Anywhere: Differences
There are many differences, so begin there.
Please only post to the newsgroup
BH Ong <email@example.com> wrote in message
> What are the differents in terms of configuring SQL Remote Between ASA to
> ASE and ASE To ASE ...ASE 188.8.131.52
I'm running 184.108.40.206 (so latest patch level) on Fedora Core 3. It's a quad
I've configured 3 sybase online engines to run. Min = 3 and Max = 3.
Sometimes all 3 startup.
Sometimes only 2 or only the initial engine startup.
When 1 or more engines fail to startup the error message in the logs is
kernel engine 1, os pid 5228 exited
kernel os_process_exists: kill failed. pid 5229 No such process
I've checked if some stale network connection is still connected on port
4100 before a problem restart, but this does not seem to b...Displaying only failed statements
using ASA 220.127.116.1198 with DBRemote. The command line is :
dbremote -m 32M -c "dbn=Sp" -rd 2 -rp 5 -q -os 5M -o C:\Remote\Remote.log
This is part of log file, created by -o option
I. 01/05 12:04:37. Applying message from "office"
E. 01/05 12:04:37. SQL statement failed: (-194) No primary key value for
foreign key 'Vend_Art' in table 'Art'
I. 01/05 12:04:38. Applying message from "office"
E. 01/05 12:04:38. SQL statement failed: (-194) No primary key value for
...Failing ASE creation.
I have installed ASE 12.5 and am trying to build the master device.
I believe the following excerpt is the cause, but have no idea how to fix
it. Can anyone shed some light on this?
00:00000:00001:2001/12/20 13:46:24.68 kernel ueshutdown: exiting
ld.so.1: /opt/sybase/ASE-12_5/bin/dataserver: fatal: relocation error: file
__1cG__CrunVdo_exit_code_in_range6Fpv1_v_: referenced symbol not found
The complete output below...
Building Adaptive Server 'hades':
Writing entry into directory services... Directory services entr...Adding ASE to existing ASE-to-ASE Installation
I am using all ASE's in my SQLRemote setup.
My current installation consists of a Consolidated ASE & 2 Remote ASE's.
My attempt to add another Remote ASE to the existing installation
consists of these steps:
- Install the sqlremote system objects in the new Remote
- Install the stable queues in the new Remote
- Manually extract a bcp file of the shared table from the Cons
- Configure the Cons server for another subscriber
- Configure the new Remote's shared table, publications, &
- Manually b...Restore ase database fail
Error content using backup server:
Backup Server session id is: 30. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume change
request from the Backup Server.
Backup Server: 18.104.22.168: Dumpfile name '/home/sybase/date' section number
0001 mounted on disk file '/home/SYBASE/zbbak090202.dat'
Backup Server: 22.214.171.124: Logical page 1051903 is not in the given database
...Displaying an alert when a validator fails
Hi All,I've got a RangeValidator that ensures that the integer input in a textbox is in the allowed range. It pops up some red error text next to the textbox if they enter the wrong text.I am wondering if there is a way to trigger a dialog box (e.g., alert('You must enter a value between 5 and 15')) if they enter an invalid number in the field. The reason being, we've had a number of people who go through past that field quickly, and don't notice the red error text. The alert() dialog, which will interrupt user activity and give an audion alert, will (ho...