Question

SQL Store Procedures don't execute after Forms upgrade from 9.2.0.908 to 9.2.1

Forms

Updated December 8, 2015

asked on March 16, 2015 • Show version history

We upgraded to Forms 9.2.1 from 9.2.0.908 and now any of our forms that use SQL stored procedures don't execute. Normally these forms populate a hidden field on them and now they just remain blank.

Any input and/or direction will be greatly appreciated.

Things I've already tried:

Refreshed the Data Sources from the Admin page
Confirmed Forms account can EXECUTE stored procedure from SQL Mgmt Studio
No longer hiding the field that is populated after running the SQL SP confirms it's not being populated after clicking 'Auto fill' button
Removed Lookup Rule, Saved, & Re-added
Interrogated System & Application Event Logs

0 0

Replies

replied on March 16, 2015 • Show version history

Hi Eddie,

I tested upgrade from 9.2.0.908 to 9.2.1, and the lookup rule that uses stored procedure still works as expected. The rule I used reads two fields and fills two fields.

Can you share with us your lookup rule and data source details? Maybe there is something special in your configuration.

Besides, have you tried adding a new data source and a new process to see if stored procedure can execute?

0 0

replied on March 17, 2015

Thanks for responding Rui... Laserfiche Support has been able to replicate my issue within their test environment and have escalated to the Forms development team. It appears the issue is isolated to fields within tables.

0 0

replied on December 8, 2015

Hi there,

Please confirm your use case. It may due to the misuse of Table.

0 0

You are not allowed to follow up in this post.

Question

Question

SQL Store Procedures don't execute after Forms upgrade from 9.2.0.908 to 9.2.1

Replies

Sign in to reply to this post.