Focal Point
[SOLVED] (FOC1400) SQLCODE IS 8115

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2397037495

December 03, 2010, 02:33 PM
SeyedG
[SOLVED] (FOC1400) SQLCODE IS 8115
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,
December 03, 2010, 03:57 PM
T.Peters
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
December 03, 2010, 05:15 PM
SeyedG
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)