Error: Failed to create ad-hoc schema export using backup service on host

[JerushaLala]

Hi All,

We use the RSP backup service to backup certain schema's once a week.1 out of 10 schema's failed to backup.
I then went to that specific schema to and clicked on trigger export scheme now.

I get the error: An error occurred while processing this request., Failed to create ad-hoc schema export using backup service on host <hostname>
I tried through the SLD (export the schema) and I get the same error.
Does anyone know what service to check for?

Thank you
Jerusha

[divtech]

Hi Jerusha, did you ever fix this? I am running into the same issue on SAP B1 Cloud (1.1 PL15).

[former_member634067]

I have same error, my SAPB1 version is v10 PL2008(HANA)

[former_member263129 · Accepted solution]

Hello,

There is a file in the /var/log/SAPBusinessOne/BackupService/logs/SID_SERVER_PORT directory: SCHEMA_NAME.pid. This file is editable. Open it and delete the numbers from it. Keep only the largest. After that, the export will run successfully.

Best regards,

Katalin

[nikunjmehta2290 · Accepted solution]

Solved it via this steps. Thank you

[former_member830301 · Accepted solution]

Katalin Kiss, that worked for me, thank you.

[alessandro_cimino_mtf · Accepted solution]

It's worked for me! Thanks a lot!

[former_member864924 · Accepted solution]

Hi,

Excellent. It works. Thanks

[nick_carr · Accepted solution]

excellent - solved mine too. thanks Katalin

[marwaawad · Accepted solution]

It worked for me, thank you.

[prudhvi_ravipati]

Hello,

I have faced the same issue and below is the solution to sort the issue.

Login into SLD ad select the Database which we were exporting. Click on Show export log.

Check for more recent log creation and it will have PID at the last of the thread like below

"run_backup.sh(13497) 211208-133648: Instance:HANA Instance Schema:"DATABASE" Found stale pid file /var/log/SAPBusinessOne/BackupService/logs/HANA Instance/DATABASE.pid with pid(13477)."

Kill the PID and try the export it will export.

Best Regards,
Prudhvi.

[former_member1375864]

I had the same problems too. Then I tried another way by creating manual backups instead of automation. You can also perform the backup & restore process by using queries in Hana Studio.

Best Regards,

Ye Lin Naing

[YDouble]

Hello,

I had the same problem recently.

The proposed solutions did not work for me either, but the export log in the SLD gave me hints.

In my case, it was a messed-up sudoers file (caused by adding a user through the GUI instead of the cli), which was preventing the tech user from running the shell script.

After fixing the file, the issue is gone. So, the details in the export log can really help in pinpointing the exact issue.

Best regards.

[brendend]

Hi Jaz,

Go to your ControlCenter and select the database you are trying to export, then click on Show Export Logs: What does your recent logs say ?

Kind Regards,

Brenden Draper

[wjmatamoros]

Good day.
I managed to fix it by renaming the .pid file located in the SAP logs folder from suse linux.

path: /var/log/SAPBusinessOne/BackupService/YourServer_30015/YourSchemaName.pid

BR.
William

[JerushaLala]

Hi Wille,
Eventually we found out it was a backup process that was stuck on the SAP server. I am not sure which service as I was assisted with this.

[former_member634067]

I fixed it after a clean reboot hana.

the process I've done

1. Get the log in SLD>Schema Export Log

run_backup.sh(12941) 210515-181501: Instance:NDB@xxxx-xxxx:30013 Schema:xx" Found pid file /var/log/SAPBusinessOne/BackupService/logs/xxxxx-xxxx/xxx.pid with running pid(6139)

2.Trace the pid#6139 with the command: ps -ef|grep 6139

Was intended to kill pid#6139 but nothing found in this process list

3.Reboot server

After reboot successfully, the backup service is resume to normal.

[yuyukyi]

Hi,jerusha7,

Do you find any solution? I got the same error. I tried Willie Chou method but it did not solve the issue.The error is still there.