https://community.sap.com/t5/technology-q-a/non-deterministic-problem-with-backup/qaa-p/13847534#M4878377 <P>"Attempted two active database requests" What else is going on during the backup ? Some other backup request, replication etc ?</P> Fri, 02 Sep 2011 06:26:09 GMT Former Member 2011-09-02T06:26:09Z https://community.sap.com/t5/technology-q-a/non-deterministic-problem-with-backup/qaq-p/13847533 <P>Every now and then I have the problem, that on one machine the backup is not working. The error from dbbackup 11.0.1.2506 reads:</P> <DIV class="codehilite"><PRE><SPAN class="n">Error</SPAN> <SPAN class="n">writing</SPAN> <SPAN class="n">backup</SPAN> <SPAN class="n">file</SPAN> <SPAN class="s">"Invalid argument"</SPAN> <SPAN class="n">Attempted</SPAN> <SPAN class="n">two</SPAN> <SPAN class="n">active</SPAN> <SPAN class="n">database</SPAN> <SPAN class="n">requests</SPAN> <SPAN class="n">Database</SPAN> <SPAN class="n">backup</SPAN> <SPAN class="n">failed</SPAN> </PRE></DIV> <P>From the runtime I assume that more or less the database backup process is at the end, maybe working on the transaction log file. Filesystem is in good shape and having still enough spare space.</P> <P>The only parameters used to start dbbackup are -x -y -o and -c (of course)</P> <P>Any idea, what might cause this cryptic error message?</P> Thu, 01 Sep 2011 10:47:24 GMT https://community.sap.com/t5/technology-q-a/non-deterministic-problem-with-backup/qaq-p/13847533 MCMartin 2011-09-01T10:47:24Z https://community.sap.com/t5/technology-q-a/non-deterministic-problem-with-backup/qaa-p/13847534#M4878377 <P>"Attempted two active database requests" What else is going on during the backup ? Some other backup request, replication etc ?</P> Fri, 02 Sep 2011 06:26:09 GMT https://community.sap.com/t5/technology-q-a/non-deterministic-problem-with-backup/qaa-p/13847534#M4878377 Former Member 2011-09-02T06:26:09Z https://community.sap.com/t5/technology-q-a/non-deterministic-problem-with-backup/qaa-p/13847535#M4878378 <P>no backup and no replication, just normal queries</P> Fri, 02 Sep 2011 06:59:17 GMT https://community.sap.com/t5/technology-q-a/non-deterministic-problem-with-backup/qaa-p/13847535#M4878378 MCMartin 2011-09-02T06:59:17Z https://community.sap.com/t5/technology-q-a/non-deterministic-problem-with-backup/qaa-p/13847536#M4878379 <P>DBLib generates this error if two threads try to use the same SQLCA at the same time. If you can reproduce this I suggest opening a support case. As a workaround you could try a server side backup and then copying the database to a different computer.</P> Fri, 02 Sep 2011 08:22:26 GMT https://community.sap.com/t5/technology-q-a/non-deterministic-problem-with-backup/qaa-p/13847536#M4878379 ian_mchardy 2011-09-02T08:22:26Z