Hello list! The other day I upgraded my SRM 2.2 app form Patch 001 to patch 003. Of coure it loaded the patch 002 components as well, which includes a couple of SQL scripts that re-map the question mapping forms. Well, these scripts failed to execute and none of my question mapping would function after the patch install. So I went ahead and wrote a sql query to perform the updates and wound up having to do field type conversions to get the script to function properly. I'm curious if anyone else ran into this issue while patching SRM 2.2. I'm wondering if it is a defect with the product or a dysfunction that is solely applicable to my environment. I had opened a ticket with BMC and their response was to restore my database and install the patch again. I'm running ARS 7.5 Patch 002 on Windows 2003 64-bit with SQL 2005 backend. The two tables that didn't convert were SRM_MasterDataMappingLIst and SRM_SourceToTargetDataAssociat. The issue being that the columns being modified are TEXT and that data type is not valid within the context of T-SQL's REPLACE command. Thanks all!
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
