HPE Content Manager (HPE RM) Forum
Showing results for 
Search instead for 
Do you mean 

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

SOLVED
Go to Solution
Trusted Contributor

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.

6 REPLIES
Honored Contributor

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

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

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

BTW.. Happy New Year Greg!

Trusted Contributor

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';

 

Highlighted
Honored Contributor

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

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.