Hi,
I am facing the issues while using the AIE 'Test Connection'. Followed steps:
-AIE Console
-In the 'Connections' -> SQL -> Entered the SQL DB severe details like Server,
Database, Username/ password
-Click on 'Test Connection' ->'Get Result' will appear
-Click on 'Get Result', an ARNote will come up:
SQL Rule Helper utility is busy verifying the Data Store Connection + Workflow
Name(AL)
Some workflows (guides) are firing and throwing this note. After sometime, no
output and we can perform any other activity on User tool. BUT....
At the server end, the arerror log used to fill up with the following lines in
every hour and finally stopped the server:
Mon Jun 20 09:06:59 2011 : Action Request System(R) Server Version 7.5.00 Patch
006 201007180200
(c) Copyright 1991-2009 BMC Software, Inc.
Mon Jun 20 09:07:03 2011 390600 : SQL database is not available -- will retry
connection (ARNOTE 590)
Mon Jun 20 09:07:03 2011 ORA-12541: TNS:no listener
---------------
--------------
Mon Jun 20 09:34:27 2011 390600 : Cannot initialize contact with SQL database
(ARERR 551)
Mon Jun 20 09:34:27 2011 Stop server
Mon Jun 20 09:34:27 2011 390600 : AR System server terminated -- fatal error
encountered (ARNOTE 21)
When trying to restart the arserver, it is not coming up.
Environment: Action Request System(R) Server Version 7.5.00 Patch 006 on Windows
Oracle DB on Unix
External DB for AIE: SQL
Did anyone ever faced the same challenge if configuring AIE? Any solution.
Thanks,
Sachin
________________________________
This message is for the designated recipient only and may contain privileged,
proprietary, or otherwise private information. If you have received it in
error, please notify the sender immediately and delete the original. Any other
use of the email by you is prohibited.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
