December 22, 2016 at 5:17 am
Hi Gurus,
We are inserting data into a sql server via a two-way interface from SAP ERP, We were able to test it successfully in QA. We recently moved into Production but we were able to read data but unable to write to the database. Its giving us below error :
" Unable to execute statement for table or stored procedure. 'XYZTable' (Structure'Statement') due to com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'XYZTable' "
We are using the same user as in QA, all the code/settings are similar. But the data is not getting inserted into the table. But is able to read correctly.
Have tried to manually insert a row into the same table with the same user login from SSMS, it is working.
Please guide me what could be the possible reasons for this kind of error.
Greately appreciate any help!
Regards.
December 22, 2016 at 5:22 am
Considering that your error is "Invalid object name 'XYZTable'" this sounds like either a permissions error, or the statement is pointing the the wrong database/schema.
If you're object names are different from QA to Production, have you ensured every single one has been updated? if you're 100% it might be worth checking what SQL is actually being run. You could either do this with Extended Events, or start a trace up using SQL Profiler and filter it to only display statement run by the account that is trying to interact with the object XYZTable. You might find it's running SQL that isn't quite what you were expecting.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply