Help on error code -7454: DateTime field overflow.

UDA
Enthusiast

Help on error code -7454: DateTime field overflow.

I am able to run the below query in production, but when I run it in the test system i am getting this error
7454: DateTime field overflow.
Any idea which environment variable needs to be changed to resolve this issue?

INSERT INTO SERVICE_ASSURANCE.TCTD425_NTWK_JOB_PRD_TST
(ASGND_PROD_CTLG_ITEM_ID /* CHAR(10) */
,ASGND_PROD_ITEM_VER_NBR /* INTEGER */
,NTWK_JOB_ID /* CHAR(12) */
,NTWK_JOB_TYPE_CD) /* CHAR(1) */
VALUES ('ABCG',6,'ASCDEF','A' )
1 REPLY
Enthusiast

Re: Help on error code -7454: DateTime field overflow.

Hi,
Please check the data types of the table fields.
SERVICE_ASSURANCE.TCTD425_NTWK_JOB_PRD_TST

show table SERVICE_ASSURANCE.TCTD425_NTWK_JOB_PRD_TST

There might be data type date for any of the columns.

Regds,
Sachin