Issue in editing views with firebird database.

Pratap Singh shared this problem 54 days ago
Awaiting Reply

Hi

While trying to edit a view with the firebird database it replicates the columns and gives an error, please have a look at the screenshot added in the attachment.

When we first publish the view it is fine but when it is edited it creates a new set of columns with the same name, it's strange but this is the issue with this specific database only.


Thanks & Regards

Pratap

Comments (4)

photo
1

/560c79b130212d6a16ac76223a739f4a

photo
1

Hi Pratap,

Thanks for reaching out.

It looks like database tables are constantly being replaced/changed, which be causing the issue in YF view builder. If the tables are created with the exact same name (case inclusive) we shouldn't be seeing these warnings.

Could you please let me know, were these changes were done while Yellowfin was running (may be a report was running in YF/broadcast while the changes were made? ).

When did it first happen?? Now, do we have same table/field names in db when the view was initially created?

Thanks,

Deepak

photo
1

Hi Deepak,


Thanks for responding, this case is replicating with any table available in db. Table structure is not being changed, when we create view first time using one table it is fine as soon going to edit the view it is giving these duplicate columns.

Seems like it is reading the columns differently 2nd time which is causing this issue.

I understand that change column/table structure may cause this but there is no change at db side .


Thanks & Regards

Pratap

photo
photo
1

Hi Pratap,

I have installed Firebird server on my local instance, and running it as windows service:

/d7ff685671fa430e94e12fb8505b9472


And used Jaybird 4.0.6 for Java 8 / JDBC 4.2 drivers to connect to Firebird's default tables employee.fdb (Firebird\Firebird_3_0\examples\empbuild). I have then created views on this data source, and edit them multiple times but everything seems to be working as expected:

/15b9c670fd5cd7bba06edbbe01c24002


Could you please check if the data source connection is fine?

/70d2155ad46b2f7ede884c40f7d74d28


and also please share logs from the Yellowfin/appserver/logs to see if we have any error messages. (Kindly compress and upload the file to FTP: https://ftp.yellowfin.bi/ and help me with the name of the file uploaded and also the exact timestamp at which the issue was replicated).


Thanks,

Deepak

photo
1

Hi Deepak,


I have uploaded the log files with name logs (1).zip, please see the logs with the latest timestamp.


Thanks & Regards

Pratap

photo
photo
1

Hi Pratap,

After looking at the logs, I see the following errors:

YF:2022-11-02 08:30:59.091:ERROR (DBUtil) - [41] [F6D964A5] [/MIPreViewEdit.i4] No columns returned for table: TAV_VA_VAMFG_M_WORKCENTER in schema: null sourceId: 128996

YF:2022-11-02 08:30:59.132:ERROR (MIViewProcess) - [41] [F6D964A5] [/MIPreViewEdit.i4] View test_1(138556) was being loaded and the available field list was empty. Aborting with Inconsistency Error.

YF:2022-11-02 08:30:59.133:ERROR (MIViewProcess) - [41] [F6D964A5] [/MIPreViewEdit.i4] Inconsistency Error detected. Aborting to maintain View integrity.


I think YF has sent a query to retrieve columns from this table in firebird db, but unable to fetch any. Not sure why this would happen. Could you please let me know if can create a fresh data source connection to firebird and create a new view and see if its still the same?

Can we enable DEBUG logging temporarily as outlined here to get more information when we reproduce the error again on a fresh ds connection and share the logs folder.

And can we check just incase if we have any DISCONNECTED fields in the YF cofig db. Please refer to the article(Step 3): https://community.yellowfinbi.com/knowledge-base/article/how-to-fix-fields-missing-from-step-2-of-view-builder-and-reports

Thanks,

Deepak

photo
1

Hi,

we got the following response from the customer.


"We don't have some DISCONNECTED fields, but not for this new connection and the new view we created now."

Sent latest log files on FTP with name File_17112022-014051.zip


Regards

Pratap

photo
1

Hi Pratap,

Unfortunately, I couldn't find any errors related to firebird data source connections. Could you please confirm if these logs were captured after replicating the error? If yes, kindly help me with the timestamp. If not, please replicate the error again and share the debug logs along with timestamp.

Best Regards,

Deepak

photo