Highlighted
Honored Contributor.. Honored Contributor..
Honored Contributor..
1700 views

NPS service is down and BI server not running.

Hi All,

NPS is running in HA windows failover cluster

OS: Windows 2016 DataCenter

BI Server service is not starting since yesterday, found the USER_MAIN table was full and increased the same.

I tried to stop all the service and start it but BI Server is not starting, tried starting from BIGUICONFIG and get the below deatils.

 

[Start Service]

18:49:13, 'LogService', 'StartService', 'Success'.

18:49:18, CAF-WRN-0021 CAF Third Party XSS checking disabled.

18:49:18, CAF-WRN-0010 CAF input validation enabled.

18:49:20, '', 'StartService', 'Success'.

18:49:20, 'ContentManager', 'getActiveContentManager', 'Failure'.

DPR-CMI-4006 Unable to determine the active Content Manager. Will retry periodically.

18:49:20, CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store.  CM-CFG-5036 Content Manager failed to connect to the content store. The connection string is "jdbc:db2://VM2OPNPS1.epldt.biz:9080/csdb:retrieveMessagesFromServerOnGetMessage=true;fullyMaterializeLobData=false;". The error encountered is: "[jcc][t4][2019][11255][4.21.29] Connection authorization failure occurred.  Reason: Authentication failed because of connectivity restrictions enforced by the security plug-in. ERRORCODE=-4214, SQLSTATE=28000" Cause: [jcc][t4][2019][11255][4.21.29] Connection authorization failure occurred.  Reason: Authentication failed because of connectivity restrictions enforced by the security plug-in. ERRORCODE=-4214, SQLSTATE=28000    Stack trace:  com.ibm.db2.jcc.am.SqlInvalidAuthorizationSpecException: [jcc][t4][2019][11255][4.21.29] Connection authorization failure occurred.  Reason: Authentication failed because of connectivity restrictions enforced by the security plug-in. ERRORCODE=-4214, SQLSTATE=28000            at com.ibm.db2.jcc.am.kd.a(kd.java:808)       at com.ibm.db2.jcc.am.kd.a(kd.java:66)  at com.ibm.db2.jcc.am.kd.a(kd.java:133)       at com.ibm.db2.jcc.t4.b.f(b.java:2516)     at com.ibm.db2.jcc.t4.b.b(b.java:1831)          at com.ibm.db2.jcc.t4.z.r(z.java:957)        at com.ibm.db2.jcc.t4.z.k(z.java:494)  at com.ibm.db2.jcc.t4.z.c(z.java:144)       at com.ibm.db2.jcc.t4.b.k(b.java:1406)          at com.ibm.db2.jcc.t4.b.b(b.java:1319)     at com.ibm.db2.jcc.t4.b.a(b.java:6509)          at com.ibm.db2.jcc.t4.b.b(b.java:869)      at com.ibm.db2.jcc.t4.b.a(b.java:785)  at com.ibm.db2.jcc.t4.b.a(b.java:430)      at com.ibm.db2.jcc.t4.b.a(b.java:403)  at com.ibm.db2.jcc.t4.b.<init>(b.java:341)         at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:233)  at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:199)  at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:482)           at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:116)           at com.cognos.cm.dbstore.CMDriverManager.getConnection(CMDriverManager.java:112)      at com.cognos.cm.dbstore.CMDriverManager.getConnection(CMDriverManager.java:105)      at com.cognos.cm.dbstore.CMDbStoreFactory.getJDBCConnection(CMDbStoreFactory.java:1936)            at com.cognos.cm.dbstore.CMDbStoreFactory.getInitialConnection(CMDbStoreFactory.java:1723)            at com.cognos.cm.dbstore.CMDbStoreFactory.initContentIndependentBeforeLock(CMDbStoreFactory.java:1956)            at com.cognos.cm.dbstore.CMDbStore.initializeContentIndependentBeforeLock(CMDbStore.java:4393)            at com.cognos.cm.server.CMServlet.initializeContentStoreContentIndependentBeforeLock(CMServlet.java:2114)            at com.cognos.cm.server.CMServlet.init(CMServlet.java:1873)    at com.cognos.cm.server.ContentManager.start(ContentManager.java:436)        at com.cognos.cm.server.ContentManagerLifecycleHandler.start(ContentManagerLifecycleHandler.java:65)            at com.cognos.pogo.services.DefaultHandlerService.start(DefaultHandlerService.java:88)      at com.cognos.pogo.services.DispatcherServices.startInitialService(DispatcherServices.java:438)            at com.cognos.pogo.services.DispatcherServices.startInititalServices(DispatcherServices.java:424)            at com.cognos.pogo.transport.PogoServlet$PogoStartup.runWithDispatcherServices(PogoServlet.java:832)            at com.cognos.pogo.transport.PogoServlet$PogoStartup.run(PogoServlet.java:814)    at com.cognos.pogo.util.threads.SafeThread.safeRun(SafeThread.java:70)          at com.cognos.pogo.util.threads.SafeThread.run(SafeThread.java:61) 

18:50:22, 'AnnotationService', 'StopService', 'Success'.

18:50:22, 'EventService', 'StopService', 'Success'.

18:50:22, 'MetadataService', 'StopService', 'Success'.

18:50:22, 'SACamSrvc', 'StopService', 'Success'.

18:50:22, 'DeliveryService', 'StopService', 'Success'.

18:50:22, 'CPS Producer Registration Service', 'StopService', 'Success'.

18:50:22, 'MonitorService', 'StopService', 'Success'.

18:50:22, 'Dispatcher', 'Stop', 'Success'.

18:50:22, 'AgentService', 'StopService', 'Success'.

18:50:22, 'HumanTaskService', 'StopService', 'Success'.

18:50:22, 'JobService', 'StopService', 'Success'.

18:50:22, 'idVizService', 'StopService', 'Success'.

18:50:22, 'SACamSrvcInternal', 'StopService', 'Success'.

18:50:22, 'relationalMetadataService', 'StopService', 'Success'.

18:50:22, 'SystemService', 'StopService', 'Success'.

18:50:22, 'Fragment Server Service', 'StopService', 'Success'.

18:50:22, 'CacheService', 'StopService', 'Success'.

18:50:22, 'BatchReportService', 'StopService', 'Success'.

18:50:22, 'ContentManagerCacheService', 'StopService', 'Success'.

18:50:22, 'camAsyncAA', 'StopService', 'Success'.

18:50:22, 'ReportDataService', 'StopService', 'Success'.

18:50:22,

18:50:22, 'MobileService', 'StopService', 'Success'.

18:50:22, 'ReportService', 'StopService', 'Success'.

18:50:22, 'QueryService', 'StopService', 'Success'.

18:50:22, 'RepositoryService', 'StopService', 'Success'.

18:50:22, 'burstDistributionService', 'StopService', 'Success'.

18:50:22, 'BUX Service', 'StopService', 'Success'.

18:50:22, 'zipiService', 'StopService', 'Success'.

18:50:22, CM-SYS-5242 Background task manager is not running.

18:50:22, 'PDC', 'StopService', 'Success'.

18:50:22, 'GraphicsService', 'StopService', 'Success'.

18:50:22, 'ContentManagerService', 'StopService', 'Success'.

18:50:22, 'visualisationGalleryService', 'StopService', 'Success'.

18:50:22, 'LogService', 'StopService', 'Success'.

 

[Start Service]

[ ERROR ] CFG-ERR-0103 Unable to start NNM iSPI Performance BI service.

Execution of the external process returns an error code value of '-1'

could you please advise.

Thanks

0 Likes
4 Replies
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: NPS service is down and BI server not running.

Hi,

is Content Store database (Informix) runing? It could be user/password issue.  You can try to open "NNMi iSPI Performance BI Configuration" GUI, select Data Access-> Content Manager -> NNMi ISPI Performance Content Store and look if settings correct. Then try to test connection from the GUI.

Also have a look to http://www-01.ibm.com/support/docview.wss?uid=swg22015967

my 2 cents,
Gedas

0 Likes
Highlighted
Honored Contributor.. Honored Contributor..
Honored Contributor..

Re: NPS service is down and BI server not running.

Hi 

Thank you very much for the reply.

I have change the password and update in GUI as well as in services.msc and still getting the error

Capture.JPG

 

I can not find the service in my system "Informix IDS - olcognoscm" , i have updated the password for the services BI Contect, ETL and utilit service.

Please advise.

0 Likes
Highlighted
Honored Contributor.. Honored Contributor..
Honored Contributor..

Re: NPS service is down and BI server not running.

got this error when the start the  serivce from BICOnfigGUI, looks like some where else the passowrd needs to updated.

[Start Service]
15:38:55, 'LogService', 'StartService', 'Success'.
15:39:02, CM-CFG-5063 A Content Manager configuration error was detected while connecting to the content store. CM-SYS-5003 Content Manager is unable to connect to the content store. Verify that the database connection properties in the configuration tool are correct and that when you test the connection, the test is successful. Cause: [jcc][t4][2032][11265][4.21.29] The application server rejected establishment of the connection. The user is not authorized to access the database. ERRORCODE=-4214, SQLSTATE=08004 Stack trace: com.ibm.db2.jcc.am.SqlNonTransientConnectionException: [jcc][t4][2032][11265][4.21.29] The application server rejected establishment of the connection. The user is not authorized to access the database. ERRORCODE=-4214, SQLSTATE=08004 at com.ibm.db2.jcc.am.kd.a(kd.java:800) at com.ibm.db2.jcc.am.kd.a(kd.java:66) at com.ibm.db2.jcc.am.kd.a(kd.java:133) at com.ibm.db2.jcc.t4.z.v(z.java:2169) at com.ibm.db2.jcc.t4.z.p(z.java:720) at com.ibm.db2.jcc.t4.z.l(z.java:538) at com.ibm.db2.jcc.t4.z.d(z.java:153) at com.ibm.db2.jcc.t4.b.k(b.java:1407) at com.ibm.db2.jcc.t4.b.b(b.java:1319) at com.ibm.db2.jcc.t4.b.a(b.java:6509) at com.ibm.db2.jcc.t4.b.b(b.java:869) at com.ibm.db2.jcc.t4.b.a(b.java:785) at com.ibm.db2.jcc.t4.b.a(b.java:430) at com.ibm.db2.jcc.t4.b.a(b.java:403) at com.ibm.db2.jcc.t4.b.<init>(b.java:341) at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:233) at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:199) at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:482) at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:116) at com.cognos.cm.dbstore.CMDriverManager.getConnection(CMDriverManager.java:112) at com.cognos.cm.dbstore.CMDriverManager.getConnection(CMDriverManager.java:105) at com.cognos.cm.dbstore.CMDbStoreFactory.getJDBCConnection(CMDbStoreFactory.java:1936) at com.cognos.cm.dbstore.CMDbStoreFactory.getInitialConnection(CMDbStoreFactory.java:1723) at com.cognos.cm.dbstore.CMDbStoreFactory.initContentIndependentBeforeLock(CMDbStoreFactory.java:1956) at com.cognos.cm.dbstore.CMDbStore.initializeContentIndependentBeforeLock(CMDbStore.java:4393) at com.cognos.cm.server.CMServlet.initializeContentStoreContentIndependentBeforeLock(CMServlet.java:2114) at com.cognos.cm.server.CMServlet.init(CMServlet.java:1873) at com.cognos.cm.server.ContentManager.start(ContentManager.java:436) at com.cognos.cm.server.ContentManagerLifecycleHandler.start(ContentManagerLifecycleHandler.java:65) at com.cognos.pogo.services.DefaultHandlerService.start(DefaultHandlerService.java:88) at com.cognos.pogo.services.DispatcherServices.startInitialService(DispatcherServices.java:438) at com.cognos.pogo.services.DispatcherServices.startInititalServices(DispatcherServices.java:424) at com.cognos.pogo.transport.PogoServlet$PogoStartup.runWithDispatcherServices(PogoServlet.java:832) at com.cognos.pogo.transport.PogoServlet$PogoStartup.run(PogoServlet.java:814) at com.cognos.pogo.util.threads.SafeThread.safeRun(SafeThread.java:70) at com.cognos.pogo.util.threads.SafeThread.run(SafeThread.java:61)
15:39:02, '', 'StartService', 'Success'.
15:39:05, 'ContentManager', 'getActiveContentManager', 'Failure'.
DPR-CMI-4006 Unable to determine the active Content Manager. Will retry periodically.
15:39:05, CAF-WRN-0021 CAF Third Party XSS checking disabled.
15:39:05, CAF-WRN-0010 CAF input validation enabled.
15:40:13, 'CPS Producer Registration Service', 'StopService', 'Success'.
15:40:13, 'AgentService', 'StopService', 'Success'.
15:40:13, 'SACamSrvc', 'StopService', 'Success'.
15:40:13, 'idVizService', 'StopService', 'Success'.
15:40:13, 'MetadataService', 'StopService', 'Success'.
15:40:13, 'MonitorService', 'StopService', 'Success'.
15:40:13, 'Dispatcher', 'Stop', 'Success'.
15:40:13, 'JobService', 'StopService', 'Success'.
15:40:13, 'AnnotationService', 'StopService', 'Success'.
15:40:13, 'EventService', 'StopService', 'Success'.
15:40:13, 'DeliveryService', 'StopService', 'Success'.
15:40:13, 'HumanTaskService', 'StopService', 'Success'.
15:40:13, 'SACamSrvcInternal', 'StopService', 'Success'.
15:40:13, 'ContentManagerCacheService', 'StopService', 'Success'.
15:40:13, 'ReportDataService', 'StopService', 'Success'.
15:40:13, 'Fragment Server Service', 'StopService', 'Success'.
15:40:13, 'CacheService', 'StopService', 'Success'.
15:40:13, 'BatchReportService', 'StopService', 'Success'.
15:40:13, 'SystemService', 'StopService', 'Success'.
15:40:13, 'camAsyncAA', 'StopService', 'Success'.
15:40:13,
15:40:13, 'MobileService', 'StopService', 'Success'.
15:40:13, 'relationalMetadataService', 'StopService', 'Success'.
15:40:13, 'RepositoryService', 'StopService', 'Success'.
15:40:13, 'zipiService', 'StopService', 'Success'.
15:40:13, 'ContentManagerService', 'StopService', 'Success'.
15:40:13, 'PDC', 'StopService', 'Success'.
15:40:13, 'QueryService', 'StopService', 'Success'.
15:40:13, 'visualisationGalleryService', 'StopService', 'Success'.
15:40:13, 'burstDistributionService', 'StopService', 'Success'.
15:40:13, 'BUX Service', 'StopService', 'Success'.
15:40:13, CM-SYS-5242 Background task manager is not running.
15:40:13, 'ReportService', 'StopService', 'Success'.
15:40:13, 'GraphicsService', 'StopService', 'Success'.
15:40:13, 'LogService', 'StopService', 'Success'.

0 Likes
Highlighted
Outstanding Contributor.. Outstanding Contributor..
Outstanding Contributor..

Re: NPS service is down and BI server not running.

Something weird. I'd suggest you to register support case.

One more idea. Could it be that content store is corrupted, because issues started after DB overload?
I don't know if it's safe (is it production system?) but you could try to run initializeNPS.ovpl and recreate content store. There are several actions- create CS, setup roles and security, config etc..

Perhaps onlty action 12 and 13 coule be enough? Also you can try action 6.

 Number  Action Status
 ------------------------------------------------------------
 1:  Install Sybase IQ 
 2:  Install BI Server 
 3:  Perform Cognos FIPS Related Activities
 4:  Install Sybase ASE Database 
 5:  Create Perfspi Database 
 6:  Create Sybase ASE Content Store 
 7:  Drop Perfspi Database  NotRun
 8:  Pre-Configure BI Server 
 9:  Install BI Server IF Patch
 10: Configure PMi 
 11: Start BI Server 
 12: Restore BI Config and ContentStore
 13: Setup Content Store Roles and Security
 14: Configure BI Server Access Control List 
 15: Restart BI Server 
 16: Enable Auto FS on Linux 
 17: Creating Man Pages
 18: Install PerfSPI_Diagnostics Reportpack
 19: Initialize custom collections 
 20: Run Silent Enablement Script Failed
 21: Restore NNMPerformanceSPI Config
 22: Disabling automatic startup of services on HA 
 23: Stop Non-Role Processes 
 24: Install Metrics Extension Packs 
 25: Upgrade Metrics Extension Packs 
 26: Get Help for This Script
 27: Quit This Script
         ------------------------------------------------------------

 

 

regards
Gedas

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.