Oninit cdi / Archive
Talk to an expert →

AUS issue - SQL error 1284

Posted in 2011

Topics: Third-Party Tools & Monitoring

ALEXANDRE MARINI — — source: IIUG Forums & Mailing Lists

Hello, my friends. I am facing some strange issue here, on a 11.70.FC1GE running on linux_64 machine. My online.log says: SCHAPI: [Auto Update Statistics Evaluation 29-15] Error -1284 Value will not fit in a BIGINT or an INT8. My OAT Alerts page says something additional: TASK NAME Auto Update Statistics Evaluation LOCATION ERROR -1284 Value will not fit in a BIGINT or an INT8. How can I trace this situation? What does mean the numbers "29-15" on the msg? Best regards!

↪ replying to ALEXANDRE MARINI
Art Kagel — — source: IIUG Forums & Mailing Lists

You are hitting a bug in sysmaster in 11.70. Some of the fields in the partition header (mapped to sysactptnhdr and sysptnhdr) are not mapped to memory correctly and show massive values that give this error. Known hug I'be been told. Art On Jan 17, 2011 6:06 AM, "ALEXANDRE MARINI" <amarini@fazenda.ms.gov.br> wrote: > Hello, my friends. > I am facing some strange issue here, on a 11.70.FC1GE running on linux_64 > machine. > > My online.log says: > SCHAPI: [Auto Update Statistics Evaluation 29-15] Error -1284 Value will not > fit in a BIGINT or an INT8. > > My OAT Alerts page says something additional: > TASK NAME Auto Update Statistics Evaluation LOCATION ERROR -1284 Value will > not fit in a BIGINT or an INT8. > > How can I trace this situation? What does mean the numbers "29-15" on the msg? > > Best regards! > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > --001636c5c1ebb25f57049a08f163

↪ replying to Art Kagel
Alexandre Marini — — source: IIUG Forums & Mailing Lists

Thanks Art for your rapid answer. Best regards. Em 17/01/2011 07:18, Art Kagel escreveu: > You are hitting a bug in sysmaster in 11.70. Some of the fields in the > partition header (mapped to sysactptnhdr and sysptnhdr) are not mapped to > memory correctly and show massive values that give this error. Known hug > I'be been told. > > Art > On Jan 17, 2011 6:06 AM, "ALEXANDRE MARINI"<amarini@fazenda.ms.gov.br> > wrote: >> Hello, my friends. >> I am facing some strange issue here, on a 11.70.FC1GE running on linux_64 >> machine. >> >> My online.log says: >> SCHAPI: [Auto Update Statistics Evaluation 29-15] Error -1284 Value will > not >> fit in a BIGINT or an INT8. >> >> My OAT Alerts page says something additional: >> TASK NAME Auto Update Statistics Evaluation LOCATION ERROR -1284 Value > will >> not fit in a BIGINT or an INT8. >> >> How can I trace this situation? What does mean the numbers "29-15" on the > msg? >> Best regards! >> >> >> > ******************************************************************************* > >> Forum Note: Use "Reply" to post a response in the discussion forum. >> > --001636c5c1ebb25f57049a08f163 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Alexandre Marini Tecnologia da Informação - DBA msn: alexandre_marini@hotmail.com SEFAZ-MS / SGI-UGSR / Sistemas IBM-Informix Cert-Info-Mgmt_color <Cert-Info-Mgmt_color.jpg> IBM Certified System Administrator - Informix Dynamic Server V10 / V11

Related threads

Glossary