BI : QUERY Execution Error !!

[former_member574967]

Hi Experts,

Whenever I click on the report on the development portal, It always opens up in the Production portal which should not happen.

Kindly advise where the necessary settings should be maintained so that the reports in development portal opens up in the development portal only.

Thanks in advance .

thanks & regards,

M.S

[Former Member · Accepted solution]

Hi,

Check the link which you have publish in the Development portal. There might b a possibility that it is a link of productiion.

- Jaimin

[former_member574967 · Accepted solution]

Hi Experts,

I have cheked as below. In Se38 & Se16 its reflecting the right portal name in the dev system. but whenever i open the development portal and click on the report under the tab in the portal ,it opens up in the production portal. Kindly advise.

Missing configuration of the portal. Check following:

1. Start the transaction SE37

2. Call the Module RSWAD_URL_GET

3. Fill the parameters as follows

I_ACTION: NEW

I_OBJTYPE: QU (QU for Queries, BTMP for Templates, VW for Views, and ERPT for Reports)

I_TECHNAME: QUERY

4. Execute and check the result

5. E_URL=http://<your expected server>:<your expected port>/irj/...&QUERY=QUERY

Solution

If the result is as you expect, the problem is not in the configuration. In other case please do following:

Run the transaction SE16

View the table RSPOR_T_PORTAL

Execute it (expand the width to see the parameter URL_PREFIX)

Check if there is a prefix for your portal maintained

Kindly advise me the steps to check the link.I am doing it for the first time.

Thanks in advance.

thanks & regards,

M.S

[former_member184494 · Accepted solution]

Check the link maintained for the iView in Portal - this could be pointing to PROD.

[former_member574967 · Accepted solution]

Hi Experts,

Sorry for the late reply. I checked and found that iviews are itself pointing to production .kindly advise is there any way to edit the iview or do i have to recreate the iviews.

thanks & regards,

M.S