Skip to Content
0

ECC to MS SQL SLT

Feb 14, 2017 at 05:58 PM

118

avatar image

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.

10 |10000 characters needed characters left characters exceeded

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

0

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.

0
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Andrey Martynov
Feb 15, 2017 at 12:43 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Anil Eatrouthu Feb 15, 2017 at 04:56 PM
0

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.


slt-sql-error.png (18.6 kB)
Share
10 |10000 characters needed characters left characters exceeded
Anil Eatrouthu Feb 15, 2017 at 05:04 PM
0

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.


Share
10 |10000 characters needed characters left characters exceeded
Andrey Martynov
Feb 16, 2017 at 07:56 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded