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:[email protected]]
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"<<inline: image001.gif>>
