Search results

  1. kasundha

    Multiple Failed login attempts records in audit log

    I generated this report from a customised audit logs report. ID 10501 In our system login screen, we have set the maximum failed login attempts limit to 5. However, the audit log report shows over 20 failed login attempts for this user. Does anybody have any idea about this...
  2. kasundha

    Auditing tables are not showing in Tableau

    I have granted SQL access for the following tables, but these tables are not showing on Tableau. -306-_aud-file-policy -305-_aud-field-policy -304-_aud-event-policy -303-_aud-event -302-_aud-audit-policy -301-_aud-audit-data-value -300-_aud-audit-data OpenEdge...
  3. kasundha

    Restore a DB without audit data

    I need to restore a progress DB, excluding the audit data area. DB backup has already been taken with the Audit Data Os :- AIX Progress DB version:- 11.7.19 Note:- We are still doing the DB migration process, Linux + OE 12.X
  4. kasundha

    Openedge Rest API error

    OE Version:- 12.8 Evaluation Edition. I have developed a sample code to test Rest API and I'm getting this error while sending the request through Postman.
  5. kasundha

    use server login as a db login

    OpenEdge version:- 11.7.19 (Migration process to OE 12 is ongoing) Server AIX. When I want to make any schema changes(upload df files) to the DB, I log in to the AIX server with the user account and then log in to the DB with another account (DBA - *created in _user table ). Is there any...
  6. kasundha

    Issues after installing the service pack 11.7.19

    I have installed the service pack 11.7.19 and after the installation when opening the developer studio, following error messages are displaying. Previous version : - 11.7.3 service pack :- 11.7.19
  7. kasundha

    Track Structural Changes in DB (Auditing not enabled)

    OE 11.7.19 OS : - AIX 7.2.0.0 As an audit requirement, I want to track structural-level changes in the DB. Adding new extents. Loading DF files. online backups. or any other changes in the db. (Not data level changes).
  8. kasundha

    Question DB user-level password policy implementation OE 11.73

    I'm using _user table to manage user accounts in the system but I'm using application-level password policy to manage user's passwords. I need to implement a password policy in the database. scenarios as follows. for password complexity. password renewal timeframes. password history (cannot use...
  9. kasundha

    XIRR Function

    I need to use XIRR function with openedge 10.2B version.
  10. kasundha

    Remove unwanted large spaces in string value

    I need to remove large spaces from a given string value before updating the db. eg: - 'PTPPromise to Pay :- 07/05/2019 , 13500.00 , Walk In , , RelativesMet customer wife . T.p.0702462817.'
  11. kasundha

    Disconnect DB is not working

    Hi all, I have scheduled an automated process to generate a system report. after the process completed it needs to disconnect the DB connection and close the program. the problem is, the program(Screen) is closing properly but the session in the DB server is still in the active mode and I have...
  12. kasundha

    Speedup For Each Code

    Hi, I have a openedge code and it gets more than 10 hours to run. first table has 40K + records and other tables have about 5 records per each record of first table. can you give me any suggestion to improve the efficiency of this code. -------------------- FOR EACH corpdata.ArrearsRpt...
  13. kasundha

    Openedger 10.2B colour scheme not appearing

    operating system: - windows 10 openedge version :- 10.2B I installed openedge 10.2B newly to my pc and it is not showing the colour pallet. I tried two times by reinstalling. here i attached the screen shot. please let me know how to fix this error.
  14. kasundha

    call multiple screens in one procedure sequentially

    I wrote a code (.P file) to run two different screens(.W files) sequentially. after closing the first screen, program quit the execution without running the second program. do you have any experience regarding this...? RUN MIS6I.w. RUN MIS2-MARKETING.w.
  15. kasundha

    best way to handle table locks

    What is the best way to handle table locks in openedge codes. sample code ============================ FOR EACH TT-TVS-DETAILS WHERE TT-TVS-DETAILS.T-RCPTNO = '' AND TT-TVS-DETAILS.T-FACNO <> '': FIND FIRST TEMP1 WHERE TEMP1.FACNO = TT-TVS-DETAILS.T-FACNO AND (TEMP1.SETAMT > 0 OR...
  16. kasundha

    save as not working with excel + openedge 10.2b

    i used an excel files to view reports(DASHBOARD) data to system users. 11 excel files are generating by this report. currently i have to save each report separately in everyday. i just want to automate the report and send these reports to relevant user. so i want to save those files in...
  17. kasundha

    Question Smtp Mail Setup With Office 365

    I have setup an email send program using officer 365 mail and it is not working properly. hear i attached the error log. 11/10/17 17:36:13 ************** ****** New Group ******* ************ Socket email started Input Parameters EmailFrom = kasun@abansfinance.lk EmailReplyTo =...
  18. kasundha

    Smtp Mail Setup

    im trying to setup a program to send emails through smtpmail.p. I had an error in error log. if smtpmail.p program is outof date, please suggest me a new method. thank you
  19. kasundha

    How To Use Save As Command For Excel File

    hi all, im using excel sheet template in my program and i want to save it in different location with different name. this is my sample code. DEFINE VARIABLE chExcel AS COM-HANDLE NO-UNDO. DEFINE VARIABLE chWorksheet AS COM-HANDLE NO-UNDO. DEFINE VARIABLE chWorkbook AS COM-HANDLE NO-UNDO...
Back
Top