Hi friends,

I have a little problem. I have a customized session to generate the invoice sequence number. That session works well both in test and live company. The only difference in the live company is that the session not allow to delete any record. Whenever I try to delete a record in the live company it gives following error message

Fatal error: Error 1000 (bdb_errno 1000) on tfabc0100001 in db_eq(delayed)
Fatal error: can not continue in tfabc0110m111 in DLL: ottstpstandard (<150>[retry.point])

What could be reason and how I should resolve this porblem? In the test company, I can delete any record.

Thanks in advance
Mahmood

I can think of only a few things to check. Are tools set, porting set, database versions all the same between test and production? You may want to force a create run time on the table itself. Also are there any database level permissions that are different?

I am going to move this to the database forum where others may have some better ideas.

Mark

Try removing the stored procedure for the table via SQL enterprise manager.

Dave

Hello,

The same error I too got , and then after DELETING the stored procedure i started getting error bdb_error 1515 i.e. 1505 - 1000 = 515 in SQL Server

and for sql server error no. 515 , description is


Cannot insert the value NULL into column '%.*ls', table '%.*ls'; column does not allow nulls. %ls fails.


When ever i use to insert the value through session in that table it use to say "FATAL ERRROR during insert 1515"

after that I re-generated the session, and now my session is working fine with that table.

I don't know why it was giving error 515, when i was not specifying anything NULL or leaving blank in my session.

Regards

Learner

hi ,

the reorganizing the particular table will solve urs purpose.

chow. ;)

Dear All
When i am creating a new form and insert some field and save then show some error like fatal error error 1515(database error 515)

Thanks

Gurmeet Singh

Dear All
When i am creating a new form and insert some field and save then show some error like fatal error error 1515(database error 515)

Thanks

Gurmeet Singh
there would be error in the tables, basically bdb 515 is runtime data dictionary error, means some problem in convert to runtime data dictionary of tools.

just check