Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

histogram error

  
   Database Help (Home) -> Ingres RSS
Next:  How to cache Ingres table?  
Author Message
ajay_chadha

External


Since: Jun 25, 2003
Posts: 2



(Msg. 1) Posted: Mon Jan 05, 2004 8:43 am
Post subject: histogram error
Archived from groups: comp>databases>ingres (more info?)
INGRES REPORT Copyright (c) 1981, 1998 Computer Associates Intl, Inc.
Reading report specifications and preparing query . . .
E_OP03A2 consistency check
- histogram on mat_monthly attribute monthly_cb_qty is not
monotonically
increasing
(Mon Jan 5 16:46:25 2004)

E_RW1019 Either you had errors in the .QUERY command, or you didn't
specify either a .QUERY or .DATA command. Processing stops.

E_RW100A 1 error(s) have occurred in setting up the report. No report will
be written. Correct errors and rerun.


what would be the possible error as query is running fine through isql , pl
help
AJAY CHADHA
ENGINEER (IT)
IT DEPARTMENT ,NTPC TTPS
------------------------------------------------------------------------------
"Speed & Quality is essence of IT"

 >> Stay informed about: histogram error 
Back to top
Login to vote
anandopatel

External


Since: Dec 11, 2003
Posts: 3



(Msg. 2) Posted: Mon Jan 05, 2004 9:48 am
Post subject: Re: histogram error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Dear Sir,

I see your company motto is

"Speed & Quality is essence of IT"

perhaps you need to hire some Ingres professionals for this to mean something.

Best wishes
Anando Patel

 >> Stay informed about: histogram error 
Back to top
Login to vote
Karl Betty Schend

External


Since: Jul 02, 2003
Posts: 55



(Msg. 3) Posted: Mon Jan 05, 2004 11:33 am
Post subject: Re: histogram error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
At 4:28 PM +0500 1/5/04, wrote:
 >INGRES REPORT Copyright (c) 1981, 1998 Computer Associates Intl, Inc.
 >Reading report specifications and preparing query . . .
 >E_OP03A2 consistency check
 > - histogram on mat_monthly attribute monthly_cb_qty is not
 >monotonically
 > increasing
 > (Mon Jan 5 16:46:25 2004)
 >

Drop and re-create the statistics on that column. What version,
patch level, platform? This problem used to occur occasionally with
dates, but as far as I know it's been fixed for quite some time.

Karl
 >> Stay informed about: histogram error 
Back to top
Login to vote
Ingres Forums

External


Since: Mar 24, 2010
Posts: 4



(Msg. 4) Posted: Wed Mar 24, 2010 10:37 am
Post subject: Re: histogram error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hi karl,

I am getting the same error on our person records, can you please send
me some ionstructions on how you would go about re-creating stats as i
am new to ingres and have very low knowledage on where to go and find
things. I can see it in VDBA just dont know how to re-create it.

thanks in advance
kam


--
kamini
------------------------------------------------------------------------
kamini's Profile: http://community.ingres.com/forum/member.php?userid=13405
View this thread: http://community.ingres.com/forum/showthread.php?t=3541
 >> Stay informed about: histogram error 
Back to top
Login to vote
Karl Schendel

External


Since: Apr 19, 2004
Posts: 11



(Msg. 5) Posted: Wed Mar 24, 2010 12:06 pm
Post subject: Re: [Info-Ingres] histogram error [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Mar 24, 2010, at 11:37 AM, Ingres Forums wrote:

>
> I am getting the same error on our person records, can you please send
> me some ionstructions on how you would go about re-creating stats as i
> am new to ingres and have very low knowledage on where to go and find
> things. I can see it in VDBA just dont know how to re-create it.

I don't know how to do anything in VDBA. I think there is a "drop
statistics" and "create statistics" menu item somewhere.

At the command line, what you woud do is

statdump -zdl databasename -rtablename -acolumn1 -acolumn2 ...

optimizedb -zv database -rtablename -acolumn1 -acolumn2

The statdump -zdl drops statistics. It's not really necessary, as
the optimizedb will overwrite any old histograms, but it is a
"feel good". The optimizedb command regenerates the
histograms. The -zv option simply tells optimizedb to output
a bit of info when it's done, and can be omitted.

Karl
 >> Stay informed about: histogram error 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
out of memory error - Hi I'm getting the error message .... E_SC0204 Error allocating memory Anyone know which memory parameter I need to update in CBF ? Thanks 1 David Greenberg

Error opening a table. - Hi, I have a set of queries executing for about 5-10 minutes for reporting. System generates exceptions very rarely. When I check the log messages, I found an exception saying "error opening a table <<table name>>". Does anyone ...

Error message while running INGSTART - Hi We use Ingres 2 /0011 on VMS 7.3/2 We are just installing Ingres on a new (at least new for us!!) server and while running INGSTART in the IISUDBMS stage we are getting the error: Starting the name server... Unable to start server: Status =..

Error while adding column using ALTER TABLE - Hi, I get this error when trying to add a column using ALTER TABLE... The Error is... E_QE009D Alter Table ADD/DROP column support for pages greater than 2k only. The SQL statement is... alter table abc add column xyz varchar(100); The..

[Info-Ingres] AL FSM error in GCC - Hi, Anyone ever figure out what causes the 'AL FSM. Input = 29, state = 13' error in GCC ? We have a remote process (via 2.6 Ingres/Net) that maintains BLOB data and it often gets disconnected with the DB server (also 2.6) reporting this error. ..
   Database Help (Home) -> Ingres All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]