Unable to launch the store from the Site Administration console after migrating Technote
(troubleshooting)Problem(Abstract) Some migration guides contain a section entitled "Launching your store from the Site Administration console". However, after following the steps in this section, you are unable to launch the store. Cause The row in the SCHCONFIG table of the database that corresponds to the job that published the store contains two path names that point to the original instance instead of to the migrated instance. This row is referred to in the "Launching your store from the Site Administration console" section of the migration guide and is used when launching the store in this fashion. Resolving the problem One of the steps in the sequence is to run the following SQL query:
select sccquery from schconfig where sccjobrefnum = jobNumber
The result from this query will contain a "deployXMLFilename" string and a "storeArchiveFilename" string, but these two strings will contain pathnames that are valid only for the original un-migrated instance. This row in the SCHCONFIG table should be updated to contain the pathnames for the migrated instance of WebSphere Commerce. Use the following SQL query to update the row:
update schconfig set sccquery = "updatedpaths" where sccjobrefnum = jobNumber
After making this change, you can successfully launch the store from the Site Administration console.
You might not have this row exist in the SCHCONFIG table of your database. This will be the case if you have cleaned up (that is, deleted) the job that was used for publishing the store.
Cross Reference information
Segment Product Component Platform Version Edition Commerce WebSphere Commerce Enterprise Migration AIX, i5/OS, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux zSeries, Solaris, Windows 6.0 Enterprise Commerce WebSphere Commerce Business Edition Migration AIX, i5/OS, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux zSeries, OS/390, Solaris, Windows 5.6, 5.6.1 Business Edition Commerce WebSphere Commerce - Express Migration AIX, i5/OS, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux zSeries, OS/390, Solaris, Windows 5.6, 5.6.1, 6.0 Express Commerce WebSphere Commerce Professional Edition Migration AIX, i5/OS, Linux, Linux iSeries, Linux pSeries, Linux xSeries, Linux zSeries, OS/390, Solaris, Windows 5.6, 5.6.1, 6.0 Professional Edition
Document Information Current web document: http://www.ibm.com/support/docview.wss?uid=swg21251865