ECC to MS SQL SLT

[Former Member]

Hello All - We have a requirement to load data from ECC to SQL Server, running into issues when loading data from ECC to SQL Server, below is the error.

"dbif_rsql_table_unknown",

Any ideas on how to resolve the issue.

Thanks in advance.

[Former Member]

Andrey - I did verify all the authorizations, they are fine no issues with security.

As mentioned table structure is created without data on the correct DB and in right schema. Apart from the table a view is also created with the job name /1LT/000000124.

We are using ODBC [Microsoft][ODBC Driver 13 for SQL Server] on Solman box.

Not clear where to go from here, Any ideas or can you forward this to the team who can help ?

Thanks

Anil

[Andrey_M]

Hi Anil,

do you have this error permananetly or only once? do you have the problem with only one table? did you look in tx SM21? I think it could be also the problem with db connection.
Without debugging it's difficult to say what happens. In anyway i suggest you to create a ticket. DevSupport have to investigate the problem remotely.

[Andrey_M]

Hi Anil,

now it's clear that error occurs when program try to read data from logging table. It's not clear exactly why the error occurs. I have a guess, that it could be connectied with insufficion authorization for user that works with DB. Check the permissions and try to make a selection to this table and to other tables in your schema under same user.

If it's not help, I can suggest you to create a ticket to the according component.

[Former Member]

One more thing to add is i verified the target SQL Server database and i noticed that everytime i run the load a new view with the job name is getting created rather than the table itself. Not able to understand why a view is being created rather a table.

Please let me know if you have any questions or more info.

[Former Member]

Here is the error Andrey, Please refer to the table name in the screen shot, for some reason the table is defaulting the job name "/1LT/00000000024". I am using the Deviating table name, i tried all the options like using the table name as is, prefixing with connection name

SQL_ECC.CVERS and also dbo.CVERS nothing worked.

[Andrey_M]

Hi,
to understand what happens you have to give more information. Where and on what step this error occurs?
What table and what sql statement try to execute. Please, investigate the DUMPs.