search cancel

Error: Error while trying to prepare statement in Policy Server

book

Article ID: 242921

calendar_today

Updated On:

Products

SITEMINDER

Issue/Introduction

 

When running Policy Server, when this one authorizes the user, the user cannot get authorized and Policy Server reports an error:    

  Error while trying to prepare statement

  as :

    [Start of call HasRelationship.][SmDsUser.cpp:903][5236][12544][02/23/2022][13:28:18]
    [13:28:18.725][CSmDsUser::ResolvePolicyObject][][][][][][][][][][][][][][][][][][][]
    [][][][][][][][][][][][][][][][][][][][][][][][][][][][][]
  [Policy resolution for user: 'myUser', filter: 'SelectUserAuth 'select ''%s'' from ''%s'''',
    type: 2, recursive: No][][][][][][][][][]

    [Error while trying to prepare statement ''][SmDsOdbcProvider.cpp:1105][5236][12544]
    [02/23/2022][13:28:18][13:28:18.725][SmDsOdbcProvider::Search][][][][][][][][][][][][]
    [][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][]
    [][][][]

    [Leave function CSmDsUser::ResolvePolicyObject][SmDsUser.cpp:919][5236][12544]
    [02/23/2022][13:28:18][13:28:18.725][CSmDsUser::ResolvePolicyObject]
    [No policy binding found][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][]
    [][][][][][][][][][][][][][][][][][][][][][][][][][00:00:00.000000][]

    [Policy is not applicable. Skipped.][SmAuthorization.cpp:1726][5236][12544]
    [02/23/2022][13:28:18][13:28:18.725][CSmAz::IsOk][][][][myAgent][]
    [myPolicyAccept][myOnAuthAccept][][][][][][][][][][][]
    [][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][]

    [IsOk? No.][SmAuthorization.cpp:1854][5236][12544][02/23/2022][13:28:18][13:28:18.725]
    [CSmAz::IsOk][][][][][][][][][][][][][][][No applicable Policy found. ][][][][][][][]
    [][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][][]

The SQL statement is a call to a Stored Procedure that uses a double single quote as:

   SelectUserAuth 'select ''%s'' from ''%s'''

 

Environment

 

  - Policy Server 12.8SP6;

Resolution

 

Upgrade Policy Server to 12.8SP7 when it will available to fix this issue.