Status = -16

My frst posting so here goes.When connecting two a Universe DB via telnet I log in and then type 'listf' to list all the connected database files, but some of them are shown with the following error 'CAN'T OPEN STATUS = -16' Can anyone tell me what this means and how do I rectify it?The data file ex ...

An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.

Prem Godugu said: Can someone help me what is causing this problem. All of a sudden our production reports and adhoc queries are throwing the following error.<table><tr><td>RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.</td>< ...

An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.

Prem Godugu said: An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.Can someone help me what is causing this problem. All of a sudden our production reports and adhoc queries are throwing the following error.<table><tr><td>RQP-DEF-0177An error occurre ...

how to resolve this error while running a report 'sqlPrepareWithOptions' status='-201'

an Bollapragada said: How to resolve this error while running a report 'sqlPrepareWithOptions' status='-201' in details it says "UDA-SQL-0107 A general exception has occurred during the operation "columns". Thanks for your help. Hiran ...

'sqlPrepareWithOptions' status='-9'

I recently installed Cognos Express and connected it to an OLAP data source. This connects to another database server, I setup the data source in Cognos Express, it tests correctly, and it created a package automatically but whenever I try to pull any data from it I am getting the same error:'sqlPre ...

Ubuntu fsck died with exit status 16

I tried to install grub2 over grub 1, ended up restarting to Error 15.After a few attempts to fix this I decided to try and reinstall grub all together.From a 9.04 live cd (Karmic is on my main partition)sudo mkdir /media/sda1sudo mount -t ext3 /dev/sda1 /media/sda1sudo mount --bind /dev /media/sda1 ...

Ubuntu External Modem Exit Status 16

I'm running a dual-boot XP Home - PCLINUX system. The PC is new (3 weeks).I would like to install either Ubuntu or Kubuntu Feisty Fawn but am having the same exact modem disconnect problem with both.I can boot the live CD with either OS by appending the boot line with noapic OR nolapic and then inst ...

Parameter Map error in Framework Manager/Report Studio

Toby Fritz said: We have a FM model in C8.2 using SQL Server db. We set up a Parameter Map based on a SQL Server table to filter a Query Subjects based on the User's ID. The parameter map is setup as follows:Query Subject: sec_parm (3 query items: userid, orgtype, orglist) sample of sec_parm data: U ...

Errors out - UDA-SQL-0358 - when adding a subtotal to a list report in Cognos 8.1

Fayu Zhang said: This is a list report that has no numeric data from data source but needs to show the number of cases closed during a time period. A lot of conditional calculations are used in the report to show that number. Reference queries are used in this report.Report run fine but run into the ...

Regarding Search and Select prompt

Dipesh Mistry said: Hi All,I have a prompt page in which I have a search and select prompt for Products.There is one Radio button prompt for selecting the Product Name or Product Id based on which the results of search and select prompt would be displayed.Also there is one more checkbox prompt which ...

Ubuntu post-removal script returned error exit status 127

Eish, it's a hot day and nothing seems to be going right. Trying to figure a way out of this one - error 127. Looks like it could be Metacity problem? There a couple of pythons that also have a problem.(Reading database ... 145089 files and directories currently installed.)Preparing to replace metac ...

Error when user runs a report in Report Studio

Shashidhar Manthena said: Hi All, User gets the following error when he runs a few reports in Report Studio. As part of the security, it's all fine. Could anyone let me know how I can debug this?An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.DPR-ERR-2082 An error ha ...

Informix Query Problem

Informix Experts,I am very new in Informix database. Follwoing SQL is giving syntex error. Can any one please guide me where i made mistake?? Its urgent please help.Select Distinct(Select count(status) From mmo where status = 1) As 'MMO Msg per Status 1',(Select count(status) From mmo where status = ...

Help with MODEM

I have a Compaq Presario 2100, I installed SuSe 10.0 and tried to configure it. I went to linuxant since the modem is a conexant HSF modem, and installed the driver, used kppp to connect, but every time i get disconnected and get EXIT STATUS 16.Can someone please help me, I've been trying to get thi ...

SQL0443N

Would anyone give any advice?Environment:DB2 client: DB2 V8.1 fixpack 8 on AIX 5.3DB2 Server: DB2 on IBM zOS 1.6 (OS390 7.1.2)Problem:On client, from db2clp, everything looks fine, and I can query whatever I want. From our product, we got the following error:QE-DEF-0177 An error occurred while perfo ...

sp_addarticle, proc has bug with no know fix

I have found a bug with the sp_addarticle procedure and have not had any success finding a fix for it. The bug only exists whenever I am adding an article that is vertically partitioned and uses a DTS package to do the processing. In this particular case, I am using snapshot repl. Has anyone experie ...

sp_addarticle and @ins_cmd, @del_cmd, @upd_cmd

I had been asked to add a new article to an established transactional replication. I modify and ran the sample provided from microsoft.<code>EXEC sp_addarticle@publication = N'ACTION',@article = N'ACTION',@source_owner = N'dbo',@source_object = N'ACTION',@destination_table = N'ACTION',@type = ...

Framework Manager and Stored Procedure issues

Craig Botha said: Hi I'm trying to create a query subject in Framework Manager (8.2) using a stored procedure from MS SQL Server 2000. Background on the SP:I have an SP that extracts a Bill of Material listing for a particular part (SP1). I've created a second SP (SP2) that takes in a list of parts ...

Maximum number of expressions in a list?

Olga Gedroit said: I am creating a report with a prompt, which allows the user to select items that he/she wishes to see a report for. One of the options is to select all of the items (so as to view the complete report). When I run such a report, I get the following error: RQP-DEF-0177 An error occu ...

error while running report

Hanu Deepthi Sistla said: QE-DEF-0459 CCLExceptionRQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.UDA-SQL-0107 A general exception has occurred during the operation "prepare".ORA-00942: table or view does not exist ...

Query Subject with db-SQL needs local processing?

said: I have a Query Subject that I created using datasource (tables & columns) SQL. I ran and tested the SQL against the database and it works fine. I used it as the source for my QS and when I tested it in FM, it throws error stating:<hr originalText="--------------------------------------- ...

Error while running report

Hanu Deepthi Sistla said: While validating the report i m getting the following error.I need help regading this.Thanks in advance.UDA-QOS-0006 ErrorUDA-SQL-0107 A general exception has occurred during the operation "prepare".ORA-00972: identifier is too longQE-DEF-0459 CCLExceptionRQP-DEF-0177 An er ...

using days between fuction i am geting the error

Murali Chalasani said: my DS is Oracle APPS .. and when i am trying using this function _days_between(PROMISE_DATE,ACTUAL_SHIPMENT_DATE). i am getting the following error. RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.UDA-SQL-0107 A general exception h ...

Creating a relationship in Framework Manager between a Stored Procedure and a view that contains BLOB data

Mark Ledbury said: Is it possible to create a relationship between a stored procedure and a view that contains BLOB Data?In Framework Manager (v 8.2) I've been trying to create a relationship between two query subjects, a Stored Procedure and a View that contains BLOB Data (the underlying database t ...

Excel data as DS in FM --new thing

Murali Chalasani said: Hi All, {color:#333333}Here we have new challenge .i created one DS using excel sheet data. after that i imported that into my FM and i tested that QS,it's working fine.and i am using another DS(oracle) also in my FM . my problem is when i am creating the relation ship between ...

Excel Format Report can not be sorted

Stephen Chang said: Hello All. I am reporting DB2 variable length text columns into my report. The sorinting column is numeric. Running with HTML format option is fine. But if I choose excel format option, I would receive the following error. Does anyone have the same experience? Thanks in advance. ...

MySQL datasource and Cognos 8.3 - database function issue

Csonka Peter said: Does anybody have experience with MySQL datasource and Cognos 8?I am unable to use the MySQL database functions. The simple cast, case.. not workingcast(create_date as date)for test I tried with one table direct from the database, 2column, no join, nothing.RQP-DEF-0177 An error oc ...

multi-fact query works in RS and QS - but I get UDA-SQL-0462 in FM?

Andrew McEwan said: I have two fact tables related via 3 conformed dimensions. When I query these in RS or Query Studio I get results ...When I test items from both fact tables in FM I get an error RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-120'.UDA-SQ ...

How to convert Integer values into formatted time intervals with Cognos 8?

Fayu Zhang said: I have got a business requirement to show the time between close date and open date (both Datetime datatype) to close the Help Desk tickets in days, hours, and minutes.There are a couple of Support KBs that offer the tips or techniques such as Convert Integer values into formatted t ...

Audit Reports Error Against Oracle Database

Daniel Hauge said: Has anyone had this problem or know the solution? I am using an Oracle database and get this error when I try to run the Audit reports:<table border="1"><tbody><tr><td>RQP-DEF-0177</td></tr></tbody></table>An error occurred while per ...

checking enum values

I want to write a procedure that will check that a variable that is passed in is one of the enumerated values that is allowed.The lineif (Select Where @status IN ('Retired', 'Playing', 'Injured'))is the one that I am trying to figure out a way to do it. I don't have a table that contains all the opt ...

Congnos report problem while migrating from CRN to Cognos 8.4

When I am validating report after upgrading from CRN to Cognos 8.4 no errors are displayingBut when the time of running report it is throwing error like ‘RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-126'. UDA-SQL-0219 The function "rtrim" is being used ...

Error in using Clob field with Union in synonyms

I created a view by using the Union all with the two other views and the basic views contains the Clob datatype field. Then I created the Synonyms of this view and imported the same Synonym in the framework manager. When I tried to execute the querysubject it throws the below written error.RQP-DEF-0 ...

Report Bursting error in Cognos 8.3

Here's the issue I'm encountering...I followed the instrx in the "Notes on Report Bursting in IBM Cognos 8.3" using option 1 - burst using one query. I have a column for my recipients, which contains there email addresses...I set the burst options according to doc specs (so far so good), but when I ...

UDA-SQL-0107 ORA-00932 Inconsistent data types

Hi, I do have a report that is working fine in dev. But the same report fails in test environment with the following messageFailure RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'.UDA-SQL-0107 A general exception has occurred during the operation "prepar ...

User Defined Function

We have a user defined function in DB2. I can execute that function on the database. I can import that function in to the Framework Manger. I am unable to execute that function in the Framework Manager. I am getting below error codes – RQP-DEF-0177 An error occurred while performing operation 'sql ...

Prompts in Report Created using Query

I have created a Report using a Query .But unable to create prompts for the same Report as it is throwing the following error while running the report 'An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'. Please let me know how to create Prompts in this case. ...

Using NVL2 function in FM

when I am trying to use NVL2 function in FM, UDA-SQL-0219 RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-126'.UDA-SQL-0219 The function "NVL2" is being used for local processing but is not available as a built-in function, or at least one of its parameters ...

The function to_char is not available as an external, database, or built-in

I am getting the below error when i use the to_char function in report studio.[u]RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-126'. UDA-SQL-0219 The function [b]to_char[/b] is not available as an external, database, or built-in function [/u] My requireme ...

Framework SP Query Subject Error -- iSeries

I am getting the following errors in Framework when attempting to create a Stored Procedure Query Subject: RQP-DEF-0177 sqlPrepareWithOptions Status = -9 UDA-SQL-0107 general exception sqlPrepareWithOptions The connection is to an iSeries. The Data Source is working. I'm able to create a Data Source ...

Validation Error "COGUDA#CONCAT": invalid identifier

Michele Martin said: I have searched the Cognos Knowledge and cannot find anything to help me with this error. QE-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-9'. UDA-SQL-0446 Oracle returned an error message. ORA-00904: "COGUDA#CONCAT": invalid identifier U ...

SQL0443N

Would anyone give any advice?Environment:DB2 client: DB2 fixpack 8 on AIX 5.3DB2 Server: DB2 on IBM zOS 1.6 (OS390 7.1.2)Problem:On client, from db2clp, everything looks fine, and I can query whatever I want. From our product, we got the following error:QE-DEF-0177 An error occurred while performing ...

Boot Loader source

I am new to kernel programming...so could you please briefly desribe the below attached code.../*2 * Copyright (C) 2008 The Android Open Source Project3 * All rights reserved.4 *5 * Redistribution and use in source and binary forms, with or without6 * modification, are permitted provided that the fo ...

modem hangs up soon after connect

Installed Mepis 6.0 OK. Yet no pppd response after modem connection to ISP (Verizon). Modem hangs up within 1-2 seconds (status 16). Tried slowing port speed from 115,200 to 57600; NG. Same machine (Shuttle, AMD Athlon3200, 512Mb ram) ran Mepis 2003.10 very well. Any advice? ...

Modem Hangup unexpectedly after dialing using kppp

I am using Fedora Core 1 on a P3 866Mhz, 128 MB RAM, 20 GB HDD. MY machine is dual boot with Windows XP on a 10GB partition and Fedora on another 10 GB partition.I have a GVC V.90 K56Flex modem and pppd 2.4.2 I am currently using kppp to dial in.The problem is that after I dial-up and am connected t ...

Right settings for C++ compiler under Windows Server 2003 R2 x64 Enterprise

Transformer Stage hasn't worked.I had installed Microsoft Visual Studio .NET 2005 Express Edition C++ and Microsoft Platform SDK for Windows Server 2003 R2 before I installed IBM WebSphere DataStage 8.1. Also I set the environment variables as documentation told. And after that I installed DataStage ...

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_ ...

kppp issues

I just installed suse10.0 on my laptop its a Compaq Presario 2100, and it has a CONEXANT 56K ACLINK modem. I did a search on google and ended up on linuxant, got an HSF 2.6.13.15 driver for suse. Installed the rpm and got connected...BUT the problem is that it disconnects randomly and the longest i ...

trying to connect to cingular gprs with my motorola v235 phone

here goes, im using a motorola v235 phone and running the live Kmobile 050 beta. using kppp. my provider is cingular/at&t . i think i am on the right track. it finds the modem, dials, even gets the username and password. then i get this error message and the connection dies The pppd daemon died ...

Problem in Validating txtfield

i had done validation in my program...it is validating and entering the values also...the problem is if i m giving the same value which is in XML file...it is taking not showing any error...can any one check my code and suggest me the solution..2day evening is submission of my work..i need help....w ...