on 10-29-2014 12:46 PM
Hello Experts,
My Scenario is RFC-JDBC where I am getting an error in RWB as
:Error when executing statement for table/stored proc. 'GRN_Header' (structure 'Statement_1'):
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid object name 'GRN_Header'..
DB team are maintaining two tables which is Header and Item.
GRN_Header is the table name which i have maintained in PI 7.1.
Please Suggest.
If you are sure that the table is available then i would suggest you cross check your channel configuration. Especially the database name.
If you are using SQL Server 2000 driver , then class name should be as follows:
Driver class | : | com.microsoft.jdbc.sqlserver.SQLServerDriver |
URL | : | jdbc:microsoft:sqlserver://<db_server>:port;databaseName=<db_name> |
Also you can even check if the table is available or not from ESR.
Importing Table Structures from a Database - Enterprise Services Repository - SAP Library
Message was edited by: Hareesh Gampa
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Check the suggestion from Anshul:
The connection string looks like: jdbc:microsoft:sqlserver://XXXXXX:PortNo;DatabaseName=XYZ
Also check if your table is associated with a schema name. In this case it will be like <Table>SchemaName.TableName</Table>
If you want to try:
Regards,
Nabendu.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ramashis,
Are you sure that the DB table doesn't have a schema?,to make the call like myschema.GRN_Header.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.