Turns out I'm using an incompatible Informix client. I looked at the compatibility matrix when I started the upgrade process and saw that for Informix on solaris the minimum db version is 10. I have that db on my db server and used the v10 client on my app server to upgrade to ARS v7.1 last year so I figured I was good.
Not so fast grasshopper! I'm being told by BMC that only v9.2 of the Informix client is compatible and that is why it's failing. My DBA says 9.2 is no longer supported by Informix and is about 5 years old. The reason I'm upgrading to 7.5 is because for support reasons we are upgrading to Informix 11 and ARS v7.1 isn't compatible with v11. This is such crap On Tue, Jun 15, 2010 at 3:11 PM, Donald Morton <[email protected]> wrote: > This may be something that your Informix DBA may be able answer better. > > I would get the exact SQL used to connect from the install's sql.log > (usually this is in a temp directory. /usr/tmp maybe?). Send the connect > line and the error message to a dba expert, and they'll likely be able to > tell you something. > > Are you running dbaccess as the same user that Remedy is starting up as? > > > > > On Jun 14, 2010, at 4:00 PM, Joe D'Souza <[email protected]> wrote: > > That's a great question.. Also along with the install log in the same >> directory there is another log which has a little more verbose than the >> install log. You may want to check all those logs that get generated on >> that >> directory.. >> >> Joe >> >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> [mailto:[email protected]]on Behalf Of Grooms, Frederick W >> Sent: Monday, June 14, 2010 5:49 PM >> To: [email protected] >> Subject: Re: Problems Installing 7.5 on Solaris/Informix >> >> >> Is there an SQL log (probably in the same place as the install log)? >> >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> [mailto:[email protected]] On Behalf Of Steve McDonald >> Sent: Monday, June 14, 2010 4:45 PM >> To: [email protected] >> Subject: Re: Problems Installing 7.5 on Solaris/Informix >> >> ** It's an upgrade and the system works fine. >> On Mon, Jun 14, 2010 at 2:35 PM, Joe D'Souza <[email protected]> wrote: >> ** >> Steve, >> >> Is this a fresh install? Or an upgrade? If its a fresh install, there >> technically should be no config files available unless you copied one from >> some other environment? In which case you will need to edit the >> configuration information manually on that one to point to the dev >> instance >> of the database. >> >> If it is an upgrade you are attempting, does the system currently stop or >> start with no problems? >> >> Joe >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> [mailto:[email protected]]on Behalf Of Steve McDonald >> Sent: Monday, June 14, 2010 5:24 PM >> To: [email protected] >> Subject: Re: Problems Installing 7.5 on Solaris/Informix >> ** >> I probably wasn't clear enough. This is during the install process, right >> after inouting the database info. It trys to connect and throws the >> "Could >> not connect" message. I looked at the 7.1 install logs and the install >> never asked for 'AR System Server DB Login ID" or the password. I'm sure >> it >> pulled the connection info from the onconfig file. That would be the >> correct thing to do. >> On Mon, Jun 14, 2010 at 11:40 AM, Joe D'Souza <[email protected]> wrote: >> ** >> Steve, >> >> Put the AR Server in a startup debug mode and then try to restart.. This >> is >> done by adding the flag -s (or -d I don't recall clearly) in the >> armonitor.conf file. Check for details on setting that flag on the AR >> Configuration Guide.. >> >> The server when in a debug mode during startup, writes additional logs to >> a >> file that gets created in the server directory. That file may have more >> information on why the startup fails.. >> >> Cheers >> >> Joe >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> [mailto:[email protected]]on Behalf Of Steve McDonald >> Sent: Monday, June 14, 2010 2:30 PM >> To: [email protected] >> Subject: Problems Installing 7.5 on Solaris/Informix >> ** >> I am trying to upgrade ARS on my dev server which connects to a remote >> database server. I'm getting "Cannot connect to the Informix server" >> error. Install log only says "SET PROPERTY >> VALIDATION_ERROR_RESULT],Detail=[INFORMIX_CONNECTION_ERROR]" and no >> details. Informix logs show nothing. >> >> I can use dbaccess from my app server to access the db on the remote db >> server. I can also telnet using the specific port the Informix client >> uses >> to communicate(telnet suncoast 1721). >> >> I threw everything over to BMC Support but the response time is killing >> me. >> I go on vacation Tursday morning and I'd really like to have the dev >> server >> conquered before I go. >> >> Thanks! >> >> Steve McDonald >> App server - Solaris 10 >> Database server - Informix 10 on Solaris 10 >> >> >> _______________________________________________________________________________ >> > > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" >> > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
