Hi,
I was trying to upgrade MediaBin 4.5.3 to 4.6.1 ver. I followed steps given in the 'MediaBin Installation and Upgrade Guide' doc under chapter 3 'Understanding MediaBin Asset Server for Microsoft SQL Server'. As per the steps given in the doc Media Bin Asset Server upgradation went fine. But after looking at the MBP.log I did not find
10/25/07 15:42:26 MBP Server Initialized OK. kind of text at the end of log. My log file has following content
05/21/08 04:31:21 Connection manager shutdown.
05/21/08 04:31:21 MBP Server exiting normally
05/21/08 07:02:27 ******************** MediaBin Server Version MediaBin 4.6.1 Build 7
starting. ********************
05/21/08 07:02:27 Service account user: REDMOND\ictsql
05/21/08 07:02:38 Incompatible schema versions expected "4.6" found "4.5.3".
05/21/08 08:40:51 ******************** MediaBin Server Version MediaBin 4.6.1 Build 7
starting. ********************
05/21/08 08:40:51 Service account user: REDMOND\ictsql
05/21/08 08:40:51 Repository initialized ok.
05/21/08 08:40:51 Missing directory:
\\10.198.212.159\MBDataDirectory\CADIn.
05/21/08 08:40:51 Invalid configuration of MBDataDirectory.
Can someone take a look at this and let me know if I have done something wrong? I have run this setup under domain a/c who is a member of local Admin group
Following is the log related to MBPreMigration
05/21/08 04:47:57 MediaBin pre-migration starting ...
05/21/08 04:47:57 Connecting to ODBC DataSource 'MediaBin Repository'
05/21/08 04:47:57 Adding rowid column to the assets table ...
05/21/08 04:47:57 - rowid column has already been added to this table before.
05/21/08 04:47:57 Adding constraint pk_assets ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding constraint fk_refbase ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding constraint fk_revisionbase ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding constraint fk_cbirdr ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Recompiling the assets table ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding rowid column to the containers table ...
05/21/08 04:47:57 - rowid column has already been added to this table before.
05/21/08 04:47:57 Adding constraint pk_containers ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding constraint fk_contparent ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding constraint fk_treeid ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding constraint fk_treeparent ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding constraint fk_refparent ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Recompiling the containers table ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding rowid column to the ContainerTree table ...
05/21/08 04:47:57 - rowid column has already been added to this table before.
05/21/08 04:47:57 Adding constraint pk_ContainerTree ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Recompiling the ContainerTree table ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding rowid column to the assetrefs table ...
05/21/08 04:47:57 - rowid column has already been added to this table before.
05/21/08 04:47:57 Adding index assetref_parentid ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Recompiling the assetrefs table ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding rowid column to the revisions table ...
05/21/08 04:47:57 - rowid column has already been added to this table before.
05/21/08 04:47:57 Adding constraint pk_revisions ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding constraint fk_ifn ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding constraint fk_ssfk ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding constraint fk_slfk ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding constraint fk_sdfk ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding constraint fk_sifk ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding constraint fk_layerparent ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding constraint fk_metadatabase ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Recompiling the revisions table ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding rowid column to the layers table ...
05/21/08 04:47:57 - rowid column has already been added to this table before.
05/21/08 04:47:57 Recompiling the layers table ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding rowid column to the SearchableStrings table ...
05/21/08 04:47:57 - rowid column has already been added to this table before.
05/21/08 04:47:57 Adding constraint pk_searchst ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Recompiling the SearchableStrings table ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding rowid column to the SearchableLongs table ...
05/21/08 04:47:57 - rowid column has already been added to this table before.
05/21/08 04:47:57 Adding constraint pk_searchl ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Recompiling the SearchableLongs table ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding rowid column to the SearchableDoubles table ...
05/21/08 04:47:57 - rowid column has already been added to this table before.
05/21/08 04:47:57 Adding constraint pk_searchd ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Recompiling the SearchableDoubles table ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding rowid column to the SearchableIdentifiers table ...
05/21/08 04:47:57 - rowid column has already been added to this table before.
05/21/08 04:47:57 Adding constraint pk_searchi ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Recompiling the SearchableIdentifiers table ...
05/21/08 04:47:57 - done.
05/21/08 04:47:57 Adding rowid column to the metadata table - this may take long time ...
05/21/08 04:47:57 - rowid column has already been added to this table before.
05/21/08 04:47:58 Adding constraint pk_metadata ...
05/21/08 04:47:58 - done.
05/21/08 04:47:58 Recompiling the metadata table ...
05/21/08 04:47:58 - done.
05/21/08 04:47:58 Adding rowid column to the layermetadata table ...
05/21/08 04:47:58 - rowid column has already been added to this table before.
05/21/08 04:47:58 Adding constraint pk_lmetadata ...
05/21/08 04:47:58 - done.
05/21/08 04:47:58 Recompiling the layermetadata table ...
05/21/08 04:47:58 - done.
05/21/08 04:47:58 Adding KB values of Original FileSize ...
05/21/08 04:47:58 Inserting 0 value rows into the metadata table ...
05/21/08 04:50:14 - done.
05/21/08 04:50:14 Inserting <=1024 value rows into the metadata table ...
05/21/08 04:52:19 - done.
05/21/08 04:52:19 Inserting >1024 value rows into the metadata table - this may take long time ...
05/21/08 04:57:07 - done.
05/21/08 04:57:07 Inserting 0 value rows into the SearchableLongs table ...
05/21/08 04:57:08 - done.
05/21/08 04:57:08 Inserting <=1024 value rows into the SearchableLongs table ...
05/21/08 04:57:15 - done.
05/21/08 04:57:15 Inserting >1024 value rows into the SearchableLongs table ...
05/21/08 04:58:51 - done.
05/21/08 04:58:51 MediaBin pre-migration completed!
