cancel
Showing results for 
Search instead for 
Did you mean: 

can't execute store prosedure

former_member192774
Participant
0 Kudos

Hi

VC 7.0/EP7.0sp14

.

datasource - jdbc informix 11.5. test connection ok. (JDBCFactory, IfxDriver.)

test data service - sobj.

audit log: {?= call my_procedure(?,?,?)} instead "execute procedure my_procedure(?)"

It's like Oracle call function syntax..

Where may be mistake?

Best regards

Vlad

Edited by: Skif on May 28, 2010 10:58 AM

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Skif,

I remember that you said that u are able to see the list of stored procedure but not able to drag to your storyboard.

I have the similar issue too as referred to the thread:

Resolved by a server restart. Hope it helps.

Cheers,

Sarah

former_member192774
Participant
0 Kudos

Hi, Sarah!

Thanks for attention. But it depend by informix version, i think...

11.5 work dropping, but not right interpret call "read metadata function"

I'm waiting support.sap answer.

Regards

Vlad

Former Member
0 Kudos

Hi Skif,

How was JDBC error being solved? Any news from SAP support?

I am still getting the error until now.

1. SAP JDBC System (to connect to MS SQL Server 2005 Stored Procedure)

2. Driver URL: jdbc:sap:sqlserver://<SQL Server IP>:1433;DatabaseName=TOMAS_DW

3. Driver Class Name: com.sap.portals.jdbc.sqlserver.SQLServerDriver

4. Test Connection: Success

5. Find Data in VC Story board: No result returned.

6. Execute reports developed using the stored procedure (developed when the JDBC system is still working): could not execute stored procedure.

When the system is down, we need to restart server so that the system work again and the stored procedure will work again. But it just last for a few days or even one day, the system will fail again.

Hope someone can really help me.

Thanks in advance,

Sarah

former_member192774
Participant
0 Kudos

Hi, Sarah!

My exchange letters w SAP is finished

Informix isn't supported в NW 7.0. (only <= 4.7)

I return to oracle now and thinking go on to the CE 7.2.

Regards

Skif