Question

2
Replies
94
Views
pradeepp2840 Member since 2017 20 posts
Verizon Wireless
Posted: July 6, 2017
Last activity: July 11, 2017
Closed
Solved

"ORA-01476: divisor is equal to zero " SQL errors in production.

Hi Team,

The below mentioned SQL error has been observed in the production logs very frequently.

2017-07-05 09:07:24,050 [PRPCWorkManager : 18] [ STANDARD] [ NBAHub:17.25] (l.access.ConnectionManagerImpl) ERROR - Not returning connection 14 for database "datadictionary" to the pool as it previously encountered the followi

ng error

User ID: (unknown)

Last SQL: SELECT ACCOUNTNO AS "ACCOUNTNO" , ATT_REF AS "ATT_REF" , ATT_VALUE AS "ATT_VALUE" , AVG3M_CELLSITE_CNT AS "AVG3M_CELLSITE_CNT" , AVG3M_DATA_GLBL_OVERAGE_AMT AS "AVG3M_DATA_GLBL_OVERAGE_AMT" , AVG3M_DATA_GLBL_OVERAGE_KBU A

S "AVG3M_DATA_GLBL_OVERAGE_KBU" , AVG3M_DATA_GLBL_USAGE_KBU AS "AVG3M_DATA_GLBL_USAGE_KBU" , AVG3M_DATA_HOT_OVERAGE_AMT AS "AVG3M_DATA_HOT_OVERAGE_AMT" , AVG3M_DATA_HOT_OVERAGE_KBU AS "AVG3M_DATA_HOT_OVERAGE_KBU" , AVG3M_DATA_HOT_US

AGE_KBU AS "AVG3M_DATA_HOT_USAGE_KBU" , AVG3M_DATA_OVERAGE_AMT AS "AVG3M_DATA_OVERAGE_AMT" , AVG3M_DATA_OVERAGE_KBU AS "AVG3M_DATA_OVERAGE_KBU" , AVG3M_DATA_USAGE_KBU AS "AVG3M_DATA_USAGE_KBU" , AVG3M_MMS_OVERAGE_AMT AS "AVG3M_MMS_O

VERAGE_AMT" , AVG3M_MMS_OVERAGE_CNT AS "AVG3M_MMS_OVERAGE_CNT" , AVG3M_MMS_USAGE_CNT AS "AVG3M_MMS_USAGE_CNT" , AVG3M_SMS_OVERAGE_AMT AS "AVG3M_SMS_OVERAGE_AMT" , AVG3M_SMS_OVERAGE_CNT AS "AVG3M_SMS_OVERAGE_CNT" , AVG3M_SMS_USAGE_C

NT AS "AVG3M_SMS_USAGE_CNT" , AVG3M_TXTPIX AS "AVG3M_TXTPIX" , AVG3M_TXTPIX_OVERAGE_AMT AS "AVG3M_TXTPIX_OVERAGE_AMT" , AVG3M_TXTPIX_OVERAGE_CNT AS "AVG3M_TXTPIX_OVERAGE_CNT" , AVG3M_TXTPIX_USAGE_CNT AS "AVG3M_TXTPIX_USAGE_CNT" , A

VG3M_VOICE_GLBL_AMT AS "AVG3M_VOICE_GLBL_AMT" , AVG3M_VOICE_INTL_AMT AS "AVG3M_VOICE_INTL_AMT" , AVG3M_VOICE_OVERAGE_MOU AS "AVG3M_VOICE_OVERAGE_MOU" , AVG3M_VOICE_ROAM_AMT AS "AVG3M_VOICE_ROAM_AMT" , AVG3M_VOICE_USAGE_MOU AS "AVG3M

_VOICE_USAGE_MOU" , CLNR_6MO AS "CLNR_6MO" , HOME_AREA_CD AS "HOME_AREA_CD" , HPC_CHURN_CENTILE AS "HPC_CHURN_CENTILE" , IN_ACCT AS "IN_ACCT" , IN_A_CMPS AS "IN_A_CMPS" , IN_CENTILE AS "IN_CENTILE" , IN_CMPS AS "IN_CMPS" , IN_MB

B_C_CENTILE AS "IN_MBB_C_CENTILE" , LTV_CMPS AS "LTV_CMPS" , LTV_IN_A_CENTILE AS "LTV_IN_A_CENTILE" , LTV_IN_A_VALUE AS "LTV_IN_A_VALUE" , LTV_IN_L_CENTILE AS "LTV_IN_L_CENTILE" , LTV_IN_L_VALUE AS "LTV_IN_L_VALUE" , LTV_LCMPS AS

"LTV_LCMPS" , M1_MMS_OVERAGE_CNT AS "M1_MMS_OVERAGE_CNT" , M1_SMS_OVERAGE_CNT AS "M1_SMS_OVERAGE_CNT" , M1_VOICE_OVERAGE_MOU AS "M1_VOICE_OVERAGE_MOU" , M2_MMS_OVERAGE_CNT AS "M2_MMS_OVERAGE_CNT" , M2_SMS_OVERAGE_CNT AS "M2_SMS_OVE

RAGE_CNT" , M2_VOICE_OVERAGE_MOU AS "M2_VOICE_OVERAGE_MOU" , M3_MMS_OVERAGE_CNT AS "M3_MMS_OVERAGE_CNT" , M3_SMS_OVERAGE_CNT AS "M3_SMS_OVERAGE_CNT" , M3_VOICE_OVERAGE_MOU AS "M3_VOICE_OVERAGE_MOU" , MG6M_IN_A_CENTILE AS "MG6M_IN_A

_CENTILE" , MG6M_IN_A_VALUE AS "MG6M_IN_A_VALUE" , MG6M_IN_L_CENTILE AS "MG6M_IN_L_CENTILE" , MG6M_IN_L_VALUE AS "MG6M_IN_L_VALUE" , MP6M_IN_A_CENTILE AS "MP6M_IN_A_CENTILE" , MP6M_IN_L_CENTILE AS "MP6M_IN_L_CENTILE" , MTN AS "MTN

" , MTN_MKT_CD AS "MTN_MKT_CD" , NRB_NETEXT_UBI_TIX_CNT AS "NRB_NETEXT_UBI_TIX_CNT" , REGION_CD AS "REGION_CD" , SPRINT_REF AS "SPRINT_REF" , SPRINT_VALUE AS "SPRINT_VALUE" , SS_MTN_VERSION AS "SS_MTN_VERSION" , TMOBIL_REF AS "TM

OBIL_REF" , TMOBIL_VALUE AS "TMOBIL_VALUE" , LONGITUDE AS "LONGITUDE" , LATITUDE AS "LATITUDE" , WIRELINE_DT AS "WIRELINE_DT" , CALLS_GENERAL AS "CALLS_GENERAL" , CALLS_TECHSUPP AS "CALLS_TECHSUPP" , STORE_MAJOR AS "STORE_MAJOR"

, STORE_MINOR AS "STORE_MINOR" , NON_STORE_MAJOR AS "NON_STORE_MAJOR" , DATA_USAGE_PCT AS "DATA_USAGE_PCT" , VZ_MKT_CD AS "VZ_MKT_CD" , CAN_MEX_AMT AS "CAN_MEX_AMT" , CAN_MEX_MOU AS "CAN_MEX_MOU" , DRAGON_OVERAGE_AMT AS "DRAGON_O

VERAGE_AMT" , HSHLD_SIZE AS "HSHLD_SIZE" from VZRTD_TRANS.SS_MTN WHERE ( ACCOUNTNO = ? )

java.sql.SQLDataException: ORA-01476: divisor is equal to zero

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:79)

at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)

at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1030)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)

at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:785)

at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:860)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)

at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3482)

at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1373)

at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPreparedStatement.java:958)

at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:625)

at com.pega.pegarules.data.internal.access.DatabasePreparedStatementImpl.execute(DatabasePreparedStatementImpl.java:582)

at com.pega.pegarules.data.internal.access.DatabaseImpl.list(DatabaseImpl.java:6447)

Please find the attached document for the ORA-01476 SQL Error alert detail.

System Administration Data Integration
Moderation Team has archived post
Share this page LinkedIn