Content Server error

[Former Member]

Hi,

While I am importing CS data as a part of migration (using sdb_import.sql), I am getting the following error

''....export_dump/SAPR3.data001 was not generated using EXPORT in PAGE format (wrong identifier)''

Please note : Source - MaxDB 7.6, AIX, CS 6.30, Target - MaxDB 7.6, SUSE, CS 6.40

Can someone help ?

Thanks

[markus_doehr2]

> ''....export_dump/SAPR3.data001 was not generated using EXPORT in PAGE format (wrong identifier)''

>

> Please note : Source - MaxDB 7.6, AIX, CS 6.30, Target - MaxDB 7.6, SUSE, CS 6.40

Did you create the export as described in

Note 962019 - System copy of an SAP MaxDB Content Server database

using the page identifier?

Markus

[Former Member]

Hi Markus / Deepak,

Yes I did the export as per the note : 962019.

Thanks

Rajesh

[markus_doehr2]

Hmm...

and source and target database are on the same patchlevel also?

Markus

[former_member188883]

Hi Rajesh.

Explanation of error message you got:

================================

Error in the Loader command for importing data.The data streams for this command must be binary and contain database structures and special information on executing the subsequent IMPORT command. These data streams are created using the EXPORT command and must not be modified.The data stream specified in the command was modified after the export was executed or it was not created using the EXPORT command. In the cause of the error section you see which information in the data stream cannot be evaluated.

Soltuion:

========

Create the data stream using the EXPORT command and re-execute the command.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Markus - yes, it's in the same patch level.

Deepak - Thanks, I've seen this note somewhere.

it looks like issue with export (failed once ,so retried), so will retry again with loader log file and let you know the status.

Thanks for your time.

[Former Member]

Hi,

Repeated the steps several times and get the same error in all cases. We used the same loadercli for both the export and import. We have also checked the ulimits for the sdb user, it is set to unlimited

Also raised SAP customer messge.

Please advise how we can resolve this.

Thanks

Rajesh

[Former Member]

Just FYI only

with the help of a modified control file (provided by SAP) I re-run the export successfully.

the control file looks like this:

export/CONTENT_SERVER_CT1/export_dump # cat SDB_EXPORT.sql

EXPORT USER CATALOG OUTSTREAM FILE '/export/CONTENT_SERVER_CT1/export_dump/SAPR3.cat'

//

EXPORT TABLE COMPONENTS0001

DATA OUTSTREAM FILE '/export/CONTENT_SERVER_CT1/export_dump/COMPONENTS0001.pages' PAGES

//

EXPORT TABLE COMPONENTS0002

DATA OUTSTREAM FILE '/export/CONTENT_SERVER_CT1/export_dump/COMPONENTNS0002.pages' PAGES

//

EXPORT TABLE CONTREP

DATA OUTSTREAM FILE '/export/CONTENT_SERVER_CT1/export_dump/CONTREP.pages' PAGES

//

EXPORT TABLE DOCUMENTS0001

DATA OUTSTREAM FILE '/export/CONTENT_SERVER_CT1/export_dump/DOCUMENTS0001.pages' PAGES

//

EXPORT TABLE DOCUMENTS0002

DATA OUTSTREAM FILE '/export/CONTENT_SERVER_CT1/export_dump/DOCUMENTS0002.pages' PAGES

Thanks for your support

Rajesh

[former_member188883]

Hi,

How was the export done ?

As per the information furnished by you there seems to be difference in actual data file size and its information in some controlfile.

Regards,

Deepak Kori