SQL Dataset Preview Error Troubleshooting

Description

Dataset preview failed, the error starting with ORA, for example, ORA-0911.

Cause

This error is an Oracle database error.

Solution

This error can be troubleshot by searching for the error information online.

For example, a common error ORA-0911 indicates that the SQL statement contains invalid characters, and it is necessary to check whether there are invalid characters in the statement.

Description

When you add a SQL dataset and preview it, an error "62400001duplicate field names found: Store" is displayed, as shown in the following figure.

Cause

In the FineBI dataset, column names cannot be duplicated within the same table, otherwise an error will occur.

Solution

Check if there are duplicate column names when fetching data from the database.

There are two ways to fetch two columns with the same data.

1. Rename the duplicate column. For example, enter the statement select Store, Store as Store1 from new_salesdetail.

2. Copy and paste the column through the Add Column function of the self-service dataset. For details, see Column Adding.

Description

When you preview a SQL dataset, an error "Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT)" is displayed.

Cause

Encoding formats are inconsistent, or there are special characters in the SQL statement.

Solution

Change the encoding format to utf8_unicode_ci.

For example, the SQL statement is select * from a where aa='aa', and its encoding format is utf8_general_ci.

Change the encoding format to utf8_unicode_ci through the SQL statement select * from a where aa=CONVERT('aa' USING utf8) COLLATE utf8_unicode_ci.

Description

You cannot save successfully after connecting to the SQL Server database and adding the SQL dataset.

Open %FineBI% fanruan.log, the log error is shown in the following figure.

Cause

During the execution of transactions in the SQL Server database, multiple transactions are executed simultaneously, causing a deadlock in the requests. Therefore, you cannot add tables normally.

Solution

Contact the database operation and maintenance administrator to handle deadlock or restart the database.