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

If Local Root Folder is set to root folder (d when workspace is created in d:\temp) then SCC connects in offline mode
It is probably because when you click the browse button and choose d drive then the folder inserted for local root is "d" not
"d:"

If workspace and local root are in the folder where PB 8 is installed and the target and archives are on the network (or differend Drive) then when you try to add an object to source control the object is successfully added but the pbg file does not get updated with the new addition

This is only a problem with the PBVM on solaris. Running the same reproduction with a Windows 2000 Jaguar server works.

get loaded fine in the plugin This is NOT a PB bug (Q303401 - Netscape-Style Plug-ins Do Not Work After Upgrading Internet Explorer )
Migration document :
Migration from Netscape DataWindow Plug-ins - http://my.sybase.com/detail?id=1014270

Reviewed by PB Engineering and determined to be "Not a PB Bug". The customer was given a workaround.

04/25/2005:

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

A PowerBuilder component, calling an Oracle Stored Procedure, deployed to EAServer, will exhibit different behaviour when it accesses an EAServer Connnection Cache using the CacheName DBParm as opposed to when it does not.

For ODBC connection, the dbparm PBUseProcOwner was introduced around Powerbuilder 6 ;
Customers can connect using ODBC to Oracle then utilise this dbparm to set the use
of userid/ owner name or to ignore OWNER of the stored procedure;

04/25/2005:

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

If removing the expressions this crash goes away.

Per Engineering, this will not be fixed:
Obsolete functionality. We will remove InsertBlock DBParm for PB 9.0

This is because currently if pb needs to describe a stored procedure result set, pb will execute the stored procedure(for example ODBC, OLEDB, MSS and SYC interface) and then get the result set description.
However pb will not fetch any data from the result set(just for description) .

PSE Update:
Fixed in PB 7.0.3 EBF Builds 10146 or greater.

to crash.

This may be a bug or may be a limitation. I believe there may be embedded NULL characters in the blob data. If you convert the blob to a string the length of the string is much shorter than the length of the blob.

Per development: PowerBuilder does not currently support Blob arguments to stored procedures. The argument is handled internally as a string, so if NULL characters are included, data might be lost. Customers should use the PowerBuilder Blob functions: SelectBlob, UpdateBlob.

SystemException: TRANSACTION_ROLLEDBACK

Work-around is to make the structure the last argument in the call.

When modifying the select statement of a datawindow, that has a sub-select and a table owner prefix,
a mysterious Datawindow Error message box can appear, when going back to design.
The changes made to the select statement are not saved.

Workaround is to make the changes in the datawindow export.

Per Development:
PB provides O73 and O84 interface for Oracle7 and Oracle8 server, sometimes they are incompatible. In the case for pbo84 interface, pb needs to check column ''DATA_TYPE_OWNER'' from table ''SYS.ALL_TAB_COLUMNS'' that the column doesn't exist in the same table of Oracle7. If you use pb o73 interface the problem doesn't occur as pb o73 doesn't check the column. So you should use pb o73 interface if you want to connect to Oracle7 server even if you use Oracle 8 client.

This is probably a duplicate of CR 239579.

string ls_myParm[] = as_myParm[]

Workaround: Declare the local string array on one line and assignment on the next line:
string ls_myParm[]
ls_myPartm[] = as_myParm[]

Per development:
This is not a PowerBuidler bug. ODBC driver doesn't support the array parmeter in a stored procedure. ODBC is implemented by Microsoft for general DBMS. The array parameter contained in a procedure only occurs in Oracle database so it is not unexpected that ODBC driver doesn't support it.

10/24/2001
Change CR type to Enhancement Request.

Customer only wanted the ability to prohibit the WebDW Generator from generating embedded stylesheets for the datawindow so that they could add their own stylesheet without it being overridden by the Generator. They thought that the GenerateCSS property of the WebDW would do this since the property eludes to this and is not documented that it is deprecated at runtime if the browser property is set.

Because, the GenerateCSS is deprecated at runtime due to the precedence of the HTMLGen.Browser and this is completely undocumented, I am still requesting this to be considered as an Enhancement Request but with the priority changed to 3.

The GenerateCSS property should actually suppress the embedded style sheet generation whether the browser is set or not. This would be a useful feature for customers that want to add their own stylesheets and still want to set the browser to include other features that the browser supports.

Workaround:
Force Browser Mozilla version string to< 3 (ie., get generation intended for an older browser for which stylesheets aren't supported), stylesheets will then not be generated for the WebDW. The customer will then be able to insert their own stylesheets to work with the WebDW. Customers may also be ensured that all intended behaviour/functionality for the WebDW still gets generated, it's just the stylesheets that don't.

This feature has already been implemented for other object painters e.g. 'window', 'datawindow' object when the same steps are repeated.

E.g. project object
Would like to see "Project - D:\dev\accounts.pbl - p_deploy1" instead of current behaviour "Project - p_deploy1".

PER DEVELOPMENT:
This is a limit to OLEDB driver. OLEDB adopts RPC mode to call Stored Procedure. For example in your case, OLEDB will execute "call ole_test(?,?) " for the syntax "EXEC ole_test @var3 = 2, @var4 = 4" and then bind parameter value. The problem in your case is about default parameter. By PB MSS native driver similar to MS Query Analyzer, SQL SERVER knows that @var1 and @var2 will use default value after sending the command. But for PRC mode used by OLEDB, how can we use default parameter when you call a function? The answer is the default parameter must be at the end. So if you want to use default parameter value, just like designing a function, put them at the end. The workaround is updating the Stored Procedure like this:
ALTER PROC ole_test (@var3 int, @var4 int,@var1 int = NULL OUTPUT,
@var2 int = NULL OUTPUT)
AS
SELECT @var1 = @var3 + @var4
SELECT @var2 = @var3 - @var4
SELECT @var1, @var2
GO

Another way to solve the problem is pb will add the parameter automatically if a default paramerer is not provided the value, that need pb to check SP script to get the default value in database, that will complicate pb oledb driver, and I don't think user will care moving default parmeter to the end if they want to use the default value.

PB Version and Build: PB 8.0 GA -> 7061

PB 7.0.3 from build 10069

Comments:

The debugger does not correctly show the value for dwItemStatus variable returned by GetItemStatus.

The value is correctly interpreted by vm at runtime however if viewed in debugger in local/instance variable tab an incorrect (unchanged) value is shown .

Additionally there is no PB 8.0 version of this dll and I could not find anything in the registry to replace this. Is this functionality no longer available in PB 8.0??

Please correct the on-line help for both 8.0 and 7.0.3

"DataWindow memory management issues
-----------------------------------
Large retrievals or imports into a DataWindow object no longer report
a premature out of memory error if you reset the default page size
for DataWindow storage to large before retrieving data. For example:

dw_1.Modify("datawindow.storagepagesize='LARGE'")
or
dw_1.object.datawindow.storagepagesize='large'

Both large and LARGE can be used with either syntax. Setting this
property allows the DataWindow to most efficiently use the available
virtual memory. While the setting LARGE is recommended, a setting of
MEDIUM is also available.

This solution also applies to out of memory errors on large Retrieve or
RowsCopy operations, especially moving from PowerBuilder 5.0 to 6.5 or
7.0. If your application had this migration problem, you should try migrating
again. [CR 211553, CR 223030] "

[Edit Mask Behaviors]

AutocompleteDates=no

This may turn out to be a browser variation and may not be a bug.

Is this a PB/Jaguar problem or a limitation of using Netscape?

Under the heading Modifying the result set ( when the data source is External or Stored Procedure) it currently states to use Design > Data Source. This option is grayed out and what one really needs to do it to click View > Column Specifications. The remainder of the topic is correct.

Should all PB controls work with this third party product?

Not a PB Bug.
Using the Oracle 8.1.5 client software on the EA Server AIX server and making 2 minor coding changes (see details below) resolved the concurrent user problem.

1) In the 'deactivate' event of the PB component made sure that 'DISCONNECT' is called on the transaction object before it is destroyed.
2) Turned on the 'sanity check' for the cache.

Comments: User event mapped to pbm_erasebkgnd is never fired if the object is a window whereas it does fire for other controls eg commandbutton. This event should either fire or not be included in the list of Window events in the dropdown when defining a user event

Not a bug:

In the given test case, when the user clicks on the tree control , the Clicked event occurs, which in turn triggers the Getfocus event, thus setting the focus on to the tree control again, and letting the window open in the background. This is the reason for the window not getting the focus, when clicked from a tree control

If you set the focus of the new window in the Getfocus event of the tree control it's working.

If a comma is used as decimal separator (in Windows control panel -> regional settings) it is not possible to change the print margin settings correctly using right mouse button context menu in RTE dw or control. Only the value in front of the comma is saved. eg set right margin to 2,7 but only 2,0 is saved

set and no initial value

04/25/2005:

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

When hitting print to print a report in PB, type a range of pages to be printed in the pages text box. Notice that the "ALL" radio button stays on and you have to check the pages radio button. Would like this pages radio button to be automaticly get checked when you enter in a page range. This does happen in MS Word and Excel and also in Word Perfect.

The option to create a new primary key and foreign key is always greyed out in PowerBuilder 8.x and 7.x.

04/25/2005:

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

Error message "There must be an open workspace with PowerBuilder Targets to complete this operation"

Problem occurs intermittently.

04/25/2005:

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

Several of the DBCS functions that aren't documented in printed documentation or the on-line help
files are below:

FillC
FillW
LeftC
LeftW
MatchW
MidW
PosW
ReplaceW
RightW
RightC
RightTrimW
TrimW

Customers are running into problems because of this deficiency, using the
standard functions for DBCS activities.

The customer sent in a test case where the jpg file is 63kb. Used a smaller
jpg file of 7 kb and it worked.

This worked in PB 5.

This does however seem to work when an object which is much smaller. If you create a window with an embeded OLE control with nothing else it does work, but does not seem to work with the CTs window.
We are however able to export the object within PB.

If you open an already existing workspace or create a new workspace on a network drive using Universal Naming Convention (UNC) then the workspace is opened or created in Read Only mode.
If you right click the workspace in PB go to properties you will Read Only displayed in the Title Bar, as a result of which Source Control is disabled, so one cannot use Source Control
In Windows explorer, map to the network drive browse to the workspace, right click on workspace and go properties, you will notice the Read Only checkbox is not checked.

Dupe of CR 239754 (see that CR for status updates).

PB crashes if a computed column w/ sort order based on it is removed from the datawindow

The problem does not occur if the datatype is datetime instead of smalldatetime.

Per Engineering:

================

This is not a problem of memory leakage. Smartheap is not returning all deleted memory to OS.

IN PB 7 we use SmartHeap version 5

IN PB 8 we use SmartHeap version 6

IN PB 8.02 we use SmartHeap version 6.02

The latest version 6.02 works best so far, and the results cannot get better with our current architecture that we use to allocate memory.

Then with Acrobat 4, we get:
C:\temp\test.pdf (=5 K)
C:\temp\test.pdf > 0 K (which is expected)

With Acrobat 5, we get:
C:\temp\test.pdf (=0 K)
D:\MyPbls\test.pdf > 5 K
The actual pdf file is placed in the directory where the pbl is located

This works okay when using PrintDatawindow(job,dw_1)

Workaround:
chooseing an other function will refresh the script painter.

POSSIBLE WORKAROUND:
For the test case submitted, the workaround was to use the datawindow without the group and use Rows... Suppress Repeating Values on the column used for the group. Since the result set was sorted on that column, this made the datawindow without the group look just like the datawindow with the group. Depending upon the complexity of the datawindow being used, this may not work for all cases.

If 251 characters entered and tilde entered then it does not gpf.

Workaround:
GetItemString() is applying the format to computed fields which is NOT consistent when used on a column. The following is my current workaround. IF Left(as_col_name,2) = "c_" THEN // Computes already have format applied ls_value = ads_datastore.getitemstring(al_row, as_col_name) ELSE // Format must be applied to columns ls_value = String( ads_datastore.getitemstring(al_row, as_col_name), ls_format) END IF

Have PB remember what was last used and put that in the dropdowns
as the default.

We understand that this is the purpose of regional settings but in today's world there are times when such things as currency and dates need to be viewed by different people in different formats. One idea is to allow an option of the editmask to override the regional settings but other ways could also work.

The type libraries (tlb files ) that PB includes have some PB objects but not others and there is no documentation available to aid tools vendors in developing tools to use with PB.

Specifically the request is to provide API or documentation on how to access the class fnfixedbar70 (or fnfixedbar80). Many user defined messages (WM_USER) are sent to the toolbar to get and send info to it. That can be seen by applying MS Spy++. Please provide tools vendors with documentation regarding these user defined messages or other access to all PB objects.

Null object reference occurs when you attempt to assign a value to a structure field within a menu script AND that same menu script declares an autoinstantiated NVO FOLLOWING the structure declaration. For example, the following code causes the error:

str_test lstr_test

n_cst_test luo_test

w_main.st_1.text = "Declared structure BEFORE NVO"

lstr_test.name = "test"

If you switch the order of declaration of the structure and NVO, it works fine. Either order works in PB7. Moving the script to a button seems to get rid of the problem as well.

Fix made in cr 258108 turned out to be only partial fix. With a new sample provided
with a larger set of data, their is still a row missing

With an Editmask of type numerical and mask: "#.00000", it is possible that the
decimal point gets overwritten and large values can be entered.

This happens when the cursor is behind the decimal point and delete the first digit,
then move to the front of the mask and type a number.

For instance

# = numbers, belongs to set {0,1,2....9}
! = uppercase, belongs to set {A,B,C...Z}+{0,1,2..9}
^ = lowecase ...

PB exception caught in tryinvoke

Using the IIOP trace resulted in the following log:
getRequest | service context length:
getULong < 00000000 (0) ....
getULong < 00000000 (0) ....
getULong < 00000000 (0) ....
getObjectRef | type_id:
getULong < 1A000000 (26) ....
getString < 49444C3A4E6176696761746F722F6E6176747265
IDL:Navigator/navtre
653A312E3000 e:1.0.
getObjectRef | profiles:
getULong < 000003000000 [2] (3) ......
getULong < 00000000 (0) ....
getULong < 74000000 (116) t...
getByteOrder < 01 ('<' little endian) .
getOctet < 01 (1) .
getOctet < 01 (1) .
getULong < 000C000000 [1] (12) .....
getString < 64757175657474652D706300 duquette-pc.
getUShort < 2C23 (9004) ,#
getProfile | tag = 0 (TAG_INTERNET_IOP)
| IIOP version = 1.1
| host = duquette-pc
| port = 9004
| object key:
getULong < 000044000000 [2] (68) ..D...
getOctets < 4577AA732F25E25DF7981C7966D9FB2D93A22DAE Ew猻/%鈃�..yf冫-.�-�
09B3A1AF4B70B8C23688F61EC3816FF15EA344C4 .场疜p嘎6.�.�.o馸�
5338F7AFAA829F1A947D41669E4BBCCCA603C709 S8鳢�....}Af.K继�.�.
DB7AE6591A348EA7 踷鎅.4.�
getProfile | components:
getULong < 01000000 (1) ....
getULong < B3BABA0A (180009651) 澈�.
getULong < 08000000 (8) ....
getByteOrder < 01 ('<' little endian) .
getULong < 00000000000000 [3] (0) .......
getComponentProfile | tag = 0X0ABABAB3 (TAG_JAG_QOP)
| targetQOP = 0000
getULong < B3BABA0A (180009651) 澈�.
getULong < 08000000 (8) ....
getByteOrder < 01 ('<' little endian) .
getULong < 00000000000000 [3] (0) .......
getProfile | tag = 0X0ABABAB3 (TAG_JAG_QOP)
| targetQOP = 0000
getULong < C0CACA0A (181062336) 朗�.
getULong < 01000000 (1) ....
skipOctets < 01 .
-------------------------------------------------------------------------------
IIOP putMessage Hexadecimal [padding] (interpretation) ISO 8859-1 encoding
--------------- - ---------------------------------------- --------------------
putOctet < 47 (71) G
putOctet < 49 (73) I
putOctet < 4F (79) O
putOctet < 50 (80) P
putOctet < 01 (1) .
putOctet < 01 (1) .
putBoolean < 01 (TRUE) .
putOctet < 00 (0) .
putULong < 00000000 (0) ....
putMessage | GIOP version = 1.1
| flags = 1 ('<' little endian)
| message type = 0 (Request)
putRequest | service context length:
putServiceContextList | service context length:
putULong < 00000000 (0) ....
putRequest | request id:
putULong < 00000000 (0) ....
putRequest | response expected:
putBoolean < 01 (TRUE) .
putRequest | object key:
putULong < 00000044000000 [3] (68) ...D...
putOctets < 4577AA732F25E25DF7981C7966D9FB2D93A22DAE Ew猻/%鈃�..yf冫-.�-�
09B3A1AF4B70B8C23688F61EC3816FF15EA344C4 .场疜p嘎6.�.�.o馸�
5338F7AFAA829F1A947D41669E4BBCCCA603C709 S8鳢�....}Af.K继�.�.
DB7AE6591A348EA7 踷鎅.4.�
putRequest | operation:
putULong < 10000000 (16) ....
putString < 6F665F726574726965766573796E6300
of_retrievesync.
putRequest | requesting principal:
putULong < 00000000 (0) ....
putRequest | request body:
putULong < 42000000 (66) B...
putString < 446174614F626A6563743D645F67726F75706D65
DataObject=d_groupme
6D626572733B417267756D656E74733D312C3336 mbers;
Arguments=1,36
3532363B2C3109526F6F742C310933363532362C 526;,1.Root,1.36526,
3209312C3200 2.1,2.
putULong < 000001000000 [2] (1) ......
putString < 00 .
putULong < 00000000000000 [3] (0) .......
endMessage | message size = 192 (after 12 byte header)
-------------------------------------------------------------------------------
IIOP getMessage Hexadecimal [padding] (interpretation) ISO 8859-1 encoding
--------------- - ---------------------------------------- --------------------
getOctet < 47 (71) G
getOctet < 49 (73) I
getOctet < 4F (79) O
getOctet < 50 (80) P
getOctet < 01 (1) .
getOctet < 01 (1) .
getOctet < 01 (1) .
getOctet < 01 (1) .
getULong < 48000000 (72) H...
getMessage | GIOP version = 1.1
| flags = 1 ('<' little endian)
| message type = 1 (Reply)
| message size = 72 (after 12 byte header)
getRequest | service context length:
getULong < 00000000 (0) ....
getULong < 00000000 (0) ....
getULong < 02000000 (2) ....
getULong < 2D000000 (45) -...
getString < 49444C3A6F6D672E6F72672F434F5242412F5452
IDL:omg.org/CORBA/TR
414E53414354494F4E5F524F4C4C45444241434B ANSACTION_ROLLEDBACK
3A312E3000 :1.0.
getULong < 00000000000000 [3] (0) .......
getULong < 01000000 (1) ....
** exception ** | number = 18, reason = offset + length exceeds message size for incoming data

The following is the srv.log:
Oct 26 10:23:26 2001: Started: CosNaming/NamingContext
Oct 26 10:23:27 2001: Started: JaguarServlet/ServletService
Oct 26 10:23:27 2001: Set 'thread.safe=false' for component 'Services/cachemanagertimer' since 'sharing=true' and component type is PB
Oct 26 10:23:27 2001: Library: 'pbjag70.dll' for component type 'pb70'
Oct 26 10:23:27 2001: PB_Component::create: created PB_Object for n_cachemanagertimer
Oct 26 10:23:27 2001: CPB_Object::Initialize: Session created.
Oct 26 10:23:27 2001: CPB_Object::Initialize: CreateInstance succeeded for n_cachemanagertimer
Oct 26 10:23:27 2001: CPB_Object::invoke: method invocation for start
Oct 26 10:23:27 2001: CacheManagerTimer Service Started.
Oct 26 10:23:27 2001: CPB_Object::invoke succeeded for n_cachemanagertimer
Oct 26 10:23:27 2001: Started: Services/cachemanagertimer
Oct 26 10:23:27 2001: Running: services...
Oct 26 10:23:27 2001: Running: CosNaming/NamingContext
Oct 26 10:23:27 2001: Running: Jaguar/GarbageCollector
Oct 26 10:23:27 2001: Running: JaguarServlet/ServletService
Oct 26 10:23:27 2001: Running: Services/cachemanagertimer
Oct 26 10:23:27 2001: CPB_Object::invoke: method invocation for run
Oct 26 10:23:31 2001: Component: testssl/n_testjaguar will not bind to any listener.
Oct 26 10:23:51 2001: Authentication timeout period is 3600 seconds.
Note: authentication timeout can be disabled.
Oct 26 10:23:51 2001: Authentication lockout period is 600 seconds.
Note: authentication lockout can be disabled.
Oct 26 10:24:14 2001: Set 'thread.safe=false' for component 'Services/cachemanager' since 'sharing=true' and component type is PB
Oct 26 10:24:14 2001: Stopped: CosNaming/NamingContext
Oct 26 10:24:14 2001: PB_Component::create: created PB_Object for n_employeerules
Oct 26 10:24:14 2001: DEBUG: BusinessRules/employeerules (create container 1415)
Oct 26 10:24:14 2001: DEBUG: BusinessRules/employeerules (constructor)
Oct 26 10:24:14 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:14 2001: CPB_Object::Initialize: Session created.
Oct 26 10:24:15 2001: CPB_Object::Initialize: CreateInstance succeeded for n_employeerules
Oct 26 10:24:15 2001: Set 'thread.safe=false' for component 'Services/preferencesmanager' since 'sharing=true' and component type is PB
Oct 26 10:24:16 2001: PB_Component::create: created PB_Object for n_preferencesmanager
Oct 26 10:24:16 2001: CPB_Object::Initialize: Session created.
Oct 26 10:24:16 2001: Preferences Manager: Storing database preferences...
Oct 26 10:24:16 2001: DBMS = 'O84' stored.
Oct 26 10:24:16 2001: CacheName = 'tennessee' stored.
Oct 26 10:24:16 2001: CPB_Object::Initialize: CreateInstance succeeded for n_preferencesmanager
Oct 26 10:24:16 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:16 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:16 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:16 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:18 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules/of_isregistereduser
Oct 26 10:24:18 2001: CPB_Object::invoke: method invocation for of_isregistereduser
Oct 26 10:24:18 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:18 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules (remove container 1415)
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules (create container 1439)
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:18 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:18 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:18 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:18 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:18 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules/_get_proxyname
Oct 26 10:24:18 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:18 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:18 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules (remove container 1439)
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules (create container 1447)
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:18 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:18 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:18 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:18 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:18 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules/_get_proxyname
Oct 26 10:24:18 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:18 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:18 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules (remove container 1447)
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules (create container 1452)
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:18 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:18 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:18 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:18 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:18 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules/_get_proxyname
Oct 26 10:24:18 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:18 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:18 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules (remove container 1452)
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules (create container 1457)
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:18 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:18 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:18 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:18 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:18 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules/_get_proxyname
Oct 26 10:24:18 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:18 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:18 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules (remove container 1457)
Oct 26 10:24:18 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules (create container 1464)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:20 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:20 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:20 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/of_getemployeename
Oct 26 10:24:20 2001: CPB_Object::invoke: method invocation for of_getemployeename
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:20 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules (remove container 1464)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules (create container 1472)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:20 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:20 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:20 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/_get_proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:20 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules (remove container 1472)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules (create container 1477)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:20 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:20 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:20 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/_get_proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:20 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules (remove container 1477)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules (create container 1482)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:20 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:20 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:20 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/_get_proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:20 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules (remove container 1482)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules (create container 1487)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:20 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:20 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:20 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/_get_proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:20 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules (remove container 1487)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules (create container 1492)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:20 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:20 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:20 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/_get_proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:20 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules (remove container 1492)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules (create container 1497)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:20 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:20 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:20 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/_get_proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:20 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules (remove container 1497)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules (create container 1502)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:20 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:20 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:20 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/_get_proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:20 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules (remove container 1502)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules (create container 1507)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:20 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:20 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:20 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/_get_proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:20 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:20 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules (remove container 1507)
Oct 26 10:24:20 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:21 2001: PB_Component::create: created PB_Object for n_navtree
Oct 26 10:24:21 2001: DEBUG: Navigator/navtree (create container 1524)
Oct 26 10:24:21 2001: DEBUG: Navigator/navtree (constructor)
Oct 26 10:24:21 2001: DEBUG: Navigator/navtree/$Activate (bind)
Oct 26 10:24:21 2001: CPB_Object::Initialize: Session created.
Oct 26 10:24:21 2001: CPB_Object::Initialize: CreateInstance succeeded for n_navtree
Oct 26 10:24:21 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:21 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:21 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:21 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:21 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:21 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:22 2001: CPB_Object::activate succeeded for n_navtree
Oct 26 10:24:22 2001: DEBUG: Navigator/navtree/of_retrievesync
Oct 26 10:24:22 2001: CPB_Object::invoke: method invocation for of_retrievesync
Oct 26 10:24:22 2001: DEBUG: BusinessRules/employeerules (create container 1553)
Oct 26 10:24:22 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:22 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:22 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:22 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:22 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:22 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:22 2001: DEBUG: BusinessRules/employeerules/of_getemployeename
Oct 26 10:24:22 2001: CPB_Object::invoke: method invocation for of_getemployeename
Oct 26 10:24:22 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:22 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:22 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:22 2001: DEBUG: BusinessRules/employeerules (remove container 1553)
Oct 26 10:24:22 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules (create container 1558)
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:23 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:23 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:23 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:23 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:23 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules/of_getemployeeregion
Oct 26 10:24:23 2001: CPB_Object::invoke: method invocation for of_getemployeeregion
Oct 26 10:24:23 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:23 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules (remove container 1558)
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules (create container 1566)
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:23 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:23 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:23 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:23 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:23 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules/of_iscpsmember
Oct 26 10:24:23 2001: CPB_Object::invoke: method invocation for of_iscpsmember
Oct 26 10:24:23 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:23 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules (remove container 1566)
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules (create container 1574)
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:23 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:23 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:23 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:23 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:23 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules/of_hasteamleadership
Oct 26 10:24:23 2001: CPB_Object::invoke: method invocation for of_hasteamleadership
Oct 26 10:24:23 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:23 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules (remove container 1574)
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules (create container 1582)
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:23 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:23 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:23 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:23 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:23 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules/_get_proxyname
Oct 26 10:24:23 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:23 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:23 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules (remove container 1582)
Oct 26 10:24:23 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules (create container 1587)
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:24 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:24 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:24 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:24 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:24 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules/_get_its_transaction
Oct 26 10:24:24 2001: CPB_Object::invoke: property get for its_transaction
Oct 26 10:24:24 2001: CPB_Object::invoke failed for n_employeerules
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:24 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules (remove container 1587)
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules (create container 1595)
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:24 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:24 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:24 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:24 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:24 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules/_get_iel_errorlog
Oct 26 10:24:24 2001: CPB_Object::invoke: property get for iel_errorlog
Oct 26 10:24:24 2001: CPB_Object::invoke failed for n_employeerules
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:24 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules (remove container 1595)
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules (create container 1603)
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:24 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:24 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:24 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:24 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:24 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules/_get_is_user_name
Oct 26 10:24:24 2001: CPB_Object::invoke: property get for is_user_name
Oct 26 10:24:24 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:24 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules (remove container 1603)
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules (create container 1611)
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:24 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:24 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:24 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:24 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:24 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules/_get_is_name
Oct 26 10:24:24 2001: CPB_Object::invoke: property get for is_name
Oct 26 10:24:24 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:24 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules (remove container 1611)
Oct 26 10:24:24 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules (create container 1619)
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:25 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:25 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:25 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:25 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:25 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules/_get_ii_type
Oct 26 10:24:25 2001: CPB_Object::invoke: property get for ii_type
Oct 26 10:24:25 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:25 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules (remove container 1619)
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules (create container 1627)
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:25 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:25 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:25 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:25 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:25 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules/_get_ib_trace_events
Oct 26 10:24:25 2001: CPB_Object::invoke: property get for ib_trace_events
Oct 26 10:24:25 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:25 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules (remove container 1627)
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules (create container 1635)
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:25 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:25 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:25 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:25 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:25 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules/_get_ib_web_display
Oct 26 10:24:25 2001: CPB_Object::invoke: property get for ib_web_display
Oct 26 10:24:25 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:25 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules (remove container 1635)
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules (create container 1643)
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:25 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:25 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:25 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:25 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:25 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules/_get_is_browser
Oct 26 10:24:25 2001: CPB_Object::invoke: property get for is_browser
Oct 26 10:24:25 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:25 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules (remove container 1643)
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules (create container 1651)
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules/$Activate (bind)
Oct 26 10:24:25 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:25 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:25 2001: CPB_Object::invoke: property get for proxyname
Oct 26 10:24:25 2001: CPB_Object::invoke succeeded for n_preferencesmanager
Oct 26 10:24:25 2001: CPB_Object::activate succeeded for n_employeerules
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules/_get_istr_parm_list
Oct 26 10:24:25 2001: CPB_Object::invoke: property get for istr_parm_list
Oct 26 10:24:25 2001: CPB_Object::invoke succeeded for n_employeerules
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules/$Deactivate (unbind)
Oct 26 10:24:25 2001: CPB_Object::deactivate succeeded for n_employeerules
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules (remove container 1651)
Oct 26 10:24:25 2001: DEBUG: BusinessRules/employeerules/$CanBePooled (pooled)
Oct 26 10:24:25 2001: PB exception caught in tryInvoke
Oct 26 10:24:25 2001: AFLIB Message: 18209/11/0: Transaction::Commit(): Transaction was marked ABORTONLY - Aborting!

Oct 26 10:24:25 2001: DEBUG: Navigator/navtree (remove container 1524)
Oct 26 10:24:25 2001: DEBUG: Navigator/navtree (destructor)
Oct 26 10:24:26 2001: PB_Component::create: created PB_Object for n_cachemanager
Oct 26 10:24:26 2001: CPB_Object::Initialize: Session created.
Oct 26 10:24:26 2001: CPB_Object::Initialize: CreateInstance succeeded for n_cachemanager
Oct 26 10:24:26 2001: CPB_Object::invoke: method invocation for of_getdatabasepreferences
Oct 26 10:24:26 2001: CPB_Object::invoke succeeded for n_preferencesmanager

After deploying components, cannot open component. Component
is inherited from another object in same pbl.

Resolution: This is not a PB problem. The print crash can be reproduced outside of PB using a c++ application, hence it is a printer driver problem.

"IEXPLORE.exe has generated errors. The program will
be closed by windows. An error log is being created".

Using the following html:
<OBJECT type="application/datawindow8" codebase="Psdwc80.cab#8,0,0,7070" classid="CLSID:88881503-8888-1000-8000-080009AC61A9" HEIGHT=300 WIDTH=300>
<PARAM VALUE="d_balpos_priorday123456789012.psr" NAME="DataWindowObject"></PARAM>
</OBJECT>

Works ok when accessing a datawindow plugin thru html:
<EMBED SRC="dwplug8.psr" WIDTH=900 HEIGHT=800>

The registry has the following settings in the HKEY_LOCAL_MACHINE
HKLM\SOFTWARE\Microsoft\Internet Explorer\Plugins\Extension\.psr
HKLM\SOFTWARE\Microsoft\Internet Explorer\Plugins\MIME\application/datawindow8

Worked ok when accessed from a client browser from win98 or NT. Problem
only appears to be when client browser is on windows 2000.

In PowerBuilder 7 and 8, pressing <shift><home> in a datawindow editmask only moves the current position to the start of the edit field.
Subsequentially pressing <ctrl>C and paste, pastes the complete value and no selection.

Pressing <shift><end> does select untill the end of the field, but <ctrl>C does not copy the selection.

Works ok on nt.

A window with many large images used for the picture property of PictureButton / Picture controls
does not always load all the images in the window when opened in the window painter or previewed
from PB. OK in a compiled application or with PB 7.x

A) when there are not any editable columns
B) when the column is protected
C) other controls including bitmaps, lines, and text

If you single click into the middle of the field, the cursor will jump to the beginning of the field. This problem happens in Netscape as well.

Problem happens in Pb 7.0.3 and pb 8.0.

RESOLUTION:

This is not a PB bug.

The autoselect property will not work as desired in the html datawindow. IE's behaviour is such that when we tab into a textbox, the contents are automatically selected. But when we set a value in the textbox, the contents are not selected. This would mean that, after this change, even if the autoselect property is unchecked the contents will appear selected. This is an undesired side effect. Even if we try to use workarounds, we are back to a jumping cursor.

autoselection is turned on, the field will get highlighted but to get to a particular

character in the field you need to use the arrow keys.

Per PB Development, this is not a bug:
PB now validates in PB7 and PB8 where it should have before. Workaround implemented was to add the edit mask after the window was open so that the behaviour looked the same as in PB6.

In the srv.log of build 10121:
Nov 02 15:30:31 2001: sqlpreview SELECT "customer"."id" , "customer"."fname" , "customer"."lname" , "customer"."address" , "customer"."city" , "customer"."state" , "customer"."zip" , "customer"."phone" , "customer"."company_name" FROM "customer"
Nov 02 15:30:31 2001: TRACE: test_app/nv_remote_datawindow_rob/retrieveex: 0 ms, 136 bytes in, 26 bytes out (jagadmin@199.93.180.146)
Nov 02 15:30:31 2001: DEBUG: test_app/nv_remote_datawindow_rob (lookup container 321)
Nov 02 15:30:31 2001: DEBUG: test_app/nv_remote_datawindow_rob/setselflink
Nov 02 15:30:31 2001: TRACE: test_app/nv_remote_datawindow_rob/setselflink: 0 ms, 145 bytes in, 29 bytes out (jagadmin@199.93.180.146)
Nov 02 15:30:31 2001: DEBUG: test_app/nv_remote_datawindow_rob (lookup container 321)
Nov 02 15:30:31 2001: DEBUG: test_app/nv_remote_datawindow_rob/setaction
Nov 02 15:30:31 2001: updatestart return 1
Nov 02 15:30:31 2001: sqlpreview SELECT "customer"."id" , "customer"."fname" , "customer"."lname" , "customer"."address" , "customer"."city" , "customer"."state" , "customer"."zip" , "customer"."phone" , "customer"."company_name" FROM "customer"
Nov 02 15:30:31 2001: TRACE: test_app/nv_remote_datawindow_rob/setaction: 0 ms, 239 bytes in, 26 bytes out (jagadmin@199.93.180.146)
Nov 02 15:30:31 2001: DEBUG: test_app/nv_remote_datawindow_rob (lookup container 321)
Nov 02 15:30:31 2001: DEBUG: test_app/nv_remote_datawindow_rob/getlasterrorstring
Nov 02 15:30:31 2001: TRACE: test_app/nv_remote_datawindow_rob/getlasterrorstring: 0 ms, 132 bytes in, 29 bytes out (jagadmin@199.93.180.146)
Nov 02 15:30:31 2001: DEBUG: test_app/nv_remote_datawindow_rob (lookup container 321)
Nov 02 15:30:31 2001: DEBUG: test_app/nv_remote_datawindow_rob/generate
Nov 02 15:30:31 2001: DEBUG: test_app/nv_remote_datawindow_rob/$Deactivate (unbind)
Nov 02 15:30:31 2001: DEBUG: test_app/nv_remote_datawindow_rob (remove container 321)
Nov 02 15:30:31 2001: DEBUG: test_app/nv_remote_datawindow_rob/$CanBePooled (pooled)
Nov 02 15:30:31 2001: TRACE: test_app/nv_remote_datawindow_rob/generate: 0 ms, 124 bytes in, 106462 bytes out (jagadmin@199.93.180.146)
Nov 02 15:30:31 2001: SystemException: TRANSACTION_ROLLEDBACK

In the srv.log of PBVM build 10047 (worked ok):
Nov 02 15:57:53 2001: DEBUG: test_app/nv_remote_datawindow_rob/retrieveex
Nov 02 15:57:53 2001: sqlpreview SELECT "customer"."id" , "customer"."fname" , "customer"."lname" , "customer"."address" , "customer"."city" , "customer"."state" , "customer"."zip" , "customer"."phone" , "customer"."company_name" FROM "customer"
Nov 02 15:57:53 2001: TRACE: test_app/nv_remote_datawindow_rob/retrieveex: 0 ms, 136 bytes in, 26 bytes out (jagadmin@199.93.180.146)
Nov 02 15:57:53 2001: DEBUG: test_app/nv_remote_datawindow_rob (lookup container 321)
Nov 02 15:57:53 2001: DEBUG: test_app/nv_remote_datawindow_rob/setselflink
Nov 02 15:57:53 2001: TRACE: test_app/nv_remote_datawindow_rob/setselflink: 0 ms, 145 bytes in, 29 bytes out (jagadmin@199.93.180.146)
Nov 02 15:57:53 2001: DEBUG: test_app/nv_remote_datawindow_rob (lookup container 321)
Nov 02 15:57:53 2001: DEBUG: test_app/nv_remote_datawindow_rob/setaction
Nov 02 15:57:53 2001: updatestart return 1
Nov 02 15:57:53 2001: TRACE: test_app/nv_remote_datawindow_rob/setaction: 0 ms, 237 bytes in, 26 bytes out (jagadmin@199.93.180.146)
Nov 02 15:57:53 2001: DEBUG: test_app/nv_remote_datawindow_rob (lookup container 321)
Nov 02 15:57:53 2001: DEBUG: test_app/nv_remote_datawindow_rob/getlasterrorstring
Nov 02 15:57:53 2001: TRACE: test_app/nv_remote_datawindow_rob/getlasterrorstring: 0 ms, 132 bytes in, 29 bytes out (jagadmin@199.93.180.146)
Nov 02 15:57:53 2001: DEBUG: test_app/nv_remote_datawindow_rob (lookup container 321)
Nov 02 15:57:53 2001: DEBUG: test_app/nv_remote_datawindow_rob/generate
Nov 02 15:57:53 2001: DEBUG: test_app/nv_remote_datawindow_rob/$Deactivate (unbind)
Nov 02 15:57:53 2001: DEBUG: test_app/nv_remote_datawindow_rob (remove container 321)

Worked ok in PB 7.0.3 (build 10047).

1. When I open a dw in the dw painter, I cannot select any column/text/object with a right or left mouse click until I go into the preview tab (or tab order) and then back to the layout tab.
2. In the dw painter, when a text object is selected only the last character typed is applied to the text object (and the text area as well).

Generation Messages:
Deployment Error Adding Component IDL For Package 'test' EAServer error code: SystemException: com.sybase.CORBA.idl.SyntaxError: file 'test::u_test `datastore_1', line 1: '`': expected '{'

If you try to suppress repeating values on multiple columns, the suppression fails on the second column unless the data is repeated on both of the selected columns.

04/25/2005:

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

04/25/2005:

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

- on the table information(e.g. use 'Export syntax' operation)

and

- on the "Object Layout" view/pane

Result of investigation is 'Not a Powerbuilder bug'.

There is a limitation with DB2/AS400 handling an ODBC API call for Foreign Key info. Suggest that customer escalate this defect to IBM vendor.

The problem is no longer reproducible with the latest driver provided in IBM AS400 Client access v5 r1 s101907 (version 8.0.2).

WORKAROUND: Call the stored procedure as a remote procedure call.

Per PB Engineering, not to be fixed (see 3 workarounds below):
1. There are some feature difference between PB5 and PB7.
2. In PB whenever you insert a nested DW, it will automatically calculate the size of the DW and put the nested DW accordingly.
3. In PB5, you can reduce the width of the nested DW up to some extent and the full DW will be shown at Run / Preview. This is a PB5 feature.
4. In PB7, if you reduce the width of the nested DW, the reduced nested DW will be shown at Run / Preview. This is a PB7 feature.
5. In this CR, the original application in PB5 contains nested DW with reduced width. In PB5 it is showing properly (point 3). But after migration to PB7, the nested DW are clipped (point 4).

We know the root cause, but cannot do any change in source code because of these feature differences. We suggest to use one of the following work arounds

1) In PB5 before migration, increase the width of the nested DW. Then migrate to PB7.
2) In PB5 before migration, delete the nested DW and insert again. Without changing the width migrate to PB7.
3) In PB7 after migration, delete the nested DW and insert again.

The datawindow was created using the following select:
select 1 from (select 1, 2 from dual)

Once the datawindow is created and you go back and modify the sql to:
select 1 from (select 1,2,3 from dual)

While returning back to the sqlpainter, you will see the error messages.

workaround:

long ll_row
ll_row = dw_1.GetRow()
string ls_string, ls_upper
ls_string = dw_1.GetitemString(ll_row,"dept_name")
ls_upper = Upper(ls_string)
dw_1.SetItem(ll_row, "dept_name",ls_upper)

Customer would like to have the option to disable this gray line. The repeated group headers cannot be removed and they would need to understand that.

Submitted to development for scoping of including an option to disable the gray line.

Update from Engineering:

For PB 9.0, a new UI datawindow attribute has been introduced to control this.

FOR PB 7.0.3 build 10140 and PB 8.0.1 build 9048 and above, users need to use a new undocumented dot notation to eliminate the gray line:

To disable the gray line add this line of code "dw_1.object.datawindow.hidegrayline=true" usually at the end of the code for the window open event.

Per PB Engineering, this is not a PB bug, it is a Microsoft issue:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnwui/html/msdn_editctls.asp

Workaround:
For the dw control, can they try using an approach similar to:

Add to the editchanged event:
choose case ls_column_name
case "testleft"
if len(data) > 7 then
dw_1.object.testleft.width = 700
end if
case "testright"
if len(data) > 7 then
dw_1.object.testright.width = 700
end if
case "testcenter"
if len(data) > 7 then
dw_1.object.testcenter.width = 700
end if
caseif len(data) > 7 then
dw_1.object.testjustify.width = 700
end if
end choose

In the sle, can they try adding the user event with the id of pbm_enchange with the following code:
if len(em_1.text) > 6 then
em_1.width = 600
end if
return 1

Work-around:
Add disconnect statements in the scriptline before restart.

Problem does not occur on Windows 2000, only Windows 98 and Windows 95 (not certified for PB 8.0)

Workaround:

To modify the library list after deploying the component, specify the library list in the com.sybase.jaguar.component.pb.librarylist property in the component's properties file or in Jaguar Manager.

NOTE: This is most likely a difference between the Sybase implementation of the Listview control which was used in PowerBuilder 6/6.5 and the Microsoft implementation of the Listview control which has been used in PowerBuilder starting with version 7, so it is possible that this behavior will be outside of the control of PowerBuilder in version 7 and later.

04/25/2005:

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

has been renamed from .pbw to .pbw.

Getting error of:

d:\pse-80\testextension.PBW is not a workspace

PER DEVELOPMENT:
Nothing can be done about this. This is a user created problem, which is equivalent to corrupting any pbl manually. Even the crash is outside of PowerBuilder's control at this point.

Clarification :
This window has a olecustomcontrol on it. Every olecontrol has got binary data (contains information about the olecontrol) associated with it.
For example, you can see the export file of the window (see at the bottom of the file)
1. export of window from new.pbl
Start of PowerBuilder Binary Data Section : Do NOT Edit
08w_dbxfer.bin 2027 (2027 is length of data)
200705004000000000060d00000000010007050040000001000705000 ..........
18w_dbxfer.bin 2027
End of PowerBuilder Binary Data Section : No Source Expected After This Point
2. export of window from dbxfer.pbl
Start of PowerBuilder Binary Data Section : Do NOT Edit
08w_dbxfer.bin 4612
2000001200e011cfd0e11ab1a1000000000000000000000000000000000003003e0009fffe..........
18w_dbxfer.bin 4612
End of PowerBuilder Binary Data Section : No Source Expected After This Point
3. export of window from new.pbl after removing compilation error.
Start of PowerBuilder Binary Data Section : Do NOT Edit
08w_dbxfer.bin 3076
2000000c00e011cfd0e11ab1a1000000000000000000000000000000000003003e0009fffe..........
18w_dbxfer.bin 3076
End of PowerBuilder Binary Data Section : No Source Expected After This Point

Giving this introduction, let me clarify some points
1. Window in the new.pbl refers to member variable 'integer_option1' of str_options. str_options of dbxfer.pbl does not have this variable. This is the reason we get compilation/regeneration error when we put new.pbl in the bottom of the library list (this time it picks up str_options from dbxfer.pbl, as this comes first in the list) and do not get any error when we put new.pbl in the top of the library list(this time it picks up str_options from new.pbl, as this comes first in the list).
If we export 'str_options' from new.pbl and import it into dbxfer.pbl, we will not get any compilation error.

2. When we unzip the pbls from the uploaded test case we can successfully open 'w_dbxfer' from new.pbl without crashing. While opening the window, it tries to put the olecustomcontrol(ole_zip) in the window. In this process it reads the binary data (example 2) from dbxfer.pbl instead of new.pbl. To pickup the data, it searches the library and get first occurrence of 'w_dbxfer.bin' in dbxfer.lib. Since these data are OK, pb can open the window.

3. When we unzip the pbls from the uploaded test and change the libpath to put new.pbl at the front and try to open the window it crashes. While opening the window, it tries to put the olecustomcontrol(ole_zip) in the window. In this process it reads the binary data (example 1) from new.pbl. Since these data are corrupted, pb crashes.

Note: steps to make the window import successfully
i) Unzip the pbls from the uploaded test case and open the target in PB.
ii) Export 'str_options' from new.pbl and import it into dbxfer.pbl
iii) open the Window from new.pbl and save the window forcefully (typing a character and deleting the same will enable the save button) to generate the correct binary data for the olecustomcontrol in the window.
iv) Export the window from new.pbl and import it into dbxfer.pbl

With 1st row at top of page click once on down arrow

Once again on up arrow -> instead of scrolling back to the top it scrolls to the last row in dw

The cursor remains on the first row .

Workaround:

In ScrollVertical event of dw

This.SetRedraw(False)

This.Post event ue_PostVScroll()

And in the user event ue_PostVScroll()

This.SetRedraw(True)

Example: SetTransObject, Retrieve, Update, etc.
Business Reason:
Use Try, Catch, Finally techniques to perform complete error processing rather than Try Catch AND return code check.

under conditions of having done this cr's workaround : "Symbol" + String(col, "#,##0.00")

i.g ) input 3,000,000 with currency("⊥") then displayed like as "⊥3,300,000.00 .

Solution:

The Customer was able to use ORCA to modify their DataWindow source code, and no PB code change was required.

AFTER :
<PARAM NAME="SourceFileName" VALUE=""></PARAM>
<PARAM NAME="DataWindowObject" VALUE="X:\PB8\deptlist.psr"></PARAM>

Per PB Engineering:
This is NOT a bug.
Need to set JAGUAR_JAVAVM environment variable pointing to the jdk being used on the server machine, remove and create the service again.

Workaround:
reassign the dataobject of the datawindow before switching into querymode.

Workaround:
Edit the exported syntax to reflect the correct column names.

Work-around: set the property com.sybase.jaguar.component.iso_level for the component.

When using PB8 to generate the JavaScript files for enabling caching for the WebDW functionality (specifically the files for handling strings, dates, and numbers), a couple of lines of script reference an object named htmldw. That object will only exist (as a global variable) if the datawindow object has the ObjectName property (on the Javascript Generation tab) set to 'htmldw' or blank (default is 'htmldw').

03/05/2004: This issue no longer reproduces in 8.0.4 build 10616, and appears to be working correctly.

compile to fail when used within an IF statement.

ANY l_var1

if isvalid(l_var1) then

end if

WA:
resolution that works are icons created with Watcom Image Editor: 32x32x16 color

The System Procedure checkbox is disabled in the datawindow stored procedure wizard.

Its disabled for SYC, O84, MSS, in7. Works ok for odbc.

Possible dupe of CR 232181.

WORKAROUND: use p-code. The problem does not occur if you use PBDs instead of DLLs.

If you supply a value for "Data value for On" and "Data value for OFF", then
then the 3 state property will remain checked. There is no edits when
you save the datawindow and require this.

Workaround:
If possible, use dot notation to access the value of a long columnname column.

LaserJet 5000 & 4000 PCL 5e -
HPBPCLA.DRV
HPBPCLA1.DLL
HPBPCLA2.DLL
HPBPCLA3.DLL
HPBPCLA4.DLL
HPBPCLA5.DLL
HPDCMON.DLL
HPTABS16.DLL

Tracing on the sequence of DLL loading , some information may help to explain the error. By default on Win95 / 98 the printer driver will only be loaded as need and removeed after use. Our PB graph / dw graph control will load and use the default printer driver to render the Graph. It seem that PB 7.0.3 datawindow engine will occpy the same memory space the Printer driver asking for. Thus it seem that when dw engine load first, the printer driver will not use an alternative memory space.

Select c.a, c.b

From (Select 'A' a,

'B' b

from Dual) c

The datawindow will Build, and if you do a retrieve in the Preview Pane, Data is returned. Next Go back to the data Source (SQL Button on the tool Bar) and then Add a space in in the SQL Statement. Ie.

Select c.a, c.b

From (Select ' A' a, //Put a space in front of the A

'B' b

from Dual) c

When you return to the Datawindow you will get the following Datawindow Error

DataWindow

DataBase Error:

Error parsing command: Unexpected token in FROM clause, could not create table list.

If the psr report is saved thru the datawindow painter, than it works ok. You can
view the psr thru pb.

It fails on Windows98 and it is also reproducible on Windows95.
The problem is not reproducible on Windows NT4.0.

Column is not in table

In later versions of PB 7.0 and the GA release of PB 8.0, PSRs are saved in an OLE Storage format. PowerBuilder used to store the PSR in a "PowerBuilder Format", however this was changed to a more "vanilla OLE" approach to improve performance. The java DataWindow in PowerJ cannot read PSRs stored in OLE format. PowerJ development has stated that supporting the new OLE Storage format would not be possibility due to cross-platform issues and other complexities involving access to the OLE source. PowerBuilder 9.0 should include an option to either save a PSR with the "OLE Storage Format" or the "PowerBuilder Format". This would ensure compatibility between the two products.

This is not a bug. There was a corrupt object inside pbl. When this object was fixed, then EXE generation could be done successfully.

Workaround:

Either comment out BOTH setredraw functions, or post them.

This problem no longer appaers in PB 8.0.4 and 9.0.1

==========================================

When using a dw that has no columns and doing a dot notation (object.data) to share with another datawindow or datastore a gpf occurs. This did not happen in PB 6, 7.x

=========

Workaround:

Initialize the datawindow/datastore that is supposed to be shared with insertrow(1).

NOTE: This has been fixed for Greek fonts with PB 8.0.1 builds 9100 and later. Other fonts are pending.
See CR 274273 for Russian and CR 241602 for Japanese/Korean.

This turned out as wrong behaviour of PB 6.5:

The right behaviour for format mask is:

1. As per PB Help, the Display Format will be always

in US format. So the meaning of the format will be same for all regional

settings, but while displaying the data it should replace the period and

comma characters as per regional settings.

2. Situation is little complecated when "ASIS" characters are present in

the format. For example if the format is 0000.00 (true format) and A0000.00

(with ASIS) and we enter 12 then the display will be

12.00 and A0012.00 (in English)

12,00 and A0012,00 (in CPC -> Comma Preferring Countries )

That means for the used display format 0000\.00.000/00 the following behaviour is expected if you use it comma preffering countries:

If enter 1234 the display should be 0012.34,000/00.

Explanation:

1. the first dot "\." is a ASIS character and is ignored

2. the second dot "." is interpreted as a comma if using a CPC operating system and will be displayed as a comma ( similar behaviour if using a display mask like $#,###.00)

3. The dash "/" is a ASIS character and is ignored

If you create a dw with a background color for a band, this color will not be shown up in the Printpreview nor it will be printed. Please add a propertie in the datawindow to enable this for Printpreview and for the printing.

For instance

dw_1..Object.DataWindow.Print.Preview.Color = 'YES'
dw_1.Object.DataWindow.Print.Background.Color = 'YES'

Gets a GPF on a french NT 4 when creating a Web page using the wizard or trying to edit it. (See repro)

Workaround:

Use o73 driver for the meantime but cannot use new Oracle 8 features !

Windows regional settings must use a space as the digit separator (this is possible if French locales is set in Windows control panel -> regional settings).

Copying from a column with either an Edit format or an Edit mask of #,##0.00 and pasting into a column with no formatting or to a column with an Edit format of #,##0.00 then tabbing away gives a validation error in the dw (need to delete the space to continue).
Pasting from above columns into a column with an edit mask of #,##0.00 works fine.

Inserting control tab characters in a mle/sle and
then copy to datawindow and print, depending on the print driver, the control
tab characters will not print properly from datawindow.

Problem happens for different OS's and drivers: HPLJ4Plus, HP2000C, HPCLJ8500

This occurs when attempting to generate a 'proxy' if the deployed component has a Powerbuilder array of 'structure' object(s) as the argument.

For example:

a) Notice the package name has not been generated.

typedef sequence < ::str_notification_list >

STR_NOTIFICATION_LISTSEQ;

...

b)

IDL is missing the package name, it should be:

typedef sequence < ::stringseqbug::str_notification_list >

STR_NOTIFICATION_LISTSEQ;

...

any la_data
la_Data = dw_1.object.data[1,1]
for i = 1 to 100
la_data += la_data
next

Workaround:
using
la_data = la_data + la_data
instead

any la_data
la_data = dw_1.object.data[1,1]
for i = 1 to 10
la_data += '%'
lb_b = fn_gpf(la_data)
next

Workaround:
using
la_data = la_data + la_data
instead

FAILS:
...
tv_1.SetRedraw(True)
tv_1.InsertItemLast(0,"t1", 1)

WORK FINE:
tv_1.SetRedraw(False)
tv_1.textsize = 20
tv_1.height = 900
tv_1.width = 1500
tv_1.InsertItemLast(0,"t1", 1)
tv_1.SetRedraw(True)

If you uncheck the override edit property in the datawindow and rerun the
app, than it works ok.

This is happening because the actual data of the column is not a julian date number, but the date 29 Feb, so I'm not sure how this would be handled in the code. Workaround is to change the day to something not equal to 60, then change the year to a non-leap year (eg: 2001) then change the day back to 60. This will now map the 60 "under the covers" to March 1.

We were unable to reproduce the actual error internally. Perhaps there is something to do with exact layout and/or exact steps when working within the painter. We could only reproduce the informational messages. The TSE reproduced the error once, but could not thereafter.

Workaround: enable property "Empty String is NULL"

w_activate.enabled=false
// Execremote
li_dde_result = execremote("net_send_message,8,5", -1)
w_activate.enabled=true

This will not allow any operations while execremote is working.

If this is not a bug but simply running out of some Windows resource, we should at least document this.

Old CR 163072 seems to be running into possibly the same type of problem but on older operating systems so not sure if its pertinent.

Workaround: (From the vendor that supplied the OCX) Set the font size in the form's resize event.

PER DEVELOPMENT: It was determined that this was a configuration issue and not a bug.

SOLUTION: Not a bug. The problem happens because the file name is not qualified with the path. Initially the file is in the current directory. A call to MailLogon changes the current directory and thereafter the file cannot be found. This is easily fixed by using GetCurrentDirectory to save the initial current directory, and the calling ChangeDirectory to set the current directory back to what it used to be. Then it is possible to write to the file again. Alternatively the file name could be fully qualified with the path.

PB application execution error (R0039) - Application terminated.
Error accessing external object property text at line XX in clicked event of cmdbtn ...

This error appears to affect keywords e.g. no , yes. It does not occur for other data values e.g. 'England' ;

This CR affects from PB7.0 and PB8.0 GA , both releases exhibit breakage.

Workaround:
comment out the trace function
page.Trace(this.name + ".Initialize(Jag): Getting component out of session var '" + this.sessionVarName + "'");
in line 1301 of the ObjMod80.scc in PowerDynamo

PB will fail at the first FETCH call which is supposed to return a string value :
FETCH ReadLog INTO :ls_Msgs;
of_error("After First Fetch: "+ls_msgs)

It is unclear whether this is a bug or an issue that needs to be documented.

The solution for customers is to Export the To-Do list from the PowerBuilder 7 application before doing the migration, and then import the To-Do list into the PowerBuilder 8 application.

04/25/2005:

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

The design constraint will be documented in the PB documentation and the technote http://my.sybase.com/detail?id=1019020 has been published.

Problem may be in the of_retrievesync in the n_jaguar_autodb object located in the
jag_common.pbl.

The pstack trace shows the following:
lwp#14 ----------
eec3a4e8 lwp_sema_p (eed68580)
eec3a4e8 __lwp_sema_wait (eed68580, 60da28a8, 0, ee305d44, 0, ee305d38) + 8
eed472b8 _co_timerset (eed68570, eed67b08, eed66b60, eed682b0, 3, eed66b60) + f4
eed564b0 _thread_start (0, 0, 0, 0, 0, 0) + 40
lwp#15 ----------
eec3a49c lwp_cond_wait (eed6b260, eed6b270, ecce5c48)
eec6c2f4 _lwp_cond_timedwait (eed6b260, eed6b270, 0, 3c42f6da, 0, 0) + 90
eed4755c _age (eed66b60, eed67b74, 0, 0, 0, 4) + 90
eec37758 __door_return (0, 0, 0, 0, 0, 0) + 68
lwp#16 ----------
eec376fc door (0, 0, 0, 0, ecc15d70, 4)
eec376fc __door_return (0, 0, 0, 0, ecc15d70, 4) + c
eed48a60 _lwp_start (0, 1, 6000, ecce5bd4, 21, 0) + 14
eed4ebf0 _ti_thr_yield (0, 0, 0, 0, 0, 0) + 8c

If the objects that were synchronized include ancestor objects, then all of the descendants need to be regenerated as well. This is also the case for objects with complex dependencies.

In these situations, an "Incremental rebuild" or "Full Rebuild" is necessary following GetLatestVersion. This is analogous to updating a header file in a C++ application.

PB9 works solves this issue by providing Orcascript that can run in batch mode at night. The "SCC REFRESH TARGET" command performs a GetLatestVersion on all out-of-sync objects and then launches a full rebuild automatically. This is the preferred solution, because it can perform all of this time-consuming processing during off-hours, and emerge with a very reliable build.

NOTE: Greatly improved by PB 8 build 9626. Small leak still remains.

04/25/2005:

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

The DateTime function is documented for argument types date, blob or any type containing blob.

When an argument of type datetime was provided, PowerBuilder 7 Build 10118 and before returned the datetime value. But PowerBuilder 7 Build 10121 and later returned ??/??/0000 00:00:00 (Null datetime value). Also PowerBuilder 8 returned the null datetime value.

The other format for Datatime is providing a blob argument.
However, below script resulted in garbage datetime returned.

ldt_show = DateTime(blob(string(ldt_DateTime)))

04/25/2005:

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

This feature is broken when using database DB2/AS400 with the setting in pbodb70.ini is PBTableOwner='NO'.
If this feature was working, the parent table (which has the primary key) would have been displayed.

This did not happen in PB 7.0.3 build 10114 or earlier or in PB 8.0.1 builds tested through 9056.

The window that is being closed has 2 statichyperlink controls. Remove
the controls and app works ok.

This feature is broken when using database DB2/AS400 with the setting in pbodb70.ini is PBTableOwner='NO'.
If this feature was working, the properties of the foreign key would be displayed
e.g.
General tab -> foreign key name, columns selected to participate in the foreign key definition, Order.
Primary key tab -> Table, columns, Order
Rules tab.

Summary: This bug needs fixing for PB7 & PB8 release.
PB7 release : gpf
PB8 release : Does not gpf however important information is missing from the Primary key tab.

Example:
You think your connected to the network (project). But you're really not.
So you open powerbuilder 8.0 and connect as if you want to work on-line.

First warning in the output window:
---------- Source Control
01/16/2002 15:38 Source Management Initialization...
Initialization of PowerBuilder Native SCC Failed.
Source control is in offline mode.

It's certainly possible for a novice to ignore this message.
From there you could open and change any object as if you were in regular PowerBuilder, (again one familiar with pb souce control should notice that there is plus signs not asterisks next to the objects which signify that you are off-line)

So you make changes, quit PowerBuilder and then later get connected to the network officially. When you reconnect your changes will be overwritten with the exported objects in the project directory. So at this point you have lost all your changes that you have made when you were working online but were really off-line.

WORKAROUND :
- use an edit style instead of an EditMask style.
- code the dw_1.update() in the RowFocusChanging event.
- don't set the focus on the date column when changing row.

04/25/2005:

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

Using a percentage for the height and width. When using pixels, scrollbars to appear.
Although different machine settings appear to need different pixel settings for the
scrollbars to show.

Using other Oracle functions such as 'ltrim', 'rtrim', or 'max' works fine, but using functions such as 'nvl' and 'decode' are resulting in the database error.

The syntax from step #4 can be used to create a new datawindow. When I entered that as the sql syntax right from the start, the datawindow was created successfully and I got no errors from PowerBuilder. The error only occurs when I take the initial datawindow and try to change the syntax.

Unclear if this is a PB, MS Source Safe or Norton AntiVirus issue.

Per PB Development:
This is not a PB Bug.
One should use currency in the editmask if deploying application at the international level.

This turned out as wrong behaviour of PB 6.5:

The right behaviour for format mask is:

1. As per PB Help, the Display Format will be always

in US format. So the meaning of the format will be same for all regional

settings, but while displaying the data it should replace the period and

comma characters as per regional settings.

2. Situation is little complecated when "ASIS" characters are present in

the format. For example if the format is 0000.00 (true format) and A0000.00

(with ASIS) and we enter 12 then the display will be

12.00 and A0012.00 (in English)

12,00 and A0012,00 (in CPC -> Comma Preferring Countries )

That means for the used display format 0000\.00.000/00 the following behaviour is expected if you use it comma preffering countries:

If enter 1234 the display should be 0012.34,000/00.

Explanation:

1. the first dot "\." is a ASIS character and is ignored

2. the second dot "." is interpreted as a comma if using a CPC operating system and will be displayed as a comma ( similar behaviour if using a display mask like $#,###.00)

3. The dash "/" is a ASIS character and is ignored

call EAS component - pass by reference UNBOUNDED array (see test 5).

To see this behavior with a datawindow:
1. Click on the "down arrow" icon once so that the first record scrolls up and out of focus.
2. Click on the "up arrow" to bring it back in focus. Notice that the datawindow scrolled down (by a page) instead of scrolling up

dw_2.GetChanges (lblob_changes)
dw_1.Reset ()
dw_1.SetChanges (lblob_changes)

Will crash/hang PB 8 while ...

dw_2.GetChanges (lblob_changes)
dw_1.Reset ()
dw_1.InsertRow(0)
dw_1.SetChanges (lblob_changes)

does not .

Determined by development to not be a bug.

When changing the menu and trying to save it can also result in a C0158 error.

Object: m_1

Event: m_1::create

(0004): Error C0158: The property '__hwnd' was found in class 'm_1', but insufficient rights are available

to access it

(0005): Error C0031: Syntax error

Work-around is to disable autoinstantiate and create the user-object explicitly within the menu

and test with ifValid if it already had been created.

The instance variables and functions of the user-object could also be moved to the menu object.

An InsertRow() action when performed on a DataWindow containing a Drop Down DataWindow (DDDW) causes a row to be inserted in the DDDW. As a result of the blank row in the DDDW, a validation error fires when the blank row gets and loses focus.

Currently reproduced internally ONLY on Windows 2000. Customer experiences problem on both NT and Windows 2000.

Reproduced behaviour in PB 8.0 GA & PB 8.01 Build 9066. Works fine in PB 7.03

04/25/2005:

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

Not consistently reproducable on all machines. Suspect it may be related to the amount of machine memory. Consulting with development.

Using getchanges does appear to clear out buffer.

If you need to use getfullstate, the workaround is to manually clear out buffer as follows:
any la_Primary[], la_Filter[]
// We need to manually clear then delete buffer
IF this.deletedcount() > 0 THEN
IF this.FilteredCount() > 0 THEN la_Filter[] = this.object.data.filter
IF this.RowCount() > 0 THEN la_Primary[] = this.object.data
// now reset the ds
this.reset()

// Put the data back in to the proper buffers
if upperbound(la_Primary[]) > 0 then this.object.data = la_Primary[]
if upperbound(la_Filter[]) > 0 then this.object.data.filter = la_Filter[]

END IF

Happens in Internet Explorer IE only !

Possible Workarounds:

If possible don't Display the messages into the alert messagebox. eg. use a button object (b_1) and code similar to: function webDW_ItemChanged( row, col, val)

{

//alert ("htmlDW_ItemChanged");

webDW.dataForm.b_1.value="Itemchanged to " + val;

}

-try using the ItemError event if possible.

Happens in Internet Explorer IE only !

PB engineering group's view is that it is not a bug. EditMask # does not display 0 when zero value is entered. It has always behaved that way. The customer can use normal Edit Style with empty string as NULL option to meet their requirement.

Work-around is to set the format directly into the source into the field
values.dispattr.format instead of setting it through the datawindow painter.

Development has determined that this is expected behavior and not a PB bug. Questions and answers as to why this is the expected behavior are below.

Q1. Why PB is saving decompressed data in Database ? Why not save the compressed data in database and decompress during Data Window retrieval ?

A1. PB is saving the data in BLOB. Apart from image, other objects can be stored in BLOB. So there is no way to know when to decompress and when not. Also we will not know the image type (bmp, jpg etc.) and will not know, how to decompress. So images have to be saved in decompressed format.

Q2. Is PB doing the decompression correctly?

A2. PB is using standard Microsoft calls for decompression. One proof of this is the size of decompressed images are same, if we select same image in different format (i.e. bmp, jpg etc.).

my_value = funktion().nvo.stringval

The function returns a nvo that has another nvo as property.
It is tried to access a string property of the second nvo, but the string contains garbage characters.

Work-around is to do the assgnment in two steps:

nvo_1 my_nvo
my_nvo = funktion()
my_value = my_nvo.nvo.stringval

Problem: Newer versions of the PowerBuilder VM cause marshalling exception when passing back parameters by reference to a java process. The customer has a simple sample in which a java application calls a java EJB which in turn calls a PBNVO method which takes in parameters by reference. This sample shows that a marshalling exception occurs when the NVO attempt to return the parameter values back down to the client.
This was not a problem in earlier builds of the PBVM. This is a problem with the NT and Solaris PBVM. The customer would like to see fixes made in both.

PER DEVELOPMENT:
All the elements in the html page have to be absolutely positioned to maintain their positioning as in the datawindow. In this case the element positioned at point "X" will remain at the point no matter what the font size or the placement or size of the other elements. If at design time, using small fonts, we specify an element to be placed at "X", we cannot expect it to reposition itself to point "Y" if the font size increases. This would be against absolute positioning.

If we open the datawindow in PowerBuilder design time using small fonts, we'll see that everything is in it's place and all the text and labels can be seen and read. Now increase the font size and reopen the same datawindow. You will see that all the text and labels cannot be read anymore. But the sizes of the text and edit controls remain same. So the HTML generated behaves in the same way as PowerBuilder.

If the user expects a page to remain nicely formatted using large fonts, they must provide for it during design time. They can ensure this by either providing enough space during design time or doing design using large fonts.

----------------------------------------------------------------
Review for SetComplete wrong return value:
----------------------------------------------------------------
PB703x : The SetComplete() RETURN value is +1 which means SUCCESS of the current transaction to actually commit.
PB801_9056: The SetComplete() RETURN value is -1 which implies there was an error and the component could not commit the transaction.
In both PB releases above, the database changes are comitted {correct action}.
____________________
Function:
oletxnobject.SetAbort()
____________________

Solution: Alter the expression to CumulativeSum(my_column for ALL) and you can successfully preview/retrieve the datawindow.

NOTE: The fix to this CR fixes only the crash. Fixing the datawindow engine to correct limitations of aggregate functions such as cumulativesum is too large a project for an ebf or a point release. With the fix to this issue, PowerBuilder will no longer crash, but the cumulativesum will result in NULL, i.e. display as blank.

CONNECT USING SQLCA;
SQLCA.DBParm = "PBDBMS=0"
dw_1.Settransobject(SQLCA)
dw_1.insertRow(0)

Workaround:
- disconnect
- set the PBDBMS parameter
- connect

Update 2002-03-05:
Third party problem with CA. SCC implementation not as expected. Opened case at CA : Case number 11701979 titled: PowerBuilder and CCCH-SCC.
Waiting for feedback from CA Techsupport.

PB has the ability to send to BCCs ( mailRecipient object's recipient Type property) but when the address book is displayed this is not available.

The problem does not occur if a connection cache to the same DB is defined in Jaguar.
In the server log, I can see that PB does some calls to the cache even if the PB transaction is a direct connection.

AFLIB Message: DLL lookup failed for 'libpbjag70x.so' failed OD message: ld.so.1
/export/home/JaguarCTS361C2/bin/jagsrv: fatal: relocation error: file export/home/JaguarCTS361C2/lib/libpbwfr70.so: symbol LeaveCriticalSection: referenced symbol not found

PBComponent::load: failed to load PowerBuilder VM
CTS_Component::load failed for component 'testmeout/n_testserver'
SystemException: OBJECT_NOT_EXIST (testmeout/n_testserver:Home/create)

UPDATE: According to PB Engineering, this is a "build" issue, and they will do a new EBF rebuild to address the problem.

Fixed in PB 7.0.3 EBF build 10156 or greater.

The dot in this path will cause link errors at machine code compile time.

CGEN: Compiling '...\user.DOMAIN\...\temp\XXX.c'
CGEN: Linking...
cannot open XXX.obj : No such file or directory

The linker should be able to avoid this problem
See workaround tab for simple workarounds

In a datawindow choose the EDIT tab and set so that "Empty String as NULL" is checked. Leave all other columns are unchecked (i.e. they are left as default), please click on another column to verify.
Close the datawindow design view. Right click on the datawindow and select Edit Source, then Find by typing <CTL>F "nil", and you should find one line which reads: edit.nilisnull=yes . This was added to the source as a result of checking the "Empty String as NULL" box above. Note that there is no edit.nilisnull=no, which would be the default if the "Empty String as NULL" is unchecked. The customer requests that all such defaults be added to the export files, even though this would make the files larger, as doing SEARCHes in source control and editing would be much more simple and not have to be done manually in certain cases.

Multiple functions in object, ie Window. When one of the functions is modified the order changes in exported source file.

Implement support for the new ASE 12.5 functionality with CHAR columns >255 characters wide in the SYJ driver as well as the SYC in CR 258686.

Dupe of EAServer CR 325704:

EAServer should support char columns with greater than 255 characters. Currently, the limit is 255 characters. Similary, it should support more than 255 columns per table.

Solution:

Resolved in EAServer 4.2.2.

This turned out to be a Third Party Problem, not a PB bug. The problem did not occur with the msvcrt.dll version 6.00.8168.0.

Removing a computed field with the following value from the datawindow, and the

migration from PB 7.0.3 to PB 8.0.1 works ok:

capital_item_cost_am + capital_stores_ovrhd_am + capital_co_labor_cst_am + capital_cntr_labor_cst_am + capital_transp_ovrhd_am + capital_payroll_ovrhd_am + retirement_stores_ovrhd_am + retirement_transp_ovrhd_am

2. PB 9 Beta 1 requires EAServer 4.1 , which did not exist in the install

3. At the end of the install got a warning "One or more of the following drivers failed to selfregister. E:\PB9\Shared\Web Targets\WtHtmlDwDtc90.dll;"

variables will cause pb to crash in pb 8.0.1.

Shared Variables:

constant long sl_xs_color_blue = Rgb ( 0, 0, 255 ) // blue

constant long sl_xs_color_white = Rgb ( 255, 255, 255) // white

Broken in 7.03 Build 10146 and 8.01 build 9056 (related to CR 263579)

This specific case requests the inclusion of ID attributes to all generated SPAN tags. Below is further information from customer:

ID's should be assigned to all SPAN tags for the purpose of attaining a handle to that SPAN. A common sense naming convention must be used, based on the name of the "DataWindow.HTMLGen.ObjectName" property, the data that the SPAN is encompassing, and if the SPAN is part of the rendered detail area, the row number. Below are some examples,

For all examples, the ObjectName is "d_myDatawindow", and if required the row will be row 12.

Example 1: SPANs that encompass entire rows.

<SPAN ID="d_myDatawindow_row_12">..</SPAN>

Example 2: SPANs that surround text labels(not text inputs). Text name is "t_label"

<SPAN ID="d_myDatawindow_t_label_12">..</SPAN>

Example 3: SPANS that surround a header or footer area

<SPAN ID="d_myDatawindow_header">..</SPAN>

The reasoning behind this is so developers can get a handle to the SPAN objects in their javascript. They may want to do this for a number of reasons: find the positioning, change it's innerHTML, make it visible or not. But currently, as there is a name value assigned to almost all objects except the SPANs, they remain elusive to the developers control. We are requesting that they be given Id's rather than Name's for a few reasons, but the main one is that ID is defined as part of the SPAN's specification in W3C's HTML 4.0 specification blueprint.( http://www.w3.org/TR/REC-html40/struct/global.html#edef-SPAN)

Customer reported problem for PowerBuilder 7. Problem also exists in PowerBuilder 8 build 9066.

--------------------------------------------------------------------------------
Summary table:-
--------------------------------------------------------------------------------
Variable Declaration Datatype Result(PB703_10150)
--------------------------------------------------------------------------------
Null Instance ANY Broken
Null Local ANY OK
Null Shared ANY OK
Null Global ANY OK
--------------------------------------------------------------------------------
Not null Instance ANY OK
--------------------------------------------------------------------------------

DataWindow Error:
Retrieve argument 1 does not match expected type.

If the dw argument is a non-null value, there is no error when retrieving the datawindow using the ANY datatype INSTANCE variable

The problem can be isolated to a datawindow retrieval with NULL argument when it is passed by ANY datatype INSTANCE variable.
There is no problem for a null value stored in ANY datatype when declared as LOCAL, SHARED and GLOBAL variables.

An ODBC connection to an Sybase ASE Database or MS SQLServer database.

A datawindow using an (picture) olecolumn mapped to an image datatype.

When retrieving the picture fails to retrieve, updating is OK.

This fails in PowerBuilder 8 but not in PowerBuilder 7 or 6.

Only the first 32KB of the blob is retrieved by the datawindow.

To retrieve the full blob increase the parameter PBMaxBlobsize

from the default value of 32767 to a maximum of 2147483647 in the

file pbodb8.ini for the relevant ODBC driver.

CR 259729 is similar to this problem but that case uses JSP.

March 14th, 2002: Update on this CR
This CR has been resolved as status 'Not a bug' by PB software engineering.
Explanation:
Merant drivers does not seem to support the API SQLDescribeParam.
For the ODBC logs, when an API (SqlGetFunction) with parameter (SQL_API_SQLDESCRIBEPARAM) is issued,
only Merant drivers specify 'not supported'.

A)To verify if the driver supports this functionality:
=======================================
i) Set the odbc trace utility and review the log.
ii) Use PB
Action: Connect odbc to database
Painter: DB admin
In view/ pane 'Objects', select folder 'Driver information'
Select SQL_Describe_paramter
Determine this property setting.
=========
Test 1: Use Merant driver for Oracle database
=========
Action: see Aii) above
Property setting = No
=========

When creating a pipeline in the painter with as source an ASE table (SYC interface) then the integer columns become real (float) columns in the source datatype of the pipeline object.

This does not happen when connecting through ODBC.

Work-around is to edit the source of the pipeline object and for the relevant columns change:

- type=real to type=long

- dbtype="float" to dbtype="integer"

Win98 / PB8x / Pb function SelectRow()

When a datawindow row is highlighted and then scrolled using the keyboard arrow keys, the script is written

to unhighlight the previous row and highlight the new row selected. However this behaviour is

broken and the datawindow display is confused and multiple rows remain highlighted.

The group datawindow has 4 groups and is sorted by division_code,
major_sic, sic and sum(curr_vendorgrp).

If a data value of 12345 is retrieved (or entered using setitem) the first time the column gets focus, the display appears as 12345--. Position the cursor between the hyphens. You can only enter 2 characters, for example resulting in 12345-EL-. At that point the cursor locks and nothing else can be entered. If you tab away and tab back, then you can enter more data, for example 12345-EL-ABCD.

04/25/2005:

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

Update 03/14/2002
Fixed in Pb 8.0.1 build 9100 while fixing CR 266745.

dw_temp.dataobject = "d_test"
//dw_temp.settransobject(sqlca)
// dw_temp.retrieve()
if keydown(keypageup!) then
dw_temp.object.DataWindow.VerticalScrollPosition = 0
elseif keydown(keypagedown!) then
dw_temp.object.DataWindow.VerticalScrollPosition =
dw_temp.object.DataWindow.VerticalScrollMaximum
end if

29 April 2002
Finally identified that the problem was caused by I.E. instead of PB ActiveX control.
Same PB ActiveX work under Netscape 4.78 + ActivX plugin wrapper without the problem.

No workaround

Customer needs this to avoid the loss of precision when retrieving decimals using dynamic SQL and GetDynamicNumber. From PB docs for GetDynamicNumber ...
"If you use this function to return a decimal value, expect the value to be rounded when you convert the
double data type back to a decimal. Doubles do not support the same precision as decimals."

giving the following error when expanding a table or rmb on a table and

selecting an option. Getting the following error:

RAISERROR executed: There is no object with the specified owner/name combination

In the jdbc log, getting the following errors:

DriverManager.getConnection("jdbc:sybase:Tds:cork:2639/")

trying driver[className=com.sybase.jdbc.SybDriver,context=null,com.sybase.jdbc.SybDriver@5248cc]

java.sql.SQLException: JZ0SJ: Metadata accessor information was not found on this database. Please install the required tables as mentioned in the jConnect documentation.

A tabular style datawindow works fine. The problem appears to be for Crosstab only.

04/25/2005:

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

of the transaction object (RPC) are not being executed when a double variable is supplied

for rpc arguments of type decimal.

Work-around is to encapsulate the RPC call in a local function of the transaction object and

call the rpc within the local function with the right decimal type.

When moving the mouse beneath the script painter, the painter automatically scrolls down.

It would also scroll vertically if you hold the mouse just right or left of the script painter when dragging.

This doesn't work anymore in PowerBuilder 8 and PowerBuilder 9.

The script painter does not scroll in drag mode.

04/25/2005:

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

Crash is in PBDWE80.DLL
With build 8.01.9087 crash is...
0x116268ad referenced memory at 0x0000007a - Read error

SetItem works OK

When the composite is printed, nested N-up header text and group header text are getting printed
over each other. And of the group header only the bottom half is printed,
so that only the lower half of the text is on the paper.

In a print preview the problem is also visible because of a missing group header at the top of the page.

The "OK All" appears to execute the same as "OK" button when trying to add duplicate target objects to source control.

Comments:
Inconsistent behaviour.
TreeView function InsertItemLast does not set the treeviewitem properties correctly unless SetItem is called to force the change in the following circumstances...

If the Checkboxes property is set to TRUE for a Treeview item (to display a checkbox) and StatePictureIndex is set to zero (ie to NOT show no StatePicture -> not show the checkbox). Any other non zero value for StatePictureIndex will work and be correctly inserted in treeview - only zero fails when checkboxes are used.
Workarounds - change the checkboxes property if checkbox needs to be hidden or call SetItem.

Per Development: This is not a PowerBuilder bug but a Netscape 4.x limitation.

Netscape4 does not support <input type=button> without an enclosing form. To display the two buttons,

<form>

<input type="button" name="reset" value="Clear Form" onClick

="resetForm();">

<input type="button" name="submit" value="Search" class=obj7C60

onClick="validateDocNumber();">

</form>

Create a new standard class from Exception, Throwable, RunTimeError class. Open Function list view and the pink icon appears for SetMessage & GetMessage functions suggesting there is inherited user code. The same functions in Script painter do not have these icons to indicate inherited code.

and you are using settransobject, autocommit=false and usecontextobject=yes,

setabort is not rolling back database changes.

Update - 11/13/2002:

This CR turned out to be "Not a Bug".

By using 'Requires' as the transaction property, setabort seems to work ok.

The same webdatawindow on nt does not give the error.

Viewing the html generated on solaris and nt, shows the following
difference:
<SCRIPT LANGUAGE="JavaScript">document.dwMine_dataForm.width_0.focus();</SCRIPT>

This tag is generated for every column and is at the end of the INPUT TYPE.

A workaround is to map user events to the scroll events and force a redraw:

Datawindow user event ue_hscroll mapped to pbm_dwnhscroll:
this.setredraw(false)
this.setredraw(true)

Database error -131
SQLSTATE = 37000
Sybase ODBC Driver Adaptive Anywhere syntax error or access violation

Using a oracle 8.1.7 table as the source and piping it to an ASA 6 or 7 table. Same error.

1. Initial splash screen, small type at bottom says copyright 2001 - should be 2002. Same thing with license agreement screen at the bottom and same thing with ASA splash screen.

2. There are some Xerces licensing issues from Apache, do those need to be included in the license information viewed via setup?

3. On the license agreement dialog screen at the bottom... "To Proceed with the installation..." do not capitalize Proceed

1. If you choose not to install ASA 8, you get a message that you didn't select it, but the explanation at the bottom of that dialog box refers to ASA 7.0 being required for examples, etc. not ASA 8.

2. The explanation in that same dialog should also include that ASA 8 is required for Web Targets, because a later message in the PB installation indicates it's required.

3. The explanation in that same dialog refers to the demo database as EAS Demo DB V4... are we delivering a V5? should we rename altogether given EOL of EAStudio?

2. Warning dialog that is displayed when you do NOT select EAServer has an extra space before comma in the first sentence of second paragraph... "select EAServer<space>,<space>then..." should be "select EAServer,<space>then"

3. Description of PBNI SDK is lacking on the select components dialog.

4. Also need a better description of the PowerBuilder Resource Monitor on the select components dialog.

5. PowerBuilder Install completion screen (where you check to read the README) has the Sybase logo overwriting the 'Reliable' graphic on the left of the dialog.

04/25/2005:

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

2/2004

PB Engineering has no plans to address the PSR issue. Instead, the SaveAS to PDF functionality is the recommended format for customers to use.

FIX: This issue is fixed in PowerBuilder 8.0.2 EBF build 9224 and the PowerBuilder 8.0.2 Maintenance Release (build 9506). In order for the fix to take effect, it is necessary to add a new dbparm: DBParm = "GenerateEqualsNull=1" in the transaction object. You must also set DisableBind=0.

However if you use:
dw_1.Modify("dwr_1.Nest_Arguments = ((~"300~"))")
than the retrieval works ok. Problem appears to be when using number variables
in the Modify statement.

For example, Dirlist("*.IMG") reports a match on Sample.img AND Sample.img1.

Workaround: if using a convention of renaming old or backup files, use and entirely different extension than that of the original file.

Cautions: In MS-DOS doing a "DIR *.img" command you will get the same results as in PowerBuilder. Using the Windows Explorer File...Find dialog results vary with the operating system and service pack. See the following information on www.microsoft.com. This may be the root cause.

//////////////////////////////////////////////////////////////////////////
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q37950

Using Asterisk Wildcard Expansion with Trailing Characters (Q37950)
The information in this article applies to:

Microsoft MS-DOS operating system versions 4.0 , 4.01 , 5.0 , 5.0a , 6.0 , 6.2 , 6.21 , 6.22

SUMMARY
The asterisk (*) wildcard ignores any combination of trailing characters specified after the wildcard in either the filename or the extension. Thus, the following two MS-DOS commands have the same result, even though they have different file specifications:
DEL *.DAT
DEL *h.DAT
This is due to the definition of the "*" wildcard, and how it is expanded.

Please exercise caution when using the wildcard in destructive MS-DOS commands, such as DEL or ERASE. We strongly recommended that you use the exact wildcard combination in a DIR command first to examine the outcome prior to issuing any other command. This may alert you to any potential consequences of the command syntax prior to any destructive executions.
//////////////////////////////////////////////////////////////////////////////////////

Solved by removing mutliple copies of PBVM80.DLL from different build numbers. Customer would like to be able to have multiple PBVM##.DLL files on the same machine, from different builds, without conflicts.

This behavior may be the expected behavior resulting from the different operating system and the versions of the font (Arial) installed. But with the SLE, when running the sample in PB 7.0.3 build 10160 and PB 8.0.1 build 9087 there is a slight difference in behavior on the same NT 4.0and W2k machines. This CR will address that difference in behavior but will also request the engineer assigned to it to document the expected behavior with different operating systems.

It works In runtime, if you right-click on the control and then select rightToLeft.

Per PB Engineering, this is not a bug.

This is not an issue and will be closed. There was confusion between RTL order, alignment and font. The rightToLeft order works for a multi-line edit control. The alignment is not set by default to right but can be selected from the painter or set dynamically.

...If not, please click Browser and select the EAServer 4.1 folder

Should be:
...If not, please click the Browse button and select the EAServer 4.1 folder

PBVM and Datawindow component. These options should be on the

same list as PowerBuilder, InfoMaker, Powerdynamo, etc.

The capability is needed for existing EAServer users needed to install

the PBVM and Datawindow 9.0 components.

RMB on the target in the system tree

Search for something which will give a hit in a registered (but not checked out) object

Double click the object name in the output window -> this by-passes the usual check which would warn the user that the object is registered but not checked out.

Object opens in appropriate painter with no warning that it's not checked out

Not critical as PB does not allow user to save changes.

dw_1.modify("datecol.protect=0~tdatecol.Background.Mode=0")

When they tab out the correct date appears.

WORKAROUND:

Change the following line of code from:

dw_1.modify("datecol.protect=0~tdatecol.Background.Mode=0")

To:

dw_1.modify("datecol.Background.Mode=0")

dw_1.modify("datecol.protect=0")

04/25/2005:

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

This CR is a request for engineering to investigate why Powerbuilder sends WM_QUERYENDSESSION message
- when a window object is closed
or
-when the application is terminated.

Workaround:

Set pen width to 0 after setting pen style.

4.0, then call a Method on a component. Application fails with a CORBA System Exception.

If the method is first called using an iiop connection instead of iiops, and subsequently called using an

iiops connection, it works.

in EAServer. Instance pooling is not being used. Out of memory errors

are causing easerver to crash.

Problem is happening in the n_cache/f_get_cache in the afc_server.pbl (changed 5/13).

dwsyntax=ds_cache[i].describe("datawindow.syntax")

if count>0 then dwdata=ds_cache[i].describe("datawindow.syntax.data")

Reviewed by PB Engineering and determined to be "Not a PB Bug". The customer was provided with a workaround.

The original problem listed below was believed to be a bug the origin being:
PBNV_Registry->Register( bitwiseDesc );
PBNV_Registry->Register( networkDesc );
Which was causing one of the classes to not show up in PB. A closer
look at the documentation reveals that you can only call register once. Documentation
needs to be clearer about this and how to provide multiple classes so
submitting a bug for a problem to development can be avoided in the future.

Please disregard the following:
When including 2 PBNI classes in a single dll,
none of the functions implemented by those classes can be seen in the PBD.
From the system tree, notice that the PBNI functions do not show up and
if you try doing a full rebuild it will fail.

04/25/2005:

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

to xml. When viewed in a browser, it only shows 1 level.

The following from JO'Neil:

I brought this up on the Sentosa discussion database that essentially it's very confusing for new Web Target users to figure out where to start. The lack of a JSP page icon is really just a symptom of this. I've recreated my posting below:

"This note really began with a question on how to create a JSP page within a JSP target, but I've taken the liberty of expanding on that to what I see is potentially a larger source of confusion.

On the Target menu, there are four web options: PowerDynamo WebSite, Website, JSP Target, Migrate PowerSite 7.1 projects, and Source Controlled Web Target. If I were a PB developer struggling to come to grips with doing Web development, I think I would find these options a bit daunting and not really have a clue on where to start. I just want a website after all!

I'm proposing we rethink these "New" tabs to make them a bit more user friendly.... We have a workspace tab with a single icon (and it will probably always be a single icon), but we have a Target Tab with 11 (growing to 12?) options which mixes traditional PB ("PB Classic"?) with Web targets as well as NEW development options with migration options. (Also, do we want to downplay PowerDynamo here as well? - we are misleading our users quite a bit here, given known scalability issues with PowerDynamo and essentially the end-of-life of the technology)

As you get to the Web tab, you see quite a few options there as well. They are not quite as confusing UNTIL you question what they mean with a JSP target. Should the 'Web Page' options automatically create .jsp files (they currently create .htm)? Will a WebDW Page under a JSP target automatically pull in the DW TagLib? What does a 'Script' page mean in the context of a JSP target? What if I want a 4GL page with a Web Datawindow, what does a user pick (I know the answer(s) ;>), but don't think a user would immediately)?

Finally, why is there a tab labeled "PB Objects". The whole product is PowerBuilder at this point!!

What I am proposing is that there be some sort of mini-design review for this dialog. I don't think rework would be that intensive as the underlying wizards wouldn't really change that much, just the introductory dialog, which after all is the 'first impression' for a user. One of my issues though is that I do not think that Team Sybase is the best target audience for this dialog. They are generally too in tune to our products and make assumptions of functionality that a 'normal user' would not. If we could introduce something like this in a Beta 2 drop, Team Sybase would get a look at it, but it could be in place for Beta 3 when it reaches the 'public.'

I contemplated submitting a few beta cases in this regard, but I think it needs to be looked at as a whole rather than as a combination of specific issues."

change the extension from html to jsp. in Powerbuilder the PowerSite editor

appears instead of something similar to PowerJ.

if you view that file in File Editor or Notepad, it returns as one long string.

For readiblity, please add cr/lf and spacing (indenting) to reflect the

structure of the XML document.

Exception code: C0000005 ACCESS_VIOLATION
File Name: E:\pb70\Shared\PowerBuilder\PBLIB70.dll
File Version: 7.0.3.10172
Fault address=10A341B1 Section:Offset=01:000231B1

Registers:
EAX:00000000
EBX:00900984
ECX:00000000
EDX:03520354
ESI:0012F290
EDI:03520352
CS:EIP:001B:10A341B1
SS:ESP:0023:0012EF48 EBP:03520020
DS:0023 ES:0023 FS:0038 GS:0000
Flags:00010206

Call stack:
Address Frame Param0 Param1 Param2 Param3 Function Name
10A341B1 0012F5AC 033E0068 01230968 033E00D8 00001B46 PL_BrowseDlgProc+4C21
10A309AA 0012F93C 012B08A0 00000111 00002733 00000000 PL_BrowseDlgProc+141A
77E8306C 00629094 00000000 00000000 00000000 00000000 RegisterClipboardFormatW+14F8
00000000 0014FC68 00000006 0000000D 00000000 00000000 0000:00000000

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

Memory Status:
Total physical memory: 196024K
Available physical memory: 72764K
Total virtual memory usage: 215640K / 376560K
PowerBuilder virtual memory usage: 95800K / 2097024K

Loaded Modules:
E:\pb70\Shared\PowerBuilder\PB70.EXE 7.0.3.10172
C:\WINNT\System32\ntdll.dll 4.00
E:\pb70\Shared\PowerBuilder\PBSYS70.dll 7.0.3.10172
E:\pb70\Shared\PowerBuilder\PBCMP70.dll 7.0.3.10172
E:\pb70\Shared\PowerBuilder\PBVM70.dll 7.0.3.10172
E:\pb70\Shared\PowerBuilder\libjcc.dll
C:\WINNT\system32\WSOCK32.dll 4.00
C:\WINNT\system32\KERNEL32.dll 4.00
C:\WINNT\system32\WS2_32.dll 4.00
C:\WINNT\system32\MSVCRT.dll 6.10.8293.0
C:\WINNT\system32\USER32.dll 4.00
C:\WINNT\system32\GDI32.dll 4.00
C:\WINNT\system32\ADVAPI32.dll 4.00
C:\WINNT\system32\RPCRT4.dll 4.00
C:\WINNT\system32\WS2HELP.dll 4.00
C:\WINNT\system32\comdlg32.dll 4.00
C:\WINNT\system32\SHELL32.dll 4.00
C:\WINNT\system32\COMCTL32.dll 5.81
C:\WINNT\System32\WINSPOOL.DRV 4.00
C:\WINNT\system32\ole32.dll 4.00
C:\WINNT\System32\OLEPRO32.DLL 5.0.4518
C:\WINNT\system32\OLEAUT32.dll 2.40.4518
C:\WINNT\system32\VERSION.dll 4.00
C:\WINNT\system32\LZ32.dll 4.00
C:\WINNT\System32\oledlg.dll 1.0
E:\pb70\Shared\PowerBuilder\PBDWE70.dll 7.0.3.10172
E:\pb70\Shared\PowerBuilder\PBDTS70.dll 7.0.3.10172
E:\pb70\Shared\PowerBuilder\PBDWP70.dll 7.0.3.10172
E:\pb70\Shared\PowerBuilder\PBSQL70.dll 7.0.3.10172
E:\pb70\Shared\PowerBuilder\PBLIB70.dll 7.0.3.10172
E:\pb70\Shared\PowerBuilder\PBDEV70.dll 7.0.3.10172
E:\pb70\Shared\PowerBuilder\PBORC70.dll 7.0.3.10172
E:\pb70\Shared\PowerBuilder\PBAPL70.dll 7.0.3.10172
E:\pb70\Shared\PowerBuilder\PBUDO70.dll 7.0.3.10172
E:\pb70\Shared\PowerBuilder\PBSCR70.dll 7.0.3.10172
E:\pb70\Shared\PowerBuilder\PBWED70.dll 7.0.3.10172
E:\pb70\Shared\PowerBuilder\PBDPP70.dll 7.0.3.10172
C:\Program Files\Lotus\Sametime Client\ACTIVMON.dll 3, 0, 2, 1
C:\WINNT\system32\MSIDLE.DLL 5.50.4522.1800
C:\WINNT\System32\mpr.dll 4.00
C:\WINNT\System32\ntlanman.dll 4.00
C:\WINNT\System32\NETUI0.dll 4.00
C:\WINNT\System32\NETUI1.dll 4.00
C:\WINNT\system32\NETAPI32.dll 4.00
C:\WINNT\system32\NETRAP.dll 4.00
C:\WINNT\system32\SAMLIB.dll 4.00
C:\WINNT\System32\rpcltc1.dll 4.00
C:\WINNT\System32\ntshrui.dll 4.00
E:\pb70\Shared\PowerBuilder\pbwep70.dll 7.0.3.10172
E:\pb70\Shared\PowerBuilder\pbwei70.dll 7.0.3.10172
E:\pb70\Shared\PowerBuilder\pbODB70.dll 7.0.3.10172
C:\WINNT\System32\ODBC32.dll 3.520.6526.0
C:\WINNT\System32\odbcint.dll 3.520.6526.0
e:\pb70\Adaptive Server Anywhere 6.0\win32\dbodbc6.dll 6.0.4.3781
e:\pb70\Adaptive Server Anywhere 6.0\win32\dblgen6.dll 6.0.4.3781
C:\WINNT\System32\odbccp32.dll 3.520.6526.0
C:\WINNT\System32\IMAGEHLP.DLL 4.00
C:\WINNT\System32\psapi.dll 4.00

causing a line break in a graph.

With PB 7.0.3 build 10108, it worked fine.

This is not a bug:

This issue was resolved by setting property com.sybase.jaguar.component.bind.thread=true.

the server and database name, the execute will fail with the following error:

Procedure Name Error

(Dupe of 169070)

O90 interface need Oracle 9i client installed should read

O90 interface requires that the Oracle 9i client be installed

The main.cpp has listed:
class PBNIEMAIL from mailsession\n

When changed to the following then no problems. There's no Smartheap error.
class PBNIEMAIL from nonvisualobject\n

When trying to repro cr277641, cannot create the dll because of a
link error (step 7 of repro).

Worked ok in PB 6.5.1 (build 620).

Is there a method available that will list the templates available in the datawindow object ? Can they be shown on the system tree or the browser as 'properties' of the datawindow? Please make the Eport Templates more accessible.

In PB 6.5 (build 444) when you drag a horizontal scrollbar to the far left in a DW, the datawindow object property HorizontalScrollPosition would be 0.

The function name should be PrintGetPrinter and not PrinterGetPrinter .

---------- Deploy: Deploy of p

Creating executable file . . .

Inspecting Application Dependencies. . .

Inspecting Application Dependencies. . .

Inspecting application libraries . . .

Unresolved resource 'Arrow!' referenced from object 'w_genapp_sheet1.win'

Error writing object information

---------- Finished Deploy of p

Unresolved resource 'Arrow!' referenced from object

Update:

*** Thursday, June 02, 2005 14:39:17 ***

cannot be reproduced anymore using PB10.2 build 8035.

ASA7 and PowerBuilder is causing virtual memory to be used up and easerver

crashing. The problem happens when stress testing the application using

Microsoft WAS tool.

EAServer crashes with the following error:

The program encounted an exception 0xc000008c at address 0x62f7feaf and cannot

continue.

The client is html pages hosted in EAserver and PowerDynamo. The html pages calling

pb components.

Right click target > properties > Library list tab > Browse > Select Library Dialog box - dropdown should have .pbd's in addition to .pbls. This option should be applicable when migrating application, migration assistant as well.

WebLink4=PowerBuilder Tech Corner!,http://www.sybase.com/developer/applicationdeveloper/pbtechcorner

WebLink5=TeamSybase,http://www.teamsybase.com

When you enter an invalid syntax then click anywhere in the datawindow => the self link arguments field is blanked out again. There should be either a messsage that the syntax is invalid, or a button that developer can click to verify the syntax...

ShowHistory shows you who has checked out a given object, but there is no way to quickly see the user who has checked our multiple objects (or what object a specified user has currently checked out).

Workarounds:

1) If possible, add a control which is enabled and has an earlier tab order than the first radiobutton, or the groupbox surrounding the radiobutton.

2) Since #1 may not be possible since it may require adding an unused control, you can alternatively do as follows:

a. Set Automatic to false for all radiobuttons, or all radiobuttons in the first group on the window.

b. Control the Checked property in the script of the Clicked event for the radiobuttons in the first groupbox on the window. Remember that the Checked property should be set on for only one radiobutton in a group. Example for a group of two radiobuttons named rb_1 and rb_1 respectively, here is the script to put in the Clicked event of the first radio button, rb_1:

/////for rb_1: clicked event////////////

if this.checked then

this.checked = false

else

this.checked = true

// in groupbox, both cannot be checked

rb_2.checked = false

end if

NOTE: The sample uses an empty mask. With a valid mask the problem does not occur.

04/25/2005:

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

A constant instance variable is declared in the ancestor class

In the decendant 2 or more instance variables are declared and initialized using the ancestor constant variable

For example,

Ancestor Window has the following instance variable

Constant int ii_FLAG = 1

In the descendant window we have the following instance declaration

int ii_var1 = ii_FLAG

int ii_var2 = ii_FLAG

If the descendant window is imported before the ancestor we get the following crash in PB 8.01 build 9116...

The instruction at "0x1090fa80" referenced memory at "0xffffffb8".

The memory could not be "read".

If just 1 instance variable is initialized in the descendant in above way PB does not crash.

Dynascript is calling a pb component. The pb component does a saveas to an EXCEL! or EXCEL5! file. The component then does a fileopen and fileread on the file that was just saved. It returns the string contents to dynamo where dynascript writes the string value out to a browser using the following:

document.contentType = "blob";

var li_total_loops = dwMine.of_getfile_loops(ls_result);

for (i = 1; i <= li_total_loops; i++){

document.write(dwMine.of_readfile_part(ls_result, i));

Update:

This turned out to be "Not a PB bug". The root cause of the problem was isolated to a "PowerDynamo limitation".

a) Completed tests for most of the datatypes supported by COM/MTS ;

b) Cannot get a straightforward function to work if the reference argument is 'char' datatype.

Data Type List:

Values below are current setting in variable, value AFTER new assignment , determine reference value :-

boolean - true, false, true - Broken

char - Error at execution, PB R0035 error calling external function

date - 5/5/2002 , 01/01/2003, 5/5/2002 - Broken

decimal - 0.33300000000000000 , 1.01 , 0.333 - Broken

double - 8596.8969 , 3.123456789012 , 8596.8969 - Broken

integer - -100, -50 , -100 true - Broken

long - 99999 , 12345 , 99999 - Broken

real - 114.2 , 3.123456789, 114.2 - Broken

string - sunny in Maidenhead, sunny in England, sunny in Maidenhead - Broken

unsignedinteger - 11515, 1400 , 11515 - Broken

unsignedlong - 654 , 98765 , 654 - Broken

Reviewed by PB Eningeering:

User error, not a PB bug.

PB engineering has determined that this is not a PB bug. The O73 driver loads an older Oracle OCI dll (ociw32.dll) than does O84 (oci.dll). The different behavior is in the Oracle OCI.dll.

an error message will be generated. PB should ignore the other OUT arguments.

This is not a bug. The SaveAsAscii function works perfectly for a grid datawindow. However, there are some limitations for other types of datawindows especially when you have multiple rows in a band. PB must convert the other dw types to a grid before saving. Basically the fields in the header and summary bands must line up with detail band fields for them to be included in the same column. If they don't PB will add columns and this causes the empty fields in any unused cells in the grid.

In PowerBuilder 7 the two zero's were interpreted literal but in PowerBuilder 8

there is different behavior and the second zero is displayed as a space and interpreted as input character.

you set the moveable property and foreground property, the line object does

not move in runtime.

8.01.9100/9116/9121

Database/Driver File/Version: PBo84xx.DLL

Embedded SQL with a WHERE condition equal to empty string or NULL value will hang PB if Oracle CURSOR_SHARING=FORCE and PB DbParm DisableBind=0

Oracle CURSOR_SHARING=EXACT with PB DisableBind=1 - NO hang (but less efficient)

Oracle CURSOR_SHARING=EXACT with PB DisableBind=0 - NO hang (Oracle & PBo84 defaults)

Oracle CURSOR_SHARING=FORCE with PB DisableBind=1 - NO hang

Oracle CURSOR_SHARING=FORCE with PB DisableBind=0 - HANG

The same SELECT in a datawindow / datastore works fine

The same embedded SQL using ODBC works fine

Oracle white paper on the subject of cursor_sharing

http://otn.oracle.com/deploy/performance/pdf/cursor.pdf

From the above doc, if a client application (eg PB) uses bind variables (default PB behaviour - DisableBind=0) there is nothing to be gained from using CURSOR_SHARING=FORCE

Workaround is to use EITHER DisableBind=0 OR CURSOR_SHARING=FORCE but never both.

Default settings for PB and Oracle is the best option.

Right now autoscript goes up to the object level functions. Request is that it should include all Powerscript functions that are listed in Powerscript Reference Volumes 1 & 2.

Also requested during PB 8 beta as CR 228747.

to another jdk other than what was installed with PB 9.0 causes PB to just

flash the splash screen and then disappear. The development environment

does not appear.

The environmental variable is set but is not used in the classpath, bootclasspath

or path. I had set it when I installed Ant on my machine.

For example if JAVA_HOME is set to $POWERJ\jdk\jdk12, than the problem happens.

If JAVA_HOME is set to $PB9\shared\sun\jdk131, than pb works ok.

If I try a similar operation from the library painter, ie...

- Export a registered object which is not checked out

- Edit source

- Save changes

- Import .sr* file

...I get an error saying the object is registered but has not been checked out so it cannot be saved. This should also appear in the source editor and nothing should be saved.

Note: Although the changes do get saved to the local copy, this object is not checked out therefore it cannot be checked back in to the source control system. Only the local copy is affected. The only way to check it in is to have checked it out first, if you check an object out after making the above changes by editing the source then the local changes are overwritten by the checked out copy.

system tree

03/05/2004: This issue no longer reproduces in 8.0.4 build 10616, and appears to be working correctly.

to retrieve the blob object. Otherwise, it make the OLEDB Column in

Datawindows useless and get kind of "RESULTSET PENDING" error.

("Microsoft OLE DB Provider for SQL Server Object was open.")

Similar reported bugs are CR239975 & CR242461 (however with the fix from CR239975 and this latest PB703x or PB801x build/ ebf, it is not necessary to close the DW preview pane/ view ;

Note: In CR239975, the workaround states to "keep the preview view closed and after creating dw change SQL to use a short alias for the long col name. " However after the fix from CR239975 and this latest PB8x build/ ebf, it is not necessary to close the DW preview pane/ view ;

At this time, the problem still occurs for the PB703x ebf/release. However the latest PB801 ebf/release does not exhibit this problem (see verification below).

shows the "Password Expiration Dialog" box. According to the online help,

this dbparm only affects applications at runtime.

Move the dbparm to a new different tab for execution only dbparms.

The problem is for o84 or o90 profiles.

The library painter will not show My documents, unless they map a drive letter there. The common dialog window only shows physical folders, not aliases. Please add the ability to see 'My Documents' when configured this way without the need to map a drive letter.

following error appears in the workspace:

Unable to Load SCC Provider DLL: C:\WINNT\System32\MsSccIntegration3.dll

Unable to Load SCC Provider DLL: C:\WINNT\System32\MsSccIntegration3.dll

---------- Source Control

---------- Done Source Control

5/9/02 16:28 Source Management Initialization...

Unable to Load SCC Provider DLL: C:\WINNT\System32\MsSccIntegration3.dll

Restoring SCC Offline Status Cache from last backup.

Error restoring SCC offline status cache from backup D:\Pse-90\10820597\test.pbc.

Using starbase version 5.1. Works ok in PB 8.0 build 9121.

-----------------------
Solution is to rename the sybase\shared\web targets\mfc42.dll that is installed by the PB9 web targets feature.

04/25/2005:

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

dbparm applies only to o73.

I verified with development and threadsafe dbparm also applies to the o84 and o90 Oracle drivers.

The threadsafe dbparm applies in development and execution time.

Fixed in 8.0.3 build 9961 and after.

[Library]

SccLogLevel=2

Would prefer to have a pre-existing entry in the pb.ini file

[Library]

SccLogLevel=1

so user only has to change it rather than figure out what he needs to change and where he needs to put this. (In my pb.ini file, there was no Library section, so this needed to be added as well)

April '03

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

April �03

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

has a column with edit style DropDownListBox with a code table. The datawindow source file (.srd) does contain syntax and values for the column, ddlb and code table.

After import, if the datawindow object is regenerated, the code table information for the

DropDownListBox is still missing.

When editing the datawindow, the code table entries are not saved when there are nested

reports.

Also PowerBuilder 7 Build 10180 and later has similar problems.

Solved by PB Engineering:

Fixed in PB 8.0.2 EBF builds 9601 and greater, including the 8.0.3 (9704) Maintenance Release, and the PB 9.0 codeline.

See CR 289862 for info about the PB 7.x fix.

select cast(multiset (select comp from glcompany) as complist) from dual;

Results in a ora-00932 inconsistent datatype error

Works ok in the sqlplus painter in Oracle.

The testcase shows two n-up datawindows where the problem happens in only one of the datawindows(d_nup). The only difference between the two datawindows is if you export d_nup, the columns are physically stored out of order. For example, emp_id2 and emp_id3 (with a tabsequence of 30 and 40) are stored after emp_lname4 (tabsequence 80).

Happens in Internet Explorer and Netscape.

April �03

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

a) 'Select error: Only cancel command is allowed when the rows are pending'. That is shortly followed by another error that;

b) 'Select error: An invalid handle was passed in a call to the database driver."

NOTE: testing with build 2031 I was unable to reproduce the second error message.

Enhancement Requested from customer: "The painter ought to ask if I want the first retrieve cancelled when I attempt to start the second..." or handle the issue in another way more graceful than the existing error messages.

For example, using City and State columns with DropDown Datawindows: When you retrieve the Specify Retrieval Criteria dialog appears. When you select a City, (Waltham) would only like to see the States that have a City called Waltham listed in the State column for that criteria dialog.

Reviewed by PB Engineering:

Not a PB bug. The customer upgraded the DB2 client software from 7.1.28 to 7.2 and problem went away.

Shouldn't the dwo.name return the name of the text field that is directly under the cursor?

st_obj.text=this.getobjectatpointer() does seem to give the correct (expected) result.

April �03

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

Reviewed by PB Engineering and determined to be "Not a Bug". They also provided the customer with a workaround.

calling a html page that downloads the datawindow activex plugin (psdwc70.cab) from a win95/98, causes Internet Explorer to crash in the awt.dll.

Problem happens in Internet Explorer 5.5 sp2 and 6.0. Problem appears to be a conflict

between java 1.3, psdwc70.cab running on a win95/98 machine.

Resolution: Not a PB bug but a third party product bug with the Java plug-in software.

Fixed in PowerBuilder 8 build 9626.

In comparing if strings in DataWindow expressions are equal, trailing blanks
are trimmed before the comparison is made.

Spaces at the start of a string are not trimmed (no left trim).

If trailing spaces are supposed to be significant in an expression then use a different expression like:

if(col1 + "<" = col2 + "<", 1, 0)

Workaround:
use the ShareDataOff() in the close or closequery event of the window

Not a Bug.

See Documentation CR 289714 for details.

following message displays:

Warning: The authenticity of this content cannot be verified, therefore it cannot

be trusted.

Problem listed below.

Thest test root has not been enabled as a trusted root.

April �03

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

R0094 Corba System Exception : Corba_comm_failure ...

The error in the orb logfile :

** exception ** | number = 18, reason = Bad string value, offset: 16, length: 72251, buffer length: 262144

Reviewed by PB Engineering:

This is not a PB bug. The problem was resolved by using the libjcc.dll from the EAServer installation.

the navigate or navigate2 method is called.

The webbrowser control (shdocvw.dll) is version 5.5.

Using the following code:

ole_1.object.Navigate(ls_directory)

April '03

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

When adding an attribute to a node, there needs to be a way to specify the presence (e.g., #REQUIRED).

Instead the functions return ????-??-?? (GetDynamicDate) and -1 (GetDynamicNumber) which is not in accordance with the documentation.

GetDynamicString returns an empty string in case of an error as expected.

"Where PowerBuilder maintains the library search path"

It states that the application's library search path is stored in the Application section of the initialization file (pb.ini)

In PB 8.0 this is no longer the case - the search path is a target property and is kept in the target file (.pbt)

WORKAROUND: You can double click on the element to bring up the Datawindow Control Reference dialog, and select a replacement, then click ok. You do not need to delete the current element first using this approach.

Versions and Build #s Tested: 7.03/8.01.8004 -> 8.01.9121

Comments:

If a new parameter is added to an existing user event then it is only added to the method declaration at the start of the object source and not to the actual method code later on in the source file.

Example

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

forward

global type nvo from nonvisualobject

end type

end forward

global type nvo from nonvisualobject

event type string ue_repro ( string stringparm )

end type

global nvo nvo

event type string ue_repro();return "" <-----NEW PARM NOT THERE

end event

on nvo.create

call super::create

TriggerEvent( this, "constructor" )

end on

on nvo.destroy

TriggerEvent( this, "destructor" )

call super::destroy

end on

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

If this nvo is created from new with that parameter then it is saved correctly.

Big problems can arise with inheritance when there are calls to this event (even after regenerating) - it crashes PB and can be difficult to find out what's causing the crash (in the painter the parameter is visible so cause is only visible if the object is exported)

This only affects user events not object functions.

November 25, 2002

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

Problem only happens when creating a crosstab datawindow that consist of two tables.

April '03

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

Select Error: SQLSTATE = 01000

[Sybase][ODBC][Adaptive Server Anywhere] General warning: Null value eliminated

in aggregate function

Is causing a retrieve to fail in Powerbuilder. Problem happens when using an

aggregate function in a select:

select max(termination_date) from employee

Works ok in ASA 8.0 (build 2065). Upgraded to ASA 8.0.1 (build 2600) and problem started happening.

The powerbuilder trace shows the following:

8877d80): select max(termination_date) from employee (172 MilliSeconds)

(8877d80): BIND SELECT OUTPUT BUFFER (DataWindow): (94 MilliSeconds)

(8877d80): ,len=30,type=DATE,pbt=7,dbt=0,ct=0,prec=0,scale=0

(8877d80): EXECUTE: (0 MilliSeconds)

(8877d80): FETCH NEXT: (109 MilliSeconds)

(8877d80):

Error 109 (rc -1) : SQLSTATE = 01000

[Sybase][ODBC Driver][Adaptive Server Anywhere]General warning: Null value eliminated in aggregate function

(8877d80): CANCEL: (110 MilliSeconds)

(8877d80): ROLLBACK: (0 MilliSeconds)

(8877d80): CANCEL: (0 MilliSeconds)

in PowerBuilder 8 GA and higher.

Work-around is to post the scrolltorow call of the other datawindow.

Workaround:

use the tab key to edit the dropdownlistbox for the datatype

display as an input field when the taborder is > 0. The computed field has a

combination of html tags and referencing a column.

"<B>" + col1 + "</B>"

AFLIB Message: 18209/11/0: Transaction::Commit(): Transaction was marked ABORTONLY - Aborting!

In the following situation...

A simple webdw in a jsp which retrieves 1000s of rows - this ensures a retrieve will take several seconds. If during the retrieve the refresh button is hit repeatedly before the page has had time to refresh completely then more and more DataWindow/HTMLGenerator80 component instances get instantiated (monitor the dw component in Jag manager)until finally the above error appears in the log, several components remain activated and subsequent connections give errors in log file and in jsp default error page. Need to reboot Jaguar to continue.

This seems to happen when failed HTTP communication happens repeatedly (hitting refresh before prior retrieve has completed). The following error also always shows up later...

"SRVLIB Message: 16240/10/0: Net-Library routine net_write() failed in

srv_rawwrite Network error: status = 29 - Net-Library operation terminated

due to disconnect"

Could be related to CR 273170. BUT unlike CR 273170 this problem happens with pooling on and off. It also happens if component is stateful or stateless. But the error in log is the same and the fact that instances remain instantiated after the failure.

==========================================================

Update:

The cause of this error turned out to be the same as for CR 265392 -> Calls to function SetLibraryList() in the HTMLGenerator80 component. Removed all calls to SetLibraryList from the component and the error no longer occurs.

See CR 265392 notes for information on this CR and how it is being fixed.

The following is the documented behavior from the User's Guide but it does not work as described. When the control panel is set to have the euro symbol('€') as the currency symbol a mask ( or format) of $###,##0.00 comes out as $000,034.80 and when the the dollar sign is set as the currency symbol with the same mask the decimal number is displayed as $34.80. The display is wrong for two reasons according to the documentation below, first the $ is not being replaced by the euro symbol and secondly with the euro symbol the leading zeros are not being suppressed. If the mask does not contain the '$' then regardless of the currency symbol set in the regional settings the mask/format work as expected.

If [Currency], [Currency(7)] or [Currency(n)] are used then the display is correct as far as the currency symbol is concerned but the display also picks up all the other regional settings and the customer cannot control how many decimal digits are displayed. For this reason they want to use either a format or an edit mask.

Documented behavior from PB 8 User's Guide (pages 610 - 611):

Number and currency settings

So that an application you build will run the same in whichever country it is deployed, masks (used in display formats and edit masks) and DataWindow expressions require U.S. notation for numbers. That is, when you specify a number in a DataWindow expression or in a number mask, a comma always represents the thousands delimiter and a period always represents the decimal place. You should also always use the $ sign to represent the symbol for currency.

At run time, the locally correct symbols are displayed for numbers and currency. The comma and period are replaced by the delimiters defined in the user's Number settings in the Regional or International Settings property sheet in the Control Panel. The $ sign in the mask is replaced by the local currency symbol as defined in the user's Currency setting in the Control Panel. For example, in countries where a comma represents the decimal place and a period represents thousands, users will see numbers in those formats.

March '03

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

The exception Integer division by zero.

(0xc0000094) occurred in the application at location 0x734a2f70.

Debug:

Unhandled exception in pb80.exe (WTFRAMESET80.DLL): 0xc0000094: Integer Divide by Zero

Is this a bug or merely a change in behavior? Real easy workaround is to simply save the composite in PB 8 and then add the additional reports.

For example, if the function was created by use tsdata and called test, the function will be listed as: tsdata.test and tsdata.test.test

Per Development:

"If you connect to Oracle8i server, o90 driver works fine, so this is an Oracle9i Server bug. For instance, connect to Oracle9i and execute the syntax with SQL PLUS:

select distinct package_name from sys.all_arguments where owner = 'TSDATA' and package_name is not null;

You will find the wrong resultset that includes procedure and function names, and that results in the problem in the CR."

April �03

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

April '03

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

For example, setting the paper orientation from default to landscape causes the following message to appear in the easerver console:

relocation error libprnt42-g.so unreferenced symbol WuSysColormap

The page does print ok but it prints to portrait. Changing the orientation in the dwprint.ini to landscape will work ok.

Work-around is to just call the function GetNativePointer when opening the window or

in the create event of the OCX.

Do not use the corresponding ReleaseNativePointer function.

Happens also with tkwmappbook.ocx TASK Talk AppointmentBooker OCX.

workaround:

set the PictureMaskColor to "WndBkrnd"

A regression starting in 8.0.1 build 9121.

component in easerver to do a datastore.print() and no dwprint.ini file is found.

PER DEVELOPMENT:

This is not a bug, but is a difference in behavior between IE and Netscape due to the lack of support for absolute positioning in Netscape.

Here are some of the developer comments:

An HTML datawindow is generated differently for Internet Explorer and for Netscape. For

Netscape a table is generated, because it does not support absolute positioning, but for IE absolute positioning is used. Therefore it is quite likely that we find differences in behavior. If you view the output generated for Netscape on IE you'll find that the focus does go to the image.

There is no special code generated for IE from PB to stop the image from gaining focus. It is one of the many differences, between HTML supported by Netscape and IE, that cannot be helped.

Keywords: gpf gpfs crash crashes

If an object is already open in a painter and the user right clicks on that same object in the system tree and selects "Edit Source", nothing happens. Instead PB should either:

1. Disable the "Edit Source" option for that object if it's already open in a painter. OR

2. Attempt to close the object that is open in the painter and then open the object in "Edit Source" mode. If there are unsaved changes to the object, the user should be prompted to ask them if they want to save them, abandon them, or cancel the "Edit Source" request.

PSE - 8/26/2002 - Per development, this cr is not a bug, and the product behavior will not be changed because of the risks and complexity of the request.

The following is a workaround of modifying the width and height of the dw control and triggering the resize event. In order for this to work, use:

dw_1.modify('create text(band=detail alignment="0" text="NEW TEXT" border="2" color="0" x="1111" y="4" height="64" width="11334" font.face="Arial" font.height="-10" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" moveable=1 )')

dw_1.height=dw_1.height + 5

dw_1.width=dw_1.width + 200

dw_1.height=dw_1.height - 5

dw_1.width=dw_1.width - 200

dw_1.triggerevent(resize!)

April �03

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

1. If I implement a fix in an object, it would be real nice if PB could determine whether the fix has an effect on other errors, and fix those

errors.

2. The error line points to a specific object. If I could right-mouse click on the error line and have an option for Regenerate which, if the error was fixed, would remove that particular error from the output window, maintaining my current position. This way I could go through an error list and fix errors one by one, Alternatively, give me the ability to generate todo list items directly from the output window.

a) be able to suppress certain messages from the Output Window such as Rebuilding Type and Generating messages by object.

b) have a summary at the end that indicates how many errors were found for each type of error (warning, error).

c) Have a quick link to get back to the first error from this batch (if output window is not set to CLEAR, it concatenates. Get next error will

start at the beginning.

d) Be bale to automatically clear the output window conditionally (Full Rebuild or Deploy for example).

1. It opens the object that contains the error

2. It opens the source for the objct that contains the error.

3. It displays an error message indicating that the object has been

successuflly migrated but must be regenerated.

The first two options work very nicely, but I don't understand why the third one appears. Either open the source for the object, or, at the very least, position me in the System Tree to the object in question so the user does not have to go hunting for it.

From the documentation the function: "Determines the width of a string using the current font of the specified print job. Returns the width of string in thousandths of an inch using the current font of rintjobnumber if it succeeds and -1 if an error occurs."

If the string width results in a number larger than the standard integer limit of +32767 ( 32+ * 1000) then the value that is returned is not accurate (integer overflow occurs) but no error is returned to the user. With the example using a long, customers would assume that the return value could be up +2,147483,647. This has resulted in at least one customer believing that they could parse a long string using this function.

So, either this is a bug and the return value needs to be changed to a long or if the return type is confirmed to be an integer, the example in the help files in PB and in the written documentation in the Powerscript Reference guide need to be changed.

This is a PowerBuilder 7.03 only regression in build 10100 and larger.

The problem did not occur in PowerBuilder 8.0.2 Build 9506.

December 18, 2002

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

are still responding to events like mouse move etc.

December 17, 2002

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

PB build 9224 and 9506

EAS 4.1.1

Using the CtsComponents/MessageService components in EAS.

When calling the publish method on the MessageService object

cms.publish(topic, msg, 0);

and one of the properties of the MessageObject (msg) is a Blob (from PB) or Byte (from Java) it fails with a CORBA.MARSHAL error :

May 20 12:00:36 2002: org.omg.CORBA.MARSHAL: read_string: length = 0 minor code: 0 completed: No

May 20 12:00:36 2002: at com.sybase.CORBA.iiop.InputStream.read_string(InputStream.java:317)

May 20 12:00:36 2002: at CtsComponents.MessageHelper.read(MessageHelper.java:20)

May 20 12:00:36 2002: at com.sybase.CORBA.cts._sk_CtsComponents_MessageService.invoke(_sk_CtsComponents_MessageService.java:539)

May 20 12:00:36 2002: SystemException: MARSHAL (CtsComponents/MessageService/publish - @158.76.131.47)

viewing a stored procedure in the "select stored procedure" view, is truncated.

The datawindow works ok. When selecting the stored procedure, the select box

will show the stored procedure that was just selected. Using the ASE ODBC driver,

the stored procedure is truncated in that view.

April '03

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

In the "Changes between Beta 1 and Beta 2" topic, a change to the PBX_GetDescription method is described, however, the "PBNI application example" topic still uses the old syntax.

Also:

In the "Required methods in the PBNI module" topic, the signature of the PBX_GetDescription() function is wrong -- it is using a PBXRESULT returnvalue instead of an LPCTSTR:

PBXEXPORT PBXRESULT PBXCALL PBX_GetDescription(); // wrong

PBXEXPORT LPCTSTR PBXCALL PBX_GetDescription(); // right

At this time PB7.x and PB8.x product releases support Microsoft SQL Server 6.x, 7.x and 2000 databases (see research section below). Thus the PB database profile dialog is incorrect because customer could have installed any of the supported MS SQL Server versions.

The db profile "Preview" tab shows the incorrect 'database connection syntax' and the trace utility documentation i.e. pbtrace.log would also be incorrect.

There are 2 areas in the graphical user interface where the text is misleading.

1)PB db profile dialog title displays:

Database profile setup - Microsoft SQL Server 6.x

b)Db profile "Preview" tab, the setting for SQLCA.DBMS displays:

SQLCA.DBMS = "MSS Microsoft SQL Server 6.x"

With PB 8.02 build 9596 the crash is ...

0x10bb02fb referenced memory @ 0x00000000 - memory could not be read

Some additional tests in PB 8.0x

- Destroy col + SetFullState (no dddw in dw) -> No data is passed

SetFullState returns 2 the

first time and 1 the next time

- Do not destroy col + dddw in the dw -> Works correctly

- Create dddw dynamically + destroy col + SetFullState -> Crash

In PB 7.0x the behaviour is the same except that instead of crashing it fails to pass the data to 2nd dw.

Getting Started

PowerBuilder 8.0 windows to work

If he changed the

Lesson 12 - Add a dataWindow to an existing Web page

page273, is incorrect. Customer reported that he needed to change the properties to use the Jaguar component and this solved issue.

Alternatively, I found that adding the PBL to the system path in order to get the tutorial to work.

modify ( "column_name.initial = '432'"). This corrupt the editmask and you're unable to enter the complete values into the mask.(432- - - - ) without modify and (432----) after modify the inital property.

Workaround: use blanks in the initial string to fill the characters

modify ( "column_name.initial = '432 '")

May �03

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

Workaround: use PostEvent instead of TriggerEvent

greater than 32000, the value is reset to 32000.

Limit=0 means the maximum number. The text column limit should be able to be set up to

32767 (according to online help).

May �03

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

PowerBuilder Engineering found that the problem is in the ODBCJT32.DLL version 4.0.6019.0.

Earlier versions of this dll work. And with the newer version the same problem occurs in Visual Basic. So the problem is not with PowerBuilder. If possible go back to the earlier version of the ODBCJT32.DLL that works correctly. We found that version 3.51.1713.00 works correctly. If this is not possible then the following workaround should also allow you the access the files corretly:

1) Add a .txt extension to your files

2) Modify the schema.ini file so that the profiles reflect the .txt extension

3) Modify the pbodb70.ini to set PBTableDot=1

[Text ODBCJT16]

PBNoCatalog='YES'

PBSyntax='CORE_SYNTAX'

PBDateTime='DEFAULT_DATETIME'

DelimitIdentifier='YES'

PBFunctions='TEXT_FUNCTIONS'

PBTableDot=1

[Text ODBCJT32]

PBNoCatalog='YES'

PBSyntax='CORE_SYNTAX'

PBDateTime='DEFAULT_DATETIME'

DelimitIdentifier='YES'

PBFunctions='TEXT_FUNCTIONS'

PBTableDot=1

4) Modify the DB profile to uncheck "Enclose Table and Column Names

in Quotes" (or add following in connectstring: DelimitIdentifier='No').

May �03

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

doesn't work properly anymore since Build 10100 of PowerBuiler 7.

The problem is also in PowerBuilder 8.

No Workaround

This also happens when Retriev on Preview is enabled in the painter, but no rows are yet

retireved.

Workaround:

Either close the preview window, or retrieve the rows first when creating the ole object.

The problem occurs if the datawindow has got focus and then the user clicks on another editable control on the window object e.g. singlelineedit, multilineedit, editmask or RichTextEdit. The powerscript in the new control getfocus event does not get triggered.

Sometimes Powerbuilder software does abort and causes screen display distortion problems in the other open window applications (possible memory leak).

Workaround:

Use mouse buttons to vertical scroll and select a ToolbarItemName icon instead of keyboard arrow keys to select choice of icon from dropdownlistbox.

May �03

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

Applying RowsMove with as target a shared datawindow

can cause a crash.

Work-around is to remove the share before the RowsMove()

browser when dragged/dropped onto the browser.

This behavior was seen in all versions and builds of PB 7/8/9 tested and this may turn out to be either a documentation issue and/or an enhancement request.

May �03

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

Please change the behavior so that one can see the entire text while inputting. Please also change the behavior so that one does not have to do a setRedraw() before and after the text is input to have the columns below this redraw once text is input.

This behavior was seen in all versions and builds of PB 7/8/9 tested and this may turn out to be either a documentation issue and/or an enhancement request.

This behavior was seen in all versions and builds of PB 7/8/9 tested and this may turn out to be either a documentation issue and/or an enhancement request.

May �03

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

Right mouse click on target, selected properties. The ddlb, only shows *.pbl.

Uninstalled beta2 and installed PB 9.0 beta 3 (build 3501) that is when the

problem appeared.

January 14, 2003

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

if using the dropdown listboxed (for instance "department" and uncheck "Admin")

the filter of the "Admin" part of the datasheet does not work.

No Workaround

Versions and Build #s Tested: PB8 Build 9121 OK; PB7 10193 OK

1) The markers both in the datawindow graph and in the legend are no longer in colour, but are drawn in black.

2) For the top series no line is drawn where they should be one. This series has no first

point which may be related.

Both problems where found in PB8.0.2 Build 9242, 9242, 9608

Only the second issue was found in PB7 Build 10197.

workaround: diable "retrieve as needed"

following error:

---------- Deploy: Deploy of target Target1

Target1DeployConfiguration1:

Building...

Target1 - 0 error(s), 0 warning(s)

Deploying...

Generating WAR File...

Delivering WAR File...

Deployment Successful - c:\TEMP\Target1.war WebApplication Target1 was successfully installed into Server Jaguar

Target1 Deployed - 0 error(s), 0 warning(s)

DeployConfiguration2:

Building...

Untitled.jsp

web.xml

Target1 - 0 error(s), 0 warning(s)

Deploying...

Error: Could not create file.

Target1 Deployed - 1 error(s), 0 warning(s)

---------- Finished Deploy of target Target1

In JagManager, the Webapplication of Target1 shows up, but the jsp page does not.

Checking the Repository, the jsp is installed under the webapplication folder.

Tried deploying the war file using the jagtool, results in the same problem.

Jagtool will return that the "WebApplication Target1 was successfully installed into

Server manager", but the jsp page does not show up in JagManager.

May �03

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

When using a number coltype column to retrieve or update a decimal column in an

ASE database then the fractional part gets lost.

This happens using the native SYC driver, but not when using ODBC.

When the datawindow painter creates the datawindow, then it will create it with

coltype decimal(..) not with coltype number.

CheckOutInfo

CheckOutPreview

ORCA_CheckInEntry

ORCA_CheckOutEntry

ORCA_CheckOutEntryList

ORCA_CheckOutPreview

Comments:

In the ORCA PB 9.0 doc I only found listed as obsolete:

PBORCA_CheckOutEntry

PBORCA_CheckInEntry

PBORCA_ListCheckOutEntries

loose focus event of a datawindow.

The crash occurs if the editstyle of the first column is a radiobutton or

checkbox; not on a normal edit column.

The problem can be platform dependant.

[2002-01-22]

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

For example:

when the DW dataobject property is null (i.e. no dataobject is assigned to the datawindow/datastore), the behaviour is the following :

dw_1.InsertRow(0) // Return -1 in 802, previouslly returned 0

dw_1.AcceptText() // Return -1 in 802, previouslly returned 1

dw_1.Retrieve() // Return -1 in 802, previouslly returned 0

dw_1.GetitemString( 1, 1) // Return null in 802 previouslly the app failed

dw_1.Update( ) // Return -1 in 802, previouslly returned 1

dw_1.SelectRow ( 1, TRUE ) // Return -1 in 802, previouslly returned 1

dw_1.DeleteRow ( 0 ) // Return -1 in 802, previouslly returned 0

Status Update: 02/02/2004

The descriptions of methods have been updated. Can be verified in PB 9.0.1 help files. Also added the following to the Migration Issues section in the PB 9.0.1 release bulletin and the PB8.x readme:

May �03

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

This would also apply to datawindow text objects. So if you retrieve data that includes an ampersand, "mydata&" if you use that data to set the value of a text object in the datawindow, it will display as "mydata_" unless you concatenate on an extra ampersand. You would instead want to set the text control to "mydata&"+"&" which will result in a display of "mydata&".

appears blank.

Workaround:

Specify a sort order sufficient to ensure the order you want in the psr.

May �03

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

Solved by PB Engineering:

Fixed in PB 7.0.3 EBF builds 10227 and greater.

NOTE: The same problem had previously been reported for PB 8.x (see CR 279797) and had already been fixed in PB 8.0.2 EBF builds 9601 and greater, including the 8.0.3 (9704) Maintenance Release, and the PB 9.0 codeline.

May �03

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

May �03

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

- column which has edit style - DropDownDW

and

- is a secondary datawindow for function ShareData()

and

- a call is made to datawindow GetSQLSelect() on the secondary datawindow.

NOTE: I suspect this is unsupported but in that case the documentation for SaveAsAscii should be updated to include limitations depending upon datawindow style.

May �03

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

Enumerated value Numeric value Meaning

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

Excel! 0 Microsoft Excel Version 2 format

Excel5! 14 Microsoft Excel Version 5 format

Customer request to support latest Excel file format. e.g. Office 2000 - Excel 9.0, Office XP - Excel

in the error - [IBM][JDBC Driver] CLI0611E Invalid column name. SQLSTATE=S0022:

Exception

Jul 17 10:28:28 2002: in thread

Jul 17 10:28:28 2002: "Thread-2"

Jul 17 10:28:28 2002:

Jul 17 10:28:28 2002: COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0611E Invalid column name. SQLSTATE=S0022

Jul 17 10:28:28 2002: at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.rsException(SQLExceptionGenerator.java:585)

Jul 17 10:28:28 2002: at COM.ibm.db2.jdbc.app.DB2ResultSet.findColumn2(DB2ResultSet.java, Compiled Code)

Jul 17 10:28:28 2002: at COM.ibm.db2.jdbc.app.DB2ResultSet.findColumn(DB2ResultSet.java:2083)

Jul 17 10:28:28 2002: at com.sybase.powerbuilder.jdbc.PbjdbcRowSet.GetColumnInt(PbjdbcRowSet.java:405)

In the jdbc log,

SQLException: SQLState(42601) vendor code(-104)

COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token "END-OF-STATEMENT" was found following "select 1". Expected tokens may include: "<table_expr>". SQLSTATE=42601

at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java, Compiled Code)

at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:186)

at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:419)

at COM.ibm.db2.jdbc.app.DB2Statement.execute2(DB2Statement.java:411)

at COM.ibm.db2.jdbc.app.DB2Statement.executeQuery(DB2Statement.java:333)

at com.sybase.jaguar.jcm.JCMCache.pingConnection(JCMCache.java, Compiled Code)

at com.sybase.jaguar.jcm.JCMCache.getProxyConnection(JCMCache.java, Compiled Code)

at com.sybase.jaguar.jcm.JCMCache.getConnection(JCMCache.java:1588)

at java.lang.reflect.Method.invoke(Native Method)

at com.sybase.powerbuilder.jdbc.PbjdbcSession.CreateJaguarSession(PbjdbcSession.java:444)

SQLException: SQLState(S0022) vendor code(-99999)

COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0611E Invalid column name. SQLSTATE=S0022

at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.rsException(SQLExceptionGenerator.java:585)

at COM.ibm.db2.jdbc.app.DB2ResultSet.findColumn2(DB2ResultSet.java, Compiled Code)

at COM.ibm.db2.jdbc.app.DB2ResultSet.findColumn(DB2ResultSet.java:2083)

at com.sybase.powerbuilder.jdbc.PbjdbcRowSet.GetColumnInt(PbjdbcRowSet.java:405)

May �03

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

PB 7.03 build 10197

In library painter, when selecting all the objects in a pbl containing many objects (eg PFC pfcapsrv.pbl) the vertical scrollbar 'jumps' up and down briefly while PB is selecting the objects. Once they are all selected everything returns to normal

either using file/open page/choose file or using the url of http://localhost/ActivitiesLog.psr.

Update:

This turned out to be a dupe of CR 287063. Verified as fixed in PB 8.0.2 EBF Build 9620.

Workaround:

Send a sting over to the database and then convert it to decimal:

SELECT my_test.id_msg,

my_test.msg_text

FROM my_test

WHERE my_test.id_msg = convert(decimal(16,0),:arg)

May �03

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

See repro steps for more details.

This only happens if the Windows Control Panel option "snap to default" for the mouse settings is selected.

This includes characters like the pound and euro sign and affects many customers.

EAServers codeset setting is set to UTF8. (also clients are set to ORBCodeSet='utf8').

For the same component written in PB it works correctly.

Affected are characters that are outside of the 0-127 ascii range.

Update / Solution:

change ORBCodeSet to cp1252 and EAServer codeset to cp1252 , test this issue again using PB804 10501 on Solaris and PB804 10535 on WinNT , pound and euro sign can be displayed properly

alignment is set to Right! and edit mask has spin set.

Works ok in PB 8.0.2 (build 9601).

January 14, 2003

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

In beta3 the second argument was changed to a boolean to indicate whether tracing should be turned on or not; however, by substituting this argument for the properties array (in which turning tracing on was also an option), we have eliminated the capability to provide other initialization arguments to the JavaVM.

If possible, this should be corrected before public beta.

The problem seems to be related to the declaration of a global array of structures. However this is not reproducible in a simple test case. Optimizing the PB 7 PBLs before the migration also solved a problem with a different structure declaration.

upgrading from 11.1.1 to 11.1.1 EBF 10181 and 12.5 to 12.5EBF 10205.

Works ok in the following:

11.1.1

11.1.1 EBF 7886

12.5

RESOLUTION: So the bottom line is that a change is required on the server as well when using newer versions of OpenClient. If the server is upgraded to an EBF after about October 2001, you shouldn't see this problem anymore.

This is a regression after PB8.0 GA. Have verified that this is a problem for Powerbuilder 8.0.2x. This is not a problem in Powerbuilder 7.x

it in the format of <prod_month>2002-04-01T00:00:00</prod_month>.

When you try to import the xml file into powerbuilder, you get a

Item '2002-04-01T00:00:00' does not pass validation test

Item validation error on IMPORT. Continue IMPORT?

Import File Failed.

For getting around those problems it is mentioned in the documentation i.e. PB 8 Users Guide , page 609 ff.

(Chapter 19) that when you have special characters to display in the mask you need to precede it with a backslash.(\).

More examples should be documented.

Resolution:

Added the following to the usage section of the string function for PB8 and PB9 sources:

To display additional characters as part of a mask for a decimal value, you must precede each character with a backslash. For example, to display a decimal number with two digits of precision preceded by four asterisks, you must type a backslash before each asterisk:

dec{2} amount

string = ls_result

amount = 123456.32

ls_result = string(amount,"\*\*\*\*0.00")

The resulting string is ***123456.32.

Also added this to the Mask property description:

To display additional characters as part of the mask for a decimal value, you must precede each character with a backslash. For example, to display a decimal number with two digits of precision preceded by four asterisks, you must type a backslash before each asterisk: \*\*\*\*0.00

The application was migrated from PB 6.5 (based on PFC 6.5).

The Full Rebuild in system tree works fine. The Exe generation from the project painter gpfs in PB80.exe at 0x10c8896f referenced memory at 0x00000002 ....could not be read.

Workaround exists:

1.) Do a Full build in the system tree

2.) Perform an incremental build in the project painter.

Solution to the problem:

The exported source for f_setplatform was actually the source for an 'empty' object prf_n_cst_dwsrv_querymodeattrib inherited from pfc_n_cst_dwsrv_querymodeattrib.

A valid version of f_setplatform already exists in PFCAPSRV.PBL so I deleted the one in PRFDWSRV.PBL.

There was no prf_n_cst_dwsrv_querymodeattrib in PRFDWSRV.PBL although this pbl contained descendents of all the classes in PFCDWSRV.PBL so after inheriting a new version of prf_n_cst_dwsrv_querymodeattrib from pfc_n_cst_dwsrv_querymodeattrib the

Application now compiles OK.

04/25/2005:

This CR was reviewed and closed as part of the Quarterly CR Review process. It is "Not targeted for any future release". Also note: engineering could not reproduce.

Versions and Build #s Tested: 6.0/7.03/8.0GA->8.02.9620

Comments:

dw_primary.ShareData (dw_secondary) fails (returns -1) if before calling ShareData a column is destroyed in the primary datawindow using Modify and the secondary datawindow is created dynamically using Create() which takes the syntax from the primary dw (using Describe).

In code...

dw_1.Modify('DESTROY COLUMN b')

dw_1.Modify('DESTROY b_t')

dw_2.Create(dw_1.Describe('DataWindow.Syntax'))

MessageBox('ShareData',dw_1.ShareData(dw_2)) <------ ShareData fails

to utilise/ support timestamp microseconds when performing a value comparison.

This enhancement is needed because sometimes the developer is required to cast/ store a 'datetime' value into a Powerbuilder datatype 'ANY'; The advantage of this enhancement would be that a Powerbuilder developer would then have better accuracy when evaluating timestamp values. This is an important feature for data security and database locking schemes which utilise timestamp datatypes to interrogate rows.

e.g. Adaptive Server Enterprise, Adaptive Server Anywhere, MS SQL server etc.

Powerbuilder datatype: Datetime

===================================

A standard data type that is a 'date' and 'time' in a single data type.

PowerBuilder and InfoMaker use the 24-hour time format:

hh:mm:ss:ffffff (hours:minutes:seconds:microseconds)

Versions and Build #s Tested: 8.0 GA - OK

8.02 build 9506

8.02 build 9601

Comments: Hitting save after entering code for a webdw DTC in a simple web page (comments will do) will crash PB if there are 2 datawindows on the page. No message, PB just vanishes.

Only crashes with code in DW DTC and when there are 2 or more dws on the page.

May �03

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

May �03

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

Workaround:

You can leave the parens out, they are not needed. Or you can fix the sql in the syntax mode.

May �03

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

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

May �03

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

Workaround is to pass a 0 to PEOutputToWindow as the last parameter instead of passing the parent window handle.

PER DEVELOPMENT: The crash is solved by CR 291696. Remaining problem is user error. In order to pass a window handle, it cannot be an MDI window. If you change the window to Main it should work.

workaround:

before doing a SetFullState just reset the dataobject of the RTE Datawindow like this:

dw_rte.dataobject = ""

dw_rte.setfullstate(my_rte_blob)

In Powerbuilder 7:

Modal dialog of Powerbuilder application error is displayed. Powerbuilder application is halted.

'Response' window does not display.

In Powerbuilder 8:

The 'response' window is processed and displays on the screen. When the user clicks on the window, then the modal dialog of Powerbuilder application error is displayed. Powerbuilder application is halted.

Ulong val

val=2200000000

insert into t_ulong(c_ulong) values(:val);

The value stored in the table is "-2094967296" which corresponds to the value when converting ulong to long datatype. There seems to be a invalid datatype promotion.

January 14, 2003

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

Workaround:

map the pbm_windowposchanged of the window and add the following codeline:

dw_1.setcolumn(dw_1.getcolumn())

because the cursor snaps to the center every time you change the tab, and the computed field gets dragged to the right.

May �03

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

Using Excel! as the SaveAsType value results in misleading error messages from Word. Using Excel5! as the SaveAsType results in no error messages, but the spreadsheet does not display in the Word document.

Closed as Duplicate of CR 290039 (see that CR for future updates).

Powerbuilder makes no difference between designtime and runtime and hence always checks for the license file.

Errormessage when a deployed PB app exe is being run: "Couldn't find license file"

January 14, 2003

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

May �03

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

May �03

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

with the following error:

Sybase Heap Manager Error:

parent: block was previously freed

----------------- Block Prefix

05FAEF30: FFFFFFFF5090B205E857021210310106 ....P.|.FW...1..

____________________________________________________________________________

___

----------------- User Buffer

Sybase Heap Manager Error:

----------------- Data Type and Source File Information

size: block was previously freed

05FAEF40 child (size 268435456)

----------------- Block Prefix

____________________________________________________________________________

___

1276F7D8: EF1DC4AB68045412E083AF11D081ED04

n.-1/2h.T.a.>.-.f.

----------------- User Buffer

1276F7E8: 646174616261736500F34705676500ED database.=G.ge.f

----------------- Data Type and Source File Information

1276F7E8 child (size 16)

Now checking all other heap blocks...

____________________________________________________________________________

___

Sybase Heap Manager Error:

check: invalid guard prefix (address: 12767A00)

----------------- Block Prefix

12767A00: 00000000000000000000000000000000 ................

----------------- User Buffer

12767A10: 0000000000000000 ........

----------------- Data Type and Source File Information

12767A10 parent (size

OS: Problem happen on all windows Platform.

Versions and Build #s Tested:

PB Version Allow Scrolling in preview when return empty resultset

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

PB5.0.04 EBF3 Yes.

PB6.5.1 bld 1326 No.

PB7.0.3 bld 10183 No.

PB8.0.1 bld 9087 No.

PB8.0.2 bld 9601 No.

May �03

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

look at the Edit menu. Not all shortcuts are defined. Only some are working.

Missing shortcuts: ctrg+z ctrg+c ctrg+v ctrg+x ctrg+f ctrg+g

Stored procedure which has argument as tinyint does not retrieve in DB painter nor as stored procedure source datawindow. Using the MSS database driver it works fine. A regular Datawindow which uses same table and same argument works fine.

of type 'number array' causes the following errors:-

With datawindow : DataWindow.Retrieve({1,2}) causes "Retrieve argument 1 does not match expected type"

With dataStore : DataStore.Retrieve({1,2}) causes GPF

However Powerbuilder application works correctly if executed :

-in development environment

or

-if compile an application to PBD (pcode).

May �03

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

PB Engineering has determined that the cursor must remain open for this to work. If it is closed the resulting GPF is not a PB problem but an Oracle problem.

but is reused when you open the sheet and fill the dw a second time.

Occurs with PB Builds (9603 and higher) becuase there we are using a new heap manager.

This is a feature!

When PB frees memory, the new heap manager will return the memory back into its pool. Memory doesn't go back to OS.

no workaround

Still a problem in 8.0.2.

May �03

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

The only way so far was getting the crashhandler output when the users where alt+tabbing between the pb app and another application.

Here is the crahshandler output:

Exception code: C0000005 ACCESS_VIOLATION

File Name: C:\7310180_ch\PBVM70.dll

File Version: 7.0.3.10180

Fault address=1132A3A3 Section:Offset=01:001093A3

Registers:

EAX:00000000

EBX:032A7B60

ECX:01690ED0

EDX:005602A6

ESI:001F01B0

EDI:00000001

CS:EIP:001B:1132A3A3

SS:ESP:0023:0012F7B8 EBP:0012F7CC

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

Flags:00010206

Call stack:

Address Frame Param0 Param1 Param2 Param3 Function Name

1132A3A3 0012F7CC 00000398 00000006 112EF2D0 0012F84C 0001:001093A3 C:\7310180_ch\PBVM70.dll

112EF39A 00000000 00000000 00000000 00000000 00000000 0001:000CE39A C:\7310180_ch\PBVM70.dll

OS version:

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

Memory Status:

Total physical memory: 261136K

Available physical memory: 133240K

Total virtual memory usage: 121868K / 632800K

PowerBuilder virtual memory usage: 95232K / 2097024K

Loaded Modules:

C:\7310180_ch\Pb70.exe 7.0.3.10180

:

:

May �03

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

May �03

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

[Database]

DBTraceFile=D:\TEMP\pbtrace.log

So there could also be a

DBTraceLevel=All and an option to exclude result sets, and perhaps other options as well.

May �03

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

to 0 when tabbed thru an integer field.

The problem only happens printing over network from within Win2000 workstation using HP 2000c driver.

Update:

This issue is not a bug. Customer needs to get a new printer driver from HP (dj132en.exe). This driver is both NT and 2000 compliant and then the printing will be ok.

Workaround: Use date format as parameter and convert to string, eg. using a format. See also CR 229146.

Suggestion:

HKCU/Software/Sybase/PowerBuilder/9.0/DatabaseProfiles

dialog boxes instead of the old-style user interface.

The following is from MSDN:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/winui/winui/windowsuserinterface/userinput/commondialogboxlibrary/aboutcommondialogboxes/openandsaveasdialogboxes.asp

will still have the value of 8.0 or 9.0, when a pb component deployed using pb 7.0.3, then 8.0.2 and then redeployed back in pb 7.0.3.

The following error will result in the srv.log even though the component is deployed

in 7.0.3:

Aug 20 09:35:03 2002: PB Unable to create session for n_testdwserver

Aug 20 09:35:03 2002: ERROR: OBJECT_NOT_EXIST (testpbversion/n_testdwserver/$Activate - bind)

The PB Merant ODBC files are listed.

This list should also contain pbbas15r.dll, pbflt15r.dll, and pbutl15r.dll.

Similar also database specific files with an extra "r" should be included

(pbbtr15r.dll etc..).

May �03

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

following debug messages in the jaguar console window:

Before calling winfree function

After calling winfree function

Update:

This turned out to be an ASE issue not a PB bug. Please refer to the ASE CR 294484 for further status updates on this issue.

and you open page, no warning message is given that it is read only. Its only when

you try to save changes, that a message appears.

May �03

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

The PB 9.0 workaround is to use ORCASCRIPT to perform SccRefreshTarget with the FULL_REBUILD option.

Sybase Heap Manager Error:

adopt: parent block was previously freed

----------------- Block Prefix

0692C800: FFFFFFFF309E3E050036930640361405

....0.>..6..@6..

----------------- User Buffer

----------------- Data Type and Source File Information

0692C810 child (size 268435456)

________________________________________________________________________

Now checking all other heap blocks...

Please set environment variable SYB_HEAP_DEBUG=true and re-test.

Resolution:

Dupe of CR 293930 - Engineering has determined the problem is with the Oracle client software, not PB.

Workaround: move the SELECT statement in the dberror event of the datawindow into a userevent and post this userevent in the dberror event instead of calling the SELECT statement directly in the dberror event.

Autoretrieve not working in 8.0.2, and it should not prompt for retrieval arguments when sharing to a datastore (broke in 9.0).

Verified fixed in builds higher:

PB7: 10241

PB8: 9809

PB9: 5021

em_date.text = string(today(),'mm/dd/yy')

The year that gets displayed is 0002.

When Trail Footer is unchecked than report prints out ok. There is a related bug

regarding Trail Footer, cr291571.

The original problem was reported that the composite datawindow was being cut off.

After moving the footer band down below the 'Fund Transfer Activity' box in the dw_pdr_share datawindow. Then resizing the dw_pdr_share in the d_test datawindow,

you can see the entire report except the footer.

According to the online help, when the Trail Footer property is set to yes, the footer appears right after the last line of data in the report. That is not happenning.

May �03

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

example a component whose source is not provided can be used in PBD form.

However, when rebuilding the application, you will always get error messages on the pbd objects. For pbds in the library list, can't these errors be inhibited, or made informational at worst?

Workarounds:

Use computed field with mid( c1 , L1 , L2 + L3 ) string function to calculate the value in the datawindow instead to calculate it in the SELECT statement.

or

syntaxFromSQL with calculated values in PBscript like

arg1 = 3

arg2 = 1 + 4

sql_syntax = &

"SELECT SUBSTR( Column1, " + string(arg1) +" ," + string(arg2)+ " ) AA, C1 FROM table1"

dw_1.syntaxFromSQL(sql_syntax, "", errors);

January '03

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

Say you have an ASE cluster, made of 2 ASEs. From an openclient application 12 and up, if the first ASE is down for any reason, the client will receive an openclient error, and will be routed to the second ASE server.

This is now supported by PB 8 in a pure client server config ( PB to ASE ) using the support in SYC driver.

EAS 4.11 has a new feature call open client HA connection, that allow Open Client components to FAIL over to another ASE server.

This is not supported by the SYJ driver, so that means if you have a PB component deployed to EAS that connects to ASE then there is no way for PB to get the HA alert.

This tool is currently not interacting well with dddw and ddlb.

When you tab to a dddw, the value of the field is not read until it loses focus.

Also when you tab to a dddw, then use the scroll bar to scroll either up or down, the

value will keep repeating itself.

This tool is currently not interacting well with check boxes and radio buttons.

Radio buttons and check boxes are not read.

This tool is currently not interacting well with edit mask fields.

Fields with edit mask such as ssn, dates, etc are read twice. Once when you

tab to the field and again when you tab off.

Not a PB problem. Problem is with the Oracle 8.1.7 client software. See Oracle bug IDs: 2215322, 2168232 and 2211936. The problem does not arise using Oracle9i client.

printing lines of text, not all lines of text are printed.

The return code returns 1 for success but lines of text are missing. It may be

the print cursor is not working properly.

From the online help: In a print job, PowerBuilder uses a print cursor to keep track of the print location. The print cursor stores the coordinates of the upper-left corner of the location at which print will being. PowerBuilder updates the print cursor after printing text with Print.

This may be the problem since the first two lines are missing and some text is

misformatted.

Works ok in PB 8.0.2 (build 9626).

Window with button control and an user event without arguments. After changing the event and adding a new argument, the change of the script is not applied to the window object

workaround:

edit the Source of the ancastor window and change the code from

event type integer ue();return 1

end event

->

event type integer ue(integer arg);return 1

end event

The old type definition is working as well

event type integer ue;return 1

end event

window controls to the script painter. Currently you can drag/drop window objects,

functions and events to the script painter but not window controls.

it crashes with the following error:

Unhandled exception in orcascr9.exe (shlw32mt90.dll) access violation

On pages 123, 125, 126 and 127 it shows the classid of:

CLASSID="CLSID:77771301-7777-1000-8000-08009AC61A9"

The correct classid listed should be:

CLASSID="CLSID:77771304-7777-1000-8000-080009AC61A9"

May �03

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

when running a WebDatawindow. For example, messages such as:

HTMLDW: EnableCommit()

HTMLDW: SetComplete()

The problem is that tracing is not turned on and these message still appear in the

log file.

In the nv_remote_datawindow object/of_log function (pbdwrmt.pbl) it shows the following:

pb7:

if ib_trace and IsValid(inv_logger) then

inv_logger.log("HTMLDW: " + Space(il_indent*INDENT_AMOUNT) + msg)

end if

pb8: (no ib_trace flag is included in the if statement)

if IsValid(inv_logger) then

inv_logger.log("HTMLDW: " + Space(il_indent*INDENT_AMOUNT) + msg)

end if

With the ib_trace flag not part of the if statement in pb8 or pb9, too many messages are written out to the Jaguar.log file.

In pb7 to enable the ib_trace, the com.sysbase.datawindow.trace=yes must be set.

protected columns to be out of sync when using the setrowfocusindicator.

The problem rights itself when you scroll past the unprotected row.

Even having the following in the rowfocuschanged event of the primary datawindow

doesn't appear to work (dw_2 is secondary datawindow):

dw_2.setrow(currentrow)

dw_2.scrolltorow(currentrow)

Both functions return successful return codes and the currentrow appears to be ok.

For example, if a messagebox is in the event to display currentrow, it returns row 2

when focus is on row 2.

However, the rowfocuschanging event in the secondary dw fires once when the

application starts up but doesn't fire again until after you scroll past

the unprotected row. When the rowfocuschanging event fires the first time,

it shows the currentrow to be 4 and newrow to be 0.

Reviewed by PB Engineering.

Not a Bug.

Nothing displays when the PSR is loaded into a datawindow. And a null object reference in a datawindow that loads the PSR when doing dw.Object.DataWindow.Print.Preview='Yes'

When using the PFC security service, sometimes a submenu in a

complex menu is being showed as disabled while in fact the property enabled is true.

htmlDW.rows[0] = new HTDW_RowClass( "((3 0 '1'))",0, ,"Test timestamp",1);

In this example the third argument which is the timestamp column is not set. The HTML datawindow is correctly displayed showing 0x00000001009349f1 but a script error occurs.

to-do list

May �03

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

but in different pbls, are registered with PBNative and then checked out,

one of the objects gets overwritten.

In the project folder when all objects are registered, you can see only 1

source object and 1 *.prp file. PBNative is creating two pbg files for each pbl.

For example,

test.pbw

-test.pbt

--newtest1.pbl

---w_test

--newtest2.pbl

---w_test

When all objects are registered with PBNative, only 1 w_test.srw and w_test.srw.prp

shows up in the project folder. If you check out one of the w_test, it will show

that both are checked out. When you check the object back in, and view both objects

in different pbls, you can see that they are the same. One of them got overwritten.

RESOLUTION: Not A Bug. All source code operations are done on the individual objects, not on the

PBL. For example, if a window w_test is there, the operations will be done

on w_test.srw. Since, the pbls are in same folder and we can have only one

w_test.srw file in a folder, it is natural that, w_test.srw will be

overwritten. So, users have to keep the pbls in separate folders, if they

want to use same object names and there is nothing wrong with SCC.

But the question is what is the purpose of using same name ? For example,

if a target has two pbls (app1.pbl & app2.pbl) and there is a window

(w_test) in each of them and application open event if we write

Open(w_test), it will open w_test of app1.pbl if app1.pbl is first in the

library list.

The odbc driver error message is:

SQLSTATE = S1C00

[Microsoft][ODBC driver for Oracle] Only Keyset-driven cursors are updateable

This CR is recorded as a regression in Powerbuilder v8 release because this error does

not occur in Powerbuilder v7 ;

Remarks:

==========

i) This same driver can be used by Powerbuilder v7 application and does not produce an error message.

ii) The following vendor's odbc drivers for supporting Oracle dbms do not produce an error message.

a) Oracle driver from Oracle corporation - sqora32.dll - v8.01.07 - 11 May, 2000

b) Oracle driver from Merant for Oracle 8 - pbor816.dll - v3.70.12 - 11 May, 2000

c) PB Datadirect OEM 4.10 Oracle from Datadirect technologies - Pbor818.dll � v4.10 � 22 July 2002

Resolution

==========

This issue is resolved by

1) Updating to the latest available Microsoft ODBC Oracle driver (MSORCL32.dll version 2.573.6019.0 dated 3/26/2002 and after). The latest Microsoft driver for mdac can be downloaded from :

http://www.microsoft.com/data/download_270RTM.htm

Microsoft Data Access Components 2.7 RTM Refresh (2.70.9001.0)

2) Upgrading PowerBuilder to 8.0.3 build 9809 or later.

Versions and Build #s Reported: PB 7.0.3.10213/PB 8.0.2.9642

Versions and Build #s Tested: 7.0 GA - 7.03.10213 & PB 8.0 GA - PB 8.03.9701

Comments:

Referencing a data block of rows and columns (dw_1.Object.Data[1,1,1,1]) in an external DataWindow will crash Powerbuilder when Rows To Disk option is set on. Removing Rows To Disk or not referencing a data block (eg dw_1.Object.Data[1,1]) does not give the error.

Crash with PB 8.03 build 9701 is 0x115d24d2 referenced memory at 0x00000000 - the memory could not be read.

The nested report has a 1 to many relationship.

May �03

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

WORKAROUND: change all calls in the dw clicked event of "this.SelectRow(...)" to

"this.post SelectRow(...)"

May �03

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

Resolution:

Engineering has determined the problem is with the Oracle client software, not PB.

This issue is now resolved in 9.2.0.4 and 9.2.0.3 Patch 2 from Oracle. Oracle had said it was a server-side patch, however Sybase testing has confirmed that applying the patch to the client-side alone resolved the problem.

column, it causes a validation error. When in the dw painter, the following error

appears:

Item '.' does not pass validation test.

When running an application, it causes the itemerror event to fire.

May �03

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

With PB9 build 7079 and higher, the Orcascript user can specify the following new command prior to calling scc connect:

scc set connect property password "StarTeam_password"

This, along with release 5.4.2.0 of StarTeam SCC integration software will set the user credentials silently and no dialog box will interfere with the Orcascript processing.

Versions and Build #s Tested: 8.01/8.02 and 8.03 (9701)

Database/Driver File/Version: PowerDynamo 3.5.2

Comments:

Similar behaviour to that in CR 288951 (PB 9 with 4GL JSP page) except this is with pages in Dynamo which use Dynascript. Could be a Dynamo issue?

Happens with server side script in 4GL web pages.

psPage.Alert(message) followed by...

psPage.Redirect(URL)

The alert is not displayed but the page is redirected.

Remove the Redirect() and the Alert()works fine.

Reviewed by Engineering:

This is correct behavior, if uses Redirect() function, server side Alert() will not work, if want do alert behavior, you should call alert function by client side function.

The following Jaguar.log with useHwnd=no:

Sep 11 10:58:58 2002: DEBUG: Test/n_dwcomp (create container 581)

Sep 11 10:58:58 2002: DEBUG: Test/n_dwcomp (constructor)

Sep 11 10:58:58 2002: DEBUG: Test/n_dwcomp/$Activate (bind)

Sep 11 10:58:58 2002: DEBUG: Test/n_dwcomp/getdw

Sep 11 10:59:06 2002: DEBUG: Test/n_dwcomp (destructor)

Sep 11 10:59:06 2002: DEBUG: Test/n_dwcomp (delete container 581)

Sep 11 10:59:06 2002: DEBUG: Test/n_dwcomp (unhash container 581)

Sep 11 10:59:06 2002: DEBUG: Test/n_dwcomp (unlink container 581)

Sep 11 10:59:06 2002: TRACE: Test/n_dwcomp/getdw: 8000 ms, 104 bytes in, 24 bytes out (jagadmin@199.93.182.34)

Sep 11 10:59:06 2002: SystemException: TRANSACTION_ROLLEDBACK (Test/n_dwcomp/getdw - @199.93.182.34)

The following Jaguar.log file with useHwnd=Yes

Sep 11 11:05:31 2002: DEBUG: Test/n_dwcomp (create container 581)

Sep 11 11:05:31 2002: DEBUG: Test/n_dwcomp (constructor)

Sep 11 11:05:31 2002: DEBUG: Test/n_dwcomp/$Activate (bind)

Sep 11 11:05:31 2002: DEBUG: Test/n_dwcomp/getdw

Sep 11 11:05:38 2002: DBError fired: Select error: SQLSTATE = S0002

[Sybase][ODBC Driver][Adaptive Server Anywhere]Column not found: Column 'emp_fnameX' not found

Sep 11 11:05:43 2002: DEBUG: Test/n_dwcomp/$Deactivate (unbind)

Sep 11 11:05:43 2002: DEBUG: Test/n_dwcomp/$CanBePooled (pooled)

Sep 11 11:05:43 2002: DEBUG: Test/n_dwcomp (delete container 581)

Sep 11 11:05:43 2002: DEBUG: Test/n_dwcomp (unhash container 581)

Sep 11 11:05:43 2002: DEBUG: Test/n_dwcomp (unlink container 581)

Sep 11 11:05:43 2002: TRACE: Test/n_dwcomp/getdw: 12000 ms, 104 bytes in, 26 bytes out (jagadmin@199.93.182.34)

There are other differences besides dberror that are firing or not firing with useHwnd.

They are:

useHwnd=no

dberror not firing

deactivate not firing

destructor firing

useHwnd=yes

canbepooled firing

The problem only occurs when the window is of type Popup! It is possible that this is not a bug, but is standard windows behavior for the Popup window style.

PER DEVELOPMENT: The problem application used code in the window's Moved event that tested the window state. However the Moved event occurs before the Resized event. By creating a User event that contained the code formerly in the Moved event, and using PostEvent to post it from the Moved event, the application works correctly. This was determined to be Not a Bug but requires a simple Powerscript code change.

Adding comment via checkin (with ctrl + tab's or ctrl + returns) doesn't show when trying via "Show History". It shows one whole line.

no workaround

***Update from Product Support Engineering 23/12/2003***

The issue was closed because it was found by engineering to be a bug in PVCS (third party problem).

When calling stored procedures through ODBC and using named parameters,

then the name of the parameters is not passed in the procedure call.

This cannot be worked around by setting StripParmNames or CallEscape for the connection.