Status: Unverified
GOAL:
Bug fixes contained within Progress 9.1D/3.1D Service Pack 9
FACT(s) (Environment):
Progress 9.1D
WebSpeed 3.1D
IBM AIX
FIX:
IBM AIX PROGRESS Service Pack 9.1D09 and WebSpeed Service Pack 3.1D09Issue Number Product Component Description 20040318-012 4GL Layer Error 223 using automatic datatype
conversions for comparison operators.20040311-005 4GL Layer Ascyncronous Appserver call cause
Dynamics client session to crash.20040304-015 4GL Layer Use of XML/SAX and code page 1252 cause
random GPF "Access violation on ntdll!
RtlFreeHeap".20040304-013 4GL Layer Execution of (write) trigger is about
30% slower on 64-bit platforms.20040223-002 4GL Layer Session crashes with a system error:
bfval called for workfile <file-name>.
(680)20040213-012 4GL Layer If a record is added using the default
blank value for a unique key field and
the table has a database Write trigger,
the record may be incorrectly created
and causing index corruption. This can
lead to error 1422.20040119-032 4GL Layer . Printing fails when outputting to FILE:
printer port from a terminal services
client when using the page-size 0
option.20040116-020 4GL Layer Use of the combination keys ALT/F4 to
exit an application causes error 2659
and "omIdToArea called with 0
objectNumber" in the database log file.20040513-032 4GL-to-JMS SonicMQ requestReply procedure does not set
Adapter JMSReplyTo field when a MultiPart
message is passed to it.20040301-036 4GL-to-JMS SonicMQ The SonicMQ Adapter increases its memory
Adapter usage dramatically when adapter clients
try to connect to a SonicMQ broker which
is not online.20040223-022 4GL-to-JMS SonicMQ If the SonicMQ adapter is very busy the
Adapter 'adaptman' utility will return a status
of 'NULL'.20040205-042 4GL-to-JMS SonicMQ Sonic Adapter: Request/Reply with
Adapter temporary Queue could cause memory leak.20040407-025 Active X Issues Using the ENTER or Function keys do not
 .; trigger events inside the PinEdit OCX
Control.20040302-005 Active X Issues If you install a 9.1D service pack, you
may end up with an older version of
prox.dll being registered rather than
the newer one that was just installed.20021209-009 Active X Issues The csspin32.ocx and cscomb32.ocx
controls supplied with 9.1D are outdated
and can cause crashes when used on
Windows 2000 SP3 and later Windows
versions20040413-033 Admin Service The collection of statistics for Fathom
is turned on regardless of Fathom
version.20040309-044 Admin Service To address a problem with Fathom on
Solaris 64 leaking file descriptors. The
AdminServer that is hosting a
osmetrics.dll that is being used by
&nbs.p; Fathom for monitoring on Solaris 64 is
charged with the lost file descriptors.
The AdminServer use of file desciptors
increases over time until the
AdminServer fails.20040108-010 Application Server AppServer may GPF when using the MESSAGE
SKIP statement with a very long message.20040116-003 AppServer The -mc switch to turn on the
compression between client and appserver
may cause error: "Client server version
mismatch. Client 82. Server 82. (8112)"20031128-008 AppServer It appears that sending a STOP from the
client to the AppServer is not working
for session-free AppServer.20040430-023 Data Dictionary20040218-018 Database Agent Database with security enabled and with
large number of tables refuses to be
polled thru Fathom Management SE -
java.lang.OutOfMemoryError20040224-041 DB - block manager User will get the following message:
&.nbsp; "Invalid before image version number
found in bi file" if the bi file is
truncated using smaller bi block size.20040303-036 DB - database Unable to run mkchema against a database
utilities that has largefiles enabled.20040223-006 DB - database PeerDirect users with many-to-many
utilities worksets relations may experience index
corruption on the dependent foreign key
index20040213-025 DB - database In some cases, if idxbuild terminates
utilities abnormally, the new run shouldn't
rebuild all indexes . This could have a
positive performance impact.20040213-021 DB - database Idxcheck will use the wrong .xb file,
utilities causing errors in indexcheck.20040209-005 DB - database Ixcompact may allow other online
utilities utilities (including another ixompact)
to change the index under construction
because in some cases the lock strength
is too low.E>20040113-002 DB - database Under certain circumstances rfutil and
utilities protuil could hang on the database
managed by Fathom Replication.20011029-003 DB - database Give user a warning if a binary dump is
utilities using an inactive index.20040419-037 DB - index manager Error 8783 running idxfix after a clean
execution of proutil idxbuild. This
error happens only in the case of very
large tables where the number of keys in
the idxbuild sort file exceeds two
billion.20040305-017 DB - index manager Too many index blocks remain locked when
updating indexes.20030321-003 DB - index manager Index corruption (error 1422) can occur
if two processes simultaneously try to
create the same key within a unique
index.20020422-023 DB - lock manager Running batch jobs that run two or more
of the database online utilities that
lock access to indexes may cause an
&nbs.p; abnormal shutdown because of a failure
during lock release.20040219-001 DB - record services When the RDBMS server is started with
-H, the hostname specified is compared
to the actual hostname of the machine.
A fully qualified hostname, i.e.
'host.mylog.progress.com', must be
considered the same as 'host'.20040201-001 DB - recovery During the physical backout phase of
manager crash recovery, the location to begin to
backout transactions in the bi file may
be misidentified. The misidentification
can occur if a note spans a bi block.20031205-006 DB - recovery When a database crashes during logical
manager backout it is possible under some
circumstances to fail to be able to
complete crash recovery, resulting in a
5022 error.20040128-015 DB - semaphore Frequent self-serve database
. services connect/disconnect cycles cause
excessive system resources to be
consumed and never released.20031104-012 DB - semaphore Unlike previous behavior, the Progress
services database can no longer be started if you
receive the warning message "Warning:
only # wait semaphores available
(1093)". You will need to either lower
the -n startup parameter (number of
users), or regenerate the kernel with
larger SEMMNS (system wide max number of
semaphores) and SEMMSL (max number of
semaphores per id). This change
eliminates the possibilty of receiving a
"transaction table mismatch (10612)"
error.
20040109-001 DB - signal services Certain OS signals are not trapped but
interpreted as a SIGHUP, causin.g client
sessions to loose their connection to
the database.20040427-007 DB manager interface User names and passwords are sent in
clear text via TCP/IP which can present
a security issue.20040318-036 DB manager interface Service Names that begin with a number
were interpretted as being the actual
port number rather than the service name
and we tried to start the service on
that number. So the port number
associated with the service in the
Services file was not being used.20040429-011 Diagnostics Enhance messages to help identify a
problem in a database by listing both
the dbkey and tha area number that is
affected.20021106-013 Diagnostics If a dbanalys is performed on a specific
storage area which only has index
&nb.sp; information then a memory violation will
be generated on Unix.20040309-029 Dictionary Datasvr When pulling schema from Oracle or a
Bugs package, if a data type is unknown to
the DataServer it is not pulled. This
error may cause you to get duplicate
s_ttb_Fld record error messages.20040309-025 Dictionary Datasvr Unsupported data types errors during
Bugs Schema Pull are being overwritten within
the ds_upd.e file.20040217-037 ESQL 92 esql application link fails in 9.1D with
encryption symbols20040405-021 Graphical runtime findRowWhere fails to find record
rendering (ADM) outside current batch if qualified
column names are passed.20040123-018 Graphical runtime Parent-child SDO relationship breaks if
rendering (ADM) the SDOs are compiled with the "Qualify
Database Fields with a Database Name"
option turned on in AppBuilder and an
alias is created for the database before
&n.bsp; running the SDOs.20031210-008 Graphical runtime ttAction already exists message when
rendering (ADM) running toolbars where toolbarcustom has
been customized to add actions.20031020-049 Graphical runtime FindRowWhere will always retrieve data
rendering (ADM) from the server for SDOs that have a
joined query even if the requested
record already exists on the client and
doesn't need to be retrieved.20030630-006 Graphical runtime viewObject in container.p sets
rendering (ADM) window-state to window-normal for
minimized windows, making it impossible
to minimize windows before super in
initializeObject override.20030612-002 Graphical runtime Comment in findRowObjectWhere funtion
rendering (ADM) about pcMode parameter is misleading,
the 'LAST' option is not supported.20030415-015 Graphical runtime After entering the first character into
rendering (ADM) a SmartFilter field with format
"(999)999-9999", the cursor jumps to the
last position in the field.20030115-010 Graphical runtime  .; SmartDataField fill-in is resized when
rendering (ADM) placed in a SmartDataViewer. If the
SmartDataField is run outside of the
SmartDataViewer, the size of the fill-in
is correct.20021115-009 Graphical runtime If a SmartFilter contains a word-indexed
rendering (ADM) field, the backspace and delete keys
will not work in the editor widget used
to edit the filter criteria.20020925-008 Graphical runtime A SmartDataBrowser that has a database
rendering (ADM) table defined as its datasource, instead
of an SDO, may error on compilation
with: "** Incompatible data types in
expression or assignment. (223)" and "**
<DLC>\gui\fn Could not understand line
252. (198)"00013872-000 Graphical runtime adm2/combo.p does not compile due to a
rendering (ADM) wrongly referenced include20040331-003 GUI Issues Color of fill-in is set incorrectly when
tabbing out of field20040311-016 GUI Issues Entering data into a fill-in may cause
&n.bsp; session to GPF or error 76 if a PROCESS
EVENTS statement is executed.20040209-040 GUI Issues PROCESS EVENTS may cause an ENTRY
trigger not to fire for a fill-in, and
also error messages about wrong data
entered when entering data.20040113-008 GUI Issues The limit on the number of widgets a GUI
client (prowin32.exe) session may create
has been removed.20040504-018 Internationalization Some records within a UTF-8 database
cannot be found using the FIND statement
when the WHERE clause contains extended
characters.20040310-010 Internationalization The LOOKUP function embedded in
get-user-field and get-value returns a
successful find for a partial match in
Webspeed if cpinternal is UTF-8 and
cpstream is UTF-8.20040106-033 Internationalization Error 51 occurs when passing a database
 .; field as INPUT-OUTPUT parameter to a
procedure using Chinese code page.20040322-036 JDBC Driver executeBatch not working against JDBC
drivers when setLong is used against a
NUMERIC field.20040322-001 JDBC Driver Changing the AutoCommit value after
performing a SELECT statement produces
an exception.20040129-023 JDBC Driver JDBC clients are not reused within the
connection pool and the connection pool
does not trim unused connections. When
using WebSpheres connection pool
manager, WebSphere thinks the
connections have been removed and makes
additional connections.20030825-011 JDBC Driver Not able to set a column's status to
NULL with the setNull method20020926-016 JDBC Driver For any kind of dynamic prepare
state.ment that has "?" parameters, the
execution of such statements will fail
if the given values of those "?"
character type parameters contain
non-ASCII letters.20040130-019 Open Edge SQL Might receive SQL Exception 7587 during
INSERT because of uninitialized
variables20040115-008 Open Edge SQL Poor performance is seen in the SQL
engine with complex queries when a query
has more than 5 tables and many equality
predicates on the join keys. Poor
performance may also be seen when a db
is converted from V9 to V10, and sql
statistics exist for indexes with more
than 4 components.20040114-010 Open Edge SQL Performance issue with PeerDirect
replication happens when PeerDirect's
 .; sql query uses the NOT EXISTS predicate.20040112-016 Open Edge SQL Using an invalid alias in a WHERE clause
causes a parsing error.20031118-071 Open Edge SQL Running the delete query after creating
a table, the SQL engine crashes.20040401-027 Oracle DataServer An Error 49 on UNIX or a GPF on Windows
encountered when doing GET-NEXT and
using a Local Oracle Dataserver20040309-043 Oracle DataServer A NULL is added to the end of a LONG RAW
field from Oracle when assigned to a
Progress RAW field overwriting the last
character.20040115-020 Oracle DataServer Commiting transactions in Progress DB
and Oracle DB simultaniously causes
error 1417.20031117-003 Oracle DataServer Query using MATCHES works against
Progress, fails against Oracle with a
933 Oracle error, "** SQL command not
properly ended."20040113-029 Product Bug Adminserver fails without error on the
adminserver.log f.ile if a CPU is not
responsive on the system.20030611-060 Product Bug A change to the Description of a field,
which does not affect SQL-WIDTH, causes
the SQL-WIDTH to revert back to the
default (twice the 4GL format), when an
incremental .df is applied to a target
database.20040423-046 PROEXP Databases deleted from Fathom console do
not cause Progress Explorer tree control
to be refreshed to show that the
deletion has occurred.20030610-043 PROEXP AppServer crashes when multiple clients
are competing for AppServer connection.20040113-021 PROGRESS Porting A defect where not using the latest IBM
Issues 1.3.1 JDK will cause the Admin Server
plug-in to not work.20030718-018 Promon Utility User is still listed in PROMON Option 1
'User Control' even though they have
&nbs.p; been disconnected or not visible from
Option 8 > 'Disconnect User'.20030703-030 Promon Utility Client not disconnecting fully from
remote connections.20030502-011 Promon Utility Disparity between remote users listed in
Summary and actual tally's from R&D
Activity\Servers screens. Connection
request denied due to 1154 error.20040225-039 Prostrct command When the target database of a procopy,
prorestore or prodb operation has an
existing structure file that identifies
variable length data extents with a
maximum size, those extents will be
expanded to their size limit. This will
be done even if the extents do not need
to be expanded to hold data.20040106-008 Prostrct command When a database extent is removed,
renamed or somehow lost, the prostrct
unlock utility may be use.d to create a
replacement (empty) extent. In version
9, the block headers of recreated
extents are not initialized correctly.
Attempts to access the blocks then cause
a system error.20040415-017 Query Results and When a SQL query contains an IN
Optimization predicate which can be used to help join
tables using an index, sql may run the
query very slowly. Also, if a qyery
contains OR'ed predicates equivalent to
an IN predicate, and these can be used
on a join, sql may run the query very
slowly.20040408-001 Query Results and Query fails with error 7473 after
Optimization Updating Statistics.20040202-038 Query Results and If a complex outer join query has more
Optimization than 8 tables joined together and has a
pattern or tree relationship, then the
&nbs.p; sql may be rejected as an "invalid outer
join". In fact, the query is logically
valid, and should be accepted as valid.20031219-001 Query Results and "TO_CHAR" function fails when used in a
Optimization SQL Query.20031208-010 Query Results and Using a range (x > 1 and x < 10) or the
Optimization BETWEENS phrase in a sub-query under a
NOT EXISTS predicate, may result in no
data being returned. Note that this
problem requires a NOT EXISTS sub-query.
Problem also requires that one or more
of the sub-query predicates not map to
an index key used to join the inner and
outer query tables.20031212-021 Rollforward Utility During a quiet point, the ai subsystem
will attempt to switch extents. If all
extents are full, the quiet point will
hang in an endless loop. The database
must be shutdown to end the hang.20040205-028 SQL Explorer &.nbsp; SQL "timestamp" datatype does not
display millisecond values.20011030-014 SQL Server When you run a query using a logical
field on the WHERE clause without saying
= no, or = yes , you will encounter the
following errors:
S0022: [Microsoft][ODBC SQL Server
Driver][SQL Server]Invalid column name
'a'.
S0022: [Microsoft][ODBC SQL Server
Driver][SQL Server]Invalid column name
'##1'.
S0022: [Microsoft][ODBC SQL Server
Driver][SQL Server]Statement(s) could
not be prepared.
20040419-002 SQL-92 Server Bugs A UNION query where some of the output
values are 0 length character strings
may crash the sql server.20040305-007 SQL-92 Server Bugs Calling complex stored procedure second
&n.bsp; time crashes SQL-92 engine.20040303-022 SQL-92 Server Bugs Complex queries associated with UNION
crash SQL-92 engine. This crash may
happen when a UNION query contains 0
length character strings.20040223-003 SQL-92 Server Bugs RPC error if a "TO_DATE" function
contains a parameter in a parameterized
SQL-92 statement.20040219-007 SQL-92 Server Bugs Running a stored procedure with more
than 50 columns in the results
definition causes the SQL-92 engine to
crash.20040111-001 SQL-92 Server Bugs When running SELECT statement on a VIEW
getting error: [JDBC Progress Driver]:
Server not reachable or possible RPC
error.20031229-001 SQL-92 Server Bugs The SQL server will die if trying to
update a blob column and a column of
another data type using parameters for
&.