Skip to Main Content

DevOps, CI/CD and Automation

Unable to run reports using a proxy user

MMNonApex-OracleJul 13 2022 — edited Jul 13 2022

Hi all,
I am using Reports 12.2.1.4 on Linux
TWO_TASK is defined and its value is DB_SERVICE
when i launch this url from the browser it works :
http://server.domain:port/reports/rwservlet?module=MODULE_NAME&userid=USERNAME/PASSWORD@DB_SERVICE&envid=ENV_ID&destype=file&desformat=pdf&server=REPORT_SERVER&PM_PS_NUTSAP=FIDJ-29W10&PM_AG_NUAGENT=1&PM_PI_NUPIECE=25125&PM_DC_NUDOSID=202200000015&PM_ED_CPDEP=U&PM_ED_DPANNEE=2022&PM_ED_NUDEPOT=2&PM_JR_DACALEN=28/02/2022&PM_TI_NUTIER=381&PM_UG_NUUG=1&PM_TI_CSCODUSA=T&PM_PI_CSSAGESD=0604P01&desname=/home/fidji/TestsReports/out/refus.pdf
When I launched the following URL from the browser it DOES NOT work :
Note that i am using a proxy user
http://server.domain:port/reports/rwservlet?module=MODULE_NAME&userid=%5BPRVOCHAB%5D/""@DB_SERVICE&envid=ENV_ID&destype=file&desformat=pdf&server=REPORT_SERVER&PM_PS_NUTSAP=FIDJ-29W10&PM_AG_NUAGENT=1&PM_PI_NUPIECE=25125&PM_DC_NUDOSID=202200000015&PM_ED_CPDEP=U&PM_ED_DPANNEE=2022&PM_ED_NUDEPOT=2&PM_JR_DACALEN=28/02/2022&PM_TI_NUTIER=381&PM_UG_NUUG=1&PM_TI_CSCODUSA=T&PM_PI_CSSAGESD=0604P01&desname=/home/fidji/TestsReports/out/refus.pdf
I tried also some variations :
http://server.domain:port/reports/rwservlet?module=MODULE_NAME&userid=[PRVOCHAB]@DB_SERVICE&envid=ENV_ID&destype=file&desformat=pdf&server=REPORT_SERVER&PM_PS_NUTSAP=FIDJ-29W10&PM_AG_NUAGENT=1&PM_PI_NUPIECE=25125&PM_DC_NUDOSID=202200000015&PM_ED_CPDEP=U&PM_ED_DPANNEE=2022&PM_ED_NUDEPOT=2&PM_JR_DACALEN=28/02/2022&PM_TI_NUTIER=381&PM_UG_NUUG=1&PM_TI_CSCODUSA=T&PM_PI_CSSAGESD=0604P01&desname=/home/fidji/TestsReports/out/refus.pdf
http://server.domain:port/reports/rwservlet?module=MODULE_NAME&userid=[PRVOCHAB]/""@DB_SERVICE&envid=ENV_ID&destype=file&desformat=pdf&server=REPORT_SERVER&PM_PS_NUTSAP=FIDJ-29W10&PM_AG_NUAGENT=1&PM_PI_NUPIECE=25125&PM_DC_NUDOSID=202200000015&PM_ED_CPDEP=U&PM_ED_DPANNEE=2022&PM_ED_NUDEPOT=2&PM_JR_DACALEN=28/02/2022&PM_TI_NUTIER=381&PM_UG_NUUG=1&PM_TI_CSCODUSA=T&PM_PI_CSSAGESD=0604P01&desname=/home/fidji/TestsReports/out/refus.pdf
with no success...
Well i am completely stuck and i need help from expert!!
Thank in advance for your interest!!
Best regards from France
in the rwservlet_diagnostigs.log i see :
error rwservlet.txt (9.17 KB)
2022-07-13 16-53-22.png

This post has been answered by Suresh Sangaran-Oracle on Jul 14 2022
Jump to Answer
Comments
Post Details
Added on Jul 13 2022
3 comments
25 views