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?
Answers
-
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
0 -
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?
0 -
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
0 -
Hi Helmut,
Do you mean this SQL Log?
0 -
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
0 -
0
-
Marta Lopez-Jurado its simple just like formal files renaming.
0 -
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...
0 -
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 .
0 -
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
1 -
your welcome .
0
