Kbase P14005: Error 2272 when truncating bi
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/03/2003 |
|
Status: Unverified
FACT(s) (Environment):
Windows NT 4.0
FACT(s) (Environment):
Progress 8.3B
SYMPTOM(s):
Error 2272 when truncating bi
Unequal number of user update and extract routines. <routine-count> user update routines, <routine-count> user extract routines. (2272)
Database started from ProControl.
CAUSE:
The 2272 seems to indicate a shared memory issue when it is found with Compaq machines, possibly due to interaction with Compaq agents.
FIX:
Carry out the following steps in order:
1. Shut down as many services as possible, and after each shutdown retry the truncate. If this doesn't work, then -
2. Reboot. If this doesn't work, then -
3.1. In general to protect Progress's shared memory from other utils like e.g. Insight manager:
In NT's USER MANAGER:
- Create a new group (eg. ProgressAdmin)
- Create a new user (eg. PAdmin1)
- Set PAdmin1 to be owner of the ProService service
- Add all users that need access to the shared memory, ie. shared memory connections,
database
administrators that need to run tools like promon
- In the Procontrol\Details\Environment tab ensure Access Group = ProgressAdmin.
If this was set to "Access = ALL", then this needs to be changed.
3.2. Reboot the machine.
3.3. Restart the database, then shut it down again, and retry the truncate.