(OracleDatabase.cpp:117). (0 : Programmer error: OCI_INVALID_HANDLE

[Former Member]

Hi Experts,

I installed BOR3 with default MYSQL database and i exported it ORACLE DB then it was working fine.

But unfortunately we changed CMS sever redirect port to 6400 instead of 6401 then our BO CMS server went down.

It was unable to UP then we moved to MYSQL DB right know it is working fine with MYSQL DB.

While migrating/creating Oracle DB we're getting given errors.

Error:

mozjsshell_368890_2009_09_15_05_29_07_024_trace.log

Tue Sep 15 2009 11:24:04 GMT+0530 (IST) err: ERROR Failed to get cluster name. (STU00165)

Tue Sep 15 2009 11:24:04 GMT+0530 (IST) err: Error description: Internal error: An unknown exception has occurred.

Tue Sep 15 2009 11:24:06 GMT0530 (IST) /BO_data/boadrs/bobje/setup/jscripts//ccmunix.js started at Tue Sep 15 2009 11:24:06 GMT0530 (IST)

Tue Sep 15 2009 11:24:06 GMT+0530 (IST) About to process commandline parameters...

cmsdbsetup20090915_121438.log

OracleDatabase.cpp:117: TraceLog message 1

2009/09/15 06:44:24.591|>>|A| |454702| 1| |||||||||||||||assert failure: (OracleDatabase.cpp:117). (0 : Programmer error: OCI_INVALID_HANDLE).

OracleDatabase.cpp:117: TraceLog message 2

2009/09/15 06:44:24.593|>>|A|X|454702| 1| |||||||||||||||assert failure: (OracleDatabase.cpp:117). (0 : Programmer error: OCI_INVALID_HANDLE).

Server Details:

BO Sever IP: 10.12................

OS: AIX 5.3 ML7

Oracle client 10.2.0.0 Client

Oracle:

Server IP: 10.12..........

10g Server

Connectivity Oracle user is fine..............

We will appreciate for valuable answers......

Since 3 days we got struck due to this.........

Regards,

Raju.

[Former Member]

Had a similar error I was unable to start the CMS. It gave the following error in the log files

-

---

FILE --> CMS_880_2010_03_18_08_02_04_153_trace

-

---

.\OracleDatabase.cpp:117: TraceLog message 1

2010/03/18 08:02:04.184|>>|A| | 880| 772| |||||||||||||||assert failure:

(.\OracleDatabase.cpp:117). (0 : Programmer error: OCI_INVALID_HANDLE).

.\apsserver.cpp:1723: TraceLog message 2

2010/03/18 08:02:04.184|>>|A| | 880| 772| |||||||||||||||assert failure:

(.\apsserver.cpp:1723). (false : no message).

.\OracleDatabase.cpp:117: TraceLog message 3

2010/03/18 08:02:04.200|>>|A| | 880| 772| |||||||||||||||assert failure:

(.\OracleDatabase.cpp:117). (0 : Programmer error: OCI_INVALID_HANDLE).

-

---

The reason of the error was the BOCMS, BOAUDIT users in ORACLE which hold the BO repositories got expired as no user logged into those accounts

I used the oracle alter command and refreshed the password and THEN restarted the CMS without any problem.

Thanks & Regards

Ishaq

[Former Member]

This is answered by myself

[Former Member]

Raju,

After repointing to Oracle DB, did you try to update the cluster name also? Try to update with cluster name also...

Or the better solution for this is to delete the OBJECT id's from MYSQL db and start the servers.

Follow the below :

SELECT objectid, objname, typeId FROM cms_infoobjects5

WHERE typeid = 16

and objname like '%yourservername%';

delete the rows whatever you get the result..

Thanks,

Anil

[Former Member]

Hi Anil,

Thanks for early Response But I'm unable to find out my Server name on query result.

Find the result:

select ObjectID,TypeID,ObjName from CMS_InfoObjects6

where typeid=16

-

---

ObjectID TypeID ObjName

-

---

7 16 -KYMO)?1CO1KGK9M1!BE{M1KS1K!;V

713 16 )/KMM9)!BE{-1COK)?A)C)51A1COM1KS1K!;`

803 16 )/KMM9)!BE{-KYMO)?K1GEKOM;E+M1KS1K!;`

804 16 )/KMM9)!BE{/1M=OEG9CO1??951C-1-)-71M1KS1K!;{-

805 16 )/KMM9)!BE{/1M=OEG9CO1??951C-1;EM1KS1K!;{

806 16 )/KMM9)!BE{/)M7+E)K/)C)?YO9-MM1KS1K!;{&

807 16 )/KMM9)!BE{/)M7+E)K/M1KS1K!;U

808 16 )/KMM9)!BE{-KYMO)?K1GEKOM-)-71M1KS1K!;{(

809 16 )/KMM9)!BE{-ECC1-O9ECM1KS1K!;V

810 16 )/KMM9)!BE{/1M=OEG9CO1??951C-1GKE-1MM9C5M1KS1K!;{2

811 16 )/KMM9)!BE{-KYMO)?K1GEKOMGKE-1MM9C5M1KS1K!;{-

812 16 )/KMM9)!BE{)/)GO9S1;E+M1KS1K!;W

813 16 )/KMM9)!BE{)/)GO9S1GKE-1MM9C5M1KS1K!;{&

814 16 )/KMM9)!BE{/1MO9C)O9EC;E+M1KS1K!;Z

815 16 )/KMM9)!BE{1S1COM1KS1K!;Q

816 16 )/KMM9)!BE{9CGQO39?1K1GEM9OEKY!;Y

817 16 )/KMM9)!BE{?9MOE3S)?Q1M;E+M1KS1K!;]

818 16 )/KMM9)!BE{GAA1OK9-MM1KS1K!;U

819 16 )/KMM9)!BE{GAK1GEM9OEKYM1KS1K!;X

820 16 )/KMM9)!BE{GAKQ?1MM1KS1K!;S

821 16 )/KMM9)!BE{GK1/9-O9S1)C)?YM9MM1KS1K!;{&

822 16 )/KMM9)!BE{GKE-1MM)C)?YM9MM1KS1K!;]

823 16 )/KMM9)!BE{GKE5K)A;E+M1KS1K!;V

824 16 )/KMM9)!BE{GQ?9-)O9EC;EM1KS1K!;Z

825 16 )/KMM9)!BE{K1GEKO)GG?9-)O9ECM1KS1K!;`

826 16 )/KMM9)!BE{M1OMGKE39?1M1KS1K!;W

827 16 )/KMM9)!BE{M1OMIQ1KYM1KS1K!;U

828 16 )/KMM9)!BE{EQOGQO39?1K1GEM9OEKY!;Z

829 16 )/KMM9)!BE{AQ?O9/9A1CM9EC)?)C)?YM9MM1KS9-1MM1KS1K!;{5

830 16 )/KMM9)!BE{U1+9CO1??951C-1GKE-1MM9C5M1KS1K!;{.

-

---

My server Hostname is 'CNDADARXYZ'

Can you pls suggest me............

Edited by: RBolla on Sep 21, 2009 7:41 AM

Edited by: RBolla on Sep 21, 2009 12:29 PM