cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SENDER JDBC ADAPTER ERROR

Go to solution
Former Member

on ‎09-13-2006 12:59 PM

0 Kudos

Hi all,

We are having an extrange problem. We are trying to read some info from an oracle Database, but we have always this error :

Error: SQLException during query 'SELECT * FROM XX': java.sql.SQLException: ORA-00942: table or view does not exist: SQLException: ORA-00942: table or view does not exist

And WE have checked it, and the table is there. To understand what is happening we try with another table and it works, we have compare both an has the same features.

Any Ideas?

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎09-13-2006 1:01 PM
0 Kudos

Hi,

Pls check if your XI transactional user id is having necessary access permissions/authorisations in the DB/Schema to perform any activity.

Regards

Vishnu

Show replies
Show replies

Answers (1)

Answers (1)

bhavesh_kantilal
Active Contributor
‎09-13-2006 1:02 PM
0 Kudos

Hi,

Maybe the user id used in the JDBC adapter does not have the credntials to pull data from the table.

Just use the same SQL query from your DB client and check if it works.

Regards,

Bhavesh

Show replies
Show replies
Former Member
‎09-13-2006 1:12 PM
0 Kudos

MANY THANS ALL!!!

It was driving me crazy!!!

One more question this Oracle is an 7.2.3 version. And is not creating properly the XML in the inbound payload. Any idea? do you need more info?

bhavesh_kantilal
Active Contributor
‎09-13-2006 1:15 PM
0 Kudos

Hi,

This is the format in which your Data polled from the DB wiill be created,

<i><resultset>

<row>

<column-name1>column-value</ column-name1>

<column-name2>column-value</ column-name2>

<column-name3>column-value</ column-name3>

</row>

<row>

<column-name1>column-value</ column-name1>

<column-name2>column-value</ column-name2>

<column-name3>column-value</ column-name3>

</row>

</resultset></i>

Resultset is to be replaced by your DT / Message Type name.

In the Sender JDBC adapter, give the Document Name as the Message Type name and the Document Namespace as the Namespace of your Message Type.

Is this how you have created the source structure?

Regards

Bhavesh

Former Member
‎09-13-2006 1:21 PM
0 Kudos

Thanks for the answer, YEs my data type is :

<resultset>

<row>

<column-name1>column-value</ column-name1>

<column-name2>column-value</ column-name2>

<column-name3>column-value</ column-name3>

</row>

the problem is that in the inbound i have an error and finally i manage to open it and the is not column-name1 in the tags.

Thanks in advance

regards

Noelia

bhavesh_kantilal
Active Contributor
‎09-13-2006 1:26 PM
0 Kudos

Hi,

If your select query is

select empid, name from EMP

then the datatype will be,

<DT_NAME>

<row> 0 to Unbounded

<EMPID> </EMPID>

<NAME> </NAME>

</row>

</DT_NAME>

Is this how you have done it? Changed the column names?

Regards,

Bhavesh

Former Member
‎09-13-2006 1:29 PM
0 Kudos

it does:

<DT_NAME>

<row> 0 to Unbounded

<> value</>

<> value</>

</row>

</DT_NAME>

this is what i can see in the inbound payload.

Many thanks

Regards

Noelia

bhavesh_kantilal
Active Contributor
‎09-13-2006 1:32 PM
0 Kudos

> it does:

>

> <DT_NAME>

> <row> 0 to Unbounded

> <> value</>

> <> value</>

> </row>

> </DT_NAME>

> this is what i can see in the inbound payload.

Am not sure what the problem is.. is it solved?

Regards,

Bhavesh

Former Member
‎09-13-2006 1:38 PM
0 Kudos

No it is not solved, the problem is that the tags are empty

<> value</>

<> value</>

then the XML is not correct, and I have an error in the mappin.

The error in the mapin is the following:

com.sap.aii.utilxi.misc.api.BaseRuntimeException: Fatal Error: com.sap.engine.lib.xml.parser.ParserException: Name expected: 0x3e(:main:, row:4, col:4) at com.sap.aii.mappingtool.tf3.Transformer.checkParserException.

From my understanding, XI is not able to map it, because is looking for the name of the XML TAGS.

thanks

regards

bhavesh_kantilal
Active Contributor
‎09-13-2006 1:45 PM
0 Kudos

Now I get it..!!

Is this issue only with a specific database or are you facing this with all db installations?

Regards,

Bhavesh

Former Member
‎09-13-2006 1:52 PM
0 Kudos

It is only happening with oracle 7.2.3. I have test it with the same table and the same scenario in a oracle 9.i and it works. Do you think it is the oracle Version?

many thanks

Regards

Noelia

bhavesh_kantilal
Active Contributor
‎09-13-2006 1:58 PM
0 Kudos

hmmm..

Which Driver are you using. there have been some known issues due to Driver incompatibilty.

Take a look at this note : 867176 Question 5.

And also 941317

Regards,

Bhavesh

Former Member
‎09-13-2006 2:06 PM
0 Kudos

We have installed the ojdbc14.zip, because we have to extract from Oracle 7.2.3 and write in oracle 9.i. do you have any idea? I´m totally lost with this. From the notes I understand that My oracle version is not supported by SAP and oracle but i´m not sure??

Many thanks

Regards

Noelia

bhavesh_kantilal
Active Contributor
‎09-13-2006 2:12 PM
0 Kudos

Am not very sure either. But the little Understaning I have the JDBC drivers depends on the JDK being used by your XI server. Just check what JDK is used by our XI server.

XI homepage --> Adminstration --> you will find JDK version there.

A DB guru will be able to throw more light on this .

Regards,

Bhavesh

Former Member
‎09-13-2006 2:14 PM
0 Kudos

Hi Noelia,

>>>>We have installed the <b>ojdbc14.zip</b>

Is it ojdbc.zip or ojdbc.jar???

It should be ojdbc.jar

Regards,

Jai Shankar.

Former Member
‎09-13-2006 2:18 PM
0 Kudos

What a pity I cannot access to administration, because I´m a developer. But from the top of my mind i think it is JDK 1.4.

DO you know a DB guru how can help me? Maybe if I open another post? what you think?

Many many thanks

Regards

Noelia

Former Member
‎09-13-2006 2:22 PM
0 Kudos

I really don´t know the administrator of my XI server told me that he has installed

ojdbc14.ja

r following the guide https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

it is the HOW TO INSTALL DRIVES in JDBC adapters...

Many thanks

Noelia

Former Member
‎09-13-2006 2:25 PM
0 Kudos

Hi,

This is not a DB problem. The ony problem seems to be driver incompatiblity. Ensure, your BASIS team has installed the driver for the version you are using.

Regards,

Jai Shankar.

Former Member
‎09-13-2006 2:36 PM
0 Kudos

But I need a driver for an oracle 7.2.3 and oracle 9i do you think this is posible?

many thanks

Noelia

Former Member
‎09-13-2006 2:42 PM
0 Kudos

Not sure, try this link http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

Any way, I am not sure if you can install two different drivers one for Oracle 7. and another for Oracle9.

Regards,

Jai Shankar.

Message was edited by: Jai Shankar

Former Member
‎09-13-2006 3:02 PM
0 Kudos

What I think is the version of Oracle 7 is not supported by NONE of them oracle and Sap.

I going to check the link IlL let you know if if i found the solution

Many thanks

Noelia

Ask a Question