Options
  • State Verified Answer
  • Locked Locked
  • Replies 12 replies
  • Subscribers 8 subscribers
  • Views 2064 views
  • Users 0 members are here
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Problem with VBScript

KarloPavicic

Hello,

 the attached script should calculate the property value in a certain class within a certain workflow and state. The script works inside the  loop, but the "if" condition is wrong. In what way could it be remade?

Dim dtToday
Dim documentClass
Dim iWorkflow
Dim iWorkflowState


documentClass = PropertyValues.SearchForProperty(100).TypedValue.DisplayValue
iWorkflow = PropertyValues.SearchForProperty(38).TypedValue.DisplayValue
iWorkflowState = PropertyValues.SearchForProperty(39).TypedValue.DisplayValue


if documentClass = "Mileage Status" or documentClass = "Employee Car"  and iWorkflowState = "2.1 Mileage Status" and iWorkflow = "Employee Car Process" then

dtToday = Now
Dim dtLastDay
dtLastDay = DateSerial(Year(dtToday), Month(dtToday) + 1, 0)


if dtToday = dtLastDay then
dtLastDay = DateSerial(Year(dtToday), Month(dtToday) + 2, 0)
end if

Output = dtLastDay

else
' '

end if

Parents
  • +1

    When combining AND and OR conditions in your if statement in line 12 you should use paranthese () to indicate in which order they have to be considered. It should probably be something like:

    if (documentClass = "Mileage Status" or documentClass = "Employee Car")  and iWorkflowState = "2.1 Mileage Status" and iWorkflow = "Employee Car Process" then

  • 0 in reply to bright-ideas.dk

    Hello,

    I try on this way and I got the error: The operation failed. Not found. Did you maybe have some other ideas?

  • 0 in reply to KarloPavicic

    What's the full error stack? 

  • 0 in reply to KarloPavicic

    Which line creates the new error?

    I suspect the error comes from a different line than the IF statement, possible from line 26. Not  quite sure what you are trying to achieve there. It probably should be
       Output = ''

  • 0 in reply to bright-ideas.dk

    This is error when i try run Recalculate. 

    When I go check in Event Viewer this is full error details:

    The job "Recalculate" finished running.

    Status: Failed. Error: Not found.

    RPCScheduledJobsHelper.cpp, 3217, Script execution failed. ((Next Mileage Status Date, PropertyDefCalculatedValue: 10-999-10)) (0x800408BB)
    RPCScheduledJobsHelper.cpp, 2709, Script execution failed. ((Next Mileage Status Date, PropertyDefCalculatedValue: 10-999-10)) (0x800408BB)
    RecalculateProperties.cpp, 1113, Script execution failed. ((Next Mileage Status Date, PropertyDefCalculatedValue: 10-999-10)) (0x800408BB)
    RecalculateProperties.cpp, 899, Script execution failed. ((Next Mileage Status Date, PropertyDefCalculatedValue: 10-999-10)) (0x800408BB)
    RecalculateProperties.cpp, 1881, Script execution failed. ((Next Mileage Status Date, PropertyDefCalculatedValue: 10-999-10)) (0x800408BB)
    RecalculateProperties.cpp, 1601, Script execution failed. ((Next Mileage Status Date, PropertyDefCalculatedValue: 10-999-10)) (0x800408BB)
    RecalculateProperties.cpp, 1435, Script execution failed. ((Next Mileage Status Date, PropertyDefCalculatedValue: 10-999-10)) (0x800408BB)
    RecalculateProperties.cpp, 1668, Script execution failed. ((Next Mileage Status Date, PropertyDefCalculatedValue: 10-999-10)) (0x800408BB)
    RecalculateProperties.cpp, 1379, Script execution failed. ((Next Mileage Status Date, PropertyDefCalculatedValue: 10-999-10)) (0x800408BB)
    VaultScriptSessionTemplates.cpp, 275, Script execution failed. ((Next Mileage Status Date, PropertyDefCalculatedValue: 10-999-10)) (0x800408BB)
    VaultScriptSessionTemplates.cpp, 340, Script execution failed. ((Next Mileage Status Date, PropertyDefCalculatedValue: 10-999-10)) (0x800408BB)
    VaultScriptSessionTemplates.cpp, 340, Not found. (0x8004000B)
    VaultScriptSessionTemplates.cpp, 523, Not found. (0x8004000B)
    CoActiveScriptSite.cpp, 895, Not found. (0x8004000B)
    CoActiveScriptSite.cpp, 737, Not found. (0x8004000B)
    Next Mileage Status Date, PropertyDefCalculatedValue, 10, Not found. (0x8004000B)
    MNullPropagatingDispatchImpl.h, 126, Not found. (0x8004000B)
    MNullPropagatingDispatchImpl.h, 173, Not found. (0x8004000B)
    CoPropertyValues.cpp, 347, Not found. (0x8004000B)
    (M-Files 22.6.11534.5 2023-02-06T07:47:13.995Z)

    Job type: Recalculate

  • 0 in reply to bright-ideas.dk

    When i start Recalulate operation i got this error:

    And this is event from event viewer:

    Status: Failed. Error: Not found.

    RPCScheduledJobsHelper.cpp, 3217, Script execution failed. ((Next Mileage Status Date, PropertyDefCalculatedValue: 10-999-10)) (0x800408BB)
    RPCScheduledJobsHelper.cpp, 2709, Script execution failed. ((Next Mileage Status Date, PropertyDefCalculatedValue: 10-999-10)) (0x800408BB)
    RecalculateProperties.cpp, 1113, Script execution failed. ((Next Mileage Status Date, PropertyDefCalculatedValue: 10-999-10)) (0x800408BB)
    RecalculateProperties.cpp, 899, Script execution failed. ((Next Mileage Status Date, PropertyDefCalculatedValue: 10-999-10)) (0x800408BB)
    RecalculateProperties.cpp, 1881, Script execution failed. ((Next Mileage Status Date, PropertyDefCalculatedValue: 10-999-10)) (0x800408BB)
    RecalculateProperties.cpp, 1601, Script execution failed. ((Next Mileage Status Date, PropertyDefCalculatedValue: 10-999-10)) (0x800408BB)
    RecalculateProperties.cpp, 1435, Script execution failed. ((Next Mileage Status Date, PropertyDefCalculatedValue: 10-999-10)) (0x800408BB)
    RecalculateProperties.cpp, 1668, Script execution failed. ((Next Mileage Status Date, PropertyDefCalculatedValue: 10-999-10)) (0x800408BB)
    RecalculateProperties.cpp, 1379, Script execution failed. ((Next Mileage Status Date, PropertyDefCalculatedValue: 10-999-10)) (0x800408BB)
    VaultScriptSessionTemplates.cpp, 275, Script execution failed. ((Next Mileage Status Date, PropertyDefCalculatedValue: 10-999-10)) (0x800408BB)
    VaultScriptSessionTemplates.cpp, 340, Script execution failed. ((Next Mileage Status Date, PropertyDefCalculatedValue: 10-999-10)) (0x800408BB)
    VaultScriptSessionTemplates.cpp, 340, Not found. (0x8004000B)
    VaultScriptSessionTemplates.cpp, 523, Not found. (0x8004000B)
    CoActiveScriptSite.cpp, 895, Not found. (0x8004000B)
    CoActiveScriptSite.cpp, 737, Not found. (0x8004000B)
    Next Mileage Status Date, PropertyDefCalculatedValue, 10, Not found. (0x8004000B)
    MNullPropagatingDispatchImpl.h, 126, Not found. (0x8004000B)
    MNullPropagatingDispatchImpl.h, 173, Not found. (0x8004000B)
    CoPropertyValues.cpp, 347, Not found. (0x8004000B)
    (M-Files 22.6.11534.5 2023-02-06T07:46:19.935Z)

    Job type: Recalculate

  • 0 in reply to bright-ideas.dk

    When i try start operation recalulate i got this error:

  • 0 in reply to KarloPavicic

    Could it be that some of your objects don't have a workflow or state?

  • +1 in reply to Craig Hawker

    Thank you all for helping. We find solutions and solve problems.

  • 0 in reply to KarloPavicic

    Next Mileage Status Date, PropertyDefCalculatedValue, 10, Not found. (0x8004000B)

    What is line ten on the code?  Is it trying to retrieve a property value?

  • 0 in reply to KarloPavicic

    Did you see my question about line 10?

Reply Children
No Data




              

© M-Files Corporation 2024 | Privacy Policy