My Oracle Support Banner

How to Run the Pointbase Console and then Run a SQL Script From Within the Pointbase Console (Doc ID 972427.1)

Last updated on JANUARY 23, 2025

Applies to:

Oracle WebLogic Portal - Version 9.2.0 to 10.3.2 [Release Weblogic Platform to AS10gR3]
Information in this document applies to any platform.

Goal

After creating a new WebLogic Portal (WLP) domain (using the PointBase Database ) from a domain template without running the SQLAuthenticator.sql script, the following exception is thrown when starting up the server. 

This document explains how to run the PointBase console and then run the SQLAuthenticator.sql script (or any other sql script) from within the console to initialize the SQLAuthenticator tables.

#### <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <> <1258762003720>

java.lang.AssertionError: java.lang.reflect.InvocationTargetException
at weblogic.descriptor.DescriptorManager$SecurityServiceImpl$SecurityProxy._invokeServiceMethod(DescriptorManager.java:175)

...

weblogic.security.internal.encryption.EncryptionServiceException: com.rsa.jsafe.JSAFE_PaddingException: Could not perform unpadding: invalid pad byte.
at weblogic.security.internal.encryption.JSafeEncryptionServiceImpl.decryptBytes(JSafeEncryptionServiceImpl.java:78)
at weblogic.security.internal.encryption.JSafeEncryptionServiceImpl.decryptString(JSafeEncryptionServiceImpl.java:94)
at weblogic.security.internal.encryption.ClearOrEncryptedService.decrypt(ClearOrEncryptedService.java:87)

...

com.rsa.jsafe.JSAFE_PaddingException: Could not perform unpadding: invalid pad byte.
at com.rsa.jsafe.JA_PKCS5Padding.a(Unknown Source)
at com.rsa.jsafe.JG_BlockCipher.decryptFinal(Unknown Source)
at weblogic.security.internal.encryption.JSafeEncryptionServiceImpl.decryptBytes(JSafeEncryptionServiceImpl.java:68)
at weblogic.security.internal.encryption.JSafeEncryptionServiceImpl.decryptString(JSafeEncryptionServiceImpl.java:94)
at weblogic.security.internal.encryption.ClearOrEncryptedService.decrypt(ClearOrEncryptedService.java:87)


Note: PointBase is only used up until WebLogic Portal (WLP) release 10.3.2.  After 10.3.2, the Derby Database is the demonstration Database that's shipped with WebLogic Portal (WLP).

Note: The SQLAuthenticator.sql script is used as an example here but the general process is for running any sql script or command.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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