SAP Maxdb table is a read-only

[Former Member]

Maxdb Table read only after the being exported and imported from source server to destination.

[JamesZ]

Hi Oscar,

How did you perform the export and import, which tool was used?

Best regards,
James

[Former Member]

Hi James,

i exported using loadercli command line.

i did this on the target server.

kind regards,

Oscar

[JamesZ]

can you share the SDB_IMPORT.sql file which you used during import?

As mentioned, the problem here is that onlog option was used.

[Former Member]

Below see the DB_Import.sql that i used

IMPORT USER

catalog instream file 'F:\export\SAPR3.cat'

data instream file 'F:\export\SAPR3.data' PAGES

package outstream file 'F:\import\SAPR3.pack' csv

[JamesZ]

in this case, please try to perform a database backup, afterwards check if the read only mode is turned off.

[Former Member]

Hi James

Thanks for the advice, after i performed the backup, now the read-only is turned off.

The current challenge is that it opens information up to mid March 2016 and the export was done on the 28th May 2016.

Any idea what could be missing hear.

Thanks in advance.

Kind regards,

Oscar

[JamesZ]

Hi Oscar,

That is to say data is missing, usually export and import won't cause this issue.

You may need to check if any filter is set by export, or redo the import to check at phase the data is missing, export or import?

Best regards,
James

[david_liu1]

Hello,

This error:

-115: Table is read only

Explanation:

The attempt was made to perform an <INSERT>, <UPDATE> OR <DELETE>

statement. But the specified table only allows reading SQL

statements because it was previously loaded with the NOLOG option.

User Action:

The read-only mode can be implicitly cancelled saving data or pages

using the database administration tool.

Have you followed the SAP note:

962019 System copy of an SAP MaxDB Content Server database

Regards,

David

[Sriram2009]

Hi Oscar.

Could you check the free disk space in the DB and log folders?

BR

SS