Repexport - Warning: Null Value Is Eliminated By An Aggregate Or Other SET Operation.
(Doc ID 3057871.1)
Last updated on NOVEMBER 07, 2024
Applies to:
Siebel CRM - Version 24.6 and laterInformation in this document applies to any platform.
Goal
In one of the repexport log files from a migration package following SQL warning was logged in it. Can this warning be ignored?
2024-11-05 17:52:01 Process Name: Repository Import/Export Utility, Status: Started, Parameter: , Message
2024-11-05 17:52:01 SQL Warning, SQL State 01003, 8153, [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Warning: Null value is eliminated by an aggregate or other SET operation.
2024-11-05 17:52:01 SQL Statement:
SELECT MAX(T2.TBL_VER)
FROM
dbo.S_RR_OBJ_VER T1,
dbo.S_RR_OBJ_ITEM T2
WHERE T1.REPOSITORY_ID = '1-IZ0U-1'
AND T1.WS_ID = '1@1641131'
AND T1.LANG_CD = 'ALL'
AND T1.ROW_ID = T2.RR_OBJ_VER_ID
AND (T2.TYPE_CD IN ('Table', 'Assignment Criteria', 'Assignment Attribute') OR (T2.TYPE_CD = 'Stream' AND T2.NAME = 'EXTN_STREAM'));
2024-11-05 17:52:01 [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Warning: Null value is eliminated by an aggregate or other SET operation.
Solution
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
| Goal |
| Solution |