1. 

   myDBR Team, Key Master

   What are the parameters for your report? Can you show the code until the first begin?

   --
   myDBR Team
2. 

   vsivaprabu, Member

   Thanks for your reply.

   Here the my report procedure.

   CREATE PROCEDURE sp_DBR_Daily_Report(userid int,SoldDate int,StartDate date,EndDate date)
   BEGIN

   END

   userid parameter sp

   create procedure sp_group(mydbr_param1)
   BEING
   select id,name from users where group_id= mydbr_param1;
   END;

   Thnaks,
   Siva
3. 

   myDBR Team, Key Master

   You have a circular reference. The userid parameter's query (sp_group) refers to first parameter which is the userid-itself. You do not have the group parameter at all. Your URL's 'u1' refers to the userid parameter. Please see the documentation about the parameter handling.

   --
   myDBR Team
4. 

   vsivaprabu, Member

   Hi mydbr Team,

   When I load the URL through Iframe and hit the url directly I getting following fatel error.

   Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 34467037488 bytes) in Unknown on line 0

   Please help to fix this issue. This issue happened after upgrading 4.0.0 to 4.3.4.

   I have changed in php.ini
   memory_limit 1024M
   max_execution_time 3600000
   max_input_time 3600000
5. 

   myDBR Team, Key Master

   Please contact support email for this. We did check the server as per request and it seems to be a server configuration issue.

   --
   myDBR Team

Reply

You must log in to post.