Repository Export Fails with Error " [SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value"
(Doc ID 2990095.1)
Last updated on JUNE 12, 2024
Applies to:
Siebel CRM - Version 23.1 and laterInformation in this document applies to any platform.
Symptoms
When attempting to perform incremental migration from DEV to PROD environment, an error occurs during repository export.
Error in repexport_XXXX.log:
SELECT COUNT(*) FROM dbo.S_DOCK_OBJECT TBL1
WHERE TBL1.REPOSITORY_ID ='1-1-1'
AND TBL1.DB_LAST_UPD BETWEEN CONVERT(datetime,'2023-11-21 12.41.49') AND CONVERT(datetime,'2023-11-23 08:23:39.260')
2023-11-23 09:23:39 [Microsoft][SQL Server Native Client 11.0][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
2023-11-23 09:23:39 22008: [Microsoft][SQL Server Native Client 11.0][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
2023-11-23 09:23:39 SQL Statement:
SELECT COUNT(*) FROM dbo.S_DOCK_OBJECT TBL1
WHERE TBL1.REPOSITORY_ID ='1-1-1'
AND TBL1.DB_LAST_UPD BETWEEN CONVERT(datetime,'2023-11-21 12.41.49') AND CONVERT(datetime,'2023-11-23 08:23:39.260')
2023-11-23 09:23:39 [Microsoft][SQL Server Native Client 11.0][SQL Server]The cursor was not declared.
2023-11-23 09:23:39 37000: [Microsoft][SQL Server Native Client 11.0][SQL Server]The cursor was not declared.
2023-11-23 09:23:39 Failed to fetch records
2023-11-23 09:23:39 Error getting modfied objects from C:\fs\migration\1-18VGF\dat\repexport_3A0D4D6A995E.dat.
2023-11-23 09:23:39 Failed to identify delta for design time data.
2023-11-23 09:23:39 Error in Preparing Where Clause for Incremental D2P
2023-11-23 09:23:39 Error in doExport (<null>).
2023-11-23 09:23:39 Error in Main function...
WHERE TBL1.REPOSITORY_ID ='1-1-1'
AND TBL1.DB_LAST_UPD BETWEEN CONVERT(datetime,'2023-11-21 12.41.49') AND CONVERT(datetime,'2023-11-23 08:23:39.260')
2023-11-23 09:23:39 [Microsoft][SQL Server Native Client 11.0][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
2023-11-23 09:23:39 22008: [Microsoft][SQL Server Native Client 11.0][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
2023-11-23 09:23:39 SQL Statement:
SELECT COUNT(*) FROM dbo.S_DOCK_OBJECT TBL1
WHERE TBL1.REPOSITORY_ID ='1-1-1'
AND TBL1.DB_LAST_UPD BETWEEN CONVERT(datetime,'2023-11-21 12.41.49') AND CONVERT(datetime,'2023-11-23 08:23:39.260')
2023-11-23 09:23:39 [Microsoft][SQL Server Native Client 11.0][SQL Server]The cursor was not declared.
2023-11-23 09:23:39 37000: [Microsoft][SQL Server Native Client 11.0][SQL Server]The cursor was not declared.
2023-11-23 09:23:39 Failed to fetch records
2023-11-23 09:23:39 Error getting modfied objects from C:\fs\migration\1-18VGF\dat\repexport_3A0D4D6A995E.dat.
2023-11-23 09:23:39 Failed to identify delta for design time data.
2023-11-23 09:23:39 Error in Preparing Where Clause for Incremental D2P
2023-11-23 09:23:39 Error in doExport (<null>).
2023-11-23 09:23:39 Error in Main function...
Also in seedexport_XXXX.log:
023-11-23 09:23:39 SQL Statement:
select t.*, s.NAME as T_ORGNAME from dbo.S_LST_OF_VAL t LEFT OUTER JOIN dbo.S_BU s ON t.BU_ID=s.ROW_ID WHERE t.WS_ID='1@82741' AND t.DB_LAST_UPD BETWEEN CONVERT(datetime,'2023-11-21 12.41.49') AND CONVERT(datetime,'2023-11-23 08:23:39.653')
2023-11-23 09:23:39 [Microsoft][SQL Server Native Client 11.0][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
2023-11-23 09:23:39 22008: [Microsoft][SQL Server Native Client 11.0][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
2023-11-23 09:23:39 SQL Statement:
select t.*, s.NAME as T_ORGNAME from dbo.S_LST_OF_VAL t LEFT OUTER JOIN dbo.S_BU s ON t.BU_ID=s.ROW_ID WHERE t.WS_ID='1@82741' AND t.DB_LAST_UPD BETWEEN CONVERT(datetime,'2023-11-21 12.41.49') AND CONVERT(datetime,'2023-11-23 08:23:39.653')
2023-11-23 09:23:39 [Microsoft][SQL Server Native Client 11.0][SQL Server]The cursor was not declared.
2023-11-23 09:23:39 37000: [Microsoft][SQL Server Native Client 11.0][SQL Server]The cursor was not declared.
2023-11-23 09:23:39 DATAEXP-ERR-1112: Unable to export sql "select t.*, s.NAME as T_ORGNAME from dbo.S_LST_OF_VAL t LEFT OUTER JOIN dbo.S_BU s ON t.BU_ID=s.ROW_ID WHERE t.WS_ID='1@82741' AND t.DB_LAST_UPD BETWEEN CONVERT(datetime,'2023-11-21 12.41.49') AND CONVERT(datetime,'2023-11-23 08:23:39.653')" (UTLOdbcExecDirect).
2023-11-23 09:23:39 DATAEXP-ERR-1103: Unable to export table "S_LST_OF_VAL" (UTLDataExportSql).
2023-11-23 09:23:39
2023-11-23 09:23:39 WARNING: Unable to export table to file.
select t.*, s.NAME as T_ORGNAME from dbo.S_LST_OF_VAL t LEFT OUTER JOIN dbo.S_BU s ON t.BU_ID=s.ROW_ID WHERE t.WS_ID='1@82741' AND t.DB_LAST_UPD BETWEEN CONVERT(datetime,'2023-11-21 12.41.49') AND CONVERT(datetime,'2023-11-23 08:23:39.653')
2023-11-23 09:23:39 [Microsoft][SQL Server Native Client 11.0][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
2023-11-23 09:23:39 22008: [Microsoft][SQL Server Native Client 11.0][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.
2023-11-23 09:23:39 SQL Statement:
select t.*, s.NAME as T_ORGNAME from dbo.S_LST_OF_VAL t LEFT OUTER JOIN dbo.S_BU s ON t.BU_ID=s.ROW_ID WHERE t.WS_ID='1@82741' AND t.DB_LAST_UPD BETWEEN CONVERT(datetime,'2023-11-21 12.41.49') AND CONVERT(datetime,'2023-11-23 08:23:39.653')
2023-11-23 09:23:39 [Microsoft][SQL Server Native Client 11.0][SQL Server]The cursor was not declared.
2023-11-23 09:23:39 37000: [Microsoft][SQL Server Native Client 11.0][SQL Server]The cursor was not declared.
2023-11-23 09:23:39 DATAEXP-ERR-1112: Unable to export sql "select t.*, s.NAME as T_ORGNAME from dbo.S_LST_OF_VAL t LEFT OUTER JOIN dbo.S_BU s ON t.BU_ID=s.ROW_ID WHERE t.WS_ID='1@82741' AND t.DB_LAST_UPD BETWEEN CONVERT(datetime,'2023-11-21 12.41.49') AND CONVERT(datetime,'2023-11-23 08:23:39.653')" (UTLOdbcExecDirect).
2023-11-23 09:23:39 DATAEXP-ERR-1103: Unable to export table "S_LST_OF_VAL" (UTLDataExportSql).
2023-11-23 09:23:39
2023-11-23 09:23:39 WARNING: Unable to export table to file.
The issue can be reproduced at will with the following steps:
1. Perform initial full migration successfully.
2. Perform changes on Source environment.
3. Perform incremental migration.
4. Migration fails during export.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |