Skip to Content

MaxDB Backup Template error

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Sep 25 at 06:22 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Sep 24 at 06:42 AM

    Hello,

    which MaxDB Version are you using?

    Perhaps this can help?

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

    Regards, Michael

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 24 at 10:54 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 24 at 11:10 AM

    Hello Herbert,

    can you please post the output of the command:

    dbmcli -d KP1 -u control,xxx file_getfirst DBMMDF

    Regards, Michael

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 24 at 02:57 PM

    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

    Add comment
    10|10000 characters needed characters exceeded