- Top Category > General Questions > DataSpider Servista > [DataSpider Servista] There are tables which are not displayed even though it exists in the connection path DB
Search via FAQ No.
[DataSpider Servista] There are tables which are not displayed even though it exists in the connection path DB
After setting the connection path in the property settings of [Read Table] process of database system adapter and if you try to select the targeted table from the list, there are tables which are not displayed even if it exists in the connection path DB. If you input manually, then the extraction test is successful. Let us know the handling method.
- Category :
Answer
*Contents linked from this page might be in Japanese.
Any of the following might be the cause.
1. Limitation of display count of [Table Name]
■Specification Description
The upper limit for the display count of table list is set in the Global Resource.
■ Counter Measures
- From version 3.0 onwards
Change the upper limit for the display count of the table from the Global Resource Settings that is being used.
* The number of default displays is set to 500.
- Previous to version 2.4.x
Specify the table name directly.
2. Another Schema Table
■Specification Description
The table that belongs to the schema of the user specified in the [User Name] of the Global Resource is displayed in the list. Another schema will not be displayed.
■Counter Measures
When using the table of another schema, specify the table name directly including the schema name. Refer to the below mentioned Reference Information for the details of each function.
・[Global Resource Properties ] - [ Connection Settings ] - [ List Settings] field
[Adapter Limitations]-[Common to all Processes] field (* Link of [Oracle 11gR2] Adapter is published as an example.)