Hi,
Apparently the Group-forms has become corrupt.
The easiest way may be to delete the form, and import it anew. Make sure
you have definitions of all related objects for the new import.
If this fails, or you want to patch things up, you must add the missing
columns by hand in the SQL Database so that it corresponds with what the
AR System is expecting.
Turn on SQL logging and create similar columns in another form to see the
exact SQL syntax required for your DB.
If all else fails, you may want to restore the system to the 7.5 state,
and then do a fresh install of 7.6.04, and finally copy the custom DEF:s
and the data using RRR|Chive...
Best Regards - Misi, RRR AB, http://www.rrr.se
Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> Hello list,
>
> I have recently began trying to upgrade from ARS 7.5 fully custom (No
> ITSM) to 7.6.4 and the installer gives an error stating that it failed
> although I'm able to start the ARS service and it shows that its on 7.6.4
> version. The indtall log show the following to Sever errors:
>
>
> Issue Details:
>
> Server: WIN2008 64bit
>
> SQL 2008 64bit
>
> ARS: 7.6.4
>
>
>
> LOG EVENT {Description=[[resultType=COMPLETED,exitCode=2]],Detail=[RIK
> command ("C:\Users\hwrarod.JSQ\AppData\Local\Temp\Utilities\rik\rik.exe"
> loadapp -x EDIDVWREMA01.bsg.ad.adp.com -t 0 -u "Action Request Installer
> Account" -p <not_displayed> -l "D:\Program Files (x86)\Remedy" -n
> ARServer-RIK_PostUpgrade -f "D:\Program Files
> (x86)\Remedy\ARServer\installforms\en\adf_ServerApps1_en.xml" -m nosamp
> -k 0 -L -c) returned an exit code of 2, which was interpreted as a
> failure]}
>
>
>
> THROWABLE EVENT {Description=[Failed to execute Rule
> Engine],Detail=[[ERROR][Fri Mar 04 12:47:04.162] ImportFileNode-
> ARImport() for "Group.def" returned non-zero return code 2 [ERROR][Fri
> Mar 04 12:47:04.162] ImportFileNode- 552 The SQL database operation
> failed. The COMMIT TRANSACTION request has no corresponding BEGIN
> TRANSACTION. (SQL Server 3902) [ERROR][Fri Mar 04 12:47:04.162]
> LoadComponent- Definition Import failed for D:\Program Files
> (x86)\Remedy\ARServer\installforms\en\Group.def (return code 2)
> [ERROR][Fri Mar 04 12:47:12.591] ImportFileNode- ARImport() for
> "UserPasswordChange.def" returned non-zero return code 2 [ERROR][Fri Mar
> 04 12:47:12.591] ImportFileNode- 552 The SQL database operation failed.
> The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
> (SQL Server 3902) [ERROR][Fri Mar 04 12:47:12.591] LoadComponent-
> Definition Import failed for D:\Program Files
> (x86)\Remedy\ARServer\installforms\en\UserPasswordChange.def (return
> code 2) [ERROR][Fri Mar 04 12:47:12.591] LoadComponent- At least one
> file in definitions list returned an error [ERROR][Fri Mar 04
> 12:47:19.650] LoadComponent- Errors processing component GroupUser,
> worst overall return code = 2 [ERROR][Fri Mar 04 12:47:22.129]
> ImportFileNode- ARImport() for "AlertList.def" returned non-zero return
> code 2 [ERROR][Fri Mar 04 12:47:22.129] ImportFileNode- 552 The SQL
> database operation failed. The COMMIT TRANSACTION request has no
> corresponding BEGIN TRANSACTION. (SQL Server 3902) [ERROR][Fri Mar 04
> 12:47:22.129] LoadComponent- Definition Import failed for D:\Program
> Files (x86)\Remedy\ARServer\installforms\en\AlertList.def (return code
> 2) ...]}
>
> ------------------------
>
>
>
> Also, I tried importing the failed forms using dev studio and get the
> following message:
>
> The SQL database operation failed. The COMMIT TRANSACTION request has no
> corresponding BEGIN TRANSACTION. (SQL Server 3902)
>
>
>
> I get the following errors when trying to perform search on the following
> forms:
>
> User form:
>
>
>
> ARERR [552] The SQL database operation failed. : Invalid column name
> 'C301600300'. (SQL Server 207)
>
>
>
> I also get the following error on Group form:
>
> ARERR [552] The SQL database operation failed. : Invalid column name
> 'C301600300'. (SQL Server 207)Invalid column name 'C139'. (SQL Server
> 207)Invalid column name 'C136'. (SQL Server 207)Invalid column name
> 'C134'. (SQL Server 207)
>
>
>
> Anyone see this problem before?
>
>
>
> Regards,
>
>
> Rafael Rodriguez|Manager Remedy/Mid-Tier Enterprise|Broadridge Financial
> Solutions
> 2 Journal Square Plaza|Jersey City, NJ 07306| 201.714.3718 p
> [cid:image001.gif@01CBDD01.9DF3FDB0]
>
>
> This message and any attachments are intended only for the use of the
> addressee and
> may contain information that is privileged and confidential. If the reader
> of the
> message is not the intended recipient or an authorized representative of
> the
> intended recipient, you are hereby notified that any dissemination of this
> communication is strictly prohibited. If you have received this
> communication in
> error, please notify us immediately by e-mail and delete the message and
> any
> attachments from your system.
>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
