Remote Design FAQ

1. Check whether remote design is supported

Scenario description: Before remote design connection, user need to confirm whether the remote project supports remote design function points.

Solution: Log in to the data decision system and viewhttp://IP:port/webroot/decision/remote/design/vtIf it returns {"data":"success"}, it means it supports it.

2. View user permissions

Scenario description: Remote design connection failure of non-supervisor account

Solution: Log in to the data decision system to check whether the user has been assigned remote design permissions. For details, please refer to: Remote Design.

3. View JAR package version

Scenario description: The local designer version and the remote JAR package version are inconsistent, which will cause many problems.

Solution: When connecting remotely, if the version does not match, it will promptRemote Design will be partially affected by inconsistent versions.As shown below:

It is recommended to update in time to ensure that the server and designer versions are consistent.

1. Incorrect username and password

Problem introduction: When remotely designing a connection, it prompts User name and password error.

Solution: The user name and password filled in do not have the authority of remote design. User need to contact the administrator to add it. For details, please refer to: Remote design .

2. Error Response HTTP/1.1 404 by

Product version: FineReport 10.0

Problem introduction: An error is reported when remotely designing a connection:com.fr.workspace.engine.exception.WorkspaceConnectionException: Response HTTP/1.1 404 by http://IP:port number/webroot/decision

Solution: Uninstall and reinstall the designer.

3. Error The SolidRecordExecutor should be register first

Product version: FineReport 10.0

Problem introduction: An error is reported when remotely designing a connection:The SolidRecordExecutor should be register first

Cause Analysis:

The server does not have a cloud operation and maintenance plugin installed, which does not affect the normal use of the function.

This is an error related to the embedded point function on the server. It is only pushed to the designer through the remote design log and displayed on the designer. In fact, it has nothing to do with the remote design function itself.

4. The remote design occasionally fails to connect

Problem introduction: The remote design connection occasionally fails to connect. The designer page will show that the remote host forcibly closes an existing connection and cannot connect to the server.

Reason analysis: A connection timeout time connectionTimeout is configured in Tomcat. If the client does not get a response from the server after this time, it will actively disconnect, that is, the above exception occurs.

Solution: The default connection timeout in Tomcat is 20 seconds, and it is generally best to set it to 60 seconds to avoid the connection disconnection caused by the long processing time of the background program. Modify it as follows: connectionTimeout="60000".

5. Frequent disconnection of remote design

Product version: FineReport 10.0

Problem introduction: Remote design, frequent disconnection.

Troubleshooting plan:

1) The administrator logs in to the data decision system and clicks Manage >Intelligent Operations>Memory Management to check whether the two graphs of Memory UtilizationandCPU Utilization under the Memory Aler Tab are blank.

     If it is blank, it means that the  WebSocket connection failed. Please refer to the document to configure the WebSocket port: Websocket connection failed 

2) Check whether the network is connected: whether the ping ip address is connected, check whether there is a problem with the vpn, and check the network status.

6. Cannot connect to projects configured with virtual directories

Problem introduction: The user project has done the virtual directory configuration, and the remote design connection cannot be connected.

Solution: Add /desicion behind the virtual directory (ie: Servlet), the connection is successful.

7. The connection server cannot be designed remotely in the intranet environment

Product version: FineReport 10.0

Problem introduction:

Without the redirection and interception settings, the external network mapping will connect normally, and the client remote design will fail to connect after changing to the VPN internal network.

Log: failed: Connection timed out: connect.
warning: com.fr.workspace.engine.exception.WorkspaceConnectionException: remote design connect failure.

Solution:

1) For the problem of VPN adaptation, just turn on all the permissions of the client connection in the VPN.

2) Sangfor VPN, user need to set the server IP and port as L3VPN resources so that the designer can connect and access remotely.

1. Error doesn't match any of the subject alternative names

Product version: FineReport 10.0

Problem introduction: An error was reported when remotely designing a connection: doesn't match any of the subject alternative names.

Reason analysis: It is because the domain name used during configuration is not the domain name filled in when the certificate is generated.

Solution: Reconfigure the domain name, test, and the connection is successful.

2. Error Unrecognized SSL message, plaintext connection?

Product version: FineReport 10.0

Problem introduction: Error when designing connection remotely: Unrecognized SSL message, plaintext connection?

Solution: The port is wrong. The port provided is not the https service port.

3. Error unable to find valid certification path to requested target

Product version: FineReport 10.0

Problem introduction: An error is reported when remotely designing a connection:

sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

4. Free ssl certificate is not supported

Product version: FineReport 9.0

Problem introduction: A free ssl certificate from Alibaba Cloud is used. The format is pfx. After configuration, user can directly access the address to enter the decision-making platform, but the remote design connection fails.

Solution: Free ssl certificate is not supported, user can convert it to .keystore certificate first.

5. Not support crt certificate

Product version: FineReport 8.0&9.0&10.0

Problem introduction: The remote design does not support crt certificates.

Solution: User can convert crt into a jks certificate.

6. Remote design cannot connect to the bi server when https is enabled

Problem introduction: According to the document  HTTPS access by configuring an SSL certificate , CAS single sign-on is normal, but the remote design connection server cannot connect successfully.

Reason analysis: The hosts file of the client machine is not configured with a domain name, so that the server cannot be accessed locally through the domain name.

Solution: After configuring the host file of the machine with the correct domain name, restart the service and design the connection remotely.

1. The server is down

Problem introduction: The remote connection test works. After switching to the remote design, a prompt box will always pop up, indicating that the server is closed (actually, it is not closed).

Solution: The remote design needs to add a port. If it is set to directly access the ip, it is generally the default port 80.

2. The request was intercepted by the server network

Problem introduction: Switching the remote directory fails, and there is a similar error in the designer log:java.util.zip.ZipException: Not in GZIP format

Reason analysis: The remote design request was intercepted by the server network.

Solution: Ask the person in charge of the server network operation and maintenance to modify the network security interception strategy to change/webroot/decision/remote/design/*Relevant requests are added to the whitelist.

3. HTTP 411 error

Problem introduction: The remote design test connection is successful, and the switching of the working directory fails. The following similar errors are reported in the designer log:

com.fr.workspace.engine.exception.WorkspaceConnectionException: Response HTTP/1.1 411 Length Required by http://IP:port/webroot/decision

Solution:

1) Confirm the Nginx version. If it is lower than Nginx 1.3.9, please install the chunk-nginx-module patch for the existing Nginx, or upgrade Nginx.

2) The designer version is upgraded to version 10.0.8, and Content-Length has been added to the post request header of the remote design.

4. Nginx 504 Gateway Time-out

Problem introduction: There is a slow switching/operation card in the remote design, and a similar error is reported in the designer log:

com.fr.workspace.engine.exception.WorkspaceConnectionException: Response HTTP/1.1 504 Gateway Time-out by 10.1.1.96:80

Cause Analysis:

The meaning of Nginx 504 Gateway Time-out is that the requested gateway is not requested,

Simply put, there is no PHP-CGI that can be executed.
Nginx 504 Gateway Time-out is generally related to the setting of Nginx.conf.

Solution:

Adjust nginx.conf parameters and restart nginx to take effect. The default fastcgi process response buffer is 8K, user can increase the following parameters:

• fastcgi_buffer_size 128k

• fastcgi_buffers 8 128k

• fastcgi_busy_buffers_size changed from 128K to 256K

• fastcgi_temp_file_write_size is changed from 128K to 256K

1. Cannot find template

Product version: FineReport 10.0

Troubleshooting steps:

1) Linux environment, check encoding, Chinese font

2) Check the registration function point, whether there is this function point

3) Check remote design user permissions

4) Check template permissions

5) Check the user group to which the template belongs

2. Failed to save edit template

Product version: FineReport 10.0

Problem introduction: When the remote server saves the template, an error is reported:"xxx.cpt" is locked by user admin with client xxx, The number after the client is the same as the designer number, but the remote design and activation code are not limited.

Cause Analysis:

As long as the sent request contains a specific string, it will happen when the server reads itjava.io.IOException: Connection reset by peer Lead to not being able to get it.

This is a server network problem, and it is a SQL injection prevention security strategy.

Solution: Ask the person in charge of the server network operation and maintenance to modify the network security interception strategy to change/webroot/decision/remote/design/*Relevant requests are added to the whitelist.

3. No permission to save template

Problem introduction: Using the super administrator account to design remotely, the following phenomenon appears when saving the template:

• Save the template, prompting that there is no permission

• Sub-directories have permission to view but do not display

• The template has been saved in the server environment, but it still prompts Please save the template in the current running environment

• An error appears in the log: NoHttpResponseException
  

Reason analysis: The server disconnected the http connection, but did not notify the client. When the service is requested next time, the httpclient continues to use the connection and an error is reported.

Solution:

1) Update the designer and project to 10.0.12 and later versions.

2) Adjust tomcat configuration: modify the connectionTimeout of Tomcat's server.xml, and restart to take effect after the increase.

1. Data connection failed

Product version: FineReport 10.0

Problem introduction: When remotely designing, the data connection fails, or the data connection test connection succeeds, but it shows failure when creating a new database query.

Solution: Check if the server and designer jar packages are the same, just keep the same.

2. The data connection password is none

Product version: FineReport 10.0

Problem introduction: When designing remotely, the existing data connection password is lost and the connection cannot be made. After refilling the password and connecting, the password will be reported as none. Designer log errorDecrypt failed: Decryption error

Solution: The project has a secret key seed file, under config, such as default_alpha, default beta, default gamma, just delete it.

3. The remote design cannot see the Excel file

Product version: FineReport 10.0

Problem introduction: Remote design cannot see Excel files. This is a requirement and cannot be supported temporarily.

4. The json data set cannot be selected for remote design

Product version: FineReport 10.0

Problem introduction: The local connection to the json data set can be selected normally, but it cannot be selected under the remote design.

Solution: Turn off  Remote design data connection permission control .

1. Open template is a new blank template

Problem introduction: All templates of remote design cannot be opened, and all templates are newly created blank templates.

Reason analysis: redis has dirty data.

Solution: clear redis, if user are using redis cluster, each node needs to be cleared.

2. The template cannot be saved

Problem introduction: The template cannot be saved during remote design, and the following similar errors are reported in the server log:java.lang.NullPointerException

Reason analysis: Redis has dirty data

Solution: Clear redis, if user are using redis cluster, each node needs to be cleared.

3. Switching remote directory card is slow, and opening report is stuck

Problem introduction: The remote design directory switching speed is very slow, and the template on the server is directly stuck.

Troubleshooting direction:

1) In the cluster environment, check whether nginx and other configurations are correct, and adjust the parameters of nginx.

2) Check whether the redis status server is abnormal, restart redis and then remote again.

4. The remote design of the cluster environment connects to the LogDB query error

Product version: FineReport 10.0

Problem introduction: After remotely designing the connection, the data set queries the table in LogDB, and an error is reported when outputting SQL.

Reason analysis: Swift access restrictions.

Solution:

1) The JAR package version is upgraded to after 2020-12-11.

2) Delete the old LogDB in the cluster node.

3) Clear the two tables fine_swift_seg_location and fine_swift_segments in FineDB.

4) Restart the cluster nodes.

1. Judgment mechanism of remote design template occupation (has been locked)

Product version: FineReport 10.0

Problem introduction: Opened the template, and opened the remote working directory after restarting the server. It was found that the template was locked, but only one person was editing it.

Reason analysis: The release logic of the template lock is to clean up every 1 minute. The precondition for judging whether to release is that no one else operates the template for 1 and a half minutes.

Solution: Restart the server, or wait for a period of time to be released.

2. Remote design plugin installation logic

Product version: FineReport 10.0

For plugins that are used by both the designer and the server, both the server side and the designer side are required to be installed:
1) If there are already plugins on the designer side, the downloading, deleting, and disabling of the plugins on the server side will not take effect immediately, and it will take a few minutes to wait. Will take effect
2) If there is a plugin on the server side and no plugin on the designer side, the plugin will not take effect and user need to switch to the local to install the plugin. However, the Disabled state of the plugin settings when the designer is switched to the local will not affect the use of the plugin at remote design time. In the remote design, the state of the plugin is controlled by the server. The simple understanding is that user only need to ensure that the designer has this plugin locally.