Error in JDBC receiver channel

[Former Member]

Hi PI Gurus,

My scenerios Proxy to JDBC were running absolutely okey since yesteday. Today when I start testing these through SPROXY its giving me error as:

Error processing request in sax parser: Error when executing statement for table/stored proc. 'SysLink_Test_Results_View' (structure 'STATEMENT'): com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'SysLink_Test_Results_View'.

Is something changed at DB side?

Thanks,

Krishna Chauhan

[Former Member]

Hi All,

Thanks to all of you for your valuable inputs, at DB side also they are not able to see any tables. Problem lies at DB side.

Thanks,

Krishna

[former_member208856]

Contact to your JDBC system Administrator. They will check that the table is there in Database.

Also they will check they have written any storedprocedure on that table & it is executing while you are trying to fill data in table.

[Former Member]

Hi,

When I check the receiver CC in ESR using external defination, it give me a popup 'Table not found'.

It seems some thing is changed at DB side.

Even in Error message it says 'Invalid object name 'U_MeterTestTestSetResult'

Thanks,

Krishna

[Former Member]

Probably the view or Table was deleted at database side.

[Former Member]

Hi Krishna,

Please check if you are using the standard JDBC receiver structure as [link|http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/frameset.htm].

Also, check whether the table exists and your user has access to the database.

Regards,

Pranav

[Former Member]

Hi,

I have checked all the interfaces yesterday. all were running okey.

Even there were plenty of tables I was able to see through external defination. but when I am checking now it says 'No table found'.

Thanks,

Krishna

[Former Member]

Hi

The stored procedure has been removed from the DB or the role has been removed from the relevant user to access the stored procedure.

Regards

Monika

[Former Member]

Hi,

Thanks, but we are not using any store procedures.

Thanks,

Krishna

[Former Member]

The object 'SysLink_Test_Results_View' has issues.