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

encounters a java.lang.NullPointerException

when resuming replication after changing the

maintenance user id.

Customer have installed "rs_install_statreport_v1510_ase.sql".

When Customer populate statistics using "rs_stat_popultae", this store proc call "rs_stat_populate_netspd" which report duplicate key error:

1> rs_stat_populate

2> go

We are going to populate report. Script version 1510. :-)

Msg 2601, Level 14, State 2:

Server 'SYBASE_MEDISREP2', Procedure 'rs_stat_populate_netspd', Line 189:

Attempt to insert duplicate key row in object 'rs_statreport' with unique index 'rs_key_statreport'

Command has been aborted.

阅读全文...

ra_helpdevice is incorrect if the device is

stored under ASM.

datatypes are returned for varchar(max), nvarchar(max), and varbinary(max)

datatypes.

Workaround: Ensure that the replication agents in your replication environment

are version 15.1 ESD #1.

阅读全文...

2. Go to the Rights tab of the User prop sheet. Note that the Connect right has not been added to the user.

We should have a mechanism a checked-grayed box for inherited rights.

It could also be a "show inherited rights" icon like in member tab for a group.

BUG when creating repository tables. No confirmation message to say "Finished creating tables."

I know that this is not a major issue, but from the customer's perspective, they need to know when a PowerDesigner process has completed.

During consolidation of large models, PD shell stops responding to Windows (doesn't update display, etc). Need more than just "Saving the local document in the repository..."

1) Import model into PD7 and save it

2) Then consolidate that model into your favorite repository.

3) When it gives you the "Saving the local document..." message, launch the TaskManager and check out the PowerDesigner program.

NOTE: It will be listed as "Not responding".

4) If you have another application open, move its window around in front of the PD GUI.

Notice that it doesn't refresh the display. This is not good.

It takes a long time (anything over a minute or so is too long, but I'm talking 30 minutes and longer here) before it will update the GUI.

What I want to see is more GUI refreshes and some kind of status update in the message window, like what happens when I Reverse Engineer a database. The old MetaWorks gave me more information than this when it was working. Just giving me an hourglass is not acceptable

阅读全文...

Resolution: Reviewed Sep 2002. Presently not targeted for any future release of the product as changes between dblib and ctlib based isql are expected. This is documented in the 11.1 'Release Bulletin Open Client/Server' manual, section on 'Standalone Utilities'.

There are several differences between dblib and ctlib based isql. A change so late in the game could cause a regression to scripts at other customer sites.

阅读全文...

combined the CONTAINS predicate and an 'Into #temp' clause.

This happens in version 12.4.3 ESD7.

Exception Thrown from hqm_con.cxx:102, Err# 1, tid 264 origtid 264

O/S Err#: 0, ErrID: 8192 (hqm_exception)

CtLibrary Error: 141, Severity: 0, Origin: 1, Layer: 1

Error Message: ct_con_props(SET,PASSWORD): user api layer: external error: buflen must be 0 or CS_UNUSED when buffer is NULL.

OS Error: 0, OS Message: .

-- (hqm_con.cxx 102)

Probelm reason:

The INSERT... LOCATION statement always takes the user and password from the

current connection to connect to an ASE server. The catalog stores the password

only as hash value created by an one-way algorithm for security reason.

So the password string is not available for the event execution before the end user

using this username has connected to ASIQ.

As soon as an user has connected using the username all subsequent INSERT... LOCATION

in events work file

Its not possible to fix this problem without added new syntax or an new feature.

i'm going to create an Enhancement Request for this.

阅读全文...