Troubleshooting
Problem
CREATE_WAVE_SHIP_GROUP agent server throws ORA-1841 while creating wave
Symptom
teps to simulate:
------------------
1) Configure the routing
guide to assin Service to shipments
2) Create a shipment without a
Service and run ROUTE_SHIPMETN agent to assign Service(Carrier info) to
shipment
3) Rung the CREATE_WAVE_SHIP_GROUP agent to include this
shipment to a wave
4) System will throw below error:
Expectations
------------
System should not throw error and should
have included the shipment into the wave
[2010-03-10 11:09:56.312] ERRORDTL 2010-03-10
11:09:56,265:ERRORDTL:Thread-10_CREATE_WAVE_SHIP_GROUP: [1268237396218]
<Errors>
<Error
ErrorCode="ORA-1841"
ErrorRelatedMoreInfo=""
ErrorUniqueExceptionId="10.10.30.14212682373957650000000000003">
<Attribute Name="ErrorCode" Value="ORA-1841"/>
<Attribute
Name="ErrorDescription" Value="ORA-01841: (full) year must be between -4713 and
+9999, and not be 0
"/>
<Attribute Name="SQLState" Value="22008"/>
<Attribute Name="TransactionIsolationLevel" Value="2"/>
<Attribute
Name="SQLStatement" Value="Prepared Statement - SELECT /*YANTRA*/
YFS_SHIPMENT_GROUP.* FROM YFS_SHIPMENT_GROUP YFS_SHIPMENT_GROUP WHERE NODE_KEY
= 'KNODE' AND SHIPMENT_GROUP_ID = 'LTL-SHIP' AND EFFECTIVE_DATE_FROM <=
'SYSDATE' AND EFFECTIVE_DATE_TO >= 'SYSDATE' ORDER BY SEQ_NO, SHIPMENT_GROUP_ID
"/>
<Attribute Name="DBErrorCode" Value="1841"/>
<Error
ErrorCode="java.sql.SQLException" ErrorDescription=""
ErrorRelatedMoreInfo="ORA-01841: (full) year must be between -4713 and +9999,
and not be 0
">
<Stack>java.sql.SQLException: ORA-01841: (full) year
must be between -4713 and +9999, and not be 0
Resolving The Problem
Fixed in 9.0 HF7
Historical Number
NFX10550
Product Synonym
[<p><b>]Escalation ID[</b><p>];223522;[<p><b>]Severity[</b><p>];Normal;[<p><b>]Type[</b><p>];NormalFix
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21560439