MaxDB Backup Template error

[Former Member]

Hi all

I have an error with MaxDB-Templates.

When i want to add a template or even want to look at the templates via
backup_template_show all

I always get the following error message:

-24582,ERR_FILEREAD: Error reading file /sapdb/KP1/data/wrk/KP1/BackupTemplates.xml
3,Error during excution of SAX parser
5,SAX error: not well-formed (invalid token)
4,Error in document '/sapdb/KP1/data/wrk/KP1/BackupTemplates.xml' (row: 17, column: 23)

When I delete the .xml-file, it is automatically recreated some seconds later and the error persists.

How can I repair that (old templates are irrevelant and can be deleted).

Thanks for your help.

[MichaelTe]

Hello Herbert,

the error says:

4,Error in document '/sapdb/KP1/data/wrk/KP1/BackupTemplates.xml' (row: 17, column: 23)

So I think there is a problem with the following line:

<file location="/sapdb/<DB>/saparch/<DB>LOG"/>

Which belongs to template "autosave". Did you try to delete this template? Try:

dbmcli -d KP1 -u control,xxx backup_template_delete autosave

Regards,

Michael

[Former Member]

Hello Michael,

same error:

-24582,ERR_FILEREAD: Error reading file /sapdb/KP1/data/wrk/KP1/BackupTemplates.xml
3,Error during excution of SAX parser
5,SAX error: not well-formed (invalid token)
4,Error in document '/sapdb/KP1/data/wrk/KP1/BackupTemplates.xml' (row: 17, column: 23)

It always tries to read the template before doing anything.

Is it possible to change the .xml-file outside of SAP?

I think <db> should be changed to the database name KP1.

Regards,

Herbert

[MichaelTe]

Hello Herbert,

I did this on a DB of my own, and it worked. Make a backup copy of the file. And then edit the file and delete the following lines:

</template>
<template id="autosave" content="AUTO" purpose="AUTOMATICLOGBACKUP" blockSize="8">
<timestamps created="20180919173414" modified="20180919173414"/>
<carrier>
<file location="/sapdb/<DB>/saparch/<DB>LOG"/>
</carrier>
</template>

Regards, Michael

[Former Member]

Hi Michael,

here is the output:

<BackupTemplateRepository>
<template id="KP1_full" content="DATA" purpose="UNKNOWN" blockSize="8">
<timestamps created="20120603192440" modified="20120603192440"/>
<carrier>
<file location="/mnt/sap_copy/backupKP1full5"/>
</carrier>
</template>
<template id="na_snap" content="DATA" purpose="UNKNOWN" blockSize="8">
<timestamps created="20120605162016" modified="20120605162016"/>
<backuptoolCarrier tool="DBMC">
<external/>
</backuptoolCarrier>
</template>
<template id="autosave" content="AUTO" purpose="AUTOMATICLOGBACKUP" blockSize="8">
<timestamps created="20180919173414" modified="20180919173414"/>
<carrier>
<file location="/sapdb/<DB>/saparch/<DB>LOG"/>
</carrier>
</template>
</BackupTemplateRepository>

Regards

Herbert

[MichaelTe]

Hello Herbert,

can you please post the output of the command:

dbmcli -d KP1 -u control,xxx file_getfirst DBMMDF

Regards, Michael

[Former Member]

Hello Michael,

we are using MaxDB 7.9.08.40.

I already found this discussion, but I think we have problems with the Database name, because
I'm working with a database copy (I think they renamed it) and in the old template will
be wrong information.

How can I delete the wrong template?

Even the cli command "backup_template_show all" returns the error.

Regards

Herbert

[MichaelTe]

Hello,

which MaxDB Version are you using?

Perhaps this can help?

https://archive.sap.com/discussions/thread/3408354

Regards, Michael