Problem with using dynamicfields in transitions[SOLVED]

[naimson]

Hello. I have this simple process - http://imgur.com/a/0p2uy
but there i cannot put value from DynamicField_custnumber (if i put direct value (in my case is 23) then all work) ,else otrs product me SQL(oracle) error

Code: Select all

ORA-01722: invalid number (DBD ERROR: error possibly near <*> indicator at char 475 in '
            INSERT INTO ticket (tn, title, create_time_unix, type_id, queue_id, ticket_lock_id,
                user_id, responsible_user_id, ticket_priority_id, ticket_state_id,
                escalation_time, escalation_update_time, escalation_response_time,
                escalation_solution_time, timeout, service_id, sla_id, until_time,
                archive_flag, create_time, create_by, change_time, change_by)
            VALUES (:p1, :p2, :p3, :p4, :p5, :p6, :<*>p7, :p8, :p9, :p10, 0, 0, 0, 0, 0, :p11, :p12, 0, :p13,

. Please advice me to debug or how to solve this problem

P.S Finally i update to last version 4.0.12(from 4.0.3) and ITSM::Bundle now works.

[jojo]

what is your OTRS version?

[naimson]

what is your OTRS version?

4.0.3
Sorry for it is not in initial post

[jojo]

please update to latest patchlevel. Also the syntax would be <OTRS_DynamicField_Name>

[naimson]

please update to latest patchlevel. Also the syntax would be <OTRS_DynamicField_Name>

So,according my case i need to write OTRS_DynamicField_custnumber , or different ?

[jojo]

<OTRS_TICKET_DynamicField_custnumber>

[naimson]

<OTRS_TICKET_DynamicField_custnumber>

Unfortunately it is don't work . Maybe you can tell me a module where this dynamicfield values are passed to transition block ,where i can add some Data::Dumper/Trace there to view values ?

Also maybe it is relevant with this case - viewtopic.php?t=27720 ?

[jojo]

did you check spellings?

[jojo]

Code: Select all

 TransitionAction-a0fc101c4a783836db9985e700b1bca2:
    ChangeTime: 2015-09-02 16:52:57
    Config:
      Config:
        ArticleType: phone
        Body: <OTRS_TICKET_DynamicField_TaskDescription>
        ContentType: text/plain; charset=UTF8
        CustomerID: ''
        CustomerUser: ''
        DynamicField_Event: <OTRS_TICKET_DynamicField_Event>
        HistoryComment: Created new task for incident
        HistoryType: AddNote
        LinkAs: Child
        Lock: unlock
        OwnerID: '1'
        Priority: 3 normal
        Queue: <OTRS_TICKET_DynamicField_TaskOwner>
        SenderType: agent
        State: new
        Subject: <OTRS_TICKET_DynamicField_TaskShortDescription>
        Title: <OTRS_TICKET_DynamicField_TaskShortDescription>
        Type: Task
      Module: Kernel::System::ProcessManagement::TransitionAction::TicketCreate
    CreateTime: 2015-09-01 13:44:23
    EntityID: TransitionAction-a0fc101c4a783836db9985e700b1bca5
    ID: '4'
    Name: Create Task Ticket

[naimson]

Code: Select all

 TransitionAction-a0fc101c4a783836db9985e700b1bca2:
    ChangeTime: 2015-09-02 16:52:57
    Config:
      Config:
        ArticleType: phone
        Body: <OTRS_TICKET_DynamicField_TaskDescription>
        ContentType: text/plain; charset=UTF8
        CustomerID: ''
        CustomerUser: ''
        DynamicField_Event: <OTRS_TICKET_DynamicField_Event>
        HistoryComment: Created new task for incident
        HistoryType: AddNote
        LinkAs: Child
        Lock: unlock
        OwnerID: '1'
        Priority: 3 normal
        Queue: <OTRS_TICKET_DynamicField_TaskOwner>
        SenderType: agent
        State: new
        Subject: <OTRS_TICKET_DynamicField_TaskShortDescription>
        Title: <OTRS_TICKET_DynamicField_TaskShortDescription>
        Type: Task
      Module: Kernel::System::ProcessManagement::TransitionAction::TicketCreate
    CreateTime: 2015-09-01 13:44:23
    EntityID: TransitionAction-a0fc101c4a783836db9985e700b1bca5
    ID: '4'
    Name: Create Task Ticket

Great thanks all is work