XQE-EXE-0004 QFWBridge has returned an error: TM1-ERR-0059

[ub14]

Hi,

We are gettting the below error on accessing TM1 Cube based Cognos Reports. TM1 Server is sarted and services are running. But once we execute the Cube based Cognos Reports, the service is stopping and Cognos reports are throwing below errror.

XQE-EXE-0004 QFWBridge has returned an error: TM1-ERR-0059 The TM1 server AbcServer/Test cubes is not responding

Any idea on this error.

[moby91]

XQE-EXE-0004 QFWBridge has returned an error: TM1-ERR-0059 The TM1 server AbcServer/Test cubes is not responding

This is a BI error message. Did you contact IBM Cognos BI Support ?

Most likely this is a firewall rule on one of the server machines (BI Dispatcher) or all of them running some BI components (Gateway, Dispatcher, CM) which is blocking the TM1 instance "Test" running on the host computer "AbcServer" using the TCP Ports defined by the parameters "PortNumber" and "ClientMessagePortNumber" in the TM1 server configuration file tm1s.cfg (plus the TCP Port 5498 used by the TM1 Admin Server by default).

On the server machines running the components of your BI environment, what happens if you ping the host computer "AbcServer" ?
Does the ping fail with a timeout ?

On the server machines running the components of your BI environment, what happens if you telnet the host computer "AbcServer" on the TCP Ports (PortNumber, ClientMessagePortNumber, 5498) used by your TM1 instance "Test" ?
Does the telnet fail with a timeout ?

[Duncan P]

It look from what you say Bhaskar as though the running of the report is causing the ABCserver service to stop. Can you confirm if this is the case, and if so are you certain?

If it is the case have then what happens if you open the cube in one of the normal TM1 UIs?

[ETHSSN]

I had the same happening:
XMD-MET-0004 Die Ausführung der Metadatenabfrage ist fehlgeschlagen. Der Daten-Provider hat folgende Fehlermeldung zurückgegeben: XQE-EXE-0004 QFWBridge hat einen Fehler zurückgegeben: PCA-ERR-0001 Interner PCMDDS-Fehler bei "tm1odpCube.cpp":"227".

TM1 Service crashed!!

[danmack]

Hi All

We are also receiving this error when using the periodsToDate function on COG 10.1.1 with DQM over TM1 10 (general release).

XMD-ERR-0001 Query execution failed. The data provider returned an error message: XQE-EXE-0004 QFWBridge has returned an error: PCA-ERR-0001 There is a PCMDDS internal error at "../../../..\mddstm1ng/prod/adapters/optsdkcore/MPCAElement.h":"116".

Removing the periodToDate data item resolves the issue however we really need to use this function.

In a different report we have the same issue (but a different error message) that causes the TM1 server instance to stop, this error message is:

XQE-PLN-0004 Found an internal error on node 'V5EdgeGroup'. Unable to get the edge group hierarchy.

Again cause is related to use of periodsToDate()

Thanks

Dan