iMIS

ANSI conversion

I'm doing a test upgrade from 15.1.3 to 15.2.15 and are performing the ANSI conversion separate from the DBupgrader. The conversion never finishes converting our 17 million row (7.5GB) Activity table. When I say never finishes, I mean that after a week of SQL grinding away, it's still working on that table. ASI tech support says this process should take hours, not days. The database log file was very small at the beginning but has grown to 9GB even though my database is set to Simple for this process.

DB server specs:
dual quad core CPU
16GB RAM
70GB free on 150GB drive.
SQL 2005 SP4
iMIS database size is 67GB

App server is separate box but we're not seeing hardly any resources being used during this conversion. We are running the ConvertTablestoANSI.exe on the app server.

What we're seeing is that eventually SQL server consistently spikes at 96% CPU on that box and stays at that level. It also takes most the RAM on that box as SQL usually does. The Activity_bak is being created and I've seen at least 4.9 million rows being copied to the Activity table. Later on in the process, if we try to login to SQL Studio to see how large the new Activity table has grown, we get a time out error on the connection. Both these servers are VMs so we've stopped the process and reverted back to snapshots twice but have gotten the same result after each time we've

Has anyone experienced poor performance on the ANSI conversion? Any suggestions as to options we should try would be greatly appreciated!

Mark Pellicore
Second Baptist Church Houston

TaskCentre running multiple instances?

I've got a question about a task possibly running multiple instances of itself creating duplicates in imis db.

99% of the time this task runs fine every 1min and creates rows and sets a flag to indicate these rows don't need to be added again, but for some reason 1% of the time this task seems to repeat the creation of the row causing duplicates. One of our providers suggested we set the maximum concurrent instances option within general tab --> options --> advanced --> to unlimited instances from the previous setting of single instance in hopes of solving this issue. Reasoning being it would give taskcentre more opportunity to catch up if it was behind from running this task every 1min. My thinking is this might not work because allowing concurrent instances would mean the task could create more duplicates by running multiple instances of the create row step before creating the flag step.

RiSE Public Profile Link In IQA Search Result

In the search results for the RiSE Directory, I am trying to link the individual's name in the search results to their public profile, however, I cannot get the ~/Party.aspx&ID=[id] link to work unless I also include the id field in my displayed search results. I obviously don't want the ID of the member to display in the search results when a member searches, so is there a way around this?

Thanks,

Unable to use CStaffUser object in iMIS 20.1.19

After upgrading to iMIS 20.1.19, we now receive the error "Type 'Asi.iBO.CStaffUser' with data contract name 'CStaffUser:http://schemas.datacontract.org/2004/07/Asi.iBO' is not expected. Consider using a DataContractResolver or add any types not known statically to the list of known types"

This occurs whenever we user the "CStaffUser.GetDefaultStaffUser or CStaffUser.LoginByUserId"

Has anyone found a viable workaround for this issue? If we use "CContactUser.LoginByWebLogin("MANAGER")" as an alternative, it messes up the current user's cart, since it's authenticating the session to the manager account.

Connection to SOA blocked by firewall. Baffled.

I'm configuring a Vyatta gateway/firewall in front of several web servers I have hosted by Softlayer. Those servers host a combination of RiSE, eCM, and Kentico websites, all of which talk to the iMIS SOA, which is hosted on a webserver *outside* of Softlayer (on my LAN). An example URL for the SOA is http://sahm.tsgiforest.com/iMIS15/AsiCommon/Services/Membership/Membersh...

we have the normal set of rules configured on the firewall (allow inbound traffic on ports 80,443,1433,25, etc), and in almost every respect, the firewall is doing it's job correctly.

iMIS Crystal Report Permissions (Cross Posted)

Hello All,

Currently users need to have a system admin level of 8 (which I'm not liking) in order to run some crystal reports (new & old) out of iMIS (20.1.1.4). I've gone through the elimination process of rights via our SQL server (where I'm creating the reports), key word access and other user security levels within iMIS.

Has anyone experienced this before and if so how did you resolve it? Also, is there a setting somewhere I can check or change.

Incorrect Syntax near 'WHERE' error when Online Membership Application tries to Save Contact.

I have this error only in my UAT environment. When the online membership application is attempting to do the Contact Save, it encounters this error. As it happens there is the dll which has the Contact.Save initiated and it throws the error.

It is working perfectly in Dev & Production, but not in UAT.

System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'WHERE'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Asi.iBO.DataServer.ExecuteNonQuery(CommandType commandType, String sql, SqlParameter[] commandParameters) at Asi.iBO.ContactManagement.CExtTable.SaveTable(DataServer server)
at Asi.iBO.ContactManagement.CExtTable.Save(DataServer server) at Asi.iBO.ContactManagement.CContact.Save(DataServer server, Boolean validate, Boolean flowDown, Boolean useTransaction)
at Asi.iBO.ContactManagement.CContact.Save(DataServer server, Boolean useNewTransaction) at Asi.iBO.ContactManagement.CContact.Save(DataServer server)
at Asi.iBO.ContactManagement.CContact.Save() at Avion.EMAN.EMAMember.SaveContact(CContact contact, String InstitutionId, String CustomeTypeCode, Boolean IsKeyContact, IiMISUser user)....

Structure of SOAP messages to interface with Imis

We're currently in the progress of linking Imis to one of our own systems.
To do that, we'll rely heavily on SOA,

Apparently we should be able to do almost everything with the SOA options of Imis, but the difficulty is that the documentation and the WSDL are not really giving enough information about all entities to construct the Soap messages. Most of the examples are .net examples, while we would like to just use plain soap calls.

Unable to update Address and Demographic data using IBO coding - iMIS 20.1.19.2470

Below IBO code works fine in earlier versions (IMIS 15.13, IMIS 15.2, iMIS 20.1.13.1540 ), but not working in iMIS 20.1.19.2470

Client having three address type: Main, Journnal, Home
Trying to update Address and Demographic table.

Asi.iBO.ContactManagement.CContact _CurrentUser = null;
Asi.iBO.ContactManagement.CAddress _MainAddress = null;
//Asi.iBO.ContactManagement.CAddress _JournalAddr = null;

Using Order_Meet.UF_6 in WCM site

iMIS 15.2.15.4667:

How would I use the Order_Meet.UF_6 in a WCM site?

What I'm trying to achieve here is using the UF_6 field as a 'Dietary Reqs' so to capture user input values to be stored in the Order_Meet table for that registrant.

Is using Panel editor the way to go? If yes, how do I create a new panel using Order_Meet as a source?

Thanks,
Vignesh