Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

Not applicable

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;

1 Reply
danielrozental
Honored Contributor II

Re: Navision error ORA-01841

You are probably trying to pass a date by parameter by missing something. If you post your script we might be able to help you further.

Check this post.

http://www.dbmotive.com/ora-01841-full-year-must-be-between-4713-and-9999-and-not-be-0/

Community Browser