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

  • 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