Re: HP Record Manager 8 patch 1 error - Work Indexing - Serialisation lock failed (829 Views)
Reply
Trusted Contributor
Ralph_Furino
Posts: 179
Registered: ‎04-27-2011
Message 1 of 7 (865 Views)
Accepted Solution

HP Record Manager 8 patch 1 error - Work Indexing - Serialisation lock failed

I upgraded my dev environment to 8.0.0.6376 from 7.4. Everything works great in my testing except when I try to reindex Title Words.

 

I am running Oracle 11G for my database. I followed the install documentation and cleared out all the tables to rebuild the work index.

 

The error that I am receiving is:

 

Work Indexing - failed to acquire serialisation lock after waiting for 300 seconds, will try again later.

 

This is my error log:

 

11:02:32 PM               # Dataset tool started: Sunday, December 29, 2013

11:02:32 PM    32         SELECT value FROM TSTWRSYS WHERE code = 'DBVERSION'

11:02:38 PM               Step 1

11:02:38 PM    62         SELECT stopWordName FROM TSSTOPWORD WHERE uri > 0

11:02:38 PM    47         SELECT value FROM TSTWRSYS WHERE code = 'PRP_7723'

11:02:38 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:02:39 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:02:40 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:02:41 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:02:43 PM    63         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:02:44 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:02:45 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:02:46 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:02:47 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:02:48 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:02:49 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:02:50 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:02:51 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:02:52 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:02:54 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:02:55 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:02:56 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:02:57 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:02:58 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:02:59 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:00 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:01 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:02 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:03 PM    78         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:05 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:06 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:07 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:08 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:09 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:10 PM    125        SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:11 PM    62         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:12 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:14 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:15 PM    63         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:16 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:17 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:18 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:19 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:20 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:21 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:22 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:23 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:25 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:26 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:27 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:28 PM    78         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:29 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:30 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:31 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:32 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:33 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:35 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:36 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:37 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:38 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:39 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:40 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:41 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:42 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:43 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:44 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:46 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:47 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:48 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:49 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:50 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:51 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:52 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:53 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:54 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:55 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:56 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:58 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:03:59 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:00 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:01 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:02 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:03 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:04 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:05 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:06 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:07 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:09 PM    63         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:10 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:11 PM    171        SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:12 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:13 PM    62         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:15 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:16 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:17 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:18 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:19 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:20 PM    62         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:21 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:22 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:23 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:24 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:26 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:27 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:28 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:29 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:30 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:31 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:32 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:33 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:34 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:35 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:37 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:38 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:39 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:40 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:41 PM    62         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:42 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:43 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:44 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:45 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:46 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:47 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:49 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:50 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:51 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:52 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:53 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:54 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:55 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:56 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:57 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:04:58 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:00 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:01 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:02 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:03 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:04 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:05 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:06 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:07 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:08 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:09 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:11 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:12 PM    63         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:13 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:14 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:15 PM    63         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:16 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:17 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:18 PM    62         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:19 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:21 PM    63         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:22 PM    109        SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:23 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:24 PM    141        SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:25 PM    141        SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:27 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:28 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:29 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:30 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:31 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:32 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:33 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:34 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:35 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:36 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:38 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:39 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:40 PM    62         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:41 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:42 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:43 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:44 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:45 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:46 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:47 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:49 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:50 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:51 PM    62         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:52 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:53 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:54 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:55 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:56 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:57 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:05:59 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:00 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:01 PM    32         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:02 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:03 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:04 PM    94         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:05 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:06 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:07 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:09 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:10 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:11 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:12 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:13 PM    62         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:14 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:15 PM    62         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:16 PM    63         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:17 PM    63         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:19 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:20 PM    219        SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:21 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:22 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:23 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:24 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:25 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:26 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:28 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:29 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:30 PM    0          SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:31 PM    63         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:32 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:33 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:34 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:35 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:36 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:37 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:38 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:40 PM    62         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:41 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:42 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:43 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:44 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:45 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:46 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:47 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:48 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:49 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:50 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:52 PM    63         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:53 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:54 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:55 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:56 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:57 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:58 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:06:59 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:00 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:01 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:03 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:04 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:05 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:06 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:07 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:08 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:09 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:10 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:11 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:13 PM    110        SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:14 PM    93         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:15 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:16 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:17 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:18 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:19 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:21 PM    78         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:22 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:23 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:24 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:25 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:26 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:27 PM    46         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:28 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:29 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:31 PM    62         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:32 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:33 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:34 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:35 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:36 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:37 PM    47         SELECT COUNT(*) FROM TSTWRSYS WHERE code = 'LOCK_PROC_0'

11:07:38 PM    300156     Step 1 Completed

Any help would be appreciated.

 

Thank you in advance.

Honored Contributor
TRIMGuru
Posts: 605
Registered: ‎05-24-2010
Message 2 of 7 (837 Views)

Re: HP Record Manager 8 patch 1 error - Work Indexing - Serialisation lock failed

LOL, Dang Ralph!  How about posting another eight hours of the log? 

 

While I can't definatively provide an answer, I can ask you if:

 

a) You've rebooted all the workgroup servers after the upgrade;

b) You had the oracle sys admin 'reset' the oracle db (stop/start? don't know the proper terms for it)

 

 

Trusted Contributor
Ralph_Furino
Posts: 179
Registered: ‎04-27-2011
Message 3 of 7 (829 Views)

Re: HP Record Manager 8 patch 1 error - Work Indexing - Serialisation lock failed

I did reboot the server after the upgrade. I also ran all of the database maintenance/repair tasks. I wanted to see how the word reindexing would work on the new version so I deleted all the tables that the manual specified. This is how I got in this mess to begin with. I should have left the indexing alone.

 

I still have items in the word indexing in TES for queued and processed. I can't get rid of them no matter what I tried.

 

This is the dev environment and that's what it's for. Gotta test before upgrading the production environment.

 

I will put a ticket in to bounce the dev DB if all fails tomorrow.

Trusted Contributor
Ralph_Furino
Posts: 179
Registered: ‎04-27-2011
Message 4 of 7 (826 Views)

Re: HP Record Manager 8 patch 1 error - Work Indexing - Serialisation lock failed

BTW.. Happy New Year Greg!

Trusted Contributor
Ralph_Furino
Posts: 179
Registered: ‎04-27-2011
Message 5 of 7 (823 Views)

Re: HP Record Manager 8 patch 1 error - Work Indexing - Serialisation lock failed

HP Support gave me this SQL to run that fixed the problem:

 

UPDATE TSTWRSYS SET VALUE = ' '  WHERE code = 'LOCK_PROC_0';

 

Honored Contributor
TRIMGuru
Posts: 605
Registered: ‎05-24-2010
Message 6 of 7 (819 Views)

Re: HP Record Manager 8 patch 1 error - Work Indexing - Serialisation lock failed

lol, thanks Ralph, Happy New Year to you also - still think you should post another eight hours worth of the logs though..  lmao

 

Glad it's all sorted now for ya.

 

If there weren't problems, you wouldn't have a critical position ;)  You're doing great in my opinion.

 

Trusted Contributor
Ralph_Furino
Posts: 179
Registered: ‎04-27-2011
Message 7 of 7 (805 Views)

Re: HP Record Manager 8 patch 1 error - Work Indexing - Serialisation lock failed

Thanks.... I appreciate the comment! I learned a great deal from you!

 

I will have more questions once I start cracking at RM 8. I already see a problem with the new Data Port. It comes pre configured for tab delimited. CSV has to be added in. All of the image import programs I wrote are for CSV.

 

Another thing with Data Port, I can't even import a box using a text tab delimited file. Keep getting Origin errors about making the number automatic.... and I'm not even using origins. I'll have to figure that out tomorrow or post.

The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.