HI All,

I am getting a strange error while I am committing any transaction.

I my function A its inserting record properly. But in my function B its showing error at the time of commit.transaction().

Please share the possible issues.

Thanks

Hello,

check your logfiles !

Oracle error 1536 = space quota exceeded for tablespace

Give more Information about the structure, please.

(retry point ? ...... ?)

Regards

Hi
My piece of code is like this

ret = db.insert(ttdwps202,db.retry)


if ret = 0 then
commit.transaction()
endif
When it comes to db.insert() its returning zero but at the time of committing its throwing this error.

And yes I have used db.retry.point()

Check the following things -

1. Are both function A and B inserting into same table?
2. Is there any commit after function A?
3. Are you checking for duplicate records?
4. Is the data correct i.e no special characters,etc ?

As already mentioned by Bernd, 1536 = Oracle DB Error (http://docs.oracle.com/cd/E11882_01/server.112/e17766/e1500.htm#sthref841) which could either be related to the permissions on the table, may be data issue or something is not right with the table definition. Check your log files and if possible post your full code.

It could also be that you have another table in which you already put so much data that you were close to the quota and the create table was just pushing it over the edge.

1. Are both function A and B inserting into same table?
No Record being inserted into different table
2. Is there any commit after function A?
Yes In the function after db.insert() I have used commit.
3. Are you checking for duplicate records?
There is No record presents in my table and I am checking duplicate values too./COLOR]
4. Is the data correct i.e no special characters,etc ?
[COLOR="RoyalBlue"] No Data is correctl

It could also be that you have another table in which you already put so much data that you were close to the quota and the create table was just pushing it over the edge

Yes 1 thing I forgot to mention that previously I was inserting record into the table and it was getting inserted. But after I modified the table definition(Added a field) and I did CRDD. The table definition is fine, but data is not getting inserted even through GTM.

Yes 1 thing I forgot to mention that previously I was inserting record into the table and it was getting inserted. But after I modified the table definition(Added a field) and I did CRDD. The table definition is fine, but data is not getting inserted even through GTM.

Seems like you have a problem here. What is the table structure? What modifications you did?

I have added a field only. and that field to the index..

One more issue. While I am deleting the table its taking huge time. So I terminated it manually. I think there is something which is not allowing to delete the tables too.

Hi,

Was there any data before you changed the index? Stopping the process might have surely impacted the table. If its just a new test table you can try creating a new one instead and delete this one. It might have been corrupted and you will need to go through the recovery process for the table first.

But well, its not your programming issue but indeed the issue is with the table definition.

okk Thanks

I will go with your suggested steps.

srprks,

I checked our system and we do not have a td-wps module. If its your custom code, then post it here so others can review to help you.

Based on the Oracle error code information -
ORA-01536: space quota exceeded for tablespace 'string'
Cause: The space quota for the segment owner in the tablespace has been exhausted and the operation attempted the creation of a new segment extent in the tablespace.
Action: Either drop unnecessary objects in the tablespace to reclaim space or have a privileged user increase the quota on this tablespace for the segment owner.
Use one of the following scripts to check the table space quota in the DB-
query to check tablespace size and freespace (https://community.oracle.com/thread/507636)
Monitoring Tablespace Usage in Oracle (http://www.databasejournal.com/features/oracle/monitoring-tablespace-usage-in-oracle.html)
Find out free space on tablespace (http://stackoverflow.com/questions/7672126/find-out-free-space-on-tablespace)
Oracle tablespace script (http://www.dba-oracle.com/t_tablespace_script.htm)

If you do not have enough free space then you can set the table space to auto extend or increase the size. Refer to -
Changing Datafile Size (https://docs.oracle.com/cd/B28359_01/server.111/b28310/dfiles003.htm)
ALTER TABLESPACE (https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_3002.htm)
Altering and Maintaining Tablespaces (https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces007.htm)
Oracle ALTER DATABASE RESIZE DATAFILE Tips (http://www.dba-oracle.com/t_alter_database_datafile_resize.htm)

How many records are in the table?
One more issue. While I am deleting the table its taking huge time. So I terminated it manually. I think there is something which is not allowing to delete the tables too.
How are you deleting the table? Are you using ttaad4231m000? or any custom code?
Are you using these commands - db.delete() (http://www.baanboard.com/programmers_manual_baanerp_help_functions_db_operations_db_delete) or db.drop.table() (http://www.baanboard.com/programmers_manual_baanerp_help_functions_db_operations_db_drop_table) or db.clear.table() (http://www.baanboard.com/programmers_manual_baanerp_help_functions_db_operations_db_clear_table)?
How did you terminate it?

Yes, I thought of it as well. But he mentioned this -

"There is No record presents in my table and I am checking duplicate values too" and hence I dropped the idea of having huge table size.

Hi NP Rao SIr,

As Bhusan already mentioned it may not be a programmatic error. Basically its due to the change in table definition.

It was working fine before I reconfigured the table after adding a field and that field to index.

I have used the session ttaad4231m000 to delete the table. When I was deleting it,it took long time to delete that table although there are no records in that table. So I used bshell to kill all processes.

That's it

Please post more of your code , the ones which you have posted has minimal information..

also, are you sure, you are not using just one commit.transaction and two db.retry.points or vice versa?

Also, just do create runtime of your Table once again, and then log out and try again

Also, Is your table structure proper? The Field which is being inserted into primary index , Is it really unique?