The synchronizeUserInformation Script Fails with: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended (Doc ID 3010644.1)

Last updated on MAY 16, 2024

Applies to:

Symptoms

Running the synchronizeUserInformation script fails with the following error when the user guid has binary value and the GUID contains a single quote character:


ERROR

Fore example, a GUID might look like this: N??DyJ??7?='?

Note we don't support binary GUIDs but you need to run the synchronizeUserInformation script to update the GUID once the GUIDs in the external LDAP have been fixed to return ASCII value.

STEPS

1. Run the following command to create a mapping file of users whose GUID has changed, that is, the GUID currently stored for a user in WebCenter Portal, does not match the GUID that is stored for the same user in the identity store.
   
   
   synchronizeUserInformation(appName='webcenter', operationType='RENAME_GUID_CREATE_MAPPING_FILE', fileName='GUIDMappingFile.properties', component='ALL', dbVendor='Oracle', dbHostNPort='<HOST:PORT>', dbName='<DATABASE_NAME>', dbSchemaName='<WEBCENTER_SCHEMA>',verbose='true')
    
   Provide the password for the webcenter schema when prompted.

   Review the generated GUIDMappingFile.properties file and confirm you see the users with GUID with single quotes.
   
   
   

2.  Run the following command to synchronize the user GUIDs.

    
   
   synchronizeUserInformation(appName='webcenter', operationType='RENAME_GUID_FROM_MAPPING_FILE', fileName='GUIDMappingFile.properties', component='ALL', dbVendor='Oracle', dbHostNPort='<HOST:PORT>', dbName='<DATABASE_NAME>', dbSchemaName='<WEBCENTER_SCHEMA>',verbose='true')
    
   Provide the password for the webcenter schema when prompted.

   When running the script you will see these errors for users with GUIDs with a single quote character:
   
   

   Update user <userid> in Spaces database from old guid <Current_User_GUID_with_Single_Quote> to new guid <New_User_GUID_in_ASCII>.

   Exception occurred while updating user <userid>[<Current_User_GUID_with_Single_Quote>].

   java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

    

Cause

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