Table import stuck

[#1]

Hello experts.

I am trying to import an external definition of a table using a JDBC reciever CC.

The JDBC is also used for interfaces and working fine.

When I search for the table in the DB - I get it alright, but when I mark it and press finish the GUI is just stuck in waiting.

I have looked in the CC monitoring and saw that the CC processed 2 messages - one after I clicked on display and

the other after I clicked finish.

Can anyone please assist?

I don't think this is a credentials issue, as I get the table name when I hit display...

[Former Member]

I have just tried to use a different DB (this time oracle) - and this time the import table worked in a couple of seconds. So I guess this is a problem with the DB.

Can anyone give me a reference to the credentials I need to use for getting the dbtab?

also - maybe this is because the PI is installed on oracle and the DB in question is MSSQL?

Any lead will be appreciated.

Thanks,

Imanuel Rahamim.

[Former Member]

Check if the user has "Execute" permission on the schema .

Reference : GRANT Schema Permissions (Transact-SQL)

- maybe this is because the PI is installed on oracle and the DB in question is MSSQL?

No. We can connect to N number of databases. All we need is to make sure the proper drivers are installed. However you have confirmed that other interfaces are working fine for the same database.

[Former Member]

The user is has administrator credentials on the DB.

I have logged in with the user and made a successful SELECT query on the table.

Will open OSS now as well...