Table of Contents

Appendix B. Known Bugs and Limitations

Applicability Rules & IS UNDEFINED

Problem/Limitation Description

Using IS UNDEFINED in an applicability rule will not have the expected results when the attribute is a reference attribute.

Event.Organiser IS UNDEFINED

Work Around

Refer to an attribute on the reference attribute instead

Event.Organiser.ID IS UNDEFINED
 

Arithmetic In Find

Problem/Limitation Description

Arithmetic operations with dates are not supported in FIND action, for example using the following will not work:

FIND Account WHERE Account.Date=CURRENT_DATE-1 

Work Around

Use functions with dates (such as DATE_ADD) instead of arithmetic operations, for example:

FIND Account WHERE Account.Date= DATE_ADD(CURRENT_DATE,-1) 
 

Functions Exclusive To Cloudbase Derby

Problem/Limitation Description

The following functions are supported only in Cloudscape/Derby database:
WORD_NUMBER
WORDS_FROM_LEFT
WORDS_FROM_RIGHT

Work Around

None

 

Function Limitations In Subqueries

Problem/Limitation Description

MIN, MAX and AVG expressions are not supported if used in subqueries on groups. For example the following query is not supported if Transaction is a group:

FIND Account WHERE  (COUNT Transaction WHERE (MAX.Transaction.Amount = 1000)) 

Work Around

Avoid using these expressions in subqueries

 

Loss Of LAN Connection

Problem/Limitation Description

If the Aware IM Server is started when either LAN or Internet connection is up and then either LAN goes down or Internet is disconnected, the server goes down too

Work Around

Start the Aware IM Server within the configuration that you intend to work with. For example, if you only use dial-up Internet connection occasionally make sure that you start the Aware IM Server first and then connect to the Internet. This way when you disconnect from the Internet Aware IM will continue to work properly.

 

MS Word Document Support In Linux & Mac

Problem/Limitation Description

Documents of MS Word type are not supported under Linux and Mac OS X operating systems (MS Word XML format can be used instead if browsers are running on the Windows platform)

Work Around

None

 

Negated IN Expressions

Problem/Limitation Description

Negated IN expression is not supported in queries. For example, the following expression is not supported:

FIND Event WHERE NOT(LoggedInMember IN Event.Participants) 

Work Around

In many cases the negated IN expression can be replaced by using the equivalent COUNT or EXISTS expression, for example:

FIND Event WHERE COUNT Member WHERE( Member IN Event.Participants AND Member=LoggedInMember) = 0 
 

Printing From MS Excel In Linux & Mac

Problem/Limitation Description

Printing of documents of MS Excel type from rules is not supported under Linux and Mac OS X operating systems

Work Around

None

 

Printing HTML Documents From Rules

Problem/Limitation Description

Printing of documents of HTML type from rules is not supported

Work Around

None

 

Report Summary Pane Resizing In Mac

Problem/Limitation Description

If you drag the bottom line of the Summary pane in the Report/Presentation Designer the height of the Summary band is not changed even though it appears visually that it is.

Work Around

Change height of the Summary band using Band Properties – see Setting Band Properties

 

Report Band Resizing In Mac

Problem/Limitation Description

Dragging bands in Report Designer to change their height is not supported on Mac OS X

Work Around

Hold down Apple key and click on the band’s header to bring up the bands property dialog. Specify the height of the band in the dialog

 

Required With Owned By References

Problem/Limitation Description

If two business objects are related through a parent/child relationship (see Reference Attributes) and the reference attribute to a child is defined as “Required” it is impossible to add a new child instance from a form of the parent instance using Add New button (see working_with_references_in_the_operation_mode)

Work Around

Do not force “Required” flag for reference attributes or create child instance first and then add it to a parent using Add button.

 

Sorting References In Business Object Group Queries

Problem/Limitation Description

Sorting on reference attributes in a query will not work if query searches business object group. For example, sorting in the following query will not work if Account is business object group:

FIND Account ORDER BY Account.Owner.Name 

Work Around

Define a shortcut attribute and sort by it, for example:

FIND Account ORDER BY Account.OwnerName 

Where OwnerName is the shortcut to Account.Owner.Name

 

Undefined With Multiple References

Problem/Limitation Description

Checking for UNDEFINED value of a multiple reference attribute (see Reference Attributes) in queries does not work correctly. For example, the following will not work:

FIND Account WHERE Account.Transactions IS UNDEFINED 

Work Around

Use EXISTS or COUNT expressions, for example

FIND Account WHERE COUNT Transaction WHERE (Transaction IN Account.Transactions) = 0 
 

Unsupported Functions In Queries

Problem/Limitation Description

The following functions and expressions are not supported if used in queries:
WAS CHANGED
WAS CHANGED TO
TYPE
OLD_VALUE

Work Around

None

 

Use Of IN With Complex Identifiers

Problem/Limitation Description

IN expressions using complex identifier of the reference list are not supported if used in subqueries. For example, the following query is not supported:

FIND Client WHERE  (COUNT Account WHERE (Account IN Client.Carrier.Accounts) > 3) 

Note that the following query is supported:

FIND Client WHERE (COUNT Account WHERE (Account IN Client.Accounts)>3) 

Work Around

Avoid using such constructs in queries