• State Not Answered
  • Locked Locked
  • Replies 5 replies
  • Subscribers 93 subscribers
  • Views 3513 views
  • Users 0 members are here
Options
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

[1777042] Error walking route

Tim Staddon
over 6 years ago
Hi - this is v7.1.2. See comment below.
Parents
  • 0 over 6 years ago

    Hi,

    I am getting the error "Datatype (Decimal) is not supported!" when trying to walk from one table to another in a target system but can't see what I'm doing wrong. The schema definitely includes both tables, and the target system MSSQL) has an integer field storing the FK to an autonumber UID column in another table, and referential integrity is in force.

    So Table 1 has an attribute table2_id where Table2.table2_id is the PK, and I want the description field from table 2.

    When I test it, I get this exception:

    [1777160] Property (vrtObj_EmployeeType@dbo.employee_master) could not read the value from system object (1000)!
        at VI.Projector.UI.ComponentModel.SystemObjectPropertyDescriptor.GetValue(Object component)
        at VI.Projector.Schema.SchemaProperty.GetValue(ISystemObject systemObject, SchemaPropertyGetValueOption option)
    [1777042] Error walking route (employee_type_id.employee_type_code)!
        at VI.Projector.Schema.SchemaProperty.GetValue(ISystemObject systemObject, SchemaPropertyGetValueOption option)
        at VI.Projector.Schema.SchemaWalker.get_Item(String route, Object defaultValue)
    Datatype (Decimal) is not supported!
        at VI.Projector.Schema.SchemaWalker.get_Item(String route, Object defaultValue)
        at VI.Projector.Schema.SchemaWalker.OnWalk(String[] route)

    I looked at using other methods, but couldn't find one that would give me the description.

Reply
  • 0 over 6 years ago

    Hi,

    I am getting the error "Datatype (Decimal) is not supported!" when trying to walk from one table to another in a target system but can't see what I'm doing wrong. The schema definitely includes both tables, and the target system MSSQL) has an integer field storing the FK to an autonumber UID column in another table, and referential integrity is in force.

    So Table 1 has an attribute table2_id where Table2.table2_id is the PK, and I want the description field from table 2.

    When I test it, I get this exception:

    [1777160] Property (vrtObj_EmployeeType@dbo.employee_master) could not read the value from system object (1000)!
        at VI.Projector.UI.ComponentModel.SystemObjectPropertyDescriptor.GetValue(Object component)
        at VI.Projector.Schema.SchemaProperty.GetValue(ISystemObject systemObject, SchemaPropertyGetValueOption option)
    [1777042] Error walking route (employee_type_id.employee_type_code)!
        at VI.Projector.Schema.SchemaProperty.GetValue(ISystemObject systemObject, SchemaPropertyGetValueOption option)
        at VI.Projector.Schema.SchemaWalker.get_Item(String route, Object defaultValue)
    Datatype (Decimal) is not supported!
        at VI.Projector.Schema.SchemaWalker.get_Item(String route, Object defaultValue)
        at VI.Projector.Schema.SchemaWalker.OnWalk(String[] route)

    I looked at using other methods, but couldn't find one that would give me the description.

Children
No Data