2087861 - Targeted CR List for ASE 15.0.3 ESD#3 | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2087861 - Targeted CR List for ASE 15.0.3 ESD#3

Symptom

The purpose of this KBA is to help SAP customers obtain a general idea of potential fixed situations in future Adaptive Server Enterprise (ASE) EBF/SP or PL releases. Please be sure to read the Disclaimer below.

If the EBF/SP has been released, check the CR list and coverletter at the service.sap.com.

Disclaimer: This document lists the targeted (not committed) release dates and the targeted fixed CR list for each release. Please be aware that the purpose of this posting is solely to provide you, our customers with estimated release dates and targeted CR lists. SAP does not commit to releasing on the specified dates or to including the CR fixes in the said release. While every effort will be made to meet the said targets, changes can occur at any time. It is also possible (although unlikely) that SAP may decide not to release an EBF/SP that was previously scheduled for release.

 

CR number

Description

367477

New Feature: User-defined default execution attributes.

374892

When User create record session without enable "sybase_script", Recording into ASE database not working.

394542

Dump / Load command having archive device name with newline character does not get parsed appropriately and causes segmentation fault in sybmultbuf.

429009

Occasionally on a multi-engine system, sp_monitorconfig "Active procedure cache" values might be higher than configuration value

461451

change the description for the IndexID column in monCachedObjects table.

469817

DDLGen: DDLGen incorrectly generates foreign key contraints for tables that do not have any if the tables have a object_ids that match referencing tables in other databases.

470655

To remove the message of 'per object statistics active' configuration parameter required for monProcessActivity table.

475139

allow concurrent access to the table while doing Reorg Rebuild or creating clustered index

497292

ALTER DATABASE might take an uneccessarily long time to complete the extension of a large database when the database has been extended over a boundary that is a multiple of 63 GB.

497750

Newly added audit options are not removed when downgrading from 15.0.2 to 15.0.1.

499982

The message, "Current process infected with signal 11 (SIGSEGV)", may be reported in the errorlog together with a stacktrace which involves the modules '_StTcCharacterSample' and 'StTcMrgBnds' when executing a SELECT query with an IN list on encrypted columns.

500474

In rare circumstances, Adaptive Server may give a time slice error with a stack trace which contains modules 'cm__check_page_range' or 'cm_choose_buffer_pool'.

529026

During instance startup, a set of three messages is logged, if a secondary interconnect is not defined for the cluster. Messages are: "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", and "Cannot resolve host name '' for the remote interface of the link to monitor".

530473

Under rare circumstances, dbcc checkalloc might report a 2525 error: "Table Corrupt: Object id wrong" with "objid in ext=0" following an ONLINE DATABASE after loading two or more transaction logs.

531631

In rare circumstances, datatype field in c6 column in sysstatistics FMT_COLUMN formatid row might be corrupted during upgrade during online database after the database is loaded across platform where byte-order is different, if the table has more than 255 columns.

531785

Add option to remove server entry after disconnecting from ASE.

532777

sp_configure may encounter error message 10840 with error message, "Internal error, FDP API, fdp_get_memory(): Failed to allocate 2097061 bytes.", in the errorlog.

540665

Query performance may be affected on queries involving private temp tables for which optimizations are based on some magic numbers when statistics are not explicitly updated on the tables. An option is provided to implicitly generate statistics for private temp tables. The statistics are kept in memory until the temp table is dropped. Traceflag 2716 is used to turn on this option. Note that external tools such as optdiag and sp_modifystats will not affect the in-memory statistics. The feature does not support regular, partitioned and proxy tables, as well as optdiag output, compatibility mode and DDLs in stored procedures when deferred compilation is turned off.

541233

In rare circumstances, a 834 error, "Illegal attempt to clean buffer" together with a stack trace which includes modules 'dbt_unreserve()' and 'cm_dbclean()' may be reported in the error log when dropping a suspect database.

544498

diagserver could run into assertion fail when 'enable stmt cache monitoring' enabled.

545416

Occasionally, when ASE write the logfile to dumpfile,"Error: I/O error, errno: 5 "may be reported in the errlog.

547118

A new builtin function is_singleusermode is created to determine if server is in single-user mode. sp_downgrade will force the server to be in single-user mode before downgrade is performed.

548235

When you run dump database command on ASE of sjis and Backup Server of eucjis, Backup Server outputs some Open Client/Server errors below and dump database command does not respond. Open Server Error: 16368.10.0.0 srv_senddone(): A message was initialized, but not completed

549423

If the PCI subsystem fails to startup then stack traces may be seen preventing ASE from booting.

551094

Attempting to retrieve data inserted using a deferred INSERT command for a table created with the "ignore_dup_key" clause and having TEXT columns may fail with a fatal 7114 error reading "Page < Page Number > is not a valid text page." together with a stack trace showing modules "sendtext" and "get_txtpage".

552026

Monitor Historical Server process memory usage keeps growing while recording a session.

552227

ASE does not check if the type of the supplied default value matches the type of the column at user table creation time.

552508

A new column "Transactions" has been added to the monState table

553163

dbcc stackused reports the wrong maximum amount of stack memory used on Itanium platforms.

553866

If built-in function like data_pages(), which accesses OAM pages is called on a table in temporary database while the table is being dropped error 677 may be raised.

554404

Incorrect information is displayed under "data cache managementt" section of sysmon report.

556134

The index checking of DBCC CHECKTABLE doesn't check the first row of every non-leaf page, so it can't check out the corrupt index if someone of first keys is bad.

556770

A 10334 error, "Permission related internal error was encountered. Unable to continue execution." may be reported in errorlog while running the DBCC CACHEDATAREMOVE command.

557592

Replicating data into an encrypted column that is bound to a domain rule fails with error 225. The same failure can occur when inserting data through bcp using the -C flag.

557939

Executing a query involving views and coalesce() may get error 4409 incorrectly.

560359

When using builtin function object_owner_id(), if the object name is longer than 30 bytes, the builtin could return wrong owner id for the object.

560776

PC Client 1503 ESD#1 Installer log.txt file show error message

560954

Feature request for a dbcc command to fix 100004 checkstorage faults (timestamp value in page header larger than database timestamp).

561626

A 8242 error "The table < table_name > in database < dbname > is bound to metadata cache ..." maybe raised when doing delete operation on a DOL table that is bound as hot object using DBCC TUNE 'des_bind' command.

561660

CREATE EXISTING TABLE command against MSSQL backend results in Msg 11213 if the remote column is defined with a DEFAULT clause. In the same situation, CREATE PROXY_TABLE fails silently and does not return any error.

561673

The builtin function valid_name() could cause stacktrace if NULL is passed as the second parameter.

561876

Sometimes, ASE terminates connection to the client after error 603, "not enough system session descriptors available" occurs.

562468

Incorrect referential interity (RI) check could happen for update/delete when there is mixed datatype equijoin between the RI column and another column. The similar mixed datatype equijoin under a view could also lead to wrong result when the view is joined to itself and has to be materialized into a worktable first.

562556

When upgrading the server which is booted with single user mode, upgrade utility was not able to perform. It required 4 connections to finish the upgrade work. And it can finish the work with only one connection.

562635

sp_dbcc_summaryreport is expanded to support the exclusion of faults registered in the dbcc_exclusions table like sp_dbcc_faultreport does.

562947

When a cursor is implicitly updatable, i.e. does not have a FOR UPDATE clause or a FOR READONLY clause, and at least one index is available, then a table scan will not be considered. This change will allow a table scan to be considered if there are no unique indices available. The change was placed under optcriteria cr562947 and will be on by default for 15.0.3 ESD #2.

563378

preupgrade utility should identify stored procedures that use depreciated function calls such as reserved_pgs().

564439

The message reported in the ASE server log when the sybpcidb database does not exist has been improved and now contains more information. The new message suggests that the sybpcidb database may be missing, or it may need to be initialized with the installpcidb script.

565273

signal 11 could happen in ResRelOp() during codegen when a constant expression from a view or derived table is SELECTed from an outer join view inner side and the constant expression is further participating in a simple WHERE clause (comparison involving other constant only) when the outerjoin view is queried.

565276

Under compatibility mode, traceflag 302 diagnostics might output "unnamed-col" for predicate printing instead of the real column name.

565484

Using a large value for 'max memory' and setting 'allocate max shared memory'=1 may cause the shared memory dump size to be much bigger than expected against SYBMON.

565752

Add ability to kill process querying syslocks table.

565877

Message 14623 doesn't provide enough info for users to perform corresponding operations to continue downgrade. It should provide more infomation like which objid and indid the row has.

566882

Modifying a segment's auto expansion attributes (grow-by or max-size) results a syntax error.

566981

Signal 11 in GtuUnion::GtSecondaryInit() may be seen in the error log and the spid terminated when selecting from a view containing a union all and the select includes > 1 variable assigment from the same column.

566990

sp_object_stats "00:01:00" does not produce output in version 15.0.x even if you have contention.

567239

Due to an issue with underlying dbcc checktable, sp_post_xpload can not detect all kind of index corruption, such as first key of one non-leaf page is bad. The new 'force' option of sp_post_xpload will force rebuild all the index except APL clustered index.

567355

ddlgen generates a redundant "go" between the two ENDs for dropping the primarykey and foreignkey

567466

If statement cache is turned on and exception is occur in compiling a statement with temporary tables in it, it could raise 8203 error sometimes.

567656

Monitor server hung on ibmplinux redhat 5.1 platform.

567766

RepAgent may send an incomplete multi-byte character in text data to Replication Server when the text data is longer than 4KB and starts with an XML declaration element and contains multi-byte characters.

567787

When statement cache and literal autoparam are enabled, a batch that contains \r\n (CR NL) sequence in the middle of two statements, the statement that right after \r\n sequence may not get correctly parameterized, offset may be shifted 2 bytes on the left.

567885

Fully qualified ASE table name in query causes exception in using DBISQL's Query Editor.

568659

Under rare conditions a query on the monOpenObjectActivity MDA table may result in a timeslice error.

568798

Under some circumstances, a signal 4 may be raised while calling ex_raise and ex_print.

568957

"ct_fetch(): protocol specific layer: external error: There is a tds protocol error. An illegal token was received" may result when accessing data containing null bytes on an ASE server when character set conversion using Unilib is employed.

569171

A stack trace in the function, setGlobalIdentity, may be generated when an INSERT query is run and this query inserts into a proxy table that is created on a remote view and the remote view is created on a table that contains an identity column and the datatype of the identity column is not NUMERIC (i.e. it could be integer or smallint) and the remote view has an instead-of trigger for insert and the instead-of trigger contains a query that selects the identity column from the inserted pseudo table.

569523

If the interfaces file does not exist or contains no server entries, opening 'Job Scheduler Server' page of Server Properties results an NullPointerException.

569541

AFter changing the name of the table with sp_rename triggers defined on the table may no longer working.

569567

Allow UPDATE STATISTICS to be performed in a multi-statement transaction. Update statistics changes will become part of the transaction, and and all the work done by update statistics will be removed by any rollback. If a multi-statement transaction does not exist, then update statistics will continue to use internal transactions to commit multiple minimal atomic parts of the update statistics command which will remain even if the command is aborted. Trace flag 2720 can be used to continue with the pre-fix behaviour, in which case an attempt to run this command in a multi-statement transaction is disallowed with an error message.

569724

Update ASE startup reporting to recognise Windows Vista and Server 2008

569742

Logins folder's Full Name column was mistakenly removed.

569804

Logging SQL when an instance is shut down gets a NullPointerException.

569904

In rare circumstances, Job Scheduler might fail to run with the error "Incorrect syntax near '`'".

569940

Truncate table is not consistent when switching tables under 'suspend audit when device full=0'

569947

SELECT INTO using ISNULL builtin in the SELECT list could lead to target table column non-nullable while the early behavior of ASE would make the target table column nullable even when the ISNULL result can't be null for the query.

569969

Update DBISQL from version 11.0.0 to 11.0.1.

570117

Deleting a table with LOB columns (text, image, unitext) and non-datarows locking scheme under direct mode may hit SIGSEGV together with stack trace in the module of LeDeleteOp::_LeOpNext() if the query plan has merge joins.

570136

Restore the old behavior in ASE125 to use parallel sort while creating index on more than one output devices.

570307

Deferred compilation may cause unexpected parse errors when setting quoted_identifier on\off within a procedure defintion. (Error 102, 257 etc)

570345

Sybmon planprint could cause stacktrace.

570457

Stacktrace could happen during GroupInsert operator execution under compatibility mode for GroupBy query with a lot of aggregates.

570794

Execution of a stored procedure which creates a table with non-materialized computed column may sometimes result in a message "current process infected with 11" and the stack trace reported in the errlrog file if the procedure performs SELECT query on this table. This is likely to happen if a procedure query tree is renormalized. Stack trace may reference modules pre__replace_cpc and s_getTreeOrPlan.

570901

ASE 15.0.3, esd#1 HKGC, Error 12316 occurs repeatedly

570910

The message "storage access violation" in various XML related modules together with a stack trace which includes XML related built-in modules may be reported in the error log after an error 712 raised from a previous XML query involving a large XML document.

570931

On rare occasions a 605 error may be reported when BCP and UPDATE INDEX STATISTICS with sampling are concurrently executed on the same Data Only Locked table that has at least one non-clustered index present.

570986

GUI: while selecting a license key file, the default directory is empty if user specify an installation destination that does not exist.

571049

On HPPA64 and HPIA64 platforms, if Java in Database feature is enabled in High Availability system, during failback operation, "sp_companion resume" operation on the primary causes the secondary companion either to hang or die due to an internal error if PCI/JVM is active on the secondary companion. In the event of a hang, the system 'ps' command will show an extra server process running. That is, in a two engine system 'ps' would show three server processes rather than the expected two. If the error results in dead engine on the secondary companion, the error log will contain messages indicating the engine hosting the JVM has exited with a signal 11.

571072

Create Table or Alter Table with Case statement that uses an IN list or NOT column NOT IN list or the equivalent of those expressions in a computed column will cause stacktrace.

571615

SQL which concatenates at least two contiguous NULLs with strings may cause error 257. For example, select NULL + NULL + 'abc'.

571645

The message "current process infected with 11" in the module 's_free' with a stack trace which includes the modules 'kill_proc', 'metrics_dump' and 's_recompile' may be reported in the error log after killing a session that was executing a stored procedure which had to be recompiled and it was hang because transaction log was almost full and the configuration option "enable metrics capture" was set to 1.

571772

On linux platforms with jmp_buffer mangling, engine dies abruptly with the message "Engine exited with signal 11".

571924

Executing a query with compute clause may hit SIGSEGV together with stack trace in the modules of subparserr() and parserr2().

572133

Under some rare circumstance when ASE is unable to allocate memory for query execution the usual message for error 701 " There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure ASE with more procedure cache." is accompanied by the stack trace in the errorlog file. The stack trace will indicate modules LePlanRelease and LeParentOp::LeOpProcessIOStats. The issue will happen if options to display statistics were activated.

572163

Request new Backup Server verbosity level to disable "Connection from Server" messages.

572188

Drop in sp_addlogin and sp_role grant/revoke performance after an upgrade from ASE 12.5.3 to 15.0.3 ESD#1 on a ASE HA cluster.

572577

When the Properties button on Threshold page of Segment Properties dialog is clicked, an internal error occurs.

572796

Sp_addexternlogin does not work when the target server password has special characters e.g. "=". This can cause the sybmigrate process fail with an error like "Incorrect syntax near '

572959

Compiler Optimizations that rearrange code blocks will lead to (-)ve Keep count in the Partition descriptor.

572977

Run sybmon command "set" without arguments caused SIGSEGV.

573341

Index counters may not be updated in monOpenObjectActivity for a table

573619

On AIX when Sybase Central 6.0.0 encounters an internal error, an internal error message about missing libjysblib600_r.a is shown instead of the regular error dialog.

573639

The message "current process infected with 11" in the module 'memcpy' together with a stack trace which includes the modules 'LeRun' and 'LeJoinContext::computeVirtualCols' may be reported in the error log if a SELECT UNION ALL query is executed involving an outer join, a TEXT column from the inner table is selected and some NULL values are returned.

573897

WaitEventID(which is larger than 251) in monProcess is incorrect.

573933

Deletes over CIS to IQ may fail with error 11298. The 'DELETE' command contains syntax that requires it to use a cursor but ASE has disabled the support of updateable cursors against IQ.

574227

If the master database has a secondary truncation point set during an upgrade from 12.5.x to 15.0.x, then an error 950 (Database 'master' is currently offline. Please wait and try your command again later) may be raised. To avoid this issue, preupgrade or upgrade will report an error if there is a secondary truncation point set.

574264

In rare circumstances, the message "Current process (...) infected with signal 11(SIGSEGV)" together with modules like (bool PopEmit < SerialCost,SerialProps > ::emitMatchProperties, PopBase*OptGlobal::_GblAddTopLevel maybe be encountered for queries involving statement cache, literal autoparameterization, compatibility mode and OR terms.

574532

Permission denied error is being given on SET_APPCONTEXT when executing a proc.

574533

Sometimes users will see error message "JZ0R1: Result set is IDLE as you are not currently accessing a row." when accessing a ASE 12.5.x database

574724

Duplicate rows could be incorrectly returned when an EXISTS subquery is SELECTing from a DISTINCT view and not all of the view's SELECT columns are participating in the subquery's correlated equijoin predicates.

574771

A query having concatenated columns in GROUP BY clause may return the incorrect result if all the set of GROUP BY columns are unique to the result set.

575064

Procedural queries with optimizable LIKE clause may underperform executing more logical IOs than expected.

575080

DDLGen doesn't hide password when a space is supplied before the password.

575115

If there is a mismatch between the datatypes of the constants in the IN/OR list and the respective column, special OR strategy might not be used. ASE now provides a optcriteria 'use_mixed_dt_sarg_under_specialor' which when enabled, will allow special OR strategy to be considered in case of mixed datatype SARGs in the IN/OR list. Additionally, traceflag 434 has been provided to turn OFF this feature. The traceflag setting overrides the optcriteria setting.

575151

An infected with 11 error is raised with function LeUpdateOp::_LeOpNext on the stack when the tsequal function is passed a datatype other than timestamp.

575251

Wrong result may happen for a query if the SELECT list has an extended column which is not included in the GROUP BY clause and one of the group by columns has a constant sarg (col= < cnst > ) on it. Similar wrong result could also happen for an equijoin between a GROUP BY view/derived table and other table when there is a constant sarg in the view for the joining column.

575330

ASE stacktraces with signal 11 when the number of columns returned from a remote procedure is less than expected from the select list to a proxy table mapped to this remote procedure.

575337

Msg 7305: after execute select ... for update in a stored proc

575359

ASE assumes DC supports BIGINT datatype and incorrectly sends signed/unsigned NULL integer parameters as BIGINT datatype.

575392

Insert queries involving proxy tables which are either part of a trigger or will fire a remote trigger may crash at signal 11.

575675

Server always selects Slow Bulk mode for bulk copying rows into table with non-clustered unique index.

575946

The database option "no ckpt on recovery" is incorrectly turned on after load database command on master database successfully completes.

575993

Connect Dialog would not allow modified server entry if it's previously connected to the server before modification.

576295

There is possibility of segmentation fault during XPDL conversion of a page whose page header is incorrect with PG_DATA and PG_OFFSET bits set simultaneously.

576357

If a parallel plan is chosen for an AMC repartition operation, sometimes the data could be inserted into the wrong partitions.

576525

Database Wizard's (Add) Device Size Dialog does not sort device sizes correctly.

576647

If error 249 occurs during and it does not appear to be due to constant in the query and the query has not started execution i.e. compilation is still proceeding, then this error may occur due to expression histogram processing. This can be verified by looking at the optdiag output for the columns in the query, and determining if there is a possible conversion error that could occur with one of the histogram step values. The change in behavior will be to suppress the error and use magic numbers for the selectivity of that column when used in expression histogramming.

576708

Inserting a NULL value into a TEXT column of a proxy table with an INSTEAD OF TRIGGER may result in an assertion failure involving the module eval_locator_bi().

576895

INSERT into a VIEW which triggers an INSERT into the proxy table may cause error 3651 when the remote table also triggers a change in one of the column values being inserted.

577113

It's possible of deadlock on sysconfigures table if running two sp_configure at the same time.

577504

On NT platform, Monitor server didn't shut itself down when ASE is down

577525

When ddlgen is used to extract the DDL for an object, that contains a user defined datatype which has a default bound to the type, the DDL generated contains an extra sp_binddefault command that fails because the default already exists.

577680

ins_syn_sql incorrectly calculates free space on the default disk

577686

If two indexes on different tables have the same name and if output from DDLGen is generated just for indexes, then an attempt to run this generated output fails if the indexes have been deleted in the server after the DDlGen was first run for the indexes.

577711

Unable to connect to ASE using the reserved administrative connection when network password encryption (-X) is enabled.

577713

Sometimes, the message "current process infected with 11" in the module 's_handle' is reported in the error log along with errors 2601 and 546 while trying to insert into a table with foreign key constraints.

578157

Some stored procedures using temporary tables and trace 299 (forced open by name resolution) may result in stack trace. This happens if a procedure is frequently renormalized. Stack trace shows module lastleft.

578424

The message "current process infected with 11" may be reported in the error log together with a stack trace which includes the modules 'Optimize' and 's_compile' when executing an UPDATE statement involving a join between two or more tables and the table being updated has defined a functional index involving columns which are being updated with values from columns from the other table(s) participating in the join.

578662

If forceplan is used to force the use of a vhash index to scan the table in a join, a SIGSEGV or incorrect result can occur.

578692

when outer joins have inner tables which are derived tables with UNION operators then there is a possibility of a stack trace.

578874

Under rare circumstances ASE fails to compile statements in the deferred compilation mode.

578889

After ASE detects a 605 error on a DOL index, ASE does not report the 605 error again on the same wrong page until ASE restarts.

578991

There is a possibility that during bcp operation, some rows get corrupted as received from the network. But they safely make it into the database and corrupt the data pages and eventually corrupt the database.

579040

Segmentation violation occurs under stress conditions in artificial environment not seen with normal replication environment.

579044

ASE Plug-in and DBISQL's Connect Dialog encounters a syntax error setting a new password when the old password contains special characters.

579240

An error 209 with the message "Ambiguous column name" may appear if a stored procedure which performs the UPDATE or DELETE with the selfjoin is executed by the non owner of a procedure and the execution is performed using the deferred compilation mechanism.

579241

Under some rare circumstance related to the runtime recompilation of the parallel queries using expression involving LIKE and variables or parameters ASE may fail to generate parallel plan and report stack traces in the errorlog file. A trace will show modules copy__eval and copy__eoptlike.

579586

Query on monSysStatement table causes timeslice error with large statement pipe.

579962

Full index scans may be selected over limiting index scans in scenarios where there is a single or no rows in the table and the costings are the same for both indices. An index scan is "limiting" when the key's major attribute has a sarg on it. The full-index scan may be selected if it has a minor optimizable attribute and it's ID is less than that of the limiting index. IDs increase in the order of index creation. Full-index scan strategies were never considerend in pre-15.0. Setting the configuration parameter "mnc_full_index_filter" to 3 or enabling the optcriteria full_index_filter will eliminate full-index-scan strategies.

580042

sp_dbcc_configreport will report arithmetic overflow error for databases larger than 2.5TB.

580098

Select data from monOpenObjectActivity could cause timeslice when heavy load.

580264

XML- > sqlj functionality can regress if sequence of COTS JavaVM is out of order wrt conversion results.

580552

Under very exceptional circumstances a timeslice followed by ungraceful shutdown of the server due to the LDAP_SPIN spinlock being held may be seen involving the housekeeper whilst checking ldap configuration.

581043

Queries from complex views may return no results at all. Running with the diagserver executable shows an assertion failure in res_view.c: "unprocessed view found"

581347

Histserver memory usage keeps growing.

581380

Null clause is unnecessarily appended to the ALTER TABLE MODIFY command when it is not explicitly specified in the command statement, resulting in an Oracle ORA-01442 error. This issue is specific only for Oracle and a traceflag 11237 is used to enable this fix.

581422

Recompilation of stored procedures reporting TABMISSING\TEMPMISSING may be seen on case-insensitive servers under traceflag 299 if column names are not consistently specified as upper or lower case in the temp table definition between executions and table re-creation.

581724

During worktable creation, if we fail to access the tempdb, it may lead to sig-11

581748

After a dumped ase1254 database was loaded into an ase1503 server, if the database includes tables with encrypted columns which reference keys in other databases, onlining the database will cause a stack trace. The data is brought online and can be used.

581827

If literal autoparam is turn on, in some rare cases, isnull() builtin function could return different result comparing when literal autoparam is turned off if the parameters in the isnull() is either CHAR or VARCHAR datatype.

581984

In some cases, dbcc checkstorage may incorrectly report the soft error "100041 (Log free space discrepancy error): Current syslogs free space does not match what dbcc counted.".

582000

Reorg rebuild / create index on a table with a CI resets systabstats.datarowsize to initial default of average row length.

582171

In some queries involving distinct and temp tables, if we have "capture missing statistics" config turned on we might get a stack trace with error "closetable: called with null SDES".

582178

Selecting "Tools"- > "Adaptive Server Enterprise"- > "Preferences" results a NullPointerException when ASE Plug-in is running on a system with Spanish locale.

582344

Timeslice and stack trace contaning LeOperator*CgpNlJoin::cgpCodeGenTryNaryNLJ amongst others may be seen under rare circumstances when executing a query involving group by and aggregation.

582855

ASE errorlog contains "TPM FATAL 'unknown TPM error-level raised' for Task xxx in ThreadID yyy"

583896

Create Proxy Table Wizard sometimes gets ArrayIndexOutOfBoundsException after clicking Finish.

583910

If the either of the optcriterias mnc_full_index_filter or full_index_filter is enabled, then explicitly updateable cursors (declare statement contains and update-clause) and dirty reads on APL tables could lead to a 311 error: open mycursor Msg 311, Level 16, State 2: Line 2: The optimizer could not find a unique index which it could use to scan table 'mytab' for cursor 'mycursor'.

584139

The dump command does not raise error message for "No space left on device" on Linux when the device is closed.

584149

Simultaneous load operation with same archive device name fails with 'Device already in use' error.

584292

Statements that use the application context builtins such as set_appcontext() while the statement cache is enabled may result in Error 4060.

584296

sp_displayaudit with "login" option fails with 18004 error on 15.0.x

584298

BY default, dbcc checkalloc( < dbname > ) turns on traceflag 3605 with SERVERWIDE scope. This can cause other processes in the ASE to unexpectedly write messages to the errorlog while the checkalloc is running.

584342

ASE may crash with Signal 11 at CtlibRemoteCaps::generateConstant when it runs out of memory.

584467

During execution, if "run script" options is selected for Fix Statistics or QPTune Wizard, a stack trace occurs preventing the execution to finish.

584552

If an insert parameterized language request with certain Numeric values is sent to the dataserver and statement caching is enabled then a segv occurs. A regular statement is fine with the same values.

584770

For srvbuild, the default available physical memory value of OOB task is shown as 80% of RAM even if this value is larger than the "max shared memory" set on the operating system.

584851

If a query involves an extended column (a GROUP BY column which does not appear in the select list) and if the select list includes an encrypted column, the execution of the query will hit a stack trace reporting a null encryption key. An exemplary query is: table t2 (a2 int, b2 int encrypt with key1) select t2.* from t1, t2 where t1.a1 = t2.a2 group by t1.a1

585079

When an instead-of trigger contains a query that accesses the inserted or deleted log tables and the schema counts of the view upon which the instead-of trigger is created and the log (syslogs) do not match, a 11060 error may be raised, resulting from too many (10) attempts to recompile the query plan without succeeding.

585168

Performance issue might be hit for a query with up to 5 joining tables involving cartesian products and/or theta-only joins.

585260

Unnecessary recompilations may happen if 'open by name' trace flag 299 is activated and a temporary table has at least one BIT column.

585467

Despite traceflag 11906 being on, reorg rebuild messages are reported to the errorlog.

585517

When a user with sa_role executes SETUSER to a non-sa_role user, creates a table and a procedure referring to that table, then execution of that procedure following a schema change such as dropping and recreating the table will result in an "object not found" error (Msg 208).

585665

Feed back optimization opened exception code shortcomings under the PCI Bridge (COTS JavaVM Integration) under AMD64 platform architectures. These code shortcomings are very severe and easily lead towards memory corruption when JDBC or Java Stream operations are invoked from ASE Tasks.

585991

Set switch command does not work with traceflag 7714 ad 7715.

586167

Automatic workspace expansion in checkstorage does not expand the text workspace automatically even though the text workspace is smaller than the recommended size, which is 25% the size of the scan workspace.

586220

The error msg 414 could be raised if the plan chose reformatting strategy and it has many join predicates.

586356

For queries containing IN/OR list s.t. one or more elements in the IN/OR list is a function then unexpected results might be returned.

586425

When running on a Unix system, BCP Wizard cannot BCP in/out multiple tables.

586565

Dump / Load operation failing to open the device may not report the Operating System error.

586779

The dump command may not raise an error message reporting "No space left on device" on Linux when the device is closed using Backup API compress.

587437

When using parallel sort on worktable, several issues were encountered while executing sort operator.

588464

Sometimes, database upgrade fails with error 1204, "out of lock error" while upgrading a system table with huge number of rows.

588594

When the optimizer chooses a query plan that includes and Nary-Nested-Loop Join Operator (as seen in showplan output) and at least one of the Scan Operators under the Join is doing dynamic partition elimination (also shown in showplan), the query may return too few rows. This problem ocurrs in queries with at least three tables and which contain join predicates involving columns of the partitioned table that are not part of the partition condition of that table.

588703

Some of the qualifying rows could be missed by an UPDATE statement using at least 2 tables other than the updated table (either directly in the UPDATE statement's FROM clause or within EXISTS/IN subqueries) and the join of these 2 tables involves an expression which contains one of these tables' columns which is also in the UPDATE's SET clause to compute the new values.

589061

TEXTPTR() builtin function may sometimes return truncated result. Pending zeros are removed.

589473

When parallelism is involved, some queries having more than 6 tables may timeout earlier during plan enumeration resulting in merge joins plan that uses excessive tempdb space.

589657

With SQL Replication enabled queries with CASE constant expression that is expression which is not referencing table columns may fail with error 401 "Invalid operator for datatype op: = type: MAINTENANCE TOKEN" or error 551 "An unknown EVAL was sent to the execution module."

589674

Sending a Java object using Java/JDBC on the client-side can result in a corrupted object stream being stored in a database table.

590395

The JVM dies with error 143 when the user logs off from Windows OS running ASE.

590604

When the view is redefined during the deferred compilation the ASE may fail during the redefinition process. Stack trace will be logged in the errorlog referencing modules like vu_redefine, col_open_range.

590760

A transaction dump that has a DROP and CREATE index commands logged for a clustered index with sorted_data, max_rows_per_page and fillfactor options used, may result after load in a corrupted table where errors 692, 605, 2509, and 2525 could be reported.

591217

The ASE server could potentially dump core in final stages of a server shutdown under the condition of stale PCI Bridge arranged JavaVM activities. This error is not a dangerous or worrisome event but the core files as left are ugly and consume lots of file system space.

592022

The message "timeslice - < number > , current process infected" together with a stack trace which includes the modules "dbts_insert", 'dbts_commits_addxdes', 'xls_test_set_lrdata' and 'ha_session_dealloc' may be reported in the error log when CHAINED transactions are used in and HA environment.

592026

Introduce configurable control for allowing or disallowing loading native libraries from within the PCA/JVM using the load and loadLibrary methods in the java.lang.System and java.lang.Runtime classes.

592603

When compatibility mode is enabled and a stored procedure is executed, ASE may stacktrace in the function ind__itagsetup(). This happens if a query in a stored procedure refers to a table that is created and dropped inside the stored procedure and that stored procedure happens to recompile after the table has been dropped.

592605

ASE may report 3474 and 3478 fatal errors if bulk-insert ctlib application making use of multi databases transaction needs to rollback.

592737

After CR 531964 changes, sysprocesses.physical_io maps to piotot which is only incremented at the end of each statement because of which monProcessActivity had to be used for tracking i/o activity for running query. The physical_io should report pbufread\pbufwrite which are incremented as each i/o completes.

593117

Unexpected errors may happen as a side effect of the compilation of SELECT INTO #TABLE statament. Errorlog will report module s_normalize. Also under some very rare circumstances on a heavy load systems a risk of random memory corruptions exists.

593582

In rare circumstances when using 'SET ROWCOUNT' option or 'TOP' directive with 'SELECT INTO' executed in the parallel mode the rows may fail to be inserted.

594204

When dboption "dbo use only" is set, the database owner executing sp_adduser may result in an access error (Msg 923).

595825

Duplicate rows may be inserted into a table that has a non-unique clustered index and that has one or more BIT columns even though the option, allow_dup_row is not set. For duplicate rows to be inserted, the total number of BIT columns in a row must not be an exact multiple of the number of BITs that can be stored in a BYTE (8) - this is a necesary, but not sufficient condition.

595988

If $SYBASE starts with /net, srvbuild[res], sqlloc[res], and sqlupgrade[res] report error: unable to load localization file < path > .

605811

After the command 'set proxy' is executed, RepAgent still sends the original login for replicated transactions instead of the new impersonated login. As a consequence, when replicating DDL commands, objects might be created with a different owner at the replicate site.

607467

In some rare situation, if a plan has groupinsert operator, it could raise 613 error.

616224

Like pattern matching may return fewer rows when the following conditions are met: 1. server's default sortorder is non-binary single-byte sortorder 2. like pattern is a constant literal 3. like pattern string length is the same as column data length 4. column is either varchar or char


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.0.3 ESD #3
  • AIX 64bit
  • HP-UX on IA64 64bit
  • Linux on Power 64bit
  • Linux on x86 64 64bit
  • Solaris on Sparc 64bit
  • Solaris on x86 64 64bit
  • Windows on x64 64bit

Product

Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise Cluster Edition 15.0

Keywords

CR, ASE 15.0.3 ESD#3, ASE 15.0.3, ESD#3, ESD 3, Adaptive, Server, Enterprise, Fix, Patch, Error, Bug , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , BW-SYS-DB-SYB , BW on Sybase ASE Database Platform , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.