Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
Micro Focus Expert
Micro Focus Expert
134 views

BIZ_Imapact Service is not running

Jump to solution

I have installed fresh BSM 9.13 in windows 2008 64 bit family server and connect to Oracle 10 g database. BSM create and connect to DB successfully. All service has UP . After that I have just reboot the server and restart the service of BSM. This time all service is UP excepted one service (BIZ_Impact).

 

I have able to open BSM and working fine.Please help on this.

 

Regards,

Sumit Kumar

Mark as solution , if works for you.
Regards,
Sumit Kumar
0 Likes
1 Solution

Accepted Solutions
Micro Focus Expert
Micro Focus Expert

Re: BIZ_Imapact Service is not runnings

Jump to solution

Hi Sumit Kumar,

 

when looking at the log you attached it seems that one or more tables do not exist:

..

2013-01-10 12:46:07,386 [CTRL-SVCStarter] (CmdbAccessor.java:188) ERROR - Customer '1': An exception has occured executeNamedQuery, query name: business_impact_new
com.hp.am.bac.bis.exceptions.ModelDataProviderException: An error has occured while executing the TQL in method executeNamedQuery, query name: business_impact_new
..

Caused by: com.hp.ucmdb.api.ExecutionException:
--- Start of server-side exception ---
appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [-2147483648] undefined error code]
CMDB Operation Internal Error: class appilog.framework.shared.manage.impl.MamResponseException : CMDB Operation Internal Error: class com.mercury.topaz.cmdb.server.manage.dal.CmdbDalException : Error in layout query due to exception: com.mercury.topaz.cmdb.server.manage.dal.CmdbDalException: [ErrorCode [-2147483648] undefined error code]
Error in layout query due to exception: com.mercury.topaz.cmdb.server.manage.dal.CmdbDalException: [ErrorCode [-2147483648] undefined error code]
Can't execute prepared statement [SELECT END_USER_GROUP_1.CMDB_ID, END_USER_GROUP_1.A_BUSINESS_CRITICALITY FROM END_USER_GROUP_1 WHERE END_USER_GROUP_1.CMDB_ID IN (?); Values: <16 bytes>], due to exception: java.sql.SQLSyntaxErrorException: [mercury][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
 : operation Tql Query: Get Or Calc Result Map. Pattern [business_impact_new] : operation Tql Query for SDK queries (By pattern name. Pattern [business_impact_new]

..

 

This appears to be a known issue:

 

The END_USER_GROUP_1 entity is a view that should exist in the ODB database.

The ODB did not have all of its views configured.  Configuring a new ODB using Start->All Programs->HP Business Service Managment->Administration->Configure HP Business Service Management on the DPS server resolved this problem.

 

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.

View solution in original post

0 Likes
3 Replies
Micro Focus Expert
Micro Focus Expert

Re: BIZ_Imapact Service is not running

Jump to solution

Hi,

 

Check the log\businessImpact_service\businessImpact.log file on the server.

 

It should provide you with some error messages to help debug the reason it's not starting.

 

 

Eric Shaffer

"HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution."
0 Likes
Micro Focus Expert
Micro Focus Expert

Re: BIZ_Imapact Service is not runnings

Jump to solution

Hi ,

 

It gives some Table or view error. I don't understand why the error is come, even it is a fresh installation.

 

I am using Oracle 10 g database.I suspect that the error is related to database. Please find the attahement and suggest me.

 

Regards,

Sumit Kumar

Mark as solution , if works for you.
Regards,
Sumit Kumar
0 Likes
Micro Focus Expert
Micro Focus Expert

Re: BIZ_Imapact Service is not runnings

Jump to solution

Hi Sumit Kumar,

 

when looking at the log you attached it seems that one or more tables do not exist:

..

2013-01-10 12:46:07,386 [CTRL-SVCStarter] (CmdbAccessor.java:188) ERROR - Customer '1': An exception has occured executeNamedQuery, query name: business_impact_new
com.hp.am.bac.bis.exceptions.ModelDataProviderException: An error has occured while executing the TQL in method executeNamedQuery, query name: business_impact_new
..

Caused by: com.hp.ucmdb.api.ExecutionException:
--- Start of server-side exception ---
appilog.framework.shared.manage.impl.MamResponseException: [ErrorCode [-2147483648] undefined error code]
CMDB Operation Internal Error: class appilog.framework.shared.manage.impl.MamResponseException : CMDB Operation Internal Error: class com.mercury.topaz.cmdb.server.manage.dal.CmdbDalException : Error in layout query due to exception: com.mercury.topaz.cmdb.server.manage.dal.CmdbDalException: [ErrorCode [-2147483648] undefined error code]
Error in layout query due to exception: com.mercury.topaz.cmdb.server.manage.dal.CmdbDalException: [ErrorCode [-2147483648] undefined error code]
Can't execute prepared statement [SELECT END_USER_GROUP_1.CMDB_ID, END_USER_GROUP_1.A_BUSINESS_CRITICALITY FROM END_USER_GROUP_1 WHERE END_USER_GROUP_1.CMDB_ID IN (?); Values: <16 bytes>], due to exception: java.sql.SQLSyntaxErrorException: [mercury][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
 : operation Tql Query: Get Or Calc Result Map. Pattern [business_impact_new] : operation Tql Query for SDK queries (By pattern name. Pattern [business_impact_new]

..

 

This appears to be a known issue:

 

The END_USER_GROUP_1 entity is a view that should exist in the ODB database.

The ODB did not have all of its views configured.  Configuring a new ODB using Start->All Programs->HP Business Service Managment->Administration->Configure HP Business Service Management on the DPS server resolved this problem.

 

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.

View solution in original post

0 Likes
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.