An error occurred while performing operation 'sqlOpenResult' status='-28'.

Shekhar Pokhrel said: I am receiving this error when ever I tried to run the tabular data."An error occurred while performing operation 'sqlOpenResult' status='-28'."what does this mean?Also, it works fine if I choose only one value from prompt?Shekhar ...

RQP-DEF-0177 Anerror occures while performing 'sqlOpenResult' status ='-28'

Could any one will help me out of this problem.Please find the attached snapshot of the error. ...

Cognos report Error - 'UDA-SQL-0114' - 'sqlOpenResult' status='-28'.

I am getting the attached error when I run the report. The version is cognos 8.4.1 and database is Db2. But when I schedule the report, the scheduling is succeeded. Prior to this, it was running perfectly without any error. The report is list and it invloved only 4 joins. Can you please suggest what ...

scheduled job fails

Prem Godugu said: In scheduled job couple of report fails with the following error.RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'. UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive. UDA-SQL-0564 Transaction (Process ID 125) was dead ...

Error with Select & Search prompt in Report Studio

Shashidhar Manthena said: Hi All, We developed a report in Report Studio (Cognos 8.2) with a Select & Search prompt in the prompt page. The parameter query is using a field from a view in the underlying database.It's an optional prompt; so when I run the report ignoring the prompt, it runs fine ...

Tempdb database is full

Mohammed Ismail said: Hi, We are getting below message in cognos log file. our Costpoint database TEMPDB is getting full when cognos user fetches data from costpoint database.172.16.1.211:9300 9240 2008-04-05 19:52:19.006 +3 0 0 11648 QOS 1268 1 Audit.RTUsage.QOS <message code="-28" severity="err ...

converting numeric data type to date?

Bhagat Seihra said: Hi, i have an data item in R.S that shows dates which produces an output like 20090302. The data type of his item is numeric.I would like to convert this to a proper date field, so i have used the following expression:cast(Expired Date, date)When I validate this it returns no err ...

Error in Sql server while Converting Varchar to Integer

Karthikeyan Ramachandran said: Hi Guys..I am getting Error while Conveting Varchar Data Type in to Integer Data Type in Sql server.How can i convert varchar in to Integer Data Types.I used Cast_integer,Cast(<columname>,int)----> no useBelow is the Error MessageRQP-DEF-0177 An error occurred ...

cognos 8.3 transformer error

Bikshapathi Chenchu said: Hi,When iam running the shell script to run the cube in the unix server iam getting an error where as if i run in my machine it works fine.Iam using package as my datasource.The error description is RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' s ...

Error while exporting the report output in PDF, XL or CSV

Parvathy Revindran said: Hi,I am able to get the report output in HTML format and i can even traverse till the bottom of the report. But while trying to run or export in any other format, i am getting the following error message. (I am using Cognos 8.2 and teradata DB for developing reports.)RQP-DEF ...

Getting error while running reports

Dipesh Mistry said: Hi All,I am getting the following errors while running reports. This reports were running well. But sometimes we get this error :-QE-DEF-0177 Error executing operation 'sqlOpenResult' Status='-28'UDA-SQL-0114 The cursor supplied to the operation "APICursor::OpenResult" is inactiv ...

Report sometimes errors when run on in a job

I have several groups of report jobs that run at scheduled intervals. Certain reports in these jobs fail roughly 50% of the time. I have not been able to determine why they are failing or why they are failing some of the tims and not all of the time. I'm running 8.3 SP-5. When I look at the run deta ...

Error While running the report

Pavithra Narayanan said: Hi ,The report was validating fine.But while running the report i m getting the following error..RQP-DEF-0177:An error occurred while performing operation 'sqlOpenResult' status='-28'.UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive. UDA-SOR-0005 ...

Cognos Report is running in Development server, not in Production server

We've migrated reports from Development server to Production server. All the reports are running fine except one report. Also, the report is running as empty for some prompt values. When it has to run with data, it throws the following error. An error occurred while performing operation 'sqlOpenResu ...

Usb-uhci.c and linux hang

Hello. I've and old Red-Hat 9 linux server. It use a new Fast track TX2000 SATA II Raid.Since two weeks, there is a new error on System Messages than hang the linux. The last error before hang up is:Kernel: usb-uhci.c: interrupt, status 28, frame #<number>Kernel: usb-uhci.c: Host controller ha ...

Help, Error about Oracle 9 installation !

I want to install Oracle9 on Sun ultra 5 workstation, but some errors occurred.OS versionolaris 8.0Memory: 256mAfter Copying all files, the Database Configuration Assistant was running, but the procedure stop at the point "Creating and starting Oracle instance",some message popuped as belo ...

Database configuration assistant error

I just installed Oracle9i yesterday to my sun sparc ultra 5 box. I have Solaris 9 (SunOS 5.9) installed on the box, and it has total 256m ram and cpu speed is ultraSparc IIi 350, hard disk size is 9G, and still has about 2.5G left in /var/osDBA/oraHome1 directory, where data folder is. The installat ...

Oracle Problem starting second database

after I was finally able to create a second database it won'tstart. When running the dbstart script it starts the firstdatabase fine and then tries to start the second. it thengenerates the following error messages:SQL> Connected to an idle instance.SQL> ORA-27302: failure occurred at: skgpwre ...

Oracle Running 8.1.7 and 9.0.1 on same server

I've installed 9.0.1 and 8.1.7 on the same solaris server (with different oracle_homes). Each installation runs perfectly, but when I try to have it running at the same time I have the following problem :I begin by strating 8.1.7, it starts without problem,I try then to start 9.0.1 and here is the m ...

Oracle upgrading from 8i to 9i on Redhat 7.2

i want to upgrade a Oracel 8.1.7 Datebase on redhat 7.2 to 9i Release 2.I've sucessfully installed 9i in another directory without a database (software only).(please have a look at http://forums.oracle.com/forums/message.jsp?id=1142756&gid=831195) After that i started the Database Upgrade Assist ...

Installation of Oracle 9.2

I was trying to install an oracle 9.2 on a sun sparc server, but when I was installing "Database Configuration Assistant", I failed! The program report: ORA-27302:failure occurred at skgpwreset1ORA-27303:additional information:invalid shared ctxORA-27146:post/wait initialization failedORA-27300:OS s ...

MySQL Nested If Trigger Calling Procedures

I am Not sure if this will work but them would be happy if someone could show me a result. I have a table to which when I insert I need to check a certain value and based on that perform inserts into different tables is the way I have done right or can there be any other way out. CREATE TRIGGER ins_ ...

Oracle Install failing when running Database Configuration Assistant

I am trying to install Oracle 9i on a new Solaris 9 box. Everything goes fine until oui tries to run the Database Configuration Assistant. It is at the "Creating and starting Oracle Instance" stage that I get a popup which says:ORA-27302: failure occured at: skgpwreset1ORA-27303: additional informat ...

Oracle ORA-27302

I tried to install Oracle 9.2.0.1.0 on my Sun Solaris machine. I failed with the following error message:ORA-27302: failure occured at: skgpwreset1ORA-27303: additional information: invalid shared ctxORA-27146: post/wait initialization failedORA-27300: OS system dependent operation:semget failed wit ...

Oracle Database configuration assistant error

I just installed Oracle9i yesterday to my sun sparc ultra 5 box. I have Solaris 9 (SunOS 5.9) installed on the box, and it has total 256m ram and cpu speed is ultraSparc IIi 350, hard disk size is 9G, and still has about 2.5G left in /var/osDBA/oraHome1 directory, where data folder is.The installati ...

Oracle create database error

I have a oracle 9i instaled in Debian Linux.When I try to create a new database (general purpose), with dbca i get the following error:failure occurred at: skgpwreset1ORA-27303: additional information: invalid shared ctxORA-27146: post/wait initialization failedORA-27300: OS system dependent operati ...

Oracle Database creation errors with 9i on Solaris 9

I am trying to install Oracle 9i database(9.2.0.1) on Solaris 9 (E4500 server with 2GB physical memory and 8 CPU's) using the database configuration assistant. I get the following ORA errors:ORA-27302: Failuer occured at:skgpwreset1ORA-27302: Additional information: invalid shared ctxORA-27146: Post ...

oracle9i occur error when I 'm try to startup it.

SQL*Plus: Release 9.0.1.0.0 - Production on 星期六 1月 28 07:37:07 2006(c) Copyright 2001 Oracle Corporation. All rights reserved.SQL> 已连接到空闲例程。SQL> ORA-27302: failure occurred at: skgpwreset1ORA-27303: addi ...

Oracle Error Ora-27302, Ora-27303, Ora-27146, Ora-27300, Ora-27301

fact: Oracle Server - Enterprise Edition 9.2.0.1fact: HP-UX 11iCreando una nueva instancia me da los siguientes errores:ORA-27302: failure occurred at: skgpwreset1ORA-27303: additional information: invalid shared ctxORA-27146 : post/wait initialization failedORA-27300: OS system dependent operation: ...

Oracle pls help -startup error

when i used the following command, the error happened.startup mount pfile=/oracle/credit/init.oraSQL> startup mount pfile=/oracle/credit/init.oraORA-27154: post/wait create failedORA-27300: OS system dependent operation:semget failed with status: 28ORA-27301: OS failure message: No space left on ...

Oracle startup error-help

when i used the following command, the error happened.startup mount pfile=/oracle/credit/init.oraSQL> startup mount pfile=/oracle/credit/init.oraORA-27154: post/wait create failedORA-27300: OS system dependent operation:semget failed with status: 28ORA-27301: OS failure message: No space left on ...

Oracle ORA-27154: post/wait create failed

i am runing Oracle 9i R2 on SunOS 5.9 , i tried to startup my database and it gives me this error:ORA-27154: post/wait create failedORA-27300: OS system dependent operation:semget failed with status: 28ORA-27301: OS failure message: No space left on deviceORA-27302: failure occurred at: sskgpsemsper ...

installing oracle 10g release 2 on spark solaris!! urgent help!

Am installing oracle 10g r2 on spark sun solaris. I did install the software without any pb, but when installing the database using dbca, I have this errors.ORA-27154: post/wait create failedORA-27300: OS system dependent operation:semget failed with status: 28ORA-27301: OS failure message: No space ...

installing oracle 10g release 2 on spark solaris!! urgent help!

Am installing oracle 10g r2 on spark sun solaris. I did install the software without any pb, but when installing the database using dbca, I have this errors.ORA-27154: post/wait create failedORA-27300: OS system dependent operation:semget failed with status: 28ORA-27301: OS failure message: No space ...

Oracle Error when I bounce database

I have two oracle database ver 9i in one unix box sun soliars 8. both one running fine. I increased oracle process from 200 to 300 on each database init.ora file. once I bounce the database one by one i bring it up one database but when i was bring it up the second one i got error. I know this error ...

ORacle error

I have experienced oracle fallowing errors while making the BCV.Errors in file /cbsora/ora92/rdbms/log/udump/bobind_ora_29118.trc:ORA-27154: post/wait create failedORA-27300: OS system dependent operation:semget failed with status: 28ORA-27301: OS failure message: No space left on deviceStandard inp ...

Oracle Database creation Error

I am working in oracle9i and linux 2.4.I am going to create a New database . But i receive the following error as SQL> startup nomount;ORA-27302: failure occurred at: skgpwreset1ORA-27303: additional information: invalid shared ctxORA-27146: post/wait initialization failedORA-27300: OS system dep ...

Oracle Instance startup failure

We have a server which has 4 instances. The details of it are as follows :OS Memory : 4.8GB SGA(in mb) PGA_aggregate_target(in gb)PYS 461 22.8WFPROD 315 24P11 461 24ASE 400 24 Total 1637 94.8 We added 2 more instances to the serverSGA(in mb) PGA_aggregate_target(in gb)OPL_L 901 24REF_L 793 24 3331 1 ...

Oracle Kernal parameter SEMMSL & SEMMNS

HiWe have 6 instances in a HP-UX box (B.11.11) , when i'm starting instances one by one, the last instance got failed to open, error in the alert reported is pasted below. ksedmp: internal or fatal error ORA-27154: post/wait create failed ORA-27300: OS system dependent operation:semget failed with s ...

Oracle Errors during creation of 2nd Instance on Linux

I have installed Oracle 9i DB R2 on Oracle every thing is ok like environment and installation but when i am trying to install 2nd instance from "DBCA" command it is giving me errors mention below.what i did is remove default instance which oracle 9i made during first installation and again install ...

Oracle Problem with RAC

I have a problem with my cluster database.When i start i get this error message on one instance: Specified value of sga_max_size is too small, bumping to 1585446912Fri May 29 13:26:43 2009Errors in file /soft/oracle/10.2.0/db_1/admin/dsibrm/udump/dsibrm2_ora_28152.trc:ORA-27154: post/wait create fai ...

Oracle Can NOT startup database. Error ORA-27300, 27301 and 27302

I tried to startup one new database on ORACLE 10GR2 (10.2.0.3) on Redhar LINUX AS 4.7. I got following messages:ORA-27154: post/wait create failedORA-27300: OS system dependent operation:semget failed with status: 28ORA-27301: OS failure message: No space left on deviceORA-27302: failure occurred at ...

Oracle ASM is not cooming up after reboot due to used semaphore arrays reached.

We have installed oracle 11.2.0.1 grid infra in 8 nodes on RHEL 5.6.After installation we have rebotted the nodes but ASM is not comming up.ERRORS : ORA-27154: post/wait create failedORA-27300: OS system dependent operation:semget failed with status: 28ORA-27301: OS failure message: No space left on ...

How to implement CRC32 function in Buildop

I have read some where that CRC32() is a C function. Hence, I would like to use it parallel job and enable to use runtime column propagation feature.So is it a way to use CRC32() in Builop custom build stage which should written in C++?When I use the function in buildop as such simple code: "q=CRC32 ...

jQuery Finding ID's and Checked status of checkboxes

Hi, I have a form which I populated with checkboxes having ID based on the records pulled from a table.eg: Table contains:ID, Name30, Some thing64, Some one28, Some where70, Some howBy means of pulling info from the table, the eventual form will be:<form><input type='checkbox' id='30' / ...

Status of message queue in ibm AIX

I am new to unix systems.For some king of application i need to display specific message queue status.In solaris and redhat command " ipcs -m -i 32765" is working and diaplays the following output for shared memory.Shared memory Segment shmid=1245185uid=500 gid=500 cuid=500 cgid=500mode=01600 access ...

MySQL 15% of all remote-connects are "unauthenticated user" status "Reading from net"

i have an vserver with plesk 7.5, apache 2 and mysql 4.0.18. i do lots of local-connections for the counter. these all works fine. but ~50% of the connections to the server must be remote from my second server and there is the problem: ~15% of the remote-connections gave me USER: "unauthenticat ...

how to check your archrive status?

My database is up & runing , But i am facing following problem...I got following message in my online.log file....Third line from bottom you can a message (Aborted by client.)/*Sat Dec 18 02:05:48 200402:05:48 Checkpoint Completed: duration was 0 seconds.03:00:50 Checkpoint Completed: duration w ...

Delivery Status Notification (Failure)

Delivery Status Notification (Failure)Returned mail: Service unavailableDelivery failureI've been getting a lot of emails with the above subjects (a dozen a day at the peak), and when I look around for an reason why I would get these emails, searches say 'that it's an email delivery problem and I'm ...

Evolution-2.28 build failure

I was trying to build evolution 2.28 on fedora 10. The errors I'm getting arechecking for GNOME_PLATFORM... configure: error: Package requirements (glib-2.0 >= 2.20.0gtk+-2.0 >= 2.16.0gconf-2.0 >= 2.0.0libbonobo-2.0 >= 2.20.3libbonoboui-2.0 >= 2.4.2libglade-2.0 >= 2.0.0libgnomecanv ...