1 / 27

Texas Skyward User Group Conference Things to Watch Steve Outlaw

Texas Skyward User Group Conference Things to Watch Steve Outlaw. Session Title. Shown items throughout Open Edge and Skyward systems Customer Forum UAC DEP Firewall Services Skyward!5233 Account Type 2 database AI and Archive Files Dbscan.bat

fell
Download Presentation

Texas Skyward User Group Conference Things to Watch Steve Outlaw

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Texas Skyward User Group Conference Things to Watch Steve Outlaw

  2. Session Title Shown items throughout Open Edge and Skyward systems • Customer Forum UAC • DEP Firewall Services • Skyward!5233 Account Type 2 database • AI and Archive Files Dbscan.bat • Copy to Remote server.bat Cleanup Web and Report servers.bat • Delete-ADMSVR.lock Task Defrag Task • Reboot Weekly Task OEE –B • Task Manager – Memory OEE – Web Broker Logs • AGENT_RETRY_VAL=0 NPP log entries • SKYRAS 64-bit SkyConnect • Print Queue Maintenance Cleanup Guidelines pdf • 5506 Looses Trusted SSL Binding upon reboot

  3. https://support.skyward.com/DeptDocs/Corporate/Project%20Management/Public%20Website/Tutorials/SkywardCustomerForum.pdfhttps://support.skyward.com/DeptDocs/Corporate/Project%20Management/Public%20Website/Tutorials/SkywardCustomerForum.pdf • http://forum.skyward.com Customer Forum

  4. UAC

  5. DEP

  6. Firewall Service

  7. Skyward!5233 Account

  8. Type 2 Database

  9. AI and Archive Files

  10. REM USER Defined variables for drive letter and how long to keep backups/ai • REM USER Defined EMAIL SERVER AND ADDRESS INFORMATION • REM SET DATE AND TIME VARIABLE (Example skyback.120520080743AM) • Logit > %PROPATH%\backup\BackupLog.%DATE%%TIME%.log • REM SET DRIVE LETTER AND FOLDER PATH INFORMATION • REM Create directories if they do not exist • REM DELETE OLD BACKUP FILES (/D -2 will keep two days) • REM Delete the old AI AutoArchive files • REM Delete the old AI and Skyback files on NAS or UNC share - this command will search sub directories • REM CHECKS FOR DATABASES ON SYSTEM • REM ONLINE BACKUP SECTION • REM OFFLINE BACKUP SECTION • REM VERIFY BACKUP SECTION • REM FIGURES OUT CONDITION THAT APPLIES AND SENDS OUT APPROPRIATE EMAI • REM SENDS OUT EMAILS • REM CLEANS UP TEMPORARY FILES AND WRITES TO LOG FILE • REM RUNS SPECIAL OR EXTRA COMMANDS • REM Optional - Copy the backup folder to another server, /FFT is needed sometimes on NAS for date time functions Dbscan.bat

  11. REM BATCH FILE TO COPY AI FILES TO REMOTE SERVER EVERY XX NUMBER OF MINUTES • REM SCHEDULE BATCH FILE TO RUN USING SCHEDULED TASK EVERY 30 MINUTES • REM USER Defined variable for drive letter • if "%PROPATH%" == "" set PROPATH=D:\Skyward • REM DRIVE LETTER AND FOLDER PATH INFORMATION • set AiArchiveStuDir=%PROPATH%\archive\stu • set AiArchiveFinDir=%PROPATH%\archive\fin • set AiArchiveDir=%PROPATH%\archive • REM Robocopy.exe is an external command that is included on 2008 server when the OS is installed. It is not included in Windows 2000/2003. It can be located in the ?:\skyward\install\skyward_folders\backup folder; copy it to the ?:\windows folder. • REM If remote location is a NAS the /FFT option may be needed to get data\time function to work. • REM Optional - Copy the Student AI files to another server • REM RoboCopy %AiArchiveStuDir% \\ANOTHER SERVER\SHARE NAME • REM Optional - Copy the Finance AI files to another server • REM RoboCopy %AiArchiveFinDir% \\ANOTHER SERVER\SHARE NAME • REM Optional - Copy all AI files including sub directories to another server • REM RoboCopy %AiArchiveDir% \\ANOTHER SERVER\SHARE NAME /S Copy to remote server.bat

  12. REM CLEANS UP TEMPORARY FILES AND COPIES CONFIG FILES • copy %DLC%\properties\*.properties %BackupDir% • copy %ConfigDir%\*.* %BackupDir%\config\ • del %PROPATH%\Wrk\lbi* /A:H /F /Q • del %PROPATH%\Wrk\dbi* /A:H /F /Q • del %PROPATH%\Wrk\srt* /A:H /F /Q • del %PROPATH%\Wrk\qqq* /A:H /F /Q • del %PROPATH%\wrk\rcd* /A:H /F /Q • del %PROPATH%\Wrk\lbi* /F /Q • del %PROPATH%\Wrk\dbi* /F /Q • del %PROPATH%\Wrk\srt* /F /Q • del %PROPATH%\Wrk\qqq* /F /Q • del %PROPATH%\wrk\rcd* /F /Q Cleanup web and report server.bat

  13. A Scheduled Task named Delete-Admsvr.lock is created as part of the 10.2B Base Installer. This was added as a workaround to a known bug in OpenEdge 10.2B that causes the AdminService to fail to start on a server reboot. • This task runs ‘At Startup’ to run a command, c:\windows\system32\cmd.exe /C del ?:\skyward\dlc\oemgmt\config\admsvr.lock using System as user and Run whether logged in or not. • Issue: • This task has been created to make sure the file named admsrv.lock file is removed so AdminService starts. It has been found that during a restart or shutdown of the server that this file does not get deleted in a timely fashion so upon restart or reboot the file still exists and AdminService does not start. This problem may not happen on every reboot but if it does happen this means that Skyward is down. It is a documented bug in OpenEdge 10.2B. • Resolution: • 1. Check ?:\skyward\dlc\oemgmt\config folder to see if admsvr.lock file exists; delete it if it does exist, then start the AdminService normally. • 2. Check Task Scheduler to see if the Delete-Admsvr.lock task exists. • 3. If not, manually create the task. Delete-ADMSVR.lock Task

  14. Defrag Task

  15. shutdown -r -t 1 -f Reboot Weekly Task

  16. OEE -B

  17. Task Manager - Memory

  18. [12/09/21@08:11:03.953-0700] P-003032 T-004468 1 WS -- WTA: WebWrite() failed during npp_send with error: -70 size: 6484 sentbytes 0 retrycount 0. (6404) • [12/09/21@08:11:03.955-0700] P-003032 T-004468 1 WS -- WTA: npp_send() failed while sending terminate message! Error: -70. (6397) OEE- web broker log

  19. AGENT_RETRY_VAL=0

  20. [12/09/21@08:11:03.955-0700] P-003032 T-004468 1 WS -- WTA: npp_send() failed while sending terminate message! Error: -70. (6397) NPP Log Entries

  21. Windows Service named SKYxxxRAS • ?:\skyward\x64\crystal\skyras\skyras.exe SKYRAS 64-bit

  22. SkyConnect

  23. Print Queue Maintenance

  24. Cleanup Guidelines.pdf

  25. Locate the following 5506 property in the <CustomMetaData> section of the c:\windows\system32\inetsrv\config\applicationHost.config file, and delete the 3 lines shown below. • <key path="LM/W3SVC/X"> • <property id="5506" dataType="Binary" userType="1" attributes="None" value="oXiHOzFAMOF0YxIuI7soWvDFEzg=“ • /> </key> • The 5506 property is a legacy feature from Internet Information Services (IIS) 6.0 and is no longer needed. • Once this is done go into IIS manager, expand the server and choose the Skyward Web Site -> Edit Binding -> Choose the secure binding (443) -> Edit -> Reselect your SSL Certificate. 5506 looses SSL Binding upon reboot

  26. End of presentation – Extra space for other notes

  27. Texas Skyward User Group Conference THANK YOU FOR ATTENDING!

More Related