topic E00040 when Creating Subscription from Customer Profile in Integration and Testing

E00040 when Creating Subscription from Customer Profile

griffira59 — Mon, 22 May 2017 17:04:34 GMT

I am using the CIM and ARB modules in the sandbox environment. I am also using the PHP API. The code that is now failing (it was working just a few weeks ago) first creates a Customer Profile from a TXN. Next, the code makes a call using a method much like the createSubscriptionFromCustomerProfile method from your API documentation. It's during this method call that the E00040 error is thrown. The API documentation states that when this error is thrown, either the Customer Profile ID, or the Payment Profile ID could not be found. However, you can check the Authorize system, and the ID's ARE there.

I have read several posts going back a few years with developers asking about the exact same error as I am. If there is a solution, please be so kind as to point me to the correct message post. However, from all the posts that I have read, there never seemed to be a solid answer.

BTW, I too can take the exact same method parameters that were used when the E00040 was thrown, try them again, and this time the subscrition is created; no errors. Please help.

Re: E00040 when Creating Subscription from Customer Profile

RichardH — Mon, 22 May 2017 17:34:34 GMT

Hello @griffira59

If you wait a few minutes before using createSubscriptionFromCustomerProfile, does it work properly?

I will also check with our operations team to see if we're experiencing latency in the sandbox.

Richard

Re: E00040 when Creating Subscription from Customer Profile

griffira59 — Tue, 23 May 2017 17:57:10 GMT

Hello Richard,

As a matter of fact, I have been experimenting with adding delays of various amounts to my code with PHP's sleep() function. To recap what I mentioned earlier, my PHP script first uses the Authorize CIM API to create a Customer Profile from a transaction. Next, I attempt to "createSubscriptionFromCustomerProfile" using the Customer Profile ID and Payment Profile ID that was just returned by CIM. It is at this exact point that the E00040 error is thrown, stating that the new Customer Profile ID and Payment Profile ID "Could not be found."

If I add at least a 15-20 second delay AFTER the Customer Profile is created, but BEFORE making the call to "createSubscriptionFromCustomerProfile," then the Subscription is created successfully. Obviously, this is a bit of a kludge. I would hate to think I had to depend on this when we go into production very soon.

With as many posts (going back several years) on this, or very similar issues, I would have hoped there would be a more solid solution. Any help/ideas will be greatly appreciated.

Re: E00040 when Creating Subscription from Customer Profile

RichardH — Tue, 23 May 2017 18:32:19 GMT

@griffira59 The sandbox should not require this long of a delay. I will report the problem to operations.

Richard

Re: E00040 when Creating Subscription from Customer Profile

sehen30303 — Sun, 28 May 2017 18:12:49 GMT

Same trouble! Any benefit response?

Re: E00040 when Creating Subscription from Customer Profile

BrandonSurowiec — Fri, 21 Jul 2017 16:11:25 GMT

It looks like after you create a new customer profile via a transaction you have to wait 15 sec or so to call the createSubscription request w/profile and payment ids otherwise it returns the E00040 error that says it is not found.

Is there any ETA to getting this fixed so we don't have to introduce a delay before attempting to create the subscription?

Re: E00040 when Creating Subscription from Customer Profile

RichardH — Fri, 21 Jul 2017 16:14:23 GMT

@BrandonSurowiec

Is this occuring in sandbox or production for you?

Richard

Re: E00040 when Creating Subscription from Customer Profile

BrandonSurowiec — Fri, 21 Jul 2017 16:31:02 GMT

Sandbox.. and it makes me scared to push to production :P

Re: E00040 when Creating Subscription from Customer Profile

RichardH — Fri, 21 Jul 2017 16:40:57 GMT

@BrandonSurowiec

I've reported the issue and am waiting for a response from operations. Our production servers are scaled significantly higher and have more rigorous monitoring and alerting for these types of issues.

Richard

Re: E00040 when Creating Subscription from Customer Profile

BrandonSurowiec — Tue, 25 Jul 2017 17:40:52 GMT

@RichardH I just tried in production and it failed.

In the same request I...

create a transaction using a Token (createTransactionRequest)
create a customer profile from the transaction charge (createCustomerProfileFromTransactionRequest)
use the given customer profile id and payment profile id that was returned to create a subscription via the two profile fields and receieved the 00040 error.

...
'profile' => [
    'customerProfileId' => $authorize_customer_id,
    'customerPaymentProfileId' => $authorize_payment_id,
],
...

I'll have to work around it by setting up the subscription on a separate request at a later time because it works if I wait a bit. I'm pretty sure doing it all in one go used to work a few months ago, but it no longer does now.

Re: E00040 when Creating Subscription from Customer Profile

RichardH — Tue, 25 Jul 2017 18:12:15 GMT

Hello @BrandonSurowiec

I've escalated your issue to the product support specialist team. Could you also create a support ticket if you have not already so your issue is properly tracked through resolution.

Richard

Re: E00040 when Creating Subscription from Customer Profile

BrandonSurowiec — Tue, 25 Jul 2017 19:10:55 GMT

Done, thanks :)

Re: E00040 when Creating Subscription from Customer Profile

RichardH — Tue, 25 Jul 2017 19:48:41 GMT

Thanks @BrandonSurowiec

I spoke with a specialist, she asked for some additional detail if you could please add to ticket and post the case # here for me to pass on.

She asked for the raw request and response (omitting Trans Key) or the URL where we can repro. Also like to know what API Login ID to query to review the logs if they can provide this information as well that would be helpful.

Richard

Re: E00040 when Creating Subscription from Customer Profile

BrandonSurowiec — Wed, 26 Jul 2017 15:18:53 GMT

Ticket #1-427666651

I'll work on getting the information requested.

Re: E00040 when Creating Subscription from Customer Profile

CoreyC — Tue, 29 Aug 2017 22:04:12 GMT

This is now my 3rd time replying to this thread, not sure why my replies are being moderated...

I'm having the same issue in the sandbox. Steps:

1) createTransactionRequest with transactionType=authCaptureTransaction and createProfile=true

2) immedietly use customerProfileId in response from createTransactionRequest to call ARBCreateSubscriptionRequest

3) ARBCreateSubscriptionRequest returns E00040

If I sleep 20 seconds before step 3, it works.

Re: E00040 when Creating Subscription from Customer Profile

griffira59 — Wed, 30 Aug 2017 21:26:44 GMT

Richard,

Thanks for your response. I posted this message a few months ago and, unfortunately, continue to have the exact same problem. I'm using the CIM and ARB modules in the sandbox environment. The login ID is 7f74PwmmNCp . There has been active testing over the last two or more months using that login ID.

I basically created a wrapper for the AuthorizeNet PHP module. The two main functions involved have been pasted below. They were created by following the Authorize documentation.

The first function 'createCustomerProfileFromTxn' does basically just that; it takes a previously successful CC txn ID, then communicates with the sandbox to create an Authorize customer profile. Next, the function 'createSubscriptionFromAuthCustomer' communicates with the sanbox, sending the new customer profile ID and payment profile ID (and other required fields) which should result in the creation of an Authorize subscription.

However, I ALWAYS get the E00040 error code returned from the method that attempts to create the Subscription UNLESS I sleep() for a MINIMUM of 15 seconds AFTER creating the Customer Profile (which, by the way, always works without a hitch). I have even tried to destroy my wrapper object, then re-initializing and re-connecting between these method calls, to no avail.

We are hoping to be moving into production by October. I really hope this can be resolved by then, or, have you seen this same problem in production?

Thank You,

Ralph

/**
   * Description:
   * @author: Ralph Griffith, ralphgriffith59@gmail.com
   * @version: 1.0.0
   * @since: Feb 28, 2017
   * @Param string $x_trans_id (numeric string)
   * @Param integer $tboMerchantId
   * @Param string $genReqId
   * @return \net\authorize\api\contract\v1\AnetApiResponseType
   * see https://developer.authorize.net/api/reference/index.html#customer-profiles
   */
   public function createCustomerProfileFromTxn($x_trans_id, $tboMerchantAccountingId, $email, $genReqId) {
       $customerProfile = new CustomerProfileBaseType();
       $customerProfile->setMerchantCustomerId($tboMerchantAccountingId);
       $customerProfile->setEmail($email);
       $customerProfile->setDescription(authorizeGatewayController::AUTH_CUST_PROFILE_DESC);

       //request FNACP = request For New Auth Customer Profile
       $requestFNACP = new CreateCustomerProfileFromTransactionRequest();
       $requestFNACP->setMerchantAuthentication($this->merchantAuthentication);
       $requestFNACP->setTransId($x_trans_id); //The Auth supplied TXN Id
       //For tracking prposes, continue to mark requests with our $genReqId
       $requestFNACP->setRefId($genReqId);

       //Set the Profile Object
       $requestFNACP->setCustomer($customerProfile);
       $ccpController = new CreateCustomerProfileFromTransactionController($requestFNACP);
       return $ccpController->executeWithApiResponse($this::AUTH_API_ENV);
   }

AND:

    /**
   * Description:
   * @author: Ralph Griffith, ralphgriffith59@gmail.com
   * @version: 1.0.0
   * @since: Jun 9, 2017
   * @Param unknown $authCustProfileId
   * @Param unknown $authCustPaymentProfileId
   * @Param unknown $x_Invoice_Num
   * @Param unknown $subscriptionTitle
   * @Param unknown $numIntervalsBetweenPayments
   * @Param unknown $billingStartDate
   * @Param unknown $trialOccurrances
   * @Param unknown $totalOccurrances
   * @Param unknown $x_amount
   * @Param unknown $trialAmount
   * @Param unknown $genReqId
   * @return \net\authorize\api\contract\v1\AnetApiResponseType
   */
   public function createSubscriptionFromAuthCustomer($authCustProfileId, $authCustPaymentProfileId, $x_Invoice_Num, $subscriptionTitle,
           $numIntervalsBetweenPayments, $billingStartDate, $trialOccurrances, $totalOccurrances, $costPerInterval, $trialAmount, $genReqId) {

       $subscription = new ARBSubscriptionType();
       $subscription->setName($subscriptionTitle);

       $order = new OrderType();
       $order->setInvoiceNumber($x_Invoice_Num);
       $order->setDescription($subscriptionTitle);
       $subscription->setOrder($order);

       $interval = new IntervalAType();
       $interval->setLength($numIntervalsBetweenPayments); // Frequency of Billing Occurrences (every 3 months (Q), or 1 per month (M))
       $interval->setUnit('months'); // 'months', ALWAYS months in this revision (After SBL Pricing revised)

       $paymentSchedule = new PaymentScheduleType();
       $paymentSchedule->setInterval($interval);
       $paymentSchedule->setStartDate($billingStartDate);// == First billing date == Date the Trial Period ends
       // 9999 for recurring, otherwise 'Total Occurances' is just the number of payments within
       // the Subscription ie, 2 for Quarterly, 6 for Monthly
       $paymentSchedule->setTotalOccurrences($totalOccurrances);
       $paymentSchedule->setTrialOccurrences($trialOccurrances);

       $subscription->setPaymentSchedule($paymentSchedule);
       $subscription->setAmount($costPerInterval);
       $subscription->setTrialAmount($trialAmount); // Should always be set to $0

       $profile = new CustomerProfileIdType();
       $profile->setCustomerProfileId($authCustProfileId);
       $profile->setCustomerPaymentProfileId($authCustPaymentProfileId);

       $subscription->setProfile($profile);

       $request = new ARBCreateSubscriptionRequest();
       $request->setmerchantAuthentication($this->merchantAuthentication);
       $request->setRefId($genReqId);
       $request->setSubscription($subscription);
       $csController = new ARBCreateSubscriptionController($request);

       return $csController->executeWithApiResponse($this::AUTH_API_ENV);
   }

Re: E00040 when Creating Subscription from Customer Profile

RichardH — Wed, 30 Aug 2017 22:17:50 GMT

Hello @griffira59

The challenge here is both architecture and performance scale in our sandbox and not your code. Our production systems are scaled to process millions of requests per day, however our sandbox does not have the same scale.

Architecturally, when you create a customer profile from a transaction, the profile is created in real time. When you want to USE a customer profile, in your case to create a subscription, the request is serviced using replicated data to improve performance. As you've seen, you'll get an E00040 if replication has not completed in which case you must retry.

You should not have the same delay in production but we cannot guarantee there won't be some delay.

I know this doesn't answer your entire question, but we have communicated the challenge to our teams.

Richard

Re: E00040 when Creating Subscription from Customer Profile

griffira59 — Thu, 31 Aug 2017 19:39:56 GMT

Richard,

Thanks for the latest, prompt reply.

I was hoping that what you described, as far as sandbox infrastructure, was the root issue. As noted, we are comfortable with what, by all accounts, seems to be a very reasonable explanation. We will monitor this particular area when moved to production.

Again, thanks for your attention to this matter.

Ralph

Re: E00040 when Creating Subscription from Customer Profile

kankikara — Mon, 02 Oct 2017 21:08:32 GMT

Thanks for your response. I posted this message a few months ago and, unfortunately, continue to have the exact same problem. I'm using the CIM and ARB modules in the sandbox environment. The login ID is 7f74PwmmNCp. There has been active testing over the last two or more months using that login ID.

I basically created a wrapper for the AuthorizeNet PHP module. The two main functions involved have been pasted below. They were created by following the Authorize documentation.

Re: E00040 when Creating Subscription from Customer Profile

Aaron — Mon, 02 Oct 2017 21:11:10 GMT

Hi @kankikara,

I had to edit your post to remove some spam links. If those were placed intentionally, please don't do that. More likely, your system has been compromised by malware that's intercepting your post to include spam links. Please address that ASAP.

Once that's done, let us know if there's something else we can do to help on this issue. Have you already tried inserting a bit of delay as recommended elsewhere in this thread?