Proxy Error

Kavya · 15 May 2023 10:55:52 PM

Hello All,

Cognos 11.1.6 on Linux OS 7.* with three dispatchers and 2 Gateway servers is all working good as expected.
We got a new Linux VM with OS 8.*. All binaries are Cognos 11.1.6 configurations were cloned from 7.* VM. I have updated the environment variables and other information in Cognos configuration to point to new 8.* VMs. Services have been started and I am able to login to Cognos Connection. I was able to create a package and publish as well.

When I am trying to select the published package to create a new report, it says loading for few minutes and then throw the PROXY error.
Here is the error message:

502 - Proxy Error
URL: ../v1/disp/../reports

Response Text:
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<html><head>
<title>502 Proxy Error</title>
</head><body>
<h1>Proxy Error</h1>
<p>The proxy server received an invalid
response from an upstream server.

The proxy server could not handle the request<p>Reason: Error reading from remote server</p></p>
</body></html>

Any suggestions on how to resolve this issue ?

Thank You !!

Kavya · 15 May 2023 11:24:13 PM

In logs, I see the error as:
java.io.IOException: Process BIBusTKServerMain failed to start properly.

How can I start this process ?

MFGF · 16 May 2023 07:15:03 AM

Quote from: Kavya on 15 May 2023 11:24:13 PM
In logs, I see the error as:
java.io.IOException: Process BIBusTKServerMain failed to start properly.

How can I start this process ?

Hi,

BIBusTKServerMain is a report process which should spawn automatically when you try to run/create/edit a report. It is a 32-bit process, and you should see at least one - possibly several (depending on the number of report processes you have configured for the instance) when you look at the list of processes running. If it's failing to start, it probably means something is blocking it or your new system hasn't allocated enough resources (eg memory) to Cognos to allow it to start. I have heard of things like virus scanners blocking it in the past, so you might want to check if the new server has anything like that running? Also check the memory allocation (MALLOC?)

Cheers!

MF.

Kavya · 24 May 2023 06:38:57 PM

Thanks MFGF for the reply.

We did check Anti virus software, Memory allocation. But nothing helped.
Found that we have higher version of libnsl.so.2 package and had to link that as libnsl.so.1
That helped us and was able to see BmtMDProviderMa process running.
I tried creating a report by selecting the package and that time I saw BIBusTKServerMain process running.

But, I was unable to load the package that I have developed using Dynamic Query Mode. It says loading and throws error as "Report Server is not responding"
Database connection is successful from Cognos connection. It is an Oracle DB.
While creating data source, I have selected "Oracle" as type and both "SQL*Net connect string:"(or OCI) and JDBC connections. JDBC connection will be successful always. OCI connection does fail every time. But, we are ok with that. That is same on Cognos 11.1.6 what we have on Linux OS 7.* VM

Below are few error messages what I am seeing in cognosserver.log on Linux OS 8.* VM:
I have application tier and contier tier components installed on one VM and ip of that VM is masked below as 10.aaa.aa.aaa
I have gateway tier component installed on another VM and ip of that VM is masked below as 10.www.www.www

com.ibm.bi.platform.commons.web.BIResponseWrapper   [Default Executor-thread-11]            NA                  bi      HttpServletResponseCode for /bi/v1/indices/ is in error: 503

ERROR   Audit.xts   [Thread-193]            NA                        Info      Success   PresentationService
PRS-PRO-0511 A partial reinitialization of the XTS processor is required.

ERROR   Audit.xts   [Thread-194]            NA                        Info      Success   PresentationService
PRS-PRO-0511 A partial reinitialization of the XTS processor is required.

ERROR   com.ibm.bi.platform.commons.web.BIResponseWrapper   [Default Executor-thread-104]   882w24slwMw9shGhhhdhhwCv4qyC4qw9Cd2vqdM2      882w24slwMw9shGhhhdhhwCv4qyC4qw9Cd2vqdM2   NA
10.10.aaa.aa.aaa   41302   LoginUser-149614924   NA   /v1/dataset-service/health   bi-service   219062   HttpServletResponseCode for /bi/v1/proxy/dataset-service/health is in error: 503

ERROR   com.ibm.bi.platform.commons.web.BIResponseWrapper   [Default Executor-thread-85]   lCC82ywG4svCyCyMv2M4h889998d9d4j29949wGh      lCC82ywG4svCyCyMv2M4h889998d9d4j29949wGh   NA
10.10.aaa.aa.aaa   37940   LoginUser-149614924   NA   /v1/disp   bi-service   219062   HttpServletResponseCode for /p2pd/servlet/dispatch is in error: 500

ERROR   Audit.Other.DISP.com.cognos.pogo.handlers.engine.ServiceLookupHandler   [Default Executor-thread-103]   28ldq98Gw9vqMvdMhdl9qssvvyyyvjj22y9whdMG      28ldq98Gw9vqMvdMhdl9qssvvyyyvjj22y9whdMG   NA
10.10.www.www.www   58134   LoginUser1993307803   AggAAAC5wXdkAAAAAAoAAAA+Y++QaXQhR4deFAAAAPHbop/CrATqOOffprTV/TR/9yCrBwAAAFNIQS0yNTYgAAAAJU7UViCvfR/t143EKRviH3FPQupt6TwR+DPD4NHFfKY=   /v1/disp   bi-service   219062
Request   http://www.ibm.com/xmlns/prod/cognos/metadataService/201907/.serverQE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: testDataSourceConnection UDA-SQL-0432 Unable to locate the gateway "libcogudaor".
BME-EX-0144 Trace back:BmtPlayTransaction.cpp(788):
QFException: CCL_RETHROW: BmtPlayTransaction::DoActionBmtActionsHelper.cpp(488):
QFException: CCL_RETHROW: BmtActionsHelper::DoActionQFSSession.cpp(1190):
QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1188):
QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(2082):
QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()Source/QE_RsApi.cpp(2112):
QFException: CCL_RETHROW: QESource/QEI_ConnectionFault.cpp(870): QFException: CCL_THROW: QE Script Stack Trace Action No=1 Action Name=TestDataSourceConnection   Failure
<messages><message><messageString>Metadata Provider Error</messageString></message><message><messageString>QE-DEF-0285 The logon failed.</messageString></message></messages>

ERROR   Audit.caf   [Default Executor-thread-103]   28ldq98Gw9vqMvdMhdl9qssvvyyyvjj22y9whdMG      28ldq98Gw9vqMvdMhdl9qssvvyyyvjj22y9whdMG   NA
10.10.www.www.www   58134   LoginUser1993307803   AggAAAC5wXdkAAAAAAoAAAA+Y++QaXQhR4deFAAAAPHbop/CrATqOOffprTV/TR/9yCrBwAAAFNIQS0yNTYgAAAAJU7UViCvfR/t143EKRviH3FPQupt6TwR+DPD4NHFfKY=   /v1/disp   bi-service   219062
Request   secure error - found userCapabilities   Warning

ERROR   com.cognos.pogo.reportservice.RequestInvoker   [Default Executor-thread-48]   8j24ljl2lyl4jv42sGwG48CClldy2q94GhMMGwC4      8j24ljl2lyl4jv42sGwG48CClldy2q94GhMMGwC4   NA
10.10.www.www.www   58254   LoginUser1993307803   AggAAABwxXdkAAAAAAoAAABJXCOJgFvC+bwnFAAAAPHbop/CrATqOOffprTV/TR/9yCrBwAAAFNIQS0yNTYgAAAAMAzV+RQKv0qmKRzRPVCrL/WrWVWpReBIx7wxDk2PvuM=   /v1/reports   report-service   219062
DPR-ERR-2074 Failed to receive a timely response from an external process with a PID 220406. Ensure that the process with a process ID 220406 is started.
If the cause of problem cannot be determined, increase the logging level for the target service in the IBM Cognos Administration tool and reproduce the conditions that caused the error.
If the problem persists, see the problem determination information on the IBM Cognos Support Portal page at http://www-947.ibm.com/support/entry/portal/Overview/Software/Information_Management/Cognos

ERROR   Audit.Other.DISP.com.cognos.pogo.handlers.engine.ServiceLookupHandler   [Default Executor-thread-48]   8j24ljl2lyl4jv42sGwG48CClldy2q94GhMMGwC4      8j24ljl2lyl4jv42sGwG48CClldy2q94GhMMGwC4   NA
10.10.www.www.www   58254   LoginUser1993307803   AggAAABwxXdkAAAAAAoAAABJXCOJgFvC+bwnFAAAAPHbop/CrATqOOffprTV/TR/9yCrBwAAAFNIQS0yNTYgAAAAMAzV+RQKv0qmKRzRPVCrL/WrWVWpReBIx7wxDk2PvuM=   /v1/reports   report-service   219062
Request   http://www.ibm.com/xmlns/prod/cognos/reportService/201912/.sessionHandler trace back: [the_dispatcher] com.cognos.pogo.handlers.performance.PerformanceIndicationHandler
[the_dispatcher] com.cognos.pogo.handlers.logic.ChainHandler [service_lookup] com.cognos.pogo.handlers.engine.ServiceLookupHandler [load_balancer] com.cognos.pogo.handlers.logic.ChainHandler
[wrapped_lb_forwarder] com.cognos.pogo.auth.NewAuthHandler [lb_forwarder] com.cognos.p2plb.clerver.LoadBalanceHandler [reportservicechain] com.cognos.pogo.handlers.logic.ChainHandler
[warp_with_authenticate] com.cognos.pogo.handlers.logic.ChainHandler [do_warp] com.cognos.pogo.handlers.logic.ChainHandler [warpmta] com.cognos.pogo.reportservice.ReportServerHandler
Failure         <messages><message><messageString>The server did something wrong</messageString></message><message><messageString>DPR-ERR-2056 The Report Server is not responding.</messageString></message></messages>

Any suggestions ?

MFGF · 25 May 2023 07:27:23 AM

Quote from: Kavya on 24 May 2023 06:38:57 PM
Thanks MFGF for the reply.

We did check Anti virus software, Memory allocation. But nothing helped.
Found that we have higher version of libnsl.so.2 package and had to link that as libnsl.so.1
That helped us and was able to see BmtMDProviderMa process running.
I tried creating a report by selecting the package and that time I saw BIBusTKServerMain process running.

But, I was unable to load the package that I have developed using Dynamic Query Mode. It says loading and throws error as "Report Server is not responding"
Database connection is successful from Cognos connection. It is an Oracle DB.
While creating data source, I have selected "Oracle" as type and both "SQL*Net connect string:"(or OCI) and JDBC connections. JDBC connection will be successful always. OCI connection does fail every time. But, we are ok with that. That is same on Cognos 11.1.6 what we have on Linux OS 7.* VM

Below are few error messages what I am seeing in cognosserver.log on Linux OS 8.* VM:
I have application tier and contier tier components installed on one VM and ip of that VM is masked below as 10.aaa.aa.aaa
I have gateway tier component installed on another VM and ip of that VM is masked below as 10.www.www.www

com.ibm.bi.platform.commons.web.BIResponseWrapper   [Default Executor-thread-11]            NA                  bi      HttpServletResponseCode for /bi/v1/indices/ is in error: 503

ERROR   Audit.xts   [Thread-193]            NA                        Info      Success   PresentationService
PRS-PRO-0511 A partial reinitialization of the XTS processor is required.

ERROR   Audit.xts   [Thread-194]            NA                        Info      Success   PresentationService
PRS-PRO-0511 A partial reinitialization of the XTS processor is required.

ERROR   com.ibm.bi.platform.commons.web.BIResponseWrapper   [Default Executor-thread-104]   882w24slwMw9shGhhhdhhwCv4qyC4qw9Cd2vqdM2      882w24slwMw9shGhhhdhhwCv4qyC4qw9Cd2vqdM2   NA
10.10.aaa.aa.aaa   41302   LoginUser-149614924   NA   /v1/dataset-service/health   bi-service   219062   HttpServletResponseCode for /bi/v1/proxy/dataset-service/health is in error: 503

ERROR   com.ibm.bi.platform.commons.web.BIResponseWrapper   [Default Executor-thread-85]   lCC82ywG4svCyCyMv2M4h889998d9d4j29949wGh      lCC82ywG4svCyCyMv2M4h889998d9d4j29949wGh   NA
10.10.aaa.aa.aaa   37940   LoginUser-149614924   NA   /v1/disp   bi-service   219062   HttpServletResponseCode for /p2pd/servlet/dispatch is in error: 500

ERROR   Audit.Other.DISP.com.cognos.pogo.handlers.engine.ServiceLookupHandler   [Default Executor-thread-103]   28ldq98Gw9vqMvdMhdl9qssvvyyyvjj22y9whdMG      28ldq98Gw9vqMvdMhdl9qssvvyyyvjj22y9whdMG   NA
10.10.www.www.www   58134   LoginUser1993307803   AggAAAC5wXdkAAAAAAoAAAA+Y++QaXQhR4deFAAAAPHbop/CrATqOOffprTV/TR/9yCrBwAAAFNIQS0yNTYgAAAAJU7UViCvfR/t143EKRviH3FPQupt6TwR+DPD4NHFfKY=   /v1/disp   bi-service   219062
Request   http://www.ibm.com/xmlns/prod/cognos/metadataService/201907/.serverQE-DEF-0325 The logon failed for the following reason:
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in: testDataSourceConnection UDA-SQL-0432 Unable to locate the gateway "libcogudaor".
BME-EX-0144 Trace back:BmtPlayTransaction.cpp(788):
QFException: CCL_RETHROW: BmtPlayTransaction::DoActionBmtActionsHelper.cpp(488):
QFException: CCL_RETHROW: BmtActionsHelper::DoActionQFSSession.cpp(1190):
QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()QFSSession.cpp(1188):
QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()QFSSession.cpp(2082):
QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()Source/QE_RsApi.cpp(2112):
QFException: CCL_RETHROW: QESource/QEI_ConnectionFault.cpp(870): QFException: CCL_THROW: QE Script Stack Trace Action No=1 Action Name=TestDataSourceConnection   Failure
<messages><message><messageString>Metadata Provider Error</messageString></message><message><messageString>QE-DEF-0285 The logon failed.</messageString></message></messages>

ERROR   Audit.caf   [Default Executor-thread-103]   28ldq98Gw9vqMvdMhdl9qssvvyyyvjj22y9whdMG      28ldq98Gw9vqMvdMhdl9qssvvyyyvjj22y9whdMG   NA
10.10.www.www.www   58134   LoginUser1993307803   AggAAAC5wXdkAAAAAAoAAAA+Y++QaXQhR4deFAAAAPHbop/CrATqOOffprTV/TR/9yCrBwAAAFNIQS0yNTYgAAAAJU7UViCvfR/t143EKRviH3FPQupt6TwR+DPD4NHFfKY=   /v1/disp   bi-service   219062
Request   secure error - found userCapabilities   Warning

ERROR   com.cognos.pogo.reportservice.RequestInvoker   [Default Executor-thread-48]   8j24ljl2lyl4jv42sGwG48CClldy2q94GhMMGwC4      8j24ljl2lyl4jv42sGwG48CClldy2q94GhMMGwC4   NA
10.10.www.www.www   58254   LoginUser1993307803   AggAAABwxXdkAAAAAAoAAABJXCOJgFvC+bwnFAAAAPHbop/CrATqOOffprTV/TR/9yCrBwAAAFNIQS0yNTYgAAAAMAzV+RQKv0qmKRzRPVCrL/WrWVWpReBIx7wxDk2PvuM=   /v1/reports   report-service   219062
DPR-ERR-2074 Failed to receive a timely response from an external process with a PID 220406. Ensure that the process with a process ID 220406 is started.
If the cause of problem cannot be determined, increase the logging level for the target service in the IBM Cognos Administration tool and reproduce the conditions that caused the error.
If the problem persists, see the problem determination information on the IBM Cognos Support Portal page at http://www-947.ibm.com/support/entry/portal/Overview/Software/Information_Management/Cognos

ERROR   Audit.Other.DISP.com.cognos.pogo.handlers.engine.ServiceLookupHandler   [Default Executor-thread-48]   8j24ljl2lyl4jv42sGwG48CClldy2q94GhMMGwC4      8j24ljl2lyl4jv42sGwG48CClldy2q94GhMMGwC4   NA
10.10.www.www.www   58254   LoginUser1993307803   AggAAABwxXdkAAAAAAoAAABJXCOJgFvC+bwnFAAAAPHbop/CrATqOOffprTV/TR/9yCrBwAAAFNIQS0yNTYgAAAAMAzV+RQKv0qmKRzRPVCrL/WrWVWpReBIx7wxDk2PvuM=   /v1/reports   report-service   219062
Request   http://www.ibm.com/xmlns/prod/cognos/reportService/201912/.sessionHandler trace back: [the_dispatcher] com.cognos.pogo.handlers.performance.PerformanceIndicationHandler
[the_dispatcher] com.cognos.pogo.handlers.logic.ChainHandler [service_lookup] com.cognos.pogo.handlers.engine.ServiceLookupHandler [load_balancer] com.cognos.pogo.handlers.logic.ChainHandler
[wrapped_lb_forwarder] com.cognos.pogo.auth.NewAuthHandler [lb_forwarder] com.cognos.p2plb.clerver.LoadBalanceHandler [reportservicechain] com.cognos.pogo.handlers.logic.ChainHandler
[warp_with_authenticate] com.cognos.pogo.handlers.logic.ChainHandler [do_warp] com.cognos.pogo.handlers.logic.ChainHandler [warpmta] com.cognos.pogo.reportservice.ReportServerHandler
Failure         <messages><message><messageString>The server did something wrong</messageString></message><message><messageString>DPR-ERR-2056 The Report Server is not responding.</messageString></message></messages>

Any suggestions ?

Hi,

For the "DPR-ERR-2056 The Report Server is not responding" error, one possibility is low disk space. How much free space is available?

For the "DPR-ERR-2074 Failed to receive a timely response from an external process with a PID..." error, this can be caused by failure to resolve a hostname within the Cognos architecture. How are your URIs defined within Cognos Configuration - are you using "localhost", a host name or an IP address?

The "RQP-DEF-0068 Unable to connect to at least one database..." error is coming from your testing of the data source connection - the CQE part of the connection is not seeing the Oracle native client libraries (libcogudaor) - this is your OCI test failing.

I would look into the first two errors and see if you can figure them out first.

https://www.ibm.com/support/pages/dpr-err-2056-report-server-not-responding
https://www.ibm.com/support/pages/dpr-err-2074-error-while-running-report-cognos

Cheers!

MF.

Kavya · 25 May 2023 11:55:06 AM

Hello,

Yes, I did check those articles before posting my message here.
On both VM's I have 106GB space. Of which at least 65GB is free on both. I do not see any dump files.
I have URI's defined using hostnames.

Resolution notes from those articles weren't resolving the issue that I am facing.

Kavya · 31 May 2023 12:10:34 AM

Hello,

Issue has been resolved. In Cognos Configuration, changing "Report Server execution mode" from "32-bit" to "64-bit" solved all issues. Now, I am able to load the package that I have developed using DQM, Create a report, Run report, Export to EXCEL, Schedule a report.

Thanks MFGF for taking time and looking into my issue.

Regards
Kavya.

MFGF · 01 Jun 2023 09:21:41 AM

Quote from: Kavya on 31 May 2023 12:10:34 AM
Hello,

Issue has been resolved. In Cognos Configuration, changing "Report Server execution mode" from "32-bit" to "64-bit" solved all issues. Now, I am able to load the package that I have developed using DQM, Create a report, Run report, Export to EXCEL, Schedule a report.

Thanks MFGF for taking time and looking into my issue.

Regards
Kavya.

Hi,

This is going to be fine if *all* your packages are published in DQM. However, if you have any CQE packages, they will no longer work when setting the report server execution mode to 64-bit - they need it to be 32-bit.

Cheers!

MF.

Kavya · 05 Jun 2023 11:11:21 AM

Hi MF,

Thanks for the reply. Yes, all our packages are published in DQM mode for now. I will make a note of this for future.

Regards,
Kavya

BSP Software	Resources	About Us
MetaManager	BSP Software Training	BSP Software
Integrated Control Suite	YouTube Channel	Micro Strategies Inc
Security Migration		IBM Cognos
Integrated Management Suite

If you are unable to create a new account, please email support@bspsoftware.com

COGNOiSe.com - The IBM Cognos Community

News:

Proxy Error

Kavya

Kavya

MFGF

Kavya

MFGF

Kavya

Kavya

MFGF

Kavya