My Oracle Support Banner

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 later
Microsoft 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.