WebLogic Failed Due To ORA-01950: no privileges on tablespace

After sending a few orders, ASAP suddenly stops processing orders and the following error is seen in the weblogic PRO1domain.log:

#### <> <> <>  (server="PRO1server" store="PRO1.JMSJDBCStore" table="WLStore"):(Linked Cause, "java.sql.SQLSyntaxErrorException: ORA-01950: no privileges on tablespace 'DATA03'

There was an I/O error with the JDBC connection to the database. There was a lack of ASAP user privileges to write to the database table WLSTORE. The solution was to grant unlimited tablespace to the user.

 

Grant UNLIMITED TABLESPACE for ASAP user ADMPRO1. 

An example is below:

grant unlimited tablespace to ADMPRO1;

PS: Database users did not have any space quotas assigned to them explicitly. However, explicit grant unlimited was required to overcome the problem.