Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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


 

Tags:
Former Member
replied

Hi Barry,

It appears communication between the APP and DB servers is failing.

See if there are any nightly jobs or backups occuring at the same time the optimization runs.

Also check the event viewer logs on the servers for any clues.

Thanks,

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question