OPRO X Server
Limitations

Last modified on 2004/01/13

Table of Contents

OPRO X Server

General

ID: oxs001
SubjectOXS must be started within X-Windows to support Graphs in Unix and Linux environments.
DetailSupport for Graphs in OXS is given through a java GUI based module. Therefore it needs to be started in a windows based graphical environment.
ReasonOperating system
ID: oxs002
SubjectWhen using a Linux environment, Japanese characters become garbage characters in Graphs.
DetailWhen using a Linux environment any Japanese characters placed in the Header, Footer, Series, Legend Title or Point in a Graph component, they will appear as garbage characters in the report.
ReasonJVM bug
ID: oxs003
SubjectThe old OXD 2 templates have to be opened and saved using OXD 2.0.20.xxx or later version if you are using ODCAW2 (Build2.0.20) or a later version.
DetailLater versions of OXD (later than 2.0.20.xxx) has a major change in tags related to page setup and ruler.
ReasonOXS limitation
ID: oxs004
SubjectGenerated Reports are not deleted under some situations.
DetailSome situations that these Limitations occur are, 1) Request from the first page (interactive) . Does not submit OMPS job and return back. 2) When Fax job request is wrong (Example : Invalid fax number). 3) After sending a Scheduled Fax job. (Does not occur often) 4) If a single submission page is used and the target OMPS server (CGI type) is not responding. 5) Scheduled Print or Fax job is deleted through the Applet. 6) When report created contains multiple pages (html output) and if it is mailed, except 1st page, others won't be deleted.
ReasonOXS Limitation
ID: oxs005
SubjectOXS allows a maximum of 50 simultanious sessions.
DetailOXS licence allows only 50 simultanious requests to ODTS,ODDS,OIPS,OCCS,ODMS and OIFS modules at a given time.
ReasonOXS Licence Limitation
ID: odds001
SubjectSingle page HTML reports can be restricted to one page only if there are DB objects within DatasetTable.
DetailBy giving FM=h1 user can get a single page HTML report of a OXD template. This will be only applicable for DB Objects (DB aware labels etc) that appear inside a DatasetTable Component.
ReasonODDS specification
ID: odds002
SubjectOnly one level of sub reporting is supported for reports produced by OXS.
DetailOXD templates allow any number of levels of a DatasetTable within a DatasetTable. The reports produced from these templates support only one level of DatasetTables within a DatasetTable.
ReasonODDS limitation
ID: odds003
SubjectAggregate Function component in the summary band will always show the summary applicable to the complete data returned from the DatasetTable irrespective of the number restrictions placed on the DatasetTable components.
DetailNumber of rows (Dataset Bands) produced by the DatasetTable can be restricted by using "Restrict the number of details" property. But if a Report Footer placed in the DatasetTable has a Aggregate Function component, it will show the result applied complete query returned by the Dataset associated with DatasetTable. Here ODDS uses a SQL to obtain value for aggregate function. It does not calculate aggregate value manually using only the displayed values.
ReasonODDS limitation
ID: odcs001
SubjectLotus Domino database does not support conditions involving date fields types.
DetailOXD templates having datasets with queries like SELECT Employees.EmployeeID FROM Employees WHERE Convert(varchar(10),Employees.BirthDate,111) < '2003/01/31' are not supported by Lotus Domino Database.
ReasonLotus Domino Database driver limitation
ID: odcs002
SubjectLotus Domino database does not support right outer join SQL statements.
DetailOXD templates having datasets with queries like SELECT Orders.OrderDate, OrderDetails.Quantity FROM Orders RIGHT OUTER JOIN OrderDetails ON Orders.OrderID = OrderDetails.OrderID are not supported by Lotus Domino Database.
ReasonLotus Domino Database driver limitation
ID: odcs003
SubjectLotus Domino database does not support left outer joins with more than 2 inner joins in SQL statements.
DetailOXD templates having datasets with queries like SELECT Items.Item, Orders.OrderDate FROM Items INNER JOIN Items_ordered ON Items.Item = Items_ordered.item INNER JOIN Orders ON Orders.CustomerID = Items_ordered.customerid INNER JOIN OrderDetails ON Orders.OrderID = OrderDetails.OrderID LEFT OUTER JOIN Product ON OrderDetails.ProductID = Product.ProductCode will not be supported for Lotus Domino database.
ReasonLotus Domino database driver limitation
ID: odcs004
SubjectCache database does not support more than 22 fields in the GROUP BY clause of the SQL statements.
DetailWhen there are 22 or more fields in a SQL GROUP BY clause, in a dataset of a OXD template, Cache database gives an error.
ReasonCache database driver limitation
ID: odcs005
SubjectAccess database LINK tables are not supported by OXS.
DetailAccess database LINK tables need the user name and password of the database to get results of the SQL statements. Current OXS protocols does not support sending the user name and password for LINK tables.
ReasonODCS limitation
ID: odcs006
SubjectODCS module does not support a same alias name for the same database type.
DetailIf the ODCS node in ODCAW.xml has 2 or more databases (DATABASE nodes) with same values for "Name" and "Type" only the first database will connect. The Other databases will not connect and an error will be logged into Error.log.
ReasonODCS limitation
ID: osms001
SubjectOSMS allows a maximum of 50 simultanious users.
DetailLicence of OXS allows a maximum of 50 simultanious sessions to the OSMS module. If more than 50 users try to connect to OSMS the rest will not be allowed to connect.
ReasonOXS Licence limitation
ID: ofms001
SubjectOFMS does not support moving, cutting, copying or pasting files or directories.
DetailOFMS is not written to support moving, cutting, copying or pasting files or directories. Therefore OFMSA cannot move, cut, copy or paste files or directories.
ReasonOFMS limitation
ID: ofms002
SubjectOFMS allows a maximum of 50 simultanious users.
DetailLicence of OXS allows a maximum of 50 simultanious sessions to the OFMS module. If more than 50 users try to connect to OFMS the rest will not be allowed to connect.
ReasonOXS Licence limitation

PDF Format

ID: pdf001
SubjectDash-Dot or Dash-Dot-Dot lines are not shown correctly in PDF reports.
DetailPDF has shows Dash-Dot or Dash-Dot-Dot styles as dash style lines.
ReasonPDF limitation
ID: pdf002
SubjectThere can be differences in reports produced in PDF and OPR format if there are components touching or very close each other in templates.
DetailTemplate in OXD has 96 pixels per inch, where as report produced by PDF has 72 pixels per inch. Therefore when OXS is producing a report in PDF a calculation is done to reduce pixel per inch to 72. During this conversion of pixels there can be some differences in the appearance of the generated report compared to the OXD template.
ReasonOXS PDF generation limitation
ID: pdf003
SubjectAdobe Acrobat 4 supports only Standard Type1 Fonts for form components in a report created by OXS.
DetailAdobe Acrobat 4 form components supports only a limited number of fonts as described in http://partners.adobe.com/asn/developer/technotes/acrobatpdf.html.
ReasonAdobe limitation
ID: pdf004
SubjectOPRO Self Sign Digital Signature verification in PDF is supported by Adobe Acrobat 5 or above.
DetailOPRO Self Sign Digital Signature allows user defined images for the Digital Signature component. User defined images are not supported by versions which are less than Adobe Acrobat 5.
ReasonAdobe limitation
ID: pdf005
SubjectReports containing transparent Form components or a Digital Signature are not supported in PDF.
DetailIn the reports produced by OXS, PDF will show the Form components and digital signature component transparent but when the user clicks on the component the transparency will disappear.
ReasonAdobe limitation
ID: pdf006
SubjectPDF reports produced by OXS having Unicode data will only show characters belonging to the CJK(chinese,japanese,koreon) character set.
DetailCurrent versions of OXS does not support font embedding for PDF reports. It supports only the fonts supported by the Adobe Acrobat Reader.
ReasonOXS limitation
ID: pdf007
SubjectPDF reports produced by OXS does not show characters belonging to Hangul-Jamo charset.
DetailHangul-Jamo charset contains some Korean characters which will not be shown by PDF reports generated by OXS.
ReasonAdobe limitation
ID: pdf008
SubjectPDF reports produced by OXS will display only characters of one language in a component.
DetailOXS does not read character by character and apply the font corresponding each character. OXS applies the font of the first character appearing to the whole component. If there is a combination CJK characters in a component some will appear as garbage.
ReasonOXS limitation
ID: pdf009
SubjectPDF reports will display only one InterfaceGroup.
DetailIf a OXD template has a InterfaceGroup component in a DatasetTable component Group band or Data band, the PDF report will display only one InterfaceGroup.
ReasonAdobe limitation
ID: pdf010
SubjectSubmiting forms depend on the Adobe viewer.
Detail* Adobe Acrobat Reader - Can't submit a form, * Adobe Acrobat Reader from Web Browser - Can submit a form only by 'Post',* Adobe Acrobat - Can submit a form by both 'Get' and 'Post',* Adobe Acrobat from Web Browser - Can submit a form only by 'Post'.
ReasonAdobe limitation on form Components
ID: pdf011
SubjectIf you install ODCAW 2.0.28 or higher version in a machine which has a older version of ODCAW server, a template having a Digital Signature component will not verify properly.
DetailODCAW server earlier than 2.0.28 used X.509 v1 for verification. But in ODCAW 2.0.28 or higher versions, Digital Signature uses X.509 v3 certificates. Because of incompatibilities between the certificates Digital Signature will not verify properly. As solution you have to clear DSProfiles folder in the server.
ReasonOXS limitation
ID: pdf012
SubjectOnly PDF Writer supported fonts are used to show Japanese in reports.
DetailOXS server PDF font writing method is similar to the method employed by PDF Writer. OXS server currently does not support font embedding for any type of font as used by Adobe Distiller. OXS currently uses font embedding only for EUDC fonts.
ReasonOXS limitation
ID: pdf013
SubjectEUDC not supported for Form components
DetailPDF reports generated by OXS does not support User Defined characters for Form components (Text, Memo,DropDown etc).
ReasonAdobe limitation

HTML Format

ID: html001
SubjectHTML reports containing Shape objects are not supported by IE web browsers lower than version 5.0.
DetailHTML reports produced by OXS uses VML for Shape objects. IE web browsers support VML from 5.0 and above.
ReasonIE limitation
ID: html002
SubjectHTML reports only support Solid , Dash , Dot Line types.
DetailCurrently IE browser supports HTML with Solid, Dash ,Dot line styles. Therefore line types Dash-Dot, Dash-Dot-Dot given for line component in OXD are not supported.
ReasonIE limitation
ID: html003
SubjectHTML reports will show text values of components aligned vertically irrespectively the alignment assign to them.
DetailOXD has 9 methods of aligning text in a component. They are TOP & LEFT , TOP & CENTER , TOP & RIGTH , MIDDLE & LEFT, MIDDLE & CENTER , MIDDLE & RIGHT , BOTTOM & LEFT , BOTTOM & CENTER, BOTTOM & RIGHT Current IE Browser only support only TOP & LEFT , TOP & CENTER and TOP & RIGTH only.
ReasonIE limitation
ID: html004
SubjectHTML reports produced by OXS having static content will show all the its contents irrespective of the size of the component.
DetailIn HTML reports all static contents are shown in full, irrespective of the component size, resulting in the expansion of the component. This could be noticed whenever the contents are more than the actual component size. This is due to static content that are transferred as it is without being wrapped by the web browsers.
ReasonIE limitation
ID: html005
SubjectHTML reports produced by OXS does not support Netscape and Opera web browsers.
DetailOXS is currenly written only to support HTML output supported by Internet Explorer.
ReasonOXS limitation

OPROXMLDB

ID: xml001
SubjectOPROXML driver does not support expressions.
DetailOXD templates having Dataset components with SQL expression are not supported in OPROText Driver. +,-,*,/, ||,SUBSTRING,UPPER,LOWER are a sample of operators not supported by OPROXML driver.
ReasonOPROXML driver limitation
ID: xml002
SubjectOPROXML driver does not support aggregate functions.
DetailOXD templates having Dataset components with aggregate functions are not supported. SUM, MIN, MAX are a sample of aggregate functions.
ReasonOPROXML driver limitation
ID: xml003
SubjectOPROXML driver does not support Join Operations.
DetailOXD templates having Dataset components with INNER, LEFT OUTER and RIGHT OUTER Joins are not supported.
ReasonOPROXML driver limitation
ID: xml004
SubjectOPROXML driver does not support ALTER TABLE function.
DetailCannot add or delete a field from a table which has already created in OPRO XML Database.
ReasonOPROXML driver limitations
ID: xml005
SubjectOPROXML driver does not support DISTINCT function.
DetailOXS uses the DISTINCT SQL function when processing 'Group bands'. Therefore OXD templates having DatasetTables using group bands are not supported.
ReasonOPROXML driver limitation
ID: xml006
SubjectOPROXML driver does not support sub queries.
DetailOXD templates having Dataset components which has a SQL statement with multiple SELECT statements are not supported.
ReasonOPROXML driver limitation
ID: xml007
SubjectOPROXML driver gives limited support for SQL having WHERE clause.
DetailOXD templates having Dataset components with only one condition is supported.
ReasonOPROXML driver limitation
ID: xml008
SubjectTables created in OPRO XML database will have names in simple letters.
DetailAll created tables exist as files in the OPRO XML database. In Windows operating system file names are case insensitive therefore to keep the consistency for all operating systems table names are stored in simple letters.
ReasonOperating System limitation
ID: xml009
SubjectJapanese tables are supported only if USERS LOCALE of environment where OPROXML database operates, is set to Japanese LOCALE.
DetailTables created by OPROXML driver are created physically using the same name given in the CREATE statement. Therefore if file name is not supported by the environment (Sun or Linux) table will not be created properly.
ReasonOPROXML driver limitation
ID: xml010
SubjectOPROXML driver does not support SQL statements with multiple lines.
DetailOPROXML driver does not allow multi line data to be inserted for Varchar and Char data types.Therefore insert statements having multiple lines data is not supported.
ReasonDriver limitations

OPROTEXTDB

ID: text001
SubjectOPROText Driver does not support expressions.
DetailOXD templates having Dataset components with SQL expression are not supported in OPROText Driver. +,-,*,/, ||, SUBSTRING,UPPER,LOWER are a sample of operands not supported by OPROText driver.
ReasonOPROText driver limitation
ID: text002
SubjectOPROText Driver does not support aggregate functions.
DetailOXD templates having Dataset components with aggregate functions are not supported. SUM, MIN, MAX are a sample of aggregate functions.
ReasonOPROText driver limitation
ID: text003
SubjectOPROText Driver does not support INNER, LEFT OUTER and RIGHT OUTER.
DetailOXD templates having Dataset components with INNER, LEFT OUTER and RIGHT OUTER Joins are not supported.
ReasonOPROText driver limitation
ID: text004
SubjectOPROText Driver does not support SQL having GROUP BY clause.
DetailOXD templates having Dataset components with GROUP BY clause is not supported.
ReasonOPROText driver limitation
ID: text005
SubjectOPROText Driver does not support DISTINCT function.
DetailOXS uses the DISTINCT SQL function when processing 'Group Bands'. Therefore OXD templates having DatasetTables using group bands are not supported.
ReasonOPROText driver limitation
ID: text006
SubjectOPROText Driver gives limited support for SQL having WHERE clause.
DetailOXD templates having Dataset components with only one condition is supported. Also commands like 'Like','<=','>=' and '<>' are not supported.
ReasonOPROText driver limitation
ID: text007
SubjectOPROText Driver does not support sub queries.
DetailOXD templates having Dataset component which has a SQL statement with multiple SELECT statements are not supported.
ReasonOPROText driver limitation
ID: text008
SubjectOPROText Driver supports only a limited number of character sets.
DetailODF files support only UTF-8 (with BOM) and Shift_JIS character sets.
ReasonOPROText driver limitation

Mail Service

ID: odms001
SubjectSome Japanese charaters are not supported for details appearing in mail sent by the ODMS module, for some Japanese charsets.
DetailCHARSET under SMTPSERVER node in ODCAW.xml allow to give character set so that Japanese text can be send by e-mail using ODMS module. If SHIFT_JIS character set is used some Japanese charaters ( like ` ) will look garabage.
ReasonCharater set limitation
ID: odms002
SubjectThe extension of mail attachments having long names with JP characters is changed to ".dat" in MS Outlook Express.
DetailOXS uses ODMS module to send reports generated through e-mail. These reports will be attached to the e-mail. Usual attachment extentions are .opr, ,pdf or .html. User is given the option to specify the name of the attachment. If the attachment has a long Japanese name the extention will be changed to .dat.
ReasonMS Outlook Express limitation

Fax Service

ID: oifs001
SubjectOIFS functions are supported only in Windows environment.
DetailReports sent by OIFS require some Windows applications. Therefore OIFS cannot be used in Linux or Sun environment.
ReasonOXS limitation
ID: oifs002
SubjectFax Board is supported only in Windows environment.
DetailFax Board library files used by OXS works only in Windows environment. Therefore Fax Board cannot be used in Linux or Sun Environments.
ReasonFax Board limitation
ID: oifs003
SubjectOIFS does not support faxing selected pages.
DetailThe windows application that is used for faxing does not support sending selected pages to fax.
ReasonOXS limitation
ID: oifs004
SubjectColor faxing is not supported.
DetailAPF Fax Driver used by OIFS do not support color faxing.
ReasonFax Driver limitation
ID: oifs005
SubjectFax Board does not support customized header information given by OXS.
DetailOXS has facility to give customized headers for faxes being sent by OIFS. Customized header can be defined in ODCAW.xml under the HEADER_LINE node. Fax Board does not support information provided in HEADER_LINE node. If you want to customize header information from Fax Board refer GDK Version 5.0 Installation and Configuration Guide for Windows.
ReasonFax-Board Driver limitation
ID: oifs006
SubjectSome frame colors are not shown in the fax document, when using fax modems.
DetailWhen frame size of component is 1 and color of the frame is Gray (R:128 G:128 B:128) , Silver (R:192 G:192 B:192),Yellow (R:248 G:252 B: 0), Fuchsia (R:248 G: 0 B:248) or Aqua (R: 0 G:252 B:248) the fax send through fax modem will not show the frame of the component.
ReasonFax Driver limitation

Print Service

ID: oips001
SubjectOIPS functions are supported only in Windows environment.
DetailReports printed by OIPS use some Windows applications. Therefore OIPS cannot be used in Linux or Sun environment.
ReasonOXS limitation
ID: oips002
SubjectCannot print the selected page(s) using OIPS.
DetailOIPS uses a windows application to print reports. This application does not support printing selected pages.
ReasonOXS limitation
ID: oips003
SubjectOIPS does not support multiple printers in a single request.
DetailFollowing is a part of a request sent to OPRO X Server. OIPS does not support requests like TS0=Default&DN0_0=HPlaserJ2&DN0_1=HPPostScript&.... Here DN0_0 and DN0_1 are two printers.
ReasonOXS limitation
ID: oips004
SubjectJapanese job names cannot be printed from PXC (Print Exchange).
DetailOIPS can be used to print reports through PXC. When sending requests to PXC a name can be given for the print job. A Japanese name given for this will become garbage.
ReasonOXS limitation
ID: oips005
SubjectWhen simultanious request are sent to OIPS to print a report in 2 different printers, both reports will be sent to one printer.
DetailWhen a print request is sent to OIPS to print a report using a printer, it will be set as the default printer for the machine by the OIPS application. Therefore when two request are sent to OIPS to print a report in 2 different printers, it will print both reports in first printer it managed to make default.
ReasonOXS limitation

OPRO X Designer

General

ID: oxd001
SubjectDoes not support Self Join.
DetailSelf Joins are not supported in VQB.
ReasonOXS limitation
ID: oxd002
SubjectDoes not support undoing a Layout.
DetailOnce removed the Layout revert is not possible.
ReasonLayout information is not saved for undo (Design Limitation)
ID: oxd003
SubjectMaximum number of Templates can be open simultaneously is restricted to 30.
DetailOnly 30 templates can be opened simultaneously at a given time. But if resources are too low to Open 30 templates (suppose templates are huge), this number (30) cannot be achived, user will get a message before 30.
ReasonResource limitation
ID: oxd004
SubjectWhen an expression is modified format/Order By/Group By is lost.
DetailWhen editing an expression, Format/Order By, Group By data are lost.
ReasonOXD limitation
ID: oxd005
SubjectFor Custom Paper, orientation cannot be changed.
DetailWhen Custom Paper is selected, orientation cannot be changed.
ReasonOXD Limitation
ID: oxd006
SubjectLine Styles have a limitation in Shape component.
DetailIn shape component, all line styles are changed to solid, when thickness is greater than 1.
Reasonlimitation in Win API
ID: oxd007
SubjectImages take longer time to save and preview.
DetailWhen images are included into a template OXD takes a longer time to save and preview.
ReasonImage data are encoded to Base64. This process consums considerable time.
ID: oxd008
SubjectFont cannot be changed in InputKey, Expression Builder, Selection criteria dialogs.
DetailOnly MS P Gothic EUDC characters will be shown in InputKey, Expression Builder, Selection criteria dialogs.
ReasonThese window's font has set to MS P Gothic
ID: oxd009
SubjectEnglish text and color outputs not possible in OCR.
DetailCannot get correct English text and color outputs from OCR.
ReasonCharacter Recognition limitations
ID: oxd010
SubjectMulti-Select is not possible for the data property.
DetailFor every component, inserting data concurrently using multi-select is not possible.
ReasonResource limitation
ID: oxd011
Subject8-bit BMP images may distorted when transparent and stretch properties are true.
DetailSome 8-bit BMP images distort when transparent and Stretch properties are set to true.
ReasonDelphi limitation
ID: oxd012
SubjectDigital Signature component does not support border property.
DetailAdobe Acrobat does not allow the Digital Signature component have a border. Therefore Digital Signature component in OXD does not have a border property.
ReasonAdobe limitation
ID: ofmsa001
SubjectNo Confirmation message for overwriting an existing file.
DetailWhen downloading a file with OFMC to a location where the file is already present , no confirmation MSG is raised to overwrite existing file.
ReasonDesign limitation of OFMS Admin tool

OPRO X Browser

General

ID: oxb001
SubjectThe number of reports that could be opened concurrently is limited to 25.
DetailIf the user exceeds this limit, OXB will automatically close the most previously opened and most inactive report.
ReasonWhen opening a new window (report), OXB uses a considerable memory. This limitation was imposed to avoid freezing the system with low virtual memory.
ID: oxb002
SubjectCannot find text in Browser mode.
DetailCurrently find text works in print preview mode only.
ReasonOXB design limitation
ID: oxb003
SubjectZoom Scale 25-200.
DetailZoom Scale between min 25 and Max 200 range.
ReasonResource limitation
ID: oxb004
SubjectIE3.0 or below versions are not supported.
DetailIf an opr file is requested through IE3.0 , OXB do not pop up.
ReasonIE limitation
ID: oxb005
SubjectCannot print with Acrobat Distiller.
DetailWhen Acrobat Distiller is selected as the printer, Printing error pops.
ReasonDelphi Printer class limitation

OXS Administrative Tools

OPRO Content Control Service Administrator

ID: occsa001
SubjectFiles larger than 1.4 MB cannot be uploaded to OCCS.
DetailMedia files larger than 1.4 MB take a long time to append the OCCS database. A CGI time out occurs.
ReasonOCCS Limitation

OPRO X Table Maker

ID: oxtm001
SubjectDoes not allow Unicode data to be inserted into tables.
Detailuser cannot append Unicode data to XML Database through data grid of the Table Maker.
ReasonThis is design limitation of the Table Maker
Copyright: © 2003 OPRO Japan Co., Ltd. - 日本オプロ株式会社 https://www.opro.net/