Unable to fetch the list of table

[rahulmehta]

Hi team,

I'm able to fetch the list of schema's but while fetching the list of table from source side getting this error:

SYS-E-HTTPFAIL,Command get_table_list failed when getting the list.
SYS,GENERAL_EXCEPTION,Command get_table_list failed when getting the list.

Source: Microsoft Azure SQL Managed Instance

And after fixing the table also not able to retrieve the data:

Can you please help me to sort this issue?...

[RajV]

I am trying to do the same wherein the MS SQL is on PAAS and I used Type as "Microsoft Azure SQL (MS-CDC)". I can see the schemas but could not get the list of tables.

[john_wang]

Hello @rahulmehta , @RajV ,

Thanks for reaching out!

In general it's caused by privileges. Please confirm the Required permissions are met in the account which used to connect to SQL Server.

If the problem persists, the best troubleshooting way is open Replicate Console --> Server --> Logging --> Server Logging Levels --> SERVER, drag and set the logging level to Verbose, save the setting. Then recreate the errors and check the Replicate Server log file to get more detailed information about the root cause. The default log file is "C:\Program Files\Attunity\Replicate\data\logs\repsrv.log" (on Windows).

A sample of the setting:

Hope this helps.

Regards,

John.

[john_wang]

Hello @eksmirnova ,

First, please open the SERVER perspective:

Then enable the SERVER component:

After you get the available tables list, check the "repsrv.log" (Windows platform default location is "C:\Program Files\Attunity\Replicate\data\logs").

Hope this helps.

Regards,

John.