Langsung ke konten utama

IBM Cognos error print PDF format - DPR-ERR-2101 Your request was invalid. Please contact your administrator.

IBM Cognos
An error has occurred.
DPR-ERR-2101 Your request was invalid. Please contact your administrator.
Please try again or contact your administrator.

 https://www.ibm.com/support/pages/dpr-err-2101-your-request-was-invalid-when-viewing-pdf-not-html-or-xls-caused-temporary-objects-location-setting

 Silakan mengikuti tutorial berikut:

Problem

User runs a standard report (for example a Reconcile - Intercompany Balances report). This displays OK (by default using HTML). User then clicks the button to change the report output to PDF. An error appears. *Importantly*, if the user changes the report to XLS, then the report does successfully appear (no error). This behaviour is different from many other similar problems/Technotes.

Symptom


IBM Cognos
An error has occurred.
DPR-ERR-2101 Your request was invalid. Please contact your administrator.
Please try again or contact your administrator.

Cause

There are many different possible causes for a similar error.
  • TIP: See separate IBM Technote #2007559 for more examples.
 This Technote specifically relates to the scenario where the cause is the setting "Temporary objects location".
 More Information
When a user runs an interactive report, the report server sends a request to the Content Manager, asking it to store the report output in the session cache for the user.
 In versions of Cognos BI *before* 10.1.1, this cache information was stored inside the Content Store (database).
  • Beginning with BI version 10.1.1, these user session files are stored on the report server's local file system. This is to reduce the processing load on the Content Manager.
NOTE: If your system was originally running an older version (for example Cognos BI 8.5) and you have now upgraded to 10.1.1, then (by default) your user session files are still stored in Content Manager (not as files).

In some early versions of BI, storing these file on the report server can cause errors/problems.

Resolving The Problem

Modify the setting "Temporary objects location" from the current ("ServerFileSystem") to the value "Content Store".

Steps:
NOTE: The exact steps will vary slightly, depending on your environment (for example version of Controller). The following steps may need to be modified slightly depending on your environment
1. Launch Cognos Connection.
  • TIP: By default, this is the following website:     http://<servername>/ibmcognos
2. Launch the administration portal
  • For some customers this means click "Administer IBM Cognos content":
image-20180824100418-1
  • For other customers, this means (in the upper-right corner), click 'Launch' then click 'IBM Cognos Administration':


3. Click 'Configuration' tab
4. Click Dispatchers and Services.
5. Click the Set Properties - Configuration button (in the upper right corner):


6. Click the tab 'Settings'
7. From the Category menu, click Tuning:
image-20180824100630-2
8. Change the setting for Temporary objects location to be 'Content Store':

8. Click OK.
9. Test.

Related Information

2007559 - ** Troubleshooting ** 'DPR-ERR-2101 Your request
Label:

Komentar

Posting Komentar

Silakan dikomen...

Postingan populer dari blog ini

CREATE CROSS TAB QUERY IN MYSQL

MySQL Multi-Aggregated Rows in Crosstab Queries MySQL’s crosstabs contain aggregate functions on two or more fields, presented in a tabular format. In a multi-aggregate crosstab query, two different functions can be applied to the same field or the same function can be applied to multiple fields on the same (row or column) axis. Rob Gravelle shows you how to apply two different functions to the same field in order to create grouping levels in the row axis. Today’s topic of discussion is crosstabs, which contain multiple aggregate functions in the row axis of a tabular resultset. Recall from the the  All About the Crosstab Query  article that an aggregate function is one that summarizes a group of related data in some way. Examples of aggregate functions include COUNT, SUM, AVG, MIN, and MAX. In a multi-aggregate crosstab query, two different functions can be applied to the same field or the same function can be applied to two or more fields. Today we’ll create a query...
Posting Komentar
Baca selengkapnya

Mysql Import data from CSV File

  Microsoft Windows [Version 10.0.15063] (c) 2017 Microsoft Corporation. All rights reserved. C:\Users\PSI011>cd C:\xampp\mysql\bin C:\xampp\mysql\bin> mysqld 2017-08-22 14:24:49 15428 [Note] mysqld (mysqld 10.1.25-MariaDB) starting as process 16352 ... C:\xampp\mysql\bin> mysql -u root -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 9 Server version: 10.1.25-MariaDB mariadb.org binary distribution Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> use pkh; Database changed MariaDB [pkh]> LOAD DATA LOCAL INFILE 'D:/2017/PKH_FOR_BPKP/PKH_FOR_BPKP_01.csv' -> INTO TABLE pkh_bpkp -> FIELDS TERMINATED BY ',' -> OPTIONALLY ENCLOSED BY '"' -> ESCAPED BY '"' -> LINES TERMINATED BY '\n...
Posting Komentar
Baca selengkapnya

Pentaho Data Integration: Membuat Koneksi ke database MSSQL Server 2008 R2

Untuk terhubung ke database SQL Server langkah-langkah berikut harus dilakukan:   Download Driver Microsoft JDBC di https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774  Tutup Spoon atau Kettle project  Unzip/extract paket dalam direktori temporer (bebas) Copy '<temp directory> \ sqljdbc_6.0\enu\auth\x64\ sqljdbc_auth.dll' ke 'C:\Program Files\Java\jre1.8.0_131' atau sesuaikan dengan path java runtime terinstall  Copy '<temp directory>\ sqljdbc_6.0\enu\jre8\sqljdbc42.jar' ke '<Kettle folder instalasi> \ data-integration \ lib' Buka Spoon atau Kettle project Uji koneksi dalam Spoon Hapus direktori temporer karena sudah tidak digunakan lagi Jika kita meng-upgrade Kettle, Java, JDBC Driver ke versi yang lebih tinggi, maka serangkaian langkah-langkah di atas harus diulang lagi.
2 komentar
Baca selengkapnya