Question

There must be at least one table or stored procedure in the SQL database to assign it to a business process. [LFF337-NoTableorStoredProcedureAssigned]

Forms

Updated July 20, 2021

asked on September 17, 2018 • Show version history

Hi,

I have noted another post with the same error, but it is not clear what the resolve is.

https://answers.laserfiche.com/questions/141444/LFF2400DataSourceConnectionError--Connecting-Oracle-ODBC-Connection-with-Forms-1031#141712

I have an external system using Oracle DB, Laserfiche is using MSSQL. In workflow i can do queries to Oracle without any issues, however in Laserfiche Forms i have created the connection and it tests successfully, but then when i want to add a process then i receive the following error.

There must be at least one table or stored procedure in the SQL database to assign it to a business process. [LFF337-NoTableorStoredProcedureAssigned]

What do i need to do to resolve this issue?

Regards,

Gert

0 0

Answer

SELECTED ANSWER

replied on October 15, 2019

The bug for Oracle has been fixed with Forms 10.4.0, it will get the objects the user can access from [all_tables] and [all_views].

0 0

Replies

replied on September 19, 2018

Do you use same user to connect to the database from Forms and Workflow? Can you check whether you see any tables listed when you switch to the Offline Lookup Tables tab and click “Add/remove offline lookup tables" for the oracle data source?

If the tables are created in one user, but you use another user to connect to the database in Forms, you need to grant right to the user used to connect the database to select the table as https://stackoverflow.com/questions/4220094/granting-permission-to-users-on-different-schema

0 0

replied on September 19, 2018

Hi Xiuhong,

I am using the same TNS, User and password as i am using in workflow. In workflow i can view the tables, but not in forms.

0 0

replied on September 20, 2018

Can you login with the same user using other tool such as Oracle SQL Developer and run following query to check whether you can get the tables?

SELECT TABLE_NAME AS name FROM user_tables UNION SELECT VIEW_NAME FROM user_views ORDER BY name

0 0

View 3 previous replies

replied on September 20, 2018

Hi Xiuhong,

When i run the query, i don't see any tables.

However, i work in SQL Developer to do my queries. We only have Read access for this particular user.

I am logged in with the same details in Oracle SQL Developer and i can do queries to the tables.

0 0

replied on September 21, 2018

Hi Gert,

We confirmed is it a bug for Forms to not be able to view other user's tables even rights are granted, this will be fixed with next release of Forms. Thanks for pointing this out. As workaround, can you use the user who created those tables when configure the data source?

0 0

replied on September 21, 2018

Hi Xiuhong,

I will have to speak to the DB Administrators to see if they will allow me to use another user. Access is very strict.

Thanks for checking this out.

0 0

replied on October 3, 2019

Has this bug been fixed since Laserfiche 10.4?

Thank you.

0 0

SELECTED ANSWER

replied on October 15, 2019

The bug for Oracle has been fixed with Forms 10.4.0, it will get the objects the user can access from [all_tables] and [all_views].

0 0

replied on July 20, 2021

No it hasn't! Still there in Forms 10.4.5.282.

0 0

You are not allowed to follow up in this post.

Question

Question

There must be at least one table or stored procedure in the SQL database to assign it to a business process. [LFF337-NoTableorStoredProcedureAssigned]

Answer

Replies

Sign in to reply to this post.