Rao, I would suggest to enable SQL-Logging in ar.cfg. Add the following line. Debug-mode: 1 Restart ARServer and post the arsql.log Kind Regards Conny
________________________________ Von: Action Request System discussion list(ARSList) [mailto:[email protected]] Im Auftrag von Joe DeSouza Gesendet: Dienstag, 30. Juni 2009 03:16 An: [email protected] Betreff: Re: Installation of AR server 7.1 - No Alert Events form could be found on the server (ARERR 3300) ** Rao, This means that the H and T tables that are the underlying tables for the said form have perhaps been created already. To verify this first of all find out the schema ID for that form. select schemaid from arscheama where name = 'Alert Events'; Lets say it returns 20.. then the T and H tables for that form will be T20 and H20.. Describe these tables and see if you get a valid description. If you get a nor rows selected result from the above SQL, then you have some problem.. Also describe the view ALERT_EVENTS and see if you get a valid description. You shouldn't get invalid object as a result.. If your results of the above area ll positive, then for some reason this form is not being recognized by the AR System. What you could try is a import in place from the def file in the installforms folder that will exist in your installation directory. I do not have access to the exact name of what that def file will be at the moment but if you cannot figure it out let me know and I'll log into my systems later and get that for you. Joe ________________________________ From: Rao Rao <[email protected]> To: [email protected] Sent: Monday, June 29, 2009 3:12:09 PM Subject: Re: Installation of AR server 7.1 - No Alert Events form could be found on the server (ARERR 3300) ** 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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
