SQL FOB load - permission table error message - HELP!?

boywonder

Hi all

We have a problem in restoring a FOB into a live SQL db, getting the following message.....

You cannot delete or change the type of the Read Permisison field (in the Permission table) before the value is reduced to 0 (zero) or '' (blank) in all records.

The message doesn't make sense because the tables in the FOB are all basic tables and the Permission table isn't one of them. :?

The client recently installed SP3 (going from SP2) so this may be related.

I have asked them to stop/start the SQL services and try loading FOB with no users in the system to start with....

But I suspect they will still receive this message.....so any ideas how to solve would be greatly appreciated

i4tost

maybe you use security filter (when you give permissions by filtering records)?
Or maybe you have table that has incorect caption (means permissions) and now you try to overwrite it?

kriki

Looks that you are trying to import the Permissions table and that you have changed the type of that field.
Did you just translate the error from Spanish or were you in English language. My experience is that you best put the language to English to have a better error-message.

Something else to try: did you change the Security Model to Standard. That fixes a lot of problems!

Xypher

I could be totally wrong but the error message looks a lot like you're importing a table that has more or less fields as the current table (or one or more fields from the import has a different data type as the corresponding field in the current table); and it wont let you import because there is currently data in the table.

(Which is what kriki said essentially :-# )

boywonder

Hi all, thanks for the replies. The install is in English & so the error has not been translated.

The Permission table isn't included in the FOB so the system shouldn't be complaining :?

kriki

Create a new DB and put all objects (the ones from the DB) in it but without data. Then import the fob to see if it works. Then you can export the tables as text and also the original tables and check what the differences are.