Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE
robben69
New Member.
1143 views

Copying default values to customer 1 failed

Hi;

 

I am new on HP BSM. I want to setup HP BSM 9.26 but see this error message. What can I do? 

 

"Event databaase or user schema configuration completed succesfully"  after this add a screen. 

0 Likes
5 Replies
Micro Focus Expert
Micro Focus Expert

Re: Copying default values to customer 1 failed

Hi robben69,

the error
Event Schema - Event Database Creation Error
  Copying default values to customer 1 failed.
occurs when executing the Configuration Wizard to create a new set of databases, correct?
Can you please provide
- the BSM version
- the server deployment (for example 1 GW and 1 x DPS or alike)
- the OS BSM runs on
- the DB type and version
- the logfile covering the error (if the output s from the Configuration Wizard, the files would sit in \log\configserver)

Greetings
Siggi

Customer Support
Micro Focus

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
0 Likes
Pavithran_vig Absent Member.
Absent Member.

Re: Copying default values to customer 1 failed

Hello Siggl,

  This vignesh, we too face the same issue.

 BSM version - 9.26

 OS version - Windows server 2008 64 bit

 Deployment - 1 GW and 1 DPS

DB type - SQL server 2008 '

Log file - 
2016-02-09 12:21:13,342 [pool-2-thread-8] (JDBCExceptionReporter.java:101) ERROR - [Mercury][SQLServer JDBC Driver][SQLServer]Invalid object name 'C000_STEP_DEFINITION'.
2016-02-09 12:21:13,342 [pool-2-thread-8] (JDBCExceptionReporter.java:101) ERROR - [Mercury][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
2016-02-09 12:21:13,342 [pool-2-thread-8] (CreateDatabase.java:115) ERROR - Caught an exception! Copying default values to customer 1 failed.: could not execute query -- [Mercury][SQLServer JDBC Driver][SQLServer]Invalid object name 'C000_STEP_DEFINITION'.
2016-02-09 12:21:13,342 [pool-2-thread-8] (JavaTask.java:80) INFO - Finished java task: com.hp.opr.configuration.tasks.CreateDatabase. Execution result: failure
2016-02-09 12:21:13,342 [pool-2-thread-8] (NavigationRules.java:57) INFO - navigationValue = failure
2016-02-09 12:21:13,342 [pool-2-thread-8] (Step.java:106) INFO - *** Step opr-createDefaultValues was executed. Execution result : failure. Next step is: opr-showDbCreationError
2016-02-09 12:21:13,342 [pool-2-thread-8] (FlowManager.java:229) INFO - last_wait_step: opr-showDbCreationError
2016-02-09 12:25:03,598 [pool-2-thread-9] (Step.java:74) INFO - *** Executing step: opr-showDbCreationError
2016-02-09 12:25:03,598 [pool-2-thread-9] (NavigationRules.java:57) INFO - navigationValue = next
2016-02-09 12:25:03,598 [pool-2-thread-9] (Step.java:106) INFO - *** Step opr-showDbCreationError was executed. Execution result : success. Next step is: opr-db-type
2016-02-09 12:25:03,598 [pool-2-thread-9] (FlowManager.java:229) INFO - last_wait_step: opr-db-type
2016-02-09 12:25:05,926 [pool-2-thread-9] (Step.java:74) INFO - *** Executing step: opr-db-type
2016-02-09 12:25:05,926 [pool-2-thread-9] (NavigationRules.java:57) INFO - navigationValue = next
2016-02-09 12:25:05,926 [pool-2-thread-9] (Step.java:106) INFO - *** Step opr-db-type was executed. Execution result : success. Next step is: opr-credentials
2016-02-09 12:25:05,926 [pool-2-thread-9] (Step.java:74) INFO - *** Executing step: opr-credentials
2016-02-09 12:25:05,926 [pool-2-thread-9] (NavigationRules.java:57) INFO - navigationValue = SQL Server
2016-02-09 12:25:05,926 [pool-2-thread-9] (Step.java:106) INFO - *** Step opr-credentials was executed. Execution result : success. Next step is: opr-msSql-credentials
2016-02-09 12:25:05,926 [pool-2-thread-9] (FlowManager.java:229) INFO - last_wait_step: opr-msSql-credentials
2016-02-09 12:25:35,239 [pool-2-thread-9] (Step.java:74) INFO - *** Executing step: opr-msSql-credentials
2016-02-09 12:25:35,239 [pool-2-thread-9] (NavigationRules.java:57) INFO - navigationValue = next
2016-02-09 12:25:35,239 [pool-2-thread-9] (Step.java:106) INFO - *** Step opr-msSql-credentials was executed. Execution result : success. Next step is: opr-msSql-opr-db
2016-02-09 12:25:35,239 [pool-2-thread-9] (Step.java:74) INFO - *** Executing step: opr-msSql-opr-db
2016-02-09 12:25:35,239 [pool-2-thread-9] (NavigationRules.java:57) INFO - navigationValue = connect
2016-02-09 12:25:35,239 [pool-2-thread-9] (Step.java:106) INFO - *** Step opr-msSql-opr-db was executed. Execution result : success. Next step is: opr-msSql-connect-opr-db
2016-02-09 12:25:35,239 [pool-2-thread-9] (Step.java:74) INFO - *** Executing step: opr-msSql-connect-opr-db
2016-02-09 12:25:35,239 [pool-2-thread-9] (JavaTask.java:68) INFO - Start java task: com.mercury.infra.configserver.fm.tasks.CheckDbConnectionTask
2016-02-09 12:25:35,255 [pool-2-thread-9] (GenericDatabaseConnectorImpl.java:22) INFO - Successfully connected into the database dbType=(SQL Server); hostName=pmichlausql35.pmintl.net; dbName=BSM_OMI; userName=; server=pmichlausql35.pmintl.net; sid=; port=49500
2016-02-09 12:25:35,270 [pool-2-thread-9] (JavaTask.java:80) INFO - Finished java task: com.mercury.infra.configserver.fm.tasks.CheckDbConnectionTask. Execution result: success
2016-02-09 12:25:35,270 [pool-2-thread-9] (JavaTask.java:68) INFO - Start java task: com.mercury.infra.configserver.fm.tasks.RegisterDbContextTask
2016-02-09 12:25:35,270 [pool-2-thread-9] (RegisterDbContextTask.java:32) INFO - Loading the DbContext using com.hp.opr.configuration.OprDBInfo
2016-02-09 12:25:35,270 [pool-2-thread-9] (DBPropertiesManager.java:104) INFO - Trying to initialize Properties Manager
2016-02-09 12:25:35,270 [pool-2-thread-9] (DBPropertiesManager.java:108) INFO - Finished initializing Properties Manager with DB type:SQL Server
2016-02-09 12:25:35,270 [pool-2-thread-9] (DBPropertiesManager.java:456) INFO - Trying to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:35,286 [pool-2-thread-9] (DBPropertiesManager.java:466) INFO - Failed to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:36,333 [pool-2-thread-9] (DBPropertiesManager.java:104) INFO - Trying to initialize Properties Manager
2016-02-09 12:25:36,348 [pool-2-thread-9] (DBPropertiesManager.java:108) INFO - Finished initializing Properties Manager with DB type:SQL Server
2016-02-09 12:25:36,348 [pool-2-thread-9] (DBPropertiesManager.java:456) INFO - Trying to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:36,348 [pool-2-thread-9] (DBPropertiesManager.java:466) INFO - Failed to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:37,395 [pool-2-thread-9] (DBPropertiesManager.java:104) INFO - Trying to initialize Properties Manager
2016-02-09 12:25:37,395 [pool-2-thread-9] (DBPropertiesManager.java:108) INFO - Finished initializing Properties Manager with DB type:SQL Server
2016-02-09 12:25:37,395 [pool-2-thread-9] (DBPropertiesManager.java:456) INFO - Trying to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:37,395 [pool-2-thread-9] (DBPropertiesManager.java:466) INFO - Failed to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:38,458 [pool-2-thread-9] (DBPropertiesManager.java:104) INFO - Trying to initialize Properties Manager
2016-02-09 12:25:38,458 [pool-2-thread-9] (DBPropertiesManager.java:108) INFO - Finished initializing Properties Manager with DB type:SQL Server
2016-02-09 12:25:38,458 [pool-2-thread-9] (DBPropertiesManager.java:456) INFO - Trying to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:38,458 [pool-2-thread-9] (DBPropertiesManager.java:466) INFO - Failed to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:39,520 [pool-2-thread-9] (DBPropertiesManager.java:104) INFO - Trying to initialize Properties Manager
2016-02-09 12:25:39,536 [pool-2-thread-9] (DBPropertiesManager.java:108) INFO - Finished initializing Properties Manager with DB type:SQL Server
2016-02-09 12:25:39,536 [pool-2-thread-9] (DBPropertiesManager.java:456) INFO - Trying to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:39,536 [pool-2-thread-9] (DBPropertiesManager.java:466) INFO - Failed to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:40,583 [pool-2-thread-9] (DBPropertiesManager.java:104) INFO - Trying to initialize Properties Manager
2016-02-09 12:25:40,583 [pool-2-thread-9] (DBPropertiesManager.java:108) INFO - Finished initializing Properties Manager with DB type:SQL Server
2016-02-09 12:25:40,583 [pool-2-thread-9] (DBPropertiesManager.java:456) INFO - Trying to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:40,583 [pool-2-thread-9] (DBPropertiesManager.java:466) INFO - Failed to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:41,645 [pool-2-thread-9] (DBPropertiesManager.java:104) INFO - Trying to initialize Properties Manager
2016-02-09 12:25:41,645 [pool-2-thread-9] (DBPropertiesManager.java:108) INFO - Finished initializing Properties Manager with DB type:SQL Server
2016-02-09 12:25:41,645 [pool-2-thread-9] (DBPropertiesManager.java:456) INFO - Trying to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:41,645 [pool-2-thread-9] (DBPropertiesManager.java:466) INFO - Failed to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:42,661 [pool-2-thread-9] (JavaTask.java:80) INFO - Finished java task: com.mercury.infra.configserver.fm.tasks.RegisterDbContextTask. Execution result: success
2016-02-09 12:25:42,661 [pool-2-thread-9] (NavigationRules.java:57) INFO - navigationValue = success
2016-02-09 12:25:42,661 [pool-2-thread-9] (Step.java:106) INFO - *** Step opr-msSql-connect-opr-db was executed. Execution result : success. Next step is: opr-result
2016-02-09 12:25:42,661 [pool-2-thread-9] (FlowManager.java:229) INFO - last_wait_step: opr-result
2016-02-09 12:25:47,067 [pool-2-thread-9] (Step.java:74) INFO - *** Executing step: opr-result
2016-02-09 12:25:47,067 [pool-2-thread-9] (NavigationRules.java:57) INFO - navigationValue = next
2016-02-09 12:25:47,067 [pool-2-thread-9] (Step.java:106) INFO - *** Step opr-result was executed. Execution result : success. Next step is: opr-persist_opr_settings
2016-02-09 12:25:47,067 [pool-2-thread-9] (Step.java:74) INFO - *** Executing step: opr-persist_opr_settings
2016-02-09 12:25:47,067 [pool-2-thread-9] (JavaTask.java:68) INFO - Start java task: com.mercury.infra.configserver.fm.tasks.RegisterDbContextTask
2016-02-09 12:25:47,067 [pool-2-thread-9] (RegisterDbContextTask.java:32) INFO - Loading the DbContext using com.hp.opr.configuration.OprDBInfo
2016-02-09 12:25:47,114 [pool-2-thread-9] (DBPropertiesManager.java:104) INFO - Trying to initialize Properties Manager
2016-02-09 12:25:47,114 [pool-2-thread-9] (DBPropertiesManager.java:108) INFO - Finished initializing Properties Manager with DB type:SQL Server
2016-02-09 12:25:47,130 [pool-2-thread-9] (DBPropertiesManager.java:456) INFO - Trying to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:47,130 [pool-2-thread-9] (DBPropertiesManager.java:466) INFO - Failed to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:48,193 [pool-2-thread-9] (DBPropertiesManager.java:104) INFO - Trying to initialize Properties Manager
2016-02-09 12:25:48,208 [pool-2-thread-9] (DBPropertiesManager.java:108) INFO - Finished initializing Properties Manager with DB type:SQL Server
2016-02-09 12:25:48,208 [pool-2-thread-9] (DBPropertiesManager.java:456) INFO - Trying to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:48,208 [pool-2-thread-9] (DBPropertiesManager.java:466) INFO - Failed to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:49,271 [pool-2-thread-9] (DBPropertiesManager.java:104) INFO - Trying to initialize Properties Manager
2016-02-09 12:25:49,271 [pool-2-thread-9] (DBPropertiesManager.java:108) INFO - Finished initializing Properties Manager with DB type:SQL Server
2016-02-09 12:25:49,271 [pool-2-thread-9] (DBPropertiesManager.java:456) INFO - Trying to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:49,271 [pool-2-thread-9] (DBPropertiesManager.java:466) INFO - Failed to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:50,349 [pool-2-thread-9] (DBPropertiesManager.java:104) INFO - Trying to initialize Properties Manager
2016-02-09 12:25:50,349 [pool-2-thread-9] (DBPropertiesManager.java:108) INFO - Finished initializing Properties Manager with DB type:SQL Server
2016-02-09 12:25:50,349 [pool-2-thread-9] (DBPropertiesManager.java:456) INFO - Trying to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:50,349 [pool-2-thread-9] (DBPropertiesManager.java:466) INFO - Failed to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:51,411 [pool-2-thread-9] (DBPropertiesManager.java:104) INFO - Trying to initialize Properties Manager
2016-02-09 12:25:51,411 [pool-2-thread-9] (DBPropertiesManager.java:108) INFO - Finished initializing Properties Manager with DB type:SQL Server
2016-02-09 12:25:51,411 [pool-2-thread-9] (DBPropertiesManager.java:456) INFO - Trying to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:51,411 [pool-2-thread-9] (DBPropertiesManager.java:466) INFO - Failed to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:52,474 [pool-2-thread-9] (DBPropertiesManager.java:104) INFO - Trying to initialize Properties Manager
2016-02-09 12:25:52,474 [pool-2-thread-9] (DBPropertiesManager.java:108) INFO - Finished initializing Properties Manager with DB type:SQL Server
2016-02-09 12:25:52,474 [pool-2-thread-9] (DBPropertiesManager.java:456) INFO - Trying to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:52,474 [pool-2-thread-9] (DBPropertiesManager.java:466) INFO - Failed to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:53,536 [pool-2-thread-9] (DBPropertiesManager.java:104) INFO - Trying to initialize Properties Manager
2016-02-09 12:25:53,536 [pool-2-thread-9] (DBPropertiesManager.java:108) INFO - Finished initializing Properties Manager with DB type:SQL Server
2016-02-09 12:25:53,536 [pool-2-thread-9] (DBPropertiesManager.java:456) INFO - Trying to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:53,536 [pool-2-thread-9] (DBPropertiesManager.java:466) INFO - Failed to get property value. Property name 'nanny-jmxpwd' namespace 'nanny-jmxpwd'
2016-02-09 12:25:54,552 [pool-2-thread-9] (JavaTask.java:80) INFO - Finished java task: com.mercury.infra.configserver.fm.tasks.RegisterDbContextTask. Execution result: success
2016-02-09 12:25:54,552 [pool-2-thread-9] (NavigationRules.java:57) INFO - navigationValue = connect
2016-02-09 12:25:54,552 [pool-2-thread-9] (Step.java:106) INFO - *** Step opr-persist_opr_settings was executed. Execution result : success. Next step is: opr-createDefaultValues
2016-02-09 12:25:54,552 [pool-2-thread-9] (Step.java:74) INFO - *** Executing step: opr-createDefaultValues
2016-02-09 12:25:54,552 [pool-2-thread-9] (JavaTask.java:68) INFO - Start java task: com.hp.opr.configuration.tasks.CreateDatabase
2016-02-09 12:25:56,161 [pool-2-thread-9] (JDBCExceptionReporter.java:101) ERROR - [Mercury][SQLServer JDBC Driver][SQLServer]Invalid object name 'C000_STEP_DEFINITION'.
2016-02-09 12:25:56,161 [pool-2-thread-9] (JDBCExceptionReporter.java:101) ERROR - [Mercury][SQLServer JDBC Driver][SQLServer]Statement(s) could not be prepared.
2016-02-09 12:25:56,161 [pool-2-thread-9] (CreateDatabase.java:115) ERROR - Caught an exception! Copying default values to customer 1 failed.: could not execute query -- [Mercury][SQLServer JDBC Driver][SQLServer]Invalid object name 'C000_STEP_DEFINITION'.
2016-02-09 12:25:56,161 [pool-2-thread-9] (JavaTask.java:80) INFO - Finished java task: com.hp.opr.configuration.tasks.CreateDatabase. Execution result: failure
2016-02-09 12:25:56,161 [pool-2-thread-9] (NavigationRules.java:57) INFO - navigationValue = failure
2016-02-09 12:25:56,161 [pool-2-thread-9] (Step.java:106) INFO - *** Step opr-createDefaultValues was executed. Execution result : failure. Next step is: opr-showDbCreationError
2016-02-09 12:25:56,161 [pool-2-thread-9] (FlowManager.java:229) INFO - last_wait_step: opr-showDbCreationError

Thanks 
Vignesh

 

0 Likes
Micro Focus Expert
Micro Focus Expert

Re: Copying default values to customer 1 failed

Hi Vignesh,

the error

 (JDBCExceptionReporter.java:101) ERROR - [Mercury][SQLServer JDBC Driver][SQLServer]Invalid object name 'C000_STEP_DEFINITION'.

makes me guess that the table 'C000_STEP_DEFINITION' either doesn't exist in the event database, or is empty,
and thus the wizard fails to copy the data to the target table.
You can check the database for the table C000_STEP_DEFINITION.
If it is missing, you know at least where the error comes from.

If this is a new installation and not an upgrade (no data), I would simply delete all the databases and give it another try,
with creating a new one.
Another option is to enable debug logging and thus better see why the error shows up.

Did you create the database manually, or did you leave this to BSM during the installation?
If this is an update, what version do you come from?

Greetings
Siggi
 

Customer Support
Micro Focus

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Pavithran_vig Absent Member.
Absent Member.

Re: Copying default values to customer 1 failed

Hello Siggi,

     Thanks alot for your help, This an upgrade from 9.13 to 9.26 hence we need the backup data. Except for User engagement schema which created manually and others have been mapped with earlier DB.

now have stuck with schema upgrade , have attached the screenshot can you please bail me out :-)

 

Thanks in advance

Vignesh

0 Likes
Micro Focus Expert
Micro Focus Expert

Re: Copying default values to customer 1 failed

Please see my answer for

http://community.hpe.com/t5/Application-Perf-Mgmt-BAC-BSM/Installation-HP-BSM-9-26-Schema-Upgrade-failure-in-DPS/m-p/6833486#M65879

Greetings
Siggi

Customer Support
Micro Focus

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.