• Font Size
  • S
  • M
  • L

Search via FAQ No.


  • No : 24349
  • Open Date : 2016/06/13 14:16
  • Print

[DataSpider Servista] How to verify when problem such as an error or decrease in response time have occurred.

How can I verify whether the problem lies in DataSpider Servista, connection host's application, or on which environment when error or decrease in response time have occurred?
 
Category : 

Answer

If there is an error, please start your investigation from the error message description.
*Please refer to FAQ No.24348 for how to investigate based off your error message.
 
If no error occurred or you cannot determine the problem from the error, then please make changes to your setting that pertains to the problem and retry the process to isolate the issue.
 
In general, by changing a setting which resolves an ongoing issue and creates a new problem, then most likely that setting is related to the cause. The followings are examples from the past.
 
Also, consider the followings and if there are no issues with the environment or with the connection host, please let us know that the cause of the problem is the product at the inquiry or comment.
 
 
1. Isolating the issue based off the error message
 
We will judge the problematic setting based on the error.
 
For example, error message regarding memory would imply to verify the memory consumption, and error message pertaining to network would imply to check network environment settings.
 
 
2. Isolating the issue based off any change made before or after the issue has started
 
For problems that have started from a particular point in time, check to see if any change were made in the settings before or after around the similar time frame. The following is an example of such situation.
  •  Environment Settings
  Confirm if any change in OS, firewall, and/or security software were made
  •  Settings on Connecting Host
  Confirm if any change were made on the database and application upon the time of problem
  •  DataSpider Servista Settings
  Confirm if any change were made on the global resources or components of DataSpider Servista
 
If there is such setting, try setting it back to the original to see if that would resolve the issue. If so, that would mean the error was caused by the change in settings.
 
 
3. Isolating the issue based off any data that changed before or after the error.
 
If error started from a particular point in time, check to see if any change in data and data size were made around the similar time frame.
 
For example, since the starting of the error, check to see if data number has increased or data (including special characters), which in the past not been part of correspondence, has been corresponding.
 
If there is any change in the number of data or the data itself, then try using the data prior to being altered to see if the problem is resolved or not. By doing this, you should be able to determine whether this is the cause or not.
 
 
4. Isolating the issue based off the usage of system resources
 
Verify to see whether CPU usage or memory depletion have occurred upon the time of error.
 
For example, if system resource such as CPU, memory, or disk is deficient, then it is possible that process may slow down or even abnormally terminate.
 
If the problem resolves by allocating ample amount of system resources, it is safe to determine that deficiency of resource is the cause.
 
 
5. Isolating the issue based off the order of process upon the time of error.
 
Verify the processes in order that occurred upon the time of error.
 
For example if it's taking unusually long time to send HTTP request to HTTP trigger, you would be able to isolate the issue by checking the following.
  •  Is HTTP trigger successfully receiving requests?
  •  Is the script successfully starting with HTTP trigger?
  •  Any particular script that is taking unusually long time to process?
  •  After script has ended, is it taking unusually long time for HTTP trigger to respond?
 
6. Isolating the issue based off other means
 
If a certain problem is occurring due to a process on DataSpider Servista, this can be verified by utilizing alternative options to see if you still encounter the same issue. The following is an example.
  • Purpose-specific adapters and generic adapters
For database adapter using JDBC driver for connection, if the problem occurs only on the purpose-specific adapter when testing both purpose-specific adapter and generic adapter separately, then the problem lies in the purpose-specific adapter.
  •  FTP Adapters
If the issue caused by FTP adapter is fixed upon using other FTP client, FTP process is the cause.