Data Troubleshooting: Warning! One or more automation profile is importing stale files.

Comments

2 comments

  • Official comment
    Avatar
    Jay Schupp

    Step 3: Manually run the the IEexport.cmd file.

    This can be done by double-clicking on the file c:\ps_illuminateed_exporter\IEexport.cmd

    NOTE:  For PowerSchool hosted clients, the BIG IP Edge (VPN) client needs to be 'Connected'.

    Comment actions Permalink
  • Avatar
    Brandyna Bishop (Edited )

    PowerSchool Stale Data Troubleshooting:


    The Warning message comes up only if the files on the SFTP server are more than seven days old. There are four basic parts that could affect the flow of data from the PowerSchool scripts to the SFTP server: The PowerSchool Scripts, the SFTP account, the Task Scheduler and possibly the BIG-IP Edge client. The steps below should help you troubleshoot where the problem might be.

    Step 1: Manually log on to the SFTP server with your credentials to verify that they work. If they don’t work email help@illuminateed.com to have them check the account. If they do work move to Step 2.

    Step 2: Confirm that the Core Data files that are listed in the Core Data Automation Profile Settings are outdated on the SFTP server. If they are current email help@illuminateed.com and let them know. If they are outdated move to Step 3.

    Step 3: Manually run the the IEexport.cmd file.
    If there is any kind of a TNS error then you will need to contact PowerSchool to verify both the IP address and BIG IP Edge (VPN) client information - link
    If there is an error username/password are invalid go to Step 4.
    If the script runs fine check the SFTP server to see if the files have been updated. If the files are still old move to Step 4. If they are now current move to Step 5.

    Step 4: If Pearson is Hosting PowerSchool then check to make sure the BIG-IP EDGE client is running AND connected. If the BIG-IP EDGE was just started go back to Step 3 again. If PowerSchool is local then you will need to ask PowerSchool for their PSNavigator password.

    Step 5: If the files are not updated on the SFTP server do the following:
    Manually connect to the SFTP server with your credentials using a client like https://filezilla-project.org Sometimes the computer has to accept the certificate in order for the tool to complete the upload. If you are able to connect go back and run the tool again. If you are not able to connect then there may be a Firewall issue

    Step 6: The Task Scheduler is a very common problem. The Task is supposed to be setup under an Admin account and run every day sometime between 6-8pm. Here are some things you can check on your end:
    - Sometimes the computer that was running the task was shutdown…like over the break.
    - Make sure the task is setup under the admin account.
    - It might be best to delete the Task and recreate it.
    filezilla-project.org
    FileZilla - The free FTP solution
    FileZilla - The free FTP solution for both client and server. Filezilla is open source software distributed free of charge.

    1
    Comment actions Permalink

Please sign in to leave a comment.