I have a customer on 15.1.3 initial release. We upgraded them from 15.1.2 over a week ago. We had a problem last weekend where a member was getting an error when trying to update his record. The error indicated that the CsContact.UpdatedBy field was not long enough - 15 characters. I contacted TS and went ahead and changed the field length in the BO to 60 to match the Updated_By column in Name. Everything seemed OK. TS indicated that they could not duplicate the problem, and indeed I could not either. I changed it back to 15 and watched the event logs for new errors. They appeared Thursday this week, so I connected back to the database and changed the length back to 60 and saved and re-published the object. It errored out the first two times but I got it to publish finally. After I got it published, desktop users started getting portfolio shutdown errors - odbc timouts. I rebooted the server. Upon rebooting I have not been able to log on to the casual view, public site (WCM) and in the desktop, I can connect to the Customers tab, AR, Billing, Events, Expo, etc, but not home, System Setup or Tools. I get the error posted below. When I look at the vBoCsContact view, I notice the UpdatedBy column is missing in the view. I cannot get back in to the BO Designer to edit the BO and try to republish. Editing the view directly does not help. Is there any other way to get to the BOD? Is there any way to force a rebuild of the CsContact BO? Restoring from backup is a very last resort as the customer has entered numerous event registrations and billing payments during the day prior to the backup. Any help would be very greatly appreciated.
Unexpected website error: String was not recognized as a valid DateTime.Couldn't store <> in RenewedThru Column. Expected type is DateTime.
System.ArgumentException: String was not recognized as a valid DateTime.Couldn't store <> in RenewedThru Column. Expected type is DateTime. ---> System.FormatException: String was not recognized as a valid DateTime.
at System.DateTimeParse.Parse(String s, DateTimeFormatInfo dtfi, DateTimeStyles styles)
at System.Convert.ToDateTime(String value, IFormatProvider provider)
at System.String.System.IConvertible.ToDateTime(IFormatProvider provider)
at System.Data.Common.DateTimeStorage.Set(Int32 record, Object value)
at System.Data.DataColumn.set_Item(Int32 record, Object value)
--- End of inner exception stack trace ---
at System.Data.DataColumn.set_Item(Int32 record, Object value)
at System.Data.DataTable.NewRecordFromArray(Object[] value)
at System.Data.DataTable.LoadRow(Object[] values, LoadOption loadOption, Index searchIndex)
at System.Data.DataTable.LoadDataRow(Object[] values, LoadOption loadOption)
at Asi.Business.BusinessController.ImportRows(String cmdText, DataParameter[] parameters, Boolean forceReload) in c:\Builds\iMIS\15.1.3_Commit\Sources\imis.net\Packages\Platform\Asi\Business\BusinessController.cs:line 1595
at Asi.Business.BusinessController.get_Item(Object[] primaryKeys, Boolean forceReload, Boolean publishedOnly, Boolean allowRecycled) in c:\Builds\iMIS\15.1.3_Commit\Sources\imis.net\Packages\Platform\Asi\Business\BusinessController.cs:line 1289
at Asi.Business.BusinessController.get_Item(Object[] primaryKeys, Boolean forceReload, Boolean publishedOnly) in c:\Builds\iMIS\15.1.3_Commit\Sources\imis.net\Packages\Platform\Asi\Business\BusinessController.cs:line 1208
at Asi.Business.BusinessController.get_Item(Object[] primaryKeys) in c:\Builds\iMIS\15.1.3_Commit\Sources\imis.net\Packages\Platform\Asi\Business\BusinessController.cs:line 1177
at Asi.Providers.AsiRoleProvider.IsUserInRole(String username, String roleName) in c:\Builds\iMIS\15.1.3_Commit\Sources\imis.net\Packages\Platform\Asi.Providers\AsiRoleProvider.cs:line 406
at Asi.Providers.AsiRoleProvider.<>c__DisplayClass1e.<GetRolesForUser>b__1a(String rolename) in c:\Builds\iMIS\15.1.3_Commit\Sources\imis.net\Packages\Platform\Asi.Providers\AsiRoleProvider.cs:line 310
at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()
at System.Collections.Generic.List`1.InsertRange(Int32 index, IEnumerable`1 collection)
at System.Collections.Generic.List`1.AddRange(IEnumerable`1 collection)
at Asi.Providers.AsiRoleProvider.GetRolesForUser(String username) in c:\Builds\iMIS\15.1.3_Commit\Sources\imis.net\Packages\Platform\Asi.Providers\AsiRoleProvider.cs:line 310
at System.Web.Security.RolePrincipal.IsInRole(String role)
at Asi.Web.SiteMapProviderBase.SwappableSiteMapProvider.UserRolesContains(IPrincipal contextUser, User currentUser, String role) in c:\Builds\iMIS\15.1.3_Commit\Sources\imis.net\Packages\Platform\Asi.Web\SiteMapProviderBase.cs:line 894
at Asi.Web.SiteMapProviderBase.SwappableSiteMapProvider.IsAccessibleToUser(HttpContext context, SiteMapNode node) in c:\Builds\iMIS\15.1.3_Commit\Sources\imis.net\Packages\Platform\Asi.Web\SiteMapProviderBase.cs:line 779
at System.Web.SiteMapNode.IsAccessibleToUser(HttpContext context)
at Asi.Web.SiteMapProviderBase.ReturnNodeIfAccessible(SiteMapNode node) in c:\Builds\iMIS\15.1.3_Commit\Sources\imis.net\Packages\Platform\Asi.Web\SiteMapProviderBase.cs:line 382
at Asi.Web.SiteMapProviderBase.SwappableSiteMapProvider.FindSiteMapNodeFromKey(String key, Boolean checkAccessibility) in c:\Builds\iMIS\15.1.3_Commit\Sources\imis.net\Packages\Platform\Asi.Web\SiteMapProviderBase.cs:line 568
at Asi.Web.SiteMapProviderBase.FindSiteMapNodeFromKey(String key, Boolean checkAccessibility) in c:\Builds\iMIS\15.1.3_Commit\Sources\imis.net\Packages\Platform\Asi.Web\SiteMapProviderBase.cs:line 169
at Asi.Web.SiteMapProviderBase.FindSiteMapNodeFromKey(String key) in c:\Builds\iMIS\15.1.3_Commit\Sources\imis.net\Packages\Platform\Asi.Web\SiteMapProviderBase.cs:line 163
at Asi.Web.UrlRewriter.Rewrite(String requestedPath, HttpApplication app) in c:\Builds\iMIS\15.1.3_Commit\Sources\imis.net\Packages\Platform\Asi.Web\UrlRewriter.cs:line 255
at Asi.ContentManagerNet.BaseUrlRewriter.CheckForCustomizedUrl(HttpApplication app) in c:\Builds\iMIS\15.1.3_Commit\Sources\imis.net\Packages\iWC\Asi.ContentManagerNet\BaseUrlRewriter.cs:line 119
at Asi.ContentManagerNet.BaseUrlRewriter.BaseUrlRewriter_AuthorizeRequest(Object sender, EventArgs e) in c:\Builds\iMIS\15.1.3_Commit\Sourc
Hi Steven, You can try to
Hi Steven,
You can try to build and publish the object from the command line.
* Go to the 'bin' directory and in a command prompt window, and run this command line:
BuildPublishBOs -W -S -CS <serverName> -CD <databaseName> -CU <userName> -CP <password>
Replace <serverName>, <databasseName>, etc. with your actual db server name, db name such as mydbserver -CD myimisdb -CU etc.
Also could the issue now be that the client has added data to the table while it was altered that is not valid for the data types the object is creating?
Ross