View Cart|Wish List|Login|Register | Thursday, February 09, 2012
 
 
 Search   ..:: Support &
    Service  Forum ::..
 
    Minimize
www.catalooksupport.com ::: another place for CATALooK.netStore support

    Minimize
SearchForum Home
     
  DotNetNuke  CATALooK.netStore  Recurring billi...
 Recurring billing errors - need a fix ASAP
 
 3/11/2009 4:42:01 PM
dshapovalov
19 posts
www.scienceofmassage.com


Recurring billing errors - need a fix ASAP
After I made sure that DNN is not unloaded, I'm still getting these errors, so it's not related to DNN unloading. I need a fix for this issue ASAP, I can't sit everyday and manually fix the mess that scheduled task creates.
 
 
CATALooK.RecurringBilling, CATALooKStore
CATALooK Recurring Billing Successfully 		0.033 True S: 3/11/2009 12:28:55 AM
E: 3/11/2009 12:28:55 AM
N: 3/11/2009 12:33:55 AM
CATALooK.RecurringBilling, CATALooKStore
EXCEPTION: System.NullReferenceException: Object reference not set to an instance of an object. at CATALooK.Templates.LoadTemplates(Hashtable templates, String cacheKey, String TemplatesPath) at CATALooK.Templates.GetTemplate(String name, Int32 PortalID, String Skin) at CATALooK.Forms.RenderSubscriptionForm(Int32 orderId, Int32 UserID, Int32 PortalID) at CATALooK.RecurrBillJob.SendOrderConfirmationEmail(Int32 orderId, Int32 CustomerID, Int32 PortalID) at CATALooK.RecurrBillJob.RecurringBilling(Int32 PortalID) at CATALooK.RecurringBilling.DoWork() 		0.203 False S: 3/11/2009 12:20:53 AM
E: 3/11/2009 12:20:54 AM
N: 3/10/2009 11:59:32 PM
CATALooK.RecurringBilling, CATALooKStore
EXCEPTION: System.NullReferenceException: Object reference not set to an instance of an object. at CATALooK.Templates.LoadTemplates(Hashtable templates, String cacheKey, String TemplatesPath) at CATALooK.Templates.GetTemplate(String name, Int32 PortalID, String Skin) at CATALooK.Forms.RenderSubscriptionForm(Int32 orderId, Int32 UserID, Int32 PortalID) at CATALooK.RecurrBillJob.SendOrderConfirmationEmail(Int32 orderId, Int32 CustomerID, Int32 PortalID) at CATALooK.RecurrBillJob.RecurringBilling(Int32 PortalID) at CATALooK.RecurringBilling.DoWork() 		2.78 False S: 3/11/2009 12:02:04 AM
E: 3/11/2009 12:02:07 AM
N: 3/10/2009 11:59:32 PM
CATALooK.RecurringBilling, CATALooKStore
CATALooK Recurring Billing Successfully 		0.124 True S: 3/10/2009 11:54:32 PM
E: 3/10/2009 11:54:33 PM
N: 3/10/2009 11:59:32 PM
CATALooK.RecurringBilling, CATALooKStore
CATALooK Recurring Billing Successfully 		0.64 True S: 3/10/2009 11:49:28 PM
E: 3/10/2009 11:49:29 PM
N: 3/10/2009 11:54:28 PM

Sent: Sunday, March 08, 2009 2:00 AM
Subject: Recurring billing errors

I use Catalook to do recurring billing and I have CATALooK.RecurringBilling setup in a scheduler. My hosting provider periodically unloads DNN and as recurring billing usually happens at midnight when there is no traffic, scheduled task does not run until the first request in the morning. When such request comes in the morning I get in most cases the following error in the scheduled task:

CATALooK.RecurringBilling, CATALooKStore
EXCEPTION: System.NullReferenceException: Object reference not set to an instance of an object. at CATALooK.Templates.LoadTemplates(Hashtable templates, String cacheKey, String TemplatesPath) at CATALooK.Templates.GetTemplate(String name, Int32 PortalID, String Skin) at CATALooK.Forms.RenderSubscriptionForm(Int32 orderId, Int32 UserID, Int32 PortalID) at CATALooK.RecurrBillJob.SendOrderConfirmationEmail(Int32 orderId, Int32 CustomerID, Int32 PortalID) at CATALooK.RecurrBillJob.RecurringBilling(Int32 PortalID) at CATALooK.RecurringBilling.DoWork()

 
While I'm trying to do my best to keep DNN alive by using hosting uptime services and pinging my site as often as I can, it still is like playing Russian roulette as there can be a situation when after DNN is unloaded next scheduled time comes before ping resurrects DNN back online and therefore I get the error above. The issue is that when it happens all orders which suppose to be recreated and re-billed automatically instead get created but stay in unpaid state and I have to go manually through all created orders and re-bill them manually using credit card information from them previous order. It's a lot of work, it's manageable so far as I only have a handful of orders on recurring billing per day, but if I grow and I'm going to have a few dozens orders to go through manually each day, it will really suck as I will have to babysit the cart every day or have a bunch of pissed off customers who lose their access to subscriptions areas.
 
    Please advise, what should I do to fix this issue. Catalook 5.5.6, DNN 4.8.4, hosting GoDaddy.com.
 
    It seems that that order creation needs to be transactional so if such error happens, unpaid orders should not be created, so next time re-billing would happen it would work successfully without manual intervention.

With respect,
 
Dmitry Shapovalov
 Page 1 of 1
NextPreviousNo Rating
  DotNetNuke  CATALooK.netStore  Recurring billi...

    Minimize
www.excommerce.com ::: eXcommerce are a dedicated reseller of Catalook. If you want the features of catalook without the hassle of setup and maintenance and want some extra support options please check our services.
      

References / Live Stores | Forum | Trial Downloads | Resource Directory | Release History | Support Requests | Referral Program | Contact
CATALooK |  Terms Of Use |  Privacy Statement
Copyright 2002-2010 CATALooK