V12.1 OneInstaller check_privileges.sql case sensitive discrepancy
Article ID: 87512
Updated On:
Products
CA Automic Workload Automation - Automation Engine
AUTOMIC WORKLOAD AUTOMATION
Issue/Introduction
Error Message :
U00029108 UCUDB: SQL_ERROR Database handles DB-HENV: 7b5b70 DB-HDBC: 7b6f60
U00003591 UCUDB - DB error info: OPC: 'SQLExecDirect' Return code: 'ERROR'
U00003592 UCUDB - Status: '42S02' Native error: '3701' Msg: 'Cannot drop the procedure 'UC_TEST_Proc', because it does not exist or you do not have permission.'
U00003594 UCUDB Ret: '3590' opcode: 'EXEC' SQL Stmnt: '
U00038068 ABORTING due to error.
The loading process was terminated abnormally. The Database might be in an inconsistent condition. Please contact Automic Support.
The file, check_privileges.sql (location: ...\Automic.Workload.Automation_12.1.0_2017-09-29\Automation.Platform\db\sql_9\12.1), has a case sensitive discrepancy.
The DROP procedure has the "UC_TEST" all in uppercase while the CREATE procedure has it as "UC_Test".
Excerpt:
U00029108 UCUDB: SQL_ERROR Database handles DB-HENV: 7b5b70 DB-HDBC: 7b6f60
U00003591 UCUDB - DB error info: OPC: 'SQLExecDirect' Return code: 'ERROR'
U00003592 UCUDB - Status: '42S02' Native error: '3701' Msg: 'Cannot drop the procedure 'UC_TEST_Proc', because it does not exist or you do not have permission.'
U00003594 UCUDB Ret: '3590' opcode: 'EXEC' SQL Stmnt: '
U00038068 ABORTING due to error.
The loading process was terminated abnormally. The Database might be in an inconsistent condition. Please contact Automic Support.
The file, check_privileges.sql (location: ...\Automic.Workload.Automation_12.1.0_2017-09-29\Automation.Platform\db\sql_9\12.1), has a case sensitive discrepancy.
The DROP procedure has the "UC_TEST" all in uppercase while the CREATE procedure has it as "UC_Test".
Excerpt:
-- Procedure
CREATE PROCEDURE UC_Test_Proc (@text as varchar(20))
WITH EXECUTE AS SELF
as
select @text
GO
EXEC UC_Test_Proc 'testest'
GO
-- Clean up
DROP PROCEDURE UC_TEST_Proc
CREATE PROCEDURE UC_Test_Proc (@text as varchar(20))
WITH EXECUTE AS SELF
as
select @text
GO
EXEC UC_Test_Proc 'testest'
GO
-- Clean up
DROP PROCEDURE UC_TEST_Proc
Cause
Cause type:
By design
Root Cause: N/A
By design
Root Cause: N/A
Environment
OS Version: N/A
Resolution
This is not a bug. It is the intended behavior. Case sensitive databases on MS SQL server is not supported. The script checks the case sensitivity at the installing point rather than afterwards.
Fix Status: No Fix
Fix Version(s):
N/A
Fix Status: No Fix
Fix Version(s):
N/A
Additional Information
Workaround :
N/A
N/A
Feedback
Yes
No
Powered by
