Hi Chananka,It is Apps 10 UPD 9.There is no issue previewing the Report, the only issue is when you click ok to print the report or when you send via E-Mail.The print job gets created but gets stuck in Working Status , the print agent doesn’t register picking up the job and the application message created in batch fails and suggests that it can’t find the user who ordered the report based on their directory id. The directory ID it references when it errors isn’t what is on the foundation user role as we have the ADFS/ Single Sign on in the instance so we have a UPN to match against the directory ID instead. e.g. John.Smith@Test.co.uk as the directory id … if this account prints it will say John.Smith is not an active user in the system and doesn’t register the @Test.co.uk part of the directory id. Many Thanks,
Thank you all the issue related to the claim rules set for the application groups.
Thanks Sajith, Have you got examples for the paths from the image provided? I can’t read the elements of the string which aren’t sensitive. Many Thanks,
I can’t see what might be different as other users can log in to EE client this one user can only log into Aurena. Will continue to trouble shoot. Thanks.
Thanks Imal, The UPN is an exact match for the foundation user tole screen you have highlighted.The only think that has changed is that the IFS application sits on a new VM and new application groups have been created for the ADFS connection. Many Thanks,
Thanks for the reply I had references to the log4net .dll I ended up having to install a 32 bit components to overcome the issue.
Thanks the issue seemed to boil down to an error in the tns names file for the way it was structured. SQL developer qualified it but when running a tnsping issues had occurred. Thanks for the help.
Thanks for the information both, I have double checked points with hashed password and TNS entry and generated high level logs with the following.24/05/2021 22:38:18[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIUbNJahFaCo2ud28NnWWjoA==24/05/2021 22:38:18[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted.24/05/2021 22:38:18[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIjOqwi0vS43Ca3HKunwDQn8BVL3vZGU/G24/05/2021 22:38:18[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted.24/05/2021 22:38:18[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSTPDB AppOwner-IFSAPP IALOwner-IFSINFO24/05/2021 22:38:18[IFSCRWebSetupVMT]-[GetAppSetting] Get the value for OpenReportPath from Web.config.24/05/2021 22:38:18[IFSCRWebSetupVMT]-[LoadReport] Loading report : D:\IFS\IFSShared\IFST NEW\Layout\test.rpt24/05/2021 22:38:18[IFSCRWebSetupVMT]-[LoadReport] DBUser = ifssys ,DBP
Thanks for the information both, I have double checked that the CWS is the 64 bit post re-config to make sure the correct hashed passwords are in the config file and that the Config file reflects a tested TNSname entry, I have high level logs which spit out the following after trying to preview test report. Log File - 24/05/2021 22:18:48[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIUbNJahFaCo2ud28NnWWjoA==24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted.24/05/2021 22:18:48[IFSCRWebSetupVMT]-[DecryptPassword] Decrypting Password : CgQIjOqwi0vS43Ca3HKunwDQn8BVL3vZGU/G24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Decrypted.24/05/2021 22:18:48[IFSCRWebSetupVMT]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSTPDB AppOwner-IFSAPP IALOwner-IFSINFO24/05/2021 22:18:48[IFSCRWebSetupVMT]-[OpenReport] File Name : test.rpt24/05/2021 22:18:48[IFSCRWebSetup
Thank you, I did try the INFSINFO schema prefix on the Datasource element which didn’t appear to work before i’m not too sure why, I have since retried which has corrected the problem thanks for you help.
I have created a new datasource element and lobby element with 1 column but still get the same results, I can also view this in the SQL query tool. I have created a new IAL looking at company column from company. EE Client - Aurena Client - Thanks.
Using my own account as opposed to IFSAPP and the code for the IAL is as follows - “CREATE OR REPLACE VIEW &IAL_OWNER..&OBJECT._IAL AS SELECT distinct company_id,emp_no FROM &AO..time_pers_diary_clocking_tab WHERE account_date BETWEEN TRUNC(sysdate + (NVL(1, 0) / 24) ) -1 AND TRUNC(sysdate + (NVL(1, 0) / 24) ) +1 AND proc_status != 'B' AND in_pers_class != 'F' AND in_stamp BETWEEN (sysdate + (NVL(1, 0) / 24) ) -0.75 AND (sysdate + (NVL(1, 0) / 24) ) AND NVL(out_stamp, (sysdate + (NVL(1, 0) / 24) ) +1) > (sysdate + (NVL(1, 0) / 24) )“ Thanks.
Thank you for the replies I have swapped out the alias to be something that would not be used as per normal for a reference and refreshed Aurena cache but still have the same issue e.g.
Thanks for the information there were some server features missing which have been installed and the hosts file updated.
This is no longer an issue it was down to a small naming discrepancy thank you to ever has taken a look.
Hi Mike, Thanks for the reply the version is 9. There is a very sporadic success rate on the send and it being picked up via JMS which is strange due to parameters being exactly the same on every send.
Hi Dsj, Thanks for the reply I have had errors where is says message of type Application_Message has no condition rules. If I hit re route a couple of times it will return. Thanks,
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
