web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / POS 101 and 102 Uniden...
Microsoft Dynamics AX (Archived)

POS 101 and 102 Unidentified error when trying to save the transaction.

(1) ShareShare
ReportReport
Posted on by Community Member

When trying to save transaction in POS, POS showing 1001 and 1002 un identified error. This transaction has to connect HO server also.

Head office and Retail store Connectivity

HO(AX Server)->Retail Store Server(File is mounted in local server )-> Store Terminals (Terminals accessing the file from Local Server)

Below message is showing in Event Viewer.

1.Log Name: Application
Source: Dynamics AX Retail
Date: 08/09/2018 5:29:30 PM
Event ID: 1
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: OMRHI104
Description:
LSRetailPosis.POSProcesses.POSApp: System.InvalidOperationException: ExecuteScalar requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized.
at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at LSRetailPosis.POSProcesses.POSFormsManager.InvokePOSMainWindow(Delegate method, Object[] args)
at LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSErrorDialog(PosisException x)
at LSRetailPosis.POSProcesses.POSApp.ConcludeTransaction()
at LSRetailPosis.POSProcesses.POSApp.ResultCallback(PosTransaction clonedTransaction, OperationInfo operationInfo)
at LSRetailPosis.POSProcesses.POSApp.RunOperationInternal(PosisOperations operationID, Object extraInfo, OperationInfo operationInfo, PosTransaction newPosTransaction).
Event Xml:
<Event xmlns="schemas.microsoft.com/.../event">
<System>
<Provider Name="Dynamics AX Retail" />
<EventID Qualifiers="0">1</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2018-09-08T13:29:30.287487600Z" />
<EventRecordID>4506</EventRecordID>
<Channel>Application</Channel>
<Computer>xxxxxI104</Computer>
<Security />
</System>
<EventData>
<Data>LSRetailPosis.POSProcesses.POSApp: System.InvalidOperationException: ExecuteScalar requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized.
at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at LSRetailPosis.POSProcesses.POSFormsManager.InvokePOSMainWindow(Delegate method, Object[] args)
at LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSErrorDialog(PosisException x)
at LSRetailPosis.POSProcesses.POSApp.ConcludeTransaction()
at LSRetailPosis.POSProcesses.POSApp.ResultCallback(PosTransaction clonedTransaction, OperationInfo operationInfo)
at LSRetailPosis.POSProcesses.POSApp.RunOperationInternal(PosisOperations operationID, Object extraInfo, OperationInfo operationInfo, PosTransaction newPosTransaction).</Data>
</EventData>
</Event>

2.Log Name: Application
Source: Dynamics AX Retail
Date: 08/09/2018 5:29:30 PM
Event ID: 1
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: OMRHI104
Description:
LSRetailPosis.POSProcesses.POSApp: System.InvalidOperationException: ExecuteScalar requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized.
at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at LSRetailPosis.POSProcesses.POSFormsManager.InvokePOSMainWindow(Delegate method, Object[] args)
at LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSErrorDialog(PosisException x)
at LSRetailPosis.POSProcesses.POSApp.ConcludeTransaction()
at LSRetailPosis.POSProcesses.POSApp.ResultCallback(PosTransaction clonedTransaction, OperationInfo operationInfo)
at LSRetailPosis.POSProcesses.POSApp.RunOperationInternal(PosisOperations operationID, Object extraInfo, OperationInfo operationInfo, PosTransaction newPosTransaction).
Event Xml:
<Event xmlns="schemas.microsoft.com/.../event">
<System>
<Provider Name="Dynamics AX Retail" />
<EventID Qualifiers="0">1</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2018-09-08T13:29:30.287487600Z" />
<EventRecordID>4506</EventRecordID>
<Channel>Application</Channel>
<Computer>XXXX104</Computer>
<Security />
</System>
<EventData>
<Data>LSRetailPosis.POSProcesses.POSApp: System.InvalidOperationException: ExecuteScalar requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized.
at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at LSRetailPosis.POSProcesses.POSFormsManager.InvokePOSMainWindow(Delegate method, Object[] args)
at LSRetailPosis.POSProcesses.POSFormsManager.ShowPOSErrorDialog(PosisException x)
at LSRetailPosis.POSProcesses.POSApp.ConcludeTransaction()
at LSRetailPosis.POSProcesses.POSApp.ResultCallback(PosTransaction clonedTransaction, OperationInfo operationInfo)
at LSRetailPosis.POSProcesses.POSApp.RunOperationInternal(PosisOperations operationID, Object extraInfo, OperationInfo operationInfo, PosTransaction newPosTransaction).</Data>
</EventData>
</Event>

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Rodolfo Recalde Profile Picture
    Rodolfo Recalde on at

    Hi,

    Go to  C:\Program Files (x86)\Microsoft Dynamics AX\60\Retail POS

    Make a backup of the file POS.exe.config file and change the property switchValue for the following section:

    ***

      <system.diagnostics>
        <sources>
          <!-- this registers the listener with traces from a specific source -->
          <source name="RetailNetTracer" switchValue="All">
            <listeners>
              <add name="RollingXmlWriterTraceListener" />
            </listeners>
          </source>
          <source name="RetailNetTracerEventLog" switchValue="All">
            <listeners>
              <add name="EventLogTraceListener" />
            </listeners>
          </source>
          <!-- The below source and listener are required for Retail monitoring to function correctly. Please do not modify either. -->
          <source name="RetailMonitoringTracer" switchValue="All">
            <listeners>
              <add name="MonitoringEventLogTraceListener" />
            </listeners>
          </source>
        </sources>
        <!-- this defines a listener -->

    ...

    ***

    This way you can have more details about the error in the event viewer and some clue to the solution.

  • Community Member Profile Picture
    Community Member on at

    Thank you for knowledgeable answer.  

  • Community Member Profile Picture
    Community Member on at

    Below mentioned details i got from log file,

    Message : UPDATE RETAILTRANSACTIONTABLE SET CUSTOMERORDER='' , GOLDFIXING=1,ISGSS=1 WHERE TRANSACTIONID='0000008001' AND TERMINAL = 'QMDLC102';

     

    UPDATE RETAILTEMPTABLE SET TRANSID=NULL,CUSTID=NULL,CUSTORDER=NULL,GOLDFIXING=NULL,ITEMRETURN='False',MINIMUMDEPOSITFORCUSTORDER=NULL WHERE ID IN (1,2) AND TERMINALID = 'QMDLC102' 

     

    DECLARE @INVENTLOCATION VARCHAR(20)

    DECLARE @CONFIGID VARCHAR(20) 

    DECLARE @RATE numeric(28, 3) 

     

    SELECT @INVENTLOCATION=RETAILCHANNELTABLE.INVENTLOCATION FROM         RETAILCHANNELTABLE

    INNER JOIN  RETAILSTORETABLE ON RETAILCHANNELTABLE.RECID = RETAILSTORETABLE.RECID 

    WHERE RETAILSTORETABLE.STORENUMBER='QMDLC'

     

    SELECT top 1 @CONFIGID = [GSSDefaultConfigIdGold] from RETAILPARAMETERS WHERE DATAAREAID='131' 

     

    SELECT TOP 1 @RATE=RATES FROM METALRATES WHERE INVENTLOCATIONID=@INVENTLOCATION   AND METALTYPE=1 AND ACTIVE=1 and RETAIL=1  AND CONFIGIDSTANDARD=@CONFIGID  AND RATETYPE=3  ORDER BY DATEADD(second, [TIME], [TRANSDATE]) DESC;

     

    INSERT INTO [DEPOSIT_GOLD_DETAILS]  ([ADVANCEID],[ORDERID],[CUSTACCOUNT],[PURCQTY],[AMOUNT],[STOREID]  ,[TERMINALID],[STAFFID],[DATAAREAID],[CREATEDON])  VALUES  ('0000008001',  '',  '131-CUS-000018814',  ISNULL(200/@RATE,0),  200 , 'QMDLC',  'QMDLC102', '133331', '131',  GETDATE());

     

    INSERT INTO [RETAILDEPOSITTABLE]  ([TRANSACTIONID],[CUSTACCOUNT],[ORDERNUM],[AMOUNT],[GOLDQUANTITY],[GOLDFIXING],[RATE]  ,[DEPOSITTYPE],[STOREID],[TERMINALID],[STAFFID],[DATAAREAID],[CREATEDON] ,[GSSNUMBER],[NOOFMONTHS] ,FIXEDCONFIGID,ManualBookedQty,BookePct,ProductType,TAXPERCENTAGE,TAXAMOUNT )  VALUES  ('0000008001'  ,'131-CUS-000018814'  ,''  ,200  , ISNULL(200/@RATE,0)  ,1  ,isnull(@RATE,0)  ,0  ,'QMDLC'  ,'QMDLC102'  ,'133331'  ,'131'  ,GETDATE() ,'131-000002712' ,1 ,'22K','0' ,'0' ,'' ,'0.00' ,'0');

     

    UPDATE RETAILTRANSACTIONTABLE SET ADVANCESALESMANID ='991503' where TRANSACTIONID='0000008001' and TERMINAL='QMDLC102' and STORE='QMDLC'

     

    UPDATE RETAILTRANSACTIONTABLE SET GOLDFIXING =1 where TRANSACTIONID='0000008001' and TERMINAL='QMDLC102' and STORE='QMDLC' ; Test Value 11

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans