Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] (FOC1400) SQLCODE IS 8115
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] (FOC1400) SQLCODE IS 8115
 Login/Join
 
Gold member
posted
All,
When running this code,
TABLE FILE LOG_TABLE
SUM
    BYTES_SENT
    BYTES_RECEIVED
BY USER_ID
WHERE ( LOG_DETAILS.LOG_DETAILS.DATE_TIME GT DT(2010-11-01 12:00:00) )
  AND ( LOG_DETAILS.LOG_DETAILS.DATE_TIME LE DT(2010-11-10 23:59:59) )
WHERE READLIMIT EQ 100000
END
  

I get the following error:
 
(FOC1400) SQLCODE IS 8115 (HEX: 00001FB3) XOPEN: S0002
 :  (8115) [S0002] Arithmetic overflow error converting expression to data
 : type int.
 (FOC1407) SQL FETCH CURSOR ERROR.  : LOG_DETAILS 


Does anyone know what causes this?

Thank you,

Seyed

This message has been edited. Last edited by: Kerry,
 
Posts: 86 | Location: Oklahoma City, Oklahoma | Registered: July 01, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Date fields are alpha format. You are trying to compare your DATE_TIME field to a numeric. Make sure you only compare alpha to alpha and numeric to numeric.


WebFOCUS: 7702
O/S : Windows
Data Migrator: 7702
 
Posts: 127 | Location: San Antonio | Registered: May 29, 2009Reply With QuoteReport This Post
Gold member
posted Hide Post
Thank you for the reply. I thought that perhaps, summing up the two columns was causing overflow. I am going to work on converting the numeric fields to date and then give it a try.

Thanks again,


Seyed


WebFOCUS 8.0.09
App Studio 8009
Linux Kernel-2.6
DBMS: Oracle 11g
all output (Excel, HTML, AHTML, PDF)
 
Posts: 86 | Location: Oklahoma City, Oklahoma | Registered: July 01, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] (FOC1400) SQLCODE IS 8115

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.