Cognos 8.2 - RQP-DEF-0177 - ORA-00972: identifier is too long error in PDF ??

said: Has anyone everyone ever come across the error RQP-DEF-0177 - ORA-00972: identifier is too long??This happens on a report when it is run in PDF. The report prompts, validates and runs fine in HTML mode, in PDF it prompts and validates, but throws this error right before it should render??Does ...

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

Date Prompt In Cognos 8.2

Hi All,Iam creating a date prompt , using a prompt page , if i run the report from my report studio or from the cognos connection the date prompt works perfectly fine... but it i dont need a prompt page and i need the date prompt in my report page , the date prompt appears as a date time prompt, whe ...

Is it possible to change format of Date prompt

D Ramkumar said: Hi,Is it possible to change format of Date prompt value.I have one date prompt in which UI is set to Edit box.whenever i click any date in calendar.it appears in the format oct 2, 2008 . is there any way to display the date in the format 2008-10-02(YYYY-MM-DD)or any javascript avail ...

How to Set date prompt value to balnk in cognos 8.4

I need to set the date prompt value to blank in cognos 8.4. Can anyone tell me the javascript that needs to be used.in 8.2 i have the follwoing code<script language="javascript">document.forms.elements.value='';</script><body oNLoad=init()><form name="formWarpRequest">I tried ...

Weired "RQP-DEF-0469" error after applying Cognos Hot fix 5

We have Cognos 8.3. I recently applied hotfix 5 and suddenly one of the report stopped working. When I run all tabular model, they run fine but when I run the report, I get following error.RQP-DEF-0469 The query 'Spending % of Running Diff Per Qtr_tab0_sub' references the non-existent query 'Spendin ...

while changing model cognos RQP-DEF-0068 Unable to connect to database...

while changing model cognos RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: database name coming ...

how to change the display of the date prompt?

Hanu Deepthi Sistla said: How to change the display value of the date prompt to Mon/YYYY in report studio cognos 8?Please help me on this. ...

'From Date'is selected greater than 'To Date'in a date prompt

If 'From Date'is selected greater than 'To Date'in a date prompt,the user needs to get an error message like "Please select a valid date"for a report studio report in Cognos 8.3Please Help me in getting the Code ASAP ...

Date Prompt default Value Issue

I have a prompt page in Cognos 8.4 (FP2 - Service Pack Installed) report studio with 2 Date prompts (Sales date, Receipt date). Both the date prompts are optional. User can run the report by selecting either of the prompts or both.In order to capture the event of user not selecting the date prompt, ...

error:rqp-def-0360

I am having a report with set of filters and when i try to add an extra filter and run the report,it throws me an RQP-DEF-0360-SQL cannot be generated error.Since Im just 4 months old with cognos,i havent comee up with this error in my past.Can any body throw some insight.Thanks in advance.I have al ...

RQP-DEF-0104 Warning: There is a cross join for the user who

RQP-DEF-0104 Warning: There is a cross join for the user who has the identity '{Everyone, System Administrators, Authors, Query Users, Consumers, Metrics Authors, Metrics Users, Planning Contributor Users, Controller Users, Analysis Users, PowerPlay Users, Data Manager Authors, Readers, Express Auth ...

RQP-DEF-0360 SQL cannot be generated; filter conditions cannot be applied

all, I have what looks like a simple report requirement, but I am stuck.There are a bunch of DB2 database tables (say 10) which are to be displayed in a report as they exist, without any grouping/aggregation. Out of these, 3 tables have columns that the report is prompted on. I imported the tables f ...

RQP-DEF-0058 Unable to resolve the expression error with stored procedure

HiIn FM, we have a stored procedure which returns value and input parameters are user info (session paramter) and setting ID. Based on that value we have to displaying a query item value. To implement this, we have created a parameter map based on stored procedure(Query subject is created in businee ...

jquery.DatePicker How Date in format dd/mm/yyyy ?

Hello, how I do formate date in format dd/mm/yyyy using DataPicker?I´m using $(".selector").datepicker({ dateFormat: 'dd/mm/yy' }) but don´t work´s. ...

Date/Time format handling on region configuration change

Hi, Im using Delphii 6, an i have a problem when it comes to date and time handling, the app im working on crashes every time that i change my region configuration to other languaje, im using spanish(Mexico) and english(USA) for testing, i need to asign some date and time values over some DateTimePi ...

ERROR[HY000] Date conversion format must contain a month, day, and year component

I've got a problem connecting to my Informix Server via VB.NET.Calling con.open() a receive an Exception:"ERROR [HY000] [Informix .NET provider][Informix]Date conversion format must contain a month, day, and year component"If I print out the Environment DBDATE is set to "dd.mm.yyyy ...

Ubuntu completely customize Nautilus Date Modified format

I wanted to change the Date Modified format from the default to a very customized format:10.01.10 11:36 AMAnd it's totally possible. Just follow the directions here:http://blog.chewearn.com/2008/11/14/change-date-format-globally-in-ubuntu/Two things to be aware of:1) Restart after you've made the ch ...

How to convert integer value to date/time format??

I m facing a problem of converting dword value integer 1187253017 to date/time format in VC++??I want to convert 1187253017 number to dd/mm/yyyy HH:mm:ss AM/PM format in VC++?plz reply me fast with code.. ...

i need display of date in MM/DD/YYYY in date prompt?this is the requirement.

Hanu Deepthi Sistla said: i need display of date in MM/DD/YYYY in date prompt and this is the requirement .we tried it but sql functions are not working on date prompt parameter.If it is possible let me know on it or help me in mainpulating the date using the HTML Script.Please i need help on this r ...

RQP-DEF-0120 Database connection is dropped

said: Hi All,I am running the meta dada wizard to import the tables from oracle 10g database and running into this error.RQP-DEF-0120 Database connection is droppedIt works fine fot other oracle databases. Does anyone come across this error. ThanksSree. ...

Default Selection of Previous Month Range in Calendar Date Prompt

Suresh Regmi said: JS Experts, I have attached a sample report. Currently, I have previous month as the default date selected in the date prompt (calendar). Would appreciate if someone could plesae help me come up with the code to make the previous completed month (eg. from 05-01-2008 to 05-31-2008) ...

Regarding Date Prompt

Gobinath M said: Hi ,My requirement is to display Date Prompt with default date which is to be the last business day of the previous month.Also user should be able to change this default date as per requirement.Can anyone help me on this???.. ...

Data from two date prompt

Rajagopal Ramanujam said: Hi,I am using 2 date prompt for Start_date and End_date . But the data is not filted and showing nothing.it works when i using date range( in_range). But the prompt page looks ugly. So i want to have two date prompt for Start Date and End Date.It works fine if i filter just ...

Defaulting date prompt to be blank !!

Richard Mabjish said: By default, the date prompt displays current date (under properties/Default Selection there is nothing specified). How can I default it to be blank and not display any date at all...? (Report Studio 8.3) ...

MySQL Change the default date time format

I am using mysql 5.1 . In that one default date time format is yyyy-mm-dd. But I want to use it as dd-mm-yyyy. Can you anybody explain me how to change the default date time format. not only in that format in any format. Plz kindly don't say me to read mysql documentation from mysql.com . I already ...

From To Date prompt in condtional block

Rajagopal Ramanujam said: Hi,Iam talking to you guys for prompt with conditional block in other thread. The user dont like the date range prompt the way it looks in the prompt page.They want to have from date and To date prompt side by side.I am wondering how can i do it in the condtional block. If ...

Checkbox in date prompt

Rajagopal Ramanujam said: Hi,I am using conditional block for prompts.In the date from To prompt there is checkbox and it always checked. If want to run the year or month prompt( all prompt are optional) i must uncheck the date prompt checkbox. otherwise year and month prompt is not working. I want ...

to insert DATE TO DB/TABLE, how must inserted the date , what format ?

When in phpMyAdmin I haveField Type dateplaced timestamp then in a command like $datenow = time(); // $datenow = date("H:i j/m/y", $tsnow); // p.516-7 $status="PENDING"; $email6=$_SESSION['email']; $query = "INSERT INTO $BookingsTable VALUES(NULL,'$datenow',0,'$email6','$sta ...

How to retrieve System Date & Time format?

How to retrieve current system date & time format ?i.e formats that are set through Control Panel->Regional Options ...

Set date prompt to yesterday's date

I am using the following script in a HTML item to display yesterdays date in a date prompt. This script works perfectly fine in 8.3. But after we migrated to 8.4, date prompt always displays yesterday's date no matter what date we pick. I am not sure how to modify this script o make it work in 8.4.H ...

Date prompt

Hi, I have a report that uses the date prompt. The slicing to be done based on the week, month and the year. Likewise the parallel period needs to be calculated for the same. How it can be achieved?I need urgent help, ...

Date Prompt in Dimensionally modelled Report

I am creating a report based on a cube on 8.4.1. Cube is MSAS cube by the way. Report will include a number of transactions last week, MTD and YTD for each product. The week is going to be last week Friday so as of today(8/12/2010), the date prompt should display 3/12/2010 which works fine. I am usi ...

How to set default startdate and end date in date prompt??

Is it possible to set the default startdate and end date in date prompt??My default date should be like below one.Default --> startdate -Jan 1,Cuurent Year end Date - Dec 31,Current YearPls suggest the way to do itThanks in Advance.. ...

reduce the size of date prompt in toolbox

I am lookin to create a custom template and I was looking to know if anyone knows that file I need to edit to reduce the size of the date prompt field. Sample screen shot of what I have and what I want it to be ...

Date prompt issue

Gurus,Kindly give me advice for my report.I have the impromptu report prompt.The user is entering the start date YYYY-MM-DDand End Date YYYY-MM-DD.Then he will get the report page with the results.How to develope this prompt page in Report studio? with Date prompt or any other option is there? ...

HOW to change the default value for date prompt

Carol Lindsey said: Hi,I'm working on a report which has a date prompt. We need to set the default value to be 00/00/0000. I am using C8.2 Any ideas on how to do this? ...

Error in date prompt

I have created the report with two date prompt (start and end date).If i run the report without validating then its throwing unresolved error in prompts.After validation if i run the report its not throwing any error and its working fine.Can any one faced same type of issues or pls give me some sugg ...

Different default date time format

I am writing a C++ ESQL Sybase application. I use dynamic SQL method 4 descriptor to get the columns. When my program got the date, the format is "May 19 2004 12:00:00:000AM", however i got a sample program from my colleague and the format his program got is "Jun 2 1998 1:09:09"I ...

Oracle how to get the date time format in OCI

How to get a date time format in OCI instead of only date ...

How to use answer from date prompt in calculated field...

I want to write a query on a warranty database to figure out how many days are left on a unit's warranty based on a future date.For example, if a unit shipped on 1/1/04 and the warranty is 365 days, how many days are left on the warranty as of 3/31/04?I want to prompt the user for the date to compar ...

Date display format

I would like to modify the date display format, for the dates stored in my database. It is stored like this: 2008-07-01I want to print as: July, 1stNow I wrote something as below, but it displays Dec 31st instead of July 1st. (And in my database Dec31 is nowhere anyway). Please tell me how to fix.He ...

Where the date time format stored for cqweb and cq eclipse client?

Hell All,Does anyone know where date time format stored for cqweb and cq eclipse client? I use cq 7.1.1.1 for windows. I found is not affected by the Reginal setting in the control panel of the cqweb server or the registry keys. cq client for windows is controlled by the Reginal setting in the contr ...

Date/Time format in database

Hi, I am writing a program using Visual C++. I need to make a connection to the database. I did it using the below code... CString strStartDate1="01/03/2003";pCommand->ActiveConnection = m_pConn; CString sSQL; sSQL.Format( "SELECT * FROM ConstructionSequence " "WHERE Star ...

how to declare date-time format in vb.net?

anyone who can help me how do i declare date-time format in vb.net from sql server 2005? i dont know where to put this line CONVERT(VARCHAR(10), GETDATE(), 1) AS [MM/DD/YYYY] ...

problem with date time format

I tried to split date time format and store them as variable but because of my datetime format is non-standard, I got stuck.Can you help me to solve this problem.my datetime format is :July24,2003 12:14:06and I want to separate it as$month,$day,$year,$hour,$minute,$second ...

Inserting date in format DD-MM-YYYY in MySQL

Hope somebody can advise on the following: I have created a table into my database which has a coloumn with datatype defined as DATE. The normal MySQL date order is YYYY-MM-DD, however I need to enter it in format DD-MM-YYYY. I am using php to insert data into my table, and I was wondering at what p ...

System date time format

I have a UI where in i display dates entered by user in the system date time format. When the UI is still up and the user changes the system date time format through the control panel i need a message which i can handle in my UI. Can anyone please tell me how to do it? ...

Taking String and converting to date/time format ?

Hidoes anybody know (have some code) that will take a string of text and convert to the UNIVERSAL TIME DESCRIPTOR DATE/TIME FORMAT ???please help major headache ..... ...

Date & Time format

How can I retrieve the date & time format defined by the user in the "Regional Settings" panel ?(tab Date, Short date style parameter). ...