Kbase P100685: Error 1006 with -trig and procedure libraries on the Appserver
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/4/2005 |
|
Status: Unverified
SYMPTOM(s):
Database trigger procedures with the same name in multiple procedure libraries cannot be used with Appservers connected to the database with -trig.
-trig fails to load into Appserver memory the correct procedure from the specified library if another procedure with the same name has been loaded previously.
AS ? library2.pl<<proc.r>> Database sports2000 not connected. (1006)
<program name> Database <dbname> not connected. (1006)
CAUSE:
This is a known issue being investigated by Development
FIX:
There are 3 ways this can be worked around:
1. Rename the trigger files so that they are unique.
2. Do not use -trig and manipulate on PROPATH to get the right procedure.
3. Create one library with a slightly different reference to the trigger code by creating the library in a parent directory.
For example if you have two libraries as follows:
library1.pl - reference "trigger.r".
library2.pl - reference "trigger.r".
Create library1 in a parent directory so that the references are different. e.g.
library1.pl - reference "parent/trigger.r".
library2.pl - reference "trigger.r".
In this case the Data Dictionary reference to the trigger code needs to change to use "parent/trigger.r".