error posting invoices

[dace]

Hi, I'm having an error trying to post invoices- when I try, it ends up giving the error:

"SQL Error - Open Failed -OEBWRK. = Table not Found"
followed by
"Opening Procedure Failed"

I'm using 7.6.100a SQL.

Does anyone have any suggestions?

Thanks!

 

[crystalreporting]

That's not a table I recognize - are you sure it's not OEBBWRK? If it is, that's a Bank Book file. Has someone turned on Bank Book without setting the module up? You could always try initializing the table, but I'd look to see what's changed if this error hasn't occurred before. If it's not the OEBBWRK table, post the correct table name and someone will tell you what's up.

Peter Shirley

http://www.linkcorp.com

 

[dace]

Sorry, that was a typo, you are correct- the table is OEBBWRK. Bank book is not set up, so there's no actual OEBBWRK_SQL table in the database. However, I took at look at the MacOpenTables table and it's showing that it's open somewhere ???

 

[dace]

If it will ever help anyone else, I solved this problem in the following manner:

-I looked in the msllockdb database, and ran the query:

SELECT *
FROM MacOpenTables
WHERE (TableName = 'OEBBWRK_SQL')

-From this query I noticed it had this table open inside Macola's custom locking system- I changed the DBName field to point to a different database and it seemed to remove the I/O lock on the (nonexistent) table.