4/1/2015
PowerCampus Integrations and
Troubleshooting
Preethi Anish & Jose Castillo
Ellucian
April 13, 2015
11934
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
1
Session rules of etiquette
• Please turn off your cell phone/pager
• If you must leave the session early, please do so as discreetly as possible
• Please avoid side conversation during the session
Thank you for your cooperation!
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
2
Introduction
Purpose of the Presentation
This session is a walkthrough of data flow between PowerCampus and different
applications integrated with it. It will help one to understanding the technical side
and troubleshoot the integration pieces.
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
3
1
4/1/2015
Agenda
•
Concept of Integration Services and Service Bus
•
Overview of PowerCampus Integrations
•
Troubleshooting Techniques
•
Examples of PowerCampus Integration
•
How to Troubleshoot
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
4
Integration Services and Service Bus
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
5
Integration
What is Application Integration?
Application Integration is the process of bringing data from one application to
another application.
Different ways of Integration
SQL Integration Services
Custom Applications
Web Services
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
6
2
4/1/2015
Integration Services (SOAP API and RESTful API)
Web Services
Web Services is a method of communication between two applications or
electronic devices over the World Wide Web.
SOAP API
SOAP communication protocol via internet or intranet
SOAP is based on XML
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
7
Integration Services (SOAP API and RESTful API)
RESTful API
REST supports multiple data formats like XML and JSON
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
8
Service Bus (Publisher and Subscriber)
Service Bus is a middleware that acts as a bridge between applications,
especially on a network.
Service Bus uses publisher and subscriber which provides an asynchronous
communications protocol.
PowerCampus uses the NServiceBus architecture.
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
9
3
4/1/2015
PowerCampus Integration
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
10
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
11
PowerCampus Integration
Troubleshooting Techniques
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
12
4
4/1/2015
Troubleshooting Techniques
o Refer to the documentation
o Check any change in hardware or software updates
o Check if message is an
Info ,
Warning or
Error
o Check the logs
o Check if the problem is replicable
o Consult technical support
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
13
PowerFAIDS Integration and
Troubleshooting
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
14
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
15
PowerFAIDS Integration
5
4/1/2015
PowerFAIDS Troubleshooting
PFI Integration Tool
o DB error logs
Integration Services
o PowerShell Scripting Logs
o All events log
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
16
PFI Integration Tool
PFI Integration tool logs the errors in PowerCampus database
PFIntegration and PFIErrorlog tables
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
17
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
18
PowerShell Scripting Logs
Import Preview File
6
4/1/2015
Integration Services Logs
C:\inetpub\wwwroot\PowerCampusSOAPServices\App_Data
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
19
Great Plains Integration (Service Bus)
and Troubleshooting
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
20
Great Plains Integration using Service Bus
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
21
7
4/1/2015
Great Plains Integration Troubleshooting
Service Bus
o Services are running
o Event Viewer
o Private Error Queue
Integration Services
o All events log
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
22
Services
Following Services should be running for PowerCampus Application Server:
o PCPublisher
o PowerShell Subscriber
o MSMQ Publisher
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
23
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
24
Services
Great Plains Application Server:
o eConnect Integration Services
o eConnect Incoming Service
o eConnect Outgoing Service
8
4/1/2015
PowerCampus Event Viewer
PowerCampus Server > Event Viewer > Applications and Services Logs >
PowerCampus Log
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
25
eConnect Event Viewer
Great Plains Server > Event Viewer > Applications and Services Logs > eConnect
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
26
PowerCampus Private Error Queue
Computer Management > Services and Applications > Message Queuing > error
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
27
9
4/1/2015
Integration Services Logs
C:\inetpub\wwwroot\PowerCampusSOAPServices\App_Data
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
28
eTranscript Integration
and Troubleshooting
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
29
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
30
eTranscript Integration
10
4/1/2015
Etranscript and Troubleshooting
Integration Services
o All events log
Service Bus
o Services are running
o Event Viewer
o Private Error Queue
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
31
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
32
eTranscripts Cloud Diagnositics
Integration Services Logs
SOAP API
C:\inetpub\wwwroot\PowerCampusSOAPServices\App_Data
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
33
11
4/1/2015
Integration Services Logs
WEB API
C:\inetpub\wwwroot\PowerCampusWebAPIServices\App_Data
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
34
Services
Following Services should be running for PowerCampus Application Server :
•
PC Publisher
•
PowerShell Subscriber
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
35
Event Viewer
PowerCampus Server > Event Viewer > Applications and Services Logs >
PowerCampus Log
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
36
12
4/1/2015
PowerCampus Private Error Queue
Computer Management > Services and Applications > Message Queuing > error
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
37
Thank you!
Preethi Anish
Jose Castillo
[email protected]
[email protected]
Please complete the online session evaluation form.
• Via your registration account Log into your registration account at
https://ellucianlive2015.smarteventscloud.com/connect/publicDashboard.ww
•
choose the link to “Surveys.”
Session ID 11934
© 2015 ELLUCIAN. CONFIDENTIAL & PROPRIETARY | Session 11934
38
13