Hello again, I have one more question about the failed application messages.After i have achieved to stop them failing, i wanted to delete failed messages in the list.Delete button is inactive in Solution Manager\Integration\IFS Connect\Application Messages.There is a background job, cleanup of finished messages, but no for failed messages.I have tried to execute cleanup function for state “Failed”. But it took 60 minutes and locked. My guess, because of there are so many failed messages. Like almost 8 million.What can i do for that ? Sincerely.
Hi,Thank you all for your helps. @anmise I have solved the problem with your lead. Thank you so much.Sincerely.
Thanky you for your answer @RichardM . I’ll keep this info.After I asked you, I have recognized that my problem was result from LOGON DATABASE trigger.Maybe someone needs this information too. Sincerely..
Hello @Jonas Feigl ,It occurs for all jobs I execute manually. It seems about session language as you have told. Version is IFS10. How can i prevent that ? Regards..
Hello @RichardM , Did you solve your problem at the end ?If so, could you please share with me ? Regards..
Hi @ChanakaAmarasekara , I‘ve found in the layout tree navigator what I need to do.And have solved the problem.Thank you so much for your guiding.Best Regards..
Hi @ChanakaAmarasekara ,I have tried that, but it doesn’t work in a kind of annoying way. I think this is about this report’s structure.There are too many tables in the report, every table is in page body even the table actually used as a header.Now I’ve tried something else, have used “page break before” for first table in the page body, it works and seperates two datas. But there is another problem, after every two pages it prints an empty page. Do you have any idea for that ? Thank you, Sincerely.
Hello,As i mentioned my previous replies, We have seperated our IT users and given them needed privileges.Now i have noticed that the user cannot grant any schema.views to other users, but IFSAPP can do.Example: grant select on IFSINFO.TEST_VIEW to X_USERWhat privileges I must give IT users to able to do that ? Sincerely..
Thank you for your helpful answer.Best Regards.
Hi @hhy38, I’ve tried to_char(SYSDATE, 'YYYY-MM-DD-HH24.MI.SS'). Result is the same. It is inserted as 21/02/0025 to table.Regards.
@Lee Pinchbeck yes I’ve. Unfortunatelly it doesn’t work. Sincerely.
Hi @Lee Pinchbeck Thank you for your answer. Actually I wonder if there is another way ? I have the same problem but mine is in PLSQL.You can see what i’ve experienced below.I am looking for solution of that problem. Do you have any idea ?
Hello @hhy38 , Have you solved your problem ?If you've, could you please share the solution ?
Hi @Wiktor,I have checked and tried to use other views with comparing your ‘&inventory_part.contract’ example .It seems we should use Parent Key columns. (FLAGS= P---L )ACTIVITY doesn’t works. But PROJECT_ACTIVITY works. Thank you so much.Best regards.
Hello @kenny.sjbk , My purpose is to make list for report parameter.I have tried CUSTOMER_INFO example and it works. But when i have tried a simple query as below it doesn’t work. Doesn’t show any project_id in list of project_id parameter. Is that clearer for you now ? Thank you.
Hello,I’m trying to prepare a quick report with parameter has default values. (IFS10) Like given example in F1 development guide;“SELECT * from customer_info where customer_category_db = '&CUSTOMER_INFO.CUSTOMER_CATEGORY_DB'” I have used “ where t.project_id LIKE '&PROJECT_LOV.PROJECT_ID' ” but this is not working. Does anyone know why ? What is difference between them ?
We have seperated IT users for analysis or investigative works and created new permission set for system privileges.We continue to use IFSAPP for developments. Thank you all
Thanks for your answers..@Technical Outlaws We about 10 people use IFSAPP for analysis and development. So when everyone use same user , it can be hard to find something from logs. That is why we don’t want to use IFSAPP.
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.
