Hi there, I searched to forums and couldn't find a similar question. So here is a new one I guess.
Working with Tags in WCM, I've come across an issue with using nested tags and the 'match all tags' option in the Tagged List iPart (SMR 284989)
We've a client who is in the process of migrating from 10.6 to 15.2.15 and uses tags - a LOT. They have a significant amount of archived, and tagged, content dating back to 2003. I've tried to un-nest the tags via the GUI by dragging and dropping to the root (Tag), but that ended up not doing anything useful (nothing in chrome and in IE, it creates an error (Exception message: Object reference not set to an instance of an object. at Asi.Business.Common.HierarchyController.MoveBranch(Guid moveHierarchyKey, Guid targetHierarchyKey, HierarchyAddType addType)
Introduction to Problem:
We had a client who moved to another CRM provider but wanted to manage their website’s content with iMIS WCM. The challenges were 1) validating user credentials against the 3rd party CRM when they log in through iMIS, 2) after validation is successful, activate the iMIS website security and 3) add a record in iMIS when the user exists in the 3rd party CRM but not iMIS.
A new client recently upgraded from iMIS 10.6 to 15.2.5. During the upgrade, I discovered that the database is case-sensitive. Apparently this collation setting is creating problems in the new version of iMIS. For instance, some functions that staff try to perform, such as billing dues, generate an error message stating that iMIS "cannot resolve the collation conflict". I tried to run the ALTER DATABASE command for changing the database collation from SQL_Latin1_General_CP850_BIN (case-sensitive) to SQL_Latin1_General_CP1_CI_AS (case-insensitive). However, SQL throws all kinds of errors saying that numerous objects and columns are "dependent on database collation." Two of these obects were views, which I simply altered to get rid of the "WITH SCHEMABINDING" until the collation could be changed, then put them back. Some of these objects were Functions that I deleted temporarily. Then I ran into a coupe of tables whose columns were dependent of the db schema, after which I got stuck.
Rather than go through all of this hassle, maybe someone out there has a better way. If anyone has a script or methodology for changing the db collation, would you be willing to share it? If you don't know of a better way, do you know how to temporarily remove the schema depedency for columns in a table? The columns are found in the GiftAidClaimDetail table. One is called TaxReclaimAmount and the other is called LabelName. Both of these columns are COMPUTED, which is probably where the schema dependency is coming in.
Thanks for any help you can give.
I've shared many times over the years the recommendation to split the iMIS database into multiple data files. This was based on some notes I read about Microsoft's Terraserver. Without solid guidance, I have been advising clients to split their databases into enough data files so each file was between 512MB and 2GB. (Originally, my thought was that a 2GB file can be transfered on a FAT partition if needed.) This was largely a guess with some useful side-benefits.
It's sometime useful to search an entire database to find out where some specific data is... for instance, you entered data into the UI but you aren't sure where it got stored.
This post contains a SQL Script to search a database for any specific string in any column in any table in your database.
To use this script, simply edit the first line to set the @value variable to the string you wish to search for (see the comment). You can include "%" as the standard SQL Wildcard character. As is, the script will search for any string starting with "C:\" ... but you can use exact strings or any arbitrary string you wish.
I have a rather large committee that I'd like to replicate (with a different name) within iMIS 15.0. Is there an easy way to do replicate/duplicate committees in iMIS?
This is a stored proc to take an input URL with a query string and split out the URL and the individual query string parameters. For example, if you're considering a URL like this:
I've just started testing the SOA in C# and have successfully developed the add person function and added the other items such as informal name, prfix, suffix etc. Now I'm trying to add address and other informatio about the person but having very little luck. I'v been reviewing the documentation but found it to be a little confusing. Could someone just point me in the right direction or maybe furnish some real world examples.
I'm trying to use the sysresHashPwd function to return a value in SQL thinking that this may be the function that is hashing the Password field in Name_Security. When I use the following:
SELECT dbo.sysresHashPwd ('password')
I receive the following message:
Error in Initialize(): 429
So there are 2 questions:
- What can I do to work through this error so that I can use the sysresHashPwd function?
- Is this the function that iMIS uses when it hashes passwords?