SQL Problem

Technical support

Moderators: Bob Cergol, Data Access, Cintac

SQL Problem

Postby jollt » Fri Aug 05, 2011 1:18 pm

Hi,

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

Image

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 :
Image

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

Thanks,
regards, Jérôme
jollt
 
Posts: 36
Joined: Tue Apr 15, 2008 3:03 pm
Location: Paris - France

Re: SQL Problem

Postby admin » Fri Aug 05, 2011 1:30 pm

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
User avatar
admin
Certified Dynamic AI Professional
 
Posts: 177
Joined: Thu Jan 01, 1970 1:00 am
Location: Copenhagen, Denmark

Re: SQL Problem

Postby jollt » Fri Aug 05, 2011 1:50 pm

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
jollt
 
Posts: 36
Joined: Tue Apr 15, 2008 3:03 pm
Location: Paris - France

Re: SQL Problem

Postby admin » Fri Aug 05, 2011 2:03 pm

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
User avatar
admin
Certified Dynamic AI Professional
 
Posts: 177
Joined: Thu Jan 01, 1970 1:00 am
Location: Copenhagen, Denmark

Re: SQL Problem

Postby jollt » Mon Aug 08, 2011 3:16 pm

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
jollt
 
Posts: 36
Joined: Tue Apr 15, 2008 3:03 pm
Location: Paris - France


Return to Technical Support

cron