Try this sql: select count(rowid) from user_cache / The fact that user_x is missing is worrisome. This more than likely means that the user form does not exist on the server.
Try using arcache to create a temporary admin user. See the ARS config guide for instructions and examples. Chances are you will need to re-run the installer. Prior to re-installing: - Remove/uninstall the existing ARServer - Delete all existing objects in the schema or delete the schema altogether Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Mon, Jun 29, 2009 at 2:12 PM, Rao Rao <[email protected]> wrote: > ** Joe/Axton, > > Joe, I ran the sql for Alerts. Please see below. > > SQL> Select count(*) from arschema where name = 'Alert Events'; > COUNT(*) > ---------- > 1 > > = = = = = > > Axton, Please see my earlier mail on the sqls - you asked. Thanks to both > of you for help and sparing time. > > With Regards, > > Rao > > On Mon, Jun 29, 2009 at 2:34 PM, Joe DeSouza <[email protected]> wrote: > >> ** >> At what point and how do you reproduce that error then? >> >> Have you checked if the entry for the Alerts form does exist in the >> arschema table? (Select count(*) from arschema where name = 'Alert Events';) >> >> Joe >> >> ------------------------------ >> *From:* Rao Rao <[email protected]> >> *To:* [email protected] >> *Sent:* Monday, June 29, 2009 1:15:07 PM >> *Subject:* Re: Installation of AR server 7.1 - No Alert Events form could >> be found on the server (ARERR 3300) >> >> ** >> Thank you Axton. I reinstlled the app. This time also it failed with >> the same error message. arerror.log does not show any error. Following is >> the arrerror log. >> >> = = = = = = arerror.log = = = = >> Mon Jun 29 12:47:46 2009 : Action Request System(R) Server Version 7.1.00 >> Build 200708221849 >> (c) Copyright 1991-2007 BMC Software, Inc. >> Mon Jun 29 12:47:46 2009 390600 : This version of the Action Request >> System(R) is ready for use or evaluation without purchasing or activating an >> authorization key. >> For unlimited capabilities, contact your sales representative. (ARNOTE 27) >> = = = = = = = = = = >> >> armonitor.log shows the following: >> >> = = = = armonitor = = = = >> Mon Jun 29 12:47:44 2009 (ARNOTE 0) >> Mon Jun 29 12:47:44 2009 AR Monitor version 7.1.00 Build 200708221849 >> started. >> Mon Jun 29 12:47:44 2009 (ARNOTE 0) >> Mon Jun 29 12:47:44 2009 AR Monitor started. >> Mon Jun 29 12:47:44 2009 (ARNOTE 0) >> Mon Jun 29 12:47:44 2009 ARMonitor child process (pid:4384) started. >> "c:\program files\ar system\vanaja\arserver.exe" >> Mon Jun 29 12:47:44 2009 (ARNOTE 0) >> Mon Jun 29 12:47:44 2009 ARMonitor child process (pid:2936) started. >> "c:\program files\ar system\vanaja\arplugin.exe" >> Mon Jun 29 12:47:44 2009 (ARNOTE 0) >> Mon Jun 29 12:47:44 2009 ARMonitor child process (pid:2276) started. >> "c:\program files\ar system\vanaja\arsvcdsp.exe" >> Mon Jun 29 12:47:44 2009 (ARNOTE 0) >> Mon Jun 29 12:47:44 2009 ARMonitor child process (pid:4912) started. >> "c:\program files\java\jre6\bin\java" >> Mon Jun 29 12:47:44 2009 (ARNOTE 0) >> Mon Jun 29 12:47:44 2009 Pausing for max 900 seconds or until server >> up. >> = = = = = = = = = = >> >> following are contents of ar.cfg file. >> >> = = = = ar.cfg = = = = >> >> Alternate-Approval-Reg: T >> Private-RPC-Socket: 390603 1 1 >> Private-RPC-Socket: 390601 1 1 >> ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\arapi71.jar; >> ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\axis.jar; >> ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\log4j-1.2.8.jar; >> ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\websvc71.jar; >> ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\wsdl4j-1.5.1.jar; >> ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\xercesImpl.jar; >> ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\xmlParserAPIs.jar; >> ARF-Java-Class-Path: C:\Program Files\AR >> System\Vanaja\commons-logging-1.0.4.jar; >> ARF-Java-Class-Path: C:\Program Files\AR >> System\Vanaja\commons-discovery-0.2.jar; >> ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\jaxrpc.jar; >> ARF-Java-Class-Path: C:\Program Files\AR System\Vanaja\saaj.jar; >> Plugin: WebService.dll >> Homepage-Form: Home Page >> Full-Text-Temp-Directory: C:\Users\Rao\AppData\Local\Temp >> Full-Text-Collection-Directory: C:\Program >> Files\Hummingbird\SearchServer60\fultext >> Full-Text-Configuration-Directory: C:\Program >> Files\Hummingbird\SearchServer60\fultext >> Plugin: arealdap.dll >> Plugin: ardbcldap.dll >> Plugin: ardbcconf.dll >> Plugin: FlashboardObject.dll >> Plugin: ServerAdmin.dll >> Plugin: reportplugin.dll >> Register-With-Portmapper: T >> Db-name: ARSys >> Server-Name: Vanaja >> Oracle-SID: orcl >> Currency-Ratio-Client-Refresh-Interval: 60 >> Multiple-ARSystem-Servers: F >> Server-directory: C:\Program Files\AR System\Vanaja\Arserver\Db >> >> >> On Mon, Jun 29, 2009 at 11:17 AM, Axton <[email protected]> wrote: >> >>> What does the arerror.log show for the time when the ARServer is starting >>> up? >>> What does armonitor.log show during a startup? >>> What ARERR number is associated with the login failure? Is is the 3300? >>> a. If it is the 3300, update the ar.conf and disable alert events. >>> Are there any failures in the install logs prior to the one provided? >>> >>> Axton Grams >>> >>> The opinions, statements, and/or suggested courses of action expressed >>> in this E-mail do not necessarily reflect those of BMC Software, Inc. >>> My voluntary participation in this forum is not intended to convey a >>> role as a spokesperson, liaison or public relations representative for >>> BMC Software, Inc. >>> >>> On Mon, Jun 29, 2009 at 9:57 AM, Rao Rao<[email protected]> wrote: >>> > ** >>> > Hi List, >>> > >>> > Can some one please help me with the below issue? Thanks. >>> > Platform: Windows >>> > Databae: Oracle 10g >>> > >>> > Installed AR server 7.1 on Windows platform under Oracle 10g. This is >>> a new >>> > installation. After installation, I tried to connect to the AR server >>> > through Admin and User tools. I am getting the following error. I >>> tried to >>> > connect through user id: Demo and gave no password. >>> > >>> > No Alert Events form could be found on the server (ARERR 3300) >>> > >>> > user: Demo, server: ARDev >>> > Unable to successfully log in to any server. >>> > >>> > In the services section, I could see the service running - - - BMC >>> Remedy >>> > Action Request System Server. And the service - AR System Portmapper - >>> is >>> > also started. >>> > >>> > In the instllation log - ActionRequestSystem.log - I see the >>> following >>> > error. >>> > >>> > [Sat Jun 27 17:22:55.047] RikMain- RIK utility version/timestamp: >>> 7.1.00 >>> > Build 200708201922 >>> > [Sat Jun 27 17:22:55.047] RikMain- Command = rik veradmin -x localhost >>> -t 0 >>> > -u Demo -p "******" -f -m -l C:\Program Files\AR System\ARS -n Action >>> > Request System -o 0 >>> > [Sat Jun 27 17:22:55.047] RikMain- ARInitialization Complete >>> > [ERROR][Sat Jun 27 17:22:55.078] VerifyControl- ARVerifyUser failure >>> > [ERROR][Sat Jun 27 17:22:55.078] VerifyControl- 3300 No Alert Events >>> form >>> > could be found on the server >>> > [ERROR][Sat Jun 27 17:22:55.078] RikMain- Problem with verification of >>> > user/pw/server information >>> > [Sat Jun 27 17:22:55.078] RikMain- ARTermination complete >>> > [Sat Jun 27 17:22:55.078] RikMain- Returning 3300 for RIK subcommand >>> > veradmin >>> > Sincerely, >>> > >>> > Rao >>> >> >> _Platinum Sponsor: [email protected] ARSlist: "Where the Answers >> Are"_ >> > > _Platinum Sponsor: [email protected] ARSlist: "Where the Answers > Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
