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

histogram error

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

External


Since: Jun 25, 2003
Posts: 1



(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: 41



(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: Oct 20, 2009
Posts: 12



(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: 17



(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:
unknown error - I got a question about an error in an errorlog. I do not have a clue what this error means and if it is a serious one. Can anyone give me some info about this error please. rwrz021 ::[65275 IIGCC, 00000008]: Tue Aug 30 11:44:27 2005..

4GL Compilation error - Friends Due to Some problem Compaq UNIX Machine was interrupted. Now Machine is working fine. But We found some errors while compiling procedures in on of the databases. Error follows. Error, Line 85 : E_OS0010 An internal problem exists within the..

Error handling in DBPs - We all know what the manual says about errors in database procedures: "If the procedure was invoked by a rule, an error has the following effects: - The procedure is terminated. - Those statements in the procedure which have been executed are rolle...

Ingres R3 Locking error? - Hi. I have a Ingres R3 server, Everything seems to run fine, except one application which crashes the iidbms process every 3rd or 4th time I run it. I am running the application on the exact same data everytime, so I don't really understand why..

[Info-ingres] ingres r3 error on hp-ux - hi , i tried install ingres r3 in a uname -a HP-UX itanium B.11.23 U ia64 .... install ok but .... ingres start with can't access kernel address 23d9c0 syscheck -v Checking host "itanium.unizar.es" for system resources required to run ...
   Database Forums (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 ]