Phase 2 metadata migration incomplete

[antoktm]

During the upgrade from 7.1.0.4, we directly applied patch 7.5.0.5 followed by the Hotfixes. We started the services, and policies, and the backup processes already running.

But at the next day, we found out that the catalog cannot be browsed with error
 

"INF - unexpected return value from db_IMAGEreceive: unable to process request 228".

Then after investigating, we found out that phase 2 of metadata migration still not complete :

bash-4.2# /usr/openv/netbackup/bin/admincmd/nbemmcmd -listsettings -brief -machinename bckpapp1 |grep IMAGE
LIST_FS_IMAGE_HEADERS="1"

We already try to restart the image cleanup, but the status is still "1", with these messages :

....
05/30/2013 15:47:14 - Info bpdbm (pid=6630) [000:01:10] Initiating import for client: test5.copy
05/30/2013 15:47:14 - Info bpdbm (pid=6630) [000:01:10] Finished importing images for client: test5.copy with 0 imported, 2 skipped, 0 corrupt.
05/30/2013 15:47:14 - Info bpdbm (pid=6630) [000:01:10] Overall progress: 2 images imported, 78 skipped, 0 corrupt. Import rate = 0 images/sec
05/30/2013 15:47:22 - Info bpdbm (pid=6630) Import procedure succeeded in importing 2 images, but 78 images were skipped and 0 images were corrupt, see the log for details
...
 

There are skipped images.

How to solve this and how to finish the phase 2 metadata migration?

[Marianne]

Import procedure succeeded in importing 2 images, but 78 images were skipped and 0 images were corrupt, see the log for details 

Hopefully you have bpdbm logging enabled? 

We need logs to find out what the problem is...

[antoktm]

Hi Marianne,

Here's the log. I see some SQL error there with VALUES ( ?, ? , ? .....)

[Marianne]

I would log a call with Symantec Support right away.

We are not going to get it resolved here...

[antoktm]

Already did that in parallel.

Thanks for the info. I will log the solution they gave me right here.