Sybase数据库技术，数据库恢复专家

running an SQL query is killed.

To reproduce:

1) create a new XML model

2) create a new element (element_1)

3) add three new elements to element(element_1)

(The three new elements branch off the sequence)

4) add several attributes to element_2

NOTE: element_2 now overlaps the other elements

Neither collapsing the sequence, auto-layout, nor redisplay corrects the issue.

The only workaround is to change the orientation from horizontal to vertical

Open a XML model

Click Language menu

The menu reads...

Generate %s File

Reverse Engineer %s File

Instead of...

Generate Schema Files

Reverse Engineer Schema Files

Session #1 is running DUMP TRAN WITH NO_LOG, already holds the append log semaphore lock

and is waiting for an exclusive latch lock on syscolumns page 'P1' to be granted.

Session #2 is running DROP TABLE, holds the conflicting with session #1 exclusive latch

lock on syscolumns page 'P1' and is waiting for a PLC lock to be granted. Session #3

is running DROP TABLE, holds the conflicting with session #2 PLC lock and is waiting

for the append log semaphore lock to be granted, which lock is held by session #1.

log free space with a 1105 error and a 3475 error on a mixed data and log database.

a large number of engines due to over optimistic costing of serial query

plans.

may be reported when attempting to load a valid database dump into an archive database.

00:1094719808:46912511093344:2011/06/28 07:33:13.37 worker string provided is too long to add to buffer provided

00:1094719808:46912511093344:2011/06/28 07:33:13.37 worker jsj__AddToBuffer() failed

the union view/derived_table is participating in an equijoin join with another table and

there is also a constant sarg (col=<const>) on the other table's equijoin column.

a stored procedure and UPDATE a temp table.

Msg 7218, Site '<remote_server' not found in sysservers.

The usertype field in syscolumns is not being set correctly.

log preceded by a stack trace which includes the modules 'des_idtnewval' and 'des__errhdl'.

The stack trace information should not be reported.

mode could generate a SEGV. This would occur if the outer stream

of the right nested OJ had replicated partitioning. The stack would

contain a calls to OptDeepPDTransform() and eqcGenNlJoinPop().

ASE 15.5 ESD#3

SQL Advantange 12.5.3 EBF 12338

DBISQL version 11.01, build 2430

Problem Description:

Customer reports that DBISQL does not report as much detailed message compared with SQL Advantage.

Since SQL Advantage is deprecated customer is requesting FR to be implemented:

The problem occurs in plans that contain store_index or N-to-1 Nlj

strategies. This can lead to the selection of plans that require

more threads than the system/query was configured for. This fix

is enabled with optcriteria cr647607.

option "heap memory per user"

in database 2 in DROP state." together with a stack trace which includes

the modules 'sqt_free' and 'des__markdestroy' may be reported in the

error log when a session is trying to release a dynamic SQL statement

(previously prepared) and concurrently another session is trying to access

the same prepared statement, for example using the OBJECT_NAME() builtin

with the id used by the internal procedure created for the prepared

statement.

defined on a base table with an encrypted column and a decrypt default,

the decrypt default information may be lost leading to a 3762 error:

"The decrypt_default for column id 27 was not found in the system

catalogs."

of a WRITETEXT non logged command may not be rolled back during ASE boot time recovery

and after ASE was shutdown with nowait.

the replication of off-row text/image columns may become inconsistent when the table does

not have any other non-clustered index. In that case 'DBCC CHECKTABLE' would report error 7928.

'UPDATE' or 'WRITETEXT' may fail with error 644 or error 7165 respectively.

and several client connections are simultaneously made using encrypted passwords.

currently when generating an XSM from a PDM, columns could be generated to XSM as either all Elements or all Attributes

customer claims that PK columns should be coming into XSM as child elements, whereas the non-PK columns are Attributes

i.e.

- create Table_1, Col_1 (PK), Col_2 and Col_3

- generate XSM from PDM

- if columns are selected to be generated as Elements, then the outcome diagram is

Root --S---> Table_1 --S---> Col_1, Col_2, Col_3, where --S---> is Sequence and Table_1, Col_1, Col_2 and Col_3 are elements

- if columns are selected to be generated as Attributes, then the outcome diagram is

Root --S---> Table_1 | Col_1, Col_2, Col_3 |, where --S---> is Sequence and Table_1 is Element, and Col_1, Col_2, and Col_3 are attributes of Table_1

- customer thinks that the following should be the outcome diagram:

Root --S---> Table_1 | Col_2, Col 3 | --S---> Col_1, where --S---> is Sequence, Table_1 and Col_1 are Elements, and Col_2 and Col_3 are attributes of Table_1

workaround

defining manually through XML builder workaround provided - however, it will not work very well if the numbers of tables get large.

right nested plan. Optimizer could choose such plans under allrows_dss optgoal

or under abstract plan forcing.

that results in error 7218. The entire memory pool runs out with an error 11223 after 1024 failed

connection attempts.

base table with the decrypt_default attribute, Adaptive Server may fail to

check the user's decrypt permission and incorrectly return the decrypt_default

value instead of the actual column value.

customer does not want to turn the role off. customer essentially wants a way to have a role so that it uses an srid and exists on all machines. However the customer does not want it usable on all machines. the customer does not want people to be able to grant permissions to it. the customer just wants it there as a placeholder so that the customer can keep all their dataserver permissions in sync except down to the grant level.

There will be an information message "INFO: Total Object Ids in temporary database generated:<total id count>, LWPs generated: <LWP id count >" printed for every 100 million object ids generated

to the replication of row-level compressed data.

using the stored procedure sp_poolconfig, when the total number

of buffers in the pool is not evenly distributed amongst the

cachelets, will fail with the following 852 error:

"Command Failed: Invalid request to move 'X' buffers from the

'<pool-size>'K pool of the '<cachename>' cache to the '2048'K pool.

Source pool only contains 'Y' buffers. Retry the command

specifying fewer buffers."

DOL table with placement index on AIX platform.

memory between buffer pools using the sp_poolconfig system stored procedure,

may lead to error 2747: "Incorrect position specifier in format string of PRINT

command" followed by message: "Transaction count after EXECUTE indicates

that a COMMIT or ROLLBACK TRAN is missing. Previous count = X, Current

count = X+1".

"SySAM2: cpuinfo detects too many Itanium quad core chips"

from Oracle/Sun, the JRE headless mode is not correctly supported therefore allowing methods

using that mode to be executed although they should not.

"alter database ... set compression = <new compression schema>" command. The LOB compression

level will stay unchanged after the command.

index.

OAM entries with zero used/unused page.

no valid ASE_ASM license, sp_configure unexpectedly succeeds. License checks done at

ASE startup correctly report that no license is available, but unexpectedly allow

continued use of the FIPS login password encryption configuration option.

some unexpected data for thresholds other than the last chance threshold.

procedure to not require recompilation for every execution. This was

previously supported by trace flag 299.

might fail if any of the column names in the expansion of "*" requires delimited identifiers.

details, only metadata and not including user data, as a result set.

To activate the fix, trace flag 11241 needs to be turned on.

packet layer: internal net library error: Net-Library operation terminated due to disconnect"

when attempting to process a BIGTIME value.

"see Installing version 15.5 over an existing 15.x Adaptive Server."

to this:

"Installing Adaptive Server Using Binary Overlay"

upgraded from 15.0.3 ESD#4.

outer join query with subquery.

dumped due to user '<username>' (suid <suid>) executing <cmdname>", should not be raised for

databases with "trunc log on chkpt" enabled.

signal 4 (SIGILL)" in the module 'pci_launcher_trigger' together with a stack trace

which includes the modules 'jcnstCopy' and 'LeExecEvalsExec' may be reported in the error

log when queries that are using Java datatypes are being executed.

a stack trace which includes the modules 'ha_checkalive' and 'ha_vcs_getgroup' may be

reported in the error log during the installation of ASE HA Cluster companionship on AIX.

"Adaptive Server Enterprise 15.0 > Troubleshooting Guide: Error Messages Advanced Resolutions > Kernel Errors"

the CR# 624835 improve thing but it still not a good plan.

fragments.

be reported if the devices name length is more than 127 bytes when running a DUMP DATABASE command.

plan. It is more likely to happen when there is a subquery at the inner side too.

Same issue could also cause optimizer to ignore certain legit merge/hash

outerjoin bushy plan too under allrows_dss optimization goal.

one side of the union is directly projecting a constant for the column and the constant

is also part of the IN clause list.

maybe lower than the compression ratio obtained from reorg rebuild. Certain conditions that

can contribute to this run-time space bloating issue are addressed.

1. When there is no login-profile in a 15.7 server, make 'Ignore login profile when creating login' checkbox selected in the Login Profile page.

2. Disable the radio-button of 'Use a common login profile for the server version 15.7 and later' when there is only single 15.7 server appeared in the Login Profile page.

3. When a 15.7 server has no login-profile, make the server automatically appeared in the Default Database page. Note that before this fix, the Next button in the wizard is disabled and SCC user could not continue the wizard if 'Ignore login profile when creating login' checkbox is unselected; he has to cancel the wizard or unselect the 15.7 server that has no login-profile in the Introduction page or has to select 'Ignore login profile when creating login' checkbox in the Login Profile page.

status bit.

may be reported when executing the system stored procedure SP_HELP_REP_AGENT

with no parameter.

given process.

The Add Login wizard is enhanced to take care of a 15.7 server that has no login-profile.

1. When there is no login-profile in all 15.7 server, make 'Ignore login profile when creating login' checkbox selected in the Login Profile page. Otherwise, if there is LP in a 15.7 server, make 'Ignore login profile when creating login' checkbox selected by default in the Login Profile page.

2. Disable the radio-button of 'Use a common login profile for the server version 15.7 and later' when there is no common LP data found among the 15.7 server that has data of LP.

3. When a 15.7 server has no login-profile, make the server automatically appeared in the Default Database page. Note that before this fix, the Next button in the wizard is disabled and SCC user could not continue the wizard if 'Ignore login profile when creating login' checkbox is unselected; he has to cancel the wizard or unselect the 15.7 server that has no login-profile in the Introduction page or has to select 'Ignore login profile when creating login' checkbox in the Login Profile page.

"Keep count of descriptor (objid=<id>, dbid=<id>) was expected to be 1. Instead 0 was found."

may be reported in the error log together with a stack trace which includes

the modules 'des__unkeep' and 'close_range' when an INSERT, DELETE or UPDATE is

executed on a table that has many referential integrity constraints defined and

after the execution of one of its triggers. Alternatively the message "infected with 11"

in the modules 'seq_schema_check_virtab' or 'LeScanOp::_LeOpOpen' may be reported.

Create Database Wizard -> Add User Database

Create Temporary Database Wizard -> Add Temporary Database

Create Temporary Database Group Wizard -> Add Temporary Database Group

Create Proxy Database Wizard -> Add Proxy Database

Create Archive Database Wizard -> Add Archive Database

Create In-Memory Database Wizard -> Add In-Memory Database

Create In-Memory Temporary Database Wizarde -> Add In-Memory Temporary Database

Create Login Profile Wizard -> Add Login Profile

(1) The configuration option 'enable functionality group' is enabled.

(2) The configuration option 'statement cache size' is larger than 0.

(3) A dynamic SQL statement with at least one parameter whose dataype depends upon a table-column referenced in the statement has been prepared and executed at least once, so that a query plan is available.

(4) The table-column's datatype has been changed to a type that is not implicitly convertible to the original type by dropping and re-creating the table.

(5) The dynamic SQL statement is re-executed with a parameter type that matches the new column dataype.

reformatting strategies where the reformatted table is partitioned N-ways.

is an expression join predicate and the expression involves columns from both sides of the

join (e.g. t1.c1*t2.c2=t1.c3).

sdes_num_in_chain() together with a stack trace which includes the

modules kill_proc() and LeExecSqlFunc() may be reported in the error

log if a long running user-defined SQL function session gets killed.

ASE may need to be rebooted following this error.

optlevel and above. The stack will show that we're code generating (CgpGlobal::CgpGenerate()) and trying to resolve a relop (ResRelOp) for a predicate bitmap (CgpPop::_CgpPePredBmToScalar).

due to UPDATE, rep agent will report 9275 error "%S_REPAGNT: Could not locate the %s image for the

%s log record at (%d,%d)."

(1) An outer join the projects a LOB column from the inner side of the join and

(2) A UNION ALL operation and

(3) An ODERBY clause.

But having 128 value lists for the same query works fine without problem.

together with a stack trace which includes the modules 'open__lwpbyname' and 'proc_get' may

be reported in the error log and the session killed if a 603 error has been previously hit

"There are not enough system session descriptors available to run this query. Raise the value

of the configuration parameter 'number of aux scan descriptors' or retry your query later.".

Transaction log may be corrupt. Please contact SYBASE Technical Support. (current marker =

(page id, rowid))", will be reported if a TEXT/IMAGE/UNITEXT columns is defined to be compressed

explicitly, or the table it belongs to has LOB compression, and this column is configured to

be replicated.

even when the subquery is under CASE expression and the actual execution of the CASE

doesn't need the result of the subquery. This could lead to unexpected exception

during the unnecessary execution of the subquery.

datatypes (such as INT2 = INT4) and there are two or more OR predicates (including

IN list predicates) on one of the joining columns.

next_identity will encounter a 10330 or 10354 error. This will occur even if the user has execute

permission for the stored procedure and the stored procedure and the referenced object are owned by

the same user.

his own server id to the function, the builtin incorrectly returns TRUE in

the case where the server user is NOT a valid user in any database but where

there exists a guest user in at least one database.

with a stack trace which includes the modules 'xact__rollback_local' and 'crt_main' may be

reported in the error log when the 1105 error was previously reported during the creation

of a table.

pure blank values and a GROUP HASHING plan is chosen.

set role sso_role with passwd xxxxxxxxx on

So that clients with sso_role can see all encryption keys in all databases without having to login and use isql or dbisql.

Server menu now included 'Role Activation' dialog.

'css_deallocate' together with a stack trace which includes

the modules 's_free' and 's_cleanframe' may be reported in the

error log under some circumstances if the execution of a stored

procedure using a cursor was aborted by an error (like a 1205

error caused by a deadlock) and the plan being executed was

just recompiled.

(dbid: <dbid>, pageno: <page id>) without releasing the exclusive latch it holds on the buffer.",

may be reported with stack trace when running UPDATE/WRITETEXT commands on TEXT/IMAGE/UNITEXT

columns, or DELETE...FROM/TRUNCATE TABLE/DROP TABLE commands on tables which have TEXT/IMAGE/UNITEXT

columns, or DROP DATABASE command on databases which have tables contains TEXT/IMAGE/UNITEXT

columns.

error, "ASE is now using a multi-byte character set, and the TEXT character counts have not

been re-calculated using this character set for table <table name>. Use DBCC FIX_TEXT on this table

before running the query again", may be raised when query data from this compressed TEXT column.

memory pool. As a consequence, error 716 may be reported ("Unable to allocate memory of size <n> bytes from the 'compression info' pool.").

text back to the client.

together with a stack trace which includes the modules 'pggam_getfree_lowhigh' and

'crt_work' may be reported in the error log and the session killed if a 603 error

has been previously hit "There are not enough system session descriptors available

to run this query. Raise the value of the configuration parameter 'number of aux scan

descriptors' or retry your query later.". Alternatively a stack trace which includes

the modules 'open__lwpbyname' and 'sqt_get_plan' may be reported.

or audit tables.

DBCC FIX_TEXT on this table before running the query again", may be raised when querying data from this TEXT column.

recovery behaves when it detects data corruption, is active.

As of 12.5.3 ESD #3, the QUIESCE DATABASE and UNMOUNT DATABASE commands

are allowed to operate on any number of databases. This is the result of

CR 379513. Currently, the QUIESCE DATABASE docs specify:

You can specify a maximum of eight databases in a single quiesce database

hold command. If you must suspend updates to additional databases, execute

additional quiesce database hold commands.

accessing <parition name>. This is an internal system error. Please contact Sybase

Technical Support.", may be raised when inserting data in bulk mode into replicated

table with compression and LOB columns while sp_reptostandby is turned on.

As examples,

- number(s,p) becomes xs:decimal, length and fraction digits are both empty.

- varchar(n) becomes xs:string and length is empty.

This also happens with columns not associated to any domain: length and precision have been lost.

compressed rows is marked for replication, resulting in the RepAgent thread terminating itself.

is missing in winx64 for 15.5 esd #5 and 15.7 GA.

"Workspace 'def$scan$ws' is incorrectly allocated. Use sp_dbcc_createws to create a new workspace."

This lead to following error:

Could not acquire a lock within the specified wait period. DTM_SERVER level wait period=...

Cannot lock table 'master.dbo.rmt_ha_sysattributes'.

HA Internal Error: Cannot acquire locks for stored procedure 'sp_addexternlogin' on server ''. Retry later.

for adding new columns in the table.

audit trail for Extended Encrypted Password login protocol and for

Extended Plus Encrypted Password login protocol to describe the password encryption used.

server, prepare will fail and raise message "One or more databases still permit wide DOL rows."

on local system and global temporary databases.

This feature is to streamline the query plan is specific scenarios where the attributes

and indices have specific properties in order to remove any unnecessary scans.

the join selectivity which can cause inefficient plan choices in circumstances involving

data skew.

This request is to look to improve the selectivity calculations to take advantage of any

histogram that might be usable on the child table.

operators used for referential integrity checking during dml operations.

will be reported, but query execution continues. If the explicit value for the TIMESTAMP

column is the result of evaluating an expression, and the query plan for the INSERT is

re-executed (i.e. because the statement cache and literal auto parameterization are

enabled or because the INSERT query is part of a stored procedure), memory corruption may

occur, leading to various stack traces.

with a stack trace which includes the modules 'AnyDataType::AnyConvertType',

'EmbedDataSet::embedConvertType' and 'OptBlock::OptDoPredElim' may be reported

in the error log when a UNION query is run with a parameterized WHERE clause

on a semantically partitioned table.

an error 156 during attempted execution of invalid 'create procedure' statement contained

within begin..end block.

circular "Cancel Queue" leading to the timeslice error.

return unexpected trailing spaces if statement cache is enabled.

SIGSEGV followed by a stack trace that includes the module np__conn_doconnect() may occur and the dataserver then crashes.

is evaluated against a constant under 'set ansinull off' (default behaviour)

it is possible for behaviour to return to legacy behaviour seen prior to version

15.0.2 ESD#5.

NULL behaviour under ansinull off (default):-

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32300.1570/html/sqlug/sqlug94.htm

is no longer applicable since 15.0.2 ESD#5, we need to update the documentation

The 'OAM count threshold' respresents the percentage by which the discrepancy between

between the actual row count and the row count as reported by the OAM pages can vary

before checkstorage will raise error 100025 - 'row count error'.

Under normal circumstances it is safe to leave this at the default value of 2%.

'cmcc__wri_bcmt_proc' and 'bufwritedes_log' may be reported in the error log when ASE flushes a syslogs page on disk while downgrading the physical lock held on this syslogs page in a 2 node Cluster Edition setup.

would not have an effect on subsequent update statistics commands for

columns which already have statistics. The number of steps used by update

statistics should only be preserved from earlier commands if it was run

with the option "using <step> values".

The "with sampling = <value> percent" will be preserved in the same way

as a explicit "using <step> values" between update statistics commands.

That is, a preserved explicit value will become the default when

subsequent commands do not specify a value, ignoring the configured default.

in 'create table' DDLs.

But this feature does not support alter table lock command.

There is a reference to 'auto_template_stats'

This should read 'auto_temptable_stats'

'compression info pool size' information.

DTM Option is included in base ASE license after ASE15.x.

activity on the system.", may be reported when creating an index on a table with a large number of partitions.

one of these columns is an in-row LOB with at least one result value actually stored in the row, a SIG BUS may be raised when the result set is FETCH. This error only occurs on platforms that require memory address alignment.

utilization ASE.

column for objects like tables, database etc.

specified using 'create login') and to also switch 'login name' to a large identifier

(255 chars). It is also to allow the use of a period '.' in the login name.

Adaptive Server Enterprise 15.7 > Reference Manual: Commands > Create login

Parameters

login_name

specifies the name of the login account to be created. <It must start with an

alphabetic character and cannot exceed 30 characters in length.>

This is fixed via CR 674627.

It could also happen in circumstances where the query tree needs to be recreated from text

as in after the ASE is upgraded.

to sysstatistics, optdiag\sp_showoptstats will report zero.

This is a diagnostic issue only, sampling is performed during the update statistics

command.

be optimized using a general-or strategy. In cases where such a general-or

strategy provides the only efficient search strategy, query performance

could be poor.

when "capture missings statistics" is ON and executing a LWP and doing

compilation optimization.

functions hk__compress_page() and pg_modify_spacebits() may be reported durng HOUSEKEEPER garbage collection.

the version in the database...", may be reported when a database dump from a Cluster Edition

server is loaded in a newer SMP server.

a temporary table to hit an error 225

Msg 225, Level 16, State 3:

Server 'SOGDEN157', Line 1:

Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during query optimization.

This is timing specific and can only occur during parallel execution of a statement

referencing the same temp table name.

feature on ASE. Specifically, he would like to be able to configure resource limits

on the number of locks similar to number of rows. Often there is a situation

where a process is unable to escalate to a table level lock on an object due to

other processes having lock(s) on the same object. Though this is more likely

on a DOL (especially Datarows lockscheme) table, it is possible on very large

Allpages lockscheme tables also.

selected through a view, ASE may incorrectly return decrypted data on

some of the columns.

as 'hostname:portnumber'.

index ddl for the proxy table.

This may fail when running the script created by ddlgen as those indices will

implicitly be added to the proxy table index definitions from the source table after the

proxy table is created.

zombie spid is left behind

Start Adaptive Server with a trace flag only when instructed to do so in this manual or as directed by Sybase Technical Support or a Cover letter. Commands or stored procedures which are not directed under these flags at any other time or way may create an error or a stack trace or other problems.

Especially trace flags 3607 and 3608 are used when a special recovery procedure is performed. Do not attempt a normal shutdown after using trace flags 3607 or 3608. Always use shutdown with nowait in these cases.

Create Function (280).

calls a web service (which uses java.xml.ws package) it is possible for the execution to

hit the following error:-

Unhandled Java Exception:

javax.xml.ws.WebServiceException: class <class> do not have a property of the name {....}<parameter>

at com.sun.xml.internal.ws.client.sei.BodyBuilder$DocLit.<init>(Unknown Source)

at com.sun.xml.internal.ws.client.sei.SEIMethodHandler.<init>(Unknown Source)

at com.sun.xml.internal.ws.client.sei.SyncMethodHandler.<init>(Unknown Source)

at com.sun.xml.inte.

not currently allocated to the database.

for the backupserver binary to core dump due to a SEGV in srv__q_defevent()

such as "A Rep Agent Thread for database '<dbname>' (dbid=<value>) is already running".

When a query involves an equi-join between two char columns

and there exists only an equivalence between the values ('a'='A' for example), it is

possible for a query to return unexpected results if a built-in function (or comparable

operator) in the predicate is reliant on the specific value from one side of the join.

Examples of this may be the compare() function when using a binary collation as the 3rd

argument or conversion of the column value in order to do a binary comparison.

for currently executing as well as previously executed statements in the relevant

MDA tables

monCachedProcedures

monProcessStatement

monProcessProcedures

monCachedStatement

monSysStatement

error..

CT-LIBRARY error:

ct_send(): network packet layer: internal Client Library error: State error: trying to write when connection is expecting a read

..to be observed when using isql or any other ct-lib client and the subsequent statement

(after the execute immediate) to not be executed. The issue only arises under very

specific circumstances when certain statements that are deferred for compilation at

runtime have to be compiled when under an execute immediate.

with SP_CONFIG_DUMP, the full path needs be saved in the dump history file for use when

generating the list of commands that are needed to create a target database with the same

layout as the source database.

1. the Size(MB) is over 99999.99 MB

2. the Usage(%) is over 99.99

This fix allows the Pool Information without causing numeric overflow

1. the Size(MB) up to 9999999.9 MB or 9999.9999 GB

2. the Usage(%) up to 9999.9

In addition, the Usage(%) in this fix corrects the value by a factor of logical page size of the server in KB (that is either 2,4,8 or 16).

Adaptive Server Enterprise 15.7 > System Administration Guide: Volume 2 > Checking Database

Consistency > Upgrading compiled objects with dbcc upgrade_object

This section advises that post successful upgrade the sysprocedures.version should read

12500, this is incorrect, after a successful upgrade it should read 15000 for any version

from 15.0 to 15.7.

compression properties defined has its schema changed by setting

the LOB compression property to not compressed, ASE following a SELECT

query execution may return incorrect results for this column for data

that was inserted into this column before the column schema change occured.

containing the functions memset and bi__xml_query/bi_xmlextract.

This can happen under heavy usage when the session heap memory pool has become starved.

The are looking for similar functionality as 'View Data' in the PDM model.

where 0 = disable and 1 = enable. The default value is 0.

and if the option "ddl path for unbound objects" is set to "default", it is possible that DDL

commands are replicated to the incorrect path.

in version 12.0) to allow implicit permissions to be granted on an underlying object

used by a stored procedure (or equivalent) when the object is in a different database

and was created by a different login than that which created the stored procedure.

The logins used to create both stored procedure and object would be aliases to the same

equivalent user in each database.

The current behaviour is a documented restriction:-

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc01672.1570/html/sec_admin/BABHCJBA.htm?resultof=%22%63%6f%6e%63%72%65%74%65%22%20%22%63%6f%6e%63%72%65%74%22%20%22%69%64%65%6e%74%69%66%69%63%61%74%69%6f%6e%22%20%22%69%64%65%6e%74%69%66%22%20%22%63%72%6f%73%73%2d%64%61%74%61%62%61%73%65%22%20

and restarting the RepAgent, the setting automatically reverts back to 'disabled' mistakenly.

The cluster interconnect protocol has not been defined in the cluster input file.

Cannot resolve host name '' for the local interface of the link to monitor.

Cannot resolve host name '' for the remote interface of the link to monitor.

followed by error 11050, "Adaptive Server cannot process this ALTER TABLE statement

due to one or more preceding errors. If there are no preceding errors, please contact

Sybase Technical Support.", and error 11934, "REORG REBUILD of table 'tabname' failed

due to an internal error. Please contact SYBASE Technical Support", may be reported

when running 'reorg rebuild' command on table which has data or LOB compressedion

defined after user is bind to temporary in-memory database.

in two error messages will be displayed stating that the user is not a user in the database.

Something similar to the TZ variable at OS level.

The optimizer may generate optimal plans for the related queries after creation of a new index which may work better for the queries.

caused by the plan corruption.

Similar to timestamp but in a format that is useful.

in public product document.

(NG) By default, the log file is located in $SYBASE/$SYBASE_ASE/install/errorlog.

(OK) By default, the log file is located in $SYBASE/$SYBASE_ASE/install/<servername>.log.

larger than 127 characters (254 bytes) may cause the process to be terminated.

where generally each grouping column belongs to a different "joined" table)

may SEGV after generating a 331 error terminating the session. The 331 error is raised

because the query has exhausted the sort id namespace.

1. DBO cannot transfer ownership on dbo-owned objects.

2. Any user or executor with sa_role cannot transfer ownership on dbo-owned objects.

In the new restriction, the wizard will not allow user to select objects that he has no privilege to transfer ownership on.

inner-side it is possible for the estimate number of rows to be higher than the number of

rows being passed in from the left. In reality in this situation the maxiumm number of rows

the join may produce is less than or equal to the number of rows from the left.

integrity definitions for us to be able to bypass any access to the child table during the

execution of a query involving a join from child to parent table.

transactions for space reservation.", may be reoported when running BCP IN/INSERT/UPDATE on table with TEXT/IMAGE/UNITEXT columns marked replicated.

@@maxpagesize, replicate ASE may raise error 7153 'Premature end-of-message received while reading text data from network. Host program may have stopped responding or may be sending text data containing a partial character at the end.' and Rep Server abort the connection.

with SP_CONFIG_DUMP, the full path needs be saved in the dump history file for use when

generating the list of load database and load transaction commands that are needed to

repopulate the database to a specified point in time.

Backup Server: 4.141.2.22: [23] The 'read' call failed for database/archive

device while working on stripe device <device> with error number 14 (Bad address).

This has been reported when loading a striped dump taken using 'with compression=100', but

only sporadically.

include the various database options (applied with sp_dboption) and

attributes (applied with CREATE and ALTER DATABASE) of the source

database, in the generated SQL.

owner.objectname or use sp_help to ..." may be incorrectly reported when

a SQL user defined function created in sybsystemprocs database with

a name prefixed by "sp_" is invoked from a database while a open

transaction in the same database is creating a stored procedure, view,

trigger, rule or default.

the 1st node with the lower version server, when booting the 2nd node, ASE will hit SIGSEGV at 1st

node and hang the 2nd node.

CHECKTABLE and DBCC CHECKDB these types of inconsistencies were already being reported with message 15960.

table 'syspartitions'. Please contact Sybase Technical Support." may be

reported during the execution of either LOAD DATABASE or USE <database>

commands when ASE is requested to calculate threshold information by

performing OAM scans.

May need to add more validation code in the related routine. A possible workaround is not to query monProcessObject.

"background task error 18388: You must be in the master database in order to run 'sp_locklogin'."

ASE may move some of these columns from in-row to off-row or vice-versa

if the size of a datarow exceeds configured limits. When such a table has

a datarow with an off-row LOB column that is not explicitly updated, ASE

may not log this column data correctly. This will result in replication

failing if this column is marked as always_replicate.

Sybase CSI Error Message: Error generating asymmetric key. Root error: error:0906D06C:PEM routines:PEM_read_bio:no start line

CT-LIBRARY error:

ct_connect(): protocol specific layer: internal Client Library error: There is a tds login error. The installed encryption handler returned a status that was not CS_SUCCEED.

logins are externally authenticated using Kerberos\LDAP

has TEXT/IMAGE/UNITEXT columns, some TEXT/IMAGE/UNITEXT data may not be successfully replicated.

followed by a 9204 error, "Could not locate schema for object with id = (0), current marker

(0, 0)." may be reported in the error log when inserting or updating an in-row LOB datum

and the 憁ultipath distribution model� is enabled. This will result in the Rep Agent

Thread shutting down itself.

an error 622 may be reported together with a stack trace in the error log which includes

the modules 'get_repdef_mode', 'open_user_table' and 'sdes_hookup'.

possible under rare circumstances for a stack trace to appear in the error log

in function upsleepgeneric() with js_wakeup() also appearing. The server will necessarily shutdown as this path holds spinlocks.

an error 950(Database 'master' is currently offline. Please wait and try your command again later) will

be raised during the upgrade.

When configuration parameter "net password encryption reqd" is set to 1/2, the utilities like haisql, HAase Agent or MSCS HA agent will fail to login to server with following errors :

Msg 1640, Level 16, State 2:

Adaptive Server requires encryption of the login password on the network.

Msg 4002, Level 14, State 1:

Login failed.

CT-LIBRARY error:

ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.

1> sp_monitor

2> go

Msg 2812, Level 16, State 11:

Server '<server>', Procedure 'sp_monitor_server', Line 57:

Stored procedure '' not found. Specify owner.objectname or use sp_help to check

whether the object exists (sp_help may produce lots of output).

('default data cache') ... " may be reported when an ASE 12.5.4 database

dump is loaded into an in-memory database and while ONLINE DATABASE is

run. This will result in a database upgrade failure.

explicitly set will continue to be used for future update statistics and

create index commands on the same table if these options are not specified.

These sticky options are:

step count (using step values);

histogram_tuning_factor;

sampling;

hashing, partial_hashing, no_hashing.

This CR implements a configuration parameter "enable sticky statistics"

to control statistics stickiness server wide. The default for

"enable sticky statistics" is 1, which matches existing sticky statistics

behavior. To turn off sticky statistics, use:

sp_configure 揺nable sticky statistics� , 0

's_begupdate' together with a stack trace which includes the

modules 's_execute' and 'execproc' may be reported in the

error log when a stored procedure executes a DML statement

which was compiled at runtime.

trace will appear in the ASE error log. This will terminate the jvm thread. This can and

will leave the ASE in an inconsistent state and will require a restart.

Error: 1265, Severity: 20, State: 1

An illegal attempt was made to release an invalid lock or a lock that is not owned by the process family (lr=0x0x14a01f000, lrmagic=f).

This can happen when there is a worktable used by an update statistics command

that resides on an in-memory tempdb (IMDB)

together with a stack trace which includes the modules 'decompress_row' and

'decompress__crow_to_apl' may be reported in the error log, after an alter table with

no datacopy command is run on a table that has compressed data, and while the replication

agent task is attempting to decompress data to be sent to the Rep Server.

which was introduced when Java RC2 arrived.

in the database info file exceeds the maximum number of allowed stripes." may be reported

by the backupserver when an attempt to execute a DUMP TRANSACTION command with many STRIPE ON

clauses is made.

- the SQL statement has enough predicates to generat at least 400 SARGs and

- the SQL statement is executing at isloation level 0 (dirty reads) and

- a unique index with at least 10 columns is chosen by the optimizer to use for repositioning the scan,

A 702 error can be raised with the function, setupSargArray in the call stack.

may be corrupt." may be reported when attempting to replicate data after an alter table drop

column with no datacopy command is run on a table with LOB data.

by a 3208 error, "Unexpected end of file while reading beginning of dump. Please confirm

that dump media contains a valid ASE dump. The ASE error log may contain more information

on the problem." may be reported due to a corrupted dump header while loading a database dump that was taken on ASE 15.7 ESD#2 and the database was created with a template.

2601 insert duplicate key row in object 'sysusers'

upgrade utilities or sp_downgrade/sp_downgrade_esd will report syntax error on the database name.

or a null value for @dbname, error message 18374 may be unexpectedly printed

with an empty database name.

This info need to add to user documentation.

"You must possess System Security Officer (SSO) role to run the installmaster

script" will be displayed when on a Cluster Edition server instead of

"You must possess System Administrator (SA) role, System Security Officer (SSO) role, Sybase Technical Suport role and Monitor and Diagnosis role to run the installmaster script."

sp_restore_system_role 'sa_serverprivs_role'

after having re-created 'sa_serverprivs_role' and the role id for 'sa_serverprivs_role'

is greater than 99, you will receive error 265

Msg 265, Level 16, State 1:

Server 'UBUSAP', Procedure 'sp_restore_system_role', Line 202:

Insufficient result space for explicit conversion of INT value '100' to a

VARCHAR field.

(return status = -6)

due to '0' emptypgcnt set by the task creating the index on empty DOL table.

Multi-attribute costing can lead to some undesired estimates in both search engine evaluation and plancost outputs.

"ERROR: Cannot downgrade to '15.0.0.0' server, which does not support bigdatetime and bigtime datatypes."

This error provides a CSMD point to dump the system state at the point

that parallel primary error processing begins. At this point, all of the

parallel family's state is available for diganostic analysis.

is used by more than one instance or Server, then there is a race condition during

JVM initialization where it is possible that the message 揷urrent process infected

with signal 11� in the function 慾vminit� may be reported in the error log, followed

by the message 揊ailed to initialize Java services". This may result in ASE shutting

itself down.

Currently this is not supported as LIKE clause uses a built-in function to

do its processing. This will lead to error 7721.

Msg 7721, Level 16, State 6:

Server 'xxxx', Line 1:

Precomputed result set definition error: Immediate PRS with built-ins

is/are invalid or not allowed; no PRS has been created.

columns do not exist in this table.

However, a warning in the IMDB users guide and ref manual should be created

and referenced table have an ownership chain available.

Also to support grantable predicated privileges on views directly.

predicated privileges to be respected on referenced tables where there exists

an ownership chain between trigger\UDF and referenced table.

set (materialized view) exists which selects that column, the session will be disconnected unexpectedly and a stack trace that includes the module memmove() will be reported in the error log.

with update statistics when specifying mutiple columns (multiple column syntax was

added in ESD#2)

update statistics t1 (c1),(c2) using out_of_range off

This request is to allow separate distinct out_of_rang clauses for each column in the

list:-

update statistics t1 (c1) using out_of_range on ,(c2) using out_of_range off

Currently this will raise a syntax error.

monProcessLookup

-201 : Prodecure <procedure_name> expects parameter <parameter_name>

where <parameter_name> is the name of the host variable that appears more than once in the cursor-declare statement, will be generated.

Basically, they encountered a failed load database because of a corrupt dump stripe.

This feature is to have backupserver run a final verifyonly like check on the dump before "dump is complete" is printed.

during execution of the statement.

When a spid is a worker process of a utility command such as dbcc checkstorage,

the 'tempdbname'\dbid reported will incorrectly be that of the current spid's db context

executing the sp_who\tempdb_id. This does not indicate any issue with actual

temporary storage locations.

the primary server the secondary server does not remove the predicate metadata.

Also if index partition names are system generated, then they are not generated in the partition spec , when -XPN option is specified

"5.7.2.7: RPC ('as_cmd') execution failed." may be reported when a LOAD DATABASE is executed and the backupserver name "hostname:portnumber" cannot be resolved correctly.

APL table with a local clustered index.

When granular permissions is enabled a user with online any database privilege can not online a database.

A possible workaround is:

Sp_configure 'identity reservation size',1

Sp_configure 'identity grab size',1

The workaround may have side effects including identity gap and performance impact.

attribute "dealloc_first_txtpg", are provided for tables having TEXT/IMAGE/UNITEXT off-row storage

columns, to control whether to deallocate the first text page after updating off-row LOB value from

non-NULL to NULL, or whether to allocate a first text page when updating LOB value from NULL to

NULL.

extents of a given object.

and the partition to be dropped and the referencing table are not empty, the command

fails because of possible violations with the foreign-key constraint, and Adaptive

Server displays error message 13971."

Msg 13971, Level 16, State 1:

Server 'UBUSAP', Line 1:

Could not drop partition with data from table 'p', because there are referential

constraints defined on the table and there are data rows in some of the

referencing tables.

1>

This is a feature request to extend the referential integrity checking to the alter

table command so as not to require that the parent table be empty when dropping a

partition whose rows have no dependant children.

becomes 0, which, however, should be 1.

a stack trace which includes the modules 'drop_al_dbid' and 'alterdb' may be reported

in the error log when an ALTER DATABASE LOG OFF command is executed to shrink this

database log space.

In ASEMAP 3.2.6 and 3.2.7, if the server is not configured for 'enable monitoring', user could not quiesce release the database. In this case, an error message is displayed in an error dialog box:

"Collection of monitoring data for table 'monOpenDatabases' requires that the 'enable monitoring' configuration option(s) be enabled. To set the necessary configuration, contact a user who has the System Administrator (SA) role."

In ASEMAP 3.2.8, it allows Quiesce Database Release to proceed by prompting for the tag name to quiesce release the database despite that 'enable monitoring' configuration is not set on the server.

0x0x1200000002' is not allowed because the database has mixed data and log segments."

may be reported incorrectly during the execution of CREATE DATABASE command as opposed to

"Altering database is not allowed because the database has mixed data and log segments."

processing.

with a stack trace which includes the modules 'LeRun' and 'exec_lava' may be reported

in the error log when a session executes a SELECT statement that uses the T-SQL function

"curunreservedpgs" while another session is in the process of extending the size of the current

database with ALTER DATABASE command.

or in full, it would be very helpful in diagnosing what went wrong during an extended

maintenance window etc if we logged a message to the error log.

This could detail the object name and relevant column(s) and what has changed in the

stats gathering mechanisms.

We could also report if\when the resource granularity setting

has been hit and multiple scans have been issued for hashing multiple columns.

file on the Microsoft Windows platforms.

the module altdb__clear_chunk() may be reported when executing SHRINKDB concurrently with sp_placeobject.

SYBMULTBUF ERROR: Failed to turn direct i/o on for database device

five TEXT columns after upgraded from ASE 15 32-bit to ASE 15.7 64-bit.

Need environment variable SYBASE_MAX_MULTIPATHS to override number of paths iterated which should be set to 1 if PowerPath is enabled.

with a stack trace which includes the modules 'ra_init_rs' and 'ra__connect_server'

may be reported in the error log when the Rep Agent Thread attempts to open a new

connection to the Replication Server and a previous connection attempt has failed.

the step weights of a domain in a column's histogram to be less than 99%. Optdiag input

of these statistics will fail.

This can happen when there are a large number (non-default) number of steps in the histogram.

You may need to reconfigure the parameter 'replication agent memory size'

with more memory.", followed by a 9219 error, "RepAgent(<dbid>): Internal

coding error. Rep Agent Thread for database '<name>' (dbid = <value>) terminated

abnormally with error. (major 92, minor 19)" maybe be reported in the error log

if the Rep Agent Thread is recycled many times and compressed data is replicated.

database with ALTER DATABASE command.

when executing the query with distinct and/or with WHERE IN long list of values.

"Error: 839, Severity: 21, State: 1, Grabbed buffer dirty but not writing:..."

the module init__data_vs_strategy() may be reported when running REORG REBUILD following which a DROP TABLE is executed.

if the parameter for the ASE service (-S) is set to a name which does not exist

in the interfaces file the following error will be displayed in the webservice.log file:-

2013-01-04 14:49:32.561 FATAL [main] - IllegalArgumentException error has occurred: java.lang.NumberFormatException: null

And Web Services will fail to start.

by default and document those changes.

in 15.7 ESD 3 and the current nightly build. The same dump loads without error

in 15.7 ESD 2. The error raised is "Label validation error: first label not VOL1." The "with compression = " method does not encounter this problem.

If a tape device is specified, backupserver will raise the error "Volume validation error: failed to obtain device information"

database <dbname>, object <objname>, index <idxname>, partition <ptnname>" followed by a stack trace involving the module indinsert() may be reported when inserting and deleting duplicate key rows in the clustered index partition for All Pages Locked table numerous times.

Encountered invalid logical page '0' while accessing database 'tdb1' (4), object

'sysdams' (58), index 'sysdams' (0), partition 'sysdams_58' (58).

the modules d_deleteplan() and proc_plan_get() may be reported in the SAP ASE errorlog when executing DBCC DELETEPLAN.

The message needs enhancement to prompt user to verify Backup Server version compatibility with ASE.

changes associated with optcriteria cr669847 are enabled by default, but previous behavior (i.e. turn on fix only if optcriteria cr669847 is on) can be obtained by using trace flag 16987

set deferred_compilation {on | off}

1. Logical devices such as the one created by sp_dumpdevice are shown in the Database Devices view.

2. Archive database is displayed in the User Databases view for SDC server.

"Execution of rule check_jsc_state failed because of errors parsing the source text in syscomments during upgrade. Please drop and recreate dbo.check_jsc_state"

Abort or rollback of the transaction may happen because of some internal / external error.

Error: 1265, Severity: 20, State: 1

An illegal attempt was made to release an invalid lock or a lock that is not owned by the process family.

infected with 11 in sqt_deallocate().

the module ptn_get_aphintpage() may be reported when executing a CREATE INDEX or REORG REBUILD command.

whose source text is stored in syscomments.

If the conditions are non-standard dateformat, then when these conditions are re-created

from text under a different dateformat. (which will happen after upgrade or via

upgrade_object) it is possible for a 247 error to be raised and a stack trace to appear in

the error log in function name s__recrtPtncond(), the session will be terminated.

then running the command:-

set deferred_name_resolution off

from a session will not function and it will behave as if it were still enabled.

the module VTABRemoteAccess() may be raised when accessing a proxy table materialized at procedure whose name starts with a '$'.