Common problems and Solutions

We will meet all kinds of problems in the report running process. The following lists some common problems, error information, causes and basic solutions.

Note: jar is 2018.4.9 and after, no longer support applet printing, please use other printing methods.

1. Code and meaning

Note 1: both the 10.0 designer and the deployment package use openjdk, flash printing cannot be started with openjdk, Oracle/Sun JDK can.

Note 2: Flash printing is an obsolete technology. Many browsers will no longer support flash printing. It is recommended that customers use zero client or local printing.

2. Some solutions

1) error code: 1301

• Error: dataset configuration error Query: Cannot create Poolableconnectionfactory ([Microsoft] [ODBC driver manager] did not find a data source name and did not specify a default driver)

• Reason: in the 64 bit system, 64 bit tomcat, no matter 32-bit JDK or 64 bit JDK, does not support ODBC data source, so an error will be reported when accessing the template with access database.
  

Generally, JDK is 64 bit, and there is no 64 bit ODBC database driver on the service.

Solution:

• Method 1: install either of the following two drivers. AccessDatabaseEngine_ 2007_ X64.exe or accessdatabaseengine2010_ X64.exe
  

• Method 2: use 32-bit JDK instead.
  

2) error code: 1303

• Error: death cycle exists at calculating XX

• Reason: dead loop exists in cell or control calculation
  

• Solution: analyze and check the related cells in the error message to see if there is any contradiction between the left and upper parent cell settings.
  

3) error code: 1305

• Error: template file parsing error file: xxx.cpt
  

• Reason: directly use EDITPLUS and other software to check the XML content in CPT and check whether the template is damaged; if it starts with frencrypt, the template may be encrypted;
  

If it is blank, then the template is damaged, the server may hang up or be restarted in the process of saving, the remote network of the client is interrupted, and so on

4) error codes: 1101, 1102, 1103, 1104, 1107, 1108

If the row-based engine in the user's scenario can't support it, you can try the new computing engine plug-in. The plug-in realizes the paging query function in the case of multiple data sources. Users don't need to write complex paging SQL or JS buttons, so that the report can quickly complete the loading of the home page.

Note: the plug-in supports Oracle, SQL server, mysql, Hana, PostgreSQL, impala, DB2 and most of the mainstream JDBC data sources.

1. address pool is full

• Reason: the address pool is full and the number of connections exceeds the maximum number of concurrent connections
  

• Solution: in the case of manage > intelligent operation, you can see the number of online users of the current system, and then compare the concurrency in the registration information page,
  

Judge whether it exceeds the number of concurrent purchases, and then choose to reduce the number of concurrent purchases or increase the maximum number of concurrent purchases

Please refer to address pool is full for details

2. Java heap space, stack overflow

• Reason: the template is too complex, the amount of data is large, and the stack overflows

• Solution: optimize the dataset, use pagination preview method for reports, and increase the server memory.
  

The processing method can refer to Error: Java heap space.

3. drop down check box return value problem

• Reason: the drop-down check box widget returned value is an array by default. The string that the parameter fetch is not quoted. (therefore, it is necessary to manually invoke a single quotation mark when calling the string type parameter in the SQL statement defined in the dataset). Multiple values are in. The in statement parameter of SQL is a string array, each of which requires single quotation marks.
  

• Solution: under transformation, change the return value of the control to a string, and use ',' as the interval.

4. the effect of local preview is different from that of server

• Reason: jar package difference or cache problem
  

• Solution: update the jar package to ensure that the development environment and server platform are consistent and correct. If not, restart the designer or clear the browser cache.
  

5. Chinese random code and box in the chart

• Reason: the box is due to the lack of Chinese font.
  

• Solution: the corresponding computer system, download and update the corresponding Chinese font library.
  

6. repeated column width is larger...

• Reason: duplicate column width is greater than paper width.
  

• Solution: just set it to less than the column width.
  

7. the row height expanded by a cell is inconsistent

• Reason: there are more lines in a certain line. If the line cannot be displayed, it will be changed, so it will be widened.
  

• Solution: just widen the cell a little bit.
  

8. display equal sign in user defined data dictionary

• Reason: a custom data dictionary is the same as a cell and a custom prompt box. If it does not start with a '=' sign, it is treated as a string, and the '=' sign is treated as a formula
  

• Solution: just write an equal sign is blank, if you want to display the equal sign, use = "="
  

9. data connection not found

• Reason: data connection or data set configuration problem
  

• Solution: check whether there is a problem with the configuration. 

10. an internal error occurred

• Reason: error will appear when installing exe, generally because the downloaded installation file is damaged and incomplete
  

• Solution: download the official exe
  

11. index xx,size xx

• Reason: the height of a row is greater than that of a page.
  

• Solution: you can merge cells vertically to make one cell occupy more than one row. In this way, you can split the cells whose row height is greater than the page height into multiple rows for calculation, and the preview will be displayed in the form of multiple pages.
  

Similarly, the length of a cell cannot be greater than the width of a page. Otherwise, there will be an error. You can merge cells horizontally.

12. TTf is not a valid TTF or OTF file

• Reason: PDF export will scan the local font file. If the font is damaged, the above error will be reported
  

• Solution: prompt which font damage, copy a past
  

13. UnsupportedClassVersionError

• Reason: it is usually caused by the technical support customizing and modifying the class in the jar package
  

• Solution: you need to adjust the engineering compilation level of IDE to 1.6
  

14. java.lang.AbstractMethodError

• Reason: it's generally because the engine's jar, plug-in's jar and designer's jar are not synchronized and compiled at the same time
  

• Solution: update all jars
  

  
  

15. java.lang.NoClassDefFoundError

1) specific error report: sun.awt .X11GraphicsEnvironment Could not initialize class sun.awt .X11.XToolkit

• Reason: it usually happens under Linux, and needs the support of local JVM X-server when processing pictures
  

• Solution: add parameters when starting Java:- Djava.awt.headless=true For example: when we start tomcat, we can add this parameter to the start command line
  

For Weblogic, it can be set at /export/home/xxx（username）/weblogic/wlserver_10.3/common/bin/commEvn.sh

Sun)
    JAVA_VM=-client
    MEM_ARGS="-Xms1024m -Xmx1024m -XX:MaxPermSize=1024m"
    JAVA_OPTIONS="${JAVA_OPTIONS} -Xverify:none"
  ;;
  *)
    JAVA_VM=
    MEM_ARGS="-Xms1024m -Xmx1024m"
  ;;
  esac
fi
export JAVA_VM MEM_ARGS JAVA_OPTIONS

Then add the following two sentences:

JAVA_OPTIONS="${JAVA_OPTIONS} -Djava.awt.headless=true "
export JAVA_OPTIONS

For WebSphere, go to application server > Server1 > process definition > java virtual machine

General JVM arguments:- Dfile.encoding=GBK - Ddefault.client.encoding=GBK - Djava.awt.headless=true

2) specific error: COM/FR/general/logrecordtime

• On the premise that the jar package is consistent, delete all plug-ins, and first determine if there is any problem with independent deployment under Tomcat,
  

• If there is no problem, let's see if we want to change the JRE of Weblogic
  

3) specific error: COM/FR/Web/core/service/widgetservice

• Reason: wrong applet package, such as putting applet in lib directory, etc

• Solution: put applet in %FR_HOME%\webapps\webroot

4) specific error: Sun/Io/unknowncharacterexception

• Reason: this class is caused by jdk1.7
  

• Solution: using 1.7 JDK can solve the error
  

  
  

16. final block not properly padded

• Reason: DES encryption class initialization problem, but only encountered in openjdk
  

• Solution: change to JDK under normal Linux
  

17. javax.mail.SendFailedException

• Error: invalid addresses javax.mail.AuthenticationFailedException

• Reason: email recipient, email account password error or email server problems, the mailbox server refused to connect, may be determined to send spam and other behavior
  

• Solution: re - enter the recipient and password, or change the mailbox
  

18. java.lang.SecurityException

• Class "XX"'s signer information does not match signer information of other classes
  

• Reason: class is repeatedly loaded. The most common one is an additional applet package in webapps/webroot/WEB-INF/lib
  

• Solution: just delete it
  

19. java.lang.NoSuchMethodError

• Reason: generally, jar packages do not match
  

• Solution: Designer lib, Lib in webapps and plug-ins should be consistent
  

20. Invalid argument

• Specific error information: invalid argument to native writeimage
  

• Reason: generally, JDK does not support decoding of some pictures
  

• Solution: use QQ screenshot to generate PNG again
  

21. TDS protocol stream is not valid

• Specific error information: connection to SQL server by using secure sockets layer (SSL) encryption Error:The TDS protocol stream is not valid
  

• Reason: when JTDS connects to SQL server, SQL Server enables security authentication
  

• Solution: add the client to the authentication list
  

22. ParseError at [row,col]:[x,xx]

• Specific error information: com.fr.third . javax.xml.stream .XMLStreamException : ParseError at [row,col]:[x,xx]

• Reason: the content of the XML file is damaged. Please refer to [row, col] for the specific row and column
  

• Solution: which manager is responsible for the newspaper reading error
  

DatasourceManager -> datasource.xml

FunctionManager -> functions.xml

ConfigManager -> config.xml

CustomConfigManager -> customconfig.xml

WidgetManager -> widgets.xml

23. Not found resource

• Specific error information: com/fr/web/core/hack/PIE.htc
  

            Or  Not found resource: /com/fr/fs/resources/fonts/iconfont.eot?

• Reason: these two are caused by IE low version does not support some styles or CSS writing, does not affect the use. May lose write transparent shadow and other special effects
  

• Solution: use higher version of IE
  

24. java.net.SocketException

1) specific error message: connection reset by peer or broken pipe

There are many reasons for resource file reading failure, which need more detailed investigation

• Reason:
  

        ① If the number of concurrent connections of the server exceeds its capacity, the server will down some of them;

        ② The client turns off the browser, while the server is still sending data to the client;

        ③ The browser side pressed stop

• Solution:
  

        ① Reduce concurrency. If you know that the number of concurrent clients actually connected to the server does not                 exceed the capacity of the server, you may be infected by a virus or Trojan horse, causing abnormal network traffic.

        ②, ③ these two situations generally do not affect the server.

However, if there is no special treatment for the exception information, the exception may appear repeatedly in the server log file, causing the server log file to be too large and affecting the operation of the server.

You can use try... Catch to catch the exception for the part that causes the exception, and then do not output or only output a prompt message to avoid using e.printstacktrace(); output all exception information.

2) specific error information: clientabort Exception:java.net.SocketException

• Reason: when processing HTTP connection and outputting content, if the user closes ie, a "clientabortexception" will appear, which is an exception in I/O processing
  

Note: it may not be triggered by users. It may also occur when the network is unstable

25. OPTION SQL_ SELECT_ LIMIT=DEFAULT

• specific error message: You have an error in your SQL syntax; check the manual that responses to your MySQL server version for the right syntax to use near 'option SQL_ SELECT_ LIMIT=DEFAULT' at line 1
  

• Reason: JDBC will send test statement set option SQL when connecting to database_ SELECT_ LIMIT=DEFAULT

  This can be done in MySQL 5.6 or below, but set. Net is no longer supported in MySQL 5.6

• Solution: upgrade the driver to the corresponding database version
  

26. Error Happens On Picture Analysis

• Reason: when importing excel, some pictures may fail to parse, or there is a problem with the width and height
  

Note: if the content on the page is OK, you can ignore the error

27. Can't create cache file

• Reason: there is no temp directory in tomcat, or the write permission of temp directory is not enough

• Solution: just create this directory in the Tomcat installation directory
  

28. Excel format pattern not supported

• Specific error information: Excel format pattern not supported by Java
  

• Reason: it is generally because of the user-defined number style used in Excel, which is not supported by Java parsing when importing the report
  

29. Cannot load JDBC driver class

• Reason: drive problem

• Solution: check whether the database driver is normal. If the driver is certain, check whether the JDK matches the driver
  

30. the designer is fragmented and incomplete

• Reason: it may be a JDK1.8 bug.

• Solution: install windows designer with built-in jdk1.7 

  
  

31. paged queries not supported

• Reason: the current database does not support paginated query row engine
  

• Solution: change the database, such as mysql, SQL server, Oracle and so on.
  

32. Cannot connect to site server: xxx

• Reason: can not connect to the app store, does not affect the use.
  

33. no function found: XXX

• Reason: the custom function is not found. The cpt of the designer is copied to the server, the custom function is not copied.

34. Cannot get a connection

• Specific error information: cannot get a connection, pool error timeout waiting for idle object
  

• Reason: the database can't be connected, the connection pool is full or timeout
  

• Solution: click server > define data connection, as shown in the figure below. Click connection pool property to pop up the connection pool property edit box to adjust the maximum number of active connections
  

35. com.fr.stable.fun.Level

• Specific error information: com.fr.plugin . record.FunctionRecordManager cannot be cast to com.fr.stable . fun.Level
  

• Solution: delete the old function point record plug-in in the plugins directory. Stop maintenance.
  

36. Class not found: JForm

• Reason: there was an error when opening the report. It may be because a plug-in was used but the current designer did not install it. Please refer to the more detailed log.
  

37. Thai, Korean and other languages error

• Solution: modify the encoding in FS to UTF-8
  

38. Get PublicKey method failed

• Specific error information: get publickey method failed, status is: - 1
  

• Solution: can't connect to the digital signature server, check whether the network can be pinged and whether the server where the digital signature is located is normal. If you can't see the problem, restart it
  

39. java.lang.OutOfMemoryError

• Reason: memory overflow
  

• Solution: observe after restart. If frequent memory overflow occurs, it is recommended to install anti downtime plug-in
  

40. Web end stuck when preview multiple exceptions

• Reason: the default 8075 port of the designer is occupied

• Solution: click File > Options > advanced, change a designer port, restart
  

41. Could not initialize class

• Specific error information: could not initialize class sense4.sense64
  

• Reason: the softdog registration is enabled in FS, but the corresponding driver is not installed
  

42. 404 error on Web

• Specific error information: 404 - /webapps/Webroot/[object% 20object] appears on the web
  

• Solution: update: jar after November 17, 2016 has fixed the bug
  

43. com.fr.test .xxx not found

• Specific error information: there are some functions to start Tomcat: com.fr.test .xxx not found!
  

• Reason: in order to improve the calculation speed of custom functions, the performance group places the custom functions to load when they are started;

If the custom function cannot be found, this error will be reported. Generally, it will not be affected, because some of them are built-in demos

44. UNEXPECTED WIDGET

• Error: the designer opened the template and could not find the control
  

• Reason: the custom control or the control in a plug-in is usually used, which cannot be found in the current running environment
  

45. designer doesn't work directly

• Solution: check the process with task manager first, is there any problem designer.exe If you have, turn it off and try again
  

• If not, open the bin directory designer.bat , add pause in the last line, save and start designer.bat , check the error report
  

46. design_open error

• Reason: remote design, template open error, try to open some simple template, if simple template works, while some parts do not work, consider whether the jar on both sides is inconsistent, plug-in is inconsistent

47. plug-in list reading failed

• Reason: it's usually because of the network that we can't connect to the mall
  

• Solution: direct browser access to the mall to see if you can access https://community.finereport.com/market/

48. the interface of the designer is disordered, and the menu is displayed in English

• Reason: it may be that the template opened last time used plug-in elements that do not exist in the current environment

• Solution: after creating a new template, exit the designer and start again
  

49. parameters set on the program dataset interface cannot be saved

• Reason: the parameters defined in the class of the program data set will conflict with the interface. For compatibility reasons, the parameters set in the class are preferred
  

• Solution: delete the parameters in the program data set class, and directly use the. Setparameter in the interface instead of setparameter in the code
  

50. print or export, the content is truncated at the end of the page

• Reason: when previewing on the web side, the browser can automatically open the div, but when printing and exporting, the page size is strictly limited, so it will be truncated

• Solution: the truncated cell settings page can be broken

51. com.fr.base .TableData$1

• Specific error information: com.fr.base .TableData$1 cannot be cast to com.fr.data . impl.NameTableData
  

• Solution: look at the stack. The stack in the figure above is a cell in the form of a formula, but the formula does not get the corresponding data set. The specific cell can be determined by dichotomy

  
  

52. java.io.FileNotFoundException

• Specific error information: java.io.FileNotFoundException : xxx.cpt Or XML (access denied)
  

• Reason: the file does not exist, or the web browser does not have access to the folder.
  

53. the remote design connection server is always disconnected

First check whether the jars on both sides are consistent. If they are consistent, see if there are conditions to install a designer on the server, and directly check the localhost to see if it will fail

If localhost is good, but not through IP, it may be a network problem. When the connection fails, Ping the server IP to see the network response delay

54. WcardTitleLayout cannot be cast

• Specific error information: wcardtitlelayout cannot be cast to com.fr.form . ui.ElementCaseEditorProvider
  

• Reason: updated jar, did not update adaptive plug-in
  

55. when the web access CPT, it prompts that the template cannot be found

• Reason: can't all CPTs be found, or only some newly added CPTs can't be found? If the newly added CPTs can't be found, is the cluster not synchronized to other nodes

All CPTs can't be found. Go to FS > intelligent operation and maintenance > system status > configuration file detection to check where the XML files are located. Find the reportlets directory from this path

56. no response to applet printing

• Reason and solution: confirm the client's browser information. Currently, applet printing is not supported in chrome, only flash, PDF and local printing are supported
  

It is recommended to install 32-bit JRE under ie, and in the control panel - Java settings - security, the http://localhost 8075 join in

57. Cannot run program xx

• Specific error information: cannot run program XX, error = 12, cannot allocate memory
  

• Solution: modify the memory configuration of the JVM and reduce the initial memory. 

  
  

58. 7.0 designer cannot open 8.0 template

• Solution: open XXX.cpt with software like EDITPLUS, find the penultimate line <designerversion designerversion = "IAA"/>, and delete it
  

Note: if some properties of the new version are used in the template, an error will be reported if it is forcibly opened in the old designer

59. web access template, page queuing appears

• Reason: the memory is almost full, and the anti-downtime plug-in starts the session queuing function

60. flash printing

• Reason: generally because the page uses non A4 paper, flash printing cannot transfer the page settings to the printer
  

• Solution: PDF printing or local printing is generally recommended
  

61. war package deployment, modification of XML does not take effect after deployment again

• Reason: under Weblogic, war package deployment does not decompress, so we will copy all XML to the temporary directory for addition, deletion and modification
  

• Solution: by visiting op=fr_base&cmd=evaluate_formula&expression=jvm() view the cache path, delete the finereport8.0 folder of the cache path, and then deploy
  

62. java.net.BindException

• Specific error information: java.net.BindException :Address already in use: JVM_ Bind
  

• Reason: generally, the port is occupied because Tomcat was started again before it was completely shut down
  

63. the current hsql has been locked by another thread

• Reason: two web servers share the same webreport. The most common one is to start tomcat, and the designer also uses the local directory to cut it
  

      Or Tomcat uses docbase mapping, the mapping address is webreport in tomcat/webapps, which will be loaded twice

• Solution: delete db.lck, which can be solved by restarting Tomcat service

  
  

64. web 654 and 655 error

• Reason: the program data set made by the problematic class file is loaded

• Solution: assembly dataset class must be placed in% fr_ The compiled class name can't be modified in the home %FR_HOME%\webapps\webroot\WEB-INF\classes\com\fr\data

  
  

65. can't create cache file error

• Reason: there is no temp directory in tomcat, or the write permission of temp directory is not enough
  

• Solution: create the temp directory under Linux and grant the permission 777; move the project from disk C to disk D under windows.