Application Architect Failing to Open

[jjbingen]

We recently setup a test environment were we upgraded from 7.0 to 7.5.  This worked as planned after a few tries...  We have now pushed this into production. In our test environment we added the web integration piece also.  This was a feature we did not have in place in the past.  In our test environment we neglected to install the web bundle and SP1 piece.  After installing the bundles these same error messages during load did not appear.

In our current production environment it fails on loading services, platforms, modules and bundle management during initial startup.  The error messages are long and cryptic but basically ‘An application expectation has occurred’ on ever one of the services, platforms.... Once the architect is loaded nothing works inside it.  I have tried uninstalling and reinstalling the WebHost IIS but to no avail.  The error messages almost point to a corrupt install. So if anyone has any ideas/tricks on how to uninstall/install this completely?  Since this is our production environment and uninstalling and reinstalling the SLX server is no longer an option.

We have updated everything with the latest Service Packs/bundles and upgrades.  We did not test until after the service packs (1 and 2) were installed.  So it is possible it worked initially then one of the service packs broke it, we have no way of knowing.

This is a fairly unique issue but anyone has any ideas we are at lose at what to try next.

Thanks for any help or suggestions.

[MikeSpragg]

What you can do is truncate the virtualfilesystem folder and then copy that in from the Eval database (select into ..) - this will put you back to square one and you can then upgrade it to the proper release as needed.

[jjbingen]

Okay that sounds cool... how to truncate the virtualfilesystem folder within SQL... few more details on the 'how to' on this

[MikeSpragg]

Login to your live system as sysdba and execute:

TRUNCATE TABLE VIRTUALFILESYSTEM

This removes the contents. Then:

insert into sysdba.virtualfilesystem (select * from SLXEVAL.sysdba.virtualfilesystem)

This grabs the data from the SLXEVAL (which you will need to replace with the name of the database holding slxeval - which you will need to have installed in order to be able to get to it).

Regards
Mike

[jjbingen]

This effected 8842 rows- does this sound right?  The SalesLogix production DB now has all these rows?  The Eval DB only had 4? 

Regradless same error messages when opening Architet...

Message Edited by jjbingen on 05-10-2010 12:59 PM

[mdykun · Accepted solution]

Its possible that withing your app data folders the configurations are broken. Locate the folders and delete them (will be re-created when started). Now if your eval database only has 4 records in the VFS then then that is wrong as well. There should be 1000's of records containing the customizations.

Mark