While running the wp-configure-la-complete task on Portal 8.5 we get the following error in the ConfigTrace.log….CWWIM4521E

We are trying to configure a property extension database by following these instructions….

https://www.ibm.com/support/knowledgecenter/SSHRKX_8.5.0/mp/install/lookaside_db.html

However, the wp-configure-la-complete task fails with the following in the ConfigTrace.log…

[wplc-create-la-tables] Instance attributes (Set 1 of 1):
[wplc-create-la-tables] ignoreDuplicateIDs= *** NOT_SPECIFIED ***
[wplc-create-la-tables]
schemaLocation=”D:/IBM/WebSphere/wp_profile/ConfigEngine/config/work/was
/wim”
[wplc-create-la-tables] attribute=[
[wplc-create-la-tables] [ reportSqlError=”true” ]
[wplc-create-la-tables] [ dbAdminId=”my_User” ]
[wplc-create-la-tables] [
dbDriver=”com.microsoft.sqlserver.jdbc.SQLServerDriver” ]
[wplc-create-la-tables] [
laPropXML=”D:/IBM/WebSphere/AppServer/etc/wim/setup/wimlaproperties.xml”
]
[wplc-create-la-tables] [
derbySystemHome=”D:/IBM/WebSphere/wp_profile/PortalServer/derby” ]
[wplc-create-la-tables] [ dbAdminPassword=”PASSWORD_REMOVED” ], ]
[wplc-create-la-tables] customproperty=[ *** NONE_SPECIFIED *** ]
[wplc-create-la-tables] securityDomain= *** NOT_SPECIFIED ***
[wplc-create-la-tables]
dbURL=”jdbc:sqlserver://my_host:1433;SelectMethod=cursor;DatabaseName=my_database”
[wplc-create-la-tables] trimSpaces= *** NOT_SPECIFIED ***
[wplc-create-la-tables] databaseType=”sqlserver”
[wplc-create-la-tables] Result:
[com.ibm.websphere.wim.exception.WIMSystemException: CWWIM4521E The
‘The specified schema name “my_User” either does not exist or you do
not have permission to use it.’ SQL Exception occurred during
processing.]
Result: [com.ibm.websphere.wim.exception.WIMSystemException: CWWIM4521E
The ‘The specified schema name “my_User” either does not exist or you
do not have permission to use it.’ SQL Exception occurred during
processing.]
[wplc-create-la-tables]
com.ibm.websphere.wim.exception.WIMSystemException: CWWIM4521E The ‘The
specified schema name “my_User” either does not exist or you do not
have permission to use it.’ SQL Exception occurred during processing.
[wplc-create-la-tables] at
com.ibm.ws.wim.dao.schema.JDBCSqlImport.importFile(JDBCSqlImport.java:22
2)
[wplc-create-la-tables] at
com.ibm.ws.wim.dbsetup.DBSetup.readSQLFiles(DBSetup.java:935)
[wplc-create-la-tables] at
com.ibm.ws.wim.dbsetup.DBSetup.setupLA(DBSetup.java:743)

Related:

Leave a Reply