When we open form qms0012f to run reports we get error
FRM-41085: Error getting Group Row count.
We have traced to the problem to procedure qms$form.init in qmslib50.pll where indeed the following codes appears:
rg_id RECORDGROUP := find_group('CGSH$FORM_OBJECTS');
-- if QMS$TRANS_ERRORS exists and is not in list of windows, add it
l_row_count := get_group_row_count(rg_id);
We think that we are missing some code here related to CGSH$FORM_OBJECTS, can anyone explain why and how to solve this?
From the Headstart 6.5 User's Guide: When starting a Headstart-generated application, you might get the following error:
FRM-41085: Error Getting Group Row Count
FRM-40735: PRE-FORM trigger raised unhandled exception ORA-04067.
This error is raised if you try to run the application under an Oracle user who does not have access to the Headstart database objects.
Maybe your problem is similar, can you check if your database user has access to the Headstart objects like hil_message etc.?
We have found that the problem is result of using an older version of headstart (5) instead of the recommended version 6.5 for designer/developer 6i. We have made some adjustments and the problem seems to be fixed.
Tanks for the reaction.