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

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, =: , =: , =: '

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;

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.

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.

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?

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)

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.

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.

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.

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

Error: The definition of the method signature in Web Service proxy is wrong.

to design if the XHTML view is open or there is an XHTML template.

Database interface used is Informix In9.

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.

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.

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).

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.

[IBM][iSeries Access ODBC-Treiber]Fehler bei Zuordnung.

Workaround: change DisableBind

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.

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.

Seems to work for all non zero sums correctly.

- ORA-01461: can bind a LONG value only for insert into a LONG column

- ORA-01465 invalid hex number

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.

workaround is to change disablebind.

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

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

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.

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_'.

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".

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.

03/17/2008: Fixed in PB 10.5.2 build 7640 and after.

Webform and win32 both display both lines of the tab's legend text.

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

no Workaround

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?

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.

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.

For example,

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

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.

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.

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

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 (*.*),*.*")

Application is crashing in PBSHR110.dll.

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.

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.

Publishing to ftp site fails.

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....

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.

on a webform

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.

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.

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

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.

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.

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.

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

In PB 11.2 the button appeary 2 times on the sheet.

Under HKLM\Software\Microsoft\Today\Items\<our item>\

we need an entry "Selectability" with value 1.

4/29/2008: Fixed in PB 11.2 build 8537 and after.

In the rte control, the document looks like the following:

{ADDRESS BILLING BLOCKBEGIN}{CLAIM HEADING INFO ROW=1 COL=33}

If you place the cursor between the ...BLOCKBEGIN} and {CLAIM ...., you can

enter any text.

In Word, the document looks like:

{MERGEFIELD {ADRESS BILLING:BLOCKBEGIN}{MERGEFIELD{CLAIM HEADER INFO:ROW=1:COL=33

05/02/2008: Fixed in PB 10.5.2 build 7670 and after.

Fixed in PB 11.2 build 8537 and after.

Component, About service components, the doc refers you to the Automated Configuration Guide for EAServer 6.x.

The documentation probably should clarify that besides deploying a service component to

EAServer 6.x, you must create a Service Component Entity. Refer to the Automated Configuration Guide manual in EAServer 6.x on how to create the entity.

- <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>

- <m:SecurityProviderAuthenticateRequest xmlns:m="http://systemsunion.com/connect/webservices/">

<m:name s:type="y:string">KED</m:name>

<m:password s:type="y:string">password</m:password>

</m:SecurityProviderAuthenticateRequest>

</E:Body>

</E:Envelope>

Is there a way we can switch off the "s:type"?

can not be reached from the "Element Attributes Dialog" when editing a XML or XHTML template with "Edit/Add Atribute".

Epson printers, like many others, has been used in place like supermarket, to print receipt for customer. The printer provides command set so it can be operated

to do different job. For example, Character A means to open casher drawer, character F means cut paper

1) Though both have the same height of 64 units, the SLE is displayed with much less height than the column.

2) The left margin is more in the sle than the column.

3) The top margin is more in the sle than the column. (Only visible in Windows XP Theme).

SQL error -254: Too many or too few host variables given

Error happens on the following sql statement:

DECLARE get_all_log_name PROCEDURE FOR get_all_logname( );

Execute get_all_log_name;

FETCH get_all_log_name INTO :ll_status, :ls_logname;

// error happens on next sql statement

SELECT count(*)

INTO :ll_found

FROM personnel

WHERE logname = :ls_logname;

is using a composite dw as the secondary source.

It is crashing in the PBDWE110!DWDataBuffer::GetItem

Message: "The parameter is incorrect".

If the directory in the regular form " Z:\directory" and added to the Resource Files tab, this works fine. As different users might have different drives mapped to the same shared drive the customer would like to use UNC paths instead. Is this possible and if so, how can it be done?

The other problem is the footer for the report. The footer displays properly on all pages except the last. On the last page lines in the footer are not displaying and the last line is missing. This problem happens in both display and printed reports.

Customer knows that the using rte_1.InputFieldDeleteCurrent()deletes the input field in PB 11.x but the users are very used to simply clicking the backspace key to delete the field and they would like to continue to be able to do this.

Is this possible with the new RTE control?

2) Open topic. Note the name in the topic page is different: "Database parameters and supported database interfaces" (the colon is missing).

3) Scroll down to the "SNC SQL Native Client for Microsoft SQL Server"

section. The various valid parameters for that DBMS type are listed.

4) Note that "Database", "AppName", and "DBTextLimit" are NOT listed. They should be. If you open those topics you will see that they apply to SNC.

Generation Errors: ERROR:Could not find transient

Code in manual: psPage.Redirect("My_webpage.html");

This appears to be a simple doc error as the correct code is inserted when the redirect is created.

PSArgClass args = new PSArgClass();

psPage.Redirect ("My_webpage.jsp", args);

a ODBC driver. PB is crashing in PB 11 after first call to stored procedure.

The dump file results are:

0012a910 0acf3b6f 0abb2f10 0adcc3cc 00000000 edaodb3x!SQLFetch+0x33f

0012a968 7434c70d 0adcc3cc 00000000 7c350420 edaodb3x!SQLFetch+0x1ab

0012a980 0ab4a3aa 74350000 0a7909f2 015c5008 odbc32!SQLFetch+0x160

0012aa14 0ab4cb19 015c5008 00000000 0af88944 PBODB110!ODBC_BuildProcInputOutputParms+0x1da [e:\pb11\db\odbc\pbodbc7.cpp @ 3666]

0012aa50 0ab36749 0a7a2008 0aff0008 00000001 PBODB110!ODBC_DoPrepare+0x2e9 [e:\pb11\db\odbc\pbodbc7.cpp @ 314]

0012ab88 10b56b27 015c5008 00501d10 015c5008 PBODB110!PB_DB_Rout+0x529 [e:\pb11\db\odbc\pbodbc1.cpp @ 1019]

0012ab90 00501d10 015c5008 0aff0008 015cd1e8 PBSHR110!DBI_PrepareWithParms+0x37 [e:\pb11\shared\pbshr\pbdbi2.cpp @ 146]

0012abb4 00502644 01591b84 015c5008 01542d1c PBVM110!rtdb_set_transaction+0xf0

015c5008 00000000 00000000 00000000 00000000 PBVM110!rtdb_set_transaction+0xa24

Net.Thomson.Distribution.Context.Mediator.DefaultCommercialInvoiceHandler theHandler

Creating same object in Visual Studio does not fail.

The focus rectangle can be drawn at the wrong position and the wrong value can be selected when clicking a radio button.

*** 30. april 2008 09:47:16 *** kirchner ***

Seem to happen in GA 11.2 release (8407).

Does not appear in build 8532.

I tried a datawindow and that appends OK in Webforms, but the datastore resets the buffer on every retrive.

object's descendant event, the message.wordparm in that event retrieves an incorrect value.

Problem only appears to be happenning on PB WinForm. Works ok on PB Native and PB WebForm.

Error is "Item '2003-00-01 00:00:00:000000' does not pass the validation test"

Columns with a date autocomplete correctly when a valid year is entered and tabbed off the column. Date is then 2008/01/01.

There are 2 closed CR with similar issue: CR 467467 and 466059

Setting below, which should be the default anyhow, in the pb.ini file, also does not work.

[Edit Mask Behaviors]

AutocompleteDates=yes

enter the userid and you either tab to the password field or move the cursor to the

password field.

Works ok in PBNative

w_r_logon is in the applogon.pbl

RESOLUTION: The customer is going to upgrade to the latest Oracle drivers and revisit the problem if it still exist.

Error: R000 Null object referrence: in function uf_itemchanged of object n_rules_company_setup at line 0 in event of object

The error message is referencing the n_rules_company_setup/uf_itemchange function.

The code in question is:

i_n_manager.uf_set_company_id_all(l_s_value)

i_n_manager.uf_set_window_title(l_s_value)

i_n_manager is an instance of n_company_setup_manager and has been registered in the n_rules_company_setup/uf_create. The n_rules_company_setup/uf_create is being called when the window (w_m_setup_company) opens.

n_rules_company_setup - company.pbl

w_m_setup_company - company.pbl

n_company_setup_manager - company.pbl

RESOLUTION: Works ok in PB 11.2 (build 8565)

the following error message appears:

dwwin.exe

The application failed to initialize properly

Versions and Build #s Tested: PB 11.2_8407 and 10.5.2_7635

Database/Driver File/Version: N/A

Comments: RichText control has a big space to scroll down after end of text. There should not be such a big blank area to scroll.

Versions and Build #s Tested: PB 11.2_8407 and 10.5.2_7635

Database/Driver File/Version: N/A

Comments: The Break On Change debug option is not interrupting the execution when instance variable changes its value.

properly on PB WebForm. They appear larger in an WebForm application.

The datawindow is d_setup_item in the itmset_d.pbl.

Everything works except the sizes of the fonts seem to be different and the lines print outside the form area.

adw_sort.Object.compute_1.expression = 'first(#' + String(ai_col) + ' for group 1)'

in the tblFindGroupsSort.

PBDWE110!tblFindGroupsSort(struct datawindow * pDW = 0x90000b00, int bSortOK = <Memory access error>)+0x420 (FPO: [EBP 0x000f0000] [1,11,0]) (CONV: cdecl)

PBDWE110!tblFindGroups(struct datawindow * pDW = <Memory access error>)+0xb (FPO: [1,0,0]) (CONV: cdecl)

PBDWE110!DWDataWindow::RowsMove(long lStartRow = <Memory access error>, long lEndRow = <Memory access error>, short queueFrom = <Memory access error>, void * ToDW = <Memory access error>, long lInsertRow = <Memory access error>, short queueTo = <Memory access error>, unsigned int iFlags = <Memory access error>)+0xbc8 (FPO: [EBP 0x0012de78] [7,33,0]) (CONV: thiscall)

PBDWE110!DWSemanticFunctions::RowsMove(void * givenDWFrom = 0x011276d8, long givenRowstart = 6, long givenRowend = 1, short givenCacheFrom = 20384, void * givenDWTo = 0x116d71d3, long givenRowInsertAt = 17987288, short givenCacheTo = 6, unsigned int CopyOrMove = 0x11276d8, int * returnCode = 0x00000000)+0x4e (FPO: [10,0,0]) (CONV: stdcall)

PBVM110!dwmRowsCopyMove(struct ob_this * rtThis = 0x011276d8, unsigned int nArgs = 6, int bCopy = 1)+0x159 (FPO: [Non-Fpo]) (CONV: cdecl)

PBVM110!fndwRowsCopy(struct ob_this * rtThis = 0x011276d8, unsigned int nArgs = 6)+0x12 (FPO: [Non-Fpo]) (CONV: stdcall)

Resolution: The crash in rowscopy is fixed in Powerbuilder 11.2 8565

-> Found that it works in new 1148 build of PocketBuilder 2.5. Targeted for June 2008

Workaround: using a batch file to start the application as a workaround (they can then set the JAVA_HOME or PATHin the batch file).

When user changes the month, after some of the dates have been made bold (MCM_SETDAYSTATE), the bold dates are lost when comming back.

for the pipeline dataobject property:

DataObject String The name of the pipeline object (the object created

in the Data Pipeline painter)

Online help should clarify when the databobject property should be assigned when running

an application exe. Since it appears you can assign the dataobject property in the painter. But the Application Technciques Manual list that 'an application must always

reference its Pipeline objects dynamically at runtime (through string variables).

The demo code just creates local datastores in a loop and assigns datawindow objects to it. Then also additionally a Garbagecollect is called at the end of the script, although end of the script the locals should go out of scope anyway.

Measuring the values with the two used methods (Pbheapdump and perfmon) are resulting in different outcomes.

It seems that the problems appear when a blob is nested in a structure.

It seems that the problems appear when a blob is nested in a structure.

If a = 1 or b = 1 then

MessageBox("", "Do something")

end If

If a equals to 1, then it should go to MessageBox line because logic OR means one of the conditions becomes true, the whole statement is true . But PB continues with checking condition for b. This is unnecessary.

A double grouped DataWindow didn't save a repeating group according to "Iterate Header for Groups".

The missing or empty tags were behind the detail band in the file but are at a higher level within the xml tree.

rte_1.showheadfoot(true,false)

rte_1.setalignment( Center! )

rte_1.inputfieldinsert("PAGENO")

rte_1.showheadfoot(false,false)

It works well. Then the customer saves the rte report in a blob in the database. He does this by executing a copyrtf for each band, converting the strings to blobs and writing the blobs to the database. Then later the process is reversed, the blobs are retrieved, changed to strings and each band is pasted in a new rte with pastertf. The problem is that in the new rtf, the footer page numbers have lost the centering, they are over on the left, and they are all 1.

The testcase shows the problem simply by copying one rte to another:

// Copy the Header

is_richtext_header = rte_1.CopyRTF(False, Header!)

rte_2.pasteRTF(is_richtext_header, Header!)

// Copy the Detail

is_richtext_detail = rte_1.CopyRTF(False, Detail!)

rte_2.pasteRTF(is_richtext_detail, Detail!)

// Copy the Footer

is_richtext_footer = rte_1.CopyRTF(False, Footer!)

rte_2.pasteRTF(is_richtext_footer, Footer!)

You can see all the target rte footer page numbers are 1 and they are on the left. In addition the copyrtf for the footer has altered the source rte too, all the page numbers there have been changed to 1 as well, although at least they are still centered.

When this error appears while printing, it is hidden behind the print progress windows, effectively locking the application (app waiting for messagebox OK, printer software waiting for more info from app).

This requires the hadheld to be rebooted.

datawindow.

The crash is happening when PB gets to the following line:

ls_rc = ldwc_reportdw.modify( "DataWindow.Crosstab.Rows=~""+ as_rows + "~" DataWindow.Crosstab.Columns=~"" + as_columns + "~"")

Where as_rows = territory_id and as_columns = @crosstab_post_year,@calc_type

Versions and Build #s Tested: PB 11.2_8407

Database/Driver File/Version: ASA 10.0 EASDemoDB11

EAServer 6.1 for Windows

Comments: The GetItemString() web dw method returns null in PB 11 JSP 4GL page. This is a regression from PB 10.5.2. In 10.5.2, the method works as expected.

If a webservice method returns a decimal or gets a decimal as argument, the decimal seperator will be ignored.

The problem is reproducible with the european seperator ( , ) and the us seperator ( . ).

The problem does not happen when regional settings are english (us).

There is no way to configure the style for the build in default dialogs, rmb on scrollbar, or rmb on editable fields.

The XML page cannot be displayed

Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.

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

A name contained an invalid character. Error processing resource 'file:///C:/PSE/11441800/11441800/11441800/trysavexml.xml'...

<Extend?dAttribute>

----------^

to an easerver component, the following error results:

org.omg.CORBA.MARSHAL was thrown by method com.sybase.jaguar.server.JaguarServer.iiopHandler

org.omg.CORBA.MARSHAL: read_boolean: value = -126 vmcid: 0x0 minor code: 0 completed: No

The pb client is first calling a method on n_corba_args and calling a easerver component method (nss_eas6_test01/of_test01) and passing the n_corba args as a jaguar proxy reference. The of_test01 then calls a method on that jaguar proxy reference.

In EAServer 5.5 and PB 11, the jaguar proxy gets passed in ok. But getting a new_JagStream: nil object reference when trying to call a method from that jaguar proxy.

RESOLUTION: Engineering provided workaround

SQLSTATE = 42000 Cannot use the OUTPUT option when passing a constant to a stored procedure:

Or

Can not get parameters of procedure

This issue is fixed in PB 10.5.2 Build 7709 and after. And in PB 11.2 Build 8575 and after.

processed by getfullstate & setfullstate between PB Client and EAServer 6.0.2

FAULTING_IP:

pbshr105!PbHeap_free+2a4 [e:\pb105\3rdparty\heap\spbheap.c @ 2345]

10bded94 895004 mov [eax+0x4],edx

EXCEPTION_RECORD: ffffffff -- (.exr ffffffffffffffff)

ExceptionAddress: 10bded94 (pbshr105!PbHeap_free+0x000002a4)

ExceptionCode: c0000005 (Access violation)

ExceptionFlags: 00000000

NumberParameters: 2

Parameter[0]: 00000001

Parameter[1]: 00000067

Attempt to write to address 00000067

RESOLUTION: Fixed in PB 10.5.2 (build 7662)

blob blb

blb = blob("Any Text", EncodingANSI!)

This worked fine in P B 10.5 both as a pcode exe and a machine code exe. In PB 11.2 it still creates a pcode exe OK, but it does not create a machine code exe. These errors are listed under the Errors tab:

---------- Linker: Errors (1:08:45 PM)

---------- Finished Errors (1:08:45 PM)

Also found the following in the WINDOWS/temp/migrate_encoding.log file:

CGEN: Compiling 'C:\Program Files\PB11.0\sybase\Shared\PowerBuilder\cgen\EN32T.c'

C:\Program Files\PB11.0\sybase\Shared\PowerBuilder\cgen\EN32T.h(1) definition of macro 'PS_UNICODE' not identical to previous definition

C:\Program Files\PB11.0\sybase\Shared\PowerBuilder\cgen\EN32T.h(1) included from C:\Program Files\PB11.0\sybase\Shared\PowerBuilder\cgen\EN32T.c(4)

C:\Program Files\PB11.0\sybase\Shared\PowerBuilder\cgen\EN32T.h(1) macro 'PS_UNICODE' defined on the command line

C:\Program Files\PB11.0\sybase\Shared\PowerBuilder\cgen\EN32T.h(56967) '//' style comment continues on next line

C:\Program Files\PB11.0\sybase\Shared\PowerBuilder\cgen\EN32T.h(56968) '//' style comment continues on next line

C:\Program Files\PB11.0\sybase\Shared\PowerBuilder\cgen\EN32T.h(56969) '//' style comment continues on next line

C:\Program Files\PB11.0\sybase\Shared\PowerBuilder\cgen\EN32T.h(56970) '//' style comment continues on next line

C:\Program Files\PB11.0\sybase\Shared\PowerBuilder\cgen\EN32T.h(56971) '//' style comment continues on next line

C:\Program Files\PB11.0\sybase\Shared\PowerBuilder\cgen\EN32T.h(75061) nested comment found in comment started on line 75060

CGEN: Compiling 'C:\WINDOWS\Temp\blob_migrate.c'

C:\WINDOWS\Temp\blob_migrate.c(931) symbol '_nEncoding' has not been declared

C:\WINDOWS\Temp\blob_migrate.c(932) function argument(s) do not match those in prototype

C:\WINDOWS\Temp\blob_migrate.c(932) 'shBinary * stdcall (__export ot_bytearray_to_binary)( ob_this *, tag_OB_NARRAY * )' defined in: C:\Program Files\PB11.0\sybase\Shared\PowerBuilder\cgen\EN32T.h(45) (col 45)

C:\WINDOWS\Temp\blob_migrate.c(932) cannot convert argument 2 defined in: C:\WINDOWS\Temp\blob_migrate.c(932) (col 73)

C:\WINDOWS\Temp\blob_migrate.c(932) source conversion type is "wchar_t [18] (lvalue)"

C:\WINDOWS\Temp\blob_migrate.c(932) target conversion type is "tag_OB_NARRAY *"

Customer is crashing in both the PB 9 and PB 11 versions of the application although when they set the following environment variables in PB 9 the crash goes away:

PB_HEAP_DEBUG=true

PB_HEAP_LOGFILENAME=c:\heap.log

They cannot do this as there are 800 users and they do not have rights to set these variables on many of the machines.

Number. The number of rows that were retrieved.

Please clarify that when using a dw filter, this value if the unfiltered value.

are not getting included in the <app>.exe.config file.

The app.config.win file is in the PowerBuilder 11.0\DOTNet\bin directory

Now in powerbuilder 11 with SNC it seems that the datawindow is just returning the error message "Select Error: Requested result set number 1 not found" rather then the detailed error message that is returned in the database painter using the same SNC database connection and executing the same procedure. In the testcase the error as to do with trying to insert a character into an integer column.

Also the same szenario works fine when a winform calls the assembly.

and the last row is deleted then the wrong row may get deleted and sorting may not function properly anymore.

If the modify statement is posted then the problem doesn't occur.

when menu item is disabled.

For example, the toolbar pic custom015! doesn't appear to be greyed out when disabled.

Customer has 3 groups that print headers summary code1, summary code2, and summary code3. Summary codes 2 and 3 may be null. If summary level 3 is blank or null, customer does not want the group header to show. To achieve that, she has marked the objects in the header line as "Autosize height=Y" and have marked the group header line as "Autosize height=Y'. When a break in summary 1 or 2 occurs in the middle of a page, the middle of a page, the group header for Summary 3 will not print; however, it seems when this coincides with a page break, the Summary 3 group header will print. Since it's blank, customer does not think this looks good.

We have found a workaround and that is to immedeately do a Full Build on the entire application after saving any changes to the application object.

into empty pbls, the following error results:

Calling cm_rebuild_application(CM_REBUILD_FULL).

Library: c:\testa\demoapp\peat.pbl

Object: m_peat_frame

Forward Declarations

(0002): Error C0001: Illegal data type: m_peat_master

Object: w_f_peat

Event: w_f_peat::create

(0004): Error C0047: Simple datatype illegal for create statement: m_peat_frame

Using the following orca script:

start session

create library "pfcapsrv\pfcapsrv.pbl" "New library"

create library "pfcdwsrv\pfcdwsrv.pbl" "New library"

create library "pfcmain\pfcmain.pbl" "New library"

create library "pfemain\pfemain.pbl" "New library"

create library "pfedwsrv\pfedwsrv.pbl" "New libary"

create library "pfeutil\pfeutil.pbl" "New library"

create library "pfcutil\pfcutil.pbl" "New library"

create library "pfeapsrv\pfeapsrv.pbl" "New library"

create library "demoapp\peat.pbl" "New library"

create library "pfcwnsrv\pfcwnsrv.pbl" "New library"

create library "pfewnsrv\pfewnsrv.pbl" "New library"

scc set connect property provider "PVCS Source Control"

scc set connect property userid "Admin"

scc set connect property localprojpath "C:\testa"

scc set connect property project "/ProjectUS?PVCS Version Manager?C:\Program Files\PVCS\vm\common\SampleDB?"

scc set connect property logfile "fullupdate.log"

scc set connect property logappend "FALSE"

scc connect offline

scc set target "demoapp\Peat Demo App.pbt" "REFRESH_ALL IMPORTONLY"

scc refresh target "full"

scc close

end session

into their applications

What are the advantages/disadvantages and typical scenarios that "scc refresh target migrate" and "scc refresh target full" would be used in. Which scenarios would you apply in using either/both of these operations and why?

Does the IMPORTONLY use the .pbg file. If so, how.

Does the REFRESH_ALL use the .pbg file. If so, how.

Does the IMPORTONLY use the .pbt file. If so, how.

Does the REFRESH_ALL use the .pbt file. If so, how.

Does the 'scc refresh target "full"' command use the .pbt and the .pbg? IF so, how or why does the command use these files?

Versions and Build #s Tested:

Server side: PBVM 10.5.1_6021 for Sun Solaris (dated from January 7th, 2008 - latest one) with EAServer 5.5

Client side: PB 10.5.2_7662

Database/Driver File/Version: O84 interface connecting into Oracle 10g, using Oracle Client 10.1.0

Via Get/SetFullState, when inserting signal characters (+, -, *, /, < or >) into datawindow and then performing GetFullState, the signal character is not saved. In the next dw retrieve, the row shows blank data for this column.

If you open the datawindow directly in PowerBuilder dw painter, you can insert such characters and save data with no problems. It will also be displayed via SetFullState. So, the issue is erradicated when saving the data via GetFullState.

The workaround is to use SetRedraw(true) function.

Using 'New' in the name of new properties is not a good idea. What is going to happen 3 or 4 years from now when they are no longer 'new' and you need to add a new new property?

That's a real pain when you want to copy this value to a different application (e.g. notepad). It requires that you manually have to strip off these double quotes.

Also, the value field has been resized to a very short box. Please reset it to 11.2 behavior.

Workaround: Use FileOpen/FileRead/FileClose functions together with ImportString function.

not have an eventid mapped to it.

The new sqlpreview event has a new eventid pbm_sqlpreview. This is inconsistent.

11 libraries. It should really have vertical and horizontal resizing.

for the inputfields instead of the corresponding data.

Integrate a .NET control to be able to use an external .NET component such as MapXtreme by MapINfo

in PB 11.5 and/or PB 12 and/or PB 12 WPF in the available controls list.

color is not working.

It works ok with all the other border styles (box, raised, shadowbox,underline,resizeborder).

color is set to transparent

When you click on a column, the top and left lines of the border are reduced in width.

This is not the case when using an SLE on a window.

When there is code in the itemfocuschanged event of a DataWindow then you need

to click twice on a dropdowndatawindow before you can select an item.

aggregate function that returns nulls, the following warning message appears and it

cancels the result set:

[POL5104] null values eliminated in aggregate function computation

The DataWindow sets a filter on the DDDW in the ue_dropdown event.

for reported datawindow reports.

Resolution: Select 'Show Background' checkbox for the nested report. If you want to

display the background gradient for the report select 'Preview Show Background' checkbox.

The property is on the Print Specification tab.

Versions and Build #s Tested: PB 11.2_8542

Database/Driver File/Version: ASE 12.5.3

Microsoft Word 2007 or Microsoft Word 2003 with add-on to open .docx files

Comments: In runtime, the OLEActivate() method invokes MS-Word 2007/2003 to open .doc files within OLE Database BLOB column, but fails for .docx files.

When you change the color and save it and then reopen the window, it is the old (original) color.

RESOLUTION: Per engineering, it is working as designed.

Customer has created an assembly in PB 11 and loaded into SQL Server 2005.

He also loaded the Sybase.PowerBuilder assemblies. When they try to register the assembly he gets the following message:

Msg 10300, Level 16, State 2, Line 1

Assembly 'QPIDCompute' references assembly 'sybase.powerbuilder.core, version=11.0.0.0, culture=neutral, publickeytoken=b76b10796def6a00.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: version, culture or public key mismatch). Please load the referenced assembly into the current database and retry your request.

The Sybase assemblies loaded on the SQL Server box are the same version as the development assemblies used to create their assembly.

Is this supported and if so how to create it in SQL Server 2005?

Versions and Build #s Tested: PB 11.2_8542

Database/Driver File/Version: EASDemoDB 11

Apache Fop 0.94 for Windows

Comments: Save Rows as XSL-FO does not follow the W3C recommendations. <fo:table-cells> element must have at least one child element <fo:block>. As a consequence, Apache fop cannot generate PDF from the .fo file.

With the DataWindow XHTML generator, the DW_Com.js

HTDW_SetColumn and HTDW_SetColumn javascript functions do not properly set the colunmn and row

file using the Microsoft XPS Document Writer, the only output that gets generated

is if the datawindow has text in the footer band.

Open a graph datawindow, make no changes and close it out. You will be prompted to save changes.

When he tries to run the web services examples he receives the following error:

Runtime Error - Bad runtime function reference at line 5 in function instantiateservice of object uo_ancestor

The error he gets when trying to import pbwsclient110.pbx is:

---------- Import PB Extension: (8:08:23 AM)

Importing C:\Program Files\Sybase\Shared\PowerBuilder\pbwsclient110.pbx

- Error: The file is not a valid dll or pbx file.

---------- Finished (8:08:23 AM)

He has both the SDK Toolkit and the Redistributable Package installed. On a co-workers machine these work.

We ran Process Monitor on his machine and it seems to be finding pbwsclient110.pbx but still fails.

FOR /*varname*/=/*start*/ to /*end*/

/*statementblock*/

END FOR

Currently there is one small mention in the for... next doc that you can end the loop with END FOR.

Oracle raises "PLS-00418: array bind type must match PL/SQL table row type" error.

included in the assembly list and the Library Files of the painter

Error in DeployLog.txt

An internal exception was thrown

http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.ddi.doc/ddi159.htm

Customer has an Informix 9 stored procedure that uses a datatype of SET:

EXAMPLE:

DROP PROCEDURE get_mgmt_aud_dtl;

CREATE PROCEDURE get_mgmt_aud_dtl(ivc_audit_tsk_list SET)

RETURNING CHAR(35);

DEFINE o_name CHAR(35);

BEGIN

FOREACH

SELECT audit_tsk_desc

INTO o_name

FROM audit_tsk

WHERE audit_tsk_num IN ivc_audit_tsk_list

RETURN o_name WITH RESUME;

END FOREACH

END

END PROCEDURE

He is able to execute this procedure with an array using the statement

EXECUTE PROCEDURE get_mgmt_aud_dtl(set{100,101,102})

When he tries to create a datawindow with this stored procedure or do a retrieve from the datawindow painter the execute statement that gets built and sent to Informix is not correct, it passes the array as separate arguments and not as an array.

Add support for the Informix Complex Datatypes.

Versions and Build #s Tested: PB 11.2_8565

Database/Driver File/Version: N/A

Comments: PB GPF's at PBSHR110.dll when opening window object migrated from PB 9.0. Note: Operations like Edit Source, Export, Import, Regenerate, Optimize and Full Build always complete successfully, which indicates there are no corrupted objects inside pbls.

results:

Microsoft Internet Explorer

Unexpected error was thrown, the browser will be closed!

Please report the error to administrator

Error: Can't move focus to the control because it is invisible, not enabled, or

of a type that does not accept the focus

Line: 7798

09/09/2008: Verified fixed in 11.2 build 8616.

much longer to get to a breakpoint and then to set out of the breakpoint.

In webforms the initial SetSeriesStyle works and the colors are changed. But on any subsequent filters (or unfilters) the colors of the graph revert back to the default colors. He tries executing the user event again after the filter but it has no affect.

If he does a messagebox after the filter and before the SetSeriesStyle event, then it works. So this problem appears to be post back related.

So there are 2 problems: 1) On a Filter in webforms, any changed colors on a graph dw are lost. 2) Executeing the SetSeriesStyle event again after the filter also does not work.

09/09/2008: Problem 1 could not be fixed. Problem 2 was fixed. Verified fixed in 11.2 build 8616.

This is a follow up to CR 534791. Development has indicated that PB assemblies cannot be stored on Microsoft SQL Server since they are not pure managed code. The customer is asking that we generate PB assemblies as pure managed code.

Workaround:

As a workaround, the customer will create pure managed C# assemblies, loaded into Microsoft SQL Server, that will make remote .NET calls to our assemblies.

Problem 1:

----------

In a Webform application, datawindow fields with edit styles of checkbox or radiobutton that have tab orders but are protected will crash when the user tabs to that field. The following error occurs:

Unexpected error was thrown, the browser will be closed!

Please report the error to the administrator.

Error: Can't move focus to the control because it is invisible, not enabled or of a type that does not accept focus.

The error happens tabbing forward or backward (Shift+tab). If you click on a protected field it just ignores the click as it should. In a client server application it simply skips to the next allowable field, webforms should do the same.

Problem 2:

----------

If the field has an Edit Style of Edit and has a tab order but is protected, in webforms it allows you the click on the field or tab to the field and it becomes highlighted. This should not happen. On a tab protected fields should be skipped and focus should go to the next allowable field. A click should be ignored and focus remain where it is.

At run time in script the customer is putting text into the t_title field and is printing the datawindow:

dw_summary.Object.t_title.Text = 'Management Audit Summary Report'

dw_summary.print()

In the printout, the header data is getting truncated on the bottom. You see the 'Management Audit Summary Report' correctly at the top and it has autosized correctly, but the header band seems to be in the same place as it was initially, cutting off the bottom of the header because t_title has increased in height but the header band has not moved to allow for that.

PBVM10.5.1 Linux allows to issue the call and return as true without error message.

But actually, PB does not remove the file

This is because the column is not allowed to have NULL, and the string with a space in it gets interpreted as NULL.

C:\Documents and Settings\All Users\Documents\Sybase\PowerBuilder 11.5

It also installed the InfoMaker Help to:

C:\Documents and Settings\All Users\Documents\Sybase\InfoMaker 11.5

styles appear ok

RESOLUTION: Composite datawindow does not support MSAA Standard.

the following error appears:

Unable to cast object of type 'c__w_c_po_detailxxxxx' to type Sybase.PowerBuilder.Web.PBWindowObject'.

Works ok when running in PBNative

2:20:52 PM mes.exe:13232 QUERY INFORMATION C:\sctg NOT FOUND Attributes Error:

2:20:52 PM mes.exe:13232 CREATE C:\sctg ACCESS DENIED USAC\us321142

2:20:52 PM mes.exe:13232 OPEN C:\sctg NOT FOUND Options: Open Access: 00010080

But if the user doesn't have access to the root directory, no XML gets generated. The user tried to workaround the issue by permanently creating the directory PB is trying to create and giving user's acces to that directory. But if the C:\sctg directory already exists, PB ignores it and creates a new incrementally named directory each time:

2:24:05 PM mes.exe:13232 QUERY INFORMATION C:\sctg SUCCESS Attributes D:

2:24:05 PM mes.exe:13232 QUERY INFORMATION C:\sctg.1 NOT FOUND Attributes Error:

2:24:05 PM mes.exe:13232 CREATE C:\sctg.1 ACCESS DENIED USAC\us321142

2:24:05 PM mes.exe:13232 OPEN C:\sctg.1 NOT FOUND Options: Open Access: 00010080

A similar issue happened in CR 335944 with BuildFromDataStore. It too writes temporary files to the system root directory. But this CR was recently fixed so it works when users don't have acccess to the root directory. Can the same sort of fix be applied to this XML problem?

first time in either PB IDE or running as application executable.

If you post the close(this) then you (briefly) see Sheet 2 open and disappear right a way (a flicker) and the toolbar for Sheet 1 remains as it should. But the customer doesn't like the flicker and wants it to work without posting.

The assembly referenced in the winform application does not connect.

When SySAM was originally put into PowerBuilder, we enforced the original PowerBuilder license terms where the license was only good for a single major version.

We have now changed this and will use the default SySAM logic rather than our own.

using windows OS authentication. Can PowerBuilder handle this?

is not consistent.

For example, a window with 2 dw's and a statictext field. The window has the

tab order set to the static text field, then dw1 and dw2.

When you run the app and open the window, click on the static text field. Now hit the tab and you tab inside dw1. The response from JAWS is:

Department ID colon edit 100 type and text

Department ID colon edit 200 type and text

Tab 300

Tab 400

Tab 500

Now when you tab to the next dw,

Tab MA (the value of the dddw)

Inconsistent behavior between the 2 dw's. Inconsistent response inside dw1.

and then don't include a path reference for the PNG file in PictureName, the IDE can't find it. That works for all other image types.

PNG files also won't be included in the EXE/PBDs unless there is a full path in the source code and in the PBR file. For all other image types, you can include a reference just to the image filename and rely on them being in the path at desgin/compile time.

In order to comply with 508 standards, the computed field should have a tab order, be able to gain focus but should not be editable.

09/09/2008: Verified fixed in 11.2 build 8616.

This makes it impossible to see the parts of the row that are outside the control.

ls_data = "~t" + copyrtfstring1 + "~t" + copyrtfstring1 + "~t" + copyrtfstring1.

Then using ImportFile he was able to import this file into a datawindow and later use the richtext strings to populate different rich text controls using the string in the datawindow and PasteRTF.

This no longer works with new Rich Text control in PB 10.5 as the string from CopyRTF appears to be different and have CR/LF in it which when using ImportFile are not allowing all the text to be placed into one field.

The text string when using CopyRTF in PB 8 is:

{\rtf1\ansi\deff0{\fonttbl{\f0\froman Tms Rmn;}}{\colortbl\red0\green0\blue0;\red0\green0\blue255;\red0\green255\blue255;\red0\green255\blue0;\red255\green0\blue255;\red255\green0\blue0;\red255\green255\blue0;\red255\green255\blue255;\red0\green0\blue127;\red0\green127\blue127;\red0\green127\blue0;\red127\green0\blue127;\red127\green0\blue0;\red127\green127\blue0;\red127\green127\blue127;\red192\green192\blue192;}{\info{\creatim\yr2008\mo7\dy29\hr2\min53\sec17}{\version1}{\vern262367}}\paperw12240\paperh15840\margl257\margr324\margt239\margb260\deftab720\pard\ql{\f0\fs20\cf0\up0\dn0 \loch\af0 Let's see}} {\rtf1\ansi\deff0{\fonttbl{\f0\froman Tms Rmn;}}{\colortbl\red0\green0\blue0;\red0\green0\blue255;\red0\green255\blue255;\red0\green255\blue0;\red255\green0\blue255;\red255\green0\blue0;\red255\green255\blue0;\red255\green255\blue255;\red0\green0\blue127;\red0\green127\blue127;\red0\green127\blue0;\red127\green0\blue127;\red127\green0\blue0;\red127\green127\blue0;\red127\green127\blue127;\red192\green192\blue192;}{\info{\creatim\yr2008\mo7\dy29\hr2\min53\sec17}{\version1}{\vern262367}}\paperw12240\paperh15840\margl257\margr324\margt239\margb260\deftab720\pard\ql{\f0\fs20\cf0\up0\dn0 \loch\af0 won't work in PB 10.5}}

And in PB 10.5 is:

{\rtf1\ansi\ansicpg1252\uc1\deff0{\fonttbl

{\f0\fswiss\fcharset0\fprq2 Arial;}

{\f1\fswiss\fcharset0\fprq2 Tahoma;}

{\f2\froman\fcharset2\fprq2 Symbol;}}

{\colortbl;\red0\green0\blue0;\red255\green255\blue255;}

{\stylesheet{\s0\itap0\f0\fs24 [Normal];}{\*\cs10\additive Default Paragraph Font;}}

{\*\generator TX_RTF32 11.0.401.504;}

\deftab1134\paperw12240\paperh15840\margl0\margt0\margr0\margb0\pard\itap0\plain\f1\fs20 let's see}{\rtf1\ansi\ansicpg1252\uc1\deff0{\fonttbl

{\f0\fswiss\fcharset0\fprq2 Arial;}

{\f1\fswiss\fcharset0\fprq2 Tahoma;}

{\f2\froman\fcharset2\fprq2 Symbol;}}

{\colortbl;\red0\green0\blue0;\red255\green255\blue255;}

{\stylesheet{\s0\itap0\f0\fs24 [Normal];}{\*\cs10\additive Default Paragraph Font;}}

{\*\generator TX_RTF32 11.0.401.504;}

\deftab1134\paperw12240\paperh15840\margl0\margt0\margr0\margb0\pard\itap0\plain\f1\fs20 afdsf}

This is not a bug, but a difference in the string with CopyRTF.

Workaround is to strip out and throw away all carriage return and newline combinations in the strings returned by CopyRTF.

long ll_pos, ll_all

string ls_temp

ll_all = len( ar_instring)

ls_temp = Trim(ar_instring)

// Search for and strip out all carriage return and newline combinations.

ll_pos = Pos ( ls_temp, "~r~n" )

do while ll_pos <> 0

ls_temp = Left(ls_temp, ll_pos - 1) + Right(ls_temp, ll_all - (ll_pos + 1))

ll_all = len(ls_temp)

ll_pos = Pos ( ls_temp, "~r~n" )

loop

Return ls_temp

Versions and Build #s Tested: 11.2_8565, 11.2_8542

Database/Driver File/Version: N/A

Comments: Within WebForms, when tabbing between datawindow editmask columns, the cursor gets positioned at end of edit mask, not at the beginning, as expected. Works fine in normal client-server application.

and retrieving a dw that has a column with a timestamp datatype, the following

error message appears:

Unexpected error was thrown, the browser will be closed!

Please report the error to the Administrator

Error: Syntax Error

Line: 70304879

that includes a structure is deployed to EAServer. When the proxy is generated

in PB, the decimal definition in the structure is different.

The structure is defined as:

global type str_test_val from structure

decimal{4} id_dec4_var

decimal{0} id_decvar

string is_stringvar

decimal{4} id_decvar2

end type

When the proxy is generated, the structure definition is:

global type proxytest_str_test_val from structure

public:

Decimal id_dec4_var

Decimal id_decvar

String is_stringvar

Decimal id_decvar2

end type

Failed to find the proxy to represent the Java class: test.Bar

It implements the following interfaces: test.BarHome

The error is happening when calling

barslist.get(i)

barslist is defined as List

Exception Type: System.IO.DirectoryNotFoundException

Exception Message: Could not find a part of the path 'c:\e drive\11.5bugs\11460181\smc_winformoutput\'.

The deploy/publish seemed to go OK and you can run the app. But what is that error mean? Why is it there if the publish went OK?

If a non-visual user object has a reference to an instance variable in an ancestor NVO, a static reference would fail.

Do not use:

public constant string PATH = n_ancestor_obj.gs_USERPATH

but use:

public string PATH

path = n_ancestor_obj.gs_USERPATH

A treeview dw is setup as:

- 100

-Firstname last name address

When you click on the node or 100, JAWS is not indicating the value. When you click

inside the node, JAWS indicates the value ok

RESOLUTION: The root cause is that the column in the header band is readonly which could not get the focus, so the value could not indicated by JAWS.

from the System Options/Profiling tab, the path and filename not getting saved.

When you restart PB, the path and file name for the trace file (xxxx.pbp) is no longer there.

These settings do appear in the pb.ini:

ProfEnable=1

ProfOverwrite=1

ProfFileName=C:\mytest.pbp

ProfLabel=

ProfTimerKind=2

ProfTraceActivities=1042

Component/Server Host tab, the ddlb does not drop down properly. When

you click on the arrow, the behavior appears more like a spin control and

ddlb.

of characters containing a multibytes character to a varchar2(4000) column on a table through O84 interface.

dw_1.Modify("DataWindow.Help.File='C:\Program Files\Sybase\PowerBuilder 11.0\Help\pbhlp110.cnt' ")

and not just

dw_1.Modify("DataWindow.Help.File='C:\Program Files\Sybase\PowerBuilder 11.0\Help\pbhlp110.hlp' ")

[Library]

SccPBGRefresh=nnn

To turn of this optimization and force a re-synch of the PBG file each time, set SccPBGRefresh=0.

as in previous versions but is wrapped to the page size.

Display of the DataWindow looks different then in previous versions with indentation

and gray outline.

Versions and Build #s Tested: PB 11.2_8599

Database/Driver File/Version: N/A

Comments: In WebForm, the messagebox buttons Yes/No/Cancel should change from English to another language when setting ASP.NET "Culture" and "UI Culture" options. When running same application directly in client-server environment (outside WebForms) in Windows with another language than English (eg: Spanish), the buttons Yes/No/Cancel appear in the other language as expected (eg: Si/No/Cancelar in Spanish).

Clicking in an empty area of a DataWindow that has script in the clicked event

gives a System.ArgumentException

This problem is reproducible when deployed to some PC's but not on others.

more gracefully so that running processes can be finished first.

DataWindow property "Use Ellipses" is *NOT* indexed in the PB Help file and can not be located via any search mechanism.

->This works: select tab1_id, :al_RetrArg from tab1

As a workaround, DBParm DisableBind=1 can be used, but results in bad perfomance.

1. if start PB 11.2 first, PB 11.5 will go to grace mode, PB 11.2 will work properly.

2. if start PB 11.5 first, both PB 11.5 and PB 11.2 work properly.

Attempted to read or write protected memory

From the online help, it states that RTE style datawindow is not supported with WebForm.

Customer would like to see PB catch the error and exit gracefully.

as running in pbnative. The WebForm datawindow is not populated with the

Search Criteria.

Workaround:

Delete the old license file: pb115.lic.

The new license now works. The underlying reason is the old license file sitting on disk is confusing SySAM.

Also in the test case as you tab through fields when you come to a dddw, it tabs to the next window control rather than continuing to tab through the datawindow columns.

sharedobject that is calling a webservice.

In PB 11.2, deploying a webform is ok. Getting the following error when calling it:

Current Thread State: Background

Method: System.Reflection.MethodInfo b()

Exception Type: System.NullReferenceException

Exception Message: System.NullReferenceException: Object reference not set to an instance of an object.

at ql.b()

at ql.Invoke(PBSessionBase A_0)

at Sybase.PowerBuilder.PBMethodQueue.ExecuteAll()

at Sybase.PowerBuilder.Web.PBSession.a()

Exception Source: Sybase.PowerBuilder.Common

Exception StackTrace: at ql.b()

at ql.Invoke(PBSessionBase A_0)

at Sybase.PowerBuilder.PBMethodQueue.ExecuteAll()

at Sybase.PowerBuilder.Web.PBSession.a()

Exception Call Stack: at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)

at System.Environment.get_StackTrace()

at Sybase.PowerBuilder.PBLogger.a(Exception A_0, LogLevel A_1, Boolean A_2, Boolean A_3)

at Sybase.PowerBuilder.PBLogger.a(Exception A_0, LogLevel A_1, Boolean A_2)

at Sybase.PowerBuilder.PBLogger.a(Exception A_0, LogLevel A_1, Boolean A_2)

at Sybase.PowerBuilder.PBLogger.LogException(Exception e, LogLevel logLevel)

at Sybase.PowerBuilder.PBLogger.LogException(Exception e)

at Sybase.PowerBuilder.Web.WebThread.a(Exception A_0)

at Sybase.PowerBuilder.Web.WebThread.a(Object A_0)

at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state)

In PB 11 the search not happening in a browser if the datawindow Web Datawindow property is checked. This worked fine in PB 9. But in 11 if you click on the dddw column the search does not happen. It still happens if you tab into the column, but not when you click on it. It also seems like the drop down is differrent. It's static, always the same drop down, no matter what value is currently displayed. Normally if there is a value displayed in the dddw column and you click on it to get the drop down, the current value heads the list. But with Web Datawindow property checked, you always get a static dropdown of the initial values, and the single character search does not work.

Coding the ItemError Event in a DataWindow prevents DataWindow Clicked Event

to postback to the server when clicking in a column area.

time and you are prompted to "Do you want to install DirectX?", if you hit

ok, the install appears to hang or not install at all on vista

destroying the connection object, the runtime monitor or netstat -a still

shows the connection is established.

For OLEDB this is controlled by the pbodb110.ini file. It is located in the C:\Program Files\Sybase\Shared\PowerBuilder directory. In the [Microsoft SQL Server] section you'll see:

PBFunctions='SYBASE_FUNCTIONS'

and in the [SYBASE_FUNCTIONS] section you'll see:

[SYBASE_FUNCTIONS]

AggrFuncs=ave(),sum()

Functions=substr()

Only three functions listed. So the customer can edit this and add more functions.

This CR is a request to more properly populate the function list for MS SQL Server in the pbodb110.ini file. Let's start he user off with the same functions listed as with MSS or SNC.

To send this by using the PhoneCall.MakeCall() function, doesn't work.

Versions and Build #s Tested: PocketBuilder 2.5.1 Build 1155

Database/Driver File/Version: ASA 10.0.1_3722 with Mobilink

Comments:

Application shuts down with GPF when starting Ultralite synchronization. The application shuts down abruptly and Event Viewer registers the GPF:

Faulting application PK25.exe, version 2.5.0.1123, faulting module ulrt10.dll, version 10.0.1.3722, fault address 0x0002f9f3.

The application, C:\Program Files\Sybase\PocketBuilder 2.5\PK25.exe, generated an application error The error occurred on 09/10/2008 @ 11:05:14.750 The exception generated was c0000005 at address 018EF9F3 (ulrt10!ULSimulateRuntimeAssertion)

The same crash happens with this application after deployed to a Pocket PC.

In PowerBuilder a datawindow with a retrieval argument has this for SQL:

SELECT "MY_NULL"."A",

"MY_NULL"."B"

FROM "MY_NULL"

WHERE "MY_NULL"."B" = :s_argument

If the value of your retrieval argument is null PB generates the following SQL at run time:

SELECT "my_null"."a", "my_null"."b" FROM "my_null" WHERE ( "MY_NULL"."B" IS NULL )

This statement correctly returns the row where B is a null. But PB has changed SQL from B = NULL to B IS NULL, and it should not be doing this as they mean different things and return different result sets..

A quick analysis on the web confirms the technical correctness of the customer's argument. However it is a controversial area with many tools coming down on the side that PB has. And some as the customer points out (Oracle SQL Developer) coming down on the other side. Changing the behavior at this point would have a tremendous impact on existing customers. Perhaps Engineering could supply an explanation of why PB does what it does in this area?

Versions and Build #s Tested: PB 10.5.2_7699 and PB 11.2_8616

Database/Driver File/Version: N/A

EAServer 6.2 and/or 5.5 for Windows

We deploy a dummy JSP page into EAServer 5.x or 6.x with the following HTML Code:

<P><IMG id="IMG1" src="../images/128_lg.jpg"></P>

After deploying the page, we enter the EAServer WebApplication directory and open the jsp page. The slashes are transformed into backslashes:

<P><IMG id="IMG1" src="..\images\128_lg.jpg"></P>

This causes some confusion for Internet Explorer when jsp is deployed to remote EAServer since it will look at local physical directory instead of virtual directory. As a result, images are not loaded.

When a breakpoint is added in the uf_itemchanged of na_req_details in reqent_v.pbl.

Also triggered is the itemchanged in the uo_rules_req_detail in the reqent_v.pbl and

the itemchanged in the u_dwa_rules_1 in the inh_vuo_pbl.

RESOLUTION: Engineering provided workaround.

throw xxx, pb will not throw to the exception instead it will continue on with the code.

When you call a webservice and the retrieve fails, it will trigger the dberror event.

In the dberror it has a statement: throw lse. Instead of throwing that exception,

it will continue will the next line of code in the getcustomerinfo.

RESOLUTION: PB does not support the exception/runtimeerror thrown in DBERROR Event

RESOLUTION: PB does not support Any return type because we do not know the exact type ,and so we can not map it to a PB data type.

VS .Net WebService treats its XmlNode derived type as the WSDL Any type.And VS.Net treats the Any type in WSDL as XmlNode type.I guess the Sharepoint webservice is made by VS.Net platform.So Visual Studio.Net can consume it .

Workaround:

1. At design time, use Web Service as normal: choose to use ".NET engine" so that Pb will generate a new assembly (mytest.dll, for example in this testcase).

2. Create a WinForm target based on the existing PB target(sharepoint.pbl).

3. Go to the property dialog of the new Winform target -- right click the new Winform target and choose properties

4. Go to the ".NET Assemblies" tab to add mytest.dll as reference

5. using the following code to call the web service.

#if defined PBWINFORM then

WebService.Lists ws

ws = create WebService.Lists

ws.PreAuthenticate = true

ws.Credentials = create System.Net.NetworkCredential("sharepointsetup", "xocu3xxxxri", "xxxxx")

ws.Url ="https://xxxxxxx/sites/xtestxxxx/_vti_bin/lists.asmx"

System.Xml.XmlNode node1

node1 = ws.GetList( "Announcements")

string ss

ss = node1.OuterXml

messagebox("OK", ss)

#end if

Database value: 2.06479860179892282E-016.

PB 10.2 decimal column: 0.000000000000000206 (correct for 18 digits precision)

PB 10.5 decimal column: 20647986017989224 (incorrect decimal point)

10.5 decimal value should be 0.00000000000000020647986017989224

group datawindow, pb will crash at:

FAULTING_IP:

PBDWE110!dwexpr_eval_aggr+6c [e:\pb11\dw\engine\common\dwexprd.cpp @ 284]

1087a1dc 8b14b2 mov edx,[edx+esi*4]

STACK_TEXT:

0012de30 1087aeff 05c5f994 00000000 0012dfc0 PBDWE110!dwexpr_eval_aggr+0x6c [e:\pb11\dw\engine\common\dwexprd.cpp @ 284]

0012df34 1087e8a8 0012df5c 01531e48 0012dfc0 PBDWE110!dwexpr_eval_datetime+0x49f [e:\pb11\dw\engine\common\dwexprd.cpp @ 218]

0012df64 1087fae4 0012dfc0 00000000 0153138c PBDWE110!dwexpr_eval_stringdatetime+0x18 [e:\pb11\dw\engine\common\dwexprs.cpp @ 2690]

0012df74 1087f945 015313b4 0012dfc0 0153138c PBDWE110!dwexpr_eval_string+0x344 [e:\pb11\dw\engine\common\dwexprs.cpp @ 238]

0012df8c 10868323 0153138c 0012dfc0 012226b8 PBDWE110!dwexpr_eval_string+0x1a5 [e:\pb11\dw\engine\common\dwexprs.cpp @ 287]

0012e804 107fcd3f 012073b0 0102fb88 0012e848 PBDWE110!dwexpr_compute_gob+0x213 [e:\pb11\dw\engine\common\dwexpr.cpp @ 605]

Trying to add the following computed field:

string(first(start_date for group 1))

The .Net SOAP enveloppe request is found to be empty with certain complex datatypes

and on \\adc-cn-pbbld\pse_folder. The zip contains the dump file.

Powerbuilder 11.1, EAServer 5.5, ASE 12.5 and OpenClient 12.5.

They have 20 servers in a cluster. Six of them are naming servers. They weren't sure, but the datawindows they have problems with could be composite or nested.

PB should be able to throw an exception from anywhere.

From cr544054, there is an restriction that you cannot throw an exception/runtimeerror

from the dberror event.

But when he tries to run either PB 11.2 or PB 11.5 it crashes out of PB. The TSE tried to repro here and for him he can start either PB, but only in eval mode, the customer is not even getting that. Similar to CR 542158.

Please see the following 2 explanations:

(1) It says on page 760 : "you must always rebuild the entire application and deliver all the dynamic libraries to customers where you make a revision to any library."

But,

(2) It says on page 762: "If changes are isolated and do not affect inherited objects in other PBSs, you might be able to distribute individual PBDs to your users to provide an upgrade or bug fix."

do not trigger the pbm_keydown event or they trigger some other windows function.

For example, when I hit F6 on the WM5 emulator the volume control pops up. When

I hit F2 the pbm_keydown event doesn't fire.

From MSN: http://msdn.microsoft.com/en-us/library/bb431750.aspx

F2 maps to VK_F2 (0x71) and F4 maps to VK_F4 (0x73)

Versions and Build #s Tested: PB 10.5.2_7757

Database/Driver File/Version: MS SQL Server 2000 - connecting via PB ODB interface

Comments: DECLARE...PROCEDURE / EXECUTE fails when executed from within a PB NVO component. But the same code works fine when executed within standard client server application and procedure returns one row in resultset as expected.

when an object is saved with a maximum length object name (40 chars).

or when selecting a starteam project

Using the workaround of CreateJavaVM=0 does not appear to work in PB 11.5.

RESOLUTION: Works ok in PB 11.5 (build 3045) using CreateJavaVM=0. But it is

not working in PB 11.5 GA. You also need to null out the JDK and JRE path under Tools/System Options in the PB IDE.

Group boxes appear longer and it interferes with the rest of the format of the page.

Using the w_m_ftp_account_setup window in the ftpacct.pbl.

When you rmb on the requisition id field in PBNative, you see the following items

on the popup menu:

Search

Save

New

Retrieve

Delete

Insert

Sort

Print Label

When you run the same app in PB .NET WebForm, the following items appear on the

popup menu:

Undo

Cut

Copy

Paste

Delete

SelectAll

Using the w_print_shipping_label window in the label.pbl.

Rbuttondown code is in the dw_row_count on the w_print_shipping_label

Problem happens in 2 places:

w_print_shipping_label in the labels.pbl

w_m_setup_user in the users.pbl

RESOLUTION: Workaround found. Added i_uo_header.taborder to the sle and then

was able to retrieve by tabbing out.

blanks gets inserted when letters are pasted and and dots gets inserted when

pasting fractional values.

on the item id or warehouse column, a popup menu should appear but does not.

Works ok in PBNative. Using the w_m_report_item_audit in the itmaudit.pbl.

Custom objects are not properly initialized in the Resize event having size 0.

not have admin privileges, the following error appears:

Unicode Font Substitution

PowerBuilder failed to change the Unicode font substitution. You must run

at least once with administrator privileges to complete this process

Problem happens on winxp and vista. Worked ok in PB 11.2 where user did not

have admin privileges.

PowerBuilder Engineering has determined that this font substitution logic is no longer necessary in PB 11.5. With this fix applied, the initialization logic that leads to this FDCC warning has been removed.

error.

The following appears in the Jaguar log file:

Oct 03 13:46:46 2008: 0000007788 PB INTERNAL EXCEPTION on: Thread : 7788, Address : 0x0E4C9C9E, Type : EXCEPTION_INT_DIVIDE_BY_ZERO. CPB_Component::invoke

Oct 03 13:46:46 2008: 0000007788 Dump Ignored

Oct 03 13:46:46 2008: 0000007788 Fatal Error Occurs when try to invoke PB method of_getreport in CISReport4CIS/n_cst_bso_rpt_interface_mgr.

Oct 03 13:46:46 2008: 0000007788 Fatal Error Occurs in PB Component, Jaguar Terminated.

FAULTING_IP:

PBDWE110!dwTableAggrSortCmp+9303

08a5c1e3 8b6d00 mov ebp,[ebp]

EXCEPTION_RECORD: ffffffff -- (.exr ffffffffffffffff)

ExceptionAddress: 08a5c1e3 (PBDWE110!dwTableAggrSortCmp+0x00009303)

ExceptionCode: c0000005 (Access violation)

ExceptionFlags: 00000000

NumberParameters: 2

Parameter[0]: 00000000

Parameter[1]: 00000007

Attempt to read from address 00000007

FAULTING_IP:

PBVM110!ob_type_vtable_module_srch+aa

082aa05a 668b5cd102 mov bx,[ecx+edx*8+0x2]

EXCEPTION_RECORD: ffffffff -- (.exr ffffffffffffffff)

ExceptionAddress: 082aa05a (PBVM110!ob_type_vtable_module_srch+0x000000aa)

ExceptionCode: c0000005 (Access violation)

RESOLUTION: Problem was a group loader issue in the pbvm. Fix is in PB 11.2 (build 8669) and after.

2008-10-02 17:29:48.619 INFO Thread-70 [JaguarServer] Warning: protocol "iiops" not supported.

2008-10-02 17:29:48.697 INFO Thread-70 [JaguarServer] n_case: : Jaguar Component Property Error: 'com.sybase.jaguar.component.report.librarylist' Not Found.

2008-10-02 17:29:48.712 INFO Thread-70 [JaguarServer] n_case: : File : C:\Apps\Astellas\11477533\d_wf_crf_status_report.dat

2008-10-02 17:29:48.712 INFO Thread-70 [JaguarServer] n_case: : File Opened Successfully

2008-10-02 17:29:48.712 INFO Thread-70 [JaguarServer] n_case: : Blob Size : 175988

2008-10-02 17:29:49.806 INFO Thread-70 [JaguarServer] n_case: : File : C:\Apps\Astellas\11477533\d_wf_crf_status_report.dat

2008-10-02 17:29:49.806 INFO Thread-70 [JaguarServer] n_case: : File Opened Successfully

2008-10-02 17:29:49.806 INFO Thread-70 [JaguarServer] n_case: : Blob Size : 175988

2008-10-02 17:29:51.322 INFO Thread-70 [JaguarServer] n_case: : File : C:\Apps\Astellas\11477533\d_wf_crf_status_report.dat

2008-10-02 17:29:51.322 INFO Thread-70 [JaguarServer] n_case: : File Opened Successfully

2008-10-02 17:29:51.322 INFO Thread-70 [JaguarServer] n_case: : Blob Size : 175988

FAULTING_IP:

PBSHR110!PbHeap_free+412

07d2c502 833800 cmp dword ptr [eax],0x0

EXCEPTION_RECORD: ffffffff -- (.exr ffffffffffffffff)

ExceptionAddress: 07d2c502 (PBSHR110!PbHeap_free+0x00000412)

ExceptionCode: c0000005 (Access violation)

ExceptionFlags: 00000000

NumberParameters: 2

Parameter[0]: 00000000

Parameter[1]: 240a0d0d

Attempt to read from address 240a0d0d

for using file operations like FileOpen, FileRead, FileWrite

Versions and Build #s Tested: 10.5.2 build 7757 and 11.2 build 8616

Database/Driver File/Version: PBODB interface, connecting to MySQL 6.0

Comments: In DW Painter, when creating a dw based on two tables with a relationship between them, a GPF occurs at PBUDO105.dll (See dmp and log files attached to reproduction for details).

It works fine when tables involved have no relationship between them.

PBCommandParm not correct sometimes for multiple client sessions on same PC.

This only occurs when used in a machine code executable. Running in both the IDE and a Pcode executable does not result in the error.

It is recently discovered that user cannot use "TAB" key to move focus in controls of

userobjects, which is dynamically opened by those functions.

com server.

In PB 9 the response time was less than a second when simulating 100 concurrent users.

In PB 11, the response time dramatically increases.

RESOLUTION: Engineering suggested to upgrade to PB 11.5 (it has better performance

for com) and suggested a coding change to improve performance.

itemchanged event which produces an error. Then if you tab into the Item ID and enter a value and then tab out, the ItemChanged event doesn't appear to fire.

and trying to preview and datawindow of type label, it causes the print preview

to be greyed out.

RESOLUTION: Paper size was left blank. By using Default(0) for the paper size

resolved the issue.

Versions and Build #s Tested: PB 11.2_8616 and 11.5_2506

Database/Driver File/Version: PBODB interface connecting to DafaFlex

Comments: PB displays DataFlex tables columns and data truncated in DB Painter. When displaying "Edit Data - Grid", the 1st column with one row is displayed, only. When querying via ISQL Session, all columns are displayed, but only one row.

box appears.

Works ok in PBNative.

According to the doc:

*****

CHAPTER 5 Developing and Deploying PowerBuilder Components

CORBA Components Guide

The PowerBuilder ErrorLogging class writes errors to

%DJC_HOME%\logs\pb-server.log. To use PowerScript to create an instance

of the class and to log messages, use the following syntax:

ErrorLogging logger

getContextService("ErrorLogging", logger)

logger.log("My Message")

*****

The errorlogging component writes to the system log, not "pb-server.log"

when you change the message name, it changes it in the wsdl but the

operation name doesn't change and customer believes it should.

<wsdl:operation name="of_return_name">

From the stack trace, problem may be happening further down:

3c9ed528 09794896 616e614d 00000000 00000000 PBSYJ110!Syc1_GetError+0x2a [e:\pb11\db\sycli\pbsyc1.cpp @ 4107]

3c9ed53c 0979b7c4 616e614d 0000000c 00000001 PBSYJ110!Syc1_PutError+0x16 [e:\pb11\db\sycli\pbsyc1.cpp @ 2656]

3c9ee59c 20726576 616e614d 5d726567 74614420 PBSYJ110!Syc1_DoJaguarLogin+0x444 [e:\pb11\db\sycli\pbsyc1.cpp @ 6762]

WARNING: Frame IP not in any known module. Following frames may be wrong.

3c9ee630 097925f7 0c191818 00000000 004c2c59 0x20726576

3c9ee684 085c51e3 0c191818 0bca9968 0ccc9064 PBSYJ110!PB_DB_Rout+0x737 [e:\pb11\db\sycli\pbsyc1.cpp @ 1126]

3c9ee698 08a7edde 0b6edec8 0c62e9b8 0ce14470 PBSHR110!DBI_LogIn+0x123 [e:\pb11\shared\pbshr\pbdbi1.cpp @ 1481]

3c9ee714 08b29e45 0c191818 0c13b2b8 0bca9968 PBVM110!rtdb_start+0x27e [e:\pb11\runtime\obtools\otdbwork.cpp @ 2143]

3c9ee728 08a84ae9 0bca9968 090d43e4 0bca9968 PBVM110!sfdb_start+0x45 [e:\pb11\runtime\semfuncs\sfdbsem3.cpp @ 286]

3c9ee838 08a07fca 0bca9968 090cde3a 090d4310 PBVM110!rt_exec_pcode+0x249 [e:\pb11\runtime\engine\rtengine.cpp @ 845]

3c9ee88c 08a075d9 00008002 0ccd2404 00000034 PBVM110!OB_RUNTIME_CLASS::invoke+0x9da [e:\pb11\runtime\obj_mgr\obclass.cpp @ 2745]

3c9ee8d4 08a25dbd 0bca9968 0ccd2404 00000034 PBVM110!OB_RUNTIME_CLASS::invoke+0x1c9 [e:\pb11\runtime\obj_mgr\obclass.cpp @ 2320]

3c9ee8f8 08a73696 00000000 00000034 00000000 PBVM110!OB_OBJECT_LOCAL::invoke+0x2d [e:\pb11\runtime\obj_mgr\obobjloc.cpp @ 1262]

3c9ee970 08b26d5a 0bca9968 000001f8 00000000 PBVM110!ot_process_dotfunccall+0x4c6 [e:\pb11\runtime\obtools\otcalls.cpp @ 331]

3c9ee994 08a84ae9 0bca9968 0bcc2582 0bca9968 PBVM110!sf_dotfunccall+0x3a [e:\pb11\runtime\semfuncs\sfcalls.cpp @ 90]

3c9eeaa4 08a07fca 0bca9968 0bcc73c2 0b38b0b8 PBVM110!rt_exec_pcode+0x249 [e:\pb11\runtime\engine\rtengine.cpp @ 845]

3c9eeaf8 08a075d9 00008002 0ccd2404 00000059 PBVM110!OB_RUNTIME_CLASS::invoke+0x9da [e:\pb11\runtime\obj_mgr\obclass.cpp @ 2745]

3c9eeb40 08a25dbd 0bca9968 0ccd2404 00000059 PBVM110!OB_RUNTIME_CLASS::invoke+0x1c9 [e:\pb11\runtime\obj_mgr\obclass.cpp @ 2320]

3c9eeb64 08a5f28c 00000000 00000059 359a0006 PBVM110!OB_OBJECT_LOCAL::invoke+0x2d [e:\pb11\runtime\obj_mgr\obobjloc.cpp @ 1262]

3c9eebb8 08ad5cbd 00000000 359a9480 0c8d419c PBVM110!OB_OREQ_INVOKE::Execute+0x14c [e:\pb11\runtime\obj_mgr\obremreq.cpp @ 245]

3c9eebec 08ad69c7 0c8d419c 00000001 34d04528 PBVM110!CPB_Object::ExecRequest+0x2bd [e:\pb11\runtime\dpb\jagserv\objagsrv.cpp @ 2599]

3c9eec28 08ad71a3 0d760aac 34d04528 089f63ee PBVM110!CPB_Object::doInvoke+0x267 [e:\pb11\runtime\dpb\jagserv\objagsrv.cpp @ 1789]

3c9eec34 089f63ee 0c8d419c 34d04528 08ad44be PBVM110!tryInvoke+0x13 [e:\pb11\runtime\dpb\jagserv\objagsrv.cpp @ 1654]

3c9eec40 08ad44be 08ad7190 0c8d419c 34d04528 PBVM110!srv_catch_exception+0xe [e:\pb11\runtime\obj_mgr\objagm.cpp @ 7683]

3c9eec54 08ad77ba 08ed73a0 08ad7190 0c8d419c PBVM110!OB_JAGLIB::ob_srv_catch_exception+0x1e [e:\pb11\runtime\h\objagm.h @ 865]

3c9eeca4 08ad6d7d 0c8d419c 34d04528 359a9480 PBVM110!CPB_Object::invoke+0x6a [e:\pb11\runtime\dpb\jagserv\objagsrv.cpp @ 1599]

3c9eecec 004961c2 0ce16888 34d04528 34d045e4 PBVM110!PBObject_invoke+0x16d [e:\pb11\runtime\dpb\jagserv\objagsrv.cpp @ 2904]

3c9eed08 00423075 34d04528 34d045e4 00000000 libjdispatch!Jaguar_Properties::allocbuf+0xa2

3c9eef34 0042c54d 3c9ef8e8 00000000 364672e0 libjdispatch!CORBA_SystemException::CORBA_SystemException+0x35 [Y:\calm\conn\itg\distrib\generic\include\JagORB.hpp @ 106]

3c9efa2c 0044d8ef 34d04528 01ab9a20 34d045e4 libjdispatch!CTS_Component::getSpecifiedIdentity+0xaf4 [Y:\calm\conn\itg\jagsrv\generic\dispatch\CTS_Component.cc @ 3384]

3c9efe64 0044f15d 01ab9a20 01ab9a20 3c9efe88 libjdispatch!_Ex_CosNaming_NamingContext::resolve+0x29f [Y:\calm\conn\itg\distrib\generic\include\CosNaming_NamingContext.hpp @ 1585]

3c9efe74 005fa5c6 01ab9a20 3c9efe90 01ab9a20 libjdispatch!CosNaming_NamingContextExt::bind_context+0x8d [Y:\calm\conn\itg\distrib\generic\include\CosNaming_NamingContextExt.hpp @ 987]

3c9efe88 005c2ee4 3c9efec8 005c2e5b 01ab9a20 libjsrv!srv__act_thread_props+0x671 [Y:\calm\conn\itg\srvlib\generic\src\ostprops.c @ 2088]

3c9efe90 005c2e5b 01ab9a20 0044f140 01ab9a20 libjsrv!srv_alloc_SybHeap+0x4a [Y:\calm\conn\itg\srvlib\generic\src\alloc.c @ 101]

3c9efec8 005c3096 0b7e3dd4 02c866cc 00000000 libjsrv!srv_alloc2+0x2b [Y:\calm\conn\itg\srvlib\generic\src\alloc.c @ 54]

3c9efefc 003bc609 00e2482c 0b7e3dd4 3c9eff18 libjsrv!srv_callback+0x36 [Y:\calm\conn\itg\srvlib\generic\src\callback.c @ 51]

3c9eff5c 003bad0e 03a23c88 003bc500 0103a7e8 libjtcl!dict_cant_modify+0x513

3c9eff74 00392b97 00000000 36466fa8 3c9effb8 libjtcl!dict_read+0x26e [Y:\calm\conn\itg\netlib\generic\dcl\dc_ini.c @ 182]

3c9eff84 77bcb530 36466fa8 00000000 00000000 libjtml!tml_recursive_mutex_unlock+0x1f [Y:\calm\conn\itg\tmlib\generic\src\win32_synch.c @ 383]

3c9effb8 77e64829 3645bfe8 00000000 00000000 msvcrt!_endthreadex+0xa3

3c9effec 00000000 77bcb4bc 3645bfe8 00000000 kernel32!BaseThreadStart+0x34

RESOLUTION: Root cause is the DBMS of PB was not the same as the DBMS of EAS connection.

The customer has identified how this happened, and will

make the necessary fix.

it causes the compile to fail with a linker error.

Problem happens for mcode and pcode.

In PB 10.5.2, when the exe failed, it generated the following message:

Unresolved resource 'mybmp.bmp'referenced from object 'w_bmp_main.win'

The same message should appear in PB 11.2 and PB 11.5.

Error C0163: The definition of referenced global variable gnv_app was improperly compiled in object a_producim_xx999

Error C0046: Illegal datatype for within clause: m_edit

Request to be able to declare initial values for structures

then the datawindow is reset, the previous value tooltip still shows up even though

that row is no longer there.

For example, a datawindow has 5 rows. Tooltip.tip is being set at runtime

in a computed expression using setitem. You place the cursor at row 4 then dw.reset

is processed and 1 row is then added. When you move the cursor over to where

it was previously to the dw_1.reset, the tooltip for the 'reset' row still shows.

f_transit_reconciliation_tout_tin(QSSWWWWSSSBSSSLS)(688,295): error CS0026: Keyword 'this' is not valid in a static property, static method, or static field initializer

All the objects that are reporting errors are using Exectute Immediate and other database functions. I do not see anything in the code that is not supported.

One other thing to note is that this is the same testcase as CR 545441 and after that was fixed and verified, other new deployment errors were reported and these ended up being objects that the customer had edited the source code and I was able to correct those errors.

dw_1.modify('datawindow.querymode=yes')

dw_1.modify("lname.background.Color=536870912")

When using editmasks the issue does not occur.

The leak might be related to SyntaxFromSql in combination with other functions.

The � "z" with dot above ("ż") entered as Right Alt (Alt Gr) + Z

on a Polish keyboard clears text in RTE instead of entering the z dot.

If a text field in a DataWindow contains single and double quotes it is not easy to use the described string, change it and apply it with modify(). Since the string contains the special characters the tilde nesting needs to be added, which makes it quite complicated.

error:

The request for procedure 'fn_count_grp_attr' failed because 'fn_count_grp_attr' is a SQL function object.

RESOLUTION: Call SQL function like any ASE function. To use it in embedded sql, use:

SELECT dbo.fn_override_cnt_grp_attr(:li_grp_id) INTO :ll_grp_attr_count FROM dt_override_grp_attr USING SQLCA;

Support the use of a cursor or pointer with .NET WebForm applications.

An option or property to leave the vertical column Scrollbar visible,

when a multiline DataWindow column looses focus, behaving similar to a multiline control on a window.

is it opening a window and retrieving to a dw and then closing the window, you

can see that available keeps dropping.

The application is monitoring memory by using the GlobalMemoryStatus api

RESOLUTION: Not a bug. App needed to run longer to see that memory stabilized.

on the 'Window' menu item, the items appended to the Window menu appear corrupt.

What shows up is:

-Window

- Tile Horizontal

- Tile Vertical

- Layer

- Cascade

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

- Arrange Icons

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

- Alliant Tools

- Tools for Instances

- Tools for Instances

- Alliant Tools

What should be showing up is:

-Window

- Tile Horizontal

- Tile Vertical

- Layer

- Cascade

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

- Arrange Icons

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

- Alliant Tools

- Tools for Instances

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

- 1 Instances

mdi application and then clicking on the menu item of 'Window', pb will crash

with an access violation in the PBVM:

FAULTING_IP:

PBVM105!OwnerMeasureItem+4a

pMRenderer->OnMeasureItem(pRTMenu, pMeasureItem);

dw edit type of checkbox in PB .NET Webform.

the webservices using the .Net engine. Now the results are returned but they cannot be accessed correctly. Object seems to be null.

With a long operation sometimes the pointer doesn't return back from hourglass to the default pointer until the mouse is moved.

This appears to be a PB problem as it works with O84 and it also works when calling the function from SQLPlus. Only PB 11 using O10 driver crashes.

Customer is crashing on their PowerBuilder client in PBSHR115.dll after a WSDL call and some EAServer activity. The crash file only contains a first chance exception.

and the copies argument is set to a value greater than 1, only 1 copy gets

printed.

This also failed in earlier builds of 11.2. But it does not fail in 11.2 build 8649. In the 11.2 builds that do fail with the O10 driver, using O84 driver does not fail.

In PB 11.5 there is no O84 driver, so it is paramount that this is fixed in 11.5 as it is in PB 11.2 build 8649 as there is no other alternative.

the secondary dw resyncs back to row 1, column 1.

dw_1.sharedata(dw_2)

dw_1.setrow(10)

dw_2.setrow(10)

dw_1.reselectrow(10) dw_1 current row is 10 but dw_2 current row is 1 causing

rowfocuschanged to fire for dw_2 as well

sharedata or the following functions:

reselectrow

setrow

scrolltorow

So that they would keep the shared dws in sync in terms of the current row.

For example, if you are sharing data and do a reselectrow(10) on the primary

dw, the secondary dw with sync to row 1 instead of row 10 which is what the primary

dw is set to.

Workaround: Add for instance the lines in the rowfocuschanged event of the dw.

this.Object.libelle.TabSequence=10

this.Object.libelle.TabSequence=0

The customer claims this worked fine in PB 9.

The issue seem to be introduced somewhere between PowerBuilder 10.5 and PowerBuilder 10.5.1

a noticeable performance degrade is detected. Problem happens on retrieval larger

resultset with multiple concurrent users. According to on-site sybase consultant, similar

problem also happen when compare the performance of PB804 on EAS5.5 with PB10.5.2 on

EAS5.5. In-house testing result, comparetively, "the Connect Time" played a very important role there. Range from 48.6 to 26.9 times of PB804.

Other operations also get a bit degrade.

<m:TheFunction

xmlns:m="urn:namespace....">

<m:InputXml

s:type="y:string">X</m:InputXml>

</m:TheFunction

on a OLE control based on an Outlook .msg file.

for the first time in winforms.

When you click on the command button that fires a messagebox, only the windows deactivate event fires. In PB Native the deactivate and activate events will fire.

Customers request that PowerBuilder should support current JDK/JRE realases (here JDK 1.6)

provided for ADO.NET (OLEDB,ASE,MSSQL and Oracle).

The following is a list of db that all have managed ADO.NET drivers that

PB should work with:

Firebird

MySQL

PostgreSQL

Progress

SQLite3

Sybase SQL Anywhere

Customer would like the namespace dropdown dialogue in the db profiles to be

editable so that other databases can be added and used.

is happening at:

FAULTING_IP:

pbdwe105!dwWinProcEdit+bc22

116acb92 8b14b9 mov edx,dword ptr [ecx+edi*4]

The problem is localized to one window that has several datawindows and several

rich text data objects.

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

OS: Windows XP SP3

Versions and Build #s Tested: PB 10.5.2_7791, PB 11.2_8616 and PB 11.5_3050

Database/Driver: N/A

Comments: RTE Control does not display encrypted RTF documents correctly. Works ok in old PB 7.0.3, by displaying exactly what is displayed in Wordpad.

Customer claims he has followed the correct steps in creating this COM object in VS.NET.

a easerver component as a webservice, pb is crashing in the IDE in the pbvm:

PBVM115!TriggerEvent+2a [e:\pb115\runtime\function\fntrig.cpp @ 1074]

004b378a 837a1c00 cmp dword ptr [edx+1Ch],0

Faulting code in the TriggerEvent of fntrig:

if (!fnThis->bSuspended && ob_inst_defined (pTrig->obInst))

Clicking rapidly on the Next Page link (>) in a DataWindow with multiple pages can cause a javascript error:

Error: 'psPage' is undefined

Line: 6470

Versions and Build #s Tested: PB 11.5_3050

Database/Driver File/Version: SYC with ASE 12.5.4 pubs2 database

Comments: In dw painter, when setting Font - Escapement to 1800 (180�) for a dw column with border, the column content will be rotated to outside the border during retrieve. The column content is correctly upside down, but should be inside its own border.

The milliseconds part of a Timestamp gets dropped when the seconds part is 59.

shows horizontal and vertical scrolls bars, but it is difficult to see the text.

A script in the itemchanged event of an ancestor datawindow will cause a postback when there is an itemchanged event.

This cannot be overrided in a standard way within the Window Painter.

Work-around define a javascript handler for the ItemChanged event in the constructor event of the child datawindow:

#IF DEFINED PBWEBFORM THEN

dw_x.JavaScriptFile = "TheScriptFile.js"

dw_x.OnClientItemChanged = "DummyItemChanged"

#END IF

Add code to the Itemchanged, so that Extend Ancestor Script can be disabled:

#IF DEFINED PBWEBFORM THEN

#END IF

When using FileRead on the ansi ascii file should return the same values (an � = asc(179)), no matter on which OS (english, german, easteuropean, chinese and japanese..) it is run.

1.) Doing the fileread on chinese os, reports inconsistant results.

2.) Doing the fileread on japanese os, returns a japanese character instead of the character returned on english os. an � = asc(179)

when using ShareData().

licensing components.

When deploying a winform application that includes a licensed control, the folloiwng error message appears:

The following exception occurred: This product has not been added to the Project's

licenses.licx file. If your Project does not have a licenses.licx file aready, you

must create a text file named "licenses.licx"and add it to your PROJECT.

You must then add the following line to the file:

'Dart.PowerTCP.EmailValidatin.Validator, Dart.PowerTCP.EmailValidation.Trial'

If the project already contains a licenses.licx, simple append this line to the file.

For more information, please see the "Creating the Licenses.licx File"page

in the online help.

***IMPORTANT***

Any time you make changes to the licenses in your project, you MUST REBUILD the project

that contains the reference to the licensed dll or the changes will not be built into the

application.

Within VS 2005 or later, you must right-click the licenses.licx file and select

'Rebuild Runtime Licenses'.

Also, please be aware that any Project that ultimately references a DART DLL must also include a licenses.licx file, and be compiled on a licensed machine. This includes,

for example, an executable that references a class library, that in turn references a

Dart DLL.

When a .Net class has an object that only has a getter, and the property itself is an object with it's own properties, you can't set the properties in a conditional code block.

The errors isn't from the C# code compile, it's from PB:

C0143: A privatewrite property can be modified only in an event or function in its parent class.

The thing is, .Net allows this. Let's say you have ClassA, which has a property of ClassB which is a getter only. However, if ClassB has properties that have setters and getters, .Net allows you to set the properties as follows:

ClassA myA = new ClassA();

myA.B.prop = 123 ; <- this works fine in .Net.

The code that is called is:

The selection is made in the w_r_mini_lookup in the gbl_lkl.pbl. When clicking

on the OK cb, it returns to ue_lookup in n_rules_setup_structure in acctset.pbl.

The code goes into the choose case and there is a value in the l_str.parms.any_arg[1].

Then a postevent to ue_set_des_and_retrieve_dw2 in acctset.pbl. A call in the

routine is done to uf_retrieve but no data is returned.

w_r_mini_lookup/cb_ok.clicked:

l_l_row = dw_lookup.GetSelectedRow (0)

IF l_l_row > 0 THEN

wf_get_selected_value (l_l_row)

i_b_allow_close = TRUE

i_str_parms.boolean_arg [1] = TRUE

CloseWithReturn (Parent, i_str_parms)

END IF

n_rules_setup_structure/ue_lookup:

l_l_row = i_dw_datawindows [1].GetRow ()

l_s_value_column = i_dw_datawindows [1].GetColumnName ()

CHOOSE CASE l_s_value_column

CASE "structure_id"

l_a_any [1] = "STRUCTUR"

l_str_parms = gf_open_mini_lookup ("dd_code_basic", "code_id", "Structure ID", l_s_sql,"CODE", l_a_any)

IF l_str_parms.boolean_arg [1] THEN

i_dw_datawindows [1].SetText (String (l_str_parms.any_arg [1]))

This.PostEvent ("ue_set_des_and_retrieve_dw2")

END IF

END CHOOSE

n_rules_setup_structure/uf_retrieve:

long l_l_rows

IF i_dw_datawindows [2].Enabled = TRUE THEN

l_l_rows = i_dw_datawindows [2].Retrieve (i_a_retrieval_arguments [1]) << no data gets retrieve here

string ls_string

ls_string = i_a_retrieval_arguments[1]

IF l_l_rows = 0 THEN

i_dw_datawindows [2].InsertRow (0)

END IF

END IF

i_dw_datawindows [2].SetFocus ()

return l_l_rows

RESOLUTION: Engineering provided a code workaround.

The following code behaves differently in PB9 than in PB11.5:

// ****************************************

decimal lr_amount=0.1000

string lr_amount1

lr_amount1=string(lr_amount*100)

messagebox('',lr_amount1) //messagebox 1

lr_amount=0.1234

lr_amount1=string(lr_amount*100)

messagebox('',lr_amount1) //messagebox 2

lr_amount1=string(lr_amount*100,"###.00")

messagebox('',lr_amount1) //messagebox 3

// ****************************************

PB9:

MessageBox 1 shows 10.0000

MessageBox 2 shows 12.3400

MessageBox 3 shows 12.34

PB11.5:

MessageBox 1 shows 10

MessageBox 2 shows 12.34

MessageBox 3 shows 12.34

The customer used string conversion without specifying the precision in many places in his application. Can we support the same precision in PB11.5 as we did in PB9?

following error appears:

Windows Internet Explorer

Unexpected error was thrown, the browser will be closed!

Please report the error to administrator.

Error: Can't move focus to the control because it is invisible, not enabled or of a type

that does not accept focus

Line: 1615

it doesn't appear to be working.

In the n_receipt_reules.uf_action_quick_po in the receipts.pbl, the tab order

for 2 columns are being set:

i_dw_datawindows[1].settaborder("display_price, 61)

i_dw_datawindows[1].settaborder("display_other_charges, 62)

The return code for each line is 0 but the tabbing does not work properly. Works

ok in PBNative.

dll (sas.dll) is used.

The app is crashing with an access violation in pbshr110.

FAULTING_IP:

PBSHR110!PbHeap_free+43e [e:\pb11\3rdparty\heap\spbheap.c @ 2375]

004deade 833f00 cmp dword ptr [edi],0

FOLLOWUP_IP:

PBSHR110!MemFreePtr+11 [e:\pb11\shared\pbshr\pbshsyb.c @ 139]

0048e371 83c404 add esp,4

The call stack shows:

PBSHR110!PbHeap_free(void * ptr = 0x00010000)+0x43e (FPO: [Uses EBP] [1,16,0]) (CONV: cdecl)

PBSHR110!MemFreePtr(void * ptr = 0x00010000)+0x11 (FPO: [1,0,0]) (CONV: stdcall)

.

.

PBVM110!rtPcodeExec(struct ob_this * obThis = 0x00000000, struct ob_group * pobGroup = <Memory access error>, unsigned int uiNoArgs = <Memory access error>, struct ob_data * pobdEvaledArglist = <Memory access error>, struct ot_lvalue_info * potLvalueInfoList = <Memory access error>, void * obInst = <Memory access error>, ob_func_type obFuncType = <Memory access error>, unsigned short obModId = <Memory access error>, struct ob_class_entry * pobClassEntry = <Memory access error>, ob_script_type obScriptType = <Memory access error>, struct ob_prototype * pobPrototype = <Memory access error>, unsigned short obRoutineId = <Memory access error>, unsigned short * pchRoutineName = <Memory access error>)+0x3af (FPO: [Uses EBP] [12,7,0]) (CONV: cdecl)

PBVM110!rtRoutineExec(struct ob_this * obThis = 0x00000000, struct rtCallInfo rtCallInfo = struct rtCallInfo, struct ob_data * pobdArgArray = 0x10000500, unsigned int uiNoArgs = 0xdbfa30, unsigned short obRoutineId = 0, OB_ROUT_TYPE obRoutineType = 20971520 (No matching enumerant), int bConvert = 0)+0x382 (FPO: [Uses EBP] [10,9,0]) (CONV: stdcall)

RESOLUTION: Powerscript defintion of security_info structure was different than the

definition in sas2.h.

No change if originalsize set to false before migration or windows classic display style used all the time.

using IE 6 and columns will then lose their tab order and cannot be tabbed to.

Works ok using IE 7 browser.

in WebForm.

On certain tabs, radio buttons partially appear where shouldn't be.

RESOLUTION: Workaround given to just shorten the DataWindow's height value In WebForm.

If I try and modify a DataWindow such as adding a group box, changing a columns position, change a columns height, etc and then do a "save"

I get the error message => "Line NN column 298: incorrect syntax" - where the

line number changes depending on the object you try and add/modify.

=> This seems to make the DW Painter totally un-usable! <=

** I had to return to build 1155 ** :-(

we loop through the DW objects. The reference to the second or third level report are not known. Moreover we do not know what objects exist on that DW and would need to describe and loop in the same way as we are for the parent DW.

Right now there is no way to get hold of the 3rd level nested report.

a document that was saved using savedocument().

If you save a document to filetype of .doc, .rtf and .pdf, you will see the .pdf

has different spacing for the topmargin and bottommargin.

RESOLUTION: Not a bug. Created PB enhancement request, cr562200,

the errormessage : failed to match datatype when describing appears.

The ue_save event in w_m_setup_type in typecode.pbl is called. The w_m_setup_type

inherits from w_ma_sheet. The code under w_ma_sheet/ue_save is:

this.triggerevent("ue_preprocess")

this.triggerevent("ue_accepttext")

The code in the w_ma_window_rule/ue_preprocess event is:

i_n_window_manager.uf_accepttext()

i_n_window-manager.no_list[1].uf_setredraw(true)

03/2009: Engineering says not a bug. Their explanation:

This is not a bug but a rational improvement for PB.

For a bitmap, there are some properties: pixels and dpi.

In PB9, when we insert a bitmap into richtext control, the size of bitmap is decided by the pixels of bitmap. In different dpis of system, we will get the different inches

for printers. So in PB9, if we change the dpi for system, the size of bitmap in richtext control will change too when we print it.

In PB115(actually in any version after PB10), the size of bitmap is decided by the inches of bitmap which is calculated by pixels/dpi of bitmap. This will keep the size

of bitmap same when we print it, no matter what dpi we use in system. This process is the same as MS-WORD. So if we insert the bitmap into MS-WORD, the size of bitmap is

the same as PB115.

PB 11.x code examples -> Graphs -> Various Graph Examples

Then choose, File -> Stats By Dept # and change Type to either 2D or 3D

and try changing the Colors.

With pie graphs there are no changes and I believe that is correct as the examples use SetSeriesStyle to change the color and with graphs you can change the colors with SetDataStyle but SetSeriesStyle would not make sense as it would turn the entire series ( one pie) to the same color.

Works fine using older ESD versions , pre esd14, icluding policy files etc.

Problem 2: A datawindow column of Edit Style type richtext with the autosize height property enabled does not print a second page when there is 2 pages worth of text pasted into the column.

Checkboxes are not centered 100%. Radiobuttons are too close to the left border of a column and the HTML output needs improvement.

The dddw is shifted one pixel to the top : when you run the Employees_List_XHTML.jsp, you will discover that the Department column is shifted to 1 pixel on top (y=0 whereas it has been defined as y=1)

Using Picturename property to set the png works ok.

Using the w_m_entry_physical_inventory and the uo_phy_inv_adj in the invadjs.pbl.

The sequence of events should be:

u_dwa_rules.uf_itemchanged()

n_phy_inv_adj_main.uf_itemchanged()

n_phy_inv_adj_main.uf_action_valid_item()

n_phy_inv_adj_main.uf_click_on_action()

na_manager.uf_retrieve()

n_phy_inv_adj_main.uf_retrieve()

na_rules.uf_retrieve()

RESOLUTION: Engineering discovered a column mismatch in the dw source. The name

in the column source was not the same column name in the gob.

CR 146848 requested a preferences option for colors of objects in PB but was closed as not to be implemented. Customer would like to see this implemented and also be able to be configured during runtime.

Customer knows that the behavior in PB 11.5 is the correct windows behavior but because their users have a mix of PB 9 and 11.5 applications they need a consistent behavior with the settings.

Toggling the windows setting with APIs is not an acceptable workaround for this customer.

you right mouse button near the right edge of a column.

Using code of:

lm_pop.PopMenu(parent.PointerX(), parent.PointerY())

RESOLUTION: Customer resolved issue.

Error text = ct_exit(): user api layer: external error: This routine cannot be called because another command structure has results pending. fatal

When using either JDBC and regular PB connections he does not see the error.

a byte array, PB will hang:

blob blb

byte bb_byte[]

any a

bb_byte[] = {1,10,100,200,255}

a = bb_byte

blb = blob(a,EncodingANSI!)

Works ok for pcode.

ALTER TABLE TECHSUPP."DEPARTMENT" ADD ("TEST" CHAR(10)) ;

"TECHSUPP" is the table owner and we are logged in as "TECHSUPP".

Customer would like the generated ddl in the powerbuilder database painter to be created without the table_owner prefix in the ddl or have the option of using the table owner or not.

When we create a datawindow the owner_name doesn't prefix the table name. Can we have the same functionality in the database painter?

you can't do that via Powerbuilder because the headers and footer tags don't exist at runtime.

the service component entity file is now generated automatically.

Per cr553881, please back out the change done from cr497660.

When deploying a component using a export configuration, you must manually include

the service component entity file in the zip file. CR559759 is entered for that

request.

The leak is only evident when the bitmap files are located in the system path.

When the bitmap files are in the current directory the memory leak is not evident.

The customer says this memory leak is also evident when running the exe when the toolbar .bmp files were added via a .psr file. So the searching for the bitmap files may not be the complete issue.

Customer is crashing on the create instance of a powerbuilder component with EAS 6.

Normal Excel! type works fine.

Happens for both o90 and 010 DB interfaces.

the DIR driver, getting the following error:

Extend PB Catalog

ct_results(): network packet layer: internal net library error: Net-Library

operation terminated due to disconnect

PB Catalog tables are not available for use

Connecting to DB2 version 8.1 using Open Client -> network layer -> directconnect -> mainframe connect.

Works ok in PB 10.5.2 (build 7699)

DirectConnect 12.6, columns are getting truncated.

For example a table is defined with the following columns:

MSDI_CODE char(10)

MSDI_ACTIVE char(20)

MSDI_NAME varchar(25)

The database trace is returning:

(f8a1c4): name=MSDI_CODE,len=6,type=CHAR,pbt=1,dbt=1,ct=0,prec=0,scale=0

(f8a1c4): name=MSDI_ACTIVE,len=11,type=CHAR,pbt=1,dbt=1,ct=0,prec=0,scale=0

(f8a1c4): name=MSDI_NAME,len=13,type=CHAR,pbt=1,dbt=1,ct=0,prec=0,scale=0

In some environments the whole text is diplayed as barcode.

contemporary style toolbar menu.

It looks ok for traditional style toolbar.

FAULTING_IP:

PBSHR115!PbHeap_free+43e [e:\pb115\3rdparty\heap\spbheap.c @ 2375]

00452b5e 833f00 cmp dword ptr [edi],0

DEFAULT_BUCKET_ID: CORRUPT_MODULELIST

PROCESS_NAME: datacap.exe

OVERLAPPED_MODULE: Address regions for 'shell32' and 'Unknown_Module_00680074' overlap

ERROR_CODE: (NTSTATUS) 0xc0000005 - The instruction at "0x%08lx" referenced memory at "0x%08lx". The memory could not be "%s".

READ_ADDRESS: 00000000

FAULTING_THREAD: 00000420

PRIMARY_PROBLEM_CLASS: CORRUPT_MODULELIST

BUGCHECK_STR: APPLICATION_FAULT_CORRUPT_MODULELIST_OVERLAPPED_MODULE

Command syntax error at line 4. Found "projectex", expected "LIBRARY | APPLICATION | EXECUTABLE | PROJECT"

End Session

The following is the code from the datafile that caused the error:

Start Session

Set Liblist

"C:\customers\11509491\pbeas.pbl"

"C:\customers\11509491\base.pbl"

"C:\customers\11509491\jagrepository_proxies.pbl"

Set Application "C:\customers\11509491\pbeas.pbl" "pbeas"

build projectex "C:\customers\11509491\pbeas.pbl" "p_deploy" "TZ1" 2011

PB is looking for libct.dll and libcs.dll. Open Client does not have those

dlls--instead they have libsybct.dll libsybcs.dll.

users to control the linespacing on a rte control.

The customer prints a .rtf document from MS-WORD and also prints the same

.rtf from the rte control. The output doesn't look the same. The customer

believes if they can control the line spacing and make it smaller, than the

formats will match up better.

Subprogram <function name> not found in subprogram list for package <owner>.<package>

TableCriteria dbparm.

When trying to expand the tables in the database painter, pb will crash.

beginning of the control and not at the position of the mouse when you click in the control.

Deploying an EA Server project from PowerBuilder using Orcascipt is not working when using build projectex. It works when using build project. The error is as follows:

Command syntax error at line 4. Found "projectex", expected "LIBRARY | APPLICATION | EXECUTABLE | PROJECT"

End Session

The following is the code from the datafile that caused the error:

Start Session

Set Liblist

"C:\customers\11509491\pbeas.pbl"

"C:\customers\11509491\base.pbl"

"C:\customers\11509491\jagrepository_proxies.pbl"

Set Application "C:\customers\11509491\pbeas.pbl" "pbeas"

build projectex "C:\customers\11509491\pbeas.pbl" "p_deploy" "TZ1" 2011

Customer would like to see this functionality available in orcascript as they have 3-4 different sets of environments. They are planning to have different passwords to avoid deploys by personnel who don't have permissions to deploy to production. Using BuildProject in Orcascript will not work for their environment.

Versions and Build #s Tested: PB 11.5_3050, PB 11.0_8616 and 10.5.2_7791

Database/Driver File/Version: N/A

Uses MSCOMM32.OCX

Comments: When scanning a barcode, the OCX oncomm() event takes precedence over PB window key.

The PB window key should take precedence, since you need to type the quantity first, and then scan the type of product. We tried ways to use PostEvent() and TriggerEvent() functions to invert the event sequence but we couldn't do that.

following error results:

ct_bind(): user api layer. An illegal value of 3 given for parameter item

The db trace shows the following:

(1106480): SRV 10 #1 103 TDS RCVPRM ERROR (DBI_DEBUG_MESSAGE) (0.006 MS / 0.006 MS)

(1106480): CLI 1 #5 ct_bind(): user api layer: external error: An illegal value of 3 given for parameter item.(DBI_DEBUG_MESSAGE) (0.001 MS / 0.007 MS)

(1106480): SRV 11 #34313 An error occurred on the socket between the TRS and the CICS transaction program. See error log.(DBI_DEBUG_MESSAGE) (0.002 MS / 0.009 MS)

(1106480): *** ERROR 5 ***(rc -1) : ct_bind(): user api layer: external error: An illegal value of 3 given for parameter item.

.

.

(1106480): SRV 11 #34313 An error occurred on the socket between the TRS and the CICS transaction program. See error log.(DBI_DEBUG_MESSAGE) (0.002 MS / 0.040 MS)

(1106480): *** ERROR 5 ***(rc -1) : ct_bind(): user api layer: external error: An illegal value of 3 given for parameter item.

(1106480): SRV 11 #102 Incorrect syntax (DB2 PREPARE failed: DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "<END-OF-STATEMENT>". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: + - AS <IDENTIFIER>(DBI_DEBUG_MESSAGE) (0.001 MS / 0.041 MS)

not show the multi user checkout icon, it just shows the

regular check out icon.

Also when multi user checkout is enabled in TFS and SccMultiCheckout=0 is added

to the pb.ini, PB still allows multi check outs.

nested report

When you are not using the distill method and want to create a PDF using xsl-fo you won't be able to specify the page size and other page properties and the pdf ends up with a default page property.

reference for create instance.

The problem in this particular case was that objects were originally developed using pbwsclient110.pbx and even though new web services were created using pbwsclient115.pbx they still worked on machines that had the PB 11.0 runtime on them. However, it would return a success code and null object reference on the machines that didn't have the PB 11.0 runtime.

The enhancement request is to return an error code instead of a success code when this situation arises.

<DW Control Name>.Object.DataWindow.Print.Preview.Outline

or

<DW Control Name>.Describe("DataWindow.Print.Preview.Outline")

The w_m_setup_structure in acctset.pbl opens. Using the uo_rules_setup_structure

in acctset.pbl.

Works ok in PB Native

Style='visibility:hidden;'

However, when the html file is inserted into an RTE control in PB via InsertDocument (or opened by Word), there is an extra blank row displayed at the top and the invisible column is visible.

abc

abb

acc

bbb

bbd

dbc

dbb

dcc

efg

If you type the letter a repeatidly as fast as you can the focus goes from abc to abb to acc, and continues in this cycle as long as you type a. But if you type d repeatidly as fast as you can the focus goes from dbc to dbb and cycles between just those two rows and never goes to row dcc. If you type d very slowly waiting a second or two between each then it cycles through all 3 d rows as it should. Why does d not behave the same as a? Why is the timing somehow different for the letter d?

OBJ_FOCUS Event Time=1A9340D Window Class="pbdw110" Name="Department Name" Role=editable text State=normal

OBJ_LOCATIONCHANGE Event Time=1A9340D Window Class="Edit" Name=none [false] Role=window State=focused,focusable Location={l:445, t:333, w:196, h:15}

OBJ_HIDE (hidden) Event Time=1A934E7 Window Class="Edit"

OBJ_FOCUS Event Time=1A934E7 Window Class="pbdw110" Name="none" Role=client State=normal

OBJ_LOCATIONCHANGE (hidden) Event Time=1A934E7 Window Class="Edit"

OBJ_FOCUS (hidden) Event Time=1A934E7 Window Class="pbdwst110"

...

OBJ_FOCUS Event Time=1A9364F Window Class="Edit" Name=""Single Line Edit One"" Role=editable text State=focused,focusable

OBJ_VALUECHANGE (hidden) Event Time=1A93881 Window Class="Edit"

Notice the first two entries OBJ_FOCUS the Class="pbdw110" Role=editable text and State=normal. The second line OBJ_LCATIONCHANGE occurs while still in this field. The Name now equals none with the following changes Window Class="Edit" Role=window State=focused,focusable.

Now if you tab into a regular single line edit control on a window you get the following:

OBJ_FOCUS Event Time=1A9364F Window Class="Edit" Name=""Single Line Edit One"" Role=editable text State=focused,focusable

The customer's contention and where he feels the datawindow is losing the AccessibleName is in the State. With the single line edit control the State=focused,focusable. However, with the datawindow editable text the State=Normal. It doesn't become focused,focusable until the OBJ_LOCATIONCHANGE line.

Over hundreds of Richtext Datawindow report have printing issue.

The customer needs to load various text files (generated by Pro*C or Oracle

package on UNIX) into a RichText DataWindow in their PowerBuilder application

and then print out the text files with Landscape Orientation from there.

Two issues are identified.

1. Datawindow object has specified the "Paper Orientation = LandScape" but it print to Portrait as default

2. Even "Top Margin=0.0" But there is extra approx. 1cm empty space in Top Margin when compare PB11.2 to PB10.2

the default font size is not retained.

In some cases the default font is not retained.

Make it possible to use larger icons\pictures on the Menu Toolbar.

appear in the db painter.

In the db painter, when selecting the table and clicking on grid manipulation,

the message of 'Table MS_SYBASE_TEST_XXX contains no columns with supported datatypes'

shows in the microhelp area.

Customer is crashing on the create instance of a powerbuilder component with EAS 6.

Equal join shows no problem, no error.

MS Office Communicator is opened. (replacement of MSN messager)

The HANG symptom is resumed after terminate the MS Office Communicator.

Need help to investigate the collected dump file to find out the reason behind.

It is getting entered as ###,###,###.00 instead of ##,##,##,###.00

Error: Error calling external function %s at line 5 in clicked event of object cb_1 of w_window.

The suspicion is that powerbuilder no longer likes the function name "?f_opendoc@@YGFPBDH@Z" defined in the home grown dll:

FUNCTION integer f_opendoc(string filename, int cmdshow) LIBRARY "ac_doc32.dll" Alias for "?f_opendoc@@YGFPBDH@Z;Ansi"

Customer does not want to use printsetup() which is what is now available to him.

Customer claims that they are using webservices but they do not believe they are when the application actually crashes.

Stack trace

msvcr71!wcslen+0x4 (FPO: [1,0,0])

msvcp71!std::basic_string<wchar_t,std::char_traits<wchar_t>,std::allocator<wchar_t> >::assign+0xd (FPO: [1,0,0])

WARNING: Stack unwind information not available. Following frames may be wrong.

pbwsclient110+0x336d9

xerces_c_2_6!xercesc_2_6::SAX2XMLReaderImpl::startElement+0x2f9

xerces_c_2_6!xercesc_2_6::MemoryManagerImpl::allocate+0x31

xerces_c_2_6!xercesc_2_6::IGXMLScanner::scanStartTagNS+0x1618

If the folder to save in does not exists, the SaveAs functions returns a 1 instead of the -1 error.

in UserObject's constructor event. After investigation, it is identified that early

instantiation of the Global variable at application object may relate to the problem.

However, similar problem also occur on instance variable. For instance variable, only the

first instance of the soapconnect can successfully createinstance

Customer is requesting an enhancement to support the SySAM license server on Windows 2008 x64.

Currently, the License Server is not supported on Windows 2008 until FLEXnet v11.6.1.

It worked fine in PB 10.5. Workaround is to use DisableBind=1.

this.oPBNETData = null;

And in the fonction HTDW_performAction (), when submitting, we have the following:

if (this.oPBNETData + "" == "undefined")

psPage.Submit(); //Jsp Target

So, the submit doesn't work, because "undefined" has never been assigned to oPBNETData. What we need really is this code:

if (this.oPBNETData + "" == null)

psPage.Submit(); //Jsp Target

Server OS (Where Web Forms app is installed): Windows 2003 Server SP2

Microsoft .NET Framework Version:2.0.50727.1433 SP1

ASP.NET Version:2.0.50727.1433

Ajax Extensions 1.0 (according to manual) installed successfully

IIS 5.2 SP2

Client Stations OS:

Windows XP SP2

Microsoft .Net Framework 2.0.50727 SP1

ASP .Net 2.0 Ajax Extensions 1.0

Runtimes de PowerBuilder 11.2 Build 8739

Comments:

Customer is trying to run a PB WebForms application that was deployed into IIS into his production environment. The deploy went fine. When accessing the application from within IE on same machine where IIS is located, it works ok. But when accessing application from within other client stations, customer receives the following error message in Internet Explorer:

Server Error in '/' Application.

Modify did not complete successfully, the error message is: Line 1 Column 866: incorrect syntax

Description: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[MethodFailureException: Modify did not complete successfully, the error message is : Line 1 Column 866: incorrect syntax.]

Sybase.PowerBuilder.Web.PBPage.Render(HtmlTextWriter writer) +310

System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) +25

System.Web.UI.Control.RenderControl(HtmlTextWriter writer, ControlAdapter adapter) +121

System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +22

System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2558

Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

The PBTrace.log shows the following:

Main Exception:

Exception Time: 2009-03-24 18:56:40.9307422

Process ID: 380

AppDomain: /LM/W3SVC/1907274638/Root-4-128824159461117190 Domain ID: 5

Managed Thread ID: 21

Current Thread State: Background

Method: Boolean j(Sybase.PowerBuilder.Web.PBWindow)

Exception Type: System.NullReferenceException

Exception Message: System.NullReferenceException: Object reference not set to an instance of an object.

at Sybase.PowerBuilder.Web.PBWindowProcessor.j(PBWindow A_0)

at Sybase.PowerBuilder.Web.PBWindowProcessor.OpenWindow(PBWindow w)

at Sybase.PowerBuilder.Web.PBWindowOpener.a(PBWindow A_0, Boolean A_1)

Exception Source: Sybase.PowerBuilder.Web

Exception StackTrace: at Sybase.PowerBuilder.Web.PBWindowProcessor.j(PBWindow A_0)

at Sybase.PowerBuilder.Web.PBWindowProcessor.OpenWindow(PBWindow w)

at Sybase.PowerBuilder.Web.PBWindowOpener.a(PBWindow A_0, Boolean A_1)

Exception Call Stack: at System.Environment.GetStackTrace(Exception e, Boolean needFileInfo)

at System.Environment.get_StackTrace()

at Sybase.PowerBuilder.PBLogger.a(Exception A_0, LogLevel A_1, Boolean A_2, Boolean A_3)

at Sybase.PowerBuilder.PBLogger.a(Exception A_0, LogLevel A_1, Boolean A_2)

at Sybase.PowerBuilder.PBLogger.LogException(Exception e, LogLevel logLevel)

at Sybase.PowerBuilder.PBLogger.LogException(Exception e)

at Sybase.PowerBuilder.Web.PBWindowOpener.a(PBWindow A_0, Boolean A_1)

at Sybase.PowerBuilder.Web.PBWindowOpener.Open(PBWindow w, Boolean newWindow)

at Sybase.PowerBuilder.Web.PBSystemFunctions.a(PBString A_0, IPBValue A_1, PBIconValue A_2, PBButtonValue A_3)

at Sybase.PowerBuilder.Web.PBSystemFunctions.a(PBString A_0, IPBValue A_1)

at Sybase.PowerBuilder.Web.PBSystemFunctions.MessageBox(PBString title, PBString text)

at c__n_pro_lease_connectservice.of_disconnectdb()

at c__pro_lease.close()

at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)

at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)

at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)

at System.Delegate.DynamicInvokeImpl(Object[] args)

at Sybase.PowerBuilder.Web.WebThread.a(Object A_0)

at System.Threading._ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)

at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state)

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

or PBRTConfig, the syntax to use is unclear.

For example, to add the Max heap size the following does not appear to work:

HKLM\Softwre\PowerBuilder\11.0\Java\PBIDEConfig\PBJVMconfig\1\-Xmx256m-verbose:jni,class

HKLM\Softwre\PowerBuilder\11.0\Java\PBIDEConfig\PBJVMconfig\Count\1

What appears to work (and verified from visualgc):

HKLM\Softwre\PowerBuilder\11.0\Java\PBIDEConfig\PBJVMconfig\0\-Xmx256m

HKLM\Softwre\PowerBuilder\11.0\Java\PBIDEConfig\PBJVMconfig\1\-verbose:jni,class

HKLM\Softwre\PowerBuilder\11.0\Java\PBIDEConfig\PBJVMconfig\Count\2

The dw contains 3 buttons (Insertrow,update and delete). When clicking on

Insertrow, easerver will crash.

Using a custom pb nvo component, problem appears to be on the sethtmlaction.

Before the crash the action and context for sethtmlaction contain:

InsertRow (dw1 0)(15 (InsertRow 0 ((1 1 )(2 1 )(3 1 ))))((row 0)(sortString '?'))

RESOLUTION: Fix by CR559312. Checked in to PB 11.5.1 codeline on 2/23. Checked in to

pb 115ebf codeline on 4/23. Works in PB 11.5.1 (build 4009)

connection object.

According to EAS Engineering, "the ejbconnection object has not really been enhanced for

quite some time and will probably never be supported for PB.NET. If your server is

EAServer or the PowerBuilder Application Server Plugin (with the Proxy Server), then

the client should definitely use the connection object."

The PowerBuilder documentation does not appear to stress that enough. In the online

help or Applications Techniques Manual, Chapter 24 - Building an EAServer Client or

Chapter 26 - Building an EJB Client.

Chapter 5 of the Easerver 6.x - JavaBean User's Guide it states:

- If using PowerBuilder, you can call EJB components hosted in EAServer by generating proxies for the home, local and remote interfaces then calling the lookup method on

the PowerBuilder CONNECTION object to instantiate the home interface proxy. Call the

appropriate home interface create mthod to instantiate a proxy for the remote interface, then call the business methods as you would for any other EAServer component.

- If you PowerBuilder 9.0 or later, you can use the PowerBuilder EJB client interfaces. These interfaces use Java and Sybase-provided PowerBuilder extensions to invoke EJBs on any J2EE compatible server.

The customer is working with pb native source control remotely via a broadband connection.

The pbls are on the office network which are under pb native source control. The customer is experiencing a long delay during the source control initialization process which is taking up to 20 minutes when a large pbl is involved. The time is being spent on the initialization process, checking the status of the object which are under source control.

The enhancement request is to allow the customer to get the status of a particular single object rather then refreshing the status of all the objects which are under source control. Customer would like the flexibility to toggle between full status of all objects which are in a pbl under source control or an individual object within a pbl.

Customer is aware of our documentation below:

http://infocenter.sybase.com/help/topic/com.sybase.dc00586_1150/pdf/dplynet.pdf

page 175 and page 177

ClassDefinition *

* The order of the array items in the VariableList property of the ClassDefinition object may not be the same in .NET applications as in standard PowerBuilder applications.

But does not believe this applies to the problem he would like looked into by engineering.

FAULTING_IP:

pbvm115!PBOLEINBOUNDAUTOMATIONOBJECT::BuildSymbolTable+1e9

10b0c419 89542908 mov dword ptr [ecx+ebp+8],edx

A regression from PB 9 where the font remained the same on the replacetext.

We also need a document of how to deploy a .msi file with all the Dlls needed and how to configure IIS in order to run 32 bits web applications.

Deleting the opt file resolves the problem, as it is deleting the parent tag info of the watch.

not correct. It has a dark border around it. It does not appear the same as with a traditional menu.

The problem does not happen for all icons.

When the images (first.bmp,next.bmp,prior.bmp and last.bmp) are moved to another

directory that is in the system path, then the gray background is not there.

Resolution: Not to be fixed. Too risky and may cause a regression. Pathing issue

does not occur in pb12 (build 2063).

results in a memory leak.

The application eventually produces the following error and then crashes pb:

There is a runtime error when invoking the Web Service APPLICATION. The

definition of the method signature in the Web Service is wrong--the data doesn't

match the parameter definition.

Using websphere 6.1. The web service generates pdf documents uses up memory each successive time the web service is invoked until Powerbuilder crashes.

Should he be able to use this blob created in Powerbuilder 8 and be able to do a selectblob of the powerbuilder 8 datawindow and then do a setfullstate in a Powerbuilder 11 application?

Would this be considered supported?

Parts of the report display fine but pages are missing.

CR 309840 seem to occur again.

When refreshing source control status, the SccQueryInfo

call gets into an infinite loop within the Perforce dll's

Some properties of type any of java classes can not be expanded within the debugger

This does appear to be a regression. It works OK in build 7518 and earlier of PB 11.x. Later versions of 11.2 display the barcode incompletely as does the latest version of 11.5, build 3143.

Application and Window objects, and CheckBox, DataWindow, DatePicker, DropDownListBox, DropDownPictureListBox, EditMask, GroupBox, InkEdit, ListBox, ListView, MonthCalendar, MultiLineEdit, PictureListBox, RadioButton, SingleLineEdit, StaticHyperLink, StaticText, and TreeView controls

Customer would like the RightToLeft property to apply to Computed Fields in the datawindow control

EasySoap client gave error "Cannot parse wsdl file" when generating proxies.

is crashing on rollback using <transaction>;

A crash is happening in the u_mgr_data/xfi_rollback. In the debugger, autocommit

is set to false and the transaction object is valid.

A dump file shows the app is crashing in the:

PBSNC115!PBOLEDB_COMMAND_BLK::RollBack+1

14f025a1 8b4908 mov ecx,dword ptr [ecx+8]

DEFAULT_BUCKET_ID: NULL_POINTER_READ

UNIX)into a RichText DataWindow in their PowerBuilder application and then print out the

text files with Landscape Orientation (most of the time) from there. The main issue

encountered is that the Richtext DW fail to use Page Orientation specified by PrintSetup()

at runtime.

After a dddw is expanded, the tab order appears to be lost.

Using IE 6 and 7 for testing.

When they are all deployed at once (RMB on Workspace in PB system tree -> Deploy) the server will get java.lang.OutOfMemoryError: PermGen space. After this the server has to be restarted.

when a rectangle is put behind it or when the picture is dynamically set.

IIS, windows event view may report the following error:

Event Type: Error

Event Source: ASP.NET 2.0.50727.0

Event: EventType clr20r3,P1 w3wp.exe, P2 6.0.3790.3959, P3 45d6968e, P4 sybase.powerbuilder.interop, P5 11.0.0.0, P6 471eaa9a, P7 4e9, P8 1f, P9 system.accessviolation, P10 NIL

Event ID: 1334

Description:

An unhandled exception occurred and the process was terminated.

Application ID: /LM/W3svc/1/Root/eonwebservice

Exception: System.AccessViolationException

Message: Attempted to read or write protected memory. This is often an

indication that other memory is corrupt.

Stack Trace: at b(oa*, PBTransaction, Boolean)

at c(oa*, PBTransaction)

at Sybase.PowerBuilder.DB.PBSQL.Stop(IntPtr dbthis, PBTransaction transaction)

at Sybase.PowerBuilder.PBSessionBase.Stop.Transaction(PBTransaction trans)

at Sybase.PowerBuilder.PBTransaction.Dispose(Boolean disposing)

at Sybase.PowerBuilder.PBPowerObject.Finalize()

Test shows that the exception won't affect PB Webservice in the opera application

since the iis can automatically restart the process w3wp.exe immediately after its stopped.

It seems that on these systems PB does not use the set regional settings (english uk), it uses some sort of US date settings instead (yy/mm/dd or yyyy/mm/dd), hence the wrong output.

Using an 11.5 psr there is no problem loading it, making changes, save it again as a psr, the new psr loads and displays properly. The customer needs to be able to do the same to these older psrs.

Versions and Build #s Tested: PB 11.5_2506

Database/Driver File/Version: SYC connecting to ASE 12.5.4

Comments: Customer has above 1000 stored procedures created with "sp_" prefix. But Pb, by default, considers these stored procedures as System Procedures.

As a consequence, customer needs to right-click and enable "Show System Procedures" to make them visible. This was reproduced here.

between enable and disable state.

CR463051 addressed the problem and created a new property (PBTOOLBARDISABLEMODE=1 ) to add as a system environmental variable.

Please document this property-- PBTOOLBARDISABLEMODE=1

a .bmp for .gif, the picture does not show in in a rte control or richtext dw.

The rtf doc contains:

{INCLUDEPICTURE "C:/DevSample/ESSIG1.GIF" \* MERGEFORMAT \d }

{INCLUDEPICTURE "C:/DevSample/ESSIG1.BMP" \* MERGEFORMAT \d }

It works ok in PB 10.5.2

the dddw where the 'empty string is null' is checked, causes the previous column's data to disappear.

Webform is doing a postback. Only happens when empty string is null is checked.

if a client application uses a bad or old proxy object then PowerBuilder

within EAServer gets a fatal error on the server side and EAServer can go down.

Powerbuilder Application Execution Error

within EAServer gets a PB INTERNAL EXCEPTION.

1 - Tested on Vista machine, PB 11.5.1 build 4011, 4 GB memory. Ran fine, returned correct bytes in less than a minute.

2 - Tested on XP machine, PB 11.5.1 build 4011, 1 GB memory. Crashed in pbvm115.dll after running for a few minutes.

Customer has an XP machine with 3 GB memory and says he is crashing.

1) Datawindow buttons can be given a picture but have no originalsize property. The picture scales instead of the button resizing around the picture causing graphics to look unprofessional using modern or classic themes. The button should have an originalsize property that behaves as it does for window picture buttons.

2) In PowerBuilder the datawindow picture buttons always display using the classic style when viewed on the datawindow regardless of the display theme in use. For example, if using the standard Windows Vista or Windows XP themes the buttons appear square on the datawindows, but when window buttons are viewed on a window object the buttons appear with rounded edges. DW buttons should behave the same.

3) In modern display themes Window commandbuttons have multitone gradient backgrounds while picturebuttons do not. This gives an inconsistent look. Picturebuttons should have similar capability.

Normal column edit style works ok.

PowerBuilder Internal Exception

A crash occured in the activate event of a component

In pb 11.5, bmp,png and jpg are not appearing on menu.

In pb 11.2, jpg are not appearing (png is not supported until 11.5)

Problem happens for both pcode and machine code. It does not appear that

the graphics are set in the executable.

Worked fine in PB 9 and 10.5.

Make it possible to create 64-bit applications to be able to use more than 2GB virtual memory.

In the Regional Options, if the Currency Symbol contains a dot (for example kr.), the dot is replaced by a comma when using the [Currency] display format.

The SQLPreview, RetrieveEnd,UpdateEnd do not have any/correct arguments.

The n_cst_global/of_test has the sharedata().

IF ids_Test.ShareData(au_DW) = 1 THEN

IF THIS.of_CreateTempTable(TRUE) = 1 THEN

ll_RowCount = ids_Test.Retrieve()

I believe where the problem is in the second retrieve:

IF li_rc = 1 THEN

ll_RowCount = au_DW.Retrieve()

The dump file shows the crash is happening in:

msvcr71!wcsstr+13

Default_Bucket_ID: Invalid Pointer Read

BUGCHECK_STR: APPLICATION_FAULT_INVALID_POINTER_READ_STRING_DEREFERENCE

Versions and Build #s Tested: PB 11.5_3127

Database/Driver File/Version: SNC connecting to SQL Server 2005 database

Comments: Enable SNC to allow multiple table selection in Paste Special/SQL/Update or Delete. Currently, only one table can be selected when using SNC.

The feature already exists for ASE, SYC and ODBC/JDBC (ase/asa/ms sql server) interfaces.

the type is changed to a different type and then changed back to Bar3D.

Undo() rte function that will do the same thing as Ctrl-z. However, there isn't a corresponding Redo() function. The customer would like to see a Redo() rte function.

2009-06-09 10:52:42.715 WARN Thread-414 Probable cause: unexpected failure or abnormal shutdown of client application or client host.

They are looking for any ideas. What does this error mean? What could be causing it?

What seems to be a good workaround is to have the customer use the clearflag set to true on the subsequent html insertdocument. If you do the insertdocuments with the clearflag argument set to true, then it does clear out the table stuff. But the customer is also doing some header and footer inserts, and this no longer works when the clearflag is set to true. So this is not an acceptable workaround for the customer.

The customer wants the RTE.Clear() to clear out the text and table structure and let subsequent insertdocuments and header and footer inserts work properly.

July 17, 2009: Engineering can't fix the clear() problem in an EBF, however they were able to fix the workaround. Verified the workaround using InsertDocument() with the clearflag argument set to true to true is fixed in PB 11.5.1 build 4556.

Testing here on Windows XP with a local printer vs a networked printer does consistently show that with the networked printer set in the datawindow.printer property, the retrieve takes longer in a good 9 out of 10 retrieves. This difference is magnified on the customer's environment.

#if defined PBNATIVE then

is always evaluating as false when used with Orca.

Powerbuilder 11 and Oracle database.

The customer has a very active application with an Oracle backend. For

performance reasonss he wants to use bind varibles. See http://www.orafaq.com/node/29 for an explanation of how Oracle uses bind varibles.

The customer does a powerbuilder insert with DisableBind = 0. The issue is that "Nulls" are getting inserted into the database for columns where the values in datawindow column are empty. Customer believes that the insert statements should not be inserting null for empty values in the datawindow columns.

on a WebForm for datastore. It does not show the document name whether the

name was set in the datawindow object or dynamically using dot notation or modify.

It works ok for datawindow but not datastore. Works ok in Winform and PBNative.

When the DDDW is expanded, the DW control gets moved upwards, using PBDataWindowEnableDDDW true.

Versions and Build #s Tested: PB 11.5_3127, PBVM 11.5 (that comes with EAServer 6.2 installation )and also PBVM 11.5_3127 upgrade in EAServer side

Database/Driver File/Version: N/A

Comments:

When a JSP invokes a PB NVO that performs intercomponent call to second PB NVO, PBVM 11.5 throws an exception and leads EAServer to crash. The issue happens if intercomponent call invokes a method with datetime datatype in parameter.

When connecting to MS Visual SourceSafe 6.0, 2005 with orcascript the

VSS Password dialog appears eventhough the password was set in the script.

scc set connect property userid "Orca"

scc set connect property password "orca"

UNIX)into a RichText DataWindow in their PowerBuilder application and then print out the

text files with Landscape Orientation (most of the time) from there. On PB10.2, the long text will be be truncated to display. On PB11.2, the long text file will be word wrapping

to new line, even the RichText DataWindow control has turn of the word wrapping.

After the dw.InsertDocument(), there is no way to reset the word wrapping.

"Unknown Exception found" in Web Service Proxy Wizard.

"Unknown Exception found" in Web Service Proxy Wizard.

"Unknown Exception found" in Web Service Proxy Wizard.

"Unknown Exception found" in Web Service Proxy Wizard.

SQLSTATE = 07006

[Microsoft][ODBC SQL Server Driver]Restricted data type attribute violation

If customer connects using ADO.NET, OLE DB or SNC there is no error. They have used ODBC in the past and say this is a migrated application that did not show the error in PB 9.0.3. The testcase however for me, does show the error in PB 9.0.3 but they insist their actual application does not.

PB in the IDE.

The crash is happening in the PBLIB115!CFP_Folder::EnumActions

FAULTING_SOURCE_CODE:

242:

243: if (bInWebTarget || bInJSPTarget)

244: {

245: // New...

> 246: hr = LP_CreateNewAction(m_pContext, m_strURL, IID_IPB_Action, (void**)&pIAction);

247: if (SUCCEEDED(hr))

248: {

249: PB_ASSERT(pIAction != NULL);

250: list.AddTail(pIAction);

251: pIAction->Release();

There are several third party tools available to do this and but he would like to be able to do it without purchasing a third party tool.

http://www.topwizprogramming.com/pbniserv.html

http://www.ecrane.com/pbservice1.cfm

http://www.firedaemon.com/

Provide properties to specify the sorting order of DataWindow Crosstab Columns

Customer enhancement is a request for a larger DW size limit.

- Some values are not in the right column

- Some values are not imported

int minute_pos = pos(time_value,':')

where time_value is an argument passed into the function at runtime. Declarations happen at compile time, and time_value has no meaning or value at compile time. The expression pos(time_value,':') clearly is intended to be evaluated at runtime using the passed in time_value to the function, so it makes no sense to use the syntax to set an initial value to the variable in a declare statement. Even if it could compile this one line declare statement will never be executed at runtime. The correct syntax is the commented out 2 lines:

int minute_pos // Declare the variable at compile time

minute_pos = pos(time_value,':') // Set a value at runtime when the function is called.

This is from the Help on initial values for variables: "Although you can use global system functions or expressions to initialize variables with compile time values in a variable declaration statement, for runtime value assignments, you must declare variables and assign their values in separate statements."

So the issue here for Engineering is can we aviod the crash and get a compile time error message?

07/15/2009: Verified fixed in PB 11.5.1 EBF build 4556 and after.

July 17, 2009: Verified fixed in PB 11.5.1 build 4556.

The database is SQL Anywhere 11 and ODBC is used to connect.

July 17, 2009: Verified fixed in PB 11.5.1 build 4556 and after.

From the only help for 11.2 and 11.5, it states for 'Using number display formats' that

'These keywords tell PowerBuilder to determine an appropriate format based on system

settings'

[General]

[Currency]

From the online documentation for PB 11.2 and PB 11.5, Users Guide, Chapter 22: Displaying and Validating Data for

Number keywords 'You can use the following keywords as number display formats when you want PowerBuilder to determine an appropriate format to use'.

The online documentation does not reference that {General] and [Currency] are

based on system settings. The online documentation does not appear to be in sync

with the online help.

On a .Net Webform application when setting the DataWindow Visible property to False and

back to True again, the last entered text may have dissappeared from the dataWindow.

Note:

There are other options to hide a DataWindow like setting the x or y coordinate to a large negative value.

"abs(col1) A,abs(col2) A"

If he takes this exact string though, and does a SetSort to the datawindow the setsort adds a space after the comma and the sort string becomes:

"abs(col1) A, abs(col2) A"

The cusotmer does a lot of iterations of this in his app. The extra spaces add up and become a problem, using memory and eventually crashing PB. Not a problem if the functions are not in the sort string.

July 17, 2009: Verified fixed in PB 11.5.1 build 4556 and after.

The problem occurs on some conditions : The PbCatalogOwner is set in the dbparm and the user connected is not the owner Pb catalog tables.

dw_1.Object.DataWindow.Export.XML.UseTemplate='t_request_response'

Before the dw.object.DataWindow.Data.XML, you still get UTF-16LE as the encoding rather than the UTF-8 encoding specified by the template.

The problem involves the nvarchar and varchar types trought SNC with SQL Server 2008 and disableBind=0

With DisableBind=1 or with another mode of connection, ODBC , OLEDB, all works fine

for Rupees.

This is a continuation of cr566072. Currently to display ruppees

in the dw, you must set the Display Format to ##,##,##,###.00. The customer

feels that it should be reading the regional settings. If so, then you

should be able to just use [currency] or [general].

Our documentation states that you can use the following keywords as number display

formats when you want PowerBuilder to determine an appropriate format to use:

[General]

[Currency]

string ls_value

long ll_tmp, i

for i = 1 to 500000

if isNull(string(ll_tmp)) then

end if

next

causes a memory leakage

SetChanges fail when datawindow / datastore SQL Query contains table or columns names with

multi-byte chars e.g. Simplified Chinese , Korean chars. Problem happen on database interface PB JDBC, SYJ Solaris.

be converted into Unicode sting. On Solaris PBVM, it is discovered that PBVM fail to get

correct Unicode string data, when the ASE database side has charset cp936 (simplified chiense).

In fact, original customer hit the problem on Korean cp949.

It is suspected that it is a general problem when unix PBVM meet the ASE DBCS charset.

tab page is marked as visible=false, the invisible tabs still require a scroll click to

scroll to the next tab.

The scroll tab functionality requires 2 clicks to scroll to the next tab.

July 28, 2009: Engineering says this is not a bug, but a limitation. The whole report is in one row with autosize text columns that together exceed the one page limitation.

The TzSpecificLocalTimeToSystemTim function is not supported on Windows 2000. See http://msdn.microsoft.com/en-us/library/ms725485(VS.85).aspx.

Friday, July 31, 2009: QA Verified Fixed in PB 11.2 Build 8850, and PB 11.5 Build 4566.

Condition : Table has 444s over columns.

Error : The row length has exceeded the maximum of 64000 bytes.

This issue will occur, if "-" or "," is contained in the editmask format.(Example, ##-## or ##,## etc)

If not supported, this should be documented and/or changed to an enhancement request.

Tested with both WebForms and Winforms.

or winform, pb will crash. Works ok in pb 12 when not using datalink.

Works ok in PB 11.2.

Versions and Build #s Tested: PB 11.5.1_4011

Database/Driver File/Version: PBJDB interface connecting to PostGre 8.3 via JDBC Driver

Comments: When issuing SELECTBLOB by using PB JDBC interface, the blob length returned from blob variable is incorrect. Same SELECTBLOB query works fine when using PB ODBC, instead.

FAULTING_IP:

PBSHR115!PbHeap_panic+237 [e:\pb115\3rdparty\heap\spbheap.c @ 1433]

004a0f77 cc int 3

Customer was using this application in PB 10.2 and it was crashing in pbdwe10.dll.

They upgraded to PB 11.5 and now it is crashing in pbshr115.dll.

RESOLUTION: Customer resolved issue by changing their code to: ls_user_id = Space(260)

li_return_code = GetEnvironmentVariables("USERNAME",ls_user_id,260)

ls_user_id = Trim(ls_user_id)

running vista and opening a window with a nested report.

RESOLUTION: Customer resolved issue. May have been a MS patch issue.

connection to MS SQL Server with the following settings:

- Hebrew database collation setting

- Hebrew OS settings

- Integrated (windows) authentication to SQL Server connection

String(Date(eyear, emonth, eday))

This expression works fine in PB 10.2.1, but in PB 11.5.1 it results in "Invalid Argument to Function" error message.

The expression works in 11.5.1 if the Date arguments are columns of long or number, but this customers columns are decimal from the database, and they no longer work.

08/12/2009: This has been fixed by Engineering. The fix is in 11.5 build 4575 and after.

The properties can be found in the object Browser for env object tree as properties, so they are there...

MemoryTotal

MemoryAvailable

MemoryVirtualTotal

MemoryVirtualAvailable

1 iteration of the libraryimport() will return -1.

The errors argument for libraryimport will be null. So there is no error given

except the return code returned -1.

Trying to open such a file will cause a crash.

dw.object.columnname.primary = 10

The columnname is a numeric (long) column. He knows he has done this in the past. But now it only seems to take an array of values. His concern there is that is slow on a datawindow. He was not able to identify what version of PB this used to work in. I went back as far as PB 8 but all work the same as now.

smart client application. But PB fail to pass argument(s) in web URL to launch the PB application. It is requested to consider the feature in coming PB Version.

Object: w_promasterce_sync

Routine: ue_postopen

Line No.: 8

wm 6.1, a customer is getting the following error on the runsync():

Cannot open transaction log

The pb_run_dbmlsync works ok. Problem only with the runsync(). If they leave

the last argument off in the runsync, than it works ok. No error.

They are using the following:

runsync(exe_name,is_publication_name,is_mluser,is_mlpassword,connect_string,other_arguments,is_sync_class_name)

Parameter values are as follows:

exe_name=\Program Files\SQLAny10\dbmlsync.exe

is_publication_name=pda

is_mluser=LRPETIT

is_mlpassword=嫫

connect_string = -c 鬱sn=CarillonPDA�

other_arguments = -d

is_sync_class_name = pda_LRPETTIT_sync

a target has a unc pathing for a pbl, orcascript returns a incorrect path.

A target has the following librarylist:

C:\pse\11503791\11503791\UNC\unc.pbl;

\\Ops-concord\duquette$\11503791\UNC\unc1.pbl;

After running orcascript, the log file shows the following:

8/13/2009 14:27 Source Management Initialization...

Local Project Path: c:\pse\11503791\11503791\unc\work

Scc Connect Offline Successful.

PBORCA_SccSetTarget: c:\pse\11503791\11503791\unc\unc.pbt

Target settings: IMPORT ONLY | REFRESH ALL (Implicit)

App Name: unc App Lib: c:\pse\11503791\11503791\unc\unc.pbl

Library List:

c:\pse\11503791\11503791\unc\unc.pbl

c:\ops-concord\duquette$\11503791\unc\unc1.pbl

Successfully created library: c:\ops-concord\duquette$\11503791\unc\unc1.pbl

PBORCA_SccClose

From the log file, you can see that the following is incorrect:

c:\ops-concord\duquette$\11503791\unc\unc1.pbl

Successfully created library: c:\ops-concord\duquette$\11503791\unc\unc1.pbl

It should be:

\\Ops-concord\duquette$\11503791\UNC\unc1.pbl;

Replication "HDR"). The secondary database generally act as ReadOnly database, unless

there is failure of primary. However, Secondary database can share certain readonly access

workload.

see this link

http://help.sap.com/saphelp_40b/helpdata/pt/08/5744c54ae611d1894f0000e829fbbd/content.htm

PowerBuilder first access to informix database must create those PB Catalog tables.

With no catalog table, accessing database by PB database painter, create datawindow object and accessing Stored Procedure or RPC calls etc all get this error:

SQL Error-626: Cannot obtain or set serial value.

ISAM Error-140:ISAM error: operation illegal on a DR Secondary

from link: http://www-01.ibm.com/support/docview.wss?rs=630&context=SSGU8G&dc=DB520&dc=DB560&uid=swg21288414&loc=en_US&cs=UTF-8&lang=en&rss=ct630db2

"-140 ISAM error: operation illegal on a DR secondary.

A DR secondary server is meant for read-only operations. Any kind of write operation to a nontemporary dbspace is not allowed. For example, you cannot create a table in a regular dbspace, and you cannot do an insert, update, or delete operation on a table in a regular dbspace."

PB INTERNAL EXCEPTION on: Thread : 3916, Address : 0x2B00E6FE, Type : EXCEPTION_ACCESS_VIOLATION reading address 0x0000006C. CPB_Component::invoke

EAS: 6.20 with EBF16459

PB: 11.02.8407

The crash happens every time the update occurs on a particular customer server. However, customer has other customers on which the same sized update with the same version of EAS/PB and same components works without problems.

and you create a datawindow, if a column type is defined as nvarchar that

column shows up as date.

The same column works ok when connected to MSS2005. The problem also

shows up if you create a new table and defined a column as nvarchar. When

you save the table, it will save the column type as date and not nvarchar.

Other problems:

- Date and time. You can create a table ok with a date and time

datatype. When retrieving data in a dw, the format is incorrect.

- Timestamp. When creating a new table, the timestamp datatype will

map to a binary datatype.

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

OS: Windows XP SP2

Versions and Build #s Tested: PB 11.5.1_4011

Database/Driver File/Version: ASA 11.0 with sample EASDemoDB V115

Comments: During runtime, datawindow in webforms never displays the same money format as set in Windows Regional Settings. The ASP.NET Culture and UI Culture settings in IIS Admin do not take effect in this case. Works fine in PB Native (client/server), only.

Versions and Build #s Tested: PB 11.5.1_4011

Database/Driver File/Version: ASA 11 EAS Demo DB V115

Comments: IF-THEN-ELSE works different in Web Forms. PB knows about the value and the datatype of "dw_2a.object.rcr_rcr_ven_1[ll_fila]" in runtime. This works fine in PBVM native, but causes the IF clause to skip to ELSE, when in Web Forms.

new_????? ??? _text_color=33554432

new_????? ??? _column_color=33554432

new_????? ??? _color=1073741824

new_????? ??? _text_border=None

new_????? ??? _column_border=None

new_???? ? ??? _text_color=33554432

I also have some entries in my pb.ini file, and one was corrupted like the above, but others had previous changes but not the latest changes. It's like the generation options got saved one place, but it looks in another place when creating new datawindows. It's also flaky in that sometimes it works and sometimes it doesn't work. It may also be that some style types work and others do not. So please check for all the style types.

text to the printer does not work.

Using the following code:

long Job

Job = PrintOpen( )

Print(Job, "Sybase Corporation")

PrintClose(Job)

The customer just sees a blank page. Customer trying to print to a HP LaserJet 8000 Series PCL

RESOLUTION: Use Print(Job, "~r~nSybase Corporation") instead. The reason is the text prints at the current print-line position, which has not yet been set, and so tries to print outside of the margin.

The compute column eventually reference a Window instance and rely on Listbox control's

DirList function to return directory list. Whenever, preview the datawindow object or set the datawindow object on a Window's datawindow control, the whole PB IDE will crash.

When a datawindow column has sufficient height so that more than one line

of text fits in the height of the column, then more text can be entered

into the column than should have been allowed (edit.limit).

Application platform - PowerBuilder 11.5 build-3127 (front end UI as well as back-end COM+ Components are built in PB 11.5)

PB INTERNAL EXCEPTION on: Thread : 6656, Address : 0x004F15BE, Type : EXCEPTION_ACCESS_VIOLATION. ot_run_dllfunccall.

When problem happens, the column background color is broken to three part.

Upper part - White (with text)

Middle part - Aqua (empty space)

Last part (not enough for one text line) - White.

The column background color expression:

" if (isnull(c4) or len(c4) = 0, rgb(0,255,255), rgb(255,255,255)) "

Engineering advises this cannot be done in an EBF, but only in a new version. Therefore asking for this to be included in PB 12.0.

of a large application after a previous version worked fine.

using multi tables and computed columns, when you display the Update Properties

it is displaying an incorrect identity field.

The problem appears to be caused from the following computed field:

(select count(*) from CGPS_TravelClaimsDetail where CGPS_TravelClaimsDetail.claimid =

CGPS_TravelClaims.claimid) as detaillinescnt,

Not sure if this works as designed or if this is a malfunction.

workarounds for this particlar case are:

=======================================

1.) remove the ansi keyword, or

2.) Define a new structure ie.

global type s_byte from structure

byte data[9]

end type

And in the code define instance variables to be eg:

s_byte isb_obj1 , isb_obj2

and then call it similar to input outpu button exisiting code, or in one button:

aa_unicode_test(isb_obj1 ,isb_obj2)

//assigning output to input object

isb_obj1.data = isb_obj2.data

aa_unicode_test(isb_obj1 ,isb_obj2)

The xml however fails validation against the xsd file due to missing nillable attribute.

This problem has on EBF 16685(PB11.2 build 8739) / EBF 17123(PB 11.5.1 build 4566) or later.

The crash was happening in the dwtableaggrsortcmp.

This worked in PB 11.2 (build 8407). Crashing for the customer in PB 11.2 (build 8806)

on a Win 2008 Cluster File Server.

using a cursor and fetch statements results in the following error:

ct_fetch(): user api layer: external error: The connection

has been marked dead

RESOLUTION: Fixed under OpenSwitch cr590381

The workaround is setting either

HKCU\SOFTWARE\Microsoft\Windows\CurrentVersion\Internet Settings\ReceiveTimeOut

or

HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Internet Settings\ReceiveTimeOut

to a DWORD value to the desired time-out in milliseconds.

opens a userobject and using dynamic datawindows. The webform will tab

to greyed out fields.

Tabbing works ok in PBNative.

The u_cte_pane opens on the w_cte_page_child. The columns that the dw incorrectly

tabs to are: firstname,surname, st_address, inv_city, inv_state, and inv_zipcode.

The u_cte_page/uf_add_pane adds the panes to the window. The u_cte_pane_dataobject/uf_update_syntax updates the syntax.

Customer claims that the datawindow saved in PB 6.5.1 imports into Crystal Reports 5 and the one created in PB 11.2 does not. He says the PB 11.2 files want the BDE driver rather than the XBASE driver as the PB6.5 DBF wanted.

MS Word 2007 .docx extension.

General, the Reload painters when opening solution is disabled and always checked.

Appears to be similar to 568755 which is for workspace.

and it requires the scannername property to be populated when using the open().

If the Scannername property is not populated, open() returns -7.

For example:

inv_scannerobject.ScannerName = "SCN1:"

Example 1:

Select col1, col2, '' AS testcolumn

In PB 10.5 the datatype in the datawindow is char(0). In 11.5 it is char(1).

Example 2:

Select col1, col2, space(30) AS testcolumn

In PB 10.5 the datatype is char(30). In 11.5 it is char(32766).

and you create a new WPF window, while the window is being created the PB .NET IDE

will temporarily move behind another program

for datetime columns when dbparm DateTimeFormat is set.

Error: 'gob.bFocusRect' is null or not an object

Because there are so many webservice dlls and they are all named the same across the six environments, sometimes they make misstakes and have the wrong dll in an environment, a dll that was created in another environment. When that happens there is no error and the wrong webservice is accessed. This can cause data integrity problems, and they aren't even aware it is happening. What they are asking for is for PB to warn them when this happens. They want PB to internally mark the dll somehow when it is created, and when a dll is being used that was not created with that environment, they want PB to error at run time.

2. Using Shadow Studio (dataDirect) as midware to generate a wsdl file. The variables displayed in the wsdl file as <s:element minOccurs="1" maxOccurs="1" nillable="true" name="Wsm_x0056_last_nam" type="s:string" />

<s:element minOccurs="1" maxOccurs="1" nillable="true" name="Wsm_x0056_first_nam" type="s:string" />

3. Using PowerBuilder Web Service Proxy Wizard to get the variables passed to the PB application. Cusotomer is using the.Net engine as SOAP engine.

4. After deployed the generated Web Service Proxy Project. Above variables name displayed as String WsmVlast_nam, String WsmVfirst_nam. PB is substituting the letter V for the string _x0056_. x0056 is the hex representation for the capital V but this is a string and customer does not think it should. Searching the internet to see if name fields can contain hex representations of characters did not produce anything definitive.

5. Customer has tried to use the variables as it is generated. There is no data can be passed to the variables.

6. She also tried to change the names of the variables back to Wsm_x0056_last_nam, Wsm_x0056_first_nam. And the data were not passed either.

Beside the variables name with "_x00nn_" so far, there are some names with "_t00nn_� are displayed correct.

Customer sees this as a bug.

Versions and Build #s Tested: PB 11.5.1_4590

Database/Driver File/Version: IN10 Interface connecting to Informix 9.x Database, with Informix Client 3.00.TC3

Comments: During Web Forms runtime, datawindow retrieve() sometimes return the error:

Select Error: SQL Error -404: The cursor or statement is not available

The issue happens if we split SQLCA connection, dw.setransobject(), dw.retrieve(), disconnect in different buttons within window. If we place the entire code from all buttons into Connect Button (connection, set trans, query and disconnect), the issue never happens In PB Native (client/server), the issue never happens.

The only known PDA that this will occur on ( every time ) is the HP iPAQ Data Messenger.

Same issue is also on Vodafone v1615抯.

This worked ok in PB 10.5.2.

Tested saving an rtf in Word and once document loaded the tab stops that were set were active.

#if defined PBNATIVE then

is still always evaluating as false when used with Orca. This was submitted as CR 576927 and the resolution states that the fix was implemented in PB 11.2 but testing with build 8896, it doesn't appear to be fixed.

System.Security.SecurityException

Request for permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0,

Culture=neutral, PublicKeyToken=b77a5c561934e089' failed in event open of object ora10

Analysis/Actions (Workaround):

Determined that the following needed to be added (http://msdn.microsoft.com/en-us/library/tkscy493.aspx) to the system.web node of the web.config file.

<securityPolicy>

<trustLevel name="Full" policyFile="internal" />

<trustLevel name="High" policyFile="web_hightrust.config" />

<trustLevel name="Medium" policyFile="web_mediumtrust.config" />

<trustLevel name="Low" policyFile="web_lowtrust.config" />

<trustLevel name="Minimal" policyFile="web_minimaltrust.config"/>

</securityPolicy>

<trust

level="Full"

originUrl=""

processRequestInApplicationTrust="true"

/>

Workaround: post the modify call.

tab into a dddw, there is no indication that focus is on the dddw and if you

use the arrow key nothing happens.

RESOLUTION: Uninstall Office 2003. Reinstalled Office 2003. Open the *.docx and

a message appears that a converter needs to be installed. Click ok. Goto this site

http://www.microsoft.com/downloads/details.aspx?FamilyId=941B3470-3AE9-4AEE-8F43-C6BB74CD1466&displaylang=en. Install the required patches and then FileFormatConverters.exe. Not a PB bug.

It behaves correctly when I make the summary band a bit smaller by

just a bit. ie. from 100 to 83. I also set autosizeheight on for that band.

the PowerScript manual list 'Preview mode provides edit boxes for specifying

paper dimensions and margins'.

According to cr435746, the new rte control starting in PB 10.5 no longer

shows that information.

Please also add the following to the online help and PowerScript manual:

(the following is from the App Techniques manual):

Users can page through the control contents in print preview mode by using the up arrow and down arrow keys or the Page Up and Page Down keys.

Versions and Build #s Tested:

- PB 11.5.1_4608 web forms on Windows XP

- IE 7.0 and IIS 6.0 on Windows 2003 R2 SP2

- Microsoft .NET Framework 2.0

- PB 11.5.1_4608 Runtime Packager deployed (.NET and Standard components) deployed correctly into Win2k3 R2 machine

Database/Driver File/Version: N/A

The following error appears when clicking on webform dw_control (if its "clicked" event is coded):

array boundary exceeded: void d(system.string) of object sybase.powerbuilder.web.webdatawindow.

--Update--

This seems to be the same as an existing Microsoft WPF Designer bug.

BugID 320579

https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=320579

SQL statements with sub-select queries with parms gives error:

"Microsoft SQL Server Native Client 10.0

Parameter Information cannot be derived from SQL statements with sub-select queries. Set parameter information before preparing command.

a random crash in the pbvm115.

FOLLOWUP_IP:

pbvm115!EvtUserEventProc+4c [e:\pb115\runtime\function\fnevents.cpp @ 2301]

10c0d48c eb02 jmp pbvm115!EvtUserEventProc+0x50 (10c0d490)

FAILED_INSTRUCTION_ADDRESS:

+26b952f01dddf74

00000001 ?? ???

NTGLOBALFLAG: 0

APPLICATION_VERIFIER_FLAGS: 0

FAULTING_THREAD: 0000122c

BUGCHECK_STR: APPLICATION_FAULT_BAD_INSTRUCTION_PTR_INVALID_POINTER_READ_WINDOW_HOOK

With PB 11.5 there is no separate install for the Runtime version of the database server.

English version of RuntimeEdition.html:

SQL Anywhere� 11 Runtime Edition

Version 11.0.0

June 2008

Runtime Edition overview

The Runtime Edition of SQL Anywhere is a special version of the SQL Anywhere database server. It is intended for use as a low-cost deployment option where the full functionality of SQL Anywhere is not required.

Feature summary

The Runtime Edition of SQL Anywhere has the following features.

It is a single-user, transaction-processing database server. It supports up to 10 same-machine connections.

It fully supports the DML subset of SQL commands, such as SELECT, INSERT, UPDATE, and DELETE.

It provides full referential integrity, including cascading updates and deletes.

It supports declared temporary tables.

It allows users to be added to a database.

Supported operating systems

The Runtime Edition is available for Windows XP/200x (both 32 bit and 64 bit) and Windows Mobile.

Runtime Edition features

The SQL Anywhere Runtime Edition is a restricted version of the SQL Anywhere personal database server.

Runtime and personal server differences

The functions supported by the SQL Anywhere personal database server that are not fully supported in the Runtime database server are as follows:

Function supported by personal database server

How it operates in the Runtime Edition

Executable name: dbeng11.exe

The executable name is rteng11.exe. You must ensure that any ODBC data sources and command lines you distribute reflect this executable name. This executable name can be used in configuration files with conditional parsing.

Replication and synchronization

You cannot replicate data using either MobiLink or SQL Remote, or by any other means.

ALTER statements

You cannot use any of the ALTER statements.

CREATE statements

You can use CREATE VARIABLE to create SQL variables. SQL variables do not form part of the database definition.

You cannot use any other CREATE statements.

COMMENT statement

You cannot add comments to the system tables.

DROP statements

You cannot use any of the DROP statements to drop a database object from the system tables.

CALL/EXEC statement

You cannot invoke stored procedures, including system procedures. Consequently, you cannot obtain procedure profiling information.

GRANT statement

You can grant the special user permissions (CONNECT, DBA, RESOURCE, GROUP, MEMBERSHIP IN GROUP) using GRANT, but you cannot change permissions on tables and views.

REVOKE statement

You can revoke the special user permissions using REVOKE, but you cannot change permissions on tables and views.

Triggers

Triggers are not fired by the Runtime Edition.

Events

You cannot add events to a database.

No transaction log

To simplify database administration, the Runtime Edition does not employ a transaction log. Users should back up their databases by making copies of their database file. If a Windows General Protection Fault or a power failure occurs during a standard operation, the database file may be corrupted. Because there is no transaction log, failed transactions cannot be recovered.

Auditing is not supported because there is no transaction log.

Heterogeneous query support

You can only issue queries to a single database. You cannot access data from external databases using the Runtime Edition.

Adaptive Server Enterprise/Microsoft SQL Server compatibility

INSERT, UPDATE, DELETE, and SELECT statements can be common between Adaptive Server Enterprise and the Runtime Edition. However, the advanced syntax feature is not supported in the Runtime Edition.

Database logic cannot be reused within a SQL Server database because the Runtime Edition does not support stored procedures.

The Runtime Edition does not support Open Server or Open Client, and none of the SQL Server connectivity tools or applications work against the Runtime Edition database server.

Communication encryption

You cannot encrypt communications in the Runtime Edition.

Database file encryption

You cannot encrypt database files that are used by the Runtime Edition.

The database server options that refer to transaction logs (-a, -f)

Not applicable to the Runtime Edition.

The dbbackup options that refer to transaction logs (-r, -t, -x)

Not applicable to the Runtime Edition.

INSTALL statement

You cannot install Java classes.

JDBC access from client applications

The Runtime Edition supports JDBC applications using the iAnywhere JDBC driver. The Runtime Edition does not support applications using jConnect for JDBC access.

Java in the database

You cannot store or execute Java classes in a database used by the Runtime Edition. You must use an external environment.

Web services

Web services are not supported.

Table encryption

Table encryption is not supported.

Application profiling and diagnostic tracing

Application profiling and diagnostic tracing are not supported.

Redistributable components

This section lists the components that are redistributable under your SQL Anywhere Runtime software license.

The Runtime Edition is licensed for standalone use only. If you plan to use SQL Anywhere within the context of an application server, web-server, multi-plexors and/or synchronization, you must license the full edition of SQL Anywhere.

Deployment issues are also discussed in the section "Deploying databases and applications" of the book SQL Anywhere Server - Programming.

Windows XP/200x

Redistributable files for Windows XP/200x are held in the bin32 or bin64 directory under your SQL Anywhere installation directory. For Windows Mobile they are held in CE\ARM.50.

If your application uses ODBC, your users need ODBC installed on their computer. Contact Microsoft for information about redistributing ODBC.

The following files can be redistributed under the software license.

File

Description

dbbackup.exe

Utility to back up a database.

dbcoen11.chm

Help file for connections and ODBC configuration.

dbcon11.dll

ODBC connection window.

dbctrs11.dll

Database server DLL.

dbdsn.exe

Utility to create, delete, describe, and list SQL Anywhere ODBC data sources.

dberase.exe

Utility to erase a database.

dbicu11.dll

Required only if the database character set is multi-byte or if the UCA collation sequence is used.

dbicudt11.dat

Required for ICU on Windows Mobile.

dbicudt11.dll

Required for ICU on Windows XP/200x.

dbinfo.exe

Utility to display information about a database.

dbisqlc.exe

SQL command processor.

dbjodbc11.dll

iAnywhere JDBC driver.

dblgen11.dll

Language-specific strings for interface and server.

dblib11.dll

Embedded SQL interface DLL.

dbodbc11.dll

ODBC driver DLL.

dboledba11.dll

OLE DB provider support utility.

dboledb11.dll

OLE DB provider.

dbserv11.dll

Database server DLL.

dbstop.exe

Utility to stop a database server.

dbsvc.exe

Utility to create, delete, and modify SQL Anywhere services.

dbtool11.dll

Database tools utility DLL.

dbtsinfo.exe

Technical support utility.

dbvalid.exe

Utility to validate a database

iAnywhere.Data.SQLAnywhere.dll

policy.11.0.iAnywhere.Data.SQLAnywhere.dll

.NET Data Provider utility. These files are installed in install-dir\Assembly\v2.

jodbc.jar

iAnywhere JDBC driver. This file is installed into the java subdirectory.

rteng11.exe

Runtime database server.

sqlany.cvf

Character set conversion mappings.

util_db.ini

Specifies the password to use when connecting to the utility database.

English version of RuntimeEdition.html:

SQL Anywhere� 11 Runtime Edition

Version 11.0.0

June 2008

Runtime Edition overview

The Runtime Edition of SQL Anywhere is a special version of the SQL Anywhere database server. It is intended for use as a low-cost deployment option where the full functionality of SQL Anywhere is not required.

Feature summary

The Runtime Edition of SQL Anywhere has the following features.

It is a single-user, transaction-processing database server. It supports up to 10 same-machine connections.

It fully supports the DML subset of SQL commands, such as SELECT, INSERT, UPDATE, and DELETE.

It provides full referential integrity, including cascading updates and deletes.

It supports declared temporary tables.

It allows users to be added to a database.

Supported operating systems

The Runtime Edition is available for Windows XP/200x (both 32 bit and 64 bit) and Windows Mobile.

Runtime Edition features

The SQL Anywhere Runtime Edition is a restricted version of the SQL Anywhere personal database server.

Runtime and personal server differences

The functions supported by the SQL Anywhere personal database server that are not fully supported in the Runtime database server are as follows:

Function supported by personal database server

How it operates in the Runtime Edition

Executable name: dbeng11.exe

The executable name is rteng11.exe. You must ensure that any ODBC data sources and command lines you distribute reflect this executable name. This executable name can be used in configuration files with conditional parsing.

Replication and synchronization

You cannot replicate data using either MobiLink or SQL Remote, or by any other means.

ALTER statements

You cannot use any of the ALTER statements.

CREATE statements

You can use CREATE VARIABLE to create SQL variables. SQL variables do not form part of the database definition.

You cannot use any other CREATE statements.

COMMENT statement

You cannot add comments to the system tables.

DROP statements

You cannot use any of the DROP statements to drop a database object from the system tables.

CALL/EXEC statement

You cannot invoke stored procedures, including system procedures. Consequently, you cannot obtain procedure profiling information.

GRANT statement

You can grant the special user permissions (CONNECT, DBA, RESOURCE, GROUP, MEMBERSHIP IN GROUP) using GRANT, but you cannot change permissions on tables and views.

REVOKE statement

You can revoke the special user permissions using REVOKE, but you cannot change permissions on tables and views.

Triggers

Triggers are not fired by the Runtime Edition.

Events

You cannot add events to a database.

No transaction log

To simplify database administration, the Runtime Edition does not employ a transaction log. Users should back up their databases by making copies of their database file. If a Windows General Protection Fault or a power failure occurs during a standard operation, the database file may be corrupted. Because there is no transaction log, failed transactions cannot be recovered.

Auditing is not supported because there is no transaction log.

Heterogeneous query support

You can only issue queries to a single database. You cannot access data from external databases using the Runtime Edition.

Adaptive Server Enterprise/Microsoft SQL Server compatibility

INSERT, UPDATE, DELETE, and SELECT statements can be common between Adaptive Server Enterprise and the Runtime Edition. However, the advanced syntax feature is not supported in the Runtime Edition.

Database logic cannot be reused within a SQL Server database because the Runtime Edition does not support stored procedures.

The Runtime Edition does not support Open Server or Open Client, and none of the SQL Server connectivity tools or applications work against the Runtime Edition database server.

Communication encryption

You cannot encrypt communications in the Runtime Edition.

Database file encryption

You cannot encrypt database files that are used by the Runtime Edition.

The database server options that refer to transaction logs (-a, -f)

Not applicable to the Runtime Edition.

The dbbackup options that refer to transaction logs (-r, -t, -x)

Not applicable to the Runtime Edition.

INSTALL statement

You cannot install Java classes.

JDBC access from client applications

The Runtime Edition supports JDBC applications using the iAnywhere JDBC driver. The Runtime Edition does not support applications using jConnect for JDBC access.

Java in the database

You cannot store or execute Java classes in a database used by the Runtime Edition. You must use an external environment.

Web services

Web services are not supported.

Table encryption

Table encryption is not supported.

Application profiling and diagnostic tracing

Application profiling and diagnostic tracing are not supported.

Redistributable components

This section lists the components that are redistributable under your SQL Anywhere Runtime software license.

The Runtime Edition is licensed for standalone use only. If you plan to use SQL Anywhere within the context of an application server, web-server, multi-plexors and/or synchronization, you must license the full edition of SQL Anywhere.

Deployment issues are also discussed in the section "Deploying databases and applications" of the book SQL Anywhere Server - Programming.

Windows XP/200x

Redistributable files for Windows XP/200x are held in the bin32 or bin64 directory under your SQL Anywhere installation directory. For Windows Mobile they are held in CE\ARM.50.

If your application uses ODBC, your users need ODBC installed on their computer. Contact Microsoft for information about redistributing ODBC.

The following files can be redistributed under the software license.

File

Description

dbbackup.exe

Utility to back up a database.

dbcoen11.chm

Help file for connections and ODBC configuration.

dbcon11.dll

ODBC connection window.

dbctrs11.dll

Database server DLL.

dbdsn.exe

Utility to create, delete, describe, and list SQL Anywhere ODBC data sources.

dberase.exe

Utility to erase a database.

dbicu11.dll

Required only if the database character set is multi-byte or if the UCA collation sequence is used.

dbicudt11.dat

Required for ICU on Windows Mobile.

dbicudt11.dll

Required for ICU on Windows XP/200x.

dbinfo.exe

Utility to display information about a database.

dbisqlc.exe

SQL command processor.

dbjodbc11.dll

iAnywhere JDBC driver.

dblgen11.dll

Language-specific strings for interface and server.

dblib11.dll

Embedded SQL interface DLL.

dbodbc11.dll

ODBC driver DLL.

dboledba11.dll

OLE DB provider support utility.

dboledb11.dll

OLE DB provider.

dbserv11.dll

Database server DLL.

dbstop.exe

Utility to stop a database server.

dbsvc.exe

Utility to create, delete, and modify SQL Anywhere services.

dbtool11.dll

Database tools utility DLL.

dbtsinfo.exe

Technical support utility.

dbvalid.exe

Utility to validate a database

iAnywhere.Data.SQLAnywhere.dll

policy.11.0.iAnywhere.Data.SQLAnywhere.dll

.NET Data Provider utility. These files are installed in install-dir\Assembly\v2.

jodbc.jar

iAnywhere JDBC driver. This file is installed into the java subdirectory.

rteng11.exe

Runtime database server.

sqlany.cvf

Character set conversion mappings.

util_db.ini

Specifies the password to use when connecting to the utility database.

Customer install crashes when selecting next on the "license type" screen in the PB 11.1 install.

Workaround: There seems to be a timing issue in event sequence when the multiselect property is changed in either constructor event or open event of a window on which the listbox resides.

After moving the codeline lb_1.multiselect = TRUE

from constructor of lb_1 on the sheet window to the getfocus() event

of lb_1 it works ok.

Similar in the response window sample part, if the multiselect change

part is put into the eg. show() event of the window, or if that code section

is posted from the open event, it worked fine.

In the Control List selecting a text object or a button object marks the DataWindow as modified.

This does not happen for a column object, a picture, a line, oval or other

graphical object or a computed field.

Versions and Build #s Tested: PB 11.5.1_4608

Database/Driver File/Version: ASA 11.0 with sample EASDemoDB V115

Comments: Decimal format does not follow regional settings when generating PDF from dw report based on stored procedure resultset. Also, datawindow displays incorrect decimal format within nested reports.

Issue happens with webforms, only. Works fine in Native PB (client/server).

ds_data.Object.DataWindow.Data.HTML

has a large text field.

When paging thru the psr, you can see it displays Page 1 of 3, Page 2 of 3, Page 2

of 3.

It should be display Page 1 of 3, Page 2 of 3, Page 3 of 3.

RESOLUTION: Not a PB Bug. From PowerBuilder User's Guide manual, Chapter 25 Using Nested Reports

Working with nested reports --> Using options for nested reports --> Using the Autosize Height option

Handling large rows

To avoid multiple blank pages or other anomalies in printed reports, never create a DataWindow object with a data row greater than the size of the target page. To handle large text-string columns, break the large string into a series of small strings. The smaller strings are used to populate individual data rows within a nested report instead of using a single text column with an autosized height.

RESOLUTION: Not a PB bug

When the problem happens, two different of color exist on the same column.

i.e. Lines with empty space, Lines with characters and last line get different colors.

Error info given by IE may look like:

Server Error in '/myapp' Application.

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

Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.

You can get detailed info on WebForm permanent user from PowerBuilder HTML Help -->Deploying Applications and Components to .NET -->WebForm targets -->Chapter 4 User Management and Registry Operations in Web Forms

A workaround for this issue is to change the PBAppPool's identity from ApplicationPoolIdentity to NetworkService in IIS management console.

configured dark red\brown within the control panel for Windows Classic Style controls.

This happens only for this color Red=128, Green=0, Blue=0

If you adjust the Green and Blue from 0 to 1 in the control panel then the check boxes are displayed.

For years powerbuilder developers had altered their ini file located in C:\Program Files\Sybase\PowerBuilder 11.5 now in powerbuilder 11.5 the ini files that are actually used are in

C:\Documents and Settings\user\Local Settings\Application Data\Sybase\PowerBuilder 11.5

Having the .ini files in two locations causes much confusion for our customers. Worse the ini files that are actually used, are hidden and do not show up on a search! Is there any good reason for the duplication of these files? I believe the .ini files left in C:\Program Files\Sybase\PowerBuilder 11.5 should be deleted.

document looses the formatting.

The results of the macro in the word document is the format is not the same as

the rest of the document.

RESOLUTION: Not a PowerBuilder issue.

are no longer supported using OLEDB and MSSQL Server 2008.

Please document the timestamp datatype for OLEDB and MSSQL Server 2008 will be

fixed in PB 12.

this is according to cr586186

If you call eg. receiver abc周咪鳇xyz in cmd, it will be received as

receiver.exe (applications's open event):

MessageBox( "....", commandline ) -> "abc�-蚠鞒xyz"

Workaround: P-code exe will work ok.

When The developer try to modify the datawindow PB need to display a message asking if you want to check it out (if it possible). This would speed up and ease development.

datawindow returns the following error:

Select Error:

Column lists do not match

The error happens when returning values from a stored procedure. The error happens

at runtime. It works ok when retrieving from the dw painter.

Customer is staticbind=0 to workaround an issue with the bit datatype. If they

use staticbind=1, than it works ok but then they run into the issue with the bit

datatype (cr463142).

> PBDWE115.DLL!DWTable::ChangeTableValue(unsigned short * newValue=0x00000000, long dddw_currow=0) Line 312 + 0x15 bytes C++

PBDWE115.DLL!DWDataWindow::AcceptText(long lParam=0, unsigned int wParam=0) Line 42 + 0x14 bytes C++

in executing sp_procedure_xx_params_rowset many times.

Using spcache=0 to workaround null problem (related to cr587611).

From SQL Profiler, you can see it is executing sp_procedure_params_rowset many

times.

RESOLUTION: Since disabling caching of stored procedure information by dbparm SPCache=0, PB needs to get the parameters information from server every time stored procedure is executing, this is what the sp_procedure_xx_params_rowset be used to do.

Not a bug.

replaced by "pb1.." if the updated data contains a single quotation mark (').

Autosize height is turned on for DataWindow columns defined in the nested report.

When data is displayed at the bottom of a page, the data is cut and displayed at the beginning of subsequent page.

with an array in dotnotation gives back only Nulls while a string type worked.

datawindow.Object.colname.Primary = Array

All values of the column in the array are NULL if the column type is long.

that most of her RichText Datawindow reports are distorted.

One of the reason is the Tab Stop Size of last line is changed after migrate to PB11.5.

Datawindow reports are distorted. One of the reason is the missing Fixedsize input field

column properties on the RichText Datawindow control. When the input field coumn is

multi-lines , there will be a large distortion on those lines with the column.

'Error return values from the printer driver were being dropped. Propogated the return codes to the PrintOpen() and the PrintClose() system functions. '

But it apears to not be working still. We are not able to capture anywhere the

fact that the user currently doesn't have the RW220 Zebra Printer turned on when trying to print.

A workaround for this issue is to change the PBAppPool's identity from ApplicationPoolIdentity to NetworkService in IIS management console.

goes to 100 cpu usage.

Dump files included.

RESOLUTION: Oracle patches resolved issue. Oracle patch 9233830 (Bundle 31) and patch 5893079 were applied to Oracle 10g client. Patch 5893079 was applied to Oracle 10.2.0.4 server.

I have a C# assembly (SureWest.Operations.Clients) that references another C# assembly (SureWest.Operations.Common). When I add a reference to SureWest.Operations.Common in PB.NET the IDE can reflect over the assembly and show the types in it; however, when I reference SureWest.Operations.Clients, the IDE doesn't show any of the types. This happens whether I have SureWest.Operations.Common referenced or not.

My Response:

This behavior looks like when reflecting over the (Operations.Clients) assembly, the IDE is not finding the assembly that is referenced the 'base' (Operations.Common).

If the two assemblies are neither in the GAC nor on the PATH, then this is probably what would happen.

I'm not sure what happens if the two assemblies are in the _same_ directory, which itself is neither the GAC nor in the PATH (I'll give that a look in a bit).

1) If you include the exe in the new string, then you get the exe twice in the resulting library list. The documentation says it should be ignored.

2) If you do a setlibrarylist in the application open event and set the list to the same files (with or without the extra exe) as were originally in the list. Then start a sharedobject, do a SetLibraryList call in the SharedObject, the library list is not good. It can't find objects in the pbds in the list.

3) If you make changes to the library list with setlibrarylist, and then you start up a sharedobject. The getlibrarylist in the sharedobject thread does not get the changes you made to the library list. It gets the original default library list.

You can get detailed info on .NET client SSL from PowerBuilder HTML Help -->Deploying Applications and Components to .NET -->.NET Language Interoperability -->Chapter 15 Building .NET client for EAServer -->SSL connection support.

A workaround for this issue is to change the PBAppPool's identity from ApplicationPoolIdentity to NetworkService in IIS management console.

Versions and Build #s Tested: PBVM 11.5.1_4608 on EAServer 6.3.0.06 Advanced Edition for Linux

The issue happens when dw container has a datawindow a with Spin Control inside it. It resides in PBVM 11.5.1_4608. On EAServer 6.x on Windows, all works fine.

declare @id char(9)

select @id = "LAUER"

select @id

;

This should return a resultset of "LAUER". This works fine with SNC. Customer would like the same capability for SYC and ASE connections.

Customer went from PB 8 to 11.5 and are having a crash problem with reselectrow. He found CR 563133 which was similar and fixed around Mar 11, 2009. But he has upgraded to 11.5.1 which is well after that and is still having the problem. His problem occurs under these conditions: The underlying table has no primary key defined, but does have an unique clustered index defined. The datawindow has the index unique defined as primary key in the update properties. When running the attached application, the application will crash if the record whose key value is empty is updated and then reselected.

caused a runtime error Bad runtime function reference on a certain PDF file that contained scanned images.

setitem - getitem throws a runtime exception when accessing a value that is not existant, accessing via dot notation does not.

assigning a value using dot notation inserts a row implicetely, for setitem an insertrow is needed.

Migration from PB9 to PB11.5. -> worked in PB9 PBVM, ->Regression.

Versions and Build #s Tested:

- Powerbuilder 11.5.1_4608

- PBVM 11.5.1_4608 on EAServer 6.3.0.06 Advanced Edition for Linux on Linux Red Hat 5.0

Database/Driver File/Version: N/A

When Using SetFullState after SetFilter/Filter on datastore, PB client crashes.

I could isolate the issue has to do when connecting to PBVM 11.5.1_4608 on Linux. I installed same Linux PBVM 11.5.1_4608 on EAServer 6.2 and 6.3 (both on Linux machine) and issue is always reproduceable. Issue does not happen if connecting to PBVM 11.5.1 on EAServer 6.3/Windows instead.

an exception in thread error in EAServer.

The error in the eas log is:

Exception in thread "btpool0-1" java.lang.StackOverflowError

at com.sybase.jaguar.server.JaguarObject.invoke(Native method)

at com.sybase.jaguar.server.JaguarObject.invoke (JaguarObject.java.303)

at com.sybase.jaguar.server.JaguarObject.invoke (JaguarObject.java:97)

at com.sybase.jaguar.server.JaguarObject_DJC.invoke (JaguarObject_DJC.java:341)

at ejb.components.keystoneseq.n_keyeasseq_nvo_EJB.of_get_system_datetime(n_keyeasseq_nvo_EJB.java:92)

at ejb.components.keystoneseq.n_keyeasseq_nvoRemote.of_get_system_datetime(n_keyeasseq_nvoRemote.java:60)

at ejb.components.keystoneseq.n_keyeasseq_nvoRemote_DJC.access$801(n_keyeasseq_nvoRemote_DJC.java:4)

It works ok using a PB client calling the webservice. It works the first time

invoking the webservice from Eclipse.

RESOLUTION: Changed the pb code to use the SYJ driver instead of the jdbc driver.

on windows 7, the table list does not expand in the db painter.

The SQL statements to not work in the db painter.

RESOLUTION: Cannot reproduce

1. describe (evaluate('page()', 5))

2. dw_2.find(pag=2, 1, dw_2.rowcount())

In a normal DW without nested report everything is fine.

Customer has regression in how HTML is generated for a datawindow. The customer app uses EASever 5.5 and has jsps deployed to EAS. These jsps use their own PB component that uses Datastore.Describe("DataWindow.Data.HTML") to generate html that is displayed by the jsps. There app is large with many datawindows and they are seeing a regression in how their datawindows look:

1) Vertical scroll bar. They have a large text field, and in 10.5 html the field has a vertical scroll bar allowing access to all the text. There is no vertical scroll bar in 11.5.

It seems to point to xerces-c_2_6.dll

Customer is observing poor performance using WebServices in Powerbuilder 11.5.1 he is using Webservices to bring back data files. The customer is seeing much better performance with their Java implementation.

But in PowerBuilder 11 and PowerBuilder 11.5 all white spaces are being removed space (char 20hex), carriage return, line feed, tab

The crash occurs when accessing a dddw datawindow for which protectmode and

some colour settings are set in script.

This does not happen if the jsp contains only 1 webdw which is expected behavior.

Versions and Build #s Tested: PB 11.5.1_4675 and old PB 9.0_5507

Database/Driver File/Version: N/A

Comments: When saving rows to xml, the decimal values entered in Portuguese (Brazil) decimal format are still saved in XML as US English decimal format.

This is a regression when compared to old PB 9.0.

the right behavior can be accomplished. Customer would eg. need to set Defaultlanguage to Hebrew!.

Getting intermittent exception:

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.IndexOutOfRangeException: Index was outside the bounds of the array.

Does not work: sqlca.DBPARM = "DisableBind=1,ConnectString='DSN=myServer;UID=sa;PWD='"

Works: sqlca.DBPARM = "ConnectString='DSN=myServer;UID=sa;PWD=',DisableBind=1"

Solution is to move DisableBind at the end of the string.

Same repro steps give no problem with ASA.

the following error results:

Error: Exception thrown has not been handled

System.AccessViolationException at line xx in event clicked of object cb_1

Problem only happens on Vista and Windows 7. Works ok on winxp

when using the ASE driver.

Calling a stored procedure that will return a string and the string value has

leading spaces. The ASE driver appears to remove the spaces.

Works ok with the SYC driver

(w3wp) occupies the memory. After logging out, the memory still remains.

When many sessions are running a web form application and logging out, MemUsage

continues to increase until 'The Server is busy' message appears. Then nothing

responses.

We were able to reproduce the fast behavior in an early version of PB 9 (9.0). But later versions of both 8 and 9 had a similar delay as 11.5.1 does. We suspect that the regression started sometime between 9.0 and 9.0.3, and 8.0.2 and 8.0.4. The customer is only seeing it now for the first time as they went from 8.0.2 to 11.5.1.

as an application executable and the system environment variable JAVA_HOME is set, the jdk from the JAVA_HOME is getting loaded.

The issue is the customer has other (non pb) applications that rely on the JAVA_HOME to run and customer wants the jre that resides in the pb application executable directory to get loaded.

Tried PBJRE_NOTUSECURRENT in the pb.ini

jvm_version.exe

jre

-bin

-lib

Currently they are not threadsafe.

the Access Services gateway, the datatype mapping is incorrect.

A timestamp column is being converted to char(26). A char(3) column is converted to

decimal(1) and char(9) is being converted to date. A smallint converted to long

and date converted to time.

RESOLUTION: DBParm of DBGatewayUDT='yes' resolved datatype mapping issue.

When binding is enabled (DisableBind=0), strings are truncated when passed to the ODBC driver.

They intermittently get the error message:

"The underlying connection was closed: A connection that was expected to be kept alive was closed by the server."

now datawindow.update() does not insert data into the database in certain

scenerio.

This worked in PB 11.5.1 (build 4566)

The toolbar background color becomes gray when ChangeMenu is called

in the open event of a sheet that has no menu attached at designtime.

The issue did not happen when the ChangeMenu call was posted.

In the DataWindow Reference Guide, Chapter 3 it explains what each one of these

crosstab properties are (Columns,Rows, SourceNames,StaticMode and Values).

Under the 'See also' section, I think it should reference: see the Table.properties

for details on the Table.CrossTabData.

In the online help, select crosstab under the 'Index' tab. Select the Crosstab.property DataWindow Object property. It should be noted on that window that there is also a Table.CrosstabData property. Or provide a link under the 'See Also' commandbutton.

a browser and the datawindow is using the bold font, column data is getting

truncated.

The nv_remote_datawindow/generate calls the datawindow.data.html

to add a second retrieval argument the follow error appears:

Column 2 has an invalid name and/or length

If a existing dw has two arguments and you try to retrieve, the window 'Specify Retrieval Arguments' don't show the second argument. It just shows a blank.

Be able to use expressions for the editmask mask property

so that different masks can be used for different rows.

But when calling SelectRow some of the columns become hidden as if the column no longer is transparent.

Customer has set the above in the [Microsoft SQL Server] section of hispbodb115.ini file. We have checked to make sure it is set in the copy in the following directory(actually he has set it in every copy of pbodb115.ini on his machine)

C:\Documents and Settings\psteinha\Local Settings\Application Data\Sybase\PowerBuilder 11.5

His datawindow has six nested reports and we have not been able to reproduce the time difference in a small report.

I did a small analysis of the first 15 fetchs in each of the logs and the total times are as follows:

SQLNCLI10 = 354.943 ms

# 1 = 189.700 ms

# 15 = 354.943 ms

SQLOLEDB = 149.538 ms

#1 = 210.285 ms

# 15 = 359.823 ms

SQLODBC = 108.953 ms

# 1 = 284.037 ms

#15 = 392.990 ms

To get elapsed time I subtracted #1 from #15. While the SQLOLEDB takes longer than ODBC, SQLNCLI10 takes more than three times as long as ODBC. Customer insists that these results can be replicated over and over.

then sometimes the tooltip of a column may still appear while it is disabled according to the expression.

The final step is to set the header band to Autosize height, to move it up tight under the column header text. But this fails and all pages have the same header height. Pages after 1 have a large blank space that the header should move up into.

A second problem with this is once the header band is set to autosize and the datawindow is closed, PB crashes when you attempt to re-open the datawindow in the painter.

When there are no IIOP connections available, then a PB ORB connection should block until a listener thread becomes available.

But the PB ORB stays blocked until a timeout occurs.

Invalid Pointer Read on msvcr71?wcscpy8

In the orcascript log file, it appears it is on the cm_rebuild_application(CM_REBUILD_FULL).

public CONSTANT string is_exposemeconstantly='exposeme!'

Customer was trying to upgrade to latest EBF to see if webservices bug fix would help his performance problems.

together and an object fails to regenerate due to an error

then status "Succeeded" can be reported instead of the number of errors.

New command line switch -ex <filename> where the filename contains error numbers allows those error numbers to not be counted as errors.

Specification for CR 624977

1. Document History and Approvals

1.1 Document Change History

Date Version Changes Author

5/4/2010

0.1 Initial Version Eric Nilson

Add a new row to this table for each new version.

1.2 Milestones and Approvals

Milestone Who and Date for each

Solution Approval

Design Approval

Code Review and Approval

Test Plan and Unit Test Approval

Check-In Approval

2. CR Description

2.1. Product - ECRTP

2.2. Customer抯 Problem Description

REQUEST:

Customer is requesting the ability to not generate an error when the data in an element is either larger or smaller than the min/max values for the element.

This relates to CMS processing, as length violations are not considered rejected transactions, but rather, Accepted with Errors.

The preferred result of this RFE would be a runtime flag to turn this error reporting off.

3. Engineer抯 Restatement of Customer抯 Problem

Customer wants to specify to not count error of less than min element length or greater than max element length. It is OK to not write any error messages to trace or LOG and to return a value of zero indicating no errors to calling program. The transaction will be placed in the good file if good bad processing is being done. But if a field is mandatory and empty, then this will still be counted as an error. If field is empty and not mandatory, it will not be counted as an error. The mandatory error number is different so this will be done as long as the mandatory error is not in the exception file.

Customer needs this special processing for inbound only. Engineer抯 Solution Description

4. Customer Impacts, If Any

To do special error checking like this will cause a small performance hit.

5. Design

This feature is for inbound maps and inbound EDI->EDI or XML-EDI,. It has not been implemented for OUTBOUND, but will work with every type of INBOUND including X12, EDIFACT, NCPDP, HL7 and XML.

The customer抯 request will be satisfied by a generic approach that can be used to allow customers to pick minor types of ECRTP Error Numbers of errors that they want to be passed through the system without counting as an error.

For the first implementation of this feature, the types of errors that are going to be passed through are the types of non-fatal errors that occur during mapping or rule processing.

If the user places a Fatal Error number that causes ECRTP to abort and return a error code of 5, ECRTP will still abort and return an error code of 5, but the Error will not be written to TRLOG and will only be written to the TRACE file.

A compliance map has a rule that states if Error, abort transaction, which means that if any error occurred during the processing of that transaction then the processing is aborted. The types of non-fatal errors that would hit this rule and cause an abort transaction in a compliance map will be able to be dismissed as not an error and not to cause an abort transaction. Also for a translation map, the mapping and rule edit type of errors can be changed to not count as an error.

For this first release of this feature, such ECRTP errors involving incorrect Header segments (ISA, GS, ST) and Trailer segments (SE, GE, IEA) will be able to be dismissed as not errors and not written to TRLOG. But the ECRTP processing and return error code status will be the same as if the error was written to TRLOG and counted as an error.. And the same is true for Trade Partner errors and tal errors such as cannot open file.

The discounting of the errors in the 杄x <filename> during mapping and rule processing will be done by setting a variable to 1 at start of mapping or rule processing and turning it back to a zero at end of mapping or rule processing.

There are other more serious errors, where ECRTP will abort the transaction or the whole map run immediately after such a serious error occurs. These types of abort transactions will not be stopped by this CR. However, if one of these errors

A new command switch, -ex <file name>, will be used to indicate that there is a file name that contains ECRTP Error numbers that are to be ignored. The file must consist of one 5 digit numeric error number on each line terminated by a new line. If this file cannot be opened, ECRTP will abort. If file line does not follow format of 5 digits new line, ECRTP will abort.

The 杄x <file name> switch is required, but the file name does not have to exist on the disk if it was passed in as a MEMIOSTRUCT parameter.

typedef struct {

char *filename;

char **paddr;

long *pbytes;

long *pbuflen;

} MEMIOSTRUCT;

When an Error occurs with an error number that matches an error number in the error exception file name, then the Error will be written to the TRACE File but not the LOG File.

For example, if 1294 was in the exceptin file, theninstead of a trace message

"(1294) ERROR: Maximum Length %d of EDI record exceeded"

There will be a message

" (DISM ) ERROR: Maximum Length %d of EDI record exceeded"

The �(DISM )� in the Trace File indicates that this error occurred but was dismissed (not counted as an error and not written to the LOG.

At the end of a run, the message Number of Errors Dismmissed: NNN

Will be added to the end of run summary if any errors have been dismissed.

If only errors that were in the 杄x <filename> occurred during a run, then a value of 0 would be returned by ECRTP to indicate to the calling program that there were no errors. And EDI Transaction with no errors or only exception type of errors in the 杄x <filename> will be passed through as good transactions.

6. Summary of Technical Changes

Functions � Which and Why

Globals & Structures � Which and Why

Error Message Changes

The major changes were in the below files.

STR.H

long dism_err_cnt_in; /* Number of inbound errors not counted as errors due to -ex filename switch */

long dism_err_cnt_out; /* Number of edi->edi outbound errors not counted as errors due to -ex switch */

int itot_exceptions; /* size of array of exception error integer nuumbers pointed to by piexception_errs pointer */

int * piexception_errs; /* pointer to array of error integer nuumbers which should not count as errors */

INITMAP.CPP

modified pr_args to process -ex filename and call new function load_exceptions()

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

INITMAP.CPP

new function load_exceptions

/*-------------------------------------------------------------------------

* load_exceptions - load ECRTP error numbers from a file that has 5 digits

* followed by a newline

*-------------------------------------------------------------------------*/

errmod.cpp

modified pr_err() logic to not count error numbers that were loaded into memory from the

exception file.

new functions

check_dismissed(char *msgnum,GLOBALSTRUTIN) /* checks to see if error number is in CVPTRIN piexception_errs */

long stat_dism_err_cnt(int delta, GLOBALSTRUTIN) /* adds count of dismised errs */

mstrseg.cpp

new function ifinal_dism_msg.c - display final run dismissed error status

7. Test Plan

Create a data file that contains edit errors and an error file with these edit error numbers and see if output is correct.

Run same data file without the new 杄x <filename> and see if errors are reported.

This was done using an from the DOS prompt with an old hippa EDI->EDI map with and without the -ex filename switch. And it worked as planned.

wrmi32 C:\maps\hipaareg\errors.EDI -st "DSN=hipaareg" -sl "DSN=hipaareg" -o -k -z -l -dg C:\maps\hipaareg\837P -ex exfile.txt -tc 1000 -wx 1 -k -id 56

To test memory passing of the exception fi.le, on can load the exception file into a MSGVAR. Then use the MEMI Gateway Tab to set MSGVAR equal to the exact full or relative file name that will be used with the ex <filename> switch. I added the -ex <filename> switch to the pfs script.

Below is a pfs file that I ran with same exfile.txt and map that I had used when testing wrmi32.exe from the DOS prompt. I was able to verify with the debugger that the exfile.txt was being read from the memory MSGVAR file that Gateway has passed in.

hipaa_errors

5.2.1, 05/18/10 08:52:34 PM

DSN=ORACLE10Driver;UID=SCOTT;PWD=wS+5der

DSN=ORACLE10Driver;UID=SCOTT;PWD=wS+5der

DSN=ECEDIGS

C:\ecedigs51\blat.exe

C:\ecedigs51\pfsFax.exe

4

1 1TraceOnOff 34 ||220

2 2LoadMemory 52 ||140||C:\maps\hipaareg\errors.edi||60||

3 3LoadMemory 52 ||140||c:\maps\hipaareg\837p\exfile.txt||63||

4 4RunMapIn 27 ||||-fn c:\maps\hipaareg\errors.edi -sl 12"DSN=hipaareg" -nz -dg c:\maps\hipaareg\837P -o -k -z -l -tc 1000 -ex c:\maps\hipaareg\837p\exfile.txt -wx 1 ||st||140||12"DSN=hipaareg"||sm||140||c:\maps\hipaareg\837p\exfile.txt||63||

And below is a trace file from the wsproces run of the pfs script.

WSPROCES PC GATEWAY Version 5.2.1.0. - STARTED AT 21:46:04 ON 05/18/2010

- Processing script file: hipaa_errors.pfs

INIT Successfully loaded Safepwd library

INIT Successfully decrypted Trading Partner DSN

INIT Successfully decrypted Log DSN

INIT Successfully decrypted RunID DSN

INIT Successfully Loaded the RTP Library

Trace COMMAND: TraceOnOff ****** Line Number 1

ACTION: ON

Trace COMMAND: LoadMemory ****** Line Number 2

ACTION: Obtained filename C:\maps\hipaareg\errors.edi supplied as string constant!

ACTION: Size of file C:\maps\hipaareg\errors.edi: 1898

ACTION: Successfully read file C:\maps\hipaareg\errors.edi and stored buffer cbd018 in proces

s var. Message[1]

Trace COMMAND: LoadMemory ****** Line Number 3

ACTION: Obtained filename c:\maps\hipaareg\837p\exfile.txt supplied as string constant!

ACTION: Size of file c:\maps\hipaareg\837p\exfile.txt: 6

ACTION: Successfully read file c:\maps\hipaareg\837p\exfile.txt and stored buffer cb48a8 in p

rocess var. Message[4]

Trace COMMAND: RunMapIn ****** Line Number 4

ACTION: Successfully decrypted PassWord for -ST

ACTION: Creating MEMIO <3GetMSG>!

ACTION: ELEMENT FILENAME (cbd7c0): file name ptr contains cbd7d0

ACTION: ELEMENT FN (cbd7d0) contains = c:\maps\hipaareg\837p\exfile.txt

ACTION: ELEMENT PADDR (cbd7c4): data buffer ptr contains cbd8fc

ACTION: ELEMENT MEMADDR (cbd8fc) : data buffer addr. = cb48a8

ACTION: ELEMENT PBYTES (cbd7c8): data size ptr contain cbd900

ACTION: DATASIZE (cbd900) : data size = 6

ACTION: ELEMENT PBUFLEN (cbd7cc): Buffer size ptr contains cbd904

ACTION: SHARED MEMORY 3GetMSG now ready for RTP or Message Queueing operations

ACTION: ASSIGNED THIS SHARED MEMORY ID OF 2701

ACTION: Successfully decrypted PassWord for -SL

ACTION: INRun Parameters = c:\maps\hipaareg\errors.edi -sl "DSN=hipaareg" -nz -dg c:\maps\hip

aareg\837P -o -k -z -l -tc 1000 -ex c:\maps\hipaareg\837p\exfile.txt -wx 1 -st "DSN=hip

aareg" -et "u:\calm_beth_ecgateway\WSPROCES\exe\Debug\TRACE" -id 2701 (address passed to

rtp) 1015ee0

TRACE: Run Time Version: 5.2.1.4

INBOUND Run 20100518 214705 Run ID 2701

TRACE 1 Error Numbers in -ex exception file c:\maps\hipaareg\837p\exfile.txt

TRACE: Reading ISA - Seg Delim 126 Elem Delim 042 Sub Delim 058 Test Ind P

TRACE Opened:TP, AC=OFF

TRACE Maximum Connections:64, Maximum Statements:0

TRACE DBMS Name :ACCESS, Version:04.00.0000

TRACE Cursor Commit Behavior = READ_ONLY

TRACE: New tradepartner: 1075-1

TRACE: Looking.. Segment GS (control)

TRACE: Exact Tradstat found for Tptnr 1075-1 Trans 837 Vers 004010X098A1 TstInd P

---LEVSEG TABLE---

[ 0]: Level: 30, Ordinal= 1, Seg ST , Max Loops= No Limit

[ 1]: Level: 40, Ordinal= 1, Seg ST , Max Loops= No Limit

[ 2]: Level: 50, Ordinal= 4, Seg NM1, Max Loops= 1

[ 3]: Level: 60, Ordinal= 6, Seg NM1, Max Loops= 1

[ 4]: Level: 70, Ordinal= 7, Seg HL , Max Loops= No Limit

[ 5]: Level: 80, Ordinal= 10, Seg NM1, Max Loops= 1

[ 6]: Level: 85, Ordinal= 13, Seg REF, Max Loops= 8

[ 7]: Level: 90, Ordinal= 14, Seg REF, Max Loops= 8

[ 8]: Level: 100, Ordinal= 15, Seg REF, Max Loops= 8

[ 9]: Level: 110, Ordinal= 17, Seg NM1, Max Loops= 1

[10]: Level: 120, Ordinal= 21, Seg HL , Max Loops= No Limit

[11]: Level: 130, Ordinal= 24, Seg NM1, Max Loops= 1

[12]: Level: 140, Ordinal= 28, Seg REF, Max Loops= 4

[13]: Level: 150, Ordinal= 29, Seg REF, Max Loops= 1

[14]: Level: 160, Ordinal= 30, Seg NM1, Max Loops= 1

[15]: Level: 170, Ordinal= 34, Seg NM1, Max Loops= 1

[16]: Level: 180, Ordinal= 37, Seg NM1, Max Loops= 1

[17]: Level: 190, Ordinal= 39, Seg HL , Max Loops= No Limit

[18]: Level: 200, Ordinal= 41, Seg NM1, Max Loops= 1

[19]: Level: 210, Ordinal= 45, Seg REF, Max Loops= 5

[20]: Level: 220, Ordinal= 46, Seg REF, Max Loops= 1

[21]: Level: 230, Ordinal= 47, Seg CLM, Max Loops= 100

[22]: Level: 232, Ordinal= 91, Seg HI , Max Loops= 0

[23]: Level: 250, Ordinal= 48, Seg DTP, Max Loops= 1

[24]: Level: 270, Ordinal= 49, Seg DTP, Max Loops= 1

[25]: Level: 280, Ordinal= 50, Seg DTP, Max Loops= 1

[26]: Level: 290, Ordinal= 51, Seg DTP, Max Loops= 5

[27]: Level: 300, Ordinal= 52, Seg DTP, Max Loops= 10

[28]: Level: 310, Ordinal= 53, Seg DTP, Max Loops= 10

[29]: Level: 320, Ordinal= 54, Seg DTP, Max Loops= 1

[30]: Level: 330, Ordinal= 55, Seg DTP, Max Loops= 1

[31]: Level: 350, Ordinal= 56, Seg DTP, Max Loops= 1

[32]: Level: 360, Ordinal= 57, Seg DTP, Max Loops= 5

[33]: Level: 370, Ordinal= 58, Seg DTP, Max Loops= 5

[34]: Level: 380, Ordinal= 59, Seg DTP, Max Loops= 1

[35]: Level: 390, Ordinal= 60, Seg DTP, Max Loops= 1

[36]: Level: 400, Ordinal= 61, Seg DTP, Max Loops= 1

[37]: Level: 410, Ordinal= 62, Seg DTP, Max Loops= 1

[38]: Level: 420, Ordinal= 63, Seg DTP, Max Loops= 2

[39]: Level: 440, Ordinal= 66, Seg AMT, Max Loops= 1

[40]: Level: 450, Ordinal= 67, Seg AMT, Max Loops= 1

[41]: Level: 460, Ordinal= 68, Seg AMT, Max Loops= 1

[42]: Level: 470, Ordinal= 69, Seg REF, Max Loops= 1

[43]: Level: 480, Ordinal= 70, Seg REF, Max Loops= 1

[44]: Level: 490, Ordinal= 71, Seg REF, Max Loops= 1

[45]: Level: 500, Ordinal= 72, Seg REF, Max Loops= 2

[46]: Level: 520, Ordinal= 73, Seg REF, Max Loops= 1

[47]: Level: 530, Ordinal= 74, Seg REF, Max Loops= 3

[48]: Level: 540, Ordinal= 75, Seg REF, Max Loops= 1

[49]: Level: 550, Ordinal= 76, Seg REF, Max Loops= 1

[50]: Level: 560, Ordinal= 77, Seg REF, Max Loops= 1

[51]: Level: 570, Ordinal= 78, Seg REF, Max Loops= 1

[52]: Level: 580, Ordinal= 79, Seg REF, Max Loops= 4

[53]: Level: 590, Ordinal= 80, Seg REF, Max Loops= 1

[54]: Level: 600, Ordinal= 81, Seg REF, Max Loops= 1

[55]: Level: 610, Ordinal= 86, Seg CRC, Max Loops= 3

[56]: Level: 620, Ordinal= 87, Seg CRC, Max Loops= 3

[57]: Level: 630, Ordinal= 88, Seg CRC, Max Loops= 1

[58]: Level: 650, Ordinal= 89, Seg CRC, Max Loops= 1

[59]: Level: 660, Ordinal= 93, Seg CR7, Max Loops= 6

[60]: Level: 670, Ordinal= 95, Seg NM1, Max Loops= 3

[61]: Level: 690, Ordinal= 98, Seg NM1, Max Loops= 1

[62]: Level: 700, Ordinal= 101, Seg NM1, Max Loops= 1

[63]: Level: 710, Ordinal= 103, Seg NM1, Max Loops= 1

[64]: Level: 750, Ordinal= 107, Seg NM1, Max Loops= 1

[65]: Level: 760, Ordinal= 109, Seg SBR, Max Loops= 10

[66]: Level: 770, Ordinal= 111, Seg AMT, Max Loops= 1

[67]: Level: 780, Ordinal= 112, Seg AMT, Max Loops= 1

[68]: Level: 790, Ordinal= 113, Seg AMT, Max Loops= 1

[69]: Level: 800, Ordinal= 114, Seg AMT, Max Loops= 1

[70]: Level: 810, Ordinal= 115, Seg AMT, Max Loops= 1

[71]: Level: 820, Ordinal= 116, Seg AMT, Max Loops= 1

[72]: Level: 830, Ordinal= 117, Seg AMT, Max Loops= 1

[73]: Level: 840, Ordinal= 118, Seg AMT, Max Loops= 1

[74]: Level: 850, Ordinal= 119, Seg AMT, Max Loops= 1

[75]: Level: 860, Ordinal= 120, Seg AMT, Max Loops= 1

[76]: Level: 870, Ordinal= 124, Seg NM1, Max Loops= 1

[77]: Level: 880, Ordinal= 128, Seg NM1, Max Loops= 1

[78]: Level: 890, Ordinal= 131, Seg REF, Max Loops= 2

[79]: Level: 900, Ordinal= 132, Seg REF, Max Loops= 2

[80]: Level: 910, Ordinal= 133, Seg REF, Max Loops= 2

[81]: Level: 920, Ordinal= 134, Seg NM1, Max Loops= 1

[82]: Level: 930, Ordinal= 136, Seg NM1, Max Loops= 2

[83]: Level: 950, Ordinal= 138, Seg NM1, Max Loops= 1

[84]: Level: 960, Ordinal= 140, Seg NM1, Max Loops= 1

[85]: Level: 970, Ordinal= 142, Seg NM1, Max Loops= 1

[86]: Level: 1010, Ordinal= 144, Seg NM1, Max Loops= 1

[87]: Level: 1020, Ordinal= 146, Seg LX , Max Loops= 50

[88]: Level: 1030, Ordinal= 154, Seg CRC, Max Loops= 3

[89]: Level: 1040, Ordinal= 155, Seg CRC, Max Loops= 1

[90]: Level: 1050, Ordinal= 156, Seg CRC, Max Loops= 2

[91]: Level: 1060, Ordinal= 163, Seg DTP, Max Loops= 0

[92]: Level: 1070, Ordinal= 157, Seg DTP, Max Loops= 1

[93]: Level: 1080, Ordinal= 158, Seg DTP, Max Loops= 1

[94]: Level: 1100, Ordinal= 159, Seg DTP, Max Loops= 1

[95]: Level: 1110, Ordinal= 160, Seg DTP, Max Loops= 1

[96]: Level: 1130, Ordinal= 161, Seg DTP, Max Loops= 2

[97]: Level: 1140, Ordinal= 162, Seg DTP, Max Loops= 2

[98]: Level: 1160, Ordinal= 163, Seg DTP, Max Loops= 3

[99]: Level: 1190, Ordinal= 164, Seg DTP, Max Loops= 1

[100]: Level: 1200, Ordinal= 165, Seg DTP, Max Loops= 1

[101]: Level: 1210, Ordinal= 166, Seg DTP, Max Loops= 1

[102]: Level: 1220, Ordinal= 167, Seg DTP, Max Loops= 1

[103]: Level: 1230, Ordinal= 168, Seg DTP, Max Loops= 1

[104]: Level: 1240, Ordinal= 169, Seg DTP, Max Loops= 1

[105]: Level: 1250, Ordinal= 172, Seg REF, Max Loops= 1

[106]: Level: 1260, Ordinal= 173, Seg REF, Max Loops= 1

[107]: Level: 1270, Ordinal= 174, Seg REF, Max Loops= 2

[108]: Level: 1290, Ordinal= 175, Seg REF, Max Loops= 1

[109]: Level: 1300, Ordinal= 176, Seg REF, Max Loops= 1

[110]: Level: 1310, Ordinal= 177, Seg REF, Max Loops= 1

[111]: Level: 1320, Ordinal= 178, Seg REF, Max Loops= 1

[112]: Level: 1330, Ordinal= 179, Seg REF, Max Loops= 1

[113]: Level: 1340, Ordinal= 180, Seg REF, Max Loops= 4

[114]: Level: 1350, Ordinal= 181, Seg REF, Max Loops= 1

[115]: Level: 1360, Ordinal= 182, Seg REF, Max Loops= 1

[116]: Level: 1380, Ordinal= 183, Seg AMT, Max Loops= 1

[117]: Level: 1390, Ordinal= 184, Seg AMT, Max Loops= 1

[118]: Level: 1400, Ordinal= 185, Seg AMT, Max Loops= 1

[119]: Level: 1405, Ordinal= 191, Seg LIN, Max Loops= 25

[120]: Level: 1410, Ordinal= 194, Seg NM1, Max Loops= 1

[121]: Level: 1420, Ordinal= 197, Seg NM1, Max Loops= 1

[122]: Level: 1430, Ordinal= 199, Seg NM1, Max Loops= 1

[123]: Level: 1470, Ordinal= 203, Seg NM1, Max Loops= 1

[124]: Level: 1480, Ordinal= 205, Seg NM1, Max Loops= 1

[125]: Level: 1490, Ordinal= 210, Seg NM1, Max Loops= 2

[126]: Level: 1510, Ordinal= 213, Seg NM1, Max Loops= 4

[127]: Level: 1520, Ordinal= 215, Seg SVD, Max Loops= 25

[128]: Level: 1530, Ordinal= 218, Seg LQ , Max Loops= 5

TRACE Start Run of MAP HIPAA_837P_4010_50

TRACE: Level 10, Segment ISA (control)

TRACE: Level 10->20, processing Segment ISA Before Rule- No: 10380

TRACE: Level 10->20, processing Segment ISA After Rule- No: 10080

TRACE: Level 20, Segment GS (control)

TRACE: Level 20->30, processing Segment GS Before Rule- No: 10435

TRACE: Level 20->30, processing Segment GS After Rule- No: 10060

TRACE: Level 30, Segment ST (control)

TRACE: Level 30->40, processing Segment ST Before Rule- No: 0

TRACE: Level 40, Segment ST (mapping)

TRACE: Level 40, Segment ST 01 (mapping)

TRACE: Level 40, Segment ST 02 (mapping)

TRACE: Level 30->40, processing Segment ST After Rule- No: 1140

TRACE: Performing Rule 5030

TRACE: Performing Rule 13160

TRACE: Level 40, Segment BHT (mapping)

TRACE: Level 40, Segment BHT01 (mapping)

TRACE: Level 40, Segment BHT02 (mapping)

TRACE: Level 40, Segment BHT03 (mapping)

TRACE: Level 40, Segment BHT04 (mapping)

TRACE: Level 40, Segment BHT05 (mapping)

TRACE: Level 40, Segment BHT06 (mapping)

TRACE: Level 40->40, processing Segment REF Before Rule- No: 815

TRACE: Level 40, Segment REF (mapping)

TRACE: Level 40, Segment REF01 (mapping)

TRACE: Level 40, Segment REF02 (mapping)