Process Mapping Logo

Process Mapping - Forums

Sharing 19 years of knowledge and experience

Metastorm BPM forums
Sign up Latest Topics

  Author   Comment  

Avatar / Picture

Posts: 5,507
Reply with quote  #1 

Quoted String in Column Name in Grid Fails with Oracle

Last edited: 02 May 2005

The information in this article applies to product: e-Work


  • When using Oracle, a quoted string in the column name in a grid prevents the associated form from loading or an action from being invoked.

    For example, a grid contains the column name to_char('test'). With Oracle, but not MS SQL Server, this will fail. The browser will display the error message 'Failed to open folder' or 'Failed to invoke action', depending on where the form with the grid is being called. Although no error message is written to the e-Work Designer log, the following error message, using this example, is written to the Windows application event log:

    Unable to load xml into DOM. Error(-1072896759) : Required white space was missing. . Found at line 11, position 48 : <s:AttributeType name='c1' rs:name='TO_CHAR('TEST')'.


  • Use an alias in the column name. In this case, the column name should be specified as to_char('test') as test.

Keywords: kb551

Post an example, and we will have a much better idea what the problem is. In about 90% of posts, the problem is one of communication. Examples bridge that gap.
Previous Topic | Next Topic

Quick Navigation:

Create your own forum with Website Toolbox!