Skip to Content

Optimization Package Failure - SAP BPC 7.5 - MS Platform

Hi BPC v7.5 Team,

We're getting the below error message with the nightly scheduled optimization packages runs. The only solutions I found on Google are for Microsoft CRM and is not applicable for us.

Any ideas?

Thanks! Barry

ERROR MESSAGE : System.InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed. at Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method
TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.CallMethod(Container BaseReference, String MethodName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, BindingFlags InvocationFlags, Boolean
ReportErrors, ResolutionFailure & Failure)
at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateCall(Object Instance,
Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack, Boolean IgnoreReturn) at OSoftPackageLauncher.Exe.Main(String[] args)(Assembly: Unknown, Object: OSoft.Services.Application.DataMgr.PackageExecute2008.DTSX)


LogID



SystemName



JobName



UserID



Status



DateWritten



963314



DM



  1. OSoftPackageLauncher.Exe.Main



14



Sunday, November 01, 2015



925132



DM



  1. OSoftPackageLauncher.Exe.Main



14



Sunday, October 18, 2015



628326



DM



  1. OSoftPackageLauncher.Exe.Main



14



Tuesday, July 07, 2015



301356



DM



  1. OSoftPackageLauncher.Exe.Main



14



Tuesday, February 17, 2015



167426



DM



  1. OSoftPackageLauncher.Exe.Main



14



Thursday, December 04, 2014


Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Nov 02, 2015 at 05:53 PM

    I found this note on Google: /**https://support.microsoft.com/en-us/kb/814912**/

    Add comment
    10|10000 characters needed characters exceeded

    • Hi John,

      You're correct. Our Network team was running a scheduled VM backup 5mins after the

      Optimization started. Once I was able to link the date-stamps in the Microsoft View to the MSSQL reports I saw the issue.

      Thanks! Barry J.

  • avatar image
    Former Member
    Nov 06, 2015 at 08:44 PM
    Add comment
    10|10000 characters needed characters exceeded

  • Nov 09, 2015 at 09:13 AM

    Hi Barry,

    did you found the reason?

    Have you tried to launch it manually during the day?

    All the systen is off or you're able to send data?

    Regards

    Roberto

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Barry,

      but the error persists? You have every day to change the status?

      I've have had a similar error when the space of transaction log was full, normally during process dimension I can see clearly this error message but with one big appset (100 million of records) just the scheduled optimize go in error and like yours complete the data transfert (but not all the steps) leaving the appset offline.

      Check the SQL errors in SSMS and verify how much space is available for the logs and also on the disk that contains your db.

      Regards

      Roberto