PostInstallDBSetup Utility Fails With "permission was denied" Errors.
(Doc ID 3029227.1)
Last updated on JUNE 18, 2024
Applies to:
Siebel CRM - Version 17.0 [IP2017] and laterMicrosoft Windows x64 (64-bit)
Symptoms
PostInstallDBSetup utility fails with several "permission was denied" Errors. Here is an example from insert_db_log.log.
INSERT INTO dbo.S_UPG_REL_LOG ( ROW_ID,PAR_ROW_ID , SEQ_NUM , LOG_CMD,CREATED_BY,LAST_UPD_BY,LOG_DT)
VALUES ('1@1704251','1@17014',49,'Log for Summary Data generation Completed','0-1','0-1',getdate())
ODBC error 42000 in SQLExecDirect:
[Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT permission was denied on the object 'S_UPG_REL_LOG', database 'siebeldb', schema 'dbo'.
(native error 229).
The issue can be reproduced under the conditions below.
1. Siebel Server Database runs on SQL Server.
2. Integrated Windows authentication is selected for the ODBC Data Source.
Changes
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 |
Changes |
Cause |
Solution |