Question

2
Replies
136
Views
pradeep pydi (pradeepp2840)
Verizon Wireless
PEGA SENIOR SYSTEM ENGINEER
Verizon Wireless
US
pradeepp2840 Member since 2017 20 posts
Verizon Wireless
Posted: July 6, 2017
Last activity: July 11, 2017
Posted: 6 Jul 2017 16:38 EDT
Last activity: 11 Jul 2017 16:24 EDT
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

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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.