Aaah! I see.. so that explains it... Anyway, I will be checking the installation of the oracle client we have and see if any libraries/permissions are permissions or oracle env badly set up or version mismatch etc...
Let you know next week. thanks ________________________________ De : Jarl Grøneng <jarl.gron...@gmail.com> À : arslist@ARSLIST.ORG Envoyé le : Jeu 24 juin 2010, 8h 36min 01s Objet : Re: unable to connect to database, rc = 550 My experience with AIE on Windows and AR Server on Unix: - you can run the rulehelper without sqlclient on the AIE server, but the exchange failes with no sqlclient. -- Jarl 2010/6/23 Frex Popo <frexp...@yahoo.fr>: > ** > We are on ARS/ITSM7.6. > Oracle 10 database. > > We have an exchange which connects to an Oracle database to retrieve some > data. The exchange howevere fails with the following error: > > [Tue Jun 22 2010 16:38:56.5370] - <TID: 001> <DTL > Oracle.Initialize: > Verifying configuration parameters > [Tue Jun 22 2010 16:38:56.5370] - <TID: 001> <STS > Scheduled Only mode, > Execution at specified Interval > [Tue Jun 22 2010 16:38:56.5370] - <TID: 001> <API > + CMDBInitialization > [Tue Jun 22 2010 16:38:56.5370] - <TID: 001> <API > - > CMDBInitialization OK > [Tue Jun 22 2010 16:38:56.5370] - <TID: 001> <API > + CMDBSetServerPort -- > PortNum [7511] RPC [0] > [Tue Jun 22 2010 16:38:56.5370] - <TID: 001> <API > - CMDBSetServerPort OK > [Tue Jun 22 2010 16:38:56.6150] - <TID: 001> <DTL > CONNECT inventory > [Tue Jun 22 2010 16:38:56.6150] - <TID: 001> <DTL > Error - OCIEnvCreate > [Tue Jun 22 2010 16:38:56.6150] - <TID: 001> <DTL > VendorOpenConnection: > unable to connect to database, rc = 550 > [Tue Jun 22 2010 16:38:56.6150] - <TID: 001> <DTL > Error: > Adapter.OpenConnection completed with errors issued > [Tue Jun 22 2010 16:38:56.6150] - <TID: 001> <ERR > StartDataHandlers: > Vendor Data Handler failed to start. > > We can connect with SQLPLUS client to the remote Database from the machine > where the EIE instance is running. > > What does not make sense is that the connection from the Rule Helper Console > works. We are able to load tables and views on the remote database. > > Perhaps the data which the Rule Helper (RuleHelperConsole form) uses has > been created correctly in the remedy databse compared to the data > (EIE:VendorParamLookup form) which the EIE uses to connect for data > transfer? > > Kind Regards > frex > > > > > > > _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"