Home » blog » Zuzana_Kelyman's blog

Upgrade 10.6.30.17 to 15.1.2.4260 issues

Posted May 26th, 2010 by Zuzana_Kelyman

We are trying to update iMIS from version 10.6.30.17 to 15.1.2.4260 version.

We were using Opportunity module from the version 10.5. with custom BOs.
We decided to drop .NET tables as they were causing a lot of errors when trying to upgrade to 15.0.1 on the test server (about a year ago ).
Now we are trying to go from 10.6.30.17 to the newest version 15.1.2.4260.
The steps we are taking (as instructed by ASI support) are below:
-  drop 10.6 .NET tables using script from ASI,
- I also deleted our custom tables (OpportunityMainAACUDonor, OppportunityMainAACUMember) and views using those tables (vBoOpportunityAACUDonor, vBoOpportunityAACUMember) as I was getting error on views if I didn't do that and the update would fail.
- manually drop the SP called asi_CheckImisNetPrivilegeLevel
-Check if we can login to IMIS as Manager not only Manager!sa
-Run script for bad views and clean them up. I deleted all views using those .NET tables we dropped. 
- run update
The update will finish but with errors during when on the step of building BOs. See below:
 
--------
Building And Publishing Business Objects ...

Error building and publishing business objects...
Please check the logs to determine which objects failed to publish.
Continuing...

Step 65 Done.
----------------------


I looked into builtpublishBOs.log and this is what is in there:
-----------------------------------------
BuildPublishBOs: starting. BOD Version 2 selected
Exception: Error loading: User
at Asi.Business.BusinessController.get_BusinessRule()
at Asi.Business.BusinessFilter.GetFilterInfo(BusinessController controller, BusinessFilter[] filters, String& whereText, DataParameter[]& parameters, String& dbWhereText)
at Asi.Business.BusinessController.SelectWithFilter(BusinessFilter[] filters, Boolean loadFromDatabase, String sort, Boolean forceReload, Boolean publishedOnly, Boolean ignoreLicensing, Boolean isVersioned)
at Asi.Business.BusinessController.SelectWithFilter(BusinessFilter[] filters, Boolean loadFromDatabase, String sort, Boolean forceReload, Boolean publishedOnly, Boolean ignoreLicensing)
at Asi.Business.Common.UserController.User(String userName, BusinessContainer container, Boolean forceReload)
at Asi.Security.SecurityContext.AuthenticateByUserId(String userId, RolePrincipal rolePrincipal)
at Asi.Security.SecurityContext.LogonByUserId(String userId)
at BuildPublishBOs.BuildPublishBOs.InitializeAndLogIn()
at BuildPublishBOs.BuildPublishBOs.Main(String[] args)
----------------------------------
 
I can login to iMIS desktop and public view but when I click on menus that are using .NET (like Process Manager, IQA....etc) I get the same error below:
 
Server Error in '/iMIS15' Application.
--------------------------------------------------------------------------------

Input array is longer than the number of columns in this table.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Input array is longer than the number of columns in this table.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[ArgumentException: Input array is longer than the number of columns in this table.]
System.Data.DataTable.NewRecordFromArray(Object[] value) +4822363
System.Data.DataTable.LoadRow(Object[] values, LoadOption loadOption, Index searchIndex) +618
System.Data.DataTable.LoadDataRow(Object[] values, LoadOption loadOption) +309
Asi.Business.BusinessController.ImportRows(String cmdText, DataParameter[] parameters, Boolean forceReload) +1255
Asi.Business.BusinessController.get_Item(Object[] primaryKeys, Boolean forceReload, Boolean publishedOnly, Boolean allowRecycled) +2753
Asi.Business.BusinessController.get_Item(Object[] primaryKeys, Boolean forceReload, Boolean publishedOnly) +57
Asi.Business.Common.DocumentHierarchyController.get_Item(Guid hierarchyKey, Boolean forceReload, Boolean publishedOnly) +172
Asi.Business.Common.DocumentHierarchyController.DocumentHierarchy(Guid hierarchyKey, BusinessContainer container, Boolean forceReload, Boolean publishedOnly) +119
Asi.Web.UI.Common.BSA.ObjectBrowser.set_DocumentHierarchyKey(Guid value) +60
Asi.Web.UI.Common.BSA.ObjectBrowser.set_RootHierarchyKey(Guid value) +337
Asi.Web.UI.Common.BSA.ObjectBrowser.InitTreeView() +1081
Asi.Web.UI.Common.BSA.ObjectBrowser.DataBind() +46
System.Web.UI.Control.DataBindChildren() +211
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +102
System.Web.UI.Control.DataBind() +15
System.Web.UI.Control.DataBindChildren() +211
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +102
System.Web.UI.Control.DataBind() +15
System.Web.UI.Control.DataBindChildren() +211
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +102
System.Web.UI.Control.DataBind() +15
System.Web.UI.Control.DataBindChildren() +211
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +102
System.Web.UI.Control.DataBind() +15
System.Web.UI.Control.DataBindChildren() +211
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +102
System.Web.UI.Control.DataBind() +15
System.Web.UI.Control.DataBindChildren() +211
System.Web.UI.Control.DataBind(Boolean raiseOnDataBinding) +102
System.Web.UI.Control.DataBind() +15
iMIS_ContentManagement_PerspectiveList.OnLoad(EventArgs e) +494
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version:2.0.50727.3082

 
 
I tried to delete all users from the database except manager and administrator, do it all over but it didn't help. 
I have an open case with ASI but so far no solution that would work.
Any help is greatly appreciated.
Zuzana Kelyman
Director, Database Services
AAC&U
 
Zuzana_Kelyman's blog | login or register to post comments | printer friendly version

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Did you manage to resolve

On July 30th, 2010 ann_nguyen says:

Did you manage to resolve this issue as I'm getting the same problem with my upgrade?

login or register to post comments

I'm also getting the same error

On July 30th, 2010 MikeMcCormack says:

Upgraded a client from 10.6 to 15.1.2 and got the same error, "input array is longer than the number of columns in this table"

login or register to post comments

Our problem was that

On July 30th, 2010 Zuzana_Kelyman says:

Our problem was that manager's rights were set tu number 9 instead of 8. I guess some legacy.

Once we set to 8 it all worked.

I would check manager account.

login or register to post comments

Manager Account

On July 30th, 2010 MikeMcCormack says:

I checked the manager account and all the permissions were set to 8

login or register to post comments