1 Reply Latest reply: Jan 7, 2013 8:15 AM by Daniel Rozental RSS

    Navision error ORA-01841

      i get follow error message

      SQL##f - SqlState: S1000, ErrorCode: 1841, ErrorMsg: [Oracle][ODBC][Ora]ORA-01841: (Heel) jaar moet liggen tussen -4713 en +9999, en mag niet 0 zijn.
      ORA-06512: in "REPORT_PROD.GET_XPS_ROAD_SHIFT", regel 10

      SQL SELECT *
      FROM "REPORT_PROD"."SN4_TRUCK_VISIT_STAGES"

      this is my script

       

      LOAD

       

      GKEY,
      "TRANSACTION_COUNT",
      STATUS,
      "TRUCK_LICENSE_NBR",
      "TRUCKING_COMPANY",
      "TRUCKING_COMPANY_NAME",
      "LINE_RCV",
      "LINE_DLV",
      SHIFT,
      "SHIFT_NAME",
      "TRUCK_ID",
      "DRIVER_CARD_ID",
      "DRIVER_NAME",
      "ENTERED_YARD",
      "EXITED_YARD",
      "SCALE_WEIGHT",
      CREATED,
      CREATOR,
      CHANGED,
      CHANGER,
      PRIORITY,
      "GOS_TV_KEY",
      "TRUCK_POSITION",
      "GATE_ID",
      "GATE_DESCRIPTION",
      "ENTRY_LANE_ID",
      "ENTRY_LANE_DESCRIPTION",
      "EXIT_LANE_ID",
      "EXIT_LANE_DESCRIPTION",
      "TROUBLE_LANE_ID",
      "TROUBLE_LANE_DESCRIPTION",
      "DRIVER_IS_HAZARD_LICENSED",
      "PRE_STAGE_STATUS",
      "EXCHANGE_AREA_NAME",
      "EXCHANGE_AREA_DESCRIPTION",
      "HAD_TROUBLE",
      "TURN_TIME",
      "DLV_FULL_COUNT",
      "RCV_FULL_COUNT",
      "DLV_MTY_COUNT",
      "RCV_MTY_COUNT",
      "TVSTAT_GKEY";

      SQL*

      From vrachtwagen;