You are viewing limited content. For full access, please sign in.

Question

Question

Leftover procedures from an upgrade from LF 9.2 to 10.1 ?

Installation and Upgrades
Updated November 8, 2017
asked on January 20, 2017 • Show version history
In the update from 9.2 to 10.1 there seems to have been a mishap in the database update script.
 
I am left with 2 invalid procedures WIN_TRUSTEE_GET_ALL_GROUPS_9I and TRUSTEE_GET_ALL_GRP_NAMES2_9I.
Both are using a table tmp_groupmembership which has been dropped as part of the upgrade from 9.2 to 10.1. Should I simply drop the procedures ?
(Oracle repository)
 
Thank you
0 0

Replies

replied on January 23, 2017

If you mean win_trustee_get_all_groups2_9i, then yes, you can drop it. ora-upg80.sql should've dropped it during the upgrade.

The definition for trustee_get_all_grp_names2_9i can be found in ora-upg2.sql.

0 0
replied on January 23, 2017

Hi Miruna

 

The names I gave are correct so no, I do not mean win_trustee_get_all_groups2_9i.

 

The 2 procedures existed in LF 9.2, and still do in 10.1 but are invalid due to the missing (dropped) table tmp_groupmembership.

0 0
replied on January 23, 2017

Hi Sylvain,

Laserfiche Server 10.1 does not call the procedures, TRUSTEE_GET_ALL_GRP_NAMES2_9I and WIN_TRUSTEE_GET_ALL_GROUPS_9I. You can drop those procedures. We'll fix the upgrade scripts in a future release to drop these procedures.

Regards

0 0
replied on November 8, 2017

Hi Alexander,

The procedure CRETAE_LOCK have the same case (I can drop)?

 

Regards,

Marco.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...