Microsoft Dynamics AX (Archived)

Retail Parameter Initialization Error

(0) Share

Report

Posted on by YasserMahmoud

270

I have an AX 2012 environment that contains:

AX 2012 R3 CU10 installed
SQL Server 2014 Stranded Edition as database server

when i tried to initialize retail parameter (Retail > Setup > Parameters > Retail Parameters > 'Initialize' button ), i get the below error:

Error Message (04:16:14 pm) System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.ArgumentNullException: Value cannot be null.
Parameter name: axPrimaryKeyColumnName
at Microsoft.Dynamics.Retail.SynchLibrary.CodeGen.DataDistributionNode.AddAXPrimaryKeyColumnName(String axPrimaryKeyColumnName)
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.Dynamics.AX.ManagedInterop.ClrBridgeImpl.InvokeClrInstanceMethod(ClrBridgeImpl* , ObjectWrapper* objectWrapper, Char* pszMethodName, Int32 argsLength, ObjectWrapper** arguments, Boolean* argsAreByRef, Boolean* isException)

If i double-click the error in Infolog window, it open 'generate' method in RetailCDXCodeGen Class.

Please can any one help me on that?

Thanks in advance

*This post is locked for comments

I have the same question (0)

All responses (21)

Answers (1)

Rodolfo Recalde on at

Like (0)

Report

RE: AX 2012 R3 CU10 - Retail Parameter Initialization Error

Hi Yasser,

a. Make sure the Retail Headquarters component (and CUs and KBs related) is installed.

b. If your environment was migrated, or have customizations in some tables related to retail, perhaps, you must include a primary key in referenced tables in the error log. ("axPrimaryKeyColumnName").

I Hope this Helps!

Regards,

Rodolfo Recalde.

Was this reply helpful? Yes No
YasserMahmoud 270 on at

Like (0)

Report

RE: AX 2012 R3 CU10 - Retail Parameter Initialization Error

Hi Rodolfo,

thanks for your replay

What you are mean with CUs and KBs related is installed.

Our technical install RTM version with only CU10 as streamslip installation.

After that i checked one of the initializing retail tables, MARKUPAUTOLINE, and found as below:

in database, no primary key for that table but in AOT there is a Primary Index with 3 available fields.

Thanks in advance

Best Regards,

Yasser Mahmoud

Was this reply helpful? Yes No
Rodolfo Recalde on at

Like (0)

Report

RE: AX 2012 R3 CU10 - Retail Parameter Initialization Error

The Retail Initialize process will indicates which tables require primary index

After identifying them, include a primary index.

Make sure the if Index properties to: AllowDuplicates> No | Enabled> Yes

I Hope this Helps!

Regards,

Rodolfo Recalde

Was this reply helpful? Yes No
YasserMahmoud 270 on at

Like (1)

Report

RE: AX 2012 R3 CU10 - Retail Parameter Initialization Error

Hi Rodolfo,

Yes i know that and the table, , is one of the tables that Retail Initialize it.

I debug the process and found it from big list may be 127 table.

and i checked table index properties as below:

Thanks for your help

Best Regards,

Yasser Mahmoud

Was this reply helpful? Yes No
Rodolfo Recalde on at

Like (0)

Report

RE: AX 2012 R3 CU10 - Retail Parameter Initialization Error

OK!

You're still in error to retail inicialize ? If yes, try to synchronize full your AX-DB.

Regards,

Rodolfo Recalde.

Was this reply helpful? Yes No
YasserMahmoud 270 on at

Like (0)

Report

RE: AX 2012 R3 CU10 - Retail Parameter Initialization Error

Unfortunately, YES

I tried for the table only and for all ax database many times.

Regards,

Yasser Mahmoud

Was this reply helpful? Yes No
Rodolfo Recalde on at

Like (0)

Report

RE: AX 2012 R3 CU10 - Retail Parameter Initialization Error

Just as attempted solution, please, you could try to do the following:

Retail > Setup > Retail Scheduler Retail Channel Schema (Form) > Select your AX Version >
click "Generate Classes" Button

I Hope this Helps!

Regards,

Rodolfo Recalde.

Was this reply helpful? Yes No
malioni91 50 on at

Like (0)

Report

RE: AX 2012 R3 CU10 - Retail Parameter Initialization Error

Hi guys! I have the exact same error... does anyone know how to solve it? I have tried Rodolfo's suggestion, but I still get the same error when I run the initialize step.

Was this reply helpful? Yes No
Hitesh Manglani 312 on at

Like (0)

Report

RE: Retail Parameter Initialization Error

Have you tried generating Incremental CIL if you get any errors on doing so then you need to execute following steps.

step1) First Stop the AOS.

step2) Delete all of the source in the C:\Program Files\Microsoft Dynamics AX\60\Server\MicrosoftDynamicsAX\bin\XppIL directory.

step3) Start the AOS.

step4) Perform a Full CIL.

step5) Perform a Incremental CIL

Was this reply helpful? Yes No
malioni91 50 on at

Like (2)

Report

RE: Retail Parameter Initialization Error

Hi. I figured out the issue. For me it was that the company was not properly created. Hence, before installing the Retail Component, make sure to have the company's financials properly setup by the functional team. Once the financials were configured, it went through fine.

Regards,

Malion

Was this reply helpful? Yes No