提供7*24专业Sybase数据库远程及现场技术支持,Sybase ASE及Sybase SQL Anywhere数据库修复服务,
请联系电话: (微信),QQ: 289965371!
We supply technical support for Sybase ASE and Sybase SQL Anywhere, also have many years of experience in recovering data from damanged Sybase devices.
Please contact us:
Phone:
Wechat: 13811580958
QQ: 289965371 联系我们获取数据库技术支持!
Email: 289965371@qq.com
扫描下方微信,联系我们:
扫描雨翰数据恢复官方微信获取专业数据库恢复服务

 

随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息。
在SAP Support Portal网站或者google上搜索Targeted CR List for ASE,可以看到针对不同版本的CR(CR表示Change Request)简单描述信息列表。
需要注意的是:Targeted CR List for ASE列出的CR虽然绝大多数是BUG,但有一些是更改需求。
以下提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息!

如有问题,请联系我!

QQ :289965371 联系我们获取数据库技术支持!
Email:
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

 

CR:324477
CR Number:   324477
Product Name:   PB Enterprise
Product Component:   OLE - Active X - OCX
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Aug 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
This is a problem with an Active X in which the OCX is not properly

redrawn when increasing it's size.

The picture gets cut-off and the remaining part only shows

the background color of the OCX.



To work-around it, make the the control very large at design time

and set the required size at opening time.



CR:324483
CR Number:   324483
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jun 2005 Presently Not Targeted For Any Future Release Of This Product
Description
PowerBuilder 7, 8, 9.



When you have an argument specified for a nested report in the base datawindow,

then this expression is not copied into the Modify Expression dialog like PowerBuilder 6 did.
Review Status
 [*** Tuesday, June 21, 2005 14:38:43 ***]

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".



CR:324583
CR Number:   324583
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
A modify statement (setting the tabsequence) causes RowFocusChanged event to be triggered with argument currentrow set to 1, even if the current row is another.



CR:324594
CR Number:   324594
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 08 Oct 2003 Fixed
Description
Setting an edit mask "!!!!" for a column in the datawindow painter crashes PowerBuilder if the number of '!' is greater or equal to 32.



CR:324650
CR Number:   324650
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Request: Please add the functionality to automatically case powerscript as setup by Sybase. PB Help shows powerscript in one case yet everything is set to lowercase.



CR:324669
CR Number:   324669
Product Name:   PB Enterprise
Product Component:   Shared Objects
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2003 Fixed
Description
SharedObjectRegister function is failing in certain circumstances.
Workaround Description
 Code the constructor event to first populate all local variables and then populate the instance variables.



CR:324704
CR Number:   324704
Product Name:   PocketBuilder
Product Component:   DW - Runtime
Status:   Open
OS:   Windows 2000
Original Version:   1.0 RC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
159 Fixed
Description
editmask "datemask!" format "dd/mm/yyyy" does not allow the entry of dates correctly. Further testing of date correctness fails due to this problem.
Workaround Description
 use spincontrols on the date fields.



CR:324718
CR Number:   324718
Product Name:   PocketBuilder
Product Component:   System Runtime Functions
Status:   Closed
OS:   Emulator 2000
Original Version:   1.0 RC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13-Aug 23 Feb 2004 Fixed
Description
If a date has a special format eg. dd/mm/yyyy and the system settings of the device are also dd/mm/yyyy the date function formats the return value to be of type mm/dd/yyyy. Also functions like isdate() return false upon values like 30/06/2003.

Example Date() function:

30/06/2003. -> 01/01/1900

02/07/2003 -> 07/02/2003

Example IsDate() function:

Isdate("30/06/2003") -> not a valid date



UPDATE: on 2003/08/12 15:50:28

fixed -> CR324718 - date/time format using old technique



CR:324724
CR Number:   324724
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 22 Jul 2003 Fixed
9.0 14 Oct 2003 Fixed
Description
When entering a value on a edit mask control, it

results is the wrong value. For example, if you enter in the value of 999 and then

point the cursor at the beginning and then enter in 123, what happens is after entering

the 1, the value becomes 1,999.00. The cursor now jumps to after the first 9. When you type in the next value of 2, the edit mask value becomes edit mask of 19,299.00. After entering the 3, the value is now 19,239.00



In PB 8.0.3, the same value entered will result in:

12,399.00



CR:324813
CR Number:   324813
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2004 Not a Bug
Description
Unable to modify DW SQL Select with DECODE and NVL functions

Changeing SELECT with Modify for instance where ls_sql is

SELECT Decode( col , 'xxx', 1) FROM xxx WHERE xxx= :xxx AND xxx = 'xxx'

or

SELECT CASE WHEN xxx = 'xxx' THEN 1 END FROM xxx WHERE xxx= :xxx AND xxx = 'xxx'

and then doing a

ls_ret=dw.Modify("DataWindow.Table.Select='" + ls_sql + "'")



Workaround:

use the SyntaxFromSQL and Create DataWindow methods : that way, he can pass some "non-ansi" functions like DECODE or some statements like CASE...WHEN.
Workaround Description
 Workaround:

use the SyntaxFromSQL and Create DataWindow methods : that way, he can pass some "non-ansi" functions like DECODE or some statements like CASE...WHEN.



CR:324855
CR Number:   324855
Product Name:   PB Enterprise
Product Component:   DB JDBC
Status:   Closed
OS:   Solaris 2.6
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2007 Presently Not Targeted For Any Future Release Of This Product
Description
Korean char. displayed broken under PBVM 803.9704 on solaris with MSSQL 2000 JDBC (sp1)ConnCache.(EAS 4.2.1)

under same environments, in windows PBVM(i.g 803.9890) , it dispayed well.



CR:324864
CR Number:   324864
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1
Description
Source Control with PowerBuilder 9.0 and WinCVS 1.2, Jalindi Igloo 1.0.01



When requesting a "Refresh Status" the status of the object errornously changes to checked out.



CR:324893
CR Number:   324893
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 08 Sep 2003 Fixed
Description
Full Rebuild does not work for some objects
Target Version
 



CR:324924
CR Number:   324924
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
A datawindow shared from a datastore, doesn't display a nested report.



CR:324975
CR Number:   324975
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2010 Fixed
Description
Updateblob throws error when database name used without owner name.
Workaround Description
 use :

UPDATEBLOB easDemo9.dba.tblob SET colblob = :lblb_content WHERE col1 = :ldec_id USING SQLCA;



CR:325064
CR Number:   325064
Product Name:   PocketBuilder
Product Component:   DW Painter
Status:   Open
OS:   Windows 2000
Original Version:   2003 V1 Beta
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Save Rows As ..." doesn't work for "SQL" format, in DataWindow



CR:325132
CR Number:   325132
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Select Report dialog window is empty for a new composite report on an Insert->Control->Report in the datawindow painter.



CR:325192
CR Number:   325192
Product Name:   PocketBuilder
Product Component:   Application Deployment
Status:   Open
OS:   Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.5 337
Description
Application icon does not work for desktop and emulator deployments



CR:325336
CR Number:   325336
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0.3 17 Sep 2003 Fixed
15 Oct 2003 Fixed
Description
After adding un-selected columns into order-by clause in data source syntax mode ,

order-by clause disappeared after converting graphics mode and return syntax mode,

also order-by clause disappeared.

If order-by columns added in select-list , no problem.
Workaround Description
 adding the order-by column in select-list



CR:325357
CR Number:   325357
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Dynamically setting the datawindow locks the file it came from. There doesn't seem to be a way to unlock it.



LibraryCreate

LibraryImport (datawindow)

use datawindow

LibraryDelete -> fails
Workaround Description
 non



CR:325429
CR Number:   325429
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 14 Jun 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
When a select statement has a computed column containing

replace and the replace function has a argument of '~~~"', its causing PB to crash.



The following is the syntax of the export dw:

retrieve="SELECT DISTINCT

REPLACE( ST_NM, '~~~"', '@' ) display,

ST_NM code



FROM

CUST_LNDLRD



WHERE

ST_NM <> ' '

" sort="display A " )



The following is the output from the crash handler:



Exception code: C0000005 ACCESS_VIOLATION

File Name: E:\pb80\Shared\PowerBuilder\PBSQL80.dll

File Version: 8.0.3.9977

Fault address=12505C8F Section:Offset=01:00004C8F



Registers:

EAX:00000000

EBX:021F4750

ECX:FFFFFFFF

EDX:021F4750

ESI:021D3618

EDI:00000000

CS:EIP:001B:12505C8F

SS:ESP:0023:0012E9F8 EBP:00000000

DS:0023 ES:0023 FS:0038 GS:0000

Flags:00010286



RESOLUTION: Could not reproduce problem in PB 9.0.2 (Build 7672) and PB 10.2 (build 8049)



CR:325430
CR Number:   325430
Product Name:   PB Enterprise
Product Component:   Window Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 17 Sep 2003 Fixed
18 Sep 2003 Fixed
Description
Powerbuilder crashes in the Window Painter when you delete a command button on a tab page and then save window, if there are other scripts that reference the command button.



CR:325434
CR Number:   325434
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 21 Sep 2003 Fixed
19 Jan 2004 Fixed
Description
Enlarge block size to current limits on the o84 and o90 Oracle native drivers.



CR:325581
CR Number:   325581
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 17 Sep 2003 Fixed
Description
dw.print() should display cancel dialog by default as it did with PB 8. With PB 9 it is necessary to explicitly pass a TRUE boolean to the dw.print method. TRUE should be the default value. Calling dw.print with no parameter no longer causes the cancel dialog to display. Also, using File...Print Report from the Preview View in the dw painter displayed a cancel dialog in PB 8. It no longer does with PB 9.



Workaround in code: call dw.print(true) instead of dw.print() to display the cancel dialog. No workaround for the dw painter problem.



CR:325617
CR Number:   325617
Product Name:   PocketBuilder
Product Component:   DB Painter
Status:   Closed
OS:   Windows 2000
Original Version:   1.0 RC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14-Aug 25 Aug 2003 Fixed
Description
"Arrange Tables" inside Database Painter causing Pocket Powerbuilder Crash.
Workaround Description
 Nil



CR:325619
CR Number:   325619
Product Name:   PocketBuilder
Product Component:   DW Painter
Status:   Open
OS:   Windows 2000
Original Version:   1.0 RC
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Unlike PowerBuilder, at the datawindow DESIGN PANE, the edges of objects and columns in datawindow are NOT shown in Pocket PowerBuilder by default.
Workaround Description
 Go to menu: Design -> Options... -> General tab page -> Show Edges to manually enable the column and object edges in datawindow.



CR:325623
CR Number:   325623
Product Name:   PB Enterprise
Product Component:   System Runtime Functions
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 17 Aug 2003 Fixed
07 Dec 2003 Fixed
Description
The fromunicode/tounicode functions show a difference (garbage characters are added at the end) which should not occur.



CR:325688
CR Number:   325688
Product Name:   PB Enterprise
Product Component:   Language - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 17 Aug 2003 Fixed
Description
Regression: From PB 7 to PB 8 & 9, when passing 2 dimensional string array to a COM dll.



CR:325749
CR Number:   325749
Product Name:   PB Enterprise
Product Component:   DW XML
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When saving to XML format when a template is set up

with children, the following is the results:



- <shoppingcart>

- <item

book

<title>A Walk in the Woods</title>

<author>BillBryson</author>

</item>



It should look like this:

- <shoppingcart>

- <item>book</item>

<title>A Walk in the Woods</title>

<author>BillBryson</author>



The template is setup as:

- shoppingcart

- item

item

-----------------------------

- title

title

- author

author



CR:325808
CR Number:   325808
Product Name:   PB Enterprise
Product Component:   Debugger
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
If adding a watch like "len(test)" causes a GPF if pressing {step in} in debugger
Workaround Description
 no



CR:325824
CR Number:   325824
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 18 Sep 2003 Fixed
29 Mar 2004 Fixed
Description
Regression: The editmask date dd.mm.yyyy does not allow values starting with a 3 to be entered.



CR:325825
CR Number:   325825
Product Name:   PB Enterprise
Product Component:   Library Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2005 Fixed
Description
Search in Library Painter crashes/gpfs when many objects in the library will be selected. GPF in pbdevxx , eg. pbdev80.dll
Workaround Description
 Workaround: Use system tree, do a search on the target.



CR:325829
CR Number:   325829
Product Name:   PB Enterprise
Product Component:   Debugger
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
Crash in debugger if breakpoint removed and then inserted again and expression in watch is set.
Workaround Description
 non



CR:325863
CR Number:   325863
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   7.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2003 Workaround
Description
PB application that worked ok in 10180 is now crashing

when closing the application in build 10290.



The following is the crash handler log that customer sent:



Exception code: C0000005 ACCESS_VIOLATION

File Name: C:\Program Files\Sybase\Shared\PowerBuilder\PBVM70.dll

File Version: 7.0.3.10290

Fault address=11385171 Section:Offset=01:00164171



Registers:

EAX:00000000

EBX:01423C00

ECX:022A02D0

EDX:01423C00

ESI:03871F60

EDI:00000000

CS:EIP:001B:11385171

SS:ESP:0023:0012FAC0 EBP:03871F60

DS:0023 ES:0023 FS:0038 GS:0000

Flags:00010246



Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

11385171 0012FC80 00050252 00060262 00000435 000003F8 ob_create_consolidated_library+411

77E8479C 01423C00 01423C00 01A000F8 01A00068 00000000 GetMessageTime+6B3

01423C00 1149B080 11361E10 00000000 113633F0 11363410 0000:00000000

11361E00 1149B0E8 1136AD40 00000000 1147E6C4 1147E6C4 ob_convert_chararray_to_string+470



OS version:

Windows NT 4.0, Build Number: 1381, Service Pack 6



Memory Status:

Total physical memory: 521620K

Available physical memory: 365012K

Total virtual memory usage: 138072K / 1027088K

PowerBuilder virtual memory usage: 77772K / 2097024K



CR:325884
CR Number:   325884
Product Name:   PB Enterprise
Product Component:   JSP Editor
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jun 2005 Presently Not Targeted For Any Future Release Of This Product
Description
PowerBuilder 9.0.1. The import files dialog for a JSP target should have a filter for java file types (.class, .jar, etc.).



CR:325891
CR Number:   325891
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 10 Feb 2004 Fixed
Description
When closing an application that contains pfc, the application

will crash will the following error:

pb90.exe - Application Error

The instruction at "0x77f87ece" referenced memory at "0x10dc14b8". The memory could

not be "written".



The following is a crash handler log:

Exception code: C0000005 ACCESS_VIOLATION

File Name: E:\pb90\Shared\PowerBuilder\PBVM90.dll

File Version: 9.0.0.6111

Fault address=10DA13F9 Section:Offset=01:002A03F9



Registers:

EAX:00000020

EBX:013B15E0

ECX:0000000C

EDX:10E35E50

ESI:00000004

EDI:00090652

CS:EIP:001B:10DA13F9

SS:ESP:0023:0012C3D0 EBP:013B15E8

DS:0023 ES:0023 FS:0038 GS:0000

Flags:00010246



Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

10DA13F9 0012C3EC 013B15E0 10B53EDE 013B15E8 10C8476A PbHeap_free+2B9

10BCA081 0012C3F4 013B15E8 10C8476A 014003D0 013B15E8 shtokenReject+A4C1

10B53EDE 0012C3FC 014003D0 013B15E8 03787D40 02740108 pbstg_fee+E

10C8476A 0012C424 02740108 02740108 00000000 10C8FFBD ob_create_interface_in_library+AEA

10C84C2C 0012C434 00000000 00000000 10DBDBD5 02740108 ob_create_interface_in_library+FAC

10C8FFBD 0012C440 02740108 03787D40 10CE4123 02740108 ob_destroy_rtinst+D

10DBDBD5 0012C44C 02740108 028E02B4 02740108 0012C474 0001:002BCBD5 E:\pb90\Shared\PowerBuilder\PBVM90.dll

10CE4123 03787D40 00000000 00000000 0000000F 00000000 rt_set_pcode_to_line+793



OS version:

Windows NT 5.0, Build Number: 2195, Service Pack 3



Memory Status:

Total physical memory: 261552K

Available physical memory: 32848K

Total virtual memory usage: 281212K / 1060304K

PowerBuilder virtual memory usage: 132864K / 2097024K



CR:325995
CR Number:   325995
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jun 2005 Presently Not Targeted For Any Future Release Of This Product
Description
When opening an existing datawindow, and you add a selfjoin to a table, meaning you open a table two times in the SQL Painter (will result in table_a and table_b), select the same field in both tables and in the painter eg. create a compute field : the columns are listed with the same names in the list. you can see in the list : field and field instead of field and field_1.
Review Status
 13.06.2005

This CR was reviewed and closed as part of the PB10 Review process. It is "Not targeted for any future release".
Workaround Description
 open the dw in "edit source"

find all references to the second "field" and rename to "field_1"



CR:326067
CR Number:   326067
Product Name:   PB Enterprise
Product Component:   DB MS SQLServer
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 18 Sep 2003 Fixed
21 Oct 2003 Fixed
Description
When calling SyntaxFromSQL function in PB8.0.1 & PB9.0 5507 the function returns just the columns names. In PB8.0.3 & PB9.0 build 6096, it returns with tablename_columnname combination. There was a change in behaviour.



CR:326125
CR Number:   326125
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2004 Not a Bug
Description
PB8 build 9970 on Windows 2000 and Windows NT. Group datawindow has its header missing on all but the first page when viewed via as a PSR on a different platform to which it was saved on.





Per PB Engineering, this is not a bug.

1. The problem happens only for the PSR's having Paper Size in Printer Specifications of the corresponding DW is set to Default(0) value.

2. Once, the paper size is set to default value, the report's page height will become a machine dependant value and the value will be set according to the default page size of the machine's default printer setup.

3. If the default page size (default printer setup) between two machine is different, then a PSR file created in one machine will no longer be portable on the other machine. This is because of the difference of the report's page height in different machine. If the page size differs with machine, the number of rows in a page will also differs and that will cause the problem.

4. To resolve the problem, just change the report's page size to a non-default value and make sure that the new page size is supported by the printer drivers of both the machine.

5. This is not a PB bug and requires no changes in source code end.
Workaround Description
 non



CR:326134
CR Number:   326134
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 18 Sep 2003 Fixed
Description
Regression since PowerBuilder 8.0.3 9882. Nested report in summary is not displayed completely even when you make the band wider.



CR:326135
CR Number:   326135
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Print Alignment Problem on DataWindows that have righttoleft support enabled.



for a normal size report:

When printing the datawindow basically prints out from left to right aligned, not as expected right to left. On the right hand side there will be some empty space left.



for a large width report:

When printing the datawindow in landscape mode basically prints out from left to right aligned, not as expected right to left.

On the overlapping pages (the ones that are extra pages because of the width) the print is also started from the left to right.



CR:326170
CR Number:   326170
Product Name:   PB Enterprise
Product Component:   PB GUI
Status:   Open
OS:   Microsoft Windows NT
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer would like Skins support in PowerBuilder version 9.0 and higher.



Information on skins can be found at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmplay/mmp_sdk/whymakeskins.asp



CR:326178
CR Number:   326178
Product Name:   PB Enterprise
Product Component:   Documentation
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2004 Fixed
Description
In the PowerBuilder Extension reference:



1. Source code examples using the PBDOM methods should no include the ref keyword or the & characters. Below are two examples, but there may be others:



SetContent under PB_DOM_ELEMENT shows the following line of script

pbdom_doc.GetRootElement().SetContent(ref & pbdom_obj_array)

that should become



pbdom_doc.GetRootElement().SetContent(pbdom_obj_array)



BuildFromFile shows:



pbdom_doc.GetRootElement().GetChildElement & ("data").GetContent(ref pbdom_obj_array)



and that should be

pbdom_doc.GetRootElement().GetChildElement & ("data").GetContent(pbdom_obj_array)



CR:326195
CR Number:   326195
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jul 2003 Fixed
10.0 Alpha 14 Oct 2003 Fixed
28 Jul 2003 Fixed
Description
With an editmask of YYYYMMDD when entering data and you reach the last Y the cursor skips to the last D entering the date incorrectly.



CR:326201
CR Number:   326201
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 04 Jul 2004 Presently Not Targeted For Any Future Release Of This Product
Description
When a PB client is trying to access a PB web service where

basic authentication is set, the following error message appears:



Application terminated.

Error: Unexpected return code: 401 Unauthorized



From the Soaplog.log file the following appears:

CLOSED





REQUEST:

CLOSED

POST /WEBSERVICES/SOAP HTTP/1.1

Host: duquette-w2k:8080

Connection: Keep-Alive

User-Agent: EasySoap++/0.6

Content-Type: text/xml; charset="UTF-8"

SOAPAction: "calc/n_calc.add return,short,return in,short,i_1 in,short,i_2"

Content-Length: 402



<E:Envelope

xmlns:E="http://schemas.xmlsoap.org/soap/envelope/"

xmlns:A="http://schemas.xmlsoap.org/soap/encoding/"

xmlns:s="http://www.w3.org/2001/XMLSchema-instance"

xmlns:y="http://www.w3.org/2001/XMLSchema"

E:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">

<E:Body>

<add>

<i_1

s:type="y:short">22</i_1>

<i_2

s:type="y:short">66</i_2>

</add>

</E:Body>

</E:Envelope>





RESPONSE:

HTTP/1.1 401 Unauthorized

Content-Length: 47

Connection: Keep-Alive

WWW-Authenticate: Basic realm="newtest"

Content-Type: text/html

Server: Jaguar Server Version 4.2



<head><title>UNAUTHORIZED!!!!!</title></head>

Connection Disconnected



CR:326207
CR Number:   326207
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jul 2003 Not a Bug
Description
DW column display format expression with String function displays incorrectly.



This is not a bug. The String format was being used incorrectly. In the string format you must always use the US standard. Then the regional settings are plugged in to the runtime display, so you will aways get the regional settings display.



A workaround is to use Escape characters in the column display format (The String format). For example, try with '#\.###\,00'. But the problem in this case is, the characters will be treated as ASIS characters and display will not be proper if the mask length is more than actual data. For example, if we use the above mask and specify an initial value 123456, the data will be displayed perfectly, as per their requirement. But if we change the initial value to 12345 (data length is less than mask length) there will be a problem.



To avoid this, they can set the display format in script. Before applying the format , they have to call a function, say GenerateMask(). Let's say the function will take 5 parameters - data, generated mask string by ref, number of digits after decimal position, digit group length and $ or Uro or other currency flag. They have to put code in the function, so that it will form the mask string (depending upon the currency flag) whose length will be exactly same to the data length. Then this mask can be applied.



CR:326214
CR Number:   326214
Product Name:   PB Enterprise
Product Component:   Help
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jul 2003 Duplicate
Description
What's New for the 9.0.1 release in the help file has a topic called PBNI source files in public directory that says you can rebuild pbni.lib from files in SDK/PBNI/src, but that directory doesn't exist.



CR:326234
CR Number:   326234
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 17 Sep 2003 Fixed
08 Oct 2003 Fixed
Description
An 8.0.3 regression that last worked in buld 9620. Using GetFullState and SetFullState to populate a datawindow that has nested datawindows 3 deep. The 2 outer most nests display and there is room made for the 3rd nest, but it does not display.



CR:326242
CR Number:   326242
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 18 Sep 2003 Fixed
08 Oct 2003 Fixed
Description
Columns with editmasks of date or string not firing editchanged event on a delete of the column data.



CR:326301
CR Number:   326301
Product Name:   PB Enterprise
Product Component:   Automation
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 30 Sep 2003 Fixed
Description
PB needs an equivalent to the VB getObject function, in order to get a valid object reference for further function calls.



CR:326365
CR Number:   326365
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 14 Oct 2003 Fixed
Description
A regression in 9.0 from 7.0.3. Cusotmer has datawindows that scroll vertically fine in 7.0.3, but when migrated to 9.0 you can't scroll all the way to the bottom.



CR:326373
CR Number:   326373
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Autosized nested reports that display fine in 7.0.3 overlap when migrated to 8.0.3.



CR:326451
CR Number:   326451
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2005 Fixed
Description
Freeform dw with groups. When doing QueryMode ON and then QueryClear, there is a GPF in PBDWE. The error is related to the size of the datawindow, ie. when the dw height is small compared to the object (a vertical scrollbar is visible.).



Workaround:

eg. replace the code in the clicked event of the queryclear button



dw_2.setredraw(false) //disable flickering

dw_2.height=1388 //set to a larger size

dw_2.Object.DataWindow.QueryClear="yes"

dw_2.height=984 //set back - eg. to original value !

dw_2.setredraw(true)
Workaround Description
 Workaround:

eg. replace the code in the clicked event of the queryclear button



dw_2.setredraw(false) //disable flickering

dw_2.height=1388 //set to a larger size

dw_2.Object.DataWindow.QueryClear="yes"

dw_2.height=984 //set back - eg. to origina



CR:326480
CR Number:   326480
Product Name:   PocketBuilder
Product Component:   DB ODBC
Status:   Open
OS:   Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Workaround
Description
When calling an external function on a transaction object that calls an ASA stored function, it fails with a SQLState S1090 error.
Workaround Description
 *** Tuesday, December 09, 2003 4:09:49 PM *** skay ***

Unicode string return types are failing in the current Pocketbuilder ODBC code due

to a failed call to SQLBindParameter in our ODBC_RPCexecute function in the ODBC

driver code. The functionality ha



CR:326518
CR Number:   326518
Product Name:   PB Enterprise
Product Component:   Debugger
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 10671 10 May 2004 Fixed
18 Jun 2004 Fixed
Description
New Feature Request:

It would be helpful for customers if the SybHeap dump output could be directed to a specific file, so customers do not have to dig through to get output and piece together for analysis. Customers should be able to specify a file name to send the dump to.



PB Engineering created 2 new environment variables:

PB_HEAP_LOGFILENAME

The PowerBuilder SybHeap memory manager can provide diagnostic output that helps you troubleshoot memory allocation issues in your application. The PB_HEAP_LOGFILENAME environment variable lets you set the name and location of the file to which this output is written.



If you specify a file name but not a directory, the file is saved in the same directory as the PowerBuilder executable, or, for a PowerBuilder component running on EAServer, to the EAServer bin directory.



If you specify a directory that does not exist, the file is not created, or, for a PowerBuilder component running on EAServer, output is written to the EAServer console.



PB_HEAP_LOGFILE_OVERWRITE

PB_HEAP_LOGFILE_OVERWRITE is a boolean environment variable that specifies whether diagnostic output should overwrite or append to the existing data in the file specified by PB_HEAP_LOGFILENAME. Values are:

true - overwrite existing data in the log file

false - append to existing data in the log file



CR:326543
CR Number:   326543
Product Name:   PB Enterprise
Product Component:   Project Wizards
Status:   Closed
OS:   Windows XP
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 May 2005 Fixed
Description
PB 9.0 New dialog on XP shows only 4 columns of icons on Project tab.



CR:326630
CR Number:   326630
Product Name:   PB Enterprise
Product Component:   Migration
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
A datawindow object name is different in the system tree after migration of unnamed object than it is in the datawindow painter.



CR:326638
CR Number:   326638
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 13 Nov 2003 Fixed
Description
Nested datawindow with a large text column displays OK in one nest but not another. It's chopping of the bottom of the last line of characters.



CR:326826
CR Number:   326826
Product Name:   PB Enterprise
Product Component:   DW Printing
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jun 2005 Fixed
Description
Regression in PowerBuilder 9.x : Cancel dialog box is displayed with canceldialog set to false for Richtext datawindow : dwcontrol.Print (false) -> the dialog is shown



CR:326835
CR Number:   326835
Product Name:   PB Enterprise
Product Component:   UO Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 03 Sep 2006 Fixed
Description
Inherited object from modified pfc_u_dw / u_dw object cannot be saved if adding a object function before saving. Causes GPF if doing it twice.



Workaround: save object and close object and then reopen and add the function
Workaround Description
 1. inherit from u_dw.

2. save object and close object

3. reopen object and add a function

4. close object and say yes for saving changes.

5. reopen object -> changes are saved.



CR:326865
CR Number:   326865
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jun 2004 Not reproducible with latest version of the product available as of Resolution Date
Description
Doing a datawindow Paste function to a column with an editmask doesn't work properly. You call the paste function and you'll see the new pasted value in the edit control. But when you tab out of the column the value disappears and it reverts back to the previous value.
Workaround Description
 Use the Clipboard() function to get the value in the system clipboard and then put the value in the edit control with SetText(). These 2 lines replace using the datawindow paste function.



In PFC, this can be implemented by overriding the pfc_paste eve



CR:326923
CR Number:   326923
Product Name:   PB Enterprise
Product Component:   DB Profile
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 12 Nov 2003 Fixed
Description
After switching from inappropriate db profile to accurate profile, (i.g MSSQL -> ASA )

and after appending sql in query then return, PB is crashed.



CR:326965
CR Number:   326965
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 01 Aug 2003 Fixed
Description
Application retrieves a Crosstab style dw. Then uses GetFullState on the first dw, SetFullState to populate dw2. The display for dw2 overlaps and cannot be read from build 6086 and later. The application worked okay with build 6075.



CR:326976
CR Number:   326976
Product Name:   PB Enterprise
Product Component:   DW Painter
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
PowerBuilder crashes while attempting to edit the SQL for a datawindow which uses an Oracle function in its Select clause and the function accepts 2 or more parameters. The function must also be qualified with its owner name.



CR:326985
CR Number:   326985
Product Name:   PB Enterprise
Product Component:   P-Code Exe Creation
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Application the creates menus dynamically and built using C-code hangs.



CR:327045
CR Number:   327045
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 17 Sep 2003 Fixed
Description
At first in syntax mode , after adding between sql query then convert to graphics mode ,

between query isn't interpreted well in graphics mode .

At once first adding between query in graphics mode , converting to syntax and graphics mode , it doesn't matter.
Workaround Description
 Once at first adding between query in graphics mode , there is no matter in converting into syntax and graphics mode



CR:327066
CR Number:   327066
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.2.1 08 Jun 2007 Fixed
Description
doesn't recognize unsigned integer data type. New datawindow created on a table with a column "unsigned int" will represent the datatype as long. This cause DW Error 22003 "Numeric value out of range" on retrieve and validation message on update.



Workaround: dw column type from long to ULong and use Disablebind = 1
Workaround Description
 1. Change column datatype in DW to ULong

2. Use DisableBind=1 for your connection.



CR:327072
CR Number:   327072
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Sep 2003 Not a Bug
05 Sep 2003 Workaround
Description
Once a JSP page has called a Web Datawindow container, the component is not returning to the pool when the timeout property is set. The

problem happens using EAServer 4.2.1. The component is returning ok

to the instance pool once the component timed out using EASErver 3.6.1 C5.



From the srv.log, you can see that the deactivate and canbepooled events are fired in

EAServer 3.6.1 C5.



Resolution: Determined to be an EAServer issue and that EAServer engineering determined the reason that the component is not timing out is that there is a transaction that is still active. The component 'requires' a transaction and so one is started. No action is done by the component to ever end the transaction. In addition the HTMLdw component returns the ContinueWork primative after each method call via the PB EnableCommit() method. The means that the HTMLdw is giving it's blessing to a Commit, but is not issuing one.



There are two timeout variables. Instance timeout and transaction timeout. The component has set an instance timeout, but no transaction timeout.



WORKAROUND: Set the transaction timeout to the desired time. This property can be found on the 'Resources' property tab of the component properties. The same tab as the instance timeout property. This will give the component the same behaviour as 3.6.1.
Workaround Description
 Setting setserversidestate to false in jsp will deactivate the instance. Although according to TSE, the pagenext and pageprior buttons will not work.



CR:327097
CR Number:   327097
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jun 2005 Fixed
23 Sep 2003 Fixed
Description
When a source control pbl is in a folder where the total

path in length is 90 or greater and you copy an object into the pbl, pb will crash.



The following is the crash handler results from PB 90:

Exception code: C0000005 ACCESS_VIOLATION

File Name: unknown

File Version: unknown

Fault address=70617369 Section:Offset=00:00000000



Registers:

EAX:00000001

EBX:02747D50

ECX:10E3B210

EDX:10E3B210

ESI:026FFE68

EDI:0012FB1C

CS:EIP:001B:70617369

SS:ESP:0023:0012F3FC EBP:0273F168

DS:0023 ES:0023 FS:0038 GS:0000

Flags:00010206



Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

70617369 0012F3F8 72756F73 6F636563 6F72746E 6973756C 0000:00000000

7265646C 0273F168 00000001 00000001 00000001 00000001 0000:00000000



OS version:

Windows NT 5.0, Build Number: 2195, Service Pack 3



Memory Status:

Total physical memory: 261552K

Available physical memory: 95124K

Total virtual memory usage: 242280K / 1060304K

PowerBuilder virtual memory usage: 118660K / 2097024K



CR:327178
CR Number:   327178
Product Name:   PB Enterprise
Product Component:   PB Web Services
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 23 Oct 2003 Fixed
Description
Customer has created a WebService in the Websphere Studio Application Developer 5.0 and we are trying to use these WSDL files and the WebService from a PowerBuilder client. We have been able to step through the WebService Proxy wizard in PB but when we try to deploy the proxy we get an error and the proxies are not created. Can we use this WebService that is created locally with WebSphere from PowerBuilder? What else do we have to do to be able to use these from PowerBuilder? The webservice has been created and temporarily "published" but do they have to be officially published to be able to use them from within PowerBuilder?



CR:327180
CR Number:   327180
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 21 Oct 2003 Fixed
24 Feb 2004 Fixed
Description
PowerBuilder 8.0.3 9977 severe memory problem in production that works with citrix.



CR:327195
CR Number:   327195
Product Name:   PB Enterprise
Product Component:   DW SaveAs
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Mar 2004 Fixed
Description
When an application is on a network drive and

you are trying to do a saveas to PDF using ghostscript, the process takes much

longer than if the application was running on a local drive.



For example, it took 33 seconds to save a datawindow to a PDF from a network drive. When

the same pbl was on a local drive it only took 4 seconds to save to a local drive and 5

seconds to save on a network drive.



CR:327212
CR Number:   327212
Product Name:   PB Enterprise
Product Component:   DW HTML
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 28 Sep 2003 Fixed
Description
Object name not returned in a Web datawindow when clicking on a picture control.



CR:327294
CR Number:   327294
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Feb 2004 Third Party Problem
Description
Cannot delete an object from PBL when using Perforce, even when you have removed it from SOurce control.



Workaround: Manually remove object from PBG and PBC files, making sure to remove it from the 'master' copy as well as local copy. Reopen the workspace *working offline* so that you are *not* connected to source control. At this point you should be able to delete the object from the PBL. Then close workspace and reopen, connecting normally to the source control system.



CR:327295
CR Number:   327295
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.2 11 Aug 2004 Not a Bug
Description
Objects in Perforce source control that have OLE controls periodically display as out of synch, even though the object on the desktop isn't any different that the object in source control.



CR:327400
CR Number:   327400
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ability to add blobs to a external datawindow -

perhaps using the GetPicture function if getting the blobs using SELECTBLOB but cannot add those pictures to the dw.



CR:327416
CR Number:   327416
Product Name:   PB Enterprise
Product Component:   Jaguar Integration
Status:   Closed
OS:   Solaris 2.6
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 27 Apr 2005 Fixed
Description
With 1 user calling the web datawindow component, a large amount of memory is consumed. From the vmstat report below, you can see the amount of swap and free space used up although the free space stabilizes while the swap space continues to drop.



A vmstat shows the following:

procs memory page disk faults cpu

r b w swap free si so pi po fr de sr dd dd f0 s0 in sy cs us sy id

0 0 0 2286904 234096 0 0 2 0 0 0 0 0 2 0 0 307 57 49 0 0 100

0 0 0 2071584 7912 0 0 0 49 69 0 10 1 3 0 0 317 297 272 3 0 97

0 0 0 2070800 7904 0 0 0 36 48 0 4 1 3 0 0 317 438 439 2 0 97

0 0 0 2068680 7888 0 0 48 99 158 0 25 5 2 0 0 354 484 313 4 1 95

0 0 0 2067736 7912 0 0 0 41 58 0 8 2 2 0 0 318 282 277 2 1 97

0 0 0 2067000 7904 0 0 0 43 66 0 9 1 3 0 0 318 296 277 2 0 97

0 0 0 2066216 7936 0 0 0 42 59 0 7 0 2 0 0 315 283 269 3 0 97

0 0 0 2065416 7912 0 0 0 36 57 0 8 1 3 0 0 315 284 271 2 1 97

0 0 0 2064600 7936 0 0 2 42 62 0 8 1 3 0 0 317 275 273 2 0 97

0 0 0 2063904 8024 0 0 18 62 88 0 14 2 2 0 0 320 309 286 3 0 97

0 0 0 2063088 8064 0 0 18 30 36 0 3 2 3 0 0 321 303 272 2 1 97

0 0 0 2062296 7928 0 0 0 48 63 0 10 1 3 0 0 318 277 270 3 0 97

0 0 0 2061504 7904 0 0 0 44 67 0 9 0 2 0 0 316 305 276 3 0 97

0 0 0 2060712 7904 0 0 0 35 55 0 7 1 2 0 0 315 274 271 2 0 97

0 0 0 2059920 7880 0 0 7 48 76 0 12 1 3 0 0 317 293 275 2 0 97

0 0 0 2059080 7936 0 0 0 48 62 0 7 0 2 0 0 315 276 270 2 0 97

0 0 0 2058296 7912 0 0 0 48 66 0 10 1 3 0 0 318 291 271 2 0 97

0 0 0 2057488 7896 0 0 0 36 53 0 8 1 3 0 0 317 289 277 3 0 97

0 0 0 2056704 7920 0 0 0 48 71 0 10 0 2 0 0 316 283 270 3 0 97

procs memory page disk faults cpu

r b w swap free si so pi po fr de sr dd dd f0 s0 in sy cs us sy id

0 0 0 2055880 7896 0 0 0 42 63 0 9 1 3 0 0 315 294 275 2 1 97

0 0 0 2055088 7920 0 0 4 44 59 0 7 1 3 0 0 368 329 289 2 0 97

0 0 0 2054304 7904 0 0 0 36 51 0 6 0 2 0 0 438 433 307 3 1 97

0 0 0 2053504 7880 0 0 3 43 66 0 11 1 3 0 0 426 409 307 2 1 97

0 0 0 2052720 7880 0 0 4 54 78 0 10 1 4 0 0 319 309 280 3 1 97

0 0 0 2051888 7920 0 0 8 41 60 0 9 1 2 0 0 316 276 274 2 0 97

0 0 0 2051112 7888 0 0 48 62 110 0 18 7 3 0 0 328 302 290 2 1 97

0 0 0 2050312 7904 0 0 0 44 64 0 9 1 3 0 0 318 327 319 3 0 97

0 0 0 2049520 7880 0 0 0 41 64 0 8 0 2 0 0 314 276 272 2 0 97

0 0 0 2048712 7888 0 0 1 43 71 0 11 1 3 0 0 317 302 281 3 1 97



0 0 0 2047920 7944 0 0 0 42 56 0 7 1 3 0 0 315 262 275 2 0 98





HTMLGenerator80 Stats (Counter on jsp page was 192)



Method Invocations: 1170.0

Instances Active: 0.0

Instances Pooled: 1.0

Transactions Completed: 975.0

Transactions Rolled Back: 0.0

Last Maximum Method Invocations: 0.0

Last Maximum Instances Active: 0.0

Last Maximum Instances Pooled: 0.0

Last Maximum Transactions Completed: 0.0

Last Maximum Transactions Rolled Back: 0.0

Peak Maximum Method Invocations: 1170.0

Peak Maximum Instances Active: 1.0

Peak Maximum Instances Pooled: 1.0

Peak Maximum Transactions Completed: 975.0

Peak Maximum Transactions Rolled Back: 0.0







The pmap.txt included with the test case shows the following:

23284: /apps/Sybase/EAServer/bin/jagsrv Jaguar

00010000 360K read/exec /apps/Sybase/EAServer/bin/jagsrv

00078000 56K read/write/exec /apps/Sybase/EAServer/bin/jagsrv

00086000 1032920K read/write/exec [ heap ]

B17FE000 16K read/write/exec [ anon ]

B1872000 64K read/write/exec [ anon ]

.

.

.

FF390000 8K read/exec /usr/lib/libdl.so.1

FF3A0000 8K read/write/exec [ anon ]

FF3B0000 160K read/exec /usr/lib/ld.so.1

FF3E8000 8K read/write/exec /usr/lib/ld.so.1

FFB70000 24K - [ stack ]

FFB76000 488K read/write/exec [ stack ]

total 1179080K



RESOLUTION: Fixed in PB 8.0.3 builds after 8/11/2003.



CR:327427
CR Number:   327427
Product Name:   PB Enterprise
Product Component:   DW Display
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Aug 2003 Presently Not Targeted For Any Future Release Of This Product
Description
ISUG Enhancement Request e15_126:



Ability to 'freeze' one or more columns on a datawindow, to allow horizontal scrolling while still seeing 'frozen' columns, similar to the 'Freeze Panes' functionality in Microsoft Excel.
Review Status
 Reviewed by PB Engineering - ISUG Rating:

"N" No Plans.



CR:327446
CR Number:   327446
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Windows XP
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 02 Dec 2003 Fixed
Description
The control menu does not display on a maximized MDI sheet in Windows XP.



CR:327558
CR Number:   327558
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 23 Oct 2003 Fixed
Description
As you add arguments and save the object, memory usage, both physical and virtual, rises very quickly.



CR:327561
CR Number:   327561
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 14 Oct 2003 Fixed
Description
Date Editmask does not allow you to change a date by typing over it. This worked in PB 7 and PB 8.



CR:327564
CR Number:   327564
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ISUG Enhancement Request e15_058 - Enhance the SCC API (PVCS) Interface in PB.



In PB 6.5, the Library Painter interface to SCC API (PVCS) is very poor. We would like the following enhancements : (a) It must display all revisions of all objects directly in the Library Painter (similar to the interface used by PVCS Client s/w) and it must be possible to select any revision of an oject to be used for building the EXE and PBDs. (b) The Registration Directory dialog box must provide the flexibility to choose the way the objects are listed (for e.g, alphabetical, librarywise, etc.). (c) Provide the facility to assign Version Labels to Tip and Previous revisions of an object. Currently, this has to be done thru the PVCS interface only.
Review Status
 Reviewed by PB Engineering - ISUG Rating:

"P" Planned for a next release.



CR:327624
CR Number:   327624
Product Name:   PB Enterprise
Product Component:   Pipeline Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0 21 Nov 2006 Fixed
Description
After editing sql syntax in syntax mode at pipeline , next time viewing the sql syntax ,

the sql statement are shown in long one line
Workaround Description
 Convert to graphics before returning to pipeline painter

Or once formatting is lost go back to SQL and click Convert to graphics followed by convert to syntax



CR:327646
CR Number:   327646
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 15 Oct 2003 Fixed
Description
Used the date editmask dd/mmm/yy.



If you type in 31 in the day portion (dd) and then type in the character A, PB8 correctly sets the month field (mmm) to AUG, but PB9 does not allow you to type in anything (probably because APR is the first month beginning with A and it does not have 31 days).



Alternatively, if you type in 31 in the day portion (dd) and then type in the characters JU, PB8 correctly sets the month field (mmm) to JUL, but in PB9 you will end up with the month part being DEC (here again JUN is the first month starting with JU and it does not have 31 days).



To see this behavior you can use either an editmask control on a window with date mask dd/mmm/yy or you can use an external datawindow with a date column having the editmask dd/mmm/yy.



CR:327688
CR Number:   327688
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2005 Duplicate
Description
A Delete of a row in a table with a delete trigger fails if connected by OLE DB.



This is a duplicate of CR 354030.



CR:327774
CR Number:   327774
Product Name:   PB Enterprise
Product Component:   DB ODBC
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2003 Duplicate
Description
It seems that PB Component fail to make connection with File DSN ODBC. Howerver , two-tier PB application can successfully make the File DSN connection using similar code.
Workaround Description
 use System DSN or User DSN instead of File DSN.



CR:327810
CR Number:   327810
Product Name:   PB Enterprise
Product Component:   DW - Runtime
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jul 2005 Fixed
25 Jan 2006 Not a Bug
Description
Cannot Modify the UpdateWhereClause property of a column if not part of the Control list of the Datawindow.



Workaround: exclude the column from the Where Clause in the datawindow painter, using the Update Specifications dialog.



CR:327915
CR Number:   327915
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 18 Sep 2003 Fixed
08 Oct 2003 Fixed
Description
Edit mask regression starting in build PB 9 build 6096. Highlighted values are not overwritten.See the follwing szenario: Using editmask '##0.00' on a decimal(2) column.



Expected behaviour:

If the user tabs into the column (existing value not highlighted) and enter 1, the result is 10.00.

If the user double clicks the column (existing value highlighted) and enter 1, the result is 1.00.



Problem behaviour: IN PB 9 newer builds:

It makes no difference if the existing value is highlighted, the result is always 10.00



CR:328067
CR Number:   328067
Product Name:   PB Enterprise
Product Component:   DB Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.3 18 Sep 2003 Fixed
Description
GRANT EXECUTE ON sp_proc statement in PB ISQL pane, results in syntax error.



CR:328092
CR Number:   328092
Product Name:   PB Enterprise
Product Component:   DW Expression
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 17 Nov 2003 Fixed
Description
Regression: DW column color expression with global function call is a slow performer in build 6531. No problems in build 5507



CR:328196
CR Number:   328196
Product Name:   PB Enterprise
Product Component:   Window - Runtime
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
PB 8: Customer wants to select treeview by typing keys (Autosearch functionality), Example: if user types Sym1, treeviewitem with lable Sym1 gets selected but if label has space in it, search fails. Example: if treeview has "Sym 1","Sym 2","Sym 3" and he type "Sym 3", "Sym 3" doesn't get selected.



This worked using PB 6.5 but does not work with PB7 or greater. This may be controlled by the Microsoft treeview control, and it may not be possible to fix in PowerBuilder 8.



04/25/2005:

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release". This change is due to using the Microsoft Treeview control and cannot be controlled within PowerBuilder.



CR:328202
CR Number:   328202
Product Name:   PB Enterprise
Product Component:   P-Code Exe Creation
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2003 Fixed
23 Oct 2003 Fixed
Description
PB 9.0.1 RC - Build Runtime Library of PBD with incremental build doesn't work.



CR:328321
CR Number:   328321
Product Name:   PB Enterprise
Product Component:   Source Control
Status:   Open
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement Request:

If the target is added to source control there is no ability to scroll the library list when there are more PBLs then the window's size and without disconnect SCC.

In PB8 and PB9 you only can scroll the if you check out the target file.

The scrollbar is not grayed and suggest that you can scroll through the library list.



CR:329075
CR Number:   329075
Product Name:   PB Enterprise
Product Component:   DB OLE DB
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10.2.1 18 Jan 2006 Fixed
Description
Asking customer to use SQLOLEDB rather than MSS (255 char limit) and getting new issue:

select * from tableA where id = "b" gives error: Invalid column name 'b'. No problem if single quotes are used instead of double quotes.

The workaround:

execute immediate "set quoted_identifier off" using sqlca;

This doesn't apply to design time, only runtime.



25 - April - 2005:

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release".



CR:329119
CR Number:   329119
Product Name:   PB Enterprise
Product Component:   UO Painter
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 22 Oct 2003 Fixed
Description
In app migrated to 9.0 from 6.5, closing a userobject in the painter crashes PB.



CR:329210
CR Number:   329210
Product Name:   PB Enterprise
Product Component:   Script Painter
Status:   Closed
OS:   MS Windows NT 4.0
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 16 Mar 2004 Fixed
Description
In PowerBuilder 9 the script painter has a memory leak so

that memory is not released when objects are closed.



In PowerBuilder 8 no such memory leak was experienced.



CR:329230
CR Number:   329230
Product Name:   PB Enterprise
Product Component:   DW Edit Mask
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   9.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
9.0.1 08 Oct 2003 Duplicate
Description
DW Edit Mask ##0.00, behaves diff in PB 9 than in PB 7.0.3 / 8.0.



CR:329464
CR Number:   329464
Product Name:   PB Enterprise
Product Component:   Edit Mask
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   9.0.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8.0.4 17 Sep 2003 Fixed
8.0.4 14 Oct 2003 Fixed
Description
A editmask defined as !!-!!-!!-!!-!!-!! and format=[General] will add an extra hyphen when you tab out of the field.



The problem appears to happen a new row is inserted and a value from a previous row

is placed in this field and then you modify it. A value is added to this field by setitem(). Once you tab out, it will appear as:

B -A -AH-AC---



Instead of

B -A -AH-AB--



Customer does have the following workaround in the wf_getdetailrowitems and the

itemchanged event of dw_1 of w_program_view.

wf_getdetailrowitems:



dw_1.AcceptText()

d_group_code = dw_1.getitemstring(l_row, 'group_code')

if pos(d_group_code, '-') > 0 then

do until pos(d_group_code, '-') = 0

d_group_code = replace(d_group_code, pos(d_group_code, '-'), 1, '')

loop

dw_1.setitem(l_row, 'group_code',d_group_code)

dw_1.accepttext()

end if

//d_group_code = dw_1.getitemstring(l_row, 'group_code')





w_program_view/dw_1/itemchanged event:

string ls_chg

string ls

if lower(dwo.name) = 'group_code' then

ls_chg = data

do until pos(ls_chg, '-') = 0

ls_chg = replace(ls_chg, pos(ls_chg, '-'), 1, '')

loop

if ls_chg <> data then

post setitem(row, dwo.name, ls_chg)

post accepttext()

end if

end if



CR:329482
CR Number:   329482
Product Name:   PocketBuilder
Product Component:   Window - Runtime
Status:   Closed
OS:   Pocket PC 2002
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2003 Fixed
Description
On the PDA the PointerX() and PointerY() functions return goofy numbers.



Created a window with a couple buttons and a listbox for results.

Each button and the window...

The "clicked" event log the:

int ptrX, ptrY

ptrX = this.PointerX()

ptrY = this.PointerY()

..log..

ptrX = parent.PointerX()

ptrY = parent.PointerY()

..log parent coords..



Get really goofy numbers for the X & Y pos.



CR:329539
CR Number:   329539
Product Name:   PB Enterprise
Product Component:   DB Oracle
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   8.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 May 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
When retrieving an Oracle LONG column (used to store binary character data) that is large (>32k) via the Oracle O84 driver, PB reports a "Select Error:" in a messagebox.

Happens eg. in the DW or DB Painter.
Review Status
 This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release". Also not reproduceable anymore.





--------------------------------------华丽的分割线-------------------------------------------------------------------------

Sybase SQL Anywhere数据库恢复工具ReadASADB:

之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具: ReadASADB。
此工具支持ASA v5.0, v6.0, v7.0, v8.0, v9.0, v10.0, v11.0, v12.0, v16.0, v17.0等版本。
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具。
恢复Sybase SQL Anywhere的工具在国内处于领先水平。

Sybase SQL Anywhere数据库恢复工具ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具
  1. 适用于所有的SQL Anywhere版本    包括:5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x,16.x,17.x
  2. 适用于所有的UltraLite版本
  3. 能够恢复出来表结构和数据
  4. 能够恢复自定义数据类型
  5. 能够恢复存储过程等对象的语法
  6. 能够导出到目标数据库
  7. 能够导出到SQL文件并生成导入脚本
  8. 支持多种字符集,包括:cp850、cp936、gb18030、utf8等
  9. 能够恢复未加密或者简单加密类型的数据
  10. 简单易用
  11. 限制:不支持AES加密的数据文件
请参考:研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
            SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

Sybase SQL Anywhere数据库恢复工具ReadASADB适用场景

各种误操作:

  1. 误截断表(truncate table)
  2. 误删除表(drop table)
  3. 错误的where条件误删数据
  4. 误删除db或log文件
  5. 误删除表中的字段

Sybase SQL Anywhere数据库恢复工具ReadASADB的应用场景:

1.因为物理磁盘故障、操作系统、系统软件方面或者掉电等等原因导致的Sybase SQL Anywhere数据库无法打开的情况;
2.误操作,包括truncate table,drop table,不正确的where条件导致的误删除等;
Sybase SQL Anywhere无法打开时,比较常见的错误是:Assertion failed。
如:
1、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Checkpoint log: invalid bitmap page -- transaction rolled back
2、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Page number on page does not match page requested -- transaction rolled back
3、Internal database error *** ERROR *** Assertion failed:200502 (9.0.2.2451) Checksum failure on page 23 -- transaction rolled back
4、File is shorter than expected
5、Internal database error *** ERROR *** Assertion failed: 201116 Invalid free list index page found while processing checkpoint log -- transaction rolled back
6、*** ERROR *** Assertion failed: 51901 Page for requested record not a table page or record not present on page
7、*** ERROR *** Assertion failed: 201417 (7.0.4.3541) Invalid count or free space offset detected on a table page
8、Internal database error *** ERROR *** Assertion failed: 201425 (8.0.3.5594) Invalid count or free space offset detected on a free list page -- transaction rolled back.
9、Internal database error *** ERROR *** Assertion failed: 100702 (8.0.1.2600) Unable to modify indexes for a row referenced in rollback log -- transaction rolled back


-------------------------------------------------------------------------------------------

Sybase ASE数据库恢复工具READSYBDEVICE:

一个不依赖数据库管理系统、直接从Sybase数据库设备文件上提取数据的业内领先的恢复工具!
能够从损坏的Sybase ASE设备文件(.dat)上提取数据的非常规恢复工具。

Sybase ASE数据库恢复工具READSYBDEVICE的主要功能:

  1. 被勒索病毒加密数据文件及备份文件情况下的恢复;
  2. 系统崩溃只剩下数据文件的情况下的恢复,甚至数据库文件不存在而只有损坏的备份文件情况下的恢复;
  3. 因断电、硬盘坏道等造成数据库文件损坏情况下的恢复;
  4. delete数据恢复、误update数据恢复、误删除表(drop)恢复、误truncate表恢复 等;
  5. 各种Sybase内部系统表损坏、索引错误的修复;
  6. master数据库损坏而无法正常运行情况下的恢复;
  7. Sybase数据库被标记为可疑,不可用等情况的恢复;
  8. Sybase数据库中数据文件内部出现坏块情况下的恢复;
  9. Sybase数据库无数据文件但有日志文件的情况下的恢复;
  10. Sybase数据库只有数据文件无任何日志文件的情况下的恢复;
  11. Sybase数据文件被误删除情况下的碎片提取恢复;
  12. 磁盘阵列上的Sybase数据库被误格式化情况下的数据库恢复;
  13. 数据库sysobjects等系统表损坏无法正常应用情况下的恢复;
  14. Sybase数据库还原数据库出现失败情况下的恢复;
  15. Sybase数据库只剩下损坏的备份文件情况下的恢复。

Sybase ASE数据库恢复工具READSYBDEVICE支持的版本:

Sybase ASE 11.0.x,11.5.x,11.9.x,12.0.x,12.5.x,15.0.x,15.5.x,15.7.x,16.0.x


-------------------------------------------------------------------------------------------

SQL Server数据库恢复工具SQLRescue:

一个不依赖数据库管理系统、直接从SQL Server数据库文件上提取数据的业内领先的恢复工具!
能够从损坏的SQL Server数据库文件(.mdf)上提取数据的非常规恢复工具。

SQL Server数据库恢复工具SQLRescue的主要功能:

  1. 系统崩溃只剩下数据文件的情况下的恢复,即无日志文件或者日志文件损坏情况下的恢复;
  2. 断电导致数据库文件损坏情况下的恢复;
  3. 硬盘坏道造成数据库损坏情况下的恢复;
  4. 数据文件内部存在坏页情况下的恢复;
  5. 企业管理器误删除数据表记录,管理软件误删除数据表记录的恢复;
  6. 并闩锁错误、格式化、误删除后导致软件不能使用的情况;
  7. 无法读取并闩锁页sysindexes失败情况下的修复;
  8. 数据文件被误删除情况下的碎片提取恢复;
  9. 系统表损坏、索引错误、误删除数据库表、删除记录的数据找回;
  10. master数据库损坏而无法正常运行情况下的恢复;
  11. 数据文件无法附加情况下的数据恢复;
  12. 数据库被标记为可疑,质疑,不可用等情况的恢复;
  13. 数据库sysobjects等系统表损坏情况下的恢复;
  14. 数据被误(drop、delete、truncate)删除表数据的恢复,误update后的数据恢复等;
  15. 还原时报一致性错误,错误823等情况下的数据恢复,各种错误提示的数据库文件修复;
  16. 数据库被误格式化等情况下的数据库恢复;
  17. 日志收缩造成数据库损坏情况下的恢复;
  18. 仅剩损坏的备份文件情况下的恢复。

SQL Server数据库恢复工具SQLRescue技术特点:

只要SQL Server数据库的数据文件存在,我们就有办法帮您从数据文件中找回重要数据。
  1. 从数据文件中直接恢复数据
  2. 不能附加时直接恢复数据并生成新的数据库
  3. 系统表损坏的数据库修复
  4. 快速修复SQL 823错误、连接中断错误

SQL Server数据库恢复工具SQLRescue支持的版本:

Microsoft SQL Server 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017,2019。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------