Sunday, October 20, 2013

java.sql.SQLException: Got minus one from a read call


If you get this error: pls check the alerts.log file.
.sql.SQLException: Got minus one from a read call


commisionTxnIdnull, levelOneApprovedQuantity=null, levelTwoApprovedQuantity=null, levelThreeApprovedQuantity=null, pybleAmt=0.0, _ntpybleAmt=0.0, _pyinsAmt=0.0, _refTransferIDnull
2013-10-21 10:28:40,075 : 2329 [main] DEBUG com.btsl.db.pool.OJDBCPoolManager  - createPool :: Creating oracle connection pool
2013-10-21 10:28:40,076 : 2330 [main] DEBUG com.btsl.db.pool.OJDBCPoolManager  - createPool 10G :: userid=neeraj1, db password=neeraj1, db_url=jdbc:oracle:thin:@172.23.23.47:1522:orcl, minPoolSize=100 max poolSize=150 oraclePoolLogFile=null
java.sql.SQLException: Got minus one from a read call
        at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
        at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:197)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:525)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:413)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
        at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:275)
        at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:206)
        at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:139)
        at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:88)
        at oracle.jdbc.pool.OracleImplicitConnectionCache.makeCacheConnection(OracleImplicitConnectionCache.java:1567)
        at oracle.jdbc.pool.OracleImplicitConnectionCache.makeOneConnection(OracleImplicitConnectionCache.java:499)
        at oracle.jdbc.pool.OracleImplicitConnectionCache.defaultUserPrePopulateCache(OracleImplicitConnectionCache.java:218)
        at oracle.jdbc.pool.OracleImplicitConnectionCache.<init>(OracleImplicitConnectionCache.java:194)
        at oracle.jdbc.pool.OracleConnectionCacheManager.createCache(OracleConnectionCacheManager.java:269)
        at com.btsl.db.pool.OJDBCPoolManager.createPool(OJDBCPoolManager.java:270)
        at com.btsl.db.pool.OJDBCPoolManager.getConnection(OJDBCPoolManager.java:67)
        at com.btsl.util.OracleUtil.getConnection(OracleUtil.java:113)
        at com.btsl.common.IDGenerator.getNextID(IDGenerator.java:81)
        at com.btsl.pretups.channel.transfer.businesslogic.ChannelTransferBL.genrateTransferID(ChannelTransferBL.java:129)
        at com.btsl.pretups.processes.ActivationBonusRedemption.process(ActivationBonusRedemption.java:291)
        at com.btsl.pretups.processes.ActivationBonusRedemption.main(ActivationBonusRedemption.java:119)
Caused by: oracle.net.ns.NetException: Got minus one from a read call
        at oracle.net.ns.Packet.receive(Packet.java:243)
        at oracle.net.ns.NSProtocol.connect(NSProtocol.java:259)
        at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292)
        ... 20 more


com.btsl.common.BaseException
        at com.btsl.db.pool.OJDBCPoolManager.getConnection(OJDBCPoolManager.java:68)
        at com.btsl.util.OracleUtil.getConnection(OracleUtil.java:113)
        at com.btsl.common.IDGenerator.getNextID(IDGenerator.java:81)
        at com.btsl.pretups.channel.transfer.businesslogic.ChannelTransferBL.genrateTransferID(ChannelTransferBL.java:129)
        at com.btsl.pretups.processes.ActivationBonusRedemption.process(ActivationBonusRedemption.java:291)
        at com.btsl.pretups.processes.ActivationBonusRedemption.main(ActivationBonusRedemption.java:119)
2013-10-21 10:28:42,649 : 4903 [main] ERROR com.btsl.pretups.channel.transfer.businesslogic.ChannelTransferBL  - genrateTransferID :: Exception 00000
class=null,method=null,message=00000,date=nullerrorCode=0
        at com.btsl.db.pool.OJDBCPoolManager.getConnection(OJDBCPoolManager.java:143)
        at com.btsl.util.OracleUtil.getConnection(OracleUtil.java:113)
        at com.btsl.common.IDGenerator.getNextID(IDGenerator.java:81)
        at com.btsl.pretups.channel.transfer.businesslogic.ChannelTransferBL.genrateTransferID(ChannelTransferBL.java:129)
        at com.btsl.pretups.processes.ActivationBonusRedemption.process(ActivationBonusRedemption.java:291)
        at com.btsl.pretups.processes.ActivationBonusRedemption.main(ActivationBonusRedemption.java:119)
2013-10-21 10:28:42,650 : 4904 [main] DEBUG com.btsl.pretups.channel.transfer.businesslogic.ChannelTransferBL  - genrateTransferID :: Exited  ID =null
class=ChannelTransferBL,method=genrateTransferID,message=9007,date=2013-10-21errorCode=0
        at com.btsl.pretups.channel.transfer.businesslogic.ChannelTransferBL.genrateTransferID(ChannelTransferBL.java:139)
        at com.btsl.pretups.processes.ActivationBonusRedemption.process(ActivationBonusRedemption.java:291)
        at com.btsl.pretups.processes.ActivationBonusRedemption.main(ActivationBonusRedemption.java:119)
class=ChannelTransferBL,method=genrateTransferID,message=9007,date=2013-10-21errorCode=0
        at com.btsl.pretups.channel.transfer.businesslogic.ChannelTransferBL.genrateTransferID(ChannelTransferBL.java:139)
        at com.btsl.pretups.processes.ActivationBonusRedemption.process(ActivationBonusRedemption.java:291)

        at com.btsl.pretups.processes.ActivationBonusRedemption.main(ActivationBonusRedemption.java:119)
-----------------------After checking  the alerts.log file  you will get this error the do the following--


Mon Oct 21 10:20:26 2013
ORA-00020: maximum number of processes (200) exceeded
 ORA-20 errors will not be written to the alert log for
 the next minute. Please look at trace files to see all
 the ORA-20 errors.
-- need to increase the processes by running this command ---

alter system set processes=500 scope=spfile;
shutdown immediate
startup



Enjoy this....:-)