• Font Size
  • S
  • M
  • L

Search via FAQ No.


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

[DataSpider Servista] “SQL Script” of [Search-Type SQL Execution] and [Update-Type SQL Execution] grays out

 [Search-Type SQL Execution] and [Update-Type SQL Execution] grays out. What are the cause and its resolution?
 
Category : 

Answer

Possible Cause
It is possible that the global resource value is not correctly set on the connecting host.
 
Countermeasure
Please verify your global resource value settings.
 
Specification Description
When opening property on DataSpider Servista, the information needed to display the property is obtained by connecting to the connection host. For this reason, if for any reason there is a connection issue with the connecting host, some of the properties (Example: SQL script) will be grayed out.
 
Issues in the Past
In the past, “SQLscripts” have been grayed out under the following instance.
  • Set value is incorrect
Extra space is mixed at the end of global resource name. Mistake between half-width characters and full-width characters exists.
  • Connecting environment is incorrect
IP address, host name, port number, etc. for the connection end's database is incorrect
 
Please check to see if any of the above situation corresponds to your situation. If it corresponds, please make the necessary correction and see if the problem resolves.