SQL Problem

[jollt]

Hi,

when I call a report from my application, I get this error :



When I execute the same report directly on DAI, I do not have any error : the report works.

I checked the trace (Administration/Activities/Log Alerts/General alerts) and can see my error :


Is the any trace log where I can see the last generate sql sentence?

Thanks,
regards, Jérôme

[admin]

Hi Jerome,

I'm not sure that any sql had been executed at this point - can you share the call you make from the application?

Otherwise you can monitor the incoming traffic to your database server.

Best regards

Bo

[jollt]

Hi Bo,

I use an API I develop to open the reports in DAI which works correctly.
The report I try to access was working this morning, I just change my sql request :

This morning I use :
select GlobRisReport.* from table (GLOB_RIS_REPORT(43, 'FRANCAIS', 683)) GlobRisReport

Then I add a parameter to my stock procedure : @userid
select GlobRisReport.* from table (GLOB_RIS_REPORT(43, 'FRANCAIS', 683,'@userid')) GlobRisReport

If I execute this request on DAI (database menu), it works
If I execute the report based on this request on DAI, it works
If I call the report from my application with this request, I have the sql error

I use this syntax with orther reports and othe stock procedure and it works

Regards,
Jérôme

[admin]

Thanks,

I was after the "final" url that the api generates - if you can intercept that, it would be interesting. You are welcome to send as a private message if you want.

Best regards

Bo

[jollt]

I might have a problem with developoment environment (where it's not working) as it's works perfectly in my production environment.

Thanks,

best regards,

Jérôme