Forum Discussion

Nikpowar97's avatar
Nikpowar97
Contributor
10 months ago

Not enough quota is available to process this command.

I am Running a Dashboard Data set rule.

The process is a bit longer.

For Each EntMem As MemberInfo In BRApi.Finance.Members.GetMembersUsingFilter(si, Brapi.Finance.Dim.GetDimPk(si, "DimName"), "E#Top.Base", True)
	For Each Parent As Member In BRApi.Finance.Members.GetParents(si, Brapi.Finance.Dim.GetDimPk(si, "DimName"), EntMem.Member.MemberId, True)
		If EntParentCheck.Contains(Parent.Name) Then
			Dim customSubstVars As New Dictionary(Of String, String)
			customSubstVars.Add("dmTime", Time)
			customSubstVars.Add("dmScenario", Scenario)
			customSubstVars.Add("dmEntity", Entmem.Member.Name)
			customSubstVars.Add("dmParent", Parent.Name)
			customSubstVars.Add("FileName", FileName)
			BRApi.Utilities.StartDataMgmtSequence(si, "Export Cube Data", customSubstVars)
		End If
	Next
Next

ERROR: Not enough quota is available to process this command.

I think it is generally with long running jobs on OS Dashboards?

 

 

 

  • JackLacava's avatar
    JackLacava
    Honored Contributor

    You're looping through every entity/parent combination, and starting a DM job for many of them. This could be spawning hundreds or thousands of threads, each one generating a file, so you're hitting Windows limits somewhere. If your environment is on-premises, you can try tweaking Windows settings, but to be honest this just seems like a flawed approach. Depending on why exactly you're trying to get data out of OneStream, there are better approaches than this bruteforcing.

    • Nikpowar97's avatar
      Nikpowar97
      Contributor

      I agree I was just doing a performance testing on the OS cloud app. Just wanted to check of there is an alternate way/ a setting(scaling) to avoid such long Operation failures on the Database.