随着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:490836
|
|
490836 |
|
PB Enterprise |
|
DW - Runtime |
|
|
|
|
|
|
|
The customer is creating a crosstab datawindow dynamically with dw.Create using the SyntaxFromSQL. It creates the crosstab successfully. But if he repeats the exact same code to create the same datawindow again, PB 11.1 crashes. In PB 10.5 there is no crash second, third, or more times around.
3/10/2008: This issue is fixed. The fix is available in PB 11.1 build 8218 and later. |
|
|
|
CR:490858
|
|
490858 |
|
PB Enterprise |
|
DB Painter |
|
|
|
|
|
|
|
Error during 'New Table' create using Specific Kanji columns name. |
|
Target Version |
|
11.1 |
|
Workaround Description |
|
W/A : Using other database utility. |
|
|
|
CR:490859
|
|
490859 |
|
PB Enterprise |
|
DB Painter |
|
|
|
|
|
|
|
Error during 'Table Name' uses specific Kanji table name. |
|
Workaround Description |
|
W/A : Using other database utility. |
|
|
|
CR:490884
|
|
490884 |
|
PB Enterprise |
|
DB Informix |
|
|
|
|
|
|
|
When trying to create a datawindow from a stored
procedure as the datasource, the following error will occur if the input arguments
are on different lines or have tabs within them:
DataWindow Wizard
Cannot create DataWindow.
'SQL Error -201: A syntax error has occurred
1 execute tsmaint.accm_test3;0 =:a, =: , =: , =: ' |
|
|
|
CR:490901
|
|
490901 |
|
PB Enterprise |
|
DW SaveAs |
|
|
|
|
|
|
|
Excel 2003 (excel 8) had a row limit of 65536 and
a column limit of 256.
Excel 2007 and higher has a greater row limit and column limit as per:
http://office.microsoft.com/en-us/excel/HP100738491033.aspx?pid=CH101030621033
Currently in the dwrxls.cpp, it is set to 65535:
// check the row-count against Excel's worksheet limit
if (rowCount > 65535)
return rc; |
|
|
|
CR:490907
|
|
490907 |
|
PB Enterprise |
|
PB.NET WS Deployment |
|
|
|
|
|
|
|
Assemblies created with PB 11 get a wrong LibraryList when called from a VisualStudio WebService. Calling the assembly from a normal VisualStudio WinForm application works fine. |
|
Workaround Description |
|
- Suggested workaround to customer:
1. Copy the PBD to where the web service is expecting it
2. Change the LibraryList dynamically. |
|
|
|
CR:490911
|
|
490911 |
|
PB Enterprise |
|
DB MS SQLServer |
|
|
|
|
|
|
|
The header name for column aliases that inlcude periods are a problem with SNC. Works fine with ODBC and also in SQLServer Query Analyzer. For example the following SQL:
SELECT department.dept_id "Department.ID",
department.dept_name "Department.Name",
department.dept_head_id "Department.Head.ID"
FROM department
produces column headers of "ID" instead of "Department.ID", "Name" instead of "Department.Name" and "ID" again instead of "Department.Head.ID". Only the data after the last period survives. If the period is the last character you get nothing for a header name.
This used to work fine in older PB ersions using MSS. It works fine in PB 11 using ODBC, and also works in SQLServer Query Analyzer. OLE DB however behaves the same as SNC.
The customer also complains of a similar problem with hyphens. In this case the hyphen is replaced by a space. And ODBC behaves the same in this case. |
|
|
|
CR:490924
|
|
490924 |
|
PB Enterprise |
|
PB.NET WebForm |
|
|
|
|
|
|
|
When compiling a webform that has the following line of
code: message.To.Add(toAddress), results in the following error:
c:\pse\pse-11\11420389\smtpweb.pbl(w_test).cb_1.clicked.14 C0327: The best overloaded method match for 'system.net.mail.mailaddresscollection.add(string)' has some invalid arguments. |
|
Workaround Description |
|
Use the following instead:
message = create @System.Net.Mail.MailMessage(fromAddress, toAddress) |
|
|
|
CR:490931
|
|
490931 |
|
PB Enterprise |
|
Machine Code Deployment |
|
|
|
|
|
|
|
Customer would like us to add a digital signature to our PB EXEs.
When we run all our PowerBuilder Applications, the following security Warning message pops up:
"The publisher could not be verified. Are you sure you want to run this software?"
"This File does not have a valid digital signature that verifies its publisher. You should only run software from publishers you trust."
This warning message pops up after installing IE7 (Internet Explorer 7). With IE6 was not any warning message. Although there is inherently nothing wrong with this warning message. Clicking on "Run" will allow you to continue, but we have hundreds of users and this new message will confuse them. Could you please add a 'valid digital signature' on PowerBuilder executables to get rid of this annoying message with IE7? |
|
|
|
CR:490992
|
|
490992 |
|
PB Enterprise |
|
DW - Runtime |
|
|
|
|
|
|
|
The Key Event KeyDecimal is not triggered in a DataWindow when using the comma key on the numeric key pad. German regional settings. |
|
Workaround Description |
|
use Editchanged event with KeyDown(keydecimal!). |
|
|
|
CR:490995
|
|
490995 |
|
PB Enterprise |
|
PB.NET WebForm |
|
|
|
|
|
|
|
Dataobject property not set for a datastore by SetFullState function |
|
|
|
CR:491073
|
|
491073 |
|
PB Enterprise |
|
DB Painter |
|
|
|
|
|
|
|
When the attribute of DB Painter is changed, PB11.1 crashes. |
|
|
|
CR:491093
|
|
491093 |
|
PB Enterprise |
|
PB.NET WinForm |
|
|
|
|
|
|
|
When using a Declare and Execute statement and the
parameter is populated after the declare statement, the parameter is not passed to the
execute statement.
For example, the following script:
DECLARE myproc PROCEDURE FOR bug_test1
@ls_string = :ls_val
USINg SQLCA;
ls_val ="aaaa"
Execute myproc ;
Will return the following in the dbtrace log:
execute bug_test1 @ls_string = '' (DBI_RUNTIME_EXECUTE)
But if you execute:
ls_val ="aaaa"
DECLARE myproc PROCEDURE FOR bug_test1
@ls_string = :ls_val
USINg SQLCA;
Execute myproc ;
The following will result in the db trace log:
execute bug_test1 @ls_string = 'aaaa' (DBI_RUNTIME_EXECUTE) |
|
|
|
CR:491094
|
|
491094 |
|
PB Enterprise |
|
PB.NET WinForm |
|
|
|
|
|
|
|
Winform response window usng "close with return" is leaking memory.
Winform application is using Openwithparm and Closewithreturn. When using a structure this is causes a memory leak in the winform environment.
The memory leak (Private Bytes) can be seen using performance monitor when running the winform test applcation. |
|
|
|
CR:491172
|
|
491172 |
|
PB Enterprise |
|
DataBase |
|
|
|
|
|
|
|
|
10.5.1 |
|
07 Apr 2008 |
Fixed |
|
|
|
24 Mar 2008 |
Not a Bug |
|
|
|
|
|
Calling a database function from PB as an RPC call is returning a value of 0 for a long return value that is set to null in the database function. Happens in ASA (ODBC) and MS SQL Server (OLE DB). |
|
|
|
CR:491184
|
|
491184 |
|
PB Enterprise |
|
MTS Integration |
|
|
|
|
|
|
|
|
|
|
29 Jul 2008 |
Fixed |
|
|
|
16 Nov 2009 |
Fixed |
|
|
|
|
|
OS: Windows XP SP2
Versions and Build #s Tested: PB 10.5.2_7562 and 10.5.2_7599
Database/Driver File/Version: ODBC, using MS SQL Server 2000
Comments: In runtime, when executing multiple instances of a PB application that invokes a PB COM+ component, the performance slows down and sometimes applications never finish.
Issue does not happen when only one instance is executed, instead. Customer tried increasing COM+ pool and recycling inside Component Services, but this affected applications when working with 2 or 3 users at same time and this could not be used as workaround. |
|
|
|
CR:491189
|
|
491189 |
|
PB Enterprise |
|
DW - Runtime |
|
|
Closed |
|
Windows XP |
|
11.0 RC |
|
|
|
|
|
|
DW filter is removing rows when those rows should have
been displayed in the dw control.
Works ok in PB 10.2.1 (build 9891). Works ok in PB 10.5 up to build 5033.
Problem started happenning in PB 10.5 (build 5034). May be a regression of cr426357. |
|
Workaround Description |
|
Reset the buffers:
dw_2.setfilter(" ")
dw_2.filter() |
|
|
|
CR:491199
|
|
491199 |
|
PB Enterprise |
|
Jaguar Integration |
|
|
|
|
|
|
|
|
|
|
03 Nov 2008 |
Insufficient info provided |
|
|
|
|
|
EAServer hangs when calling PB components
under stress test.
Problem possibly could be at:
oci!OCIDescriptorAlloc+0x33
pbo90105!CPBOCI::OCIDescriptorAlloc(void * parenth = <Memory access error>, void ** descpp = <Memory access error>, unsigned int type = <Memory access error>, unsigned int xtramem_sz = <Memory access error>, void ** usrmempp = <Memory access error>)+0x1c
pbo90105!Ora_DoSelectBind(struct DBI_Command * lpCommandPtr = <Memory access error>)+0x396
pbo90105!PB_DB_Rout(struct DBI_Command * lpCommandPtr = 0x3f46a3d0)+0xc96
PBSHR105!DBI_Execute(struct DBI_Command * pCommandBlock = 0x00000000, int bBind = 1154120232, unsigned short * lpszCommandBuffer = 0x3d769438)+0x2c
PBDWE105!dwGetExceedPageMessage+0xebf
PBDWE105!CreateXHTMLTemplate+0xded7
and
oci!OCIStmtPrepare+0x36
pbo90105!CPBOCI::OCIStmtPrepare(struct OCIStmt * stmtp = <Memory access error>, struct OCIError * errhp = <Memory access error>, unsigned char * stmt = <Memory access error>, unsigned int stmt_len = <Memory access error>, unsigned int language = <Memory access error>, unsigned int mode = <Memory access error>)+0x21
pbo90105!Ora_DoCompile(struct DBI_Command * lpCommandPtr = <Memory access error>, int bUseSQLCache = <Memory access error>)+0x5e0
pbo90105!PB_DB_Rout(struct DBI_Command * lpCommandPtr = <Memory access error>)+0x107e
PBSHR105!SQLST_RemoveComments(unsigned short * lpStrSQL = 0x000004e4, unsigned short * lpStrOut = 0x000004e4, unsigned long nBufLen = 0)+0x36
PBDWE105!CreateXHTMLTemplate+0xded7
PBDWE105!dwGetExceedPageMessage+0x18ee
RESOLUTION: No contact from customer |
|
|
|
CR:491266
|
|
491266 |
|
PB Enterprise |
|
PB Web Services |
|
|
|
|
|
|
|
Customer receives the following error when trying to call web service method with complex datatype
Error: The definition of the method signature in Web Service proxy is wrong. |
|
|
|
CR:491493
|
|
491493 |
|
PB Enterprise |
|
PB.NET WebForm |
|
|
|
|
|
|
|
Wants a new argument to close UpLoadfiles function after first upload. |
|
Workaround Description |
|
In pbuploadfile.aspx, remove the button 'Close' by deleting the HTML line :
<pb:WebInternalButton text="Close" onclientclick="javascript:closeIt(this.form);return false;" runat="server" />
and for the 'Upload' button change its OnClick javascript as this :
onclientclick= "checkFile(this.form);closeIt(this.form)" |
|
|
|
CR:491495
|
|
491495 |
|
PB Enterprise |
|
DB Informix |
|
|
|
|
|
|
|
The DataWindow Painter can crash after changing the select statement and returning
to design if the XHTML view is open or there is an XHTML template.
Database interface used is Informix In9. |
|
|
|
CR:491513
|
|
491513 |
|
PB Enterprise |
|
DW - Runtime |
|
|
|
|
|
|
|
The customer has a dw column with "empty string is null" checked. They are trying to have the initial value of the column be an empty string. How do they do this? They have code like this in the dw constructor:
this.object.colname.initial = "empty"
The string "empty" appears to be special and have a special meaning in this context. It does not display as the initial value. The initial value in the case appears to be blank or a real empty string. But the column is not null even when "empty string is null" is checked. So it is not acting as an empty string should even though it looks empty. (Personally I think allowing the string "empty" to set the initial value as an empty string is the silliest convention one could come up with. I see no documentation on this. So the question to Engineering then, is this supposed to work? If so then make it act like an empty string and be null if "empty string is null" is checked. If not get rid of it. A string is a string even if it is "empty".
The way it should work is to set the initial value to a real empty string like:
this.object.colname.initial = ""
But this behaves the same way. It seems like an empty string, but it is not null even when "empty string is null" is checked. Please fix this. |
|
|
|
CR:491530
|
|
491530 |
|
PB Enterprise |
|
DB MS SQLServer |
|
|
|
|
|
|
|
When connected to MSSQL2005 using SNC and the dbparm of
BindSPInput=1 is set, PB fails when returning an output variable of type real.
It works ok when the app returns an output variable of type decimal. App also
works ok for real and decimal using MSS2000 and SNC and bindSPInput=1.
App is using the DynamicDescriptionArea and the DynamicStagingArea. |
|
|
|
CR:491614
|
|
491614 |
|
PocketBuilder |
|
DB ODBC |
|
|
Open |
|
Windows Mobile 5 |
|
2.5 |
|
|
|
|
|
|
PKODB25.INI is missing from the CAB files used to deploy the PocketBuilder runtimes. |
|
|
|
CR:491631
|
|
491631 |
|
PocketBuilder |
|
PB GUI |
|
|
|
|
|
|
|
Found during FDCC Testing - XP only (Vista was correct)
There are a set of _mandatory_ "HKEY_CURRENT_USER" used by PocketBuilder. When the product is installed by running setup.exe and selecting "Run As Administrator" - some of the current-user specific registry keys are placed into the administrator's account rather than the true user's account.
The fix is for the IDE, not the installer.
There is no need to re-install the product to get the benefit of this change.
After this fix, PocketBuilder 2.5 passes the U.S. FDCC compliance tests for both Windows XP and Vista (as of this date). |
|
|
|
CR:491898
|
|
491898 |
|
PB Enterprise |
|
OLE - Active X - OCX |
|
|
|
|
|
|
|
|
|
|
10 Mar 2008 |
Presently Not Targeted For Any Future Release Of This Product |
|
|
|
|
|
OS: Windows XP SP2
Versions and Build #s Tested: PB 11.1_8123
Database/Driver File/Version: N/A
Comments: Running Sun ActiveX Bridge as nvo oleobject within PowerBuilder works ok for the methods, but never triggers the mapped events. From outside PB, if you use Visual Studio ActiveX Control Test Container and test the ActiveX, it will say that PropertyChange event was triggered. |
|
|
|
CR:491994
|
|
491994 |
|
PB Enterprise |
|
DB ODBC |
|
|
|
|
|
|
|
If a DataWindow in PB11 with one numeric retrieval argument, that compares with a database column of type INTERGER and error is given by the IBM iseries ODBC driver:
[IBM][iSeries Access ODBC-Treiber]Fehler bei Zuordnung. |
|
|
|
CR:492007
|
|
492007 |
|
PB Enterprise |
|
DW - Runtime |
|
|
|
|
|
|
|
datetime retrieval argument in DW cause ODBC error SQL0418 on DB2/400
Workaround: change DisableBind |
|
|
|
CR:492034
|
|
492034 |
|
PB Enterprise |
|
DW Printing |
|
|
|
|
|
|
|
Customer's datawindow report get problem after apply PB10.5.2
build 7611+2. With a specific length of data and column with AutoSize Height,
an extra empty line occur on datawindow print preview mode.
Besides, on the datawindow printout, data wrap up to cover the empty line.
Thus printout and printprview are not match. |
|
|
|
CR:492049
|
|
492049 |
|
PB Enterprise |
|
PB.NET WebForm |
|
|
|
|
|
|
|
OS: Windows XP SP2
Versions and Build #s Tested: PB 11.1_8204
Database/Driver File/Version: N/A
Comments: When distributing web form application msi onto other machines with IIS and .NET Framework, we need to manually enable ASPNET user with Full Control on base treeview dw directory so that content of treeview gets displayed.
Customer would like a way to automate this process when running msi installer instead, in case he needs to install many web form distributions for different web form projects and/or machines. |
|
|
|
CR:492062
|
|
492062 |
|
PB Enterprise |
|
Language - Runtime |
|
|
|
|
|
|
|
Sum within an Evaluate expression not returning correct result when sum is 0. Returned value is 1.387778780781446E-16 and not 0.
Seems to work for all non zero sums correctly. |
|
|
|
CR:492531
|
|
492531 |
|
PB Enterprise |
|
DB JDBC |
|
|
Closed |
|
Microsoft Windows 2000 |
|
10.5.1 |
|
|
|
|
|
|
Trying to update a BLOB Oracle column with UpdateBlob using JDBC driver results in an Oracle error like:
- ORA-01461: can bind a LONG value only for insert into a LONG column
- ORA-01465 invalid hex number |
|
|
|
CR:492548
|
|
492548 |
|
PB Enterprise |
|
Window - Runtime |
|
|
|
|
|
|
|
|
|
|
10 Mar 2008 |
Third Party Problem |
|
|
|
|
|
In an MDI frame if you open up sheets the sheets are then listed under the "Windows" menu item. Once you hit about 10 sheets only 10 sheets are listed and the last menu item becomes "More Windows". When you select more windows you get a dialog box that lists all the sheets.
But if you initially open up a sheet that is not enabled and then open up more than 10 sheets that are enabled, if you click the "More Windows" menu item and select a sheet that was not listed in the Windows menu, ie it is a greater than 10 sheet, then that sheet is not displayed as it should be, a different sheet is displayed, or the disabled sheet is displayed.
3/11/2008: Engineering determined this is a Microsoft issue. VC++ programs exibit the same behavior. |
|
|
|
CR:492556
|
|
492556 |
|
PB Enterprise |
|
Jaguar Integration |
|
|
|
|
|
|
|
|
|
|
05 Feb 2009 |
Consult Complete |
|
|
|
|
|
Request Engineering to analyze a PBVM crash dump within EAServer for California Courts in their production application. From the dump it seems that the crash happened in Oracle Client dll: oraclient10.dll. |
|
|
|
CR:492566
|
|
492566 |
|
PB Enterprise |
|
PB.NET WebForm |
|
|
|
|
|
|
|
Columns in a datawindow do not display correctly in WebForms. A raised border column with an Edit Style of 3D RadioButton does not have white background in the circles. Also the text and circles could be centered better. Columns with a lowered border and an Edit Style of Edit do not appear lowered at all, but have a blue outline. A groupbox on a window is larger in webforms and runs into other controls. A horizontal scroll bar does not display on a datawindow. And the initial highlight of a dddw column in a datawindow is not highlighted in webforms. |
|
|
|
CR:492621
|
|
492621 |
|
PB Enterprise |
|
DW - Runtime |
|
|
|
|
|
|
|
SQL query has a where condition with subselect with union. Cause SQL0255 'Function not supported for query'
workaround is to change disablebind. |
|
Workaround Description |
|
change disablebind |
|
|
|
CR:492661
|
|
492661 |
|
PB Enterprise |
|
DB MS SQLServer |
|
|
|
|
|
|
|
MS SQL Server 2005 using the SNC PB driver. A datawindow query with a large number (16) of joins crashes PB11. The same query works OK in ASA (ODBC):
SELECT Atable.ColumnA,
Atable.ColumnB,
B1.ColumnA,
B1.ColumnB
FROM Atable
JOIN Btable B1 ON Atable.ColumnA = B1.ColumnA
JOIN Btable B2 ON Atable.ColumnA = B2.ColumnA
JOIN Btable B3 ON Atable.ColumnA = B3.ColumnA
JOIN Btable B4 ON Atable.ColumnA = B4.ColumnA
JOIN Btable B5 ON Atable.ColumnA = B5.ColumnA
JOIN Btable B6 ON Atable.ColumnA = B6.ColumnA
JOIN Btable B7 ON Atable.ColumnA = B7.ColumnA
JOIN Btable B8 ON Atable.ColumnA = B8.ColumnA
JOIN Btable B9 ON Atable.ColumnA = B9.ColumnA
JOIN Btable B10 ON Atable.ColumnA = B10.ColumnA
JOIN Btable B11 ON Atable.ColumnA = B11.ColumnA
JOIN Btable B12 ON Atable.ColumnA = B12.ColumnA
JOIN Btable B13 ON Atable.ColumnA = B13.ColumnA
JOIN Btable B14 ON Atable.ColumnA = B14.ColumnA
JOIN Btable B15 ON Atable.ColumnA = B15.ColumnA
JOIN Btable B16 ON Atable.ColumnA = B16.ColumnA
WHERE 1 = 1 |
|
|
|
CR:492689
|
|
492689 |
|
PB Enterprise |
|
Rich Text |
|
|
|
|
|
|
|
An RTE.copyrtf() function is leaking memory. In a loop it's a very bad leak increasing rapidly to a point where you crash. |
|
|
|
CR:492763
|
|
492763 |
|
PB Enterprise |
|
DB ADO.NET |
|
|
|
|
|
|
|
Request to include support for Informix in our ado.net DBMS driver.
Currently .Net dataproviders for ASE, Oracle and SQL Server are supported
Table 5-1 in the Connecting to your Database manual of PowerBuilder 11.1 |
|
|
|
CR:492797
|
|
492797 |
|
PB Enterprise |
|
DB Oracle |
|
|
|
|
|
|
|
The customer has an application that connects to Oracle and it runs 24 hours a day. One of the requirements of this application is if the network goes down or the database isn't available, his powerbuilder app will try to do a reconnect every 30 seconds until in connects successfully agian. Sometimes at night or over the weekend, the database goes down and stays down. His app keeps trying to re-connect every 30 seconds. When this happens there is a memory leak and eventually the PB app crashes.
3/10/2008: This issue is fixed. The fix is available in PB 11.1 build 8218 and after, and PB 11.2 build 8509 and after. |
|
|
|
CR:492806
|
|
492806 |
|
PB Enterprise |
|
Debugger |
|
|
|
|
|
|
|
Team Sybase reports that in the debugger the bubble help not displaying in the source pane when you hover the cursor over a variable in the script if the variable name contains a "#". Variable names without "#" in them display the bubble help showing the contents of the variable when you hover over it.
Team Sybase also claims that in PB 11.2 variables with a "#" in their names are not displayed properly in variable panes. For example the variable 'ls_y#' is displayed as 'ls_y_u0023_'. |
|
|
|
CR:492844
|
|
492844 |
|
PB Enterprise |
|
Documentation |
|
|
|
|
|
|
|
PB does not provide the option which rewrites dw object in a PrintPage event. |
|
|
|
CR:492911
|
|
492911 |
|
PB Enterprise |
|
DW - Runtime |
|
|
|
|
|
|
|
PB crashes after calling ShareDataOff and then setfilter. |
|
|
|
CR:493009
|
|
493009 |
|
PB Enterprise |
|
Window - Runtime |
|
|
|
|
|
|
|
|
|
|
07 Aug 2008 |
Fixed |
|
|
|
22 Jul 2008 |
Fixed |
|
|
|
|
|
When a variable or an object new in an ancestor window after changing the code of a descendant window has been located, PB cannot open a descendant window. This issue causes GPF. The Workspace cannot be re-opened after GPF occurs. |
|
|
|
CR:493051
|
|
493051 |
|
PB Enterprise |
|
PB.NET WebForm |
|
|
|
|
|
|
|
OS: Windows XP SP2
Versions and Build #s Tested: PB 11.1_8123
Database/Driver File/Version: O90 connecting to Oracle 10g, using Oracle 10.1.0 client
IIS 5.1
.NET Framework 2.0.50727.42
Comments: When trying to connect to Oracle database via O90 from within webforms, we always get the error "Oracle library OCI.dll could not be loaded". |
|
|
|
CR:493055
|
|
493055 |
|
PB Enterprise |
|
PB.NET WebForm |
|
|
|
|
|
|
|
OS: Windows XP SP2
Versions and Build #s Tested: PB 11.1_8123
Database/Driver File/Version: N/A
IIS 5.1
.NET Framework 2.0.50727.42
Comments: Issue reproduced in a treeview DataWindow with a Checkbox for each level-2 Node. When it's used on the WinForm, if they select one or more Checkboxes inside Node 1, for example, and then clicks to display the content of Node 2, the content is displayed as expected, and all modifications are kept. When it's used on the WebForm, as soon as you click Node 2 its content is displayed, but any modification made to Node 1 is undone. |
|
|
|
CR:493066
|
|
493066 |
|
PB Enterprise |
|
Rich Text |
|
|
|
|
|
|
|
The rte.InputFieldLocate funtion locates an input field in a RichTextEdit control. It returns a string with the name of the input field if it succeeds. InputFieldLocate returns an empty string if no matching input field is found or if an error occurs. However in the latter case the returned string appears to be an empty string, but if you do a len() on the string you get a -1! Worse, and probably caused by the -1, if you do a Trim() on that string, PB crashes.
03/17/2008: Fixed in PB 10.5.2 build 7640 and after. |
|
|
|
CR:493087
|
|
493087 |
|
PB Enterprise |
|
PB.NET WinForm |
|
|
|
|
|
|
|
A tab control with a two lines on the tab displays incorrectly when deployed as a winform. Only the first line of the tab's legend text displays. Customer claims in PB 11.2 build 8407 that the Tahoma font is displayed too large.
Webform and win32 both display both lines of the tab's legend text. |
|
|
|
CR:493165
|
|
493165 |
|
PB Enterprise |
|
DW - Runtime |
|
|
|
|
|
|
|
The datawindow datawindow.syntax property reports other values then the edit source in IDE. Some properties like hidegreyline and backgroundcolorxp are not there, but in the syntax there is eg. a property selected.mouse=no that is not in edit source. |
|
|
|
CR:493209
|
|
493209 |
|
PB Enterprise |
|
Jaguar Integration |
|
|
|
|
|
|
|
Milliseconds of current time within PB comp are not available in Solaris. Works fine in Windows environment.
When you run the testcase , you would see following in EAServer log :
Solaris :
**********
2008-03-03 09:48:28.086 INFO btpool0-2 [JaguarServer] Begin :09:48:28:000 <---- Milliseconds part is 000
2008-03-03 09:48:28.087 INFO btpool0-2 [JaguarServer] From Function of_test
2008-03-03 09:48:28.087 INFO btpool0-2 [JaguarServer] End :09:48:28:000 <---- Milliseconds part is 000
Windows :
***********
2008-03-03 10:04:41.595 INFO btpool0-2 [JaguarServer] Begin :10:04:41:595 <--- Valid Milliseconds
2008-03-03 10:04:41.595 INFO btpool0-2 [JaguarServer] From Function of_test
2008-03-03 10:04:41.595 INFO btpool0-2 [JaguarServer] End :10:04:41:595 |
|
|
|
CR:493302
|
|
493302 |
|
PB Enterprise |
|
DW - Runtime |
|
|
|
|
|
|
|
Cannot edit data on Treeview DWs when 1st row is not collapsed
no Workaround |
|
|
|
CR:493319
|
|
493319 |
|
PB Enterprise |
|
DW Display |
|
|
|
|
|
|
|
The datawindow detail band is set to autosize height. There are 2 computed fields in the detail band. On top is a computed field with the following expression:
if(getrow() = min(getrow() for page), title, "")
This is intended to only show the title column for the first row on the page. Directly below the first computed field is the second that shows a detail row. Both computed fields are slide up all above and autosize height. The intention is to display a title column at the top of the page for the first row, then first row data underneath. Then for the rest of the rows on the page, no title displayed, only row data, with the row data sliding up because the title is blank. When it displays, the first row is correct with the title and the data, but all other rows have a blank space where the title would be, and the row data does not slide up as expected leaving this large space between the row data. I have tried other ways to do the same thing for example the following expression for the title computed field height:
if(getrow() = min(getrow() for page), 77, 0)
But it has the same results. I suspect that the aggregate function is the cause in that when the datawindow engine is determining what each row should look like, the aggregate function is not known, so the expression doesn't evaluate properly. It's a Catch 22.
So the question is, can this be fixed? |
|
|
|
CR:493334
|
|
493334 |
|
PB Enterprise |
|
Window - Runtime |
|
|
|
|
|
|
|
Customer have an application set running on Windows Server 2003 Service Pack 2 compiled with Version 11.1 Build 8204 that has the application crash in PBVM110.dll.This is an application that uses tcp/ip as a communication protocol between other applications runing on the same machine and remote clients over TCP/IP.
This program set runs as a server for remote clients. There are several administrators that will connect to the Windows Server 2003 machine using remote desktop. If their display setting of remote desktop are different from the last user then the PowerBuilder application will crash. Testing revealed that changing the "desktop size" or the "color resolution" between connections will crash the program. Customer set up a simple midi application with three empty sheets and that application does not crash.
App doesn't crash outside of Terminal Services. Customer tried changing resolution and color depth about 15 times with no failure outside of Terminal Services. While using Terminal Services customer notice that when you reconnect with a different resolution that all applications will minimize. (Both Task Manger and the MobileServ application). Apparently, Terminal Services is triggering an event to cause this to happen. This is just an observation. |
|
|
|
CR:493471
|
|
493471 |
|
PB Enterprise |
|
PB.NET WebForm |
|
|
|
|
|
|
|
The customer has an app with a response window that has picture buttons lined up in a column to the left of a tab control. When deployed to Web Forms the buttons are on top of the tab control and nothing happens when you click them. Also the tabs don't respond when clicked.
It's not related to a response window as the same behavior happens when it's changed to a main window.
4/29/2008: Verified fixed in PB 11.2 build 8407. |
|
|
|
CR:493519
|
|
493519 |
|
PB Enterprise |
|
DB MS SQLServer |
|
|
|
|
|
|
|
PB with SNC cannot store the correct value in a decimal host variable from float data.
For example, |
|
Workaround Description |
|
A host variable is created by double. And the obtained value is substituted for a decimal type. The value of float will be rounded correctly. |
|
|
|
CR:493590
|
|
493590 |
|
PB Enterprise |
|
PB.NET WebForm |
|
|
|
|
|
|
|
Sheets on MDI webform not opening. It appears the
open event and activate event of sheet are firing but sheet never appears.
The Receipt Entry (m_poreceiptentry) calls gf_open_sheet_with_name in the gbl_menu.pbl.
The function is trying to open the w_m_receipt window.
w_m_receipt - \inventory\receipts.pbl
inherited from w_ma_window - \_common\inh_win.pbl
inherited from w_ma_sheet - \_common\inh_win.pbl |
|
|
|
CR:493683
|
|
493683 |
|
PB Enterprise |
|
PB.NET Assembly Deployment |
|
|
|
|
|
|
|
|
|
|
03 Jun 2008 |
Consult Complete |
|
|
|
|
|
Deployement failed without any information for debugging |
|
|
|
CR:493734
|
|
493734 |
|
PB Enterprise |
|
PB.NET WebForm |
|
|
|
|
|
|
|
The customer has an MDI application. On one of the sheets is a tab control with three tab pages. Each tab page has a bitmap displayed on it's tab. There is also a treeview on the sheet. There are 2 problems when the application is deployed to Web Forms. First the three bit maps displayed on the tab pages are washed out. They don't appear with the same detail and clarity as they do in client sever. (The tabs them selves, and the whole tab control is flat in WebForms with a blue border, whereas in client server the tab control and the tabs have a raised border - this issue is reported in another CR)
The second issue is resizing. The customer has resizing code so that the tab and the treeview fill the sheet, whatever it's size. This works fine in client server, but in webforms the resizing is not done when the sheet is first displayed. You have to click on an object on the window before the resizing is done. |
|
|
|
CR:493867
|
|
493867 |
|
PB Enterprise |
|
PB.NET WebForm |
|
|
|
|
|
|
|
Webform:
With a Treeview and a Datawindow control in the same .Net WebForm window, tabbing out
from a modified column gives a flickering effect with postbacks and loss of the focus
due to the itemchanged event. |
|
|
|
CR:493879
|
|
493879 |
|
PB Enterprise |
|
DW - Runtime |
|
|
Closed |
|
Windows XP |
|
11.0 RC |
|
|
|
|
|
|
App is crashing when using sharedata() or rowscopy().
The faulting ip address is as follows:
FAULTING_IP:
PBDWE110!DWDataBuffer::GetItem+12 [e:\pb11\dw\engine\table\dwtbufr.cpp @ 535]
116e0fd2 8b04b8 mov eax,[eax+edi*4]
EXCEPTION_RECORD: ffffffff -- (.exr ffffffffffffffff)
ExceptionAddress: 116e0fd2 (PBDWE110!DWDataBuffer::GetItem+0x00000012)
ExceptionCode: c0000005 (Access violation)
ExceptionFlags: 00000000
NumberParameters: 2
Parameter[0]: 00000000
Parameter[1]: 00000004
Attempt to read from address 00000004 |
|
|
|
CR:493884
|
|
493884 |
|
PB Enterprise |
|
DW Wizards |
|
|
|
|
|
|
|
Cannot build a DW based on a Web Sevice with an HTTPS url |
|
|
|
CR:493975
|
|
493975 |
|
PB Enterprise |
|
DW - Runtime |
|
|
|
|
|
|
|
AutoSelect of the head column of DW does not become effective. |
|
|
|
CR:494014
|
|
494014 |
|
PB Enterprise |
|
DB OLE DB |
|
|
|
|
|
|
|
|
11.1 |
|
13 Apr 2008 |
Fixed |
|
11.1 |
|
|
Fixed |
|
|
|
|
|
In MSS, if raiserror was called more than once , the one with the highest severity was reported in PB transaction object. With the other interfaces, it is the first raiserror that gets reported, no matter what the severity is set to. |
|
|
|
CR:494056
|
|
494056 |
|
PB Enterprise |
|
Window - Runtime |
|
|
|
|
|
|
|
The customer has a number of tabpages in a tab control. The tab control has the Powertips and Multiline properties checked. Some of the tabpages become invisible at times. But when you hover the cursor near where an invisible tab page is, it's Powertip still displays. For example if tabpage 5 is invisible, if you hover the cursor around where the tabpage 4 and tabpage 6 tabs are adjacent, you'll see the tabpage 5 Powertip displayed. |
|
|
|
CR:494150
|
|
494150 |
|
PB Enterprise |
|
Menus - Runtime |
|
|
|
|
|
|
|
SetToolbarPos function crashes PB. |
|
|
|
CR:494173
|
|
494173 |
|
PB Enterprise |
|
PB.NET WebForm |
|
|
|
|
|
|
|
Bug on webform File manager. It does not appear to be working properly when whe use GetFileOpenname with the graphic filter.
GetFileOpenName("Select an Image File to Upload", s_filename, s_pathname, "jpg", "Graphic Files (*.jpg;*.bmp;*.gif;*.tif;*.png),*.jpg;*.bmp;*.gif;*.tif;*.png;*.jpeg;*.tiff")
Works fine when not using the graphics filter
GetFileOpenName("Select File", s_pathname, s_filename, '*', " Files (*.*),*.*") |
|
|
|
CR:494194
|
|
494194 |
|
PB Enterprise |
|
Jaguar Integration |
|
|
|
|
|
|
|
Customer is having a memory leak in EAServer with a PB component. They have sent in a dump file. Asking for Engineering anaysis of the dump. |
|
|
|
CR:494218
|
|
494218 |
|
PB Enterprise |
|
DW Ink Control |
|
|
|
|
|
|
|
Null InkPicture crashes on SetFullState |
|
|
|
CR:494246
|
|
494246 |
|
PB Enterprise |
|
DW - Runtime |
|
|
|
|
|
|
|
Calling SetFullState on an empty DW will cause a GPF if the BLOB was created with GetFullState on a DW with a InkPicture control populated from an Oracle database. |
|
|
|
CR:494301
|
|
494301 |
|
PB Enterprise |
|
Window - Runtime |
|
|
|
|
|
|
|
|
|
|
16 Jun 2008 |
Presently Not Targeted For Any Future Release Of This Product |
|
|
|
|
|
Crash dump collected from PowerBuilder Application. Application started crashing once migrated to PB 11 and XP. Application uses Attachmate to connect to the mainframe.
Application is crashing in PBSHR110.dll. |
|
|
|
CR:494363
|
|
494363 |
|
PB Enterprise |
|
Window - Runtime |
|
|
|
|
|
|
|
Customer's application use window timer event to trigger
sequences action and end with a response window. On the other hand, there is validation
triggered by datawindow itemchanged event, that lead to another popup dialog box.
Under frequent trigging of both response window and itemchanged dialog box, The timer event stop triggering and itemchanged event get pass for wrong value on validation. |
|
|
|
CR:494440
|
|
494440 |
|
PB Enterprise |
|
PB.NET WebForm |
|
|
|
|
|
|
|
The customer is using a tab control and has both an bitmap icon and text on the tab of each tab page. In Win32 client server, the icon and text are centered on the tab with an equal space on the left edge and the right edge of the tab. But in WebForms the icon and text are shifted all the way to the left of the tab, with no space on the left edge, and a very wide space on the right edge. |
|
|
|
CR:494546
|
|
494546 |
|
PB Enterprise |
|
DW Display |
|
|
|
|
|
|
|
During printing a Datawindow containing about 50 Thousand rows (approximately 1250 Pages) when moving the mouse a GUI Problem starts to show ie. after a few seconds only strange figures appear on screen. This happens when using the windows 2000 style. When using XP Style display settings then it works fine ! |
|
|
|
CR:494586
|
|
494586 |
|
PB Enterprise |
|
Rich Text |
|
|
|
|
|
|
|
From the online help for showheadfoot, it list the
following as a code example to use to insert the current page number in a footer:
rte_1.showheadfoot(true,false)
rte_1.setalignment( Center! )
rte_1.inputfieldinsert("PAGENO")
rte_1.showheadfoot(false,false)
Please clarify in the documentation that the headerfooter property must be checked
at design time. The above code should be added to the Application Techniques Manual,
Implementing Rich Text.
Also in the Application Techniques Manual, Implementing Rich Text, Preview and Printing,
theres a section on Setting the page number. I believe that code is obsolete.
For more info, see cr433830. |
|
|
|
CR:494634
|
|
494634 |
|
PB Enterprise |
|
DW Edit Mask |
|
|
|
|
|
|
|
When EditMask has mask value of "000" and type of "numericmask!" ,update value moved to wrong position. |
|
|
|
CR:494722
|
|
494722 |
|
PB Enterprise |
|
PB.NET Smart Client |
|
|
|
|
|
|
|
Error when publishing an application to a ftp site.
Publishing to ftp site fails. |
|
|
|
CR:495110
|
|
495110 |
|
PB Enterprise |
|
DB OLE DB |
|
|
|
|
|
|
|
Connecting to MS SQLServer via OLE DB. The customer has a stored procedure and is calling this procedure in embedded SQL in PB using delclare, execute, and fetch, accessing parameters by name. The stored procedure is used in other none PB applications as well. Sometimes changes are made to the stored procedure, like adding a new parameter. In the past the existing PB exe continued to work fine after a change like this as it was accessing parameters by name and didn't need to use the new parameter. But now in build 7611, he is getting the error "Mismatch between Retrieve Columns and Fetch Columns". He believes this should not be happening. |
|
|
|
CR:495343
|
|
495343 |
|
PB Enterprise |
|
DW SaveAs |
|
|
|
|
|
|
|
When using dw_1.saveas to save in XML! format with EncodingANSI,
PB is saving the file with extra hex characters.
In textpad you can see the following characters at the beginning of the file where
these characters are not there in PB 9:
EF BB BF 3C....
In PB 9:
3C.... |
|
|
|
CR:495542
|
|
495542 |
|
PB Enterprise |
|
Script Painter |
|
|
|
|
|
|
|
Need different sorting of events/functions in script painter.
Currently the choices are (a) scripted first and (b) alphabetical. If you're working with a large framework (.e.g., PFC) you can have a lot of events/functions that are scripted in the ancestor but not in the current object. Events/functions that are scripted in the current object should have precedent. So when scripted first is chosen the order should be (1) scripted in current object, then (2) scripted in ancestor and finally (3) not scripted. |
|
|
|
CR:495571
|
|
495571 |
|
PB Enterprise |
|
Language - Runtime |
|
|
|
|
|
|
|
The customer has an app that is crashing after closing the main window. He can run his app in IDE but it crashes in the exe. |
|
|
|
CR:495698
|
|
495698 |
|
PB Enterprise |
|
DB OLE DB |
|
|
|
|
|
|
|
Memory leak with the OLEDB ODB interface against MS SQL Server when using the SyntaxFromSQL function. |
|
|
|
CR:495771
|
|
495771 |
|
PB Enterprise |
|
DW XML |
|
|
|
|
|
|
|
PB cannot import the element of omitted XML correctly. XML imported to DW must include all elements. An empty element is sufficient as it. |
|
Workaround Description |
|
Please add an empty element to XML. example( <xxxx /> ). |
|
|
|
CR:495833
|
|
495833 |
|
PB Enterprise |
|
OLE - Active X - OCX |
|
|
|
|
|
|
|
Team Sybase reports that when using OLE in Powerbuilder to access Excel and you try to make a column larger then 255 you get an error. The error message is "Powerbuilder Application Execution Error (R0039)" "Error: Error accessing external object property columnwidth at line..." But when attempting to do the same when running Excel standalone the Excel error is "Column width must be between 0 and 255 characters". Shouldn't PowerBuilder be able to report the real Excel error? |
|
|
|
CR:495841
|
|
495841 |
|
PB Enterprise |
|
PB.NET WebForm |
|
|
|
|
|
|
|
Imported XML data is getting cut off in a datawindow on a webform |
|
|
|
CR:495845
|
|
495845 |
|
PB Enterprise |
|
PB.NET WebForm |
|
|
|
|
|
|
|
Extra scrollbars appearing next to text data in a datawindow
on a webform |
|
|
|
CR:495947
|
|
495947 |
|
PB Enterprise |
|
Rich Text |
|
|
|
|
|
|
|
Inputfieldcurrentname is inconsistent when inserting a document thru the popmenu.
For example, when inserting a document thru the popmenu and then selecting text (but
not an input field), PB will return the first inputfield in the document. This will
continue to happen until you select an inputfield, then PB will return the current name ok. When you continue to select text after that (but not an input field), PB will return nulls ok for InputFieldCurrentName.
However, when you insert a document using rte_1.insertdocument("my.rtf,true,filetyperichtext!) and then select text (but not an input field), PB
will return nulls for the inputfieldcurrentname. This is ok. PB should only
return an inputfield when one is selected. |
|
|
|
CR:495949
|
|
495949 |
|
PB Enterprise |
|
PB.NET |
|
|
Closed |
|
Microsoft Windows 2003 |
|
11.1 |
|
|
|
|
|
|
Unable to call an NVO deployed in a .NET assembly. |
|
|
|
CR:495954
|
|
495954 |
|
PB Enterprise |
|
OLE - Active X - OCX |
|
|
|
|
|
|
|
OLEStorage Open crashes PB when directory path and filename is long. The customer is getting a -9 returned. But TSE and PSE are crashing. Either way can we get the limit increased so any (un)reasonably long name will work? |
|
|
|
CR:496037
|
|
496037 |
|
PB Enterprise |
|
Window - Runtime |
|
|
|
|
|
|
|
When try to call external function "Shell_NotifyIconA;Ansi", PB11 seem able to perform all
expected but the PB Application crash on return. If convert to ANSI call to
"Shell_NotifyIconW", PB Application does not crash but fail to call the Balloon Tip in
system tray icon. |
|
|
|
CR:496060
|
|
496060 |
|
PB Enterprise |
|
DB Oracle |
|
|
|
|
|
|
|
A crash or connection loss is encountered when calling DataWindow DBCancel before the first row has been retrieved.
The retrieve has a long prepare time.
Versions used:
PowerBuilder 10.5.2 Build 7611
Database interface O90 or O10 with Oracle Client 9.2.0.8, 10.2.0.1 or 10.2.0.2 |
|
|
|
CR:496086
|
|
496086 |
|
PB Enterprise |
|
Rich Text |
|
|
|
|
|
|
|
Customer needs a way to programmically set superscript and
subscript.
The following example on code exchange opens a font dialog. There you have to
set the radio button for subscript or superscript. Is there a way to set
this as a default when you open. |
|
|
|
CR:496377
|
|
496377 |
|
PB Enterprise |
|
PB.NET WebForm |
|
|
|
|
|
|
|
The second column has a visible expression, that depends on the value of the first column. When you change the value of the first column, a postback is sent to the server and the second column is not visible. You can't see, which column has the focus now.
When you now change the value of the first column again (to 101), the second column becomes visible, but the cursor is in the third column. |
|
|
|
CR:496412
|
|
496412 |
|
PB Enterprise |
|
PB.NET WinForm |
|
|
|
|
|
|
|
When the cursor on a webform is in a column the getfocus function does not work. |
|
|
|
CR:496463
|
|
496463 |
|
PB Enterprise |
|
PB Web Services |
|
|
|
|
|
|
|
OS: Windows XP SP2
Versions and Build #s Tested: PB 11.1_8204, 11.1_8218 and 10.5.2_7635
Database/Driver File/Version: ASE 15.0, accessed via WSDL
Comments: When retrieving information from ASE web service via SOAP, PowerBuilder display size mismatch in array-to-object conversion between tns_datareturn structure and self-created structure variable. It seems that the generated proxy is invalid. |
|
|
|
CR:496537
|
|
496537 |
|
PB Enterprise |
|
DW Display |
|
|
|
|
|
|
|
Display overlap problem with a large text column and a nested datawindow report using autoseize height and sliding up. |
|
|
|
CR:496582
|
|
496582 |
|
PB Enterprise |
|
Jaguar Integration |
|
|
|
|
|
|
|
Access violation error using PB 10.5.2, EAServer 5.3
and Oracle 10g.
The exact error is:
FAULTING_IP:
oraclient10!kppisize+374a
61c829fe 0fb64618 movzx eax,byte ptr [esi+0x18]
EXCEPTION_RECORD: ffffffff -- (.exr ffffffffffffffff)
ExceptionAddress: 61c829fe (oraclient10!kppisize+0x0000374a)
ExceptionCode: c0000005 (Access violation)
ExceptionFlags: 00000000
NumberParameters: 2
Parameter[0]: 00000000
Parameter[1]: 00000118
Attempt to read from address 00000118
064cdd74 61c2988a 0324ae10 448d596c 00000100 oraclient10!kppisize+0x374a
064cddac 031816ce 0324ae10 448d596c 00000100 oraclient10!OCIDateTimeConstruct+0x38
064cdde4 077a1d52 0324ae10 448d596c 00000100 oci!OCIDateTimeConstruct+0x42
064cde18 077a781c 0324ae10 448d596c 00000100 pbo10105!CPBOCI::OCIDateTimeConstruct+0x42
064ce278 077a9bd4 400df110 00000001 400df110 pbo10105!Ora_DoBindWInputParms+0xa7c
064cec84 06b55387 400df110 0762e701 400df110 pbo10105!PB_DB_Rout+0x10c4
064cec8c 0762e701 400df110 4019c01c 426a27c8 PBSHR105!DBI_PrepareWithParms+0x37
064ced10 074a1627 064cfbd8 06e6a8c7 56433230 PBDWE105!dwGetExceedPageMessage+0xa11
064cedcc 426a2788 3fe142f0 00000001 43039550 PBDWE105!CreateXHTMLTemplate+0xe077
40122f84 40099228 43fda468 4011fca4 00000000 0x426a2788
400df110 00000000 00000000 00000000 00000000 0x40099228 |
|
|
|
CR:496686
|
|
496686 |
|
PB Enterprise |
|
Window - Runtime |
|
|
|
|
|
|
|
On a simple MDI application, when two child windows are opened with a delay containing a button, the button's text appears 2 times during the opening.
In PB 11.2 the button appeary 2 times on the sheet. |
|
Workaround Description |
|
I have taken a look at the sample and I have some workarounds, and depending on the application they might be applicable by the customer.
Eg. use a different OpenSheet argument for arrangeopen.
In the sample that would mean use
li_rc = OpenSheet ( lw_sheet, as_sheetname, w_genapp_frame, 0, Cascaded! )
in the of_opensheet function. (or use Layered!)
or use the original code and use later in that event:
w_genapp_frame.ArrangeSheets ( cascade! ) |
|
|
|
CR:496734
|
|
496734 |
|
PB Enterprise |
|
PB Web Services |
|
|
|
|
|
|
|
|
|
|
06 Aug 2008 |
Third Party Problem |
|
|
|
|
|
Wrong DateTime conversion in PB EasySoap. |
|
|
|
CR:496791
|
|
496791 |
|
PB Enterprise |
|
DW Edit Mask |
|
|
|
|
|
|
|
Somewhere in version 9 this behavior changed. You have a date, datetime, or time column in a datawindow with an editmask and autoskip checked. With a record in the dw if you click in a column to position the cursor just after the last digit, it will immediately skip to the next column. In PB 8 and earlier versions of PB 9 you could click at the end and edit the column. |
|
|
|
CR:496807
|
|
496807 |
|
PB Enterprise |
|
Edit Mask |
|
|
|
|
|
|
|
CR 466805 was not fixed on DateTime datatype. |
|
|
|
--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具:ReadASADB。
此工具支持ASA v5.0,v6.0,v7.0,v8.0,v9.0,v10.0,v11.0,v12.0等版本。
恢复Sybase SQL Anywhere的工具在国内应该算首创。
ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具
- 适用于所有的SQL Anywhere版本 包括:5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x
- 适用于所有的UltraLite版本
- 能够恢复出来表结构和数据
- 能够恢复自定义数据类型
- 能够恢复存储过程等对象的语法
- 能够导出到目标数据库
- 能够导出到SQL文件并生成导入脚本
- 支持多种字符集 包括:cp850、cp936、gb18030、utf8等
- 能够恢复未加密或者简单加密类型的数据
- 简单易用
- 限制:不支持AES加密的数据文件
请参考:
研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍
ReadASADB适用场景
各种误操作:
- 误截断表(truncate table)
- 误删除表(drop table)
- 错误的where条件误删数据
- 误删除db或log文件
- 误删除表中的字段
本工具的应用场景:
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等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------