"the query for ResourceContainer failed" BE2012 - Clean Install
Hi All,
just want to share the problem i have with BE 2012.
It is a clean fresh installation on clean newly installed Win2008 R2 SP1 (all pre-checks passed fine).
After remote push of 2 agents and creation oddedupe folder, the console reports error in lower left corner of the screen saying : "The query for ResourceContainer failed".
The result is that nothing is visible inside GUI anyomore (groups, agents, jobs...).
Debugging shows :
MANAGEME: [03.27.12 15:00:28] [0000] ERROR: Reason: DataAccess DataAccessBEServer QueryResourceContainer: caught an exception:Invalid column name 'finaljobstatus'..
MANAGEME: [03.27.12 15:00:28] [0000] ERROR: Stack: at BackupExec.Management.Components.DataAccess.DataAccessBEServer.QueryResourceContainer(ItemCriteria& queryInfo)
I have tried reinstall, removal of installation, deletition of profile, registry keys, deletition of all associated folders and tried a clean install, also i have trye dusing another SQL server as opposed to using SQL express, but always the same error appears (will have to rebuild the server form scratch it seems).
Any ideas? Ayone seen this before?
Thanks.
All the best,
Kresimir
Ok.. Solved.
The SQL express database which BE installs (and any other) inherits collation settings from Language for non-Unicode programs setting (http://msdn.microsoft.com/en-us/library/ms143311(v=sql.90).aspx ). Therefore if you have some other regional setting, the SQL express database of BE inherits these setings and the BE 2012 cannot work with "non-standard" collations.
The collation of SQL Express database which i am now using is (English US) so all is OK now.
Thanks for your replays.