15.2 SOA Product Pricing error

 

This is wilth tech support as an SMR, but have not had a response in a few days.so  thought I would post here too incase anyone has had a similar problem and has suggestions.

 

Hello,

I am getting the following error when I try to get product pricing information using SOA calls.

The functionality is working fine on my development machine, but get this error when install on the client servers. I checked the product and there is member/nonmember pricing, the product looks similar to the set-up on the local machine that works.

I can add the product to the cart, but the pricing is zero, so leads me to believe the proper pricing is not being found that returns the null reference object.

Let me know what I else I can provide to get this web service call working.

Thanks Nick

CommerceManager.GetPartyItemPrice
Asi.Soa.Commerce.Persistence.V10.PartyItemPriceLinqDefinition.GetEntity()

Service Error:

An error has occurred while consuming this service. Please contact your administrator for more information. Error ID: e187ab14-3baf-48b2-8c6c-82e72c89bfe4
Timestamp: 3/27/2012 9:07:55 AM
Message Id: e187ab14-3baf-48b2-8c6c-82e72c89bfe4
An exception of type 'NullReferenceException' occurred
Type: NullReferenceException
Message: Object reference not set to an instance of an object.
Source: Asi.Soa.Commerce.Persistence.V10
Stack Trace: at Asi.Soa.Commerce.Persistence.V10.PartyItemPriceLinqDefinition.GetEntity() in c:\Builds\42\ScrumV3\15.2.0_Main15_Commit\Sources\imis.net\Packages\Soa\Asi.Soa\Asi.Soa.Commerce.Persistence.V10\LinqDefinitions\PartyItemPriceLinqDefinition.cs:line 274
at Asi.Soa.Core.Persistence.LinqPersistenceTranslator.PersistenceInstanceToEntity(Object persistenceInstance) in c:\Builds\42\ScrumV3\15.2.0_MainFoundation_Commit\Sources\imis.net\Packages\Soa\Asi.Soa\Asi.Soa.Core\Persistence\Linq\LinqPersistenceTranslator.cs:line 78
at Asi.Soa.Core.Persistence.LinqQuery.TranslateLinqQueryResultsToEntityIdentityMapList(Repository repository, ExtendedEntityDefinition extendedEntityDefinition, IQueryable queryable) in c:\Builds\42\ScrumV3\15.2.0_MainFoundation_Commit\Sources\imis.net\Packages\Soa\Asi.Soa\Asi.Soa.Core\Persistence\Linq\LinqQuery\LinqQuery.cs:line 104
at Asi.Soa.Core.Persistence.LinqQuery.ExecuteQuery(QueryData query) in c:\Builds\42\ScrumV3\15.2.0_MainFoundation_Commit\Sources\imis.net\Packages\Soa\Asi.Soa\Asi.Soa.Core\Persistence\Linq\LinqQuery\LinqQuery.cs:line 124
at Asi.Soa.Core.Persistence.LinqPersistenceStrategyBase.FindMatching(QueryData query) in c:\Builds\42\ScrumV3\15.2.0_MainFoundation_Commit\Sources\imis.net\Packages\Soa\Asi.Soa\Asi.Soa.Core\Persistence\BaseClasses\LinqPersistenceStrategyBase.cs:line 145
at Asi.Soa.Core.Domain.Repository.FindMatching(QueryData query) in c:\Builds\42\ScrumV3\15.2.0_MainFoundation_Commit\Sources\imis.net\Packages\Soa\Asi.Soa\Asi.Soa.Core\Domain\Repository\Repository.cs:line 416
at Asi.Soa.Core.Services.EntityService.Find(QueryData query) in c:\Builds\42\ScrumV3\15.2.0_MainFoundation_Commit\Sources\imis.net\Packages\Soa\Asi.Soa\Asi.Soa.Core\Services\EntityService.cs:line 223
at SyncInvokeFind(Object , Object[] , Object[] )
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage41(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage3(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage2(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage1(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ServiceModel.FaultException`1Asi.Soa.Core.DataContracts.Faults.ServiceFault, Asi.Soa.Core.Contracts, Version=100.0.1.122, Culture=neutral, PublicKeyToken=null: Service Error:

An error has occurred while consuming this service. Please contact your administrator for more information. Error ID: e187ab14-3baf-48b2-8c6c-82e72c89bfe4
Timestamp: 3/27/2012 9:07:55 AM
Message Id: e187ab14-3baf-48b2-8c6c-82e72c89bfe4
An exception of type 'NullReferenceException' occurred
Type: NullReferenceException
Message: Object reference not set to an instance of an object.
Source: Asi.Soa.Commerce.Persistence.V10
Stack Trace: at Asi.Soa.Commerce.Persistence.V10.PartyItemPriceLinqDefinition.GetEntity()

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Hmmm... looks like it's

Hmmm... looks like it's either having trouble mocking an order line for the SALES product or it can't find the price for the party. Try looking at the view vSoaPartyItemPrice to see if a price is listed for the partyId and ItemId you're trying to retrieve. This view is not 100% 1-for-1 what Soa uses for pricing, but it's a starting point.

Cheers,
Courtney

SOA Item Price Error

  

Hi - thanks for the information. I checked the ID and product I am testing with the view and seem to get the right results - below.

Anything else I can try? Stuck moving this customer project ahead unti I get passed this. 

Thanks Nick

SELECT

PartyId, ItemClass, ItemId, ItemPrice1, ItemPrice2, ItemPrice3

FROM

[vSoaPartyItemPrice]

where

PartyId

= '9034415'

and

ItemClass = 'SALES'

and

PartyId ItemClass ItemId ItemPrice1 ItemPrice2 ItemPrice3

ItemId = 'test01' 

---------- ---------- ------------------------------- --------------------- --------------------- ---------------------

9034415 SALES TEST01 5.00 10.00 0.00

(

1 row(s) affected)

 

SOA Item Price Error

 

Hello

Anymore thoughts on this?

This has stopped me dead in my tracks. I have been able to work on my local 15.2 that works fine, but the customer 15.2 gets this error.

They are supposed to start testing next week. I would hate to tell them the project is onhold indefinitely until this issue is solved, especially since I recommended upgrade to 15.2:-(

The product and category are set to sell on web.

If I can get that section of source code emailed to me I would try and debug further myself to keep this moving.

Thanks Nick

 

SOA Pricing Resolution

 

 

Hello,

I did get this resolve with tech support and wanted to share the answer for others.

To fix, go to Desktop > AR/Cash > Set up module > Aging button > Default Terms Code, set it to a value and the error goes away:-)