Data reader error - table is empty

Hi all,

I have a stranger thing case with the data read and the ODBC connections.

The thing is that when I try to configure a data reader, I can use all the tables in the RDB area but one: the "User" table.

The error message says: Table 'User' is empty.

The table is not empty and if I try to select the other tables there is no problem with the connection.

Also, I have no problems with the manual query to call the User table for the data read (obviously the table is not empty so the error message is senseless)... but that is a bit annoying for me and I do not know why this error happens only with this table.

Any suggestion?

Find more posts tagged with

Accepted answers

All comments

Helmut Heimann

Hi Marta Lopez-Jurado,

what exactly do you mean by "manual query"-- a query directly on your database using the same SQL statement in e.g. SQL Server? If so, using the same user credentials?

Is the table in your SQL database perhaps protected by security permissions?

Is the table located in the same schema as the other tables, you are able to retrieve data from?

Kind Regards,

Helmut

unknown

Hi Helmut,

The "manual query" means when you can modify the code in the Data Read for the query (see screenshot below).

In the SQL Server there is no problem using the same query (with the same user credentials).

The table is not protected by security permissions. In fact, with the manual modifications that you can see in the screenshot I can obtain the data from the SQL database and everything is ok.

The issue is when I try to select the 'User' table in the right side that the following message appears:

Do you know the reason that this error message appears?

Helmut Heimann

Hi Marta,

this message usually appears if the database table really does not contain any records or due to insufficient user rights, which both do not seem to be the case. Could you provide the details of the SQL log as well, please?

Regards,

Helmut

unknown

Hi Helmut,

Do you mean this SQL Log?

Ravichandra Aj

Marta Lopez-Jurado in addition to above comments its happening because of

-> .csv file name generated by board is having space in file name. remove that space from the filename of your .csv file and change the column data type according to your requirement .

-> keep format as Tab delimited.

i hope it will help you.

Regards,

Ravi

unknown

Hi Ravichandra Aj,

How do I change the filename of the .csv file generated by Board?

Ravichandra Aj

Marta Lopez-Jurado its simple just like formal files renaming.

unknown

Ravichandra Aj but I don't know which .csv file generated by Board you are referring.

The data reader is by SQL not by ASCII...

Ravichandra Aj

Marta Lopez-Jurado fine if the data reader is from sql rename the source file name whether it is a .csv nor any table . once even i faced the same problem but after renaming worked out for me.

if you need any help let me know .

unknown

Unfortunately, I can't change the SQL database but It may be possible that there is a kind of conflict with "User" as name of the table in SQL

Many thanks for yout help

Ravichandra Aj

your welcome .