Locate import kickouts in AS/400

45 pts.
Tags:
AS 400
As a user where can I locate the import kickouts in AS/400?

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 9  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • ToddN2000
    What import kickouts and where are they coming from? More details are needed to give a good reply. 
    104,375 pointsBadges:
    report
  • Mallan
    The import kick-outs that I'm looking for it's coming from Human Resources status changes.
    45 pointsBadges:
    report
  • ToddN2000
    Who is the software vendor? Every software package has it's own files , menus and programs. Without know who wrote the system software, we don't know the steps.
    104,375 pointsBadges:
    report
  • Mallan
    The software is Kronos AS/400 iSeries., from my knowledge the kickouts are stored in the transaction assistant. But I'm not able to find it or find the navigation.
    45 pointsBadges:
    report
  • ToddN2000
    There are two Kronos database tables that contain all the information that you need to know about errors that are displayed on Transaction assistant. These tables are FAILEDXMLDATA and FAILEDXMLBODY. And here’s a query that will pull all person-level data out:

    select distinct a.failedxmldataid "Error ID",c.personnum "Empl ID",
    
           c.personfullname   "Employee Name",
    
           c.employmentstatus "Kronos Status",
    
           convert(char,c.employmentstatusdt,101) "Kronos Status Dt",
    
           convert(char,c.companyhiredtm,101) "Kronos Hire Dt",
    
           convert(char,b.updatedtm,120) "Error Dt/Time",b.errorcode "Err Code",
    
           substring(b.sourcedetails,1,25) "Import Source",
    
           rtrim(d.fieldname) "Field Name",
    
           substring(d.internalmesgtxt,charindex('The person',d.internalmesgtxt),190) "Error Message"
    
    from failedxmlbody  a,
    
         failedxmldata  b,
    
         vp_employeev42 c,
    
         importresult   d
    
    where a.failedxmldataid = b.failedxmldataid
    
      and substring(a.xmlreqbody,charindex('<PersonNumber>',a.xmlreqbody)+14,07)
    
          = c.personnum
    
      and charindex('<PersonNumber>',a.xmlreqbody) > 0
    
      and a.xmlreqkey = 0
    
      and b.importresultid = d.importresultid
    
      and b.updatedtm >= '@@Date to Display@@' + ' ' + '**Start Time (hh:mm)**' + ':00' 
    
      and b.updatedtm <= '@@Date to Display@@' + ' ' + '**End Time (hh:mm)**' + ':59.999'
    
      order by c.personfullname
    104,375 pointsBadges:
    report
  • Mallan
    Thank you for that, as a functional user without using a query what are the navigation to select transaction assistant?
    45 pointsBadges:
    report
  • ToddN2000
    Worst case is you can call Kronos for support. It's been a long time since I had access to Kronos due to my new position.
    104,375 pointsBadges:
    report
  • Mallan
    Thank you so much for everything Todd, you have been a great help
    45 pointsBadges:
    report
  • ToddN2000
    No problem. wish I could remember more.. been about 18 years since I worked with it directly.
    104,375 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: